> Out of curiosity, what condition was your cfparam trying to prevent?
The URL structure works like this:
http://blah-blad.com/services-detail.cfm/bariatric-and-wellness (which
is a high level overview category record only)
or
http://blah-blad.com/services-detail.cfm/bariatric-and-wellness/treatment-options
(which adds more specific detail to the page about treatment options)
If it's a high level page the query retrieves the category record only. If it's
a more detailed page the query also joins in another table to get the
additional detail requested, so values from the detail table may not always
exists in the returned query.
The cfparam tag was trying to set default values (like zero) for columns that
may not always be returned from the query. That did not work, but the IsDefined
did work.
I'm not done with the page, but you can get the idea at:
http://68.168.221.45/services-detail.cfm/breast-health/breast-reconstruction .
The left navigation, main lookup and detail lookups are working. Still writing
the code to chain in the related FAQs, events, and staff. The change based on
the service selected.
Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100
Hauppauge NY 11788
P : 631.231.6600 Ext. 119
F : 631.434.7022
http://www.austin-williams.com
Great advertising can't be either/or. It must be &.
Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged
-----Original Message-----
From: Leigh [mailto:[email protected]]
Sent: Thursday, June 30, 2011 3:38 PM
To: cf-talk
Subject: RE: Stupid Question
> capability_detail is a query.
> It returns one and only one record...
Out of curiosity, what condition was your cfparam trying to prevent?
1) query contained 0 records
2) query did _not_ contain the column "capability_id"
..
?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346000
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
