or deadlock due to the MAX(ID) used for creating a unique id. It is very
possible to return the same ID to two different "users" if they make a
request at the "same" time. Personally I avoid this method of finding a
unique id.
Kore Peterson
John Croney
<[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]>
net.com> cc:
Subject: Re: SQL INSERT error on large amount of text
04/07/2004
01:08 PM
Please respond
to cf-talk
I got it to work. I use CFSQLTYPE="CF_SQL_LONGVARCHAR"
Thanks for help.
Do you know what could be causeing the other problems?
> No I was not, I was using ParagraphFormat. I tride the cfqueryparam
> but that cut the text down to a few lines. I tride useing MaxLength
> attribute but nothing happen. This is my script:
>
>
> <CFQUERY
> NAME="NewID"
> datasource="VFP"
> dbtype="ODBC">
> SELECT max(id) as LastID from News
> </CFQUERY>
>
> <cfset Image=Trim(#Form.txtImage#)>
> <cfset NextID=#NewID.LastID#+1>
> <cfset OptionNews=trim(#Form.optNews#)>
>
> <CFQUERY NAME="qry_News" DATASOURCE="VFP">
> INSERT INTO News(id,ctopic ,mnews ,ddate ,cphoto ,mphototext ,itype ,
> lnew ,backgroundimg)
> VALUES(#NextID#,
> <CFQUERYPARAM VALUE="#Form.txtTopic#">,
> <CFQUERYPARAM VALUE="#Form.txtMemo#" MAXLENGTH="9999">,
> {04/06/04},
> [#Image#],
> <CFQUERYPARAM VALUE="#Form.txtText#">,
> #OptionNews#,
.
> f.,
> [none]
> )
> </CFQUERY>
>
>
> > Are you using cfqueryparam? If not what are you doing to escape
> > characters
> > like ' ,"; etc?
> >
> >
> > Kore Peterson
> >
> >
> >
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
