1 Reply Latest reply on Apr 17, 2007 11:09 AM by Newsgroup_User

    Query Of Queries runtime error

    FREELIFERK
      Hi:

      I'm getting below error:

      Error Executing Database Query.

      Query Of Queries runtime error.
      Table named "Results" was not found in Memory. It is misspelled, or the table is not defined.


      The error occurred in E:\Inetpub\wwwroot\info\spn.cfm: line 470
      468 :
      469 : <!--- Get the Number of records on the user's first level --->
      470 : <cfquery name="FrontLine" dbtype="query">
      471 : SELECT *
      472 : FROM Results

      below is the code from .cfm file

      <cfstoredproc datasource="#Constant.DataSource#" procedure="SP_RESULTS">
      <cfprocparam type="in" dbvarname="@TableName" cfsqltype="CF_SQL_VARCHAR" value="#Local.TableName#">
      <cfprocparam type="in" dbvarname="@ID" cfsqltype="CF_SQL_INTEGER" value="#Client.LoginID#">
      <cfprocparam type="out" dbvarname="@TableExists" cfsqltype="CF_SQL_INTEGER" variable="Local.TableExists">
      <cfprocresult resultset="1" name="Results">
      </cfstoredproc>

      <!--- Get the Number of records on the user's first level --->
      <cfquery name="FrontLine" dbtype="query">
      SELECT *
      FROM Results
      WHERE Depth = 1
      </cfquery>