RE: Convert format

val() command -- 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 order number from the db. I want to increment it by one and write the new

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: plus the lock if you are on cf < mx Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vi

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 is