aspose file tools
The moose likes JDBC and the fly likes SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "SELECT * FROM studentrecords where [student id]= Watch "SELECT * FROM studentrecords where [student id]= New topic
Author

SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql

amrish sharma
Greenhorn

Joined: Sep 24, 2009
Posts: 20
posted private message
0
Quote
where 1234 is under [student id]
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5536

I like...
Android Eclipse IDE Ubuntu
posted
0
Quote
Is studentid a character column or a numeric column? If numeric, does it work if you remove the quotes? Are you sure there is a studentrecord with that studentid? Are you getting an error, or just no rows selected?

JBoss In Action
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: SELECT * FROM studentrecords where [student id]='1234' doesnt returning the first row in mssql
 
Similar Threads
convert from decimal to byte array but base 8
url rewrite
what does hiobernate Session's update work ?
generate Unique key
How to store composite objects in Hibernate