List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:June 8 2005 12:00pm
Subject:Re: Query Problems
View as plain text  
John Heinig wrote:
> 
>              1, 5,              // explained in the user manual

Are you sure that these are the right numbers?

> 	writeQuery.replace(updatedRow);

You know that a replace query can either insert data, or replace it, 
depending on your indexes, right?  Have you checked that you aren't 
simply replacing an existing row with the same key(s)?

> VALUES
> (33281,'bot',2,'Triple.Agente.CVCD.DVDrip.[www.TodoCVCD.com].mpg','http://tracker.prq.to/announce','5f4f6da7e3bad30bad2ccb7f51629a8d5abb41d1','http://thepiratebay.org/download.php/3316054/Triple.Agente.CVCD.DVDrip.%5Bwww.TodoCVCD.com%5D1.torrent',1,0,'Unknown',817402172,'2005-05-14','single',1,'','','no',1,'2005-05-14',6)

You said you "typed" the query into another tool, but did you actually 
cut and paste this exact query, or did you type something else?
Thread
Query ProblemsJohn Heinig8 Jun
  • Re: Query ProblemsWarren Young8 Jun
Re: Query ProblemsWarren Young8 Jun
Re: Query ProblemsWarren Young8 Jun
Re: Query ProblemsWarren Young8 Jun