User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 361,950 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,603 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser:

I'm sure there is an easy Loop solution - doing an update

Join Date: Jul 2007
Posts: 13
Reputation: tashakota is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
tashakota tashakota is offline Offline
Newbie Poster

Re: I'm sure there is an easy Loop solution - doing an update

  #3  
Apr 15th, 2008
Originally Posted by sanscls View Post
To make clear: My problem is on the Processing page. I need to be able to update MULTIPLE images (filedatd field in db) with names (picturename field in db) They will have the SAME listnumber, but different ID numbers.


I believe if you update the db using the listnumber instead of the id, then you should be updating all records with that listnumber.

ie:

  1. cfquery name="titlepicture" datasource="#dsn#"
  2. UPDATE uploads SET
  3. picturename = '#form.picturename#'
  4. WHERE listnumber = #form.listnumber#
  5. cfquery
  6.  
  7. cflocation url="index.cfm
Last edited by peter_budo : Apr 20th, 2008 at 6:51 pm. Reason: Keep It Organized - please use [code] tags
Reply With Quote  
All times are GMT -4. The time now is 11:50 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC