Ok, I thought I had the jist of this but. no...
I am doing a query on a table that has a date field.
Here is the code:
<CFSET NewDate=CreateODBCDate(#dateformat(Now(),"mm/dd/yy")#)>
<CFQUERY NAME="myquery" DATASOURCE="mydb">
select field_1,field_2
FROM mytable
where date = #newdate#
</CFQUERY>
I get the ole' "[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
" error on this. Am I not using the CreatODBCdate properly?
Thanks
George Loch
Stephen Hales Creative
[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
