> 2 - Your INSERT statement is using a SELECT statement to
> chose VALUES to be inserted into the table. Since MySQL
> does not support sub-SELECT statements, the second part
> of your query is not returning any values, resulting in
> the NULL value error stated above.
MySQL does support INSERT .
Danger, danger! UltraDev code ahead!
First off, do yourself a favor and try to ween yourself off UltraDev and
learn ASP and SQL from a good book and write the code yourself. It will
probably save you many headaches in the future.
I think that your problem might be twofold and they are related.
