Re: [ cf-dev ] dramatic problem with query of query

[EWS]

Date format has long been a problem with all scripting language. In my 
experience and research the only sure fire way to format dates and have 
any database understand it without any risk of ambiguity (which is what 
causes most DB's to report errors and die) is the following format 
dd-mmm-yyyy for example 19-Jan-2004 so now if your DB stores american 
format dates it will store 01/19/04 whereas normal (sorry, UK) dates are 
stored 19/01/2004. No ambiguity at all.

It works in every instance that I have ever used it and negates the needs 
to set up any 'locale' variables.

Regards

Ellis C Wood
Ellwood Web Solutions
On Mon, 19 Jan 2004 00:36:26 +0000, Dave Phipps <[EMAIL PROTECTED]> 
wrote:

Try changing the DateFormat function to have a mask of 'yyyy-mm-dd'.  It 
could be the db driver for MX 6.1 was upgraded and requires the db date 
and your supplied date to match.

Hope this helps.

Cheers

Dave

On Sat, 17 Jan 2004 12:11:46 +0100
  "ing. fusto" <[EMAIL PROTECTED]> wrote:
Hello, i have a problem: the following query of query
<cfquery name="assenti" dbtype="query">
     SELECT * FROM assenze_mensili
     WHERE assenze_mensili.data=<cfqueryparam
cfsqltype="CF_SQL_DATE"

value="#DateFormat(parsedateTime(ret_data),'dd/mm/yyyy')#">
</cfquery>
until last december, when my provider was using cfmx 6.0, was ok; the he
upgraded to cf mx 6.1 and now all pages containing a query of query 
fail,
reporting an error of unsupported type comparison.
any idea.
best regards
salvatore

-- ** Archive: 
http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]




--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]