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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
