I got the following error. No mention of the database
D:\FTP\chrisf\Database\bwpc.mdb in the error statement as Mark Ireland
pointed out.
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
expression '#CFID#'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (49:1) to (49:49).
Kris
----- Original Message -----
From: "Mark Ireland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 12:58 PM
Subject: Re: Arrays, databases, and WDDX
Its not an Access version problem is ist?
D:\FTP\chrisf\Database\bwpc.mdb
At 12:46 AM 22/06/00 -0400, you wrote:
>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.
>
>
>
><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.