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 & CD-roms</option>
</select>
<input name="f_value">
<input type="image" name="Search" value="mv_submit" src="/graphix/go.gif">
</Form>
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.
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 & CD-roms</option>
</select>
<input name="f_value">
<input type="image" name="Search" value="mv_submit" src="/graphix/go.gif">
</Form>
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.