Answered
cfquery inserting multiple values into tables?
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
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
AdChoices