Re: simple createODBCdate question

Date is definitely a reserved word in Access, and will throw errors. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706

simple createODBCdate question

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

Re: simple createODBCdate question

Here is the code: CFSET NewDate=CreateODBCDate(#dateformat(Now(),"mm/dd/yy")#) Should be cfset NewDate = #CreateODBCDate(Now())# Pound signs always go on the outside, any text not escaped (inside single or double quotes) insides the pound signs are interpreted as variables. And creating a

RE: simple createODBCdate question

Hmmm... I get the same error -Original Message- From: Judah McAuley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 19, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Re: simple createODBCdate question Here is the code: CFSET NewDate=CreateODBCDate(#dateformat(Now(),"mm/

Re: simple createODBCdate question

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:

RE: simple createODBCdate question

19, 2000 5:23 PM To: George Loch Subject: Re: simple createODBCdate question 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

Re: simple createODBCdate question

in this case, the pound signs really aren't even necessary because you're already in a cfset statement. i think the recommendation is to not use them inside of cf tags because you're "over-coding". try: cfset NewDate = CreateODBCDate(Now()) -emily CFSET