Microsoft VBScript compilation (0x800A03EA)

treasacrowe · August 20th, 2004, 08:28 AM

Hi i am trying to select records from a database using the following syntax, before i put in the order by part it works no problem, can anyone see my problem? thanks

SQL = "Select * FROM MainTable WHERE Company LIKE '" & ("%") & request("Company") & ("%") &"' AND Device LIKE '" & ("%") & request("Part") & ("%") &"' AND Division LIKE '" & ("%") & request("Strategy") & ("%") &"' ORDER BY '" & ("%") & request("orderby") & ("%") &'" ASC"
set RS = dbconn.execute(SQL)

happygv · August 20th, 2004, 08:48 AM

Use this...

Code:

SQL = "Select * FROM MainTable WHERE Company LIKE '%" & request("Company") & "%' AND Device LIKE '%" & request("Part") &"%' AND Division LIKE '%" & request("Strategy") & "%' ORDER BY " & request("orderby") & " ASC"

Cheers!

_________________________
- Vijay G
Strive for Perfection

treasacrowe · August 20th, 2004, 08:54 AM

hi thanks for your help, i tried this and now i am getting the error
0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.
Any ideas?

happygv · August 20th, 2004, 09:08 AM

Looks like you are missing the COLUMNNAME after order by and beofer ASC.

Code:

SQL=...
Response.write SQL
Response.end
set RS = dbconn.execute(SQL)

Try the code in blue and post the resulting sql statement here. Will have a look at it.

_________________________
- Vijay G
Strive for Perfection

treasacrowe · August 20th, 2004, 09:51 AM

Thanks a million, it does look like i'm missing the columnname alright, i'll use get instead of post to see if the columname is being sent properly....

Select * FROM MainTable WHERE Company LIKE '%%' AND Device LIKE '%%' AND Division LIKE '%DAC%' ORDER BY ASC

treasacrowe · August 20th, 2004, 09:54 AM

thanks very much, i wasn't sending the column name correctly! it works perfectly now!

happygv · August 20th, 2004, 10:00 AM

Glad that it works. Now you can remove off these two lines of code.

Response.write SQL
Response.end

Cheers!

_________________________
- Vijay G
Strive for Perfection

stephens1982 · March 29th, 2007, 10:53 PM

Hi I am trying to connect to a database and I am getting this error below:

Microsoft VBScript compilation (0x800A03EA)
Syntax error

/X/join.asp, line 13, column 61
connObj.Open("DRIVER={Microsoft Access Driver(*.mdb)};DBQ=" &
------------------------------------------------------------^

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

Page:
POST 183 bytes to /X/join.asp

The Line that it is refering to is this:

Dim connObj,strSQL,cmdObj,strSQL2,cmdObj2,strSQL3,cmdO bj3

Dim AddName,AddEmail,AddMailing
Dim AddConfirm,AddCreditcard,AddNamecd,AddExpiredate,A ddTypesrvc,CardNumber
Dim AddUsername,AddPassword

Set connObj = Server.CreateObject("ADODB.Connection")
connObj.Open("DRIVER={Microsoft Access Driver(*.mdb)};DBQ=" &
Server.MapPath("CyberX.mdb"))

:(