DW SQL End of Statement Error

[Bkster]

I have two tables in oracle that I need to query. Here is the problem. I build the SQL Query in Crystal Reports. I then copy the SQL code to the record set. When I am building the record set and test it I get the expected results. When I try and display the information on the web page I get
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/offsite/TMPd6rbl5kgz9.asp, line 10, column 42

and line 10 is the SQL code

SELECT PA_STUDENT."STUD_ID", PA_STUDENT."LNAME", PA_STUDENT."FNAME",PA_STUD_PSWD."STUD_PSWD" FROM "PLATEAU"."PA_STUDENT"PA_STUDENT,
"PLATEAU"."PA_STUD_PSWD" PA_STUD_PSWD
WHERE PA_STUDENT."STUD_ID" = PA_STUD_PSWD."STUD_ID" AND PA_STUDENT."STUD_ID" = '06272'

Any ideas

Thanks
Brian

 

[schase]

did you check this out?

http://www.macromedia.com/support/ultradev/ts/documents/error_800a0401.htm

"Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[Bkster]

Thanks Stuart I figured it out. It needed double "" around the field names.

Brian