Is that # hash mark in the color value causing you trouble?
----- Original Message -----
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 10:16 AM
Subject: SQL error
> 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
