CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Passing a variable value

Print topic Send  topic

Author Message
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}
View profile  Send private message
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
View profile  Send private message
MichaelMcDonald

Posts: 638
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
cleyan


Posts: 128
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
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 http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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