|
 |
asp_databases thread: records in a drop down menu
Message #1 by "Arsalan" <arsal21@y...> on Mon, 30 Apr 2001 14:41:08
|
|
i am calling the records of a field (of Access Table) in a drop down box.
The problem is that i want to display a single record only once, no mater
how many times it is repeating in the column of the table.
how is it possible ?
Message #2 by "kaps pandya" <kapinjal@m...> on Mon, 30 Apr 2001 23:59:02 +1000
|
|
hi
i think u should use a distinct in ur query so u will have those
records u want only once..
probably it work
regards
Message #3 by "Jason Byrnes" <byrnes@f...> on Mon, 30 Apr 2001 09:58:50 -0400
|
|
Hi Arsalan,
try using "SELECT DISTINCT fieldname FROM tablename" as youre SQL statement.
This will ensure only unique values are returned. then step through the
recordset to write the drop down.
Hope this helps,
Jason
"Arsalan" <arsal21@y...> wrote in message news:61135@a..._databases...
>
> i am calling the records of a field (of Access Table) in a drop down box.
> The problem is that i want to display a single record only once, no mater
> how many times it is repeating in the column of the table.
> how is it possible ?
>
>
|
|
|
View Cart
