This was the script for access:
oRS.Open "Select * from AlertHistory Where Date
=#"&DateValue(LogTimeStamp)&"#;",oConn
does anyone know the equivalent for sql server?
Cheers!
Try replacing # with single quote (').
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment