I think I had the same problem. Gerald proposed to set up another object
with single table or something similar.
Angus Lees wrote:
>
> On Mon, Dec 10, 2001 at 10:10:40AM +0100, Robert wrote:
> > Angus Lees wrote:
> > > DBIx::Recordset::SQLInsert():
> > > return $self->do ("INSERT INTO $self->{'*Table'} ($fields) VALUES ($vals)") ;
> > >
> > > $self->{'*Table'} seems to be "table1,table2,table3" for each table in
> > > $self->Links. I presume this came from BuildFields().
> > >
> > > needless to say, "INSERT INTO table1,table2,table3 .." is invalid SQL.
>
> > Multitable insert/update has been in TODO for quite some time... ;-)
>
> i'm setting up a DBIx::Recordset object involving some links and !LinkName=2.
> later i try Execute(=insert => 1), which fails.
>
> i'm guessing (without much investigation) that the LinkName=2 is including
> all the tablenames, and screwing up any later attempt to do an INSERT or
> DELETE or anything else where SQL only allows a single table name.
>
> i'm only trying to do a simple insert into a single table :(
>
> --
> - Gus
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
