You are here: SQL Function « MsSQL Server « IT news, forums, messages
SQL Function

Posted by Sean on 04/28/06 02:43

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?

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация