Help with multiple SQL statements in Interbase?
I have an Interbase 6.0 database on Win32 and I'm using the 0.9.2 version of the gvidb, but I'm running into problems with Z SQL queries like the following: insert into users (username,pword,email,lastname,firstname,chrome) values(<dtml-sqlvar username type="string">, <dtml-sqlvar expr="mkpword(password)" type="string">, <dtml-sqlvar email type="string">,<dtml-sqlvar lastname type="string">, <dtml-sqlvar firstname type="string">, <dtml-sqlvar chrome type="string">) <dtml-var sql_delimiter> insert into users_roles (UID, ROLEID) values(gen_id(UID_GEN,0), <dtml-sqlvar user_role type="string">) The SQL looks right and the first part of the query (before the delimiter) is executed and committed. The second part (which adds a user's role) never gets submitted. Is there a problem with sending multiple SQL statements to interbase in the same method? If so, is there a workaround, these need to go in the same transaction to insure that gen_id gives me the correct value. Thanks, Jason Jones jason.jones@awl.com
participants (1)
-
Jason.Jones@awl.com