[thesite] Wierd bug

[Daniel J. Cody]

seb, give this a whirl again when you get a chance.. it looks like there
was no <cfqueryparam value=#body# cfsqltype=cf_sql_longvarchar> tag in
teh <cfrquery> tag which we need to insert values larger than 2k

thnx..

.djc.

Seb wrote:
> 
> I actually submitted the article in question and it was all okay. then when
> I editied it, I got the following on submission:
> 
> (Be warned, I've pasted the *entire* error message. It's a bit long. =)
> 
> Error Diagnostic Information
> Oracle Error Code = 1704
> 
> ORA-01704: string literal too long
> 
> SQL = "UPDATE content SET categoryid = '22', datemod = '11/26/2000',
> contentname = 'The Fire Is So Delightful...', synopsis = 'I like to burn
{snip}
> Very long. Very long indeedly doo.', signoff = 3 WHERE contentid = 4237"
> 
> Data Source = "EVOLTCLONE"