Right,
So who exactly wins out in the battle of the variable values?
I have a parameter declared: FPSiteTypeID
I have a query (getFieldPlacementSites) that gets a row from the
database. One of the columns in that row is FPSiteTypeID. I also have
a query (getFieldPlacementSiteTypes) that gets a lookup/mapping of
these FPSiteTypeIDs
There is a select box that I offer for the client to select these
FPSiteTypeIDs.
This is how the flow looks then.
<code>
<cfparam name="FPSiteTypeID" default="0">
<cfquery datasource=dsn name=getFieldPlacementSites>
SELECT blah1, blah2, FPSiteTypeID
FROM thisTable
WHERE someID = #ID#
</cfquery>
<cfquery datasource=dsn name=getFieldPlacementSiteTypes>
SELECT FieldPlacementSiteTypeID, FieldPlacementSiteType -- (notice the
different name from FPSiteTypeID)
FROM FieldPlacementSiteTypes
</cfquery>
<cfloop query=getFieldPlacementSites>
<select id="FPSiteTypeID" name="FPSiteTypeID">
<cfloop query="getFieldPlacementSiteTypes">
<option value="#FieldPlacementSiteTypeID#"<cfif
FieldPlacementSiteTypeID EQ FPSiteTypeID>
selected="selected"</cfif>>#FieldPlacementSiteType#</option>
</cfloop>
</select>
</cfloop>
</code>
Well, everytime this is run, the value of FPSiteTypeID in the <cfif >
statement comes out to be 0 (the default value) instead of the value
from the query (getFieldPlacementSites). Why?
TIA,
George
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182329
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
