Re: error: insert has more expressions than target column

Dino Vliet wrote:
> I'm getting the same error without brackets.

Check the columns in table "lessons" matches the columns in your select.

> The EXECUTE statement was because I read something
> about executing dynamic content.
>
> I want to add 7 days to the date value of startdate
> and want to repeat it every week. Because there are 8
> weeks I choose to do that with the for loop going from
> 0 to 7.

Looking closer, I can see the problem. You're treating the column from
the select as a variable (which it isn't).

Try something like:

INSERT INTO lessons (col_name1, col_name2, ...)
SELECT dayofweek, startdate + (i*7), endate + (i*7), startime, ...

--
   Richard Huxton
   Archonet Ltd