Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Update DB with SQL

  		Logged in as: Guest
arrSession:exec spGetSession 2,3,32
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> ASP >> Update DB with SQL
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Update DB with SQL - 5/23/2001 6:45:00 AM   
  Therarez

 

Posts: 12
Score: 0
Joined: 5/22/2001
From: Mexico
Status: offline 		Maybe I am missing something.

I need to update a database using a SQL statement made up from passed information and such. Making the SQL statement was fun, but I need my asp page to just go ahead and update the database without further intervention???

Any one got any ideas??


I dont want to go to Chelsea!!!
 
 
Post #: 1
 
Re: Update DB with SQL - 5/23/2001 6:47:25 AM   
  adminkoe

 

Posts: 117
Score: 0
Joined: 12/23/2000
From:
Status: offline 		Hi Cheech,

using SQL is easy...


strSQL = " * from table where [Criteria] = something"
' to place a record in the DB use "Insert into table where values = something"

'set the connection and open that DB for the query
set objRS = server.createobject("adodb.recordset")

objRS.open strSQL, "data connection info"

hope this helps...

(in reply to Therarez)
 
 
Post #: 2
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> ASP >> Update DB with SQL Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI