Error when searching records.

• Sagar Sawant

  SSC Eights!

  Points: 853

  More actions

  August 25, 2010 at 7:51 am

  #226210

  Hi,

  Encryption decryption done on one table in DB.

  But When searching records on one page. I'm getting below error. But in other pages it's works good.

  Incorrect syntax near 'Access'. Invalid value 0 for state. Valid range is from 1 to 127.

  Does any one know about this.

• Mike01

  SSChampion

  Points: 11395

  More actions

  August 25, 2010 at 12:34 pm

  #1211850

  how about some DDL, sample data, expected output and what you have tried? Not much to go on with what you've provided

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/