That did the trick. Thanks
On Thu, 31 Oct 2002 10:11:32 -0800, Matt Robertson wrote: > This will do it for you. Watch out for any unintended line breaks that > might make it into this msg. > > Notice that its not necessary to use tickmarks on a text field. Use > cfsqltype=CF_SQL_LONGVARCHAR for memo fields. These sql types can be > used on Access, mySQL, Oracle and MS SQL without causing any trouble. > Haven't tested for a universal date type, yet. > > <cfquery > DATASOURCE="#request.SiteDSN#"> > UPDATE myFile > SET > myFile.myPath=<cfqueryparam cfsqltype="CF_SQL_VARCHAR" > value=#form.myPath#> > WHERE > myFile.IDNUM=<cfqueryparam cfsqltype="CF_SQL_NUMERIC" > value=#blahblah#> > </cfquery> > > Cheers, > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com > > > > -----Original Message----- > From: FlashGuy [mailto:flashmx@;rogers.com] > Sent: Thursday, October 31, 2002 10:01 AM > To: CF-Talk > Subject: Re: MySQL & CF > > > I see...OK...trying the <cfqueryparam now. Getting "?" inserted into my > database. Must be wrong syntax. > I'll keep trying. > > On Thu, 31 Oct 2002 11:53:38 -0600, Paul Giesenhagen wrote: > > > \ is an escape character .. .Matt Robertson gave me a good tip .. use > > <cfqueryparam> for your insert and let CF escape all the correct > characters. > > > > Hope this helps. > > > > Paul Giesenhagen > > QuillDesign > > > > ----- Original Message ----- > > From: "FlashGuy" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, October 31, 2002 11:46 AM > > Subject: OT: MySQL & CF > > > > > > > Hi, > > > > > > Something weird is happening. Before I switched my databases from > Access > > to MySQL my app was working OK. > > > Now when I insert data into my SQL database one of the fields is > getting > > mucked up and I don't know why? Here is an example of a entry how is > > *should* appear in the > > > database: > > > > > > Should be: > > > > > > env_var = book1 > > > destination = D:\data\book1 > > > > > > This is what getting input into my SQL database: > > > > > > env_var = book1 > > > destination = D:|ata|ook1 > > > > > > Its like the "\b" is getting interpreted into a wacko ASCII > character? > > > > > > Both fields in my table are varchar(255) types > > > > > > > > > --------------------------------------------------- > > > Colonel Nathan R. Jessop > > > Commanding Officer > > > Marine Ground Forces > > > Guatanamo Bay, Cuba > > > --------------------------------------------------- > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
