IPMCenters.org national site

Affected URL: http://www.ipmcenters.org/Ecotox/Details.cfm?RecordID=9112

Error:

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.

The error occurred in E:/inetpub/wwwroot/ipmcenters.org/Ecotox/Details.cfm: line 84
82 : select *
83 : from tblLabcodes
84 : where  strLabCode = <CFQUERYPARAM Value="#getall.Labcode#">
85 : </cfquery>
86 : 

• Browse to IPMCenters.org
• Datasources > Pesticide Information > OPP Pesticide Ecotoxicity Database
• Database Access
• Select Pesticide Name: "Potassium oleate/Methoxychlor MIS 16 mixture", Submit Request
• "Potassium oleate/Methoxychlor MIS 16 mixture"

Reported by Kathleen Stanton via feedback form (see attached error report).

Cause:
In Ecotox section of IPMCenters.org site, updated database seems to have different field names in table tblLabCodes. Causing errors in pesticide detail page.

• Edit field names in database table tblLabCodes to correspond to existing code
  • Rename "Laboratory Name" to "strLabName"
  • Rename "LabCode" to "strLabCode"
• Edit code to correspond to new database field names
  

  <cfquery name="getlab" datasource="ecotox">
  select [Laboratory Name] AS strLabName
  from tblLabcodes
  where  LabCode = <CFQUERYPARAM Value="#getall.Labcode#">
  </cfquery>