in my shopping cart check out process, once an order
has been recorded, i want to update the stock levels
of my inventory too.
i'm thinking of using triggers, so that if there is
not enough stock, the trigger should raise an error
(i'm using MSSQL7). in this case, how can ColdFusion
know that the error is "out of stock" and the product
ID of the error?
thanks
__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com
------------------------------------------------------------------------------
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.
