December 10th, 2002, 02:20 PM
|
 |
Charge into the Knight
|
|
Join Date: Jan 2002
Location: Orlando, FL
Posts: 276
Time spent in forums: < 1 sec
Reputation Power: 12
|
|
Querying Access gives me an Syntax error...please help
Here is my sql statement and error message:
PHP Code:
SELECT * FROM materials LEFT OUTER JOIN scndry_authors ON
materials.mat_rec_id=scndry_authors.mat_rec_id WHERE
materials.245_title_statement ='STUDY GUIDE TO ACCOMPANY
BIOLOGY.'
Warning: Invoke() failed: Exception occurred. Source: Microsoft
OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC
Microsoft Access Driver] Syntax error in query
expression 'materials.245_title_statement ='STUDY GUIDE TO
ACCOMPANY BIOLOGY.''. in
C:\tent\wwwroot\test\archives_catalog\result.php on line 71
Can I have a field name start with a number?
__________________
Every man is a fool for at least five minutes every day; wisdom consists of not exceeding the limit.-- Elbert Hubbard
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
