|
Posted by Jack Vamvas on 04/28/06 08:24
Are you calling the function as in : SELECT * dbo.myFunction or some other
way?
Could you post the function and the call from the sproc
----
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Sean" <sklosky@genex.com> wrote in message
news:1146181419.634940.224110@u72g2000cwu.googlegroups.com...
> hello everyone,
>
> I created a function in MSSQL that builds an html coupon based upon the
> coupon ident (more complex than that, but that's not where i'm having
> problems!)
>
> When the function builds the coupon, it returns the stream as
> VarChar(8000)
>
> I am calling this function in a sproc that passes in the coupon ident.
> But when I execute this sproc, I get the following error:
>
> Syntax error converting the varchar value '<html>......"
>
> What am I doing wrong? Are there problems with the datatypes I"m
> using?
>
> Thanks in advance for any help on this?
>
[Back to original message]
|