cfquery inserting multiple values into tables?

[david3233]

Hi
I am extremely new to CF and I am stuck. I have queries to inserts data into to multiple tables which works fine in SQL plus, but when I try it using a cold fusion form, it doesn't work and I get the error noted below.
The RelNo.NEXTVAL and RelNo.CURRVAL are the primary keys in the two noted tables so that that the number is the same in both tables. I tried breaking it into 2 cfquery, but it didn't work. Any suggestions would be helpful. Thanks.
David


Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-00933: SQL command not properly ended

The error occurred in C:\ColdFusion8\wwwroot\dbclass2\newdonorinsert.cfm: line 11

[Dan_Bracuk]

Each sql query must be in separate cfquery tags.

[david3233 · Accepted solution]

Thanks. It was driving me nuts