ok, I will let you know.
Larry Juncker wrote:
>
> You are correct James;
>
> Just do a simple
> <CFQUERY NAME="getLastPO" DATASOURCE="DSN">
> SELECT Max(YourTable.PONum) AS MaxOfPONum
> FROM YourTable;
> </cfquery>
>
> <CFSET NextPONum = getLastPO.MaxofPONum + 1>
>
> You will want to know what your column name is in your DB and replace PONum
> with whatever that column name is.
>
> Hope this helps!
>
> Larry Juncker
> Developer @ HeartlandInternet.com
>
> -----Original Message-----
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 17, 2000 6:54 AM
> To: [EMAIL PROTECTED]
> Subject: Number Generation
>
> I have a form that contains a field designated for a work order number.
> Is there a way that I can have this field automatically generate a
> number and increment to the next number each time it is loaded? I am
> guessing that I would have to query the database to check the last
> number assigned and generate the next one, but that is a guess. This way
> managers wont have to remember the last number assigned when assigning a
> new request.
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> 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.
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> 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.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
