--------------4F5548F2C62BC4D955ED12A0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
select max(order_ID) as last_num from orders_table
- Michael
Greg Thrasher wrote:
> Hi.
> I've got a problem. I'm building a site that lets users order products, and
> when one orders something, the info about the order gets inserted into my
> access database. Now, I have one column called "Order_ID", which is set in
> Access to be an random autonumber data type. On my "thank you for your
> order" page, I want to be able to display the order number so that customers
> can track their orders. How do I get cf to display the autonumber that was
> just generated for that order? I can't just do a select orders where
> name=<customer's name> because I want to make it possible for one customer
> to make multiple orders.
> Hope someone can figure this out. Thanks!!!
>
> ------------------------------------------------------------------------------
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send
>a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Michael Smith, TeraTech Inc - Tools for Programmers(tm)
VB, CF/ASP Web, Telephony, Math, Access programming tools & consulting
100 Park Ave Ste 360, Rockville MD 20850 USA
Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185 BBS:301-762-8184
Web: http://www.teratech.com/sig/
Email: mailto:[EMAIL PROTECTED]
--------------4F5548F2C62BC4D955ED12A0
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
select max(order_ID) as last_num from orders_table
<br>- Michael
<p>Greg Thrasher wrote:
<blockquote TYPE=CITE>Hi.
<br>I've got a problem. I'm building a site that lets users order
products, and
<br>when one orders something, the info about the order gets inserted into
my
<br>access database. Now, I have one column called "Order_ID", which
is set in
<br>Access to be an random autonumber data type. On my "thank you
for your
<br>order" page, I want to be able to display the order number so that
customers
<br>can track their orders. How do I get cf to display the autonumber
that was
<br>just generated for that order? I can't just do a select orders
where
<br>name=<customer's name> because I want to make it possible for one
customer
<br>to make multiple orders.
<br>Hope someone can figure this out. Thanks!!!
<p>------------------------------------------------------------------------------
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
<p>--
<br>Michael Smith, TeraTech Inc - Tools for Programmers(tm)
<br>VB, CF/ASP Web, Telephony, Math, Access programming tools & consulting
<br>100 Park Ave Ste 360, Rockville MD 20850 USA
<br>Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185
BBS:301-762-8184
<br>Web: <A HREF="http://www.teratech.com/sig/">http://www.teratech.com/sig/</A>
<br>Email: <A HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>
<br> </html>
--------------4F5548F2C62BC4D955ED12A0--
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
