Mark
|
| Posted: 06/26/2002, 1:27 PM |
|
Hi,
What I'm trying to do is to get one listbox populated based on another.
I know there's a javascript workaround for this, but I don't want to load
all the data to the client, as I'm acutely aware how easy it is for your PC
to run out of resources, regardless of the RAM available !
How can I make use of a button or link, to force the listbox in question to
re-populate itself from the server, when clicked ?
For Example, I think what I could do is set a session parameter in the
Client OnChange event of the first listbox to hold the new key based on the
selection made.
Then have a button which has a server OnClick event, that executes some SQL
based on the session parameter to get the correct entries & then populate
the second listbox....
That's my theory, but can anyone show me how to actually do this as I'm not
having any luck so far !!
Using PHP & MySQL.
Many Thanks,
Mark
|
|
|
 |
Robert Rodgers
|
| Posted: 06/27/2002, 12:56 PM |
|
Another way is to keep posting to the current page Here is an example. This
is an ASP example but I don't think it should matter.
You will need to set up a connection named "Connection1" that points to the
Internet database (this example uses "users", and "user_groups") and point
to your publishing location
--
Robert Rodgers
Robert@SylvanComputing.com
Ph: 509.531.4351
Fax: 503.961.0317
Text Message: mailto:5095314351@mobile.att.net
===============================================
*** NEW ***
See our web hosting options
500MB Web Space, NT2000 Hosted, Unmetered Data
Transfer, Unlimited Email, Unlimited Email
Aliases, Web based mail access, MSSQL2000, ASP,
Coldfusion, PHP, Frontpage 2000, Server Side
Includes (.stm, .shtm, .shtml), RealAudio/Video,
SSL Security, E-commerce Shopping Cart
$360.00/yr or $35/mo
www.sylvancomputing.com
---
"Mark" <mark@markate.demon.co.uk> wrote in message
news:afd846$kob$1@news.codecharge.com...
> Hi,
>
> What I'm trying to do is to get one listbox populated based on another.
> I know there's a javascript workaround for this, but I don't want to load
> all the data to the client, as I'm acutely aware how easy it is for your
PC
> to run out of resources, regardless of the RAM available !
>
> How can I make use of a button or link, to force the listbox in question
to
> re-populate itself from the server, when clicked ?
>
> For Example, I think what I could do is set a session parameter in the
> Client OnChange event of the first listbox to hold the new key based on
the
> selection made.
>
> Then have a button which has a server OnClick event, that executes some
SQL
> based on the session parameter to get the correct entries & then populate
> the second listbox....
>
> That's my theory, but can anyone show me how to actually do this as I'm
not
> having any luck so far !!
>
> Using PHP & MySQL.
>
> Many Thanks,
> Mark
>
>
>
begin 666 linkedlist.zip
M4$L#!!0````(`%QEVRR&:C_Y;0(``,L&```,````5&5S=$QI;FLN8V-PS55-
M;]LP##UWP/Z#H<,^@+5!NNVT.$":)D6'H//F8-="L=E8F"RYE-2F^_6C)#NU
MTPWH80-V$Y\H\I&/IB<9WT(BRI2-66*A;B2WL-A94$9HE;+*UI(E" 2+.\BX
MK5)VPI(;)^6W0]! X1 HU))+`RQQ*-</#:2L\V2),)>JD*[L>>7Y:E848$R'
M3%^^.)K,==UH!<H:;QY-5L+8,[T+3$\IOP!9YMIA`3'%^=E<2U<K8M%#UWPC
M*47)+6\!V%F60"FLOR$;'=U7W"P0-5(("84-A<<;!.M0?>?2M1&O7+T!9(GB
M-5DM*VK=O?C)L5Q7X.$K8CZ XMNE\&0*K5279+X_CR/+6%+*G &\WJ)VC6')
M1CM5QO)2%L!K47JU=G >E(4!VZXDS:0IA3S"[!+U'6FC7WSZM9I^\G3WA#M
M:+T['K]ETU['1]/)XJX]A YF'"FR!?1(G@W-KZN!_5D+%1YUQDJH'_Z\])+Y
MPZCMVG0@ZOO_3=33?R+JH9Q!Z$,U`RCU5E#EO/!?SJ"(H22=2X CI\>DS]7U
M$ B2? AU45LI;0R\OV_%ZH_CHQZ7RL+6^QC@6%3S88S%K>.T4IHN5-M&C35+
M?,W%EP:06XTIFZFRY]BUL9M>EF@L` 87\-)_]XS/RT/:GT+P[PF;-6J]"L
MC[_==Z!\)"(DJ#V]$13F/'+=K\$X>S'@^.ET/W\4XW3[M>[?&NOIGQ1%\\=1
M&,6D=!@N77(OP<=L5W!GAG*]07IQM74ATRS/UNW?PW3%[+-ST_A1JFL*G;+7
M-#P:\TK?=]V@QAUXCP*;7OI)[G\NPCY<A*4XX.]K)9]?4$L#!!0````(`&5E
MVRS2"P@.IP0``#(-```,````5&5S=$QI;FLN87-PM5=M;]LV$/YNP/^!T]!.
M'FPM<AHO`=IAMB2W!EPGL-7TPS8$C,786B51E:BDV:_?'4E+HNVER8<9"&(>
M'][+<W?D^>VK;N>G6;9.JH@1CZ<IS\@T3EA)?G<'_BCP`_=TV.V\^JW;>?O#
M8$!^G"V\^2<_(-/9/'AG.7^J,PXM<VLP^&\476^9!)$G4"%+\X2*[P-7O!"L
M^"YL0>_C#17<0&+ 01:18T%W.Y*-6,0TB?]AY(IN&!(Q&HVF8^_T'';)-2UB
M>BO!?IP"1&Q#ON1<],EJ7<2Y0(G:0YT+FC*U6K(H+MA:J%68)WWR(?PXWP6M
MQ7IE'@4?<YZQ3"@1NA'<PU+[X'FK8\LE*ZM$*+C'LPQLQSS3('_2B%R%D=&N
M>28*GFC4/"[%A']SS95/!5WQJE@S0SXT5_NH226$MK6C@KPCEM7M[ >-XI"5
M8AYG7YRM2!/ K)AHX@2 5S X<7G[-ZBQ+<5\G&T</Y8AT>+1ZG4[1S5B,70[
M3>)PT_D%;=3Y`]&<W0E[R;Y6<,RVKL;AAYMP.5ZLYN,P\*U>'P#9$_L],I"(
MG0>]7EUW1GGMEYR*2+;?U+]P)R>C<Q6\D3#P;\$>R#HI]_)H+)W+G&5U_G5:
M4==A(I%13W':".VH#+'4^Z;Q/AD7!7T$UH-YX(7D9T(L\IK<=#O6='GYD50E
M*VXV!:_RTNI#@O$/PV];;ME#D;U>EWH+T#N097X'3,B^09]YWGLF-/57M*"I
MO0>#;4S0093@Q$[H3'B511Y/JC3#`I#^WL21U8*@M7U$!KFTC%B&_Q^+)G^?
M8RC,0Z/.YRTKF.2!P:T(*2;P00>=6JB0V#<K5MS#U?F\]D%%!TIL*^?82:6X
M1<)[H%3GPIGR0N=";6D-XRBJE1 (W%0@,S;+!-NPHD^"-!>/];^!JU5X10R'
MP3/;18-8V05%3VV>!U\K"I?IE"8ED&S]L4OE7Z#:V3!5(I/'F0]G:Y?*DJ60
ME$B2AQK;%KH=[%3DNZZ&`\+QBOAN+O;LF'7SG!X86N;W9_3 \$@/#(_UP'"_
M!V3CMEM@N-<"$I#P39SI%M!W>BL2);$MO8,U,+LCLU(FU*Y;ZYHF%>N1<,LR
M+'G,B;DG54(,TX*G5QROV*9@!IBA;L=\Y^2!)8U+)H5V_5@`@>,[2$9SR0)!
M"RZV4.]'+F5]`<MK\STG@I,(*(XS66TDWTT$_NG9],W4E]$M+D-B$^-1(RHV
M%=FG+.$T4K<]KL%A>,Y+YM1'FME >G.GW3IN?__)P"FB'AS0N1/W["QP)\%+
M*+K,&HW7,7LP.,)4MV<54)2IYZ>97O8QCISY`+D3E$L&?1_#./;8[1C(.;!3
MJVX]PJ^/C$-H!F8GT&NHF"1\_<6V4@JEV7M)W!-VQPNVVO*')ZO"X%@F`(_4
M`Z)W\NOYFXLSO_5XR'WPM-5,C4AW1TMB1',%'5TRHL+1-YOVJ38KG5"5U;@Q
M&;HGW@@&L7;)-93I^(XFM-Z39EJ*6X:DG55UB[;<D7OAGI] D:&@V;?U%?O2
M%"@-1A)0#;27.=.LA/*71O(;CCC&-8(?\X27\)(UK^+!(+4+7-);W1H,[")&
M$M3/H'\!4$L#!!0````(`$QEVRPH"&&480$``,X"```-````5&5S=$QI;FLN
M:'1M;(V22TO#0!#'[X+?8=R#Z"$)[5'3'(I%!&D%T:MLDFD3W1>[DSX0O[N;
MW:9J4? T.Z___&:9O"$IBM.3O$%>]Y9:$EC,<?/ 5SC*L^C[1#94E+K>]=84
MYZITYCK/3'2?'#J@!H%X*?QS:;4,OM&6N #<<FD$IH>&'_U+;24H+G'""!V)
M5KTQX!6U6GU%4NX,`XG4Z'K"C';$?"_ D5@(['0'%5?0.0P46E6-WPEPC8I
M6_ 3*P1?9OL:Z]DU&(O.`8>R(](J_29WWSJ"A<+@.A18T1ZWSTSU=L3B"+7R
ML5>^YJZRK:&K6E>=]"/3PQ*N*V5+%Y>1'>!]4'A9F'Y?]Q&&9'%*!#@"H8W^
M$V0\Z.8ZR,&:B\ZG&<1JK(O'V/;<)_(LEAW!C/\%$\Q9DL!T=GLWAVGXMKT9
M09(4>:M,YWEWQA/$Q=D`-+B1?M_$BJ WF]_\IA9O)>N/)3R&8\S"'7\"4$L#
M!!0````(`&1EVRREHK=F( (``(H&```.````5&5S=$QI;FME9"YC8W/%5<%N
MVS ,/6_ _L'09;=F`W::X@)9F@P9DBZ8LYYVD65:5BI+@B0[Z=^/MN<T+KH9
M/NUD\9%Z?*1(>)[(`)',8O*!1(II43$!,5DD^P.45K$`GD2:E8@=P(>MU(^0
MD<CCK>TE>J6%DKX@D:W2YB"U.#Q9=.R=.0(/)%H?]G_U>>"5D^&I@^^-!A)5
M3G7F#T -LH8FS-7@8K+9))]0JN&(&QV3+9[4=>J%4COF'V-2A%+1HZ?,6VH+
MBT=+>5Y2JZ@M*1>2EEE*A<SIT0K*O:?GY@*K&5[AY^;>&6'JP./7Z%P*6OM,
M>FX0MJB?GB"5.C<T9>%:PNK,P89.!4<&SFW;@SWS'HO9F:SIIZO@16?^F_2!
MBE?55]C_S5T2C(,=A,+@Q"2 U1C=^QZ8DRQ56-G/UN[PK1%2#UTMU'F;AIR,
MRX8!/4HBX4QEKZF_=@")< P6UBK9C\&:*8_MQ%HU3E4++2_GC]W J*2=H3T+
M!5;V^1>)"BD*% 0UJ)MW;-_.E*2T.H@Z^-6<O[&?FBW\(+/&%UU)!:SV;
M[:)=+=;8PG7 #;YF4UE9HH"8O"=1;EQ2F%,O>78[S(!JR^9=_DW?14TG9[R
M4>XF:#)U8EP`-\;=14TFOV>U% SG=XS_$CB]-0H'=_Q=_X1-IE_<?7_XDHRQ
M+S)3I]/)OR7K2G<3/)8A[P-OCOXJQVSV6I+98!7F[?YZQ%=ULTU-0/,'0M]O
M4$L!`A0`% ````@`7&7;+(9J/_EM`@``RP8```P``````````0`@`+:!````
M`%1E<W1,:6YK+F-C<%!+`0(4`!0````(`&5EVRS2"P@.IP0``#(-```,````
M``````$`( "V@9<"``!497-T3&EN:RYA<W!02P$"% `4````" !,9=LL* AA
ME&$!``#.`@``#0`````````!`" `MH%H!P``5&5S=$QI;FLN:'1M;%!+`0(4
M`!0````(`&1EVRREHK=F( (``(H&```.``````````$`( "V@?0(``!497-T
@3&EN:V5D+F-C<U!+!08`````! `$`.L```! "P``````
`
end
|
|
|
|
Mark
|
| Posted: 06/27/2002, 1:51 PM |
|
Hi Robert,
many thanks - I'll take a look & get back to you.
Regards,
Mark
Robert Rodgers <Robert@SylvanComputing.com> wrote in message
news:affql5$h1c$1@news.codecharge.com...
> Another way is to keep posting to the current page Here is an example.
This
> is an ASP example but I don't think it should matter.
>
> You will need to set up a connection named "Connection1" that points to
the
> Internet database (this example uses "users", and "user_groups") and point
> to your publishing location
>
> --
> Robert Rodgers
>Robert@SylvanComputing.com
> Ph: 509.531.4351
> Fax: 503.961.0317
> Text Message: mailto:5095314351@mobile.att.net
> ===============================================
> *** NEW ***
> See our web hosting options
> 500MB Web Space, NT2000 Hosted, Unmetered Data
> Transfer, Unlimited Email, Unlimited Email
> Aliases, Web based mail access, MSSQL2000, ASP,
> Coldfusion, PHP, Frontpage 2000, Server Side
> Includes (.stm, .shtm, .shtml), RealAudio/Video,
> SSL Security, E-commerce Shopping Cart
> $360.00/yr or $35/mo
> www.sylvancomputing.com
> ---
> "Mark" <mark@markate.demon.co.uk> wrote in message
>news:afd846$kob$1@news.codecharge.com...
> > Hi,
> >
> > What I'm trying to do is to get one listbox populated based on another.
> > I know there's a javascript workaround for this, but I don't want to
load
> > all the data to the client, as I'm acutely aware how easy it is for your
> PC
> > to run out of resources, regardless of the RAM available !
> >
> > How can I make use of a button or link, to force the listbox in question
> to
> > re-populate itself from the server, when clicked ?
> >
> > For Example, I think what I could do is set a session parameter in the
> > Client OnChange event of the first listbox to hold the new key based on
> the
> > selection made.
> >
> > Then have a button which has a server OnClick event, that executes some
> SQL
> > based on the session parameter to get the correct entries & then
populate
> > the second listbox....
> >
> > That's my theory, but can anyone show me how to actually do this as I'm
> not
> > having any luck so far !!
> >
> > Using PHP & MySQL.
> >
> > Many Thanks,
> > Mark
> >
> >
> >
>
>
>
|
|
|
|
|
