Trouble inserting date into database

[cshow365]

The date format in the form being submitted is mm/dd/yyyy.
Below is the error I'm getting.
Any help would make me really happy!
Thanks

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 2.

Error occurs in line 42

40 : '#Trim(FORM.Frequency)#',
41 : #FORM.FrequencyUnitsID#,
42 : #CreateODBCDate(FORM.DateTaken)#)
43 : </cfquery>
:o

[mxstu]

Can you post the query code and the actual sql statement sent to the database from the error message (it contains the actual values submitted).

[cshow365]

Here it is!

<cfquery datasource="#APPLICATION.dataSource#">
INSERT INTO Drugs(UserID,
DrugName,
Dose,
DoseUnits,
Frequency,
FrequencyUnitsID,
DateTaken)
VALUES(#SESSION.auth.UserID#,
#FORM.DrugName#,
'#Trim(FORM.Dose)#',
#FORM.DoseUnits#,
'#Trim(FORM.Frequency)#',
#FORM.FrequencyUnitsID#,
#CreateODBCDate(DateTaken)#)
</cfquery>




Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 2.

The error occurred in C:\CFusionMX7\wwwroot\Project
Alpha\drugs091805\drug_insert1.cfm: line 42

40 : '#Trim(FORM.Frequency)#',
41 : #FORM.FrequencyUnitsID#,
42 : #CreateODBCDate(DateTaken)#)
43 : </cfquery>
44 :


--------------------------------------------------------------------------------

SQL INSERT INTO Drugs(UserID, DrugName, Dose, DoseUnits, Frequency,
FrequencyUnitsID, DateTaken) VALUES(3, DRUG1, '2', mg, '2', 1, {d
'2005-09-18'})
DATASOURCE Drugs
VENDORERRORCODE -3010
SQLSTATE 07002

[mxstu]

I don't think the problem is the date. I think you are just missing single
quotes around some of the form values. If you are inserting into a "text"
column, you must use single quotes. If it is a "numeric" column then you do
not need single quotes.

VALUES(3, DRUG1, '2', mg, '2', 1, {d '2005-09-18'})

[cshow365]

A million times thank you!