HI,,
I got the following problem. Tried several alternatives but most of the times in vain!!
I will be inserting the following.
" INSERT INTO TEMPLATES(ID, TEMPLATE_CATEGORY, TEMPLATE_NAME, TEMPLATE_FILE_CONTENT) "+" VALUES +"('"+id+"',' "+templateCat+" ','"+templateName+"', EMPTY_BLOB()) ";
I need to concatenate the id, templateCat and templateName and insert that
string as value in TEMPLATE_NAME column.
i.e, instead of +templateName+ ...i need the concatenated string.
I tried several possibilities but getting errors. any idea???
regards,
Navi