- see footer for list info -<
Can anyone see whats wrong with this please ...?
I have three tables .... Make, Model, and JoinmakeModel
Make has ford etc... Model has mondeo etc.... Join just lists which models
are for which makes ...
The Code......
<!--- store the selected Main_Group variable variable after the first select
boxes submits itself --->
<cfif isDefined('form.select_make')>
<cfset page.select_make = form.select_make>
</cfif>
<cfoutput>
<form name="DropDown" method="post">
<!--- query DB for the first drop down list --->
<!--- Get The Makes --->
<cfquery name="getMakes" datasource="#application.DSN#">
SELECT MakeIDPK, Make
FROM tblMakes
ORDER BY Make ASC
</cfquery>
<!--- first drop down list --->
<!--- NOTICE the onChange javascript event in the select tag, this is what
submits the form after the first selection --->
<select name="select_make" required="yes" onchange="this.form.submit()">
<option>Make</option>
<!--- dynamically populate the first drop down list based on the
getMakes query --->
<!--- NOTICE the CFIF within the option tag, this says, if the first
selection has been made, display the chosen option when the page reloads
--->
<cfloop query="getMakes">
<option value='#MakeIDPK#'
<cfif isDefined('form.select_make')>
<cfif form.select_make eq
#MakeIDPK#>selected
</cfif>
</cfif>>#Make#</option>
</cfloop>
</select>
<p>
<cfoutput>#page.select_Main_Group#</cfoutput><cfabort>
<!--- if the first selection has been made, display the second drop down
list with the appropriate results --->
<!--- query DB for second drop down list, based on the selected item from
the first list --->
<cfquery name="getModel" datasource="#application.DSN#">
SELECT tblJoinMakeAndModel.MakeIDFK,
tblModels.Model
FROM tblMakes
INNER JOIN tblJoinMakeAndModel ON tblMakes.MakeIDPK =
tblJoinMakeAndModel.MakeIDFK
INNER JOIN tblModels ON tblJoinMakeAndModel.ModelIDFK =
tblModels.ModelIDPK
WHERE (tblJoinMakeAndModel.MakeIDFK =
#page.select_Main_Group#)
</cfquery>
<!--- second drop down list --->
<select name="select_model" required="yes">
<option>Select Model</option>
<!--- dynamically populate the second drop down list based on the
get_model query --->
<cfloop query="getModel">
<option value="#ModelIDPK#">#Model#</option>
</cfloop>
</select>
</form>
</cfoutput>
I based it on the Ryan M BeMiller example.....
I keep getting this ....
You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members.
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
