LC3120
Posts: 1
|
| Posted: 06/22/2016, 11:24 AM |
|
i have form with text area called mycode which have a list of codes:
12345,
34567,
76548,
34569
has button for search to display record on Grid1
Grid1
how can pass this mycode value into Grid1 view custome sql. i can pass the value thru url query but value is too long for url
{mycode}
SELECT code, name, address FROM rawcodes where code IN {mycode}
|
 |
 |
eratech
Posts: 513
|
| Posted: 06/26/2016, 4:49 AM |
|
Possibly add to OnClick of search button to Save Control Value to Session and then change the query to use the Session instead of URLs parameter?
Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia |
|
|
|
MichaelMcDonald
Posts: 640
|
| Posted: 06/28/2016, 4:02 AM |
|
Good interpretation Eric.
I had no idea what this was about.
_________________
Central Coast, NSW, Australia.
|
|
|
|
cleyan
Posts: 136
|
| Posted: 06/30/2016, 11:04 AM |
|
Hi L.
I would try to Send the form via POST instead of GET, then on Before Build Select event on the Grid, read the value of the field and modify the SQL sentence of the grid adding the new condition
I hope this give some light to your problem
Regards
Carlos
_________________
**************************************************
Carlos Leyan B.
Temuco, Chile
www.leytec.net |
|
|
|
|
