|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 25th, 2003, 05:25 AM
|
|||
|
|||
|
Urgent Syntax Error help help help
Hi Friends i have following statement
RS.Open "SELECT job_apply.job_apply_id, job_apply.job_id, job_apply.resume_id, job_apply.job_apply_date, job_apply.empl_id, job.job_job FROM job INNER JOIN job_apply ON job.job_id = job_apply.job_id WHERE resume_ID=" & (request("resumeid"))& "Order by job_apply_date", Con It is giving this error Syntax error (missing operator) in query expression 'resume_ID=1Order by job_apply_date'. I am missing something, please help me.......
|
|
#2
August 25th, 2003, 10:20 AM
|
||||
|
||||
|
It looks like you have no space before the ORDER BY clause:
& "Order by job_apply_date", Con Change to: & " Order by job_apply_date", Con Hope that helps!
|
|
| Viewing: ASP Free Forums > Database > SQL Development > Urgent Syntax Error help help help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
