[azwani]

I'm a new learner of JScript.can anyone give me source code how to retrieve data from database using JScript + asp.It's a bit different from VBScript right..

[Shane]

Originally Posted by azwani

I'm a new learner of JScript.can anyone give me source code how to retrieve data from database using JScript + asp.It's a bit different from VBScript right..

Same code, different syntax.

www.coveryourasp.com has code in jscript.

[azwani]

this is my source code -->

// connect to database
conn = Server.CreateObject("ADODB.Connection");
conn.Open("DSN=metadata;UID=;PWD=");



Obrs = objConn.Execute ("Select linkxml From metatag " &_
"Where Discipline='"& "disp &"'" &_
"And Author='"& author &"'");

and this the error i've got -->

Error Type:
Microsoft JScript compilation (0x800A03EE)
Expected ')'
/LOM/mainmenu.asp, line 32
"Where Discipline='"& "disp &"'" &_


i'm used to VBScript but not JScript

[Shane]

Originally Posted by azwani

this is my source code -->

// connect to database
conn = Server.CreateObject("ADODB.Connection");
conn.Open("DSN=metadata;UID=;PWD=");



Obrs = objConn.Execute ("Select linkxml From metatag " &_
"Where Discipline='"& "disp &"'" &_
"And Author='"& author &"'");

and this the error i've got -->

Error Type:
Microsoft JScript compilation (0x800A03EE)
Expected ')'
/LOM/mainmenu.asp, line 32
"Where Discipline='"& "disp &"'" &_


i'm used to VBScript but not JScript

Make everything one line (I'm not sure if you can use the _ is jscript). Also, replace the & with a + .