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

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 423,293 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 5,295 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.

Join our community!

Please support our ColdFusion advertiser: Programming Forums

Thread Tools Display Modes

Views: 1603 | Replies: 3

•

Join Date: Jan 2008

Posts: 3

Reputation: sanscls is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

sanscls

Offline

Newbie Poster

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

Apr 1st, 2008

I want to update an access db with multiple records. They are property pictures. They may have the same listnumber, but all have a different ID#. There are not always a set amount of pics... may be 5 or 7 or 10, etc..

The DB fields are id, filedata (actual .jpg filename), picturename, listnumber

I am trying to add names to all pictures at once instead of one at a time. Below is the code I have... it is only updating one record at a time.

Data entry page: (output query: lookup grabs the pictures witha a specific listnumber ie:1950)

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
<cfoutput query="lookup">
<form enctype="multipart/form-data" action="title_picture_action.cfm?id=#listnumber#" method="POST">
<input type="hidden" name="id" value="#id#">
<input type="hidden" name="listnumber" value="#listnumber#">
 
	<table border="0" width="500" cellpadding="10" cellspacing="0">
	<tr>
        <td><img src="images/uploads/#filedata#" width="100"></td>
		<td><input type="text" maxlength="50" size="20" name="picturename" value="#picturename#"></td>
		<!--- <td align="center">
<input type="submit" value="Submit"></td> --->
 
		<hr color="00704a" style="height = 1px">
    </tr>
	</cfoutput>
	<tr><td><input type="submit" value="Submit"></form></td></tr>
	<table>
<cfoutput query="lookup">
<form enctype="multipart/form-data" action="title_picture_action.cfm?id=#listnumber#" method="POST">
<input type="hidden" name="id" value="#id#">
<input type="hidden" name="listnumber" value="#listnumber#">

	<table border="0" width="500" cellpadding="10" cellspacing="0">
	<tr>
        <td><img src="images/uploads/#filedata#" width="100"></td>
		<td><input type="text" maxlength="50" size="20" name="picturename" value="#picturename#"></td>
		<!--- <td align="center"><input type="submit" value="Submit"></td> --->
		
		<hr color="00704a" style="height = 1px">
    </tr>
	</cfoutput>
	<tr><td><input type="submit" value="Submit"></form></td></tr>
	<table>

Processing page:

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
<cfquery name="titlepicture" datasource="#dsn#">
	UPDATE uploads SET	
	picturename = '#form.picturename#'
	WHERE id = #form.id#
	</cfquery> 
 
	<cflocation url="index.cfm
 
<cfquery name="titlepicture" datasource="#dsn#">
	UPDATE uploads SET	
	picturename = '#form.picturename#'
	WHERE id = #form.id#
	</cfquery> 
			
	<cflocation url="index.cfm

Any help will be GREATLY appreciated! Thx in advance.

Last edited by peter_budo : Apr 4th, 2008 at 4:25 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Jan 2008

Posts: 3

Reputation: sanscls is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

sanscls

Offline

Newbie Poster

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

Apr 2nd, 2008

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.

•

Join Date: Jul 2007

Posts: 13

Reputation: tashakota is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

tashakota

Offline

Newbie Poster

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

Apr 15th, 2008

•

Originally Posted by sanscls

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:

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
cfquery name="titlepicture" datasource="#dsn#"
UPDATE uploads SET
picturename = '#form.picturename#'
WHERE listnumber = #form.listnumber#
cfquery
 
cflocation url="index.cfm
cfquery name="titlepicture" datasource="#dsn#"
UPDATE uploads SET
picturename = '#form.picturename#'
WHERE listnumber = #form.listnumber#
cfquery
      
cflocation url="index.cfm

Last edited by peter_budo : Apr 20th, 2008 at 6:51 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Jun 2008

Location: Dhaka

Posts: 10

Reputation: iqbalhosan is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

iqbalhosan iqbalhosan is offline

Offline

Newbie Poster

try this!

Jun 3rd, 2008

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfoutput>
	<form enctype="multipart/form-data" action="title_picture_action.cfm?id=#listnumber#" method="POST">
		<table border="0" width="500" cellpadding="10" cellspacing="0">	
			<tr>        
				<td><img src="images/uploads/#filedata#" width="100"></td>		
				<td>
					<input type="text" maxlength="50" size="20" name="picturename" value="#picturename#">
					<input type="submit" value="Submit">
				</td>
			</tr>	
		</table>
	</form>
</cfoutput>	
<cfoutput>
	<form enctype="multipart/form-data" action="title_picture_action.cfm?id=#listnumber#" method="POST">
		<table border="0" width="500" cellpadding="10" cellspacing="0">	
			<tr>        
				<td><img src="images/uploads/#filedata#" width="100"></td>		
				<td>
					<input type="text" maxlength="50" size="20" name="picturename" value="#picturename#">
					<input type="submit" value="Submit">
				</td>
			</tr>	
		</table>
	</form>
</cfoutput>	

###################processing page################

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfquery name="titlepicture" datasource="#dsn#">
		UPDATE	uploads 
		SET	picturename = '#form.picturename#'
		WHERE id = #url.id#
	</cfquery>
<cfquery name="titlepicture" datasource="#dsn#">
		UPDATE	uploads 
		SET	picturename = '#form.picturename#'
		WHERE id = #url.id#
	</cfquery>