All of my data is in one table with one ID so i needed to modify the included page and the CFC queries and the script below to refelct that. I don't get errors but still no data being inserted into the dropdowns.
<cfquery name="get_years" datasource="DSN">
SELECT YearRange
FROM ExactFit2012
ORDER BY YearRange
</cfquery>
<cfquery name="get_makes" datasource="DSN">
SELECT make
FROM ExactFit2012
ORDER BY Make
</cfquery>
<cfquery name="get_models" datasource="DSN">
SELECT model
FROM ExactFit2012
ORDER BY model
</cfquery>
Origional Code:
<cfquery name="get_states" datasource="mydsn">
SELECT state_id,state
FROM tbl_states
ORDER BY state
</cfquery>
<cfquery name="get_counties" datasource="mydsn">
SELECT county_id,state_id,county
FROM tbl_counties
ORDER BY state_id,county_id
</cfquery>
<cfquery name="get_destinations" datasource="mydsn" maxrows="1">
SELECT state_id,county_id,destination_id,destination_name
FROM tbl_destinations
WHERE destination_id = '0'
ORDER BY state_id,county_id
</cfquery>
<cfscript>
Year = QueryNew("YearRange","Varchar");
for(i=1; i LTE get_years.RecordCount; i=i+1){
newRow = QueryAddRow(Year);
QuerySetCell(Year, "YearRange", "#get_years.YearRange[i]#");
}
make = QueryNew("YearRange, make", "Varchar, Varchar");
for(i=1; i LTE get_makes.RecordCount; i=i+1){
newRow = QueryAddRow(make);
QuerySetCell(make, "YearRange", #get_makes.YearRange[i]#);
QuerySetCell(make, "Make", #get_makes.make[i]#);
}
Model = QueryNew("YearRange, make, model", "Varchar, Varchar, Varchar");
for(i=1; i LTE get_models.RecordCount; i=i+1){
newRow = QueryAddRow(model);
QuerySetCell(model, "YearRange", #get_models.YearRange[i]#);
QuerySetCell(model, "make", #get_models.make[i]#);
QuerySetCell(model, "model", #get_models.model[i]#);
}
</cfscript>
Origional Code:
<cfscript>
State = QueryNew("state_id,state","Integer,Varchar");
for(i=1; i LTE get_states.RecordCount; i=i+1){
newRow = QueryAddRow(State);
QuerySetCell(State, "state_id", #get_states.state_id[i]#);
QuerySetCell(State, "state", "#get_states.state[i]#");
}
County = QueryNew("state_id, county_id, county", "Integer, Integer, Varchar");
for(i=1; i LTE get_counties.RecordCount; i=i+1){
newRow = QueryAddRow(County);
QuerySetCell(County, "state_id", #get_counties.state_id[i]#);
QuerySetCell(County, "county_id", #get_counties.county_id[i]#);
QuerySetCell(County, "county", "#get_counties.county[i]#");
}
Destination = QueryNew("state_id, county_id, destination_id, destination_name", "Integer, Integer, Integer, Varchar");
for(i=1; i LTE get_destinations.RecordCount; i=i+1){
newRow = QueryAddRow(Destination);
QuerySetCell(Destination, "state_id", #get_destinations.state_id[i]#);
QuerySetCell(Destination, "county_id", #get_destinations.county_id[i]#);
QuerySetCell(Destination, "destination_id", #get_destinations.destination_id[i]#);
QuerySetCell(Destination, "destination_name", "#get_destinations.destination_name[i]#");
}
</cfscript>
I deleted all the references to the _id fields from the code so that it might work with my data but i think i may have needed that.
|
