I have an SQL database with several tables in it. The Events table is the main one and contains the primary key ID and is an AutoNumber; it is related to each of the other tables: Dates, Internet, Intranet, PPrint which all contain their own ID field and contain the fields BeginDate and EndDate. All relationships are set up as one-to-many.
When I access the form for an event, all the beginning and ending dates on the form are the same. I can't figure out what the problem with my code is. Hopefully, someone can tell me what I've done wrong here. Here is my query in my updateaction.cfm file: <cfquery name="UpdateEvent" datasource="Events"> UPDATE Events, Dates, times, Internet, Intranet, PPrint SET Events.Inactive = '#form.inactive#', 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.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# </cfquery> Here is the code in my updateform.cfm file. <!--- query to get an event to update---> <cfquery name="GetEventtoUpdate" datasource="Events"> SELECT Events.Inactive, Events.Title, Events.InterDesc, Events.IntraDesc, Events.PrintDesc, Events.PrintPub, Events.InterPub, Events.IntraPub, 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# AND times.id = #URL.ID# AND dates.id = #URL.ID# AND internet.id = #URL.ID# AND intranet.id = #URL.ID# AND pprint.id = #URL.ID# </cfquery> <!--- end query---> <html> <head> <title>Edit Event</title> </head> <body> <!--- define the action page in the form tag. The form variables will pass to this page when form is submitted---> <cfoutput query="GetEventtoUpdate"> <form action="updateaction.cfm" method="post"> <input type="Hidden" name="ID" value="#ID#"><br> <table border="0" bgcolor="E0E0E0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td width="100%" valign="middle" bgcolor="000000" align="center"> <table border="0" bgcolor="E0E0E0" cellpadding="0" cellspacing="1" width="100%"> <tr> <td bgcolor="00007D"> <table width="100%" cellpadding="2" cellspacing="0"> <tr> <td bgcolor="00007D" valign="middle"> <font color="FFFFFF"><b>Editing an Event</b></font> </td> </tr> </table> </td> </tr> <td bgcolor="FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <!--- end table layout ---> <!--- start update form ---> <tr><td></td> <td align="right">Inactive? <input type="checkbox" name="Inactive" value="#GetEventtoUpdate.Inactive#" notchecked> </td> </tr> <tr> <td width="100">Event Title:</td> <td><input type="text" name="Events.Title" value="#GetEventtoUpdate.Title#" size="67" maxlength="255"> </td> </tr> <tr> <td>Updated on: </td> <td><input type="text" name="Events.Updatedon" value="#Dateformat(GetEventtoUpdate.updatedon, "mmmm dd, yyyy")#"></td> </tr> <tr> <td></td> <td colspan="2">Time: Comment:</td> </tr> <tr> <td </td> <td><input type="text" name="Times.EventTime" value="#Timeformat(GetEventtoUpdate.EventTime, "hh:mm")#"<br /> <input type="text" name="Times.Comment" value="#GetEventtoUpdate.Comment#" <br /> </td> </tr> <tr> <td></td> <td> <input type="button" name="extendBtn" value="Add More Times ... " onclick="extend();"></td> </tr> <tr> <td></td> <td colspan="2">Beginning Date: Ending Date:</td> </tr> <tr> <td </td> <td><input type="text" name="Events.BeginDate" value="#DateFormat(GetEventtoUpdate.BeginDate, "mm/dd/yyyy")#" <br /> <input type="text" name="Events.EndDate" value="#DateFormat(GetEventtoUpdate.EndDate, "mm/dd/yyyy")#" <br /> </td> </tr> <tr> <td></td> <td> <input type="button" name="extendBtn" value="Add More Dates ... " onclick="extend();"></td> </tr> <tr></tr> <tr> <td width="10">Area/Section:</td> <td><input type="text" name="Area" value="#GetEventtoUpdate.Area#" size="20" maxlength="20" ></td> </tr> <tr> <td width="10">Location:</td> <td><input type="text" name="Location" value="#GetEventtoUpdate.Location#" size="20" maxlength="20"></td> </tr> <tr> <td width="100" valign="top">Category: </td> <td> <SELECT NAME="Category"> <option value="1">4th of July <option value="2">Williamsburg Institute <option value="3">Category 3 <option value="4">Category 4 <option value="5">Category 5 <option value="6">Category 6 </SELECT> </tr> <tr> <td width="100" valign="top">Sub Category: </td> <td> <SELECT NAME="Subcategory"> <option value="1">Sub Category 1 <option value="2">Sub Category 2 <option value="3">Sub Category 3 <option value="4">Sub Category 4 <option value="5">Sub Category 5 <option value="6">Sub Category 6 </SELECT> </td> </tr> <tr> <td >Print in Publications? </td> <td><input type="checkbox" name="PrintPub" value="#GetEventtoUpdate.PrintPub#" checked></td> </tr> <tr> <td></td> <td colspan="2">Beginning Date: Ending Date:</td> </tr> <tr> <td </td> <td><input type="text" name="Print.BeginDate" value="#DateFormat(GetEventtoUpdate.BeginDate, "mm/dd/yyyy")#" <br /> <input type="text" name="Print.EndDate" value="#DateFormat(GetEventtoUpdate.EndDate, "mm/dd/yyyy")#" </tr> <tr> <td></td> <td> <input type="button" name="extendBtn" value="Add More Dates ... " onclick="extend();"></td> </tr> <tr> <td valign="top">Print Description:</td> <td><textarea name="PrintDesc" value= "#GetEventtoUpdate.PrintDesc#" wrap="virtual" rows="5" cols="52"></textarea></td> </tr> <tr> <td valign="top" width="100">Display on Internet? </td> <td><input type="checkbox" name="InterPub" value="#GetEventtoUpdate.InterPub#" checked></td> </tr> <tr> <td></td> <td colspan="2">Beginning Date: Ending Date:</td> </tr> <tr> <td </td> <td><input type="text" name="Internet.BeginDate" value="#DateFormat(GetEventtoUpdate.BeginDate, "mm/dd/yyyy")#" <br /> <input type="text" name="Internet.EndDate" value="#DateFormat(GetEventtoUpdate.EndDate, "mm/dd/yyyy")#" <br /> </tr> <tr> <td></td> <td> <input type="button" name="extendBtn" value="Add More Dates ... " onclick="extend();"></td> </tr> <tr> <td valign="top">Internet Description:</td> <td><textarea name="InterDesc" name="#GetEventtoUpdate.InterDesc#" wrap="virtual" rows="5" cols="52"></textarea></td> </tr> <tr> <td valign="top" width="100">Display on Intranet? </td> <td><input type="checkbox" name="IntraPub" value="#GetEventtoUpdate.IntraPub#" checked> </td> </tr> <tr> <td></td> <td colspan="2">Beginning Date: Ending Date:</td> </tr> <tr> <td </td> <td><input type="text" name="Intranet.BeginDate" value="#DateFormat(GetEventtoUpdate.BeginDate, "mm/dd/yyyy")#" <br /> <input type="text" name="Intranet.EndDate" value="#DateFormat(GetEventtoUpdate.EndDate, "mm/dd/yyyy")#" </tr> <tr> <td></td> <td> <input type="button" name="extendBtn" value="Add More Dates ... " onclick="extend();"></td> </tr> <tr> <td valign="top">Intranet Description:</td> <td><textarea name="IntraDesc" name="#GetEventtoUpdate.IntraDesc#" wrap="virtual" rows="5" cols="52"></textarea></td> </tr> <tr> <td valign="top" width="100">Event Ticketed? </td> <td><input type="checkbox" name="Ticketed" value="#GetEventtoUpdate.Ticketed#" checked> </td> </tr> <tr> <td valign="top" width="100">Kid-Friendly? </td> <td><input type="checkbox" name="Kid" value="#GetEventtoUpdate.Kid#" checked> </td> </tr> <tr> <td valign="top" width="100">Handicapped Accessible? </td> <td><input type="checkbox" name="Handicap" value="#GetEventtoUpdate.Handicap#" checked> </td> </tr> <tr> <td colspan="2"> </td> </tr> </table> <br> <input type="Submit" value="Update Event" style="cursor:hand"> <input type="Reset" value="Cancel" style="cursor:hand" </form> </cfoutput> <!--- end update form ---> </body> Thanks for the help. 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists