WHERE ID="gb_entryID"
One of the most basic CF questions in CFQUERY one can ask, is the WHERE clause, for which I am perplexed. The book "ColdFusion in 21 Days" manual I purchased several years ago contains the where clause containing WHERE ID="ID" and I know I should be able to decipher the first element. I am familiar with SQL enough to know the second element refers to the tablefield: gb_entryID (which I created in MS Access). I do not know what the first element refers to, but I think it has something to do with the NAME attribute in the hidden input tag which contains the VALUE referencing the field: gb_entryID. I have someone who uses call_number, and he said to use it as I did below. I cannot consult him any longer, as he passed away a few weeks ago. What is call number?
My situation is that I get an error message: Variable GB_ENTRYID is undefined.
I have two versions of the guestbook listing: one that the public sees (gb.cfm), and another listing (gb_mstr.cfm) that I can click on an icon for each entry, to edit just that one record for for misspellings or profanity, or click a checkbox to suspend to public viewing of the entry. My gb_mstr.cfm page is the page containing links to edit detail of each record, and is for my eyes only.
Here's my guestbook.mdb table structure: gb_entryID (unique), gb_entry_nm_l (text), gb_entry_nm_f (text), gb_entry_m (memo) and here is my HTML/CFML pages:
Entry Edit Page named gb_edit.cfm (available only from gb_mstr.cfm listing page):
<CFQUERY NAME="edit_entry" DATASOURCE="guestbook">
SELECT *
FROM gb_entries
WHERE call_number=#gb_entryID#
</CFQUERY>
<HTML>
<HEAD>
<TITLE>Edit This Entry</TITLE>
</HEAD>
<BODY>
<TABLE>
<TR>
<TD>
<TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="5"
CELLSPACING="0">
<TR>
<TD
VALIGN="top"
WIDTH="200">
<A HREF="gb_mstr.cfm">Back to the Master Guestbook</A>
</TD>
<TD VALIGN="top">
<CFOUTPUT QUERY="edit_entry">
<FORM
NAME="f_gb_entry"
ACTION="gb_confirm.cfm"
METHOD="post">
<B>Your First Name:</B>
<BR>
<INPUT
TYPE="text"
NAME="gb_entry_nm_f"
VALUE="#gb_entry_nm_f#">
<P>
<B>Your Last Name:</B><BR>
<INPUT
TYPE="text"
NAME="gb_entry_nm_l"
VALUE="#gb_entry_nm_l#">
<BR>
Uncheck the box to display First Name only:
<INPUT
TYPE="checkbox"
CHECKED
NAME="gb_entry_nm_l_dspl_x">
<P>
<B>Your Email Address:</B><BR>
<INPUT
TYPE="text"
NAME="gb_entry_tce"
VALUE="#gb_entry_tce#"
SIZE="40"
MAXLENGTH="40">
<BR>
Uncheck the box to keep email private:
<INPUT
TYPE="checkbox"
checked
NAME="gb_entry_tce_dspl_x">
<P>
<B>Your Comments:</B><BR>
<TEXTAREA
COLS="45"
MAX="50"
ROWS="5"
NAME="gb_entry_m">
#gb_entry_m#
</TEXTAREA>
<P>
<INPUT
TYPE="hidden"
NAME="gb_entryID"
VALUE="#gb_entryID#">
<INPUT
TYPE="submit"
VALUE="Update Your Entry">
</FORM>
</CFOUTPUT>
</TD>
</TR>
</TABLE>
</TD></TR>
</TABLE></BODY>
</HTML>
Guestbook Master Listing named gb_mstr.cfm (for site owners' eyes only):
<CFQUERY NAME="dspl_entries" DATASOURCE="guestbook">
SELECT gb_entries.*, IIf([gb_entry_nm_l_dspl_x]=Yes,[gb_entries].[gb_entry_nm_f] & ' ' & [gb_entries].[gb_entry_nm_l],[gb_entries].[gb_entry_nm_f]) AS nm_z, IIf([gb_entry_tce_dspl_x]=Yes,IIf(IsNull([gb_entries].[gb_entry_tce]),'','Email: ' & [gb_entries].[gb_entry_tce]),'') AS em_z
FROM gb_entries
ORDER BY gb_entries.gb_entry_dt DESC;
</CFQUERY>
<CFQUERY DATASOURCE="guestbook" NAME="edit_entries">
SELECT gb_entries.*
FROM gb_entries;
</CFQUERY>
<HTML>
<HEAD>
<TITLE>Site Owner's Master Listing of Guestbook Entries</TITLE>
</HEAD>
<BODY>
<TABLE
BORDER="0"
WIDTH="100%"
CELLPADDING="0"
CELLSPACING="0">
<CFOUTPUT QUERY="dspl_entries">
<!-- <TR>
// <TD>
// <B>#DateFormat('#gb_entry_dt#', "M/D/YYYY")#</B>
// </TD>
// </TR>
// --><TR>
<TD>
<IMG
SRC="http://65.61.35.197/md/img/icons/pencil20x20.gif"
BORDER="0">
<IMG
SRC="http://65.61.35.197/md/img/icons/magnifying_glass01_20x.gif"
BORDER="0">
<BR>
<B>Name:</B> #gb_entry_nm_f# #gb_entry_nm_l#<BR>
<B>Email:</B> #gb_entry_tce#<BR>
<B>City or Town:</B> #gb_entry_cy#, #gb_entry_stt#<BR>
<B>Comments:</B>#gb_entry_m#<BR>
<A HREF="gb_del_confirm.cfm?call_number=#gb_entryID#"
onClick="return(window.confirm('This will PERMANENTLY delete this entry!
Are you sure you wish to proceed?'));">
DELETE THIS TASK
</A>
</CFOUTPUT>
<FORM
ACTION="gb_mstr.cfm"
METHOD="post">
<CFOUTPUT QUERY="edit_entries">
<B>Delete this Entry:</B>
<INPUT
TYPE="checkbox"
NAME="gb_entry_del_x"
VALUE=#gb_entry_del_x#>
</CFOUTPUT>
<BR>
<INPUT TYPE="Submit" VALUE="Save">
</FORM>
</TD></TR>
</TABLE>
</BODY>
</HTML>
AdChoices