ThreeSelectsRelated

[PaulBW]

Why does it not work

<cfquery name="cars" datasource="#db#">

SELECT apn_makes.make, apn_models.model, apn_trims.trim

FROM apn_makes, apn_models, apn_trims

WHERE apn_models.make_id = apn_makes.id

AND apn_trims.model_id = apn_models.id

order by make,model,trim

</cfquery>

<FORM ACTION="index.cfm" METHOD="POST">

<CF_ThreeSelectsRelated

  QUERY="cars"

  NAME1="make"

  NAME2="model"

  NAME3="trim"

  VALUE1="make"

  VALUE2="model"

  VALUE3="trim"

  DISPLAY1="make"

  DISPLAY2="model"

  DISPLAY3="trim"

  WIDTH1="150"

  WIDTH2="150"

  WIDTH3="150"

  FORCEWIDTH1="40"

  FORCEWIDTH2="40"

  FORCEWIDTH3="40"

  EMPTYTEXT1="choose a make"

  EMPTYTEXT2="choose a model"

  EMPTYTEXT3="choose a trim"

  FORM="carForm">

<INPUT TYPE="Submit">

</FORM>

<cfoutput query="cars">

#make# - #model# - #trim#<br>

</cfoutput>

Here is the file: http://autopronetwork.com/newcar/index.cfm

Any help is appreciated...

[Dan_Bracuk]

Looks like something wrong with your custom tag.