Question
Oracle 10g Windows + CF8 Windows doesn't make the insert
Hi!
I have this simple query that is not inserting new values :
<cfquery datasource="THEDATASOURCE">
INSERT INTO SCHEMA.TABLE (ID_COLUMN, SECOND_COLUMN)
VALUES (AUTOINCREMENT_TABLE.NEXTVAL,'<cfoutput>#form.FIELD#</cfoutput>');commit;
</cfquery>
where AUTOINCREMENT_TABLE.NEXTVAL is a sequence made for the ID column of the table.
what can be?
I have this simple query that is not inserting new values :
<cfquery datasource="THEDATASOURCE">
INSERT INTO SCHEMA.TABLE (ID_COLUMN, SECOND_COLUMN)
VALUES (AUTOINCREMENT_TABLE.NEXTVAL,'<cfoutput>#form.FIELD#</cfoutput>');commit;
</cfquery>
where AUTOINCREMENT_TABLE.NEXTVAL is a sequence made for the ID column of the table.
what can be?
AdChoices