Grid with variable

[pinux]

Hi,
I would like to do a grid like that:

http://www.scriptcase.net/systems/v5/exemplos_en_us/grid49/grid49.php

with the possibility to add at the end of the URL some variables as:
http://www.scriptcase.net/systems/v5/exemplos_en_us/grid49/grid49.php?Category=category_value
to open the grid with only the data with the Category that I have in the URL.
Any hint?

Thanks

[diogo]

Re: Grid with variable

modify your sql to something like this :

SELECT
… your fields …
FROM
YOUR TABLE
WHERE
category = ‘[var_category]’

if you access your application like this:
http://www.scriptcase.net/systems/v5/exemplos_en_us/grid49/grid49.php?var_category=1

the value will be passed to the variable.