Skip to main content
A
ajdklfajdlk
Inspiring
April 28, 2008
Answered

query in CF7 works but not in CF8

  • April 28, 2008
  • 2 replies
  • 499 views
I've got a site that i just moved from CF7 to CF8. Some of our queries are no longer working on 8 where they worked fine on 7. The following query chokes with
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Anybody got any ideas?

    This topic has been closed for replies.
    Correct answer ajdklfajdlk
    Apparently it's the double quotes in "d" that cause the problem. I replaced them with single quotes query runs perfectly.

    2 replies

    N
    Newsgroup_User
    Inspiring
    April 29, 2008
    also chack that you are using same connector drivers.
    iirc, when i migrated from cf7 to cf7 my dsn that used MS Access Driver
    was changed by the updater to MS Access with Unicode Driver... or the
    other way around...

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/
    A
    ajdklfajdlkAuthor
    Inspiring
    April 29, 2008
    Azadi,

    I believe it was a driver issue, because i tested my app with CF8 development edition (worked fine) and then uploaded to our webserver (also CF8) and the problem occurred. So that would mean it's a driver issue.
    A
    ajdklfajdlkAuthorCorrect answer
    Inspiring
    April 29, 2008
    Apparently it's the double quotes in "d" that cause the problem. I replaced them with single quotes query runs perfectly.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices