no no. don't put quotes around price in the Replace function. :)
use
#Replace(price, ",", "", "ALL")#
not
#Replace("price", ",", "", "ALL")#
-----Original Message-----
From: Metzy Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 11:33 AM
To: CF-Talk
Subject: RE: insert problem
I tried doing a replace but i still get the same output
I'm doing this before i save.
my field type is money.
there are no quotes on my field
<cfquery name="prodEdit" datasource="#dsn.bps#" dbtype="ODBC">
Update product
Set sectionID = #sectionID#,
productName = '#productName#',
description = '#description#',
manufacturer = '#manufacturer#',
manufURL = '#manufURL#',
<cfif changeLarge is "Yes">
imageName = '#imageName#',
</cfif>
<cfif changeThumb is "Yes">
thumbName = '#thumbName#',
</cfif>
<cfif changePrint is "Yes">
printName = '#printName#',
</cfif>
price = #price#,
salePrice = #salePrice#
Where productID = #productID#
</cfquery>
#Replace("price", ",", "", "ALL")#
#price#
#Replace("salePrice", ",", "", "ALL")#
#salePrice#
price $45.50 salePrice $111,110.00
----------------------------------------------------------------------------
----
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near
'110.00'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (377:2) to (377:63).
Date/Time: 05/10/01 11:20:05
...
-----Original Message-----
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 7:29 AM
To: CF-Talk
Subject: RE: insert problem
Replace("1,110.00", ",", "", "ALL")
or Replace(thevar, ",", "", "ALL") if it's in a variable.
-----Original Message-----
From: Metzy Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 10:23 AM
To: CF-Talk
Subject: insert problem
i'm trying to same a number that has been formatted as dollar amount
if i have an amount that is $1,110.00 it's telling that i have an error
i'm pretty sure that it is because i'm trying to save and the number is
being placed with a comma in it. how can i work around this.
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 9: Incorrect syntax near
'110.00'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (367:2) to (367:63).
Date/Time: 05/10/01 10:08:17
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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