|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 5th, 2007, 04:02 PM
|
|||
|
|||
Problem with "Syntax error in FROM clause. "
I'm getting this error code:
Microsoft JET Database Engine error '80040e14' Syntax error in FROM clause. /lift_trucks/default.asp, line 50 Here is the code: SQL="select OLE_Object from Table where id=" & ("OLE_Object") & _ "select post_id,email ,post_date ,equip_type ,manu ,year_made ,model_num ,serial_num ,odo_read ,hour_read ,attach_type ,capacity ,price, post_body, " & _ "from posts " & _ " order by post_date desc" objrs.open sql,objconn,1,2 <------ line 50 if not objrs.eof then objRS.PageSize=10 totcount=objrs.recordcount reccount=10 objRS.AbsolutePage=iPage Does anyone know what I need to do to fix this? I've tried brackets on the name, etc ... (URL address blocked: See forum rules)=newthread&f=33#
|
|
#2
March 5th, 2007, 04:05 PM
|
||||
|
||||
|
you have a comma before the word FROM
Code:
post_body, " & _ "from posts " & _
__________________
Come JOIN the party!!! Quote of the Month: Risks: If you never try anything new, you'll miss out on many of life's great disappointments. Questions to Ponder: Is there another word for synonym? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright© 2008 sbenj69
|
|
#3
March 5th, 2007, 05:20 PM
|
|||
|
|||
|
Quote:
I removed the comma, but I'm still having the same problem ... 
|
|
| Viewing: ASP Free Forums > Other > Programming Help > Problem with "Syntax error in FROM clause. " |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
