Hi Micheal, I had exactly the same problem and was unable to solve it. It expects something specific from the query. I used their sample table and it works. When I get my query to return exactly the same thing with my table, the only difference being an extra ID field. The only thing I can think of is the the first column must be the primary key.
Please let me know if you find a solution, Thanks ----- Original Message ----- From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 4:31 PM Subject: 2 Selects killing me > 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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists