Displaying 3 results from an estimated 3 matches for "val12".
Did you mean:
val1
2004 May 24
1
RMySQL problem
...several
rows at once to insert a complete data.frame into a table. I've tryied
to use "paste" to build the sql string but It works "by column" and I
need it "by row" ...
The sql systax should be something like:
INSERT INTO TABLEA(COL1, COL2, COL3) VALUES
(VAL11, VAL12, VAL13),
(VAL21, VAL22, VAL23),
...
(VALN1, VALN2, VALN3);
and I have a data.frame with 3 columns corresponding to that table
columns.
How can I do this ?
Thanks
EJ
2004 May 25
0
RMySQL problem - SOLVED
...olumn" and I
> >>>>> need it "by row" ...
> >>>>>
> >>>>> The sql systax should be something like:
> >>>>>
> >>>>> INSERT INTO TABLEA(COL1, COL2, COL3) VALUES
> >>>>> (VAL11, VAL12, VAL13),
> >>>>> (VAL21, VAL22, VAL23),
> >>>>> ...
> >>>>> (VALN1, VALN2, VALN3);
> >>>>>
> >>>>> and I have a data.frame with 3 columns corresponding to that table
> >>>>> columns.
> &g...
2006 Aug 14
4
Updating a table with Ajax
I''ve been banging my head against the wall trying to update a table
(add/delete rows) using Ajax. It seems simple enough but just doesn''t work
for me. I can get it to work using DIVs instead of a table, but doing the
layout with DIVs is much more cumbersome and I know it works for others with
a table (though I haven''t been able to find an exact example code anywhere).