0 Replies - 4202 Views - Last Post: 16 May 2012 - 09:50 AM Rate Topic: -----

#1 rikkp  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 17
  • Joined: 26-March 12

Error Executing Database Query

Posted 16 May 2012 - 09:50 AM

On my local machine (running CF 8) the code works fine
This is the error message that I am recieving when the code is run on the REMOTE server (CF 9)

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

here is the link pointing to the "StateData.cfm" action page

a href="StateData.cfm?state=Rhode Island" target="_blank" title="Rhode Island results"

here is the action page code

<cfif IsDefined("url.State")>
<cfquery name="compareSoil" datasource="backpacklab">
select * from soilTest
where state = "#url.state#"
</cfquery>
</cfif>



This post has been edited by Craig328: 16 May 2012 - 11:08 AM


Is This A Good Question/Topic? 0
  • +

Page 1 of 1