That was it! Thank you!
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 4:18 PM
To: CF-Talk
Subject: Re: OT: SQL Question
On 1/16/01, Gieseman, Athelene penned:
><cfquery datasource="IS_Budget" name="SaveInvoiceQry">
> INSERT X_Invoices (Vendor, Inv_GL, Inv_City, Inv_Dept, Inv_Date,
>Inv_No, Inv_Desc, ApprovedDate, Notes, Inv_Amount)
> values ('#Vendor#', '#Inv_GL#', '#Inv_City#', '#Inv_Dept#',
>'#Inv_Date#', '#Inv_No#', '#Inv_Desc#', '#ApprovedDate#', '#Notes#',
>#Inv_Amount#)
></cfquery>
>
>I'm sure I'm not seeing something obvious. But it looks to me like there
>are 10 items for each of the values and table columns. Can anyone see what
>I'm not?
One thing to look for is columns that don't have single quotes around
them. If you input an #Inv_Amount# with a comma in it, like 1,000.00,
it will think that is 2 fields, because of the comma. Try using:
#rereplace(Inv_Amount, "[^0-9\.]+", "", "ALL")#
Or even just:
#replace(Inv_Amount, ",", "", "ALL")#
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists