Daniel,

I maintain the driver. I don't know of any problems with updates. I have seen 
"subscript is out of bounds:1" when the server gets really overloaded, but 
not subscript 2. 

Here are some questions that come to mind.

-did it ever work?
-do updates to other tables work?
-do updates to this table work if you exclude the field named 'next'?
- what version of mysql server, what platform?
- what happens if you try the same update  from the mysql client instead of 
squeak? 

If you'd care to send me the table definition (eg mysqldump would be one way), 
I can take a look. 

-Alan

On Sunday 10 April 2005 19:13, Daniel Salama wrote:
> In addition, I am able to insert, delete, and select using the exact
> same code with no problems. I just can't update. Any clues?
>
> Thanks,
> Daniel
>
> On Apr 10, 2005, at 12:52 PM, Daniel Salama wrote:
> > I'm trying to execute an UPDATE SQL statement and every time I run it,
> > I get an exception. Is there a specific way of doing this?
> >
> > Socket initializeNetwork.
> > spec := (JdmConnectionSpec new initialize
> >  user: 'master'; password: 'secret';
> >  host: (NetNameResolver addressForName: 'localhost');
> >  database: 'dcm'; port: 3306).
> > connection := JdmConnection on: spec.
> > statement := connection createStatement.
> > nextCustomerNo := 1.
> > updateSQL := 'update tests set next = ', (nextCustomerNo asString), '
> > where sequence = ''CustomerNo'''.
> > statement executeQuery: updateSQL.
> >
> > This generates: "Error: subscript is out of bounds: 2" exception.
> >
> > Any ideas anyone?
> >
> > Thanks,
> > Daniel