Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connecting to SQL Server from Server side JavaScript
- Thread starter lakshman
- Start date
heres an example with comments:
//get parameters
queryvar = Request.QueryString("someparam"
;
//make connection
aconn = Server.CreateObject('ADODB.connection');
aconn.Open("DSN=ACUSQL_SBC;UID=sbc;PWD=sbc;"
//define query and execute
sqlbeg = "SELECT * FROM sbc WHERE code='"+queryvar+"'";
recset = aconn.Execute(sqlbeg);
now your records are stored in recset and can be accessed like recset("fieldname" jared@aauser.com
//get parameters
queryvar = Request.QueryString("someparam"
;//make connection
aconn = Server.CreateObject('ADODB.connection');
aconn.Open("DSN=ACUSQL_SBC;UID=sbc;PWD=sbc;"
;//define query and execute
sqlbeg = "SELECT * FROM sbc WHERE code='"+queryvar+"'";
recset = aconn.Execute(sqlbeg);
now your records are stored in recset and can be accessed like recset("fieldname"
jared@aauser.com- Status
Similar threads
- Question