Re: Problem inserting array of rows

[Dvořáček Michal]

Hi,

if you have 6 colums, you are inserting only 5 in table

INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ')
                         [1th       ] [2nd]   [3rd]  [4th] [5th]

i think that first apostrophe is shifted to left side
should be:
INSERT INTO songs VALUES (1, 'blah', ' ***', 45, 2, ' ');

hint: numeric fields don't required to be in apostrophes


   Michal Dvoracek                           michal.dvoracek@stripped

   database, table, query