Search results for query: *

I'm trying to query a table and get back 'something' from which I can extract the table's column names and types. At the moment I'm using meta data (Java) but need at least one record in my ResultSet to be able to get the meta data in the first place. So... 1. How can I select just one...

I'm querying mySQL tables quite happily from a Java application but .... If a create a query in mySQL itself can I then save it somewhere on the server and then run a query on that saved query! ... or would it be best to just build the entire query into one SQL statement and run that from the...

insulting the expertise of many of you I know but ... I've installed MSDE from win200 disk but am not getting any icons in the task bar and can't work out how to open the Service manager. I don't think it has installed correctly. Any advice? Thanks.

I have a simple table containing personID-choiceID pairs. I want to retrieve PersonIDs that have opted for one choice and another and another etc... Using an intersect query may not be the best way but ... (SELECT * from <table> WHERE choiceID= [variable]) intersect (SELECT * from <table> WHERE...

is it possible to find out the username of the person running a java application under windows2000. I've got an application running on a windows2000 network and i want it to automatically get the username of the person logged on. KJS

I'm trying to connect to mySQL using a servlet and the sun.jdbc.odbc.JdbcOdbcDriver. I think the driver is found but i get the message 'no suitable driver' when i try: DriverManager.getConnection(&quot;jdbc:mySQL://localhost:3306/test&quot;);