Uncle Ben wrote:
I wrote a stored procedure to INSERT a new row in the database. It
returns the new ID via @@IDENTITY.
This value is read by my ASP and stored in variable intNewID. The
value displays fine via <%= intNewID %>. But when I tested it using
IsNumeric(intNewID), it returned False.
Just for the record, IsNumeric is not part of ASP.
Since you didn't post your code, I'll guess that you're reading a recordset,
and assigning the variable something like this:
intNewID = objRS("ID")
Do you note any difference if you change it to this?
intNewID = objRS.Fields("ID").Value
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.