templates

[zcy]

when the variable have comma, the enter string is
separated the list form.
etc: 'insert into table(column1,column2)'
insert into table(column1
column2.

 

[zcy]

template:
[$QUERY sql= select column_name from table_name where condition]
when the return result include ','or ':', the return result is not exception value.
etc:
[$QUERY sql=select 'insert into table(column1,column2)valuesvalue1,:value2)' from dual]
exception value : insert into table(column1,column2)valuesvalue1,:value2);
error display list form.
suggest: add a type function as list ,not parse special character of the system define. etc: "," ":"

 

[zcy]

[$QUERY ] execute time?
the sentence [$QUERY sql= select * from tab where column_name1=[name]] do not preciseness run.
the sql sentence execute require use enter condition.