Date query (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

wtpandar -> Date query (12/23/2004 0:47:33)

I am having some troubles with the SQL query. What i have is

String date = "01/12/2004";

"SELECT * FROM Computers WHERE purchaseDate = "+date+";";

But returned is nothing... ie nothing matching

Any help???
Thanks



BeTheBall -> RE: Date query (12/23/2004 13:31:37)

Welcome to Outfront. Is that the actual code you are using? I have never seen anyone use a space in a variable name. Does this get you anywhere?

Strdate = "01/12/2004";

"SELECT * FROM Computers WHERE purchaseDate = "+Strdate+""



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875