View Single Post
  #2 (permalink)  
Old August 20th, 2003, 12:09 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

Take a look at this page that deals with this specific error type.

I am not 100% sure, but it may be caused by the fact that you use Yes as a WHERE clause value. If I am nit mistaken, changing it to True might solve the problem.

Otherwise, if Post is a Text type column, use ' to delimit the value:

Code:
mySQL = "SELECT * FROM SignIn WHERE Post = 'yes' ORDER BY ID DESC"
HtH

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.