RE: Convert format

val() command cfset SESSION.ecom.ordernumber = val(qLastOrderNo.newOrderNumber) + 1 -- Sam -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 12:49 PM To: CF-Talk Subject: Convert format Hi All, I've got a query which retrieves the max

Re: Convert format

yor query will always return a row and as such the test will fail even if the return item is null replace with this: cfset SESSION.ecom.ordernumber=val(qLastOrderNo.newOrderNumber) + 1 plus the lock if you are on cf mx Marius Milosav www.scorpiosoft.com It's not about technology, it's about

RE: Convert format

Thanks to all for your help. Thanks, Mark -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 4:03 PM To: CF-Talk Subject: Re: Convert format yor query will always return a row and as such the test will fail even if the return item