How to Insert Multiple Records Using Cold Fusion with Oracle Database in Soundings.
i was tried like this its not working, please check it once if i am doing any thing wrong.
<cfloop index="x" from="1" to="3">
<cfset newInsID = "#x#">
<cfquery name="addAnswer" datasource="mydsnnew">
insert into newanswers(id, questionid, answer, rank)
my oracle table is :
CREATE TABLE NEWANSWERS
ID VARCHAR2(35 BYTE) NOT NULL,
QUESTIONID VARCHAR2(35 BYTE) NOT NULL,
ANSWER VARCHAR2(255 BYTE) NOT NULL,
RANK NUMBER(1, 0) DEFAULT 0
i tried like this, its inserting only one record in oracle database table.
i want to insert all the records into my Oracle Database Table.