Jeff
It's not a silly error, but exactly what it says...
Your second value is 2330 characters long...
.... a 2,000 char field fills up quickly, doesn't it!
HTH
Dick
At 11:16 AM -0500 2/17/01, 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists