Re: CONVERT Function in ASPX

Tech-Archive recommends: Fix windows errors by optimizing your registry

gurvar wrote:
Hi I try this funation in SQL2K It works fine.
But I'm getting the following error in my ASPX Page

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet or even
microsoft.public.dotnet.framework.aspnet .

There was no problem with following statement when talking to SQL7.
Please advice. & Thanks

Select CONVERT(varchar(20),SUM(CONVERT(numeric(20),F.Fee_Amount_VC)))

I suspect SQL 2005 is being stricter when it comes to numeric datatypes,
which require both precision and scale arguments (you've only supplied the
precision argument). Time to go back and read the documentation I'd say ;-)


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages