Don't think cfquery can recognise that as a date you need to put it in a variable or call it inside the query
SELECT * FROM crossref_email WHERE crsref_email = '#URL.eml#' AND crsref_date_created = #CreateODBCDateTime(CreateDateTime(2002, 04, 17, 0, 0, 0))# -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 20:16 To: CF-Talk Subject: <CF_DateTime_Query> help HELP! I'm trying to match an e-mail address with the exact date and time the record was created as a unique identifier. I'm trying to use the following ODBC value in the this query to extract a unique row. SELECT * FROM crossref_email WHERE crsref_email = '#URL.eml#' AND crsref_date_created = {ts '2002-05-01 2:31:32'} The date value stored in the tablecolumn is ... 5/1/2002 2:31:32 PM How would I write this query so that the query checks both the date and time for a match? Thanks D- > My guess is that it's sending the whole variable as alist just to the first > parameter, you'd need to split the values out. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 02 May 2002 17:06 > To: CF-Talk > Subject: <CF_CreateODBCDateTime_DUH!> > > > Ok, > > I need a second pair of eyes here. > > THIS WORKS ... > > <CFSET myDate = #CreateDateTime(2002,05,01,14,31,32)#> > <cfoutput>#CreateODBCDateTime(mydate)#</cfoutput> > > WHY DOESN'T THIS WORK? > > where the URL value is ?test=2002,05,01,14,31,32<br> > > <CFSET myDate = #CreateDateTime(url.test)#> > <cfoutput>#CreateODBCDateTime(mydate)#</cfoutput> > > WHAT AM I DOIGN WRONG HERE? > > THANKS! > > D- > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
