heh...well you kicked it into gear anyways ;)
- dave
Christopher Jordan wrote:
Doh! typo... it *is* {d 'YYYY-MM-DD'} and not DD-MM as my email
indicated. Good eye though, David. :)
Chris
David L. Penton wrote:
{d '2006-18-06'} seems a bit out of whack. It should likely be a
YYYY-MM-DD format, or {d '2006-06-18'}
I have used DB2 zSeries and DB2 UDB on AIX and for all date
operations, I always use the YYYY-MM-DD format.
- dave
Christopher Jordan wrote:
Hi folks,
I'm getting a Data Truncation error with the following code snippet:
<CFQuery Name="AddNewNote" DataSource="#as400ds#">
INSERT INTO #PrependLibrary("Notes")#
(#ThisNoteInsertList#)
VALUES (
<CFQueryParam value="#ThisClientID#"
cfsqltype="CF_SQL_INTEGER">,
<CFQueryParam value="#ThisNoteID#"
cfsqltype="CF_SQL_INTEGER">,
<CFQueryParam value="#ThisNoteType#"
cfsqltype="CF_SQL_VARCHAR">,
<CFQueryParam value="#ThisNoteTimeStamp#"
cfsqltype="CF_SQL_TIMESTAMP">,
<CFQueryParam value="#ThisNoteText#"
cfsqltype="CF_SQL_VARCHAR">,
<CFQueryParam value="#ThisNoteAuthor#"
cfsqltype="CF_SQL_VARCHAR">,
<CFQueryParam value="#ThisNoteAuthorIPAddress#"
cfsqltype="CF_SQL_VARCHAR">
<CFIf Len(ThisEmployeeID)>
,<CFQueryParam value="#ThisEmployeeID#"
cfsqltype="CF_SQL_INTEGER">
</CFIf>
<CFIf Len(ThisCostCenterID)>
,<CFQueryParam value="#ThisCostCenterID#"
cfsqltype="CF_SQL_INTEGER">
</CFIf>
<CFIf Len(ThisShiftID)>
,<CFQueryParam value="#ThisShiftID#"
cfsqltype="CF_SQL_INTEGER">
</CFIf>
<CFIf Len(ThisShiftDate)>
,<CFQueryParam value="#ThisShiftDate#"
cfsqltype="CF_SQL_DATE">
</CFIf>
)
</CFQuery>
The issue appears to be with the CF_SQL_DATE line. My DB2 table is
set up such that the field called ShiftDate is of datatype "DATE",
and the value of "ThisShiftDate" at the time I'm trying to insert it
is: {d '2006-18-06'}
I'm at a loss. I've only just begun to use CFQueryParam and I wonder
if I'm doing something wrong or if it's just the stupid DB2 table or
what?
Any DB2 gurus in the group? I've got no idea what version of DB2 I'm
on, but I'd be willing to bet it's rather old, as the AS400 it
resides on is quite old. Help would be greatly appreciated. :)
Thanks,
Chris
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
