|
|
Posted by Erland Sommarskog on 04/28/06 14:57
Sean (sklosky@genex.com) writes:
> 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?
Your major error in your post is that you don't include the code that
you use. I'm sorry, but it is not possible to help you from the description
you have given. You have apparently messed up the data types somewhere,
but that's all I can say.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|