I have a backend page set up to insert new FAQ's to the site so teh CEO can
add them as they come up. This is really the only one that has this much
HTML for the table layout of requirements. It was teh # sign causing the
problem, I removed all the <Font> tags and it inserted just fine. Thanks
Guys.
Jeff Davis
----- Original Message -----
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 2:31 PM
Subject: Re: SQL error
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
