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
