Oracle 10g Windows + CF8 Windows doesn't make the insert

[Guest]

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?

[Dan_Bracuk]

What exactly is it doing? Throwing an error?

[Guest]

it's not inserting the text from the web form.
I enclosed the code with a <cftry> but it's not throwing any error.

[Dan_Bracuk]

What is your indication that the new record is not there? Is the sequence incrementing?