Post reply

error in parameterized query

  • February 4, 2008 at 5:55 am

    #181625

    i am trying to execute simple query on server 2000

    select * from employee where salary = ?

    but the query gives following error:

    [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error.

    if anyone know the reason, then kindly do reply.

  • February 4, 2008 at 6:31 am

    #774718

    What application are you using to execute the query?

    How have you specified the value for your parameter?

  • February 4, 2008 at 8:15 am

    #774755

    Please do not cross post. It wastes people's time.

    Please direct replies to the following thread -

    Error in parameterised query (SQL 2000)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 5, 2008 at 4:51 am

    #775056

    i am using query analyzer and want to take a input from user during run time. according to that input, query should give the result

  • February 5, 2008 at 5:13 am

    #775067

    Query analyser does not work like MS Access does. See the reply to your other post on this.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply