This is a multi-part message in MIME format.
------=_NextPart_000_0011_01BFDC49.94F5E710
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Since it is a database error the way I would recommend trying to solve this
problem is by first trying to get the insert statement working by trying to
make the insert work by using literals rather then variables. If that works
then replace one literal column with a variable at a time until you find the
offending column variable.
Hope This Helps
Bill Guttman
203-820-5042
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
<http://www.sys-con.com/coldfusion/readerschoice2000/>
http://www.katungroup.com
HTML Links <http://www.katungroup.com/html.htm>
DHTML Links <http://www.katungroup.com/dhtml.htm>
Coldfusion Links <http://www.katungroup.com/coldfusionlinks2.htm>
E-Commerce Links <http://www.katungroup.com/ecommercelinks.htm>
Java <http://www.katungroup.com/java.htm>
JavaScript <http://www.katungroup.com/javascript.htm>
Web Design Links <http://www.katungroup.com/webdesign.htm>
Graphic Design Links <http://www.katungroup.com/GraphicDesign.htm>
Venture Capital Links <http://www.katungroup.com/venturecapital.htm>
Incubator Links <http://Iwww.katungroup.com/incubators.htm>
eBusiness Links <http://www.katungroup.com/eBusiness.htm>
Click on my website for the best content and links on:
E-Commerce, Coldfusion, Java, HTML, Web Development
Jobs, Travel, Venture Capital, Dating and much, much more
-----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.
------=_NextPart_000_0011_01BFDC49.94F5E710
Content-Type: text/x-vcard;
name="Bill Guttman.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Bill Guttman.vcf"
BEGIN:VCARD
VERSION:2.1
N:Guttman;Bill
FN:Bill Guttman
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:19990917T054340Z
END:VCARD
------=_NextPart_000_0011_01BFDC49.94F5E710--
------------------------------------------------------------------------------
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.
