- see footer for list info -<
Similar problem to Roger Broadhurst 's posting on 23/03/2006
the date is being entered into the access
database as the result of a calculation. eg for
yesterday instead of 27/03/2005 is calculates 27
devided by 3 devided by 2005 = 31/12/1899
12:00:00 in a date field or 1.5 in a number field.
there are no sql errors. the string looks like this:
q_addCurrency (Datasource=araxi, Time=0ms,
Records=0) in
C:\CFusionMX7\wwwroot\ARAXI_DEV\wwwroot\dsp_home_cover_french.cfm
@ 08:34:29.029
INSERT INTO tblDailyRates
(CurrencyRateDate,USD,JPY,CYP,CZK,DKK,EEK,GBP,HUF,LTL,LVL,MTL,PLN,SEK,SIT,SKK,CHF,ISK,NOK,BGN,HRK,RON,RUB,TRY,AUD,CAD,CNY,HKD,IDR,KRW,MYR,NZD,PHP,SGD,THB,ZAR
) VALUES
(27/03/06,1.2025,140.15,0.5759,28.670,7.4617,15.6466,0.68830,264.18,3.4528,0.6960,0.4293,3.9048,9.3550,239.59,37.565,1.5733,86.84,7.9670,1.9558,7.3280,3.5112,33.4150,1.6160,1.6999,1.4100,9.6495,9.3312,10876.61,1173.22,4.4432,1.9753,61.496,1.9460,46.807,7.5168)
At 12:35 25/03/2006, you wrote:
>- see footer for list info -<
Similar problem to what or who?
If you're getting SQL errors, output the SQL string and see what's wrong
with it.
Adrian
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Shawn Fawcett
Sent: 24 March 2006 14:14
To: Coldfusion Development
Subject: [CF-Dev] similar Date criteria ColdFusion/Access problem
>- see footer for list info -<
Hi all,
I'm having a similar problem with the date & yes
it is actally calculing the date...
here it is:
<cfset query_string = "INSERT INTO tblDailyRates (CurrencyRateDate"/>
<cfloop index="i" from="1" to="#ArrayLen(top.xmlchildren)#">
<cfset child = top.xmlchildren[i] />
<cfset query_string = query_string & ",#child.xmlattributes.currency#"/>
</cfloop>
<cfset query_string = query_string & " ) VALUES
(#DateFormat(CreateODBCdate(CurrencyRateDate),"dd/mm/yy")#" />
ARAXI Traductions France
100 Passage Henri Régnault - 92400 Courbevoie La Défense 6
Tél. : 01 49 03 41 49 - Fax : 01 49 03 41 42
_________
_______________________________________________
For details on ALL mailing lists and for joining
or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
ARAXI Traductions France
100 Passage Henri Régnault - 92400 Courbevoie La Défense 6
Tél. : 01 49 03 41 49 - Fax : 01 49 03 41 42
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
