CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 search with listbox

Print topic Send  topic

Author Message
Roger
Posted: 05/23/2001, 8:55 AM

I have a search form and a grid.
Both have 4 checkboxes.
When I check any (or multi) checkboxes, the click the search button, nothing
seems to happen. All records are still selected.

I am on PHP/MySQL

--

Rgds
Roger Tng
www.Web4U.com.sg
Get appreciated. Join our Referral Program.


Alexey Alexapolsky
Posted: 05/24/2001, 9:46 AM

Have you added those checkbox fields as Input Parameter into
grid that shows results ?

--
Regards,
Alexey
CodeCharge Support



Roger <roger@web4sme.net> wrote in message
news:9egmgs$j70$1@mail.tankhill.com...
> I have a search form and a grid.
> Both have 4 checkboxes.
> When I check any (or multi) checkboxes, the click the search button,
nothing
> seems to happen. All records are still selected.
>
> I am on PHP/MySQL
>
> --
>
> Rgds
> Roger Tng
> www.Web4U.com.sg
> Get appreciated. Join our Referral Program.
>
>
>

Roger
Posted: 05/24/2001, 10:34 AM

Yes, I did. Set Param as = or %...% but did not work.
The Checkboxes value are as original at 1/0
Field type is Varchar(2).
Someone was suggesting setting Param value to Yes/"BLANK" because HTML
defaults to that. Sound like it might work. I have yet to try.
--
Rgds
Roger Tng

"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9ejdtu$4ra$1@mail.tankhill.com...
> Have you added those checkbox fields as Input Parameter into
> grid that shows results ?
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
>
> Roger <roger@web4sme.net> wrote in message
>news:9egmgs$j70$1@mail.tankhill.com...
> > I have a search form and a grid.
> > Both have 4 checkboxes.
> > When I check any (or multi) checkboxes, the click the search button,
> nothing
> > seems to happen. All records are still selected.
> >
> > I am on PHP/MySQL
> >
> > --
> >
> > Rgds
> > Roger Tng
> > www.Web4U.com.sg
> > Get appreciated. Join our Referral Program.
> >
> >
> >
>
>

Roger
Posted: 05/24/2001, 12:50 PM

Sorry, my 1st meaasge was wrong.
It's suppose to be Field/check prarmeter set to 'on' uncheck set to 'blank'
But still not working.
Any suggestions? Alexey.

--
Rgds
Roger Tng

"Roger" <roger@web4sme.net> wrote in message
news:9ejgnh$7kr$1@mail.tankhill.com...
> Yes, I did. Set Param as = or %...% but did not work.
> The Checkboxes value are as original at 1/0
> Field type is Varchar(2).
> Someone was suggesting setting Param value to Yes/"BLANK" because HTML
> defaults to that. Sound like it might work. I have yet to try.
> --
> Rgds
> Roger Tng
>
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:9ejdtu$4ra$1@mail.tankhill.com...
> > Have you added those checkbox fields as Input Parameter into
> > grid that shows results ?
> >
> > --
> > Regards,
> > Alexey
> > CodeCharge Support
> >
> >
> >
> > Roger <roger@web4sme.net> wrote in message
> >news:9egmgs$j70$1@mail.tankhill.com...
> > > I have a search form and a grid.
> > > Both have 4 checkboxes.
> > > When I check any (or multi) checkboxes, the click the search button,
> > nothing
> > > seems to happen. All records are still selected.
> > >
> > > I am on PHP/MySQL
> > >
> > > --
> > >
> > > Rgds
> > > Roger Tng
> > > www.Web4U.com.sg
> > > Get appreciated. Join our Referral Program.
> > >
> > >
> > >
> >
> >
>
>

CodeCharge
Posted: 05/24/2001, 1:11 PM

What URL do you see in the browser when you click "Search" and the form is
refreshed ?


"Roger" <roger@web4sme.net> wrote in message
news:9ejoms$fsr$1@mail.tankhill.com...
> Sorry, my 1st meaasge was wrong.
> It's suppose to be Field/check prarmeter set to 'on' uncheck set to
'blank'
> But still not working.
> Any suggestions? Alexey.
>
> --
> Rgds
> Roger Tng
>
> "Roger" <roger@web4sme.net> wrote in message
>news:9ejgnh$7kr$1@mail.tankhill.com...
> > Yes, I did. Set Param as = or %...% but did not work.
> > The Checkboxes value are as original at 1/0
> > Field type is Varchar(2).
> > Someone was suggesting setting Param value to Yes/"BLANK" because HTML
> > defaults to that. Sound like it might work. I have yet to try.
> > --
> > Rgds
> > Roger Tng
> >
> > "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
> >news:9ejdtu$4ra$1@mail.tankhill.com...
> > > Have you added those checkbox fields as Input Parameter into
> > > grid that shows results ?
> > >
> > > --
> > > Regards,
> > > Alexey
> > > CodeCharge Support
> > >
> > >
> > >
> > > Roger <roger@web4sme.net> wrote in message
> > >news:9egmgs$j70$1@mail.tankhill.com...
> > > > I have a search form and a grid.
> > > > Both have 4 checkboxes.
> > > > When I check any (or multi) checkboxes, the click the search button,
> > > nothing
> > > > seems to happen. All records are still selected.
> > > >
> > > > I am on PHP/MySQL
> > > >
> > > > --
> > > >
> > > > Rgds
> > > > Roger Tng
> > > > www.Web4U.com.sg
> > > > Get appreciated. Join our Referral Program.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Roger
Posted: 05/24/2001, 8:36 PM

