The error message from ODBC seems to imply that Access is expecting a
datetime value in CFID. Have you tried adding a date manually?
-----Original Message-----
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 2:47 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
I have the datetime set in the database to automatically set it whenever a
new record is made so I don't have to worry about it anymore.
-----Original Message-----
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
You mentioned "datetime" in your text - where is it used in the code?
-----Original Message-----
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:47 AM
To: [EMAIL PROTECTED]
Subject: Arrays, databases, and WDDX
Hello Everyone,
I am building a system configurator for a site, but I keep having this error
I can't figure out. To see the error, go to www.bluewaterpc.com then click
"SOHO Bundle" in the left column. Then just hit the calculate button on the
bottom. Now, what this does, is it puts a ton of ProductID numbers (used in
a database) into variables like "Case", "RAM", "CPU", etc. You get the
idea... now, an array is then made with these variables. This array goes
in a <CFWDDX> tag and then we try to put this information into a database
using CFQUERY.
The database is setup as follows. It is a Microsoft Access database, and in
a table called "SystemQuote" there are 4 fields. "CFID" is one field set up
as an integer. "CFTOKEN" is setup as Long Integer. "ProductID" is setup as
memo. Finally, DateTime is setup as, you guessed it, a Date/Time field.
Following is some of the code for the page where all of this happens:
<CFSET ProductIDArray=ArrayNew(2)>
<CFSET ProductIDArray[1][1] = "Case">
<CFSET ProductIDArray[1][2] = #Case#>
<CFSET ProductIDArray[2][1] = "CPU">
<CFSET ProductIDArray[2][2] = #CPU#>
<CFSET ProductIDArray[3][1] = "RAM">
<CFSET ProductIDArray[3][2] = #RAM#>
<CFSET ProductIDArray[4][1] = "HardDrive">
<CFSET ProductIDArray[4][2] = #HardDrive#>
<CFSET ProductIDArray[5][1] = "Floppy">
<CFSET ProductIDArray[5][2] = #Floppy#>
<CFSET ProductIDArray[6][1] = "Monitor">
<CFSET ProductIDArray[6][2] = #Monitor#>
<CFSET ProductIDArray[7][1] = "VideoCard">
<CFSET ProductIDArray[7][2] = #VideoCard#>
<CFSET ProductIDArray[8][1] = "CDROMorDVD">
<CFSET ProductIDArray[8][2] = #CDROMorDVD#>
<CFSET ProductIDArray[9][1] = "CDRecorder">
<CFSET ProductIDArray[9][2] = #CDRecorder#>
<CFSET ProductIDArray[10][1] = "ZipDrive">
<CFSET ProductIDArray[10][2] = #ZipDrive#>
<CFSET ProductIDArray[11][1] = "SoundCard">
<CFSET ProductIDArray[11][2] = #SoundCard#>
<CFSET ProductIDArray[12][1] = "Speakers">
<CFSET ProductIDArray[12][2] = #Speakers#>
<CFSET ProductIDArray[13][1] = "Modem">
<CFSET ProductIDArray[13][2] = #Modem#>
<CFSET ProductIDArray[14][1] = "NetworkCards">
<CFSET ProductIDArray[14][2] = #NetworkCards#>
<CFSET ProductIDArray[15][1] = "Scanner">
<CFSET ProductIDArray[15][2] = #Scanner#>
<CFSET ProductIDArray[16][1] = "DigitalCamera">
<CFSET ProductIDArray[16][2] = #DigitalCamera#>
<CFSET ProductIDArray[17][1] = "Printer">
<CFSET ProductIDArray[17][2] = #Printer#>
<CFSET ProductIDArray[18][1] = "OperatingSystem">
<CFSET ProductIDArray[18][2] = #OperatingSystem#>
<CFSET ProductIDArray[19][1] = "Keyboard">
<CFSET ProductIDArray[19][2] = #Keyboard#>
<CFSET ProductIDArray[20][1] = "Mouse">
<CFSET ProductIDArray[20][2] = #Mouse#>
<CFIF IsDefined('Software')>
<CFSET ProductIDArray[21][1] = "Software">
<CFSET ProductIDArray[21][2] = #Software#>
</cfif>
<CFWDDX ACTION="CFML2WDDX" Input="#ProductIDArray#" Output="WDDX">
<CFQUERY datasource="bwpc" name="InputQuoteData">
INSERT INTO SystemQuote ( CFID, CFTOKEN, ProductID ) values ( #CFID#,
#CFTOKEN#, '#WDDX#' )
</CFQUERY>
If you all can figure out what the problem is, I would greatly appreciate
it. I sure can't. Thank you for all of your help. You
----------------------------------------------------------------------------
--
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.
----------------------------------------------------------------------------
--
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.
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
