[ic] Processing Form Variables

Sergey Sheykin sheich@mosinfo.ru
Thu, 11 Jan 2001 15:45:31 +0300

Hi list!

Know anybody, how can i processing a variables values,
transmitted from the form ?

For example :

<FORM ACTION="[process-target]" METHOD=POST>
<INPUT TYPE=hidden NAME=mv_todo VALUE="return">
<INPUT TYPE=hidden NAME=mv_nextpage VALUE="list_title.html">
<select name="f_category" style="HEIGHT: 18px; WIDTH: 140px">
	<OPTION value="s" Selected>All Products</option>
	<OPTION value="Books/CD-roms">Books &amp; CD-roms</option>
<input name="f_value">
<input type="image" name="Search" value="mv_submit" src="/graphix/go.gif">

and list_title.html include :

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

well! When [value f_value] contains some like "stal'" -
in query body arises wrong expression :
...like 'stal'' - superfluous apostrophe.

I need replace "stal'" on "stal''" - in what place
i can do it ? 

In ..interchange/lib/Vend/Table/DBI.pm i find
subroutine query {}, variable $query contains
a ful sql-query. But where i can find value of my [f_value] ?

Thank's, Sergey.