[thelist] datatype conversion error

Scott Dexter sgd at ti3.com
Fri Jun 29 11:19:24 CDT 2001


check your column datatypes in the table and make sure that they match the
datatypes in the stored proc. That's usually where I get caught with these--

Also, if you are expecting to actually get the OUTPUT parameter back to the
ASP page yer gonna have to use the ADODB.Command object and go through the
painful .parameter crap....

(and why on earth would you make a long --on-topic-- post longer with a
tip?)

dex

> -----Original Message-----
> From: Warden, Matt [mailto:mwarden at mattwarden.com]
> Error converting data type varchar to int.
> 
> @ReturnedStatsSessionID VARCHAR(20)    OUTPUT,
> @StatsSessionID  INT,
> @IPAddress   VARCHAR(15),
> @UserAgentString  VARCHAR(100),
> @ClientName   VARCHAR(50),
> @ClientVersion   INT,
> @URL    VARCHAR(100)
> 




More information about the thelist mailing list