On 6/1/00, jmentzer penned:
>Hi
>
>I'm looking to do my first shopping cart w/ CF. As the merchant for whom the
>site is being built doesn't accept credit cards, "submit order" is simply
>going to send a few emails and store some records in the database.
>
>Can anyone give me a few pointers on the best way to do this? Would
>CFTRANSACTION be useful?
Sounds like you're going to build something from scratch? I planned
on spending the weekend when I did mine. LOL 6 months later, I was
still going strong. The point is, build the cart with credit card
functionality, then turn it off.
As far as cftransaction, I suspect you think it does what it sounds
like, as in help conduct a transaction. That's not the case. What it
does, is lock the database up for your own use if you have more than
one query to run and the results from one depend upon the actions of
another. Example: You write an order to a table with an autonumber
column in an Access database. Now you want to know what that number
is, so you run another query to get the highest number (the last
order written). cftransaction will prevent anyone else from writing
an order in the split second between when you wrote yours and when
you query for the max order number. Otherwise, you'd pick up their
order number.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.