3 Replies Latest reply on May 20, 2013 10:09 AM by iccsi


    iccsi Level 1

      I would like to use user input as CFQUERYPARAM for example,

      I have txtMyID on the form and would like to use user input as my query parameter.


      I tried to use


        <cfqueryparam value = "#trim(form.txtMyID)#" CFSQLTYPE = "cf_sql_integer">


        but does not work,



      I tried the following which works, but I need get the value from user enter.


        <CFSET MyID = "1">

        <cfqueryparam value = "#MyID#" CFSQLTYPE = "cf_sql_integer">



      Your help and information is great appreciated,





        • 1. Re: CFQUERYPARAM
          BreakawayPaul Level 2

          Can you see if cf_sql_numeric works as the type?  I've had problems with integer before.  Also, make sure the data type of your column matches whatever your CFSQLTYPE is.

          • 2. Re: CFQUERYPARAM
            mkane1 Level 1

            The problem is likely with the value of trim(form.txtMyID). Directly using FORM variables is not a good idea, for a variety of reasons. It is better to initialize all your variables as uniquely named local page variables, and then assign values from FORM or other inputs after validating them.


            <cfset ThistxtMyID = "0">

            <cfif IsDefined("FORM.txtMyID") AND IsValid("integer", Trim(FORM.txtMyID)>

                <cfset ThistxtMyID = Trim(FORM.txtMyID)>



            Be sure to validate ThistxtMyID before you try to use it:


            <cfif ThistxtMyID EQ "0">

            handle this error condition, don't query the database


            • 3. Re: CFQUERYPARAM
              iccsi Level 1

              Thanks a million for the information and help,