posted 20 years ago
Hi All,
My requirement is that I have a variable like
title = "Hello world"
and my insert statement is like
insertSQL = "INSERT INTO TblCategory (CategoryKey, Title, ContentTypeKey) ";
insertSQL += " VALUES(" + key + ", " + title + "," + contTypeKey + ")";
when I was trying to insert in oracle the title varible is expecting ''.
Please help me out... how can I resolve it.
thanks
Regards
Sham
SQL: INSERT INTO TblCategory (CategoryKey, Title, ContentTypeKey) VALUES(19, Helloworld,2)