Build Master/Detail page in ColdFusion

ColdFusion Master/Detail Pages

Page 1, Page 2, Page 3

1. Create a new page and Save it AS Details.cfm.
Note when we mentioned earlier how to retrieve variables from the queryString using #URL.CFvariable#

2. Make our Recordset but filter the SQL statement to find the CatID in the Details table equal to the CatID in the QueryString passed.

<cfquery name="rsDetails datasource="udnewbie">

SELECT SubCatID, SubCatTitle, CatID
FROM tblSubCat
WHERE CatID = #URL.CatID#

</cfquery>

note: Recall that CatID is of datatype number, it it was a string we would surround it with single quotes like '#URL.CFVariable#'

3. We have successfully created our filtered Recordset, all we need to do now is display our SubCatgory Titles. you should know how to do this from part 1.
Within our body tags we will type:

<cfoutput query="rsDetails">

#rsDetails.SubCatTitle#<br>

</cfoutput>


4. View your master page through the browser and click a link.


Happy Programming!

If you have any problems with the tutorial, just drop me an email or post a comment.
Omar Elbaga
http://www.UDnewbie.com

If you are further enticed by ColdFusion, you might like to try a couple of CF Newsgroups like CFTalk news://fuseware.com/cf-talk or Jag's CF NG news://ls.magicfind.com/mb-cf. Also see Patty's CF resources. You will also find plenty of CF Extensions for Ultradev at http://www.massimocorner.com and http://www.basic-ultradev and there is much more.