CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> PHP

 Passing a variable value

Print topic Send  topic

Author Message

Posts: 1
Posted: 06/22/2016, 11:24 AM

i have form with text area called mycode which have a list of codes:
has button for search to display record on 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
SELECT code, name, address FROM rawcodes where code IN {mycode}
View profile  Send private message

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?

CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message

Posts: 640
Posted: 06/28/2016, 4:02 AM

Good interpretation Eric.
I had no idea what this was about.
Central Coast, NSW, Australia.

View profile  Send private message

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



Carlos Leyan B.
Temuco, Chile
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.