Thanks everyone for your help. I add the val() and it worked perfectly. Now
on to my next big coding project. Thanks again and I'm sure that I'll be
asking more questions as the time comes.
~|
Upgrade to Adobe ColdFusion MX7
Your select statement will always return 1 row, and it will either contain the
max number, or ""
So, use:
Select Max(ReqNum) as HighestNumber
from PrintingReq
No need for a cfif, since val("") returns 0
--
Pat
~|
Upgra
You probably have a null value coming through...put in an or statement ...or
qryHighestNum.highestNumber is ""... So that if it is a null value or no
value...it is set to 1
If you want to see where your problem is do a cfdump () that will display your query results.
Eric
-Original Message--
Melissa Weber wrote:
>
>
>
>
>
>
>
It's because the query HAS a recordcount every time, I think - and it's
returning " " as the result.
So instead of
try
or .
Also you don't need the pound signs in
~~~
wrap qryHighestNum.highestNumber in a val()
in the event that the argument is an empty string, val() will it as a zero.
so:
On 1/30/07, Melissa Weber <[EMAIL PROTECTED]> wrote:
> I've very new to ColdFusion and need some help. I've written a page that has
> six fields: office, year, number,
5 matches
Mail list logo
