Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Sql Where

  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    UK
    Posts
    302
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Sql Where

    Hi all.

    Could someone have look this for me? I want to set the Date_Late by Order By.

    But the IIS error message is coming up "Expected end of statement". I have try different combinations of the statement and even looked around net . So yet again can Coding Forums Help?

    strSQL = "SELECT * FROM Data WHERE NameID=" & NameID ORDER BY Date_Late
    Kind regards,
    Mike Hughes

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    Try
    Code:
    strSQL = "SELECT * FROM Data WHERE NameID=" & NameID & " ORDER BY Date_Late"
    I am the luckiest man in the world

  • #3
    Regular Coder
    Join Date
    Jul 2002
    Location
    UK
    Posts
    302
    Thanks
    16
    Thanked 0 Times in 0 Posts
    Done and working. Thanks
    Kind regards,
    Mike Hughes


  •  

    Posting Permissions

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