ResultSet Problem

2001-06-27 Thread AVDHUT SHEDGE


I am giving a query to MySQL which contains order by RowNo.When i give this query on 
mysql prompt it gives me resultset in ascending order,but when i give the same query 
through java program(servlet) it gives me resultset in descending or any random order.

before yesterday everything was working fine.i have not made any changes to my java 
program.

Need help urgently.

thankx.
 

_
Buy Lagaan  Yaadein music for 30% less.
Avail this special offer at 
http://shopping.rediff.com/shopping/music/offerrediffmailer.htm 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to Configure MySQL with JRUN

2001-06-01 Thread AVDHUT SHEDGE

We want to Configure MySQL database to JRUN as a jdbc datasource (Native).
If Anybody knows ,Please give reply.

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Query regarding backup of database

2001-05-14 Thread AVDHUT SHEDGE

how to copy database from one pc to another without networking

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to transfer database from one machine to another without network

2001-05-13 Thread AVDHUT SHEDGE

i have created a database ,Now i want to copy it on the server. Is there any way to do 
it or i have to make tables on the servers 
if anybody knows
please reply a.e.a possible.

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




in SQL query can we use sysdate to get System date

2001-05-10 Thread AVDHUT SHEDGE

in SQL query can we use sysdate to get System date like Oracle

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Regarding SQL query with Unique

2001-05-08 Thread AVDHUT SHEDGE

We want to get the Unique value from a table.
can we use the following query:

select unique(ProblemNo) from MainProblem;

where MainProblem is a Table having Column ProblemNo.

the contents of ProblemNo are 
1
1
2
2
3
3
3

the result of the above query must be :
1
2
3

Thank You.


_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php