====================
lakeID, lakeName
Guide Table
====================
guideID, companyName
Fusion Table
====================
fusionID, lakeID, guideID
Several solutions:
1. The two query solution:
<cfquery name="LakesQ" datasource="xxx">
Select LakeID, LakeName
>From Lakes
</cfquery>
<cfquery Name="ThisGuideQ">
Select LakeID
>From FusionTable
Where GuideID=<cfqueryparam blah blah>
</cfquery>
<cfset LakeList=ValueList(ThisGuideQ.LakeID)>
Then in your form:
<cfoutput query="LakesQ">
<input type="CheckBox" name="Lakes" value="#LakeID#" <cfif ListFind(LakeList,LakeID)>CHECKED</cfif>>#LakeName#<br>
</cfoutput>
2. One query solution
<cfquery name="LakesQ">
Select l.LakeID, l.LakeName,f.GuideID
>From Lakes l
Left Outer Join FusionTable f on f.LakeID=l.LakeID AND f.GuideID=(put the Guide ID here)
</cfquery>
Then:
<cfoutput query="LakesQ">
<input type="CheckBox" name="Lakes" value="#LakeID#" <cfif GuideID neq "">CHECKED</cfif>>#LakeName#
</cfquery>
It's late, and those are off the top of my head.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
