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 number to a session var. However, CF5 throws a message that it can't convert format. I checked the db (SQL 2000)- the field ordernumber is an integer. What am I doing wrong

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

people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 3:48 PM Subject: Convert format Hi All, I've got a query which retrieves the max

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