http://203.117.184.52/ndirectory/viewGrid.php?s_Company...&IB=on&OB=on&TR
=on

--
Rgds
Roger Tng

"CodeCharge" <support@codecharge.com> wrote in message
news:9ejpsk$h1f$1@mail.tankhill.com...
> What URL do you see in the browser when you click "Search" and the form is
> refreshed ?
>
>
> "Roger" <roger@web4sme.net> wrote in message
>news:9ejoms$fsr$1@mail.tankhill.com...
> > Sorry, my 1st meaasge was wrong.
> > It's suppose to be Field/check prarmeter set to 'on' uncheck set to
> 'blank'
> > But still not working.
> > Any suggestions? Alexey.
> >
> > --
> > Rgds
> > Roger Tng
> >
> > "Roger" <roger@web4sme.net> wrote in message
> >news:9ejgnh$7kr$1@mail.tankhill.com...
> > > Yes, I did. Set Param as = or %...% but did not work.
> > > The Checkboxes value are as original at 1/0
> > > Field type is Varchar(2).
> > > Someone was suggesting setting Param value to Yes/"BLANK" because HTML
> > > defaults to that. Sound like it might work. I have yet to try.
> > > --
> > > Rgds
> > > Roger Tng
> > >
> > > "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
> > >news:9ejdtu$4ra$1@mail.tankhill.com...
> > > > Have you added those checkbox fields as Input Parameter into
> > > > grid that shows results ?
> > > >
> > > > --
> > > > Regards,
> > > > Alexey
> > > > CodeCharge Support
> > > >
> > > >
> > > >
> > > > Roger <roger@web4sme.net> wrote in message
> > > >news:9egmgs$j70$1@mail.tankhill.com...
> > > > > I have a search form and a grid.
> > > > > Both have 4 checkboxes.
> > > > > When I check any (or multi) checkboxes, the click the search
button,
> > > > nothing
> > > > > seems to happen. All records are still selected.
> > > > >
> > > > > I am on PHP/MySQL
> > > > >
> > > > > --
> > > > >
> > > > > Rgds
> > > > > Roger Tng
> > > > > www.Web4U.com.sg
> > > > > Get appreciated. Join our Referral Program.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Alexey Alexapolsky
Posted: 05/25/2001, 6:19 AM

I'd suggest you to select Page/Open event at page that displayes results ,
and change "on" with 1 in for checkbox params , like
if ( $HTTP_GET_VARS["checkbox_name"] == "on" ) {
$HTTP_GET_VARS["checkbox_name"] == 1;
}

May be it's just a matter of conversion.
Anywhow I suggest you to edit script and print sql statement
corresponding to grid ,so you will immediately see what is wrong.

--
Alex
Develop database-connected web sites
without coding: http://www.codecharge.com
ASP, ASP.NET, PHP, JSP, Perl, ColdFusion



Roger <roger@web4sme.net> wrote in message
news:9ekk0m$6v5$1@mail.tankhill.com...
>
http://203.117.184.52/ndirectory/viewGrid.php?s_Company...&IB=on&OB=on&TR
> =on
>
> --
> Rgds
> Roger Tng
>
> "CodeCharge" <support@codecharge.com> wrote in message
>news:9ejpsk$h1f$1@mail.tankhill.com...
> > What URL do you see in the browser when you click "Search" and the form
is
> > refreshed ?
> >
> >
> > "Roger" <roger@web4sme.net> wrote in message
> >news:9ejoms$fsr$1@mail.tankhill.com...
> > > Sorry, my 1st meaasge was wrong.
> > > It's suppose to be Field/check prarmeter set to 'on' uncheck set to
> > 'blank'
> > > But still not working.
> > > Any suggestions? Alexey.
> > >
> > > --
> > > Rgds
> > > Roger Tng
> > >
> > > "Roger" <roger@web4sme.net> wrote in message
> > >news:9ejgnh$7kr$1@mail.tankhill.com...
> > > > Yes, I did. Set Param as = or %...% but did not work.
> > > > The Checkboxes value are as original at 1/0
> > > > Field type is Varchar(2).
> > > > Someone was suggesting setting Param value to Yes/"BLANK" because
HTML
> > > > defaults to that. Sound like it might work. I have yet to try.
> > > > --
> > > > Rgds
> > > > Roger Tng
> > > >
> > > > "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
> > > >news:9ejdtu$4ra$1@mail.tankhill.com...
> > > > > Have you added those checkbox fields as Input Parameter into
> > > > > grid that shows results ?
> > > > >
> > > > > --
> > > > > Regards,
> > > > > Alexey
> > > > > CodeCharge Support
> > > > >
> > > > >
> > > > >
> > > > > Roger <roger@web4sme.net> wrote in message
> > > > >news:9egmgs$j70$1@mail.tankhill.com...
> > > > > > I have a search form and a grid.
> > > > > > Both have 4 checkboxes.
> > > > > > When I check any (or multi) checkboxes, the click the search
> button,
> > > > > nothing
> > > > > > seems to happen. All records are still selected.
> > > > > >
> > > > > > I am on PHP/MySQL
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Rgds
> > > > > > Roger Tng
> > > > > > www.Web4U.com.sg
> > > > > > Get appreciated. Join our Referral Program.
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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