you would be writing it in the select query Judy.
"Success is a journey, not a destination!!" Doug Brown ----- Original Message ----- From: "Judy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 4:56 AM Subject: Re: too many forms > In which file do I write the join - the updateform that has the SELECT query > or the updateaction form that has the UPDATE query? > > > ----- Original Message ----- > From: "Douglas Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 19, 2002 10:22 PM > Subject: Re: too many forms > > > > 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 > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
