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-
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
