> I never had much luck with #CreateODBCDate(***)#
> because it appends
> these brackets { t ' '} and MsSQL7 and Access
> freak out!! So I just did something like the above for a
> quick workaround and never got around asking how you correctly
> use the ODBCDate functions. I guess now is as good a time as
> ever, anyone????
ODBC date and time formats use the curly brackets you mention above. To
reference values in ODBC date/time format in your CFQUERY tags, just leave
off the single quotes that you'd use for strings.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.
