sql select statement

Results 1 to 2 of 2

Thread: sql select statement

  1. #1
    chang Guest

    Default sql select statement

    I have a systax error with the codes below near the "Index". I cannot see anything wrong with it. Please help if you see it.<BR><BR><BR>objCommand.CommandText = "select Index, UID, SubmitDate, TicketNumber from SpecificSurvey where SubmitDate&#062;&#039;"&ReportRange&"&#039; order by SubmitDate"<BR>

  2. #2
    rwadkins@tsccg.com Guest

    Default RE: sql select statement

    I&#039;m guessing here, but Index is an important word to SQL Server. Try your query without that column to see if it works. Also try your query with [Index] instead of Index to let SQL Server know that Index is a column name and not an Index.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts