Copy link to clipboard
Copied
quote:...
Originally posted by: Newsgroup User
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
> Access Driver] Syntax error (missing operator) in query expression ''{d
> '2007-04-13'}''.
it seems the error is with your eventDate. in MS Access, dates should be
entered as ###date### (where date is an actual date, in m/d/yyyy format,
or d/m/yyyy, depending on locale settings in the database). but there
should be 3 # on both sides of t
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: Newsgroup User
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
> Access Driver] Syntax error (missing operator) in query expression ''{d
> '2007-04-13'}''.
it seems the error is with your eventDate. in MS Access, dates should be
entered as ###date### (where date is an actual date, in m/d/yyyy format,
or d/m/yyyy, depending on locale settings in the database). but there
should be 3 # on both sides of the date and no '.
so try changing your SEEevents.eventDate='#form.eventDate#' to
SEEevents.eventDate=###form.eventDate###.
if that still throws an error, you will have to parse your date form
field and make a date in MS Access format from it first, i.e. before
your <cfquery> add <cfset eDate = DateFormat(form.eventDate,
"mm/dd/yyyy")> and then use that in your query:
SEEevents.eventDate=###eDate###
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied