Create ODBC Date

[hevychevy1996]

I created an online application submitting to itself. I have the code below for the beginning of my cfquery: I am having a problem with the date. app_date is the date field i am using. When i test it out i receive error executing database query. N E ideas?
Thanks in advance

#CreateODBCDate(FORM.app_date)

 

[hevychevy1996]

here is what i receive

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver][mysqld-4.1.3-beta-max]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 

The error occurred in C:\Inetpub\

http://wwwroot\vpn\emp_app\emp_app.cfm:

line 182

180 : '#FORM.specialty#',
181 : '#FORM.date_entered#',
182 : '#FORM.discharge_date#')
183 : </cfquery>
184 : <cfmail subject="A new application has been submitted" from="admin@company.net" to="hr@company.net" type="html">

 

[hevychevy1996]

I see i haven't got any responses. Is there any other type of coding I can use instead of create ODBC ? Please let me know

-Thanks in advance

 

[TruthInSatire]

i'll look for some of my mySql inserts when i get home and post the syntax i used to insert the dates.

If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer. Asking questions is the ABC of diagnosis. Only the inquiring mind solves problems.

-Quote by Edward Hodnett

 

[hevychevy1996]

hey bombboy just checking up to see if you found any sqlinserts yet?
what about cfqueryparam is that an option as well?

-Thanks in advance