3 Replies Latest reply on Sep 25, 2006 2:38 AM by Newsgroup_User

    QoQ unsupported numeric type??

    Level 7
      Hi,

      Has anyone successfully used CF_Select from Masrizal? I bought the code only
      to find that it's not working with dynamic options.
      Would appreciate suggestions on how to get this to work. TIA

      THis error is coming from this code in the Tag.

      <cfquery dbtype="query" name="qryTemp">
      select * from qryTemp
      order by parent
      </cfquery>
      Error Executing Database Query.

      Query Of Queries runtime error.
      Query Of Queries runtime error.
      Unsupported Numeric type conversion in Query of Queries.







      My Code:
      <cfquery name="getPA" datasource="bibs2">
      select PraticeArea, PraticeAreaID from bibs_tblPraticeArea
      where DeleteFlag = 0 order by PraticeArea
      </cfquery>

      <cfquery name="getBibs" datasource="bibs2">
      Select *
      from bibs_tblBibliographies
      where DeleteFlag = 0
      Order by DateModified Desc
      </cfquery>


      <table border="0">
      <form name="test" action="example.cfm" method="post">
      <tr><td>Pratice Area</td>
      <td>
      <cf_select name="PraticeArea" formname="test"
      passthrough="style='background-color:##000000; color:##ffffff;'">
      <cf_option value="">Select Pratice Area</cf_option>
      <cfoutput query="getpa">
      <cf_option value="#PraticeAreaID#">#PraticeArea#</cf_option>
      </cfoutput>
      </cf_select>
      </td>
      </tr>

      <tr><td>Bibs</td>
      <td>
      <cf_select name="BiBs" parent="PraticeArea" formname="test"
      passthrough="style='background-color:##000000; color:##ffffff;'">
      <cf_option value="" parent="">Select Bib</cf_option>
      <cfoutput query="getBibs">
      <cf_option value="#BIBSID#"
      parent="#PraticeArea#">#Title#</cf_option>
      </cfoutput>
      </cf_select>
      </td>
      </tr>

      <tr>
      <td>
      <br>
      <input name="Submit" type="Submit">
      </td>
      </tr>
      </form>

      <!--- view posted form --->
      <cfif isdefined("form.Submit")>
      <tr>
      <td >
      <hr>
      <cfoutput>
      You have selected this:<br>
      <cfloop collection="#form#" item="key">
      <cfif key neq "fieldnames" and key neq "submit">
      #Key#: #evaluate("form.#key#")#<br>
      </cfif>
      </cfloop>
      </cfoutput>
      </td>
      </tr>
      </cfif>
      </table>






        • 1. Re: QoQ unsupported numeric type??
          Level 7
          > order by parent

          > Unsupported Numeric type conversion in Query of Queries.

          I presume "parent" is a numeric column? I also suspect it has some null
          values in it. That'll cause this sort of error. QoQ is a bit flaky like
          that.

          --
          Adam
          • 2. Re: QoQ unsupported numeric type??
            Stefan_K.
            Quick guess:
            QueryNew() is somewhere used, but without the optional datatype-attribute.
            This results in CF scanning the first 20 rows and thus guessing the datatype (same with Excel as ODBC-datasource) and can result in the mentioned errors ...
            • 3. Re: QoQ unsupported numeric type - Solution!
              Level 7
              Solution: #jsstringformat()#

              Example:
              <cf_select name="PraticeArea" formname="test"
              passthrough="style='background-color:##000000; color:##ffffff;'">
              <cf_option value="">Select Pratice Area</cf_option>
              <cfoutput query="getpa">
              <cf_option
              value="#jsstringformati(PraticeAreaID)#">#PraticeArea#</cf_option>
              </cfoutput>
              </cf_select>


              <cf_select name="BiBs" parent="PraticeArea" formname="test"
              passthrough="style='background-color:##000000; color:##ffffff;'">
              <cf_option value="" parent="">Select Bib</cf_option>
              <cfoutput query="getBibs">
              <cf_option value="#jsstringformat(BIBSID)#"
              parent="#jsstringformat(PraticeArea)#">#Title#</cf_option>
              </cfoutput>
              </cf_select>


              thanks for all the respond!



              "is" <myis10-noreply@covad.net> wrote in message
              news:eeu0uv$s3p$1@forums.macromedia.com...
              > Hi,
              >
              > Has anyone successfully used CF_Select from Masrizal? I bought the code
              only
              > to find that it's not working with dynamic options.
              > Would appreciate suggestions on how to get this to work. TIA
              >
              > THis error is coming from this code in the Tag.
              >
              > <cfquery dbtype="query" name="qryTemp">
              > select * from qryTemp
              > order by parent
              > </cfquery>
              > Error Executing Database Query.
              >
              > Query Of Queries runtime error.
              > Query Of Queries runtime error.
              > Unsupported Numeric type conversion in Query of Queries.
              >
              >
              >
              >
              >
              >
              >
              > My Code:
              > <cfquery name="getPA" datasource="bibs2">
              > select PraticeArea, PraticeAreaID from bibs_tblPraticeArea
              > where DeleteFlag = 0 order by PraticeArea
              > </cfquery>
              >
              > <cfquery name="getBibs" datasource="bibs2">
              > Select *
              > from bibs_tblBibliographies
              > where DeleteFlag = 0
              > Order by DateModified Desc
              > </cfquery>
              >
              >
              > <table border="0">
              > <form name="test" action="example.cfm" method="post">
              > <tr><td>Pratice Area</td>
              > <td>
              > <cf_select name="PraticeArea" formname="test"
              > passthrough="style='background-color:##000000; color:##ffffff;'">
              > <cf_option value="">Select Pratice Area</cf_option>
              > <cfoutput query="getpa">
              > <cf_option value="#PraticeAreaID#">#PraticeArea#</cf_option>
              > </cfoutput>
              > </cf_select>
              > </td>
              > </tr>
              >
              > <tr><td>Bibs</td>
              > <td>
              > <cf_select name="BiBs" parent="PraticeArea" formname="test"
              > passthrough="style='background-color:##000000; color:##ffffff;'">
              > <cf_option value="" parent="">Select Bib</cf_option>
              > <cfoutput query="getBibs">
              > <cf_option value="#BIBSID#"
              > parent="#PraticeArea#">#Title#</cf_option>
              > </cfoutput>
              > </cf_select>
              > </td>
              > </tr>
              >
              > <tr>
              > <td>
              > <br>
              > <input name="Submit" type="Submit">
              > </td>
              > </tr>
              > </form>
              >
              > <!--- view posted form --->
              > <cfif isdefined("form.Submit")>
              > <tr>
              > <td >
              > <hr>
              > <cfoutput>
              > You have selected this:<br>
              > <cfloop collection="#form#" item="key">
              > <cfif key neq "fieldnames" and key neq "submit">
              > #Key#: #evaluate("form.#key#")#<br>
              > </cfif>
              > </cfloop>
              > </cfoutput>
              > </td>
              > </tr>
              > </cfif>
              > </table>
              >
              >
              >
              >
              >
              >