[ic] SQL search problem

Sergey Sheykin sheich@mosinfo.ru
Thu, 4 Jan 2001 16:22:32 +0300


Hi,
Somebody can tell, whether I can use
a _'_ character inside the SQL-request?

If i said :

[query ml=10 more=1 list=1
 query="
 select sku, title, price, authors, pubdate, category
 from products
 where authors = '[value f_value]'"
]

and inside the [value f_value] meets _'_ character,
browser show "Internal Server Error" (500), because
line of SQL-request terminated on a _'_ -character!

Please, help!