SQL statement

Results 1 to 3 of 3

Thread: SQL statement

  1. #1
    Whsiao Guest

    Default SQL statement

    I have the following SQL statement trying to retrieve a record from an ACCESS DB using ASP, MCINo is a text datatype, and trtStart is a date datatype. When I run it, it returns an empty set even when the record is there.... I tried with MCINo=&#039;23423423" without the trtStart part and it works.... I am wondering if my expression for date value is wrong... can someone help?<BR><BR><BR>SELECT * FROM treatment_Latent WHERE (MCINo =&#039;23423423&#039; AND trtStart =03/03/2111)<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: SQL statement

    try this<BR><BR>SELECT * FROM treatment_Latent WHERE MCINo =&#039;23423423&#039; AND trtStart = #03/03/2111#<BR><BR><BR>you sure the year should be 2111

  3. #3
    Whsiao Guest

    Default Great, it worked, 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