select sql

Results 1 to 3 of 3

Thread: select sql

  1. #1
    Join Date
    Dec 1969

    Default select sql

    can anyone tell me what is wrong with this sql statement<BR><BR>SELECT * FROM images WHERE site = &#039;mason&#039; AND month = &#039;5&#039; AND m_id = &#039;1&#039;

  2. #2
    Tim Snyder Guest

    Default RE: select sql

    If month is numeric than remove "&#039;"

  3. #3
    Join Date
    Dec 1969

    Default RE: select sql

    what are the datatypes for month and m_id ??if they are numeric you wont need the single quotes -- if month is a date their may be other requirements depending on which db you are using<BR><BR>Bob

Posting Permissions

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