Ask a Question related to Dreamweaver AppDev, Design and Development.
-
rajesh #1
select 'ALL'
hi
I have a listbox where you can select
so
the select box is like this
ALL
T1
T2
T3
if I select the ALL I want that alle records must displayed\
how does this ALL works?
please advise
kisoen
rajesh Guest
-
Populate Combo box with value 'ALL'
Have read in a query to a combo box but need to have an additional value of ALL in the combo box to enable our filter to work. How can i do this,... -
#25474 [Bgs]: posting arrays from a select box with multiple select is not working properly
ID: 25474 User updated by: fmuller at cisco dot com -Summary: apache2filter: posting from a multiple select box is not... -
#25474 [Opn->Fbk]: posting arrays from a select box with multiple select is not working properly
ID: 25474 Updated by: sniper@php.net Reported By: fmuller at cisco dot com -Status: Open +Status: ... -
problem changing 'all' text color
Hi! When I change the text (specifically, it's color) after Selecting a (DW4) Table, much of the text doesn't change color. When I examine the code,... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id, -
twocans #2 Re: select 'ALL'
select * from YourtableName
order by YourColumnName Asc
[url]http://www.w3schools.com/sql/sql_groupby.asp[/url]
regards
twocans
"rajesh" <r.kisoenpersad@chello.nl> wrote in message
news:d1krf2$o55$1@forums.macromedia.com...> hi
> I have a listbox where you can select
>
> so
> the select box is like this
>
> ALL
> T1
> T2
> T3
>
> if I select the ALL I want that alle records must displayed\
> how does this ALL works?
>
> please advise
> kisoen
>
>
twocans Guest
-
rajesh #3 Re: select 'ALL'
hi,
I don't not mean * of all
but the in the meaning of ALL records
ALL can also be as select when click on select you will get all the records
gr. kisoen
"twocans" <abbadontdoit@hotmail.com> schreef in bericht
news:d1kskc$ph7$1@forums.macromedia.com...> select * from YourtableName
> order by YourColumnName Asc
>
> [url]http://www.w3schools.com/sql/sql_groupby.asp[/url]
>
> regards
>
> twocans
>
>
>
>
> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
> news:d1krf2$o55$1@forums.macromedia.com...>> > hi
> > I have a listbox where you can select
> >
> > so
> > the select box is like this
> >
> > ALL
> > T1
> > T2
> > T3
> >
> > if I select the ALL I want that alle records must displayed\
> > how does this ALL works?
> >
> > please advise
> > kisoen
> >
> >
>
rajesh Guest
-
twocans #4 Re: select 'ALL'
<option selected value="%">All</option>
OK sorry I miss understood you. the above shows you the value of ALL in a
"List Menu"
twocans
"rajesh" <r.kisoenpersad@chello.nl> wrote in message
news:d1lv36$4vs$1@forums.macromedia.com...> hi,
>
> I don't not mean * of all
> but the in the meaning of ALL records
>
> ALL can also be as select when click on select you will get all the
> records
>
> gr. kisoen
>
>
> "twocans" <abbadontdoit@hotmail.com> schreef in bericht
> news:d1kskc$ph7$1@forums.macromedia.com...>>> select * from YourtableName
>> order by YourColumnName Asc
>>
>> [url]http://www.w3schools.com/sql/sql_groupby.asp[/url]
>>
>> regards
>>
>> twocans
>>
>>
>>
>>
>> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
>> news:d1krf2$o55$1@forums.macromedia.com...>>>> > hi
>> > I have a listbox where you can select
>> >
>> > so
>> > the select box is like this
>> >
>> > ALL
>> > T1
>> > T2
>> > T3
>> >
>> > if I select the ALL I want that alle records must displayed\
>> > how does this ALL works?
>> >
>> > please advise
>> > kisoen
>> >
>> >
>>
>
twocans Guest
-
rajesh #5 Re: select 'ALL'
I tried this also, but not working
do you have do something in the SQL statement for this ALL?
gr. kisoen
"twocans" <abbadontdoit@hotmail.com> schreef in bericht
news:d1m053$69f$1@forums.macromedia.com...> <option selected value="%">All</option>
>
> OK sorry I miss understood you. the above shows you the value of ALL in a
> "List Menu"
>
> twocans
>
>
>
>
>
>
>
>
>
> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
> news:d1lv36$4vs$1@forums.macromedia.com...>> > hi,
> >
> > I don't not mean * of all
> > but the in the meaning of ALL records
> >
> > ALL can also be as select when click on select you will get all the
> > records
> >
> > gr. kisoen
> >
> >
> > "twocans" <abbadontdoit@hotmail.com> schreef in bericht
> > news:d1kskc$ph7$1@forums.macromedia.com...> >> >> select * from YourtableName
> >> order by YourColumnName Asc
> >>
> >> [url]http://www.w3schools.com/sql/sql_groupby.asp[/url]
> >>
> >> regards
> >>
> >> twocans
> >>
> >>
> >>
> >>
> >> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
> >> news:d1krf2$o55$1@forums.macromedia.com...
> >> > hi
> >> > I have a listbox where you can select
> >> >
> >> > so
> >> > the select box is like this
> >> >
> >> > ALL
> >> > T1
> >> > T2
> >> > T3
> >> >
> >> > if I select the ALL I want that alle records must displayed\
> >> > how does this ALL works?
> >> >
> >> > please advise
> >> > kisoen
> >> >
> >> >
> >>
> >>
> >
>
rajesh Guest
-
twocans #6 Re: select 'ALL'
can i see the page
"rajesh" <r.kisoenpersad@chello.nl> wrote in message
news:d1m0cu$6kr$1@forums.macromedia.com...>I tried this also, but not working
> do you have do something in the SQL statement for this ALL?
>
> gr. kisoen
>
>
>
>
> "twocans" <abbadontdoit@hotmail.com> schreef in bericht
> news:d1m053$69f$1@forums.macromedia.com...>>> <option selected value="%">All</option>
>>
>> OK sorry I miss understood you. the above shows you the value of ALL in a
>> "List Menu"
>>
>> twocans
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
>> news:d1lv36$4vs$1@forums.macromedia.com...>>>> > hi,
>> >
>> > I don't not mean * of all
>> > but the in the meaning of ALL records
>> >
>> > ALL can also be as select when click on select you will get all the
>> > records
>> >
>> > gr. kisoen
>> >
>> >
>> > "twocans" <abbadontdoit@hotmail.com> schreef in bericht
>> > news:d1kskc$ph7$1@forums.macromedia.com...
>> >> select * from YourtableName
>> >> order by YourColumnName Asc
>> >>
>> >> [url]http://www.w3schools.com/sql/sql_groupby.asp[/url]
>> >>
>> >> regards
>> >>
>> >> twocans
>> >>
>> >>
>> >>
>> >>
>> >> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
>> >> news:d1krf2$o55$1@forums.macromedia.com...
>> >> > hi
>> >> > I have a listbox where you can select
>> >> >
>> >> > so
>> >> > the select box is like this
>> >> >
>> >> > ALL
>> >> > T1
>> >> > T2
>> >> > T3
>> >> >
>> >> > if I select the ALL I want that alle records must displayed\
>> >> > how does this ALL works?
>> >> >
>> >> > please advise
>> >> > kisoen
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>
twocans Guest
-
rajesh #7 Re: select 'ALL'
this is the coding of the listbox (the page is not on the internet)
<p>Select period (mm/dd/yyyy) click on ... for display calendar. (ALL
CALLS)</p>
<form name="form1" method="post" action="mgt.asp">
<p> Team
<select name="Team" id="Team">
<option value="%">Select...</option>
<option value="Team 1">Team 1</option>
<option value="Team 2">Team 2</option>
<option value="Team 3">Team 3</option>
</select>
the SQl is like this
SELECT Support.SupportTeamID, Call.SystemID, Count(Call.CallID) AS
AantalVanCallID, Tblcontype.typedescription FROM (Call INNER JOIN
Tblcontype ON Call.FunORCorr_change = Tblcontype.typeid) INNER JOIN Support
ON Call.IntakeBy = Support.SupportID where intakedate BETWEEN #vartxt1# AND
#vartxt2# and support.supportteamid = 'varteam' GROUP BY
Support.SupportTeamID, Call.SystemID, Tblcontype.typedescription
should i change something in the SQL statement?
please advise
kisoen
"twocans" <abbadontdoit@hotmail.com> schreef in bericht
news:d1m3q8$clr$1@forums.macromedia.com...a> can i see the page
>
>
>
>
>
>
>
>
>
> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
> news:d1m0cu$6kr$1@forums.macromedia.com...> >I tried this also, but not working
> > do you have do something in the SQL statement for this ALL?
> >
> > gr. kisoen
> >
> >
> >
> >
> > "twocans" <abbadontdoit@hotmail.com> schreef in bericht
> > news:d1m053$69f$1@forums.macromedia.com...> >> <option selected value="%">All</option>
> >>
> >> OK sorry I miss understood you. the above shows you the value of ALL in>> >> >> "List Menu"
> >>
> >> twocans
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
> >> news:d1lv36$4vs$1@forums.macromedia.com...
> >> > hi,
> >> >
> >> > I don't not mean * of all
> >> > but the in the meaning of ALL records
> >> >
> >> > ALL can also be as select when click on select you will get all the
> >> > records
> >> >
> >> > gr. kisoen
> >> >
> >> >
> >> > "twocans" <abbadontdoit@hotmail.com> schreef in bericht
> >> > news:d1kskc$ph7$1@forums.macromedia.com...
> >> >> select * from YourtableName
> >> >> order by YourColumnName Asc
> >> >>
> >> >> [url]http://www.w3schools.com/sql/sql_groupby.asp[/url]
> >> >>
> >> >> regards
> >> >>
> >> >> twocans
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "rajesh" <r.kisoenpersad@chello.nl> wrote in message
> >> >> news:d1krf2$o55$1@forums.macromedia.com...
> >> >> > hi
> >> >> > I have a listbox where you can select
> >> >> >
> >> >> > so
> >> >> > the select box is like this
> >> >> >
> >> >> > ALL
> >> >> > T1
> >> >> > T2
> >> >> > T3
> >> >> >
> >> >> > if I select the ALL I want that alle records must displayed\
> >> >> > how does this ALL works?
> >> >> >
> >> >> > please advise
> >> >> > kisoen
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
>
rajesh Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
