It has to do with how you are writing your query, if you have a table that has multiple data in a column then it is duplicating within the form. You more than likely need to do a join if you have relational tables.
"Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "Judy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 6:04 PM Subject: too many forms > Can someone tell me why when I click aa link to bring up a form to update, I do get the correct form, but I get 25 copies of it - all containing the same information? > > Here's the queries I'm using: > In the 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> > > > In 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 = #Dates.ID# > AND Events.ID = #Times.ID# > AND Events.ID = #Internet.ID# > AND Events.ID = #Intranet.ID# > AND Events.ID = #PPrint.ID# > </cfquery> > > In the event file that contains the "Edit" link to the updateform.cfm I have this: > > <a href="updateform.cfm?action=edit&ID=#ID#">Edit</a> > > Thanks, I'm desparate for an answer tonight. > > Judy > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
