tDBRow(MySQL) - NamedParameter

[Anonymous]

Hi,

I want to execute a SQL query  with the tDBRow(MySQL) component.  How can i define the two named parameters ? 

select * from people where (first_name = :name or last_name = :name) and address = :address")

 Any ideas ?

[fdenis]

on your sql query you can insert java code globalMap value or context value:
"select * from people where (first_name = "+ globalMap.get("yourGlobalVar") +" or last_name = " + context.oneValue + ") and address = " + any java code + " )"