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\RECbik edetail.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...

SEARCH PAGE...
<td><div align="center">
<cfselect name="StreetDir"
required="no">
<option value=""></option>
<option value="N">NORTH</option>
<option value="S">SOUTH</option>
<option value="E">EAST</option>
<option value="W">WEST</option>
</cfselect>
</div></td>

RESULTS PAGENot displayed on the results page just processed)

<cfset WhereClause = " 0=0 ">
<!--- Build subclause for Street Direction --->
<cfif Form.StreetDir IS NOT "">
<cfset WhereClause = WhereClause & " and StreetDir = '" & form.StreetDir &
"'" >
</cfif>


and on the DETAILS/UPDATE PAGE:

<td><div align="center">
<cfselect name="StreetDir"
value="#BikeResult.StreetDir#"
required="no">
<option value=""></option>
<option value="N">NORTH</option>
<option value="S">SOUTH</option>
<option value="E">EAST</option>
<option value="W">WEST</option>
</cfselect>
</div></td>

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

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

Phil

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...

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.

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...