Getting Document ID from empty Library Returns NAN

[Bismarck]

I have a browser based InfoPath 2007 form that users fill out and submit to
a MOSS 2007 Form Template Library. I set the file name during the submit by
using concatenate("Request - " + MAX( @ID) = 1)

This works great. It increments the ID based on the Retreived ID from the
Library. However, when the library is empy, it returns "NaN".

Any ideas how I can avoid this?

Bismarck

 

[Paresh]

I have a browser based InfoPath 2007 form that users fill out and submit to
a MOSS 2007 Form Template Library.  I set the file name during the submit by
using concatenate("Request - " + MAX( @ID) = 1)

This works great.  It increments the ID based on the Retreived ID from the
Library.  However, when the library is empy, it returns "NaN".

Any ideas how I can avoid this?

Bismarck

How do u retrieve the ID?

Thanks,
Paresh
http://www.openzeas.com/blogs/Paresh

 

[Swathi (GGK Tech)]

Hi,
While setting the filename, check the condition that Id is blank or not. If
it is not blank then only set the filename.

 

[Bismarck]

Send me your e-mail address and I'll send you a "How To" document I'm
putting together

Bismarck
(e-mail address removed)

 

[Shiva (GGK Tech)]

Hello,

If your ID field data type is integer then it will return ‘NaN’ for blank
value. You have restrict to check the blank values not allowed otherwise you
can set any default value for blank value.