January 9, 2009 at 8:33 am
I was running an ASP report. It blows up on this line:
PerYes = FormatNumber(.Parameters ("PerYes"),2)
The error displays 'FormatNumber'.
Any help is greatly appreciated.
Arun
January 9, 2009 at 8:36 am
More info on this error.
Type mismatch: 'FormatNumber'
Thanks,
Arun
January 9, 2009 at 9:46 am
You'd probably get better answers posting this on a asp site as it has nothing to do with SQL Server.
My guess is that FormatNumber is expecting a numeric and that .Parameters ("PerYes") is a string already. Try doing CINT if int or the equivalent conversion for decimal number.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 9, 2009 at 10:29 am
Yes, I hould have posted to an asp forum.
But, thanks for the tip, it's certainly in the right direction.
Thanks,
Arun
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply