UPDATING BIKE LICENSE PAGE

[perezn470]

OK STUMMPED AGAIN...LOL.

I have a Search page then a results page then a details page then an details/update page then a confirmation page. I am just trying to set up a simple update page that will update the records that someone else filled in to correct any errors. When you type in the something to search for in the search page it goes fine. that populates the results page just fine, where i have a unique number as the link to the details/update page. but when you click on the link to take you to the details/update page, i keep running into issues. It seems to be centered on the fields that have a cfinput option in the search page. i am going to paste the areas from each page that give me the issues.
This is the error message i keep getting:
Attribute validation error for tag CFSELECT.
The value of the attribute QUERY is invalid. The 'Query' attribute must be defined if the 'Value', 'Display', or 'Group' attributes are defined.

The error occurred in C:\Inetpub\wwwroot\dashboard\Training\Bikes\RECbikedetail.cfm: line 82

80 : <td><div align="center">
81 : <cfselect name="StreetDir"
82 : value="#BikeResult.StreetDir#"
83 : required="no">
84 : <option value=""></option>

NEXT I AM ATTACHING THE ACTUAL CODE...

[Dan_Bracuk]

Your error message is very specific and tells you exactly what the problem is. Is there something about it you don't understand?

[paross1]

Really..... sounds like a job for plain old <SELECT> since he isn't using it with a query.....

Phil

[perezn470]

ok i have tried it with select and cfselect and it didnt work.

now i am thinking i have to add a parameter at the top but not sure what or how....lol.

and then i know i have to repeat it for all of the other multiple choice ones that are on there also. just need to be sent in the right direction...

[MGTF]

On line 82 of the first code snippet, you reference "#BikeResult.StreetDir#". This indicates that you are retrieving the value a table field named "StreetDir" with the query named "BikeResult" (e.g. <CFquery name = "BikeResult" datasource = somedatabase>). Make sure that your spelling and capitalization match on query name, fieldname.

[perezn470]

DONE AND DONE spelling and case all match.... it works for the regular search page just not this one that i am trying to set up to update records that need to be corrected. and it is just on those that have the multiple choice options in the <select> or <cfselect> that are giving me this message...