SQL Error

[larryman]

Please,

Can anyone help figure out the source of error in the SQL statement below. I keep getting this error.

Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.


strSQL = "SELECT AirOrder.Passenger_No," _
& "AirOrder.Date, AirOrder.Department, AirOrder.[E-mail_Address]," _
& "AirOrder.Purpose_Travel, AirOrder.Way, AirOrder.Depart," _
& "AirOrder.Departure_Date, AirOrder.Departure_Time, AirOrder.Destination," _
& "AirOrder.Return_Date, AirOrder.Return_Time, AirOrder.Approval_Email," _
& "airbooking.Name, airbooking.OrderNo FROM AirOrder INNER JOIN airbooking ON" _
& "AirOrder.OrderId = airbooking.OrderNo Where airbooking.OrderNo = "& Request.QueryString("OrderId&quot&""

Set rs = dcnDB.Execute(strSQL)


Oysterbar ride to success. Keep Riding

 

[vbkris]

before executing do a response.write and post the output:
response.write strSQL
Set rs = dcnDB.Execute(strSQL)

Known is handfull, Unknown is worldfull

 

[adroit]

Make sure that there is a space between the Fieldnames and SQL Clauses.

Check it with

Response.Write strSQL

then copy/paste and run it directly in the SQL Query Analyzer or access (what ever DB are you using)

---Error Source---
& "airbooking.Name, airbooking.OrderNo FROM AirOrder INNER JOIN airbooking ON" _
& "AirOrder.OrderId = airbooking.OrderNo Where Request.QueryString("OrderId&quot&""
--------------
Inster a space after ON or before the AirOrder in the next line.

I hope this will help.

 

[larryman]

Adroit,

Thanks, it's working with the space recommended.

vbkris, Thanks too.

Larryman

Oysterbar ride to success. Keep Riding