3 Replies Latest reply on Sep 3, 2015 6:02 AM by BKBK

    Get form values

    nataliafoster26

      I have a form that is passing values like  this.

      GETL639NAVY 1649

      GETL639ORANGE 1653

      GETL639PURPLE 0

      GETL794BLACK 0

      GETL794NAVY 0

      GETL794SAHARA 0

      GETL794WHITE 0

      GETLST660BLUEWAKE 0

       

       

      When its not 0 I would like to get

      that specific record from a query

      select * from table

      where ID = '#number#'

        • 1. Re: Get form values
          EddieLotter Level 3

          Do you mean something like this?:

           

          <cfif form.GETL639NAVY neq 0>

          <cfquery name="theQuery">

            SELECT *

            FROM table

            WHERE ID = <cfqueryparam value="#form.GETL639NAVY#" CFSQLType='CF_SQL_INTEGER'>

          </cfquery>

          </cfif>

          • 2. Re: Get form values
            nataliafoster26 Level 1

            no sorry.

            that would be for that specific variable.

            But for all variables

            'GET....' if the variable is not equal to 0

            then i would like it to find the record in the table which is the ID

            • 3. Re: Get form values
              BKBK Adobe Community Professional & MVP

              <cfif isDefined("form.GETL639NAVY")>

                <!--- List of all form fields --->

                <cfset formFieldList = form.fieldnames>

               

                <cfloop list="#formFieldList#" index="formField">

               

                <cfif left(formfield,3) is "get" and isNumeric(form[formfield]) and form[formfield] is not 0><!---  Field-name begins with "get" and field value is a number other than 0--->

                     <cfquery name="#formfield#Query"><!---Distinguish dynamically between the queries --->

                      SELECT *

                       FROM TBL

                       WHERE ID = <cfqueryparam value="#form[formfield]#" CFSQLType='CF_SQL_INTEGER'>

                     </cfquery>

                </cfif>

               

                </cfloop>

              </cfif>