I am trying to use the 2 selects and it not working the page just won't load. So I
know I don't have any bugs just that my query isn't running right and I am not
populating the selects right....
here is my query. Basically I have a table with lots of records. Using the first
select box I want to to show only the cpt codes from the 1st boxes list of locations.
the fees table has a idnumber, the locationid, the cpt code and some other data.
<CFQUERY NAME="FEES" DATASOURCE="#application.dsn#">
SELECT
tblcorp_fees_location.LOCATION,
tblcorp_fees_location.LOCATION_NUMBER,
tblcorp_fees_fees.LOCATION_ID,
tblcorp_fees_fees.CPT_CODE
FROM tblcorp_fees_fees INNER JOIN
tblcorp_fees_location ON tblcorp_fees_fees.LOCATION_ID =
tblcorp_fees_location.LOCATION_NUMBER
ORDER BY tblcorp_fees_location.LOCATION
</CFQUERY>
and here is my select boxes
<CF_TwoSelectsRelated
QUERY="FEES"
NAME1="LOCATION"
NAME2="CPT"
DISPLAY1="location"
DISPLAY2="cpt_code"
VALUE1="location_id"
VALUE2="cpt_code"
FORCEWIDTH1="70"
FORCEWIDTH2="70"
SIZE1="1"
SIZE2="1"
HTMLBETWEEN="<BR>"
AUTOSELECTFIRST="Yes"
EMPTYTEXT1="(choose a location)"
EMPTYTEXT2="(now choose a cpt code)"
FORMNAME="twoselect">
Anyhelp would be appreciated......its been a long day....
thanks
mike
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
