hughesmi
12-21-2004, 12:30 PM
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? :confused:
strSQL = "SELECT * FROM Data WHERE NameID=" & NameID ORDER BY Date_Late
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? :confused:
strSQL = "SELECT * FROM Data WHERE NameID=" & NameID ORDER BY Date_Late