Don Oldenburg
|
| Posted: 08/20/2001, 1:49 PM |
|
Okay -- I'm getting very frustrated...
Can someone send me their code for a dynamic listbox in ASP? I need to know
what the header/footer code is, as well as any events... I'm having a
terrible time getting this to function within CC.. I've got a working model
OUTSIDE of CC, but no cant implement it into CC.
HELP!
|
|
|
 |
Megan Garrison
|
| Posted: 08/20/2001, 3:58 PM |
|
hi Dan ~ here is what works for me, BUT it does not work in netscape and the
dependent list boxes MUST be on a page that is not getting any
variables/values passed to it via URL
dependent list boxes for country (canada & us) and state/province. I have a
country table (tbleCountries) with a country_id and country fields and I
have a locations table (tblLocations) with location_id, state, and
country_id fields.
I put this code in the forms Events, under Open:
'start
set rs = cn.execute("select [c].[country_id] as catid,[c].[country] as
catname from [tblCountries] c where [country_id] <> '99999';")
set subrs = Server.CreateObject("ADODB.Recordset")
while not rs.eof
set subrs = cn.execute ("select location_id as my_location_id,state as name
from [tblLocations] where country_id= '" & rs(0) & "'" )
while not subrs.eof
name = subrs(1)
id = subrs(0)
subrs.MoveNext
if subrs.eof then
SetVar "subcat" , """" & name & "#" & id & """"
else
SetVar "subcat" , """" & name & "#" & id & ""","
end if
Parse "subcats",true
wend
subrs.close
SetVar "cat" , rs(1) & "#" & rs(0)
Parse "cats",true
SetVar "subcats",""
rs.MoveNext
wend
rs.close
'end
and I put this code under the footer part of the same form (form is named
SearchGroups)
<code>
<script language="Javascript">
var cats = new Array();
<!--Begincats-->
cats["{cat}"] = new Array(
<!--Beginsubcats-->
{subcat}
<!--Endsubcats-->
);
<!--Endcats-->
var k=0;
for (i in cats) {
cat_name_id = i.toString().split("#");
document.forms["SearchGroups"].country_id.options[k] = new Option
cat_name_id[0] , cat_name_id[1])
k=k+1;
}
/*for (i in cats) {
cat_name_id = i.toString().split("#");
document.forms["SearchGroups"].country_id.options[k] = new Option
cat_name_id[0] , cat_name_id[1])
k=k+1;
}*/
function set_subcat() {
var lbopt = document.SearchGroups.country_id.options;
var arr = cats[lbopt[lbopt.selectedIndex].text];
key = lbopt[lbopt.selectedIndex].text + "#" +
lbopt[lbopt.selectedIndex].value;
for (i=document.SearchGroups.my_location_id.options.length; i >=0 ; i--) {
document.SearchGroups.my_location_id.options=null;
}
for (i=0; i < cats[key].length; i++) {
subcat_name_id = cats[key].split("#");
document.SearchGroups.my_location_id.options = new
Option(subcat_name_id[0],subcat_name_id[1])
}
}
document.all["country_id"].onchange = set_subcat;
function parseQueryString (str) {
str = str ? str : location.search;
var query = str.charAt(0) == '?' ? str.substring(1) : str;
var args = new Object();
if (query) {
var fields = query.split('&');
for (var f = 0; f < fields.length; f++) {
var field = fields[f].split('=');
args[unescape(field[0].replace(/\+/g, ' '))] =
unescape(field[1].replace(/\+/g, ' '));
}
}
return args;
}
file://restore listbox settings
var args = parseQueryString ();
for (var arg in args) {
var opt = document.SearchGroups.elements[arg].options;
for (i=0; i < opt.length; i++) {
file://alert (opt.value + " - "+ args[arg]);
if (opt.value == args[arg])
opt.selected = true;
break; }
}
}
set_subcat();
</script>
</code>
Then in the "Country" and "State" fields, set for listbox, set the List
properties with List of Values as 1;dummy (no join at all)
I have not tried to post code here so In case the above does not show, I am
making a txt file attachment
hope this helps, ~Megan
PS if you ever come up with something that works in netscape or when
variables are being transferred< I'd love to have the code.
begin 666 dependent_listbox.txt
M22!P=70@=&AI<R!C;V1E(&EN('1H92!F;W)M<R!%=F5N=',L('5N9&5R($]P
M96XZ#0H-"B=S=&%R= T*#0H-"G-E="!R<R ](&-N+F5X96-U=&4H(G-E;&5C
M="!;8UTN6V-O=6YT<GE?:61=(&%S(&-A=&ED+%MC72Y;8V]U;G1R>5T@87,@
M8V%T;F%M92!F<F]M(%MT8FQ#;W5N=')I97-=(&,@=VAE<F4@6V-O=6YT<GE?
M:61=(#P^("<Y.3DY.2<[(BD-"@T*<V5T('-U8G)S(#T@4V5R=F5R+D-R96%T
M94]B:F5C="@B041/1$(N4F5C;W)D<V5T(BD-"@T*=VAI;&4@;F]T(')S+F5O
M9@T*#0IS970@<W5B<G,@/2!C;BYE>&5C=71E("@B<V5L96-T(&QO8V%T:6]N
M7VED(&%S(&UY7VQO8V%T:6]N7VED+'-T871E(&%S(&YA;64@9G)O;2!;=&)L
M3&]C871I;VYS72!W:&5R92!C;W5N=')Y7VED/2 G(B F(')S*# I("8@(B<B
M("D-"@T*=VAI;&4@;F]T('-U8G)S+F5O9@T*;F%M92 ]('-U8G)S*#$I#0II
M9" ]('-U8G)S*# I#0IS=6)R<RY-;W9E3F5X= T*:68@<W5B<G,N96]F('1H
M96X-"E-E=%9A<B B<W5B8V%T(B L("(B(B(@)B!N86UE("8@(B,B("8@:60@
M)B B(B(B#0IE;'-E( T*4V5T5F%R(")S=6)C870B("P@(B(B(B F(&YA;64@
M)B B(R(@)B!I9" F("(B(BPB#0IE;F0@:68-"E!A<G-E(")S=6)C871S(BQT
M<G5E#0IW96YD#0IS=6)R<RYC;&]S90T*#0H-"E-E=%9A<B B8V%T(B L(')S
M*#$I("8@(B,B("8@<G,H,"D-"E!A<G-E(")C871S(BQT<G5E#0I3971687(@
M(G-U8F-A=',B+"(B( T*<G,N36]V94YE>'0-"G=E;F0-"@T*<G,N8VQO<V4-
M"@T*#0HG96YD#0H-"@T*86YD($D@<'5T('1H:7,@8V]D92!U;F1E<B!T:&4@
M9F]O=&5R('!A<G0@;V8@=&AE('-A;64@9F]R;2 H9F]R;2!I<R!N86UE9"!3
M96%R8VA'<F]U<',I( T*#0H-"@T*/'-C<FEP="!L86YG=6%G93TB2F%V87-C
M<FEP="(^#0IV87(@8V%T<R ](&YE=R!!<G)A>2@I.PT*#0H\(2TM0F5G:6YC
M871S+2T^#0IC871S6R)[8V%T?2)=(#T@;F5W($%R<F%Y* T*/"$M+4)E9VEN
M<W5B8V%T<RTM/@T*>W-U8F-A='T-"CPA+2U%;F1S=6)C871S+2T^#0HI.PT*
M/"$M+45N9&-A=',M+3X-"G9A<B!K/3 [#0IF;W(@*&D@:6X@8V%T<RD@>PT*
M8V%T7VYA;65?:60@/2!I+G1O4W1R:6YG*"DN<W!L:70H(B,B*3L-"F1O8W5M
M96YT+F9O<FUS6R)396%R8VA'<F]U<',B72YC;W5N=')Y7VED+F]P=&EO;G-;
M:UT@/2!N97<@3W!T:6]N("@@8V%T7VYA;65?:61;,%T@+"!C871?;F%M95]I
M9%LQ72D-"FL]:RLQ.PT*?0T*#0HO*F9O<B H:2!I;B!C871S*2![#0IC871?
M;F%M95]I9" ](&DN=&]3=')I;F<H*2YS<&QI="@B(R(I.PT*9&]C=6UE;G0N
M9F]R;7-;(E-E87)C:$=R;W5P<R)=+F-O=6YT<GE?:60N;W!T:6]N<UMK72 ]
M(&YE=R!/<'1I;VX@*"!C871?;F%M95]I9%LP72 L(&-A=%]N86UE7VED6S%=
M*0T*:SUK*S$[#0I]*B\-"@T*#0H-"F9U;F-T:6]N('-E=%]S=6)C870H*2![
M#0H-"G9A<B!L8F]P=" ](&1O8W5M96YT+E-E87)C:$=R;W5P<RYC;W5N=')Y
M7VED+F]P=&EO;G,[#0IV87(@87)R(#T@8V%T<UML8F]P=%ML8F]P="YS96QE
M8W1E9$EN9&5X72YT97AT73L-"FME>2 ](&QB;W!T6VQB;W!T+G-E;&5C=&5D
M26YD97A=+G1E>'0@*R B(R(@*R!L8F]P=%ML8F]P="YS96QE8W1E9$EN9&5X
M72YV86QU93L-"@T*9F]R("AI/61O8W5M96YT+E-E87)C:$=R;W5P<RYM>5]L
M;V-A=&EO;E]I9"YO<'1I;VYS+FQE;F=T:#L@:2 ^/3 @.R!I+2TI('L-"F1O
M8W5M96YT+E-E87)C:$=R;W5P<RYM>5]L;V-A=&EO;E]I9"YO<'1I;VYS6VE=
M/6YU;&P[#0I]#0H-"@T*#0H-"F9O<B H:3TP.R!I(#P@8V%T<UMK97E=+FQE
M;F=T:#L@:2LK*2![#0IS=6)C871?;F%M95]I9" ](&-A='-;:V5Y75MI72YS
M<&QI="@B(R(I.R -"F1O8W5M96YT+E-E87)C:$=R;W5P<RYM>5]L;V-A=&EO
M;E]I9"YO<'1I;VYS6VE=(#T@;F5W($]P=&EO;BAS=6)C871?;F%M95]I9%LP
M72QS=6)C871?;F%M95]I9%LQ72D-"GT@#0H-"GT-"@T*9&]C=6UE;G0N86QL
M6R)C;W5N=')Y7VED(ETN;VYC:&%N9V4@/2!S971?<W5B8V%T.PT*9G5N8W1I
M;VX@<&%R<V51=65R>5-T<FEN9R H<W1R*2![#0IS='(@/2!S='(@/R!S='(@
M.B!L;V-A=&EO;BYS96%R8V@[#0IV87(@<75E<GD@/2!S='(N8VAA<D%T*# I
M(#T]("<_)R _('-T<BYS=6)S=')I;F<H,2D@.B!S='([#0IV87(@87)G<R ]
M(&YE=R!/8FIE8W0H*3L-"FEF("AQ=65R>2D@>PT*=F%R(&9I96QD<R ]('%U
M97)Y+G-P;&ET*"<F)RD[#0IF;W(@*'9A<B!F(#T@,#L@9B \(&9I96QD<RYL
M96YG=&@[(&8K*RD@>PT*=F%R(&9I96QD(#T@9FEE;&1S6V9=+G-P;&ET*"<]
M)RD[#0IA<F=S6W5N97-C87!E*&9I96QD6S!=+G)E<&QA8V4H+UPK+V<L("<@
M)RDI72 ]( T*=6YE<V-A<&4H9FEE;&1;,5TN<F5P;&%C92@O7"LO9RP@)R G
M*2D[#0I]#0I]#0IR971U<FX@87)G<SL-"GT-"@T*9FEL93HO+W)E<W1O<F4@
M;&ES=&)O>"!S971T:6YG<PT*=F%R(&%R9W,@/2!P87)S95%U97)Y4W1R:6YG
M("@I.PT*9F]R("AV87(@87)G(&EN(&%R9W,I('L-"G9A<B!O<'0@/2!D;V-U
M;65N="Y396%R8VA'<F]U<',N96QE;65N='-;87)G72YO<'1I;VYS.PT*9F]R
M("AI/3 [(&D@/"!O<'0N;&5N9W1H.R!I*RLI('L-"F9I;&4Z+R]A;&5R=" H
M;W!T6VE=+G9A;'5E("L@(B M("(K(&%R9W-;87)G72D[#0II9B H;W!T6VE=
M+G9A;'5E(#T](&%R9W-;87)G72D@>R -"F]P=%MI72YS96QE8W1E9" ]('1R
M=64[( T*8G)E86L[('T-"GT-"@T*?0T*#0IS971?<W5B8V%T*"D[#0H\+W-C
M<FEP=#X-"@T*#0II;B!T:&4@(D-O=6YT<GDB(&%N9" B4W1A=&4B(&9I96QD
M<RP@<V5T(&9O<B!L:7-T8F]X+"!S970@=&AE($QI<W0@<')O<&5R=&EE<R!W
M:71H($QI<W0@;V8@5F%L=65S(&%S(#$[9'5M;7D@*&YO(&IO:6X@870@86QL
#*0T*
`
end
|
|
|
|
Jason Charette
|
| Posted: 08/21/2001, 5:37 PM |
|
If you don't menu using a "menu" page (as opposed to grid or record, where
this technique is trickier), let me know - I'm pretty confident I've got a
method of achieving this.
Jason
"Don Oldenburg" <don.oldenburg@cacmnet.com> wrote in message
news:9lrt4j$t6e$1@news.codecharge.com...
> Okay -- I'm getting very frustrated...
>
> Can someone send me their code for a dynamic listbox in ASP? I need to
know
> what the header/footer code is, as well as any events... I'm having a
> terrible time getting this to function within CC.. I've got a working
model
> OUTSIDE of CC, but no cant implement it into CC.
>
> HELP!
>
>
|
|
|
|
kmc
|
| Posted: 08/21/2001, 9:08 PM |
|
Jason,
Lots of folks would like to see your method.
I want to use in Search forms, record forms and menu.
Every hint and tip welcomed here.
kmc
"Jason Charette" <jasoncharette@hotmail.com> wrote in message
news:9luurc$4f4$1@news.codecharge.com...
> If you don't menu using a "menu" page (as opposed to grid or record, where
> this technique is trickier), let me know - I'm pretty confident I've got a
> method of achieving this.
>
> Jason
|
|
|
|
Jason Charette
|
| Posted: 08/22/2001, 3:41 AM |
|
1. Create a menu, and add one item, leave it as label. This will be your
dropdown. (Don't worry, I'm not crazy - hold on).
2. In form properties, events, before show, you will put all of your code to
generate the drop-down, but the tricky part is that you MUST treat this code
as a string. In other words, it must have name assignment(in this case,
let's use $thistemp), if there are quotes, you may have to escape them, and
you will certainly have to surround your code with quotes (example below).
Then add these two lines:
$tpl->set_var("THISISMYCODE", $thistemp);
$tpl->parse("THISISMYCODE", false);
3. In the menu form, past the following into your caption:
<!--BeginTHISISMYCODE-->
{THISISMYCODE}
<!--EndTHISISMYCODE-->
4. Generate page, sit back, and enjoy!
Example using PHP, but should work with anything:
Events, before show:
$thistemp = "<ul><li>Howdy!<BR><li>This is a second item!<BR><li>Now I am
tired of this!<br></ul>";
$tpl->set_var("THISISMYCODE", $thistemp);
$tpl->parse("THISISMYCODE", false);
-- Remember to insert the block in step three, and if I haven't forgotten
anything, it'll work.
Cheers, and hope this helps.
Many thanks to the CC techsupport guys, and especially to Alex, for this
one...
Jason.
"kmc" <kmc@tasmail.com> wrote in message
news:9lvb89$obh$1@news.codecharge.com...
> Jason,
>
> Lots of folks would like to see your method.
> I want to use in Search forms, record forms and menu.
> Every hint and tip welcomed here.
> kmc
>
> "Jason Charette" <jasoncharette@hotmail.com> wrote in message
>news:9luurc$4f4$1@news.codecharge.com...
> > If you don't menu using a "menu" page (as opposed to grid or record,
where
> > this technique is trickier), let me know - I'm pretty confident I've got
a
> > method of achieving this.
> >
> > Jason
>
>
>
|
|
|
|
Jason Charette
|
| Posted: 08/22/2001, 4:58 AM |
|
Allow me to amend that - $thistemp should contain the HTML that your code
generates - not your code itself! Sorry about that. Teach me to answer these
things, first thing in the morning.... :)
J.
"Jason Charette" <jasoncharette@hotmail.com> wrote in message
news:9m028d$v5f$1@news.codecharge.com...
> 1. Create a menu, and add one item, leave it as label. This will be your
> dropdown. (Don't worry, I'm not crazy - hold on).
>
> 2. In form properties, events, before show, you will put all of your code
to
> generate the drop-down, but the tricky part is that you MUST treat this
code
> as a string. In other words, it must have name assignment(in this case,
> let's use $thistemp), if there are quotes, you may have to escape them,
and
> you will certainly have to surround your code with quotes (example below).
> Then add these two lines:
> $tpl->set_var("THISISMYCODE", $thistemp);
> $tpl->parse("THISISMYCODE", false);
>
> 3. In the menu form, past the following into your caption:
>
> <!--BeginTHISISMYCODE-->
> {THISISMYCODE}
> <!--EndTHISISMYCODE-->
>
> 4. Generate page, sit back, and enjoy!
>
> Example using PHP, but should work with anything:
>
> Events, before show:
>
> $thistemp = "<ul><li>Howdy!<BR><li>This is a second item!<BR><li>Now I am
> tired of this!<br></ul>";
> $tpl->set_var("THISISMYCODE", $thistemp);
> $tpl->parse("THISISMYCODE", false);
>
> -- Remember to insert the block in step three, and if I haven't forgotten
> anything, it'll work.
>
> Cheers, and hope this helps.
>
> Many thanks to the CC techsupport guys, and especially to Alex, for this
> one...
>
> Jason.
>
>
> "kmc" <kmc@tasmail.com> wrote in message
>news:9lvb89$obh$1@news.codecharge.com...
> > Jason,
> >
> > Lots of folks would like to see your method.
> > I want to use in Search forms, record forms and menu.
> > Every hint and tip welcomed here.
> > kmc
> >
> > "Jason Charette" <jasoncharette@hotmail.com> wrote in message
> >news:9luurc$4f4$1@news.codecharge.com...
> > > If you don't menu using a "menu" page (as opposed to grid or record,
> where
> > > this technique is trickier), let me know - I'm pretty confident I've
got
> a
> > > method of achieving this.
> > >
> > > Jason
> >
> >
> >
>
>
|
|
|
|
Frank Rocco
|
| Posted: 08/22/2001, 10:47 AM |
|
I tried this and cannot get it to work.
In the Events Before Show I entered:
$thistemp = "<ul><li>Howdy!<BR><li>This is a second item! <BR><li>Now I
am
tired of this!<br></ul>";
$tpl->set_var("THISISMYCODE", $thistemp);
$tpl->parse("THISISMYCODE", false);
And in the menu label I entered:
<!--BeginTHISISMYCODE-->
{THISISMYCODE}
<!--EndTHISISMYCODE-->
My form does not load, script times out.
Thanks for the help
Frank
|
|
|
|
Jason Charette
|
| Posted: 08/22/2001, 11:35 AM |
|
That's weird.... Worked for me.
Okay, I use CC2.0, beta 5, with PHP and Templates, connecting to Postgresql.
I have two possible reasons why this may not have worked for you:
1- The "tpl" method is case sensitive. So make sure that the
> <!--BeginTHISISMYCODE-->
> {THISISMYCODE}
> <!--EndTHISISMYCODE-->
is exactly as specified... and that the "blockname" (in my case
THISISMYCODE) is case identical as well.
Further, knowing virtually nothing of ASP, the variable assignment probably
differs, so using my example verbatim may not work...
This method is the same as that used by CC itself. Take a look at the
template file generated by the app (in my case template.php but in yours
template.asp..?) This should give you a working example of how to achieve
the same effect using ASP.
Apart from that, I can't think of why it wouldn't work.
Good luck...
J.
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9m0r7o$jpj$1@news.codecharge.com...
> I tried this and cannot get it to work.
> In the Events Before Show I entered:
> $thistemp = "<ul><li>Howdy!<BR><li>This is a second item! <BR><li>Now
I
> am
> tired of this!<br></ul>";
> $tpl->set_var("THISISMYCODE", $thistemp);
> $tpl->parse("THISISMYCODE", false);
>
> And in the menu label I entered:
> <!--BeginTHISISMYCODE-->
> {THISISMYCODE}
> <!--EndTHISISMYCODE-->
>
> My form does not load, script times out.
>
> Thanks for the help
>
> Frank
>
>
|
|
|
|
CodeCharge
|
| Posted: 08/22/2001, 11:38 AM |
|
Hi Frank,
This code looks like PHP code. I belive you're using ASP ?
Adamm
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9m0r7o$jpj$1@news.codecharge.com...
> I tried this and cannot get it to work.
> In the Events Before Show I entered:
> $thistemp = "<ul><li>Howdy!<BR><li>This is a second item! <BR><li>Now
I
> am
> tired of this!<br></ul>";
> $tpl->set_var("THISISMYCODE", $thistemp);
> $tpl->parse("THISISMYCODE", false);
>
> And in the menu label I entered:
> <!--BeginTHISISMYCODE-->
> {THISISMYCODE}
> <!--EndTHISISMYCODE-->
>
> My form does not load, script times out.
>
> Thanks for the help
>
> Frank
>
>
|
|
|
|
Frank Rocco
|
| Posted: 08/22/2001, 11:49 AM |
|
Ok,
I thought I could mix ASP & PHP. My main project is defined as ASP 2.0
I guess I need an ASP version as I do not yet know PHP.
Thanks
Frank
|
|
|
|
|
