...

View Full Version : Sql Where



hughesmi
12-21-2004, 11:30 AM
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

Roelf
12-21-2004, 11:37 AM
Try


strSQL = "SELECT * FROM Data WHERE NameID=" & NameID & " ORDER BY Date_Late"

hughesmi
12-21-2004, 11:52 AM
Done and working. Thanks :thumbsup:



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum