Error Occurred While Processing Request

Error Diagnostic Information

An error has occurred while processing the expression:

SELECT DISTINCT Base2.Company,Base2.FullName,Base2.Title,Base2.Add1,Base2.Add2,Base2.City,Base2.State,Base2.Zip,Base2.Country,Base2.Phone,Base2.Fax,Base2.Email,Base2.Url,Search_Cat.Search_Category FROM Base2,Search_Cat, Link WHERE Base2.Company_ID = Link.Company_ID AND Search_Cat.ID = Link.Cat_ID AND Base2.Company_ID = #Base2__Company_ID#

The error occurred on (or near) line 8 of the template file c:\fibersource\website\docs\f-info\Detail.CFM.

     2:      on the Detail Page. It uses the Unique Identifier field
     3:      passed in the URL link that is invoked when user clicks
     4:      on a record on the Results Page to retrieve the detail record.--->
     5: 
     6: <!---Run the query using the Unique Identifier passed in the URL.--->
     7: 
     8: <CFQUERY NAME="GetDetailData" DATASOURCE="Search">
     9:        SELECT DISTINCT Base2.Company,Base2.FullName,Base2.Title,Base2.Add1,Base2.Add2,Base2.City,Base2.State,Base2.Zip,Base2.Country,Base2.Phone,Base2.Fax,Base2.Email,Base2.Url,Search_Cat.Search_Category

Error resolving parameter BASE2__COMPANY_ID

Cold Fusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:

  1. You have misspelled the parameter name, or
  2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.

Date/Time: 04/09/04 23:02:45
Browser: ia_archiver
Remote Address: 209.237.238.172
Template: c:\fibersource\website\docs\f-info\Detail.CFM