cfquery name="name" datasource="#dsn#"> INSERT INTO Stock VALUES (#Form.Item_ID#, '-#Form.ammount#',) </cfquery>
On 9/17/06, Chad Gray <[EMAIL PROTECTED]> wrote: > > I am working on an inventory system where people put in a number of items > that are being taken out of inventory and put into inventory. > > The users are entering positive numbers. > > I need to store the number as a negative in the database if inventory is > being removed. > > How do I convert the number they enter to a negative before I insert it > into the database? > > I am sure it is something simple I am just a little burnt out. > Thanks! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
