tunhien
asked on
Database ?
I have executed this code :
row = dbAccount.executeNonQuery( "insert PRODUCTDETAIL " +
"values('" + max + "','" + productDetailRealID + "','" + name + "','" + image + "','" + price
+ "','" + englishDescription + "','" + vietnameseDescription + "','" + englishMoreDescription
+ "','" + vietnameseMoreDescription + "','" + pricePerUnit + "','" + pause + "','" + day + "','" + month + "','" + year + "','" + stateID + "','" + kindID +
"','" + categoryID + "','" + capacityID + "','" + concentrationID + "','" + TTNH + "','" + totalReview + "')");
Then I checked row's value . Row's value is 0 . But in my database , that record has been inserted successfully . Why ? Why doesn't row's value is 1 ?
row = dbAccount.executeNonQuery(
"values('" + max + "','" + productDetailRealID + "','" + name + "','" + image + "','" + price
+ "','" + englishDescription + "','" + vietnameseDescription + "','" + englishMoreDescription
+ "','" + vietnameseMoreDescription + "','" + pricePerUnit + "','" + pause + "','" + day + "','" + month + "','" + year + "','" + stateID + "','" + kindID +
"','" + categoryID + "','" + capacityID + "','" + concentrationID + "','" + TTNH + "','" + totalReview + "')");
Then I checked row's value . Row's value is 0 . But in my database , that record has been inserted successfully . Why ? Why doesn't row's value is 1 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think you should let me know the type of dbAccount variable.
>> INTO is missing
Strange that the row is still inserted :)
Could you post the correct code that is being used?
Strange that the row is still inserted :)
Could you post the correct code that is being used?
? is that the answer you want?
I doesn't know what the author want,too
INSERT INTO "TABLENAME" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)