> WHERE ID = ID
This is always true. You need something like
WHERE ID = #ID#
See the difference?
Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New Zealand
http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/
-----Original Message-----
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Friday, 19 April 2002 3:03 p.m.
To: CF-Talk
Subject: update form displays multiple pages
When I click an Edit link for a record, instead of displaying a form
containing existing data, I get 25 pages of the same record. I know my
relationships in my database are correct - they are all one-to-many.
Where have I gone wrong? The main file, Events contains the primary key
ID and the other 6 tables each have a foreign key also called ID.
Here is the cfquery and cfoutput code for my main file where the Edit
link is located:
<!--- add query to select all events--->
<cfquery name="selectevent" datasource="Events">
SELECT *
FROM Events
WHERE ID = ID
</cfquery>
<!--- end query to select all events--->
<cfoutput query="selectevent">
<tr bgcolor="#iif(selectevent.currentrow MOD 2, DE('FFFFFF'),
DE('E0E0E0'))#">
<td valign="top">
<a>#title#</a><br>
Updated on: <a>#Dateformat(updatedon, "mmmm dd, yyyy")#</a>
</td>
<td align="right" valign="top" width="200">
<a href="displayinterdesc.cfm?ID=#id#">Preview</a>
<a href="updateform.cfm?Id=#id#">Edit</a>
<a href="deleteform2.cfm?Id=#id#">Delete</a>
</td>
</tr>
</tr>
</cfoutput>
</table>
</body>
------------------------------------------------------------------------
--------
Here is my cfquery and cfoutput and some of the form input code for my
updateform file .
<!--- query to get an event to update--->
<cfquery name="GetEventtoUpdate" datasource="Events"
cachedwithin="#CreateTimeSpan(1,0,0,0)#">
SELECT
Events.Title,
Events.InterDesc,
Events.IntraDesc,
Events.PrintDesc,
Events.PrintPub,
Events.InterPub,
Events.IntraPub,
Events.Inactive,
Events.Area,
Events.Location,
Events.Ticketed,
Events.Kid,
Events.Handicap,
Events.Updatedon,
Dates.BeginDate,
Dates.EndDate,
Times.EventTime,
Times.Comment,
Internet.BeginDate,
Internet.EndDate,
PPrint.BeginDate,
PPrint.EndDate,
Intranet.BeginDate,
Intranet.EndDate
FROM Events, Dates, Times, Internet, Intranet, PPrint
WHERE Events.ID = #URL.ID#
</cfquery>
<!--- end query--->
<cfoutput query="GetEventtoUpdate">
<form action="updateaction.cfm" method="post">
<input type="Hidden" name="ID" value="#ID#"><br>
<!--- start update form --->
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr><td></td>
<td align="right">Inactive? <input type="checkbox" name="Inactive"
value="#GetEventtoUpdate.Inactive#" unchecked></td>
</tr>
<tr>
<td width="100">Event Title:</td>
<td><input type="text" name="Title" value="#GetEventtoUpdate.Title#"
size="67" maxlength="255">
</td>
</tr>
<tr>
<td>Updated on: </td>
<td><input type="text" name="Updatedon"
value="#Dateformat(GetEventtoUpdate.updatedon, "mmmm dd, yyyy")#"></td>
</tr>
------------------------------------------------------------------------
--------
Here is the code for the updateaction file
<cfquery name="UpdateEvent" datasource="Events">
UPDATE Events, Dates, times, Internet, Intranet, PPrint
SET
Events.Title = '#form.title#',
Events.InterDesc = '#form.InterDesc#',
Events.IntraDesc = '#form.IntraDesc#',
Events.PrintDesc = '#form.PrintDesc#',
Events.InterPub = '#form.InterPub#',
Events.IntraPub = '#form.IntraPub#',
Events.PrintPub = '#form.PrintPub#',
Events.Inactive = '#form.inactive#',
Events.Area = '#form.Area#',
Events.location = '#form.Location#',
Events.Ticketed = '#form.Ticketed#',
Events.Kid = '#form.Kid#',
Events.Handicap = '#form.Handicap#',
Events.Updatedon = '#form.Updatedon#',
Times.EventTime = '#form.Times.EventTime#',
Times.Comment = '#form.Comment#',
Dates.BeginDate = '#form.Dates.BeginDate#',
Dates.EndDate = '#form.Dates.EndDate#',
PPrint.BeginDate = '#form.PPrint.BeginDate#',
PPrint.EndDate = '#form.PPrint.EndDate#',
Internet.BeginDate = '#form.Internet.BeginDate#',
Internet.EndDate = '#form.Internet.EndDate#',
Intranet.BeginDate = '#form.Intranet.BeginDate#',
Intanet.EndDate = '#form.Intranet.EndDate#'
WHERE Events.ID = #URL.ID#
AND Dates.ID = #URL.ID#
AND Times.ID = #URL.ID#
AND Internet.ID = #URL.ID#
AND Intranet.ID = #URL.ID#
AND Print.ID = #URL.ID#
</cfquery>
Thanks in advance for your help.
Judy
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
