Hello George,
<cfset newdate = Now()>
is just as sufficient as it can get...
WHERE date = newdate
should work then...
I am hesitating, 'cause 'date' is possibly a reserved word either
in CF or in SQL. Somebody help me out here:-))
Birgit
Wednesday, April 19, 2000, 5:32:39 PM, you wrote:
> 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.
------------------------------------------------------------------------------
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.
