You may want to use a text field, not a char field.
I imagine the quotes in the insert may be cause of the problems. There are a
handful of statements that have an effect on the quotes. Look into htmleditformat()
first. I don't see any single quotes
in your insert, so preservesinglequotes() probably won't have an effect.
Why do you want to store so much HTML in the database?
Jeff Davis wrote:
> Help?
> I'm sure this is a silly insert error but I just don't see the problem. The answer
>filed is set up for 2000 Char. Do I need to use a special tag to insert HTML into the
>field? Running CF 4.5 and SQL7.
>
> ODBC Error Code = 22001 (String data right truncation)<P> [Microsoft][ODBC SQL
>Server Driver][SQL Server]String or binary data would be truncated.
> SQL = "insert into dbo.faq (question,answer) values ('What do I need to play at
>IWONITLIVE.com? ','Below are the requirements to plat at IWONITLIVE.com:<br>
> <table width="100%" border="0" cellpadding="4" align="center" cellspacing="6">
> <tr>
> <td width="193"><b><font face="Verdana, Arial, Helvetica,
>sans-serif" size="2" color="#FF0000">Requirement</font></b></td>
> <td width="143"><b><font face="Verdana, Arial, Helvetica,
>sans-serif" size="2" color="#FF0000">Minimum</font></b></td>
> <td width="132"><b><font face="Verdana, Arial, Helvetica,
>sans-serif" size="2" color="#FF0000">Recommended</font></b></td>
> </tr>
> <tr>
> <td width="193"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Internet
> Connection </font></td>
> <td width="143"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">56K
> Dial-Up </font></td>
> <td width="132"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">DSL/Cable
> or higher</font></td>
> </tr>
> <tr>
> <td width="193"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Windows
> Media Player</font></td>
> <td width="143"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Version
> 5 </font></td>
> <td width="132"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Version
> 7 </font></td>
> </tr>
> <tr>
> <td width="193"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Speakers</font></td>
> <td width="143"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Any</font></td>
> <td width="132"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Any</font></td>
> </tr>
> <tr>
> <td width="193"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Microphone</font></td>
> <td width="143"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Any</font></td>
> <td width="132"><font face="Verdana, Arial, Helvetica, sans-serif"
>size="2">Any</font></td>
> </tr>
> </table>')"<P>
>
> Jeff Davis
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
