>- see footer for list info -< Thanks. I am right I was losing my mind!
On 6/29/05, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > Quick glance, move the AND below the where. > > <cfquery datasource="#REQUEST.data#"> > UPDATE Banners > SET BannerName = <cfqueryparam value="#Trim(FORM.BannerName)#" > cfsqltype="cf_sql_varchar"> > WHERE BannerID = <cfqueryparam value="#FORM.EditBanner#" > cfsqltype="cf_sql_integer"> > AND BannerLink = <cfqueryparam value="#Trim(FORM.BannerLink)#" > cfsqltype="cf_sql_varchar"> > </cfquery> > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Simon Baynes > Sent: 29 June 2005 12:21 > To: [email protected] > Subject: [CF-Dev] SQL Problem > > >- see footer for list info -< > OK I have a db table with the following set up:- > > Name - Banners > Fields:- > BannerID INT PRIMARY KEY > BannerName VARCHAR 50 > BannerLink VARCHAR 100 > > I am trying to do the following > > <cfquery datasource="#REQUEST.data#"> > UPDATE Banners > SET BannerName = <cfqueryparam value="#Trim(FORM.BannerName)#" > cfsqltype="cf_sql_varchar"> > AND BannerLink = <cfqueryparam value="#Trim(FORM.BannerLink)#" > cfsqltype="cf_sql_varchar"> > WHERE BannerID = <cfqueryparam value="#FORM.EditBanner#" > cfsqltype="cf_sql_integer"> > </cfquery> > > Whenever I do this it sets the BannerName to -1. > > I am really confused I tried dumping the form before and the > BannerName is set in the variable correctly. I also tried it without > the cfqueryparams and that is not working either. > > It is driving me cracked and I think I am losing my mind. So any help > would be great. > > -- > > Simon Baynes > www.simonbaynes.com > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended recipient(s) please note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or call > our switchboard on +44 (0) 20 89107910. The opinions expressed within this > communication are not necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > -- Simon Baynes www.simonbaynes.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
