R: R: connectorJ & huge table problem

2004-06-24 Thread Leonardo Francalanci
> Leonardo, > > Earlier you said that a statement without a parameter ('?') works, but > one with a parameter doesn't. > > In both cases, are you still using a PreparedStatement? > > -Mark > yes, it is always a preparedstatement. If you need more details (or you want me to try something

Re: R: R: connectorJ & huge table problem

2004-06-22 Thread Fagyal, Csongor
Richard F. Rebel wrote: Next time you come over, maybe you can help hold him or take the shot. He's such a pain to take pictures of, he walks right up to the camera. Yeah, I also have problems taking snapshots of my cat... use FEL to pre-flash so he won't blink when you take the actual pictur

Re: R: R: R: connectorJ & huge table problem

2004-06-22 Thread SGreen
tel.ie> Fax to: Subject: R: R: R: connectorJ & huge ta

R: R: R: connectorJ & huge table problem

2004-06-22 Thread Leonardo Francalanci
> Next time you come over, maybe you can help hold him or take the shot. > He's such a pain to take pictures of, he walks right up to the camera. Mmmh... my English is very bad... I can't understand... is it a joke or just a mistake? -- MySQL General Mailing List For list archives: http://lis

Re: R: R: connectorJ & huge table problem

2004-06-22 Thread Richard F. Rebel
Next time you come over, maybe you can help hold him or take the shot. He's such a pain to take pictures of, he walks right up to the camera. On Tue, 2004-06-22 at 09:50, Leonardo Francalanci wrote: > > It looks as if you are being over-complex anyway. Isn't what you want > > > > SELECT * FROM

R: R: connectorJ & huge table problem

2004-06-22 Thread Leonardo Francalanci
> It looks as if you are being over-complex anyway. Isn't what you want > > SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ; > > which picks a single random record. No, I have to know which is the ID I pick before doing the select (because I splitted my data, and when I access the splitted