|
| |
|
|
wtpandar
Posts: 1
Joined: 12/23/2004
Status: offline
 |
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
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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+""
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
