You can't have a reserved SQL word as the name of a column and refer to it
like a normal column. In your query, you have from= '#from#'. FROM is a
reserved word. You will need to change the name of the column, or put ""
around it to let the database know what you are trying to do. This is in
Sybase, but I assume it's the same for Access
"from" = '#from#'
Todd Ashworth
----- Original Message -----
From: "Jeremy Toevs" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 2:37 PM
Subject: Update Error 2
Before I even had the valid field in my query I was receiving that error.
And I also tried the valid without the ' '. So I am still stumped.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
