[thesite] Wierd bug

[Seb]

thanks Dan, but you oughta check your sql syntax...

SQL = "UPDATE content SET categoryid = '22', datemod = '11/26/2000',
contentname = 'The Fire Is So Delightful...', synopsis = 'I like to burn
things.... pa said it''s best to burn books but I like burning meerkats...',
body = :1 signoff = 3 WHERE contentid = 4237"


I'm getting "ORA-00933: SQL command not properly ended" which isn't too bad
compared to the previous problems....

Seb.

----- Original Message -----
From: "Daniel J. Cody" <dcody at oracular.com>
To: <thesite at lists.evolt.org>
Sent: Sunday, November 26, 2000 8:16 PM
Subject: Re: [thesite] Wierd bug


> 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"
>
> _______________________________________________
> http://lists.evolt.org/thesitearchive/
> and new & improved kentucky fried old archives:
> http://lists.evolt.org/thesitearchive/old/
>