danwillig
12-20-2007, 05:28 PM
I'm trying to update 2 tables in one database. My first query is going through alright. The second one has some bugs.
My code is:
insert into panel_scene_map (scene_id, panel_id)
SELECT MAX(panel_id) AS new_id FROM panel
values('#scene_id#', '#panel_id#')
This is my error message:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
My code is:
insert into panel_scene_map (scene_id, panel_id)
SELECT MAX(panel_id) AS new_id FROM panel
values('#scene_id#', '#panel_id#')
This is my error message:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.