Skip to main content
P
perezn470
Known Participant
July 21, 2008
Question

UPDATING BIKE LICENSE PAGE

  • July 21, 2008
  • 2 replies
  • 527 views
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...
    This topic has been closed for replies.

    2 replies

    M
    MGTF
    Participant
    July 24, 2008
    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.
    P
    perezn470Author
    Known Participant
    July 25, 2008
    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...
    D
    Dan_Bracuk
    Inspiring
    July 21, 2008
    Your error message is very specific and tells you exactly what the problem is. Is there something about it you don't understand?
    P
    paross1
    Participating Frequently
    July 21, 2008
    Really..... sounds like a job for plain old <SELECT> since he isn't using it with a query.....

    Phil
    P
    perezn470Author
    Known Participant
    July 24, 2008
    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...
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices