Oops. I mean #URL.ID#
-----Original Message-----
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Friday, 19 April 2002 3:26 p.m.
To: CF-Talk
Subject: Re: update form displays multiple pages
I made the change, but got this error message:
<!--- add query to select all events--->
<cfquery name="selectevent" datasource="Events">
SELECT *
FROM Events
WHERE ID = #ID#
</cfquery>
<!--- end query to select all events--->
Do I need to have additional WHERE statements here because I'm using 6
different tables in this form which all have relationships with the main
Events?
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while evaluating the expression:
#ID#
Error near line 7, column 13.
------------------------------------------------------------------------
--
Error resolving parameter ID
ColdFusion was unable to determine the value of the parameter.
This
problem is very likely due to the fact that either:
1.. You have misspelled the parameter name, or
2.. You have not specified a QUERY attribute for a CFOUTPUT,
CFMAIL,
or CFTABLE tag.
The error occurred while processing an element with a general
identifier of (#ID#), occupying document position (7:12) to (7:15).
----- Original Message -----
From: "Matthew Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 11:13 PM
Subject: RE: update form displays multiple pages
> > 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
>
>
>
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
