query string problems

Results 1 to 3 of 3

Thread: query string problems

  1. #1
    danscan Guest

    Default query string problems

    update tblinfect_test set score=&#039;50&#039;, date=&#039;6/11/01&#039; where infect_test_ID =64 <BR><BR>All score is a string, date is a data/time and infect_test_id is a number. The record does exist I can&#039;t figure it out. It fails and hightlights "date".

  2. #2
    Join Date
    Dec 1969

    Default RE: query string problems

    date is a keyword... try [date] = &#039;6/11/01&#039;<BR><BR>or better yet, try naming the field something different.

  3. #3
    danscan Guest

    Default thanks.

    Can&#039;t see the forest because of the trees. Why can&#039;t the debugger be a little me specific instead of "syntax error".<BR><BR>thanks

Posting Permissions

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