Thanks everyone for your suggestions. FYI, this is what I got to work:
select dlo_id, dlo_locn
from del_locn
order by dlo_locn
select user_del.dlo_id
from del_locn, user_del
where del_locn.dlo_id = user_del.dlo_id
and user_del.usr_id = #usr_id2#
#dlo_l
ll opinions expressed herein are those of the author and not of The Board
of Executors
> -Original Message-
> From: Ricq Pattay [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 11, 2000 3:33 PM
> To: [EMAIL PROTECTED]
> Subject: pre-selecting items in a multiple list box
Ricq,
The other response you got pretty well sums up the problem you've got -
you're only the value in your output loop to a single value from the user's
delivery locations. The way I see it you've got two choices:
1> Use a ListFind(get_del_locn.dlo_id,
ValueList(get_user_del_locn.dlo_id))
Try changing your cfif statement to this:
Joy
At 08:33 AM 4/11/00 -0500, you wrote:
>I'm using a CF template that attempts to pre-select several items in a list
>box based on values returned from 2 queries. If a match occurs, that entry
>in the list box should be selected. There will almost a
Pattay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 11, 2000 2:33 PM
Subject: pre-selecting items in a multiple list box
> I'm using a CF template that attempts to pre-select several items in a
list
> box based on values returned from 2 queries. If a mat
I'm using a CF template that attempts to pre-select several items in a list
box based on values returned from 2 queries. If a match occurs, that entry
in the list box should be selected. There will almost always be more than
one match. Specifically, the list box should list all possible delivery
l
6 matches
Mail list logo