Non-repeating items

[LC]

Hi,

Lets say I connected to an Access database and created an
sql and then created a drop down list.

<%
strSQL = "SELECT tblEV3Location.Division,
tblEV3Location.Code FROM tblEV3Location
ORDER BY tblEV3Location.Division;"

set cars=adoCon.execute(strSQL)
%>

<select name="Division">
<% 'Loop through the recordset to make each entry
in the list. %>
<% do while not cars.eof %>
<Option value = "<%= cars(1) %>"> <%= cars
(0) %></Option>
<%cars.movenext
loop%>
</select>

How can I make the drop down contain unqiue values that
is not repeating any of the items in the list?

Any help appreciated.
Thanks.

[Aaron [SQL Server MVP]]

Why are you posting the same question again?

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"LC" <lc@hotmail.com> wrote in message
news:5e2901c474d1$cd9f42d0$a601280a@phx.gbl...

> Hi,
>
> Lets say I connected to an Access database and created an
> sql and then created a drop down list.
>
> <%
> strSQL = "SELECT tblEV3Location.Division,
> tblEV3Location.Code FROM tblEV3Location
> ORDER BY tblEV3Location.Division;"
>
> set cars=adoCon.execute(strSQL)
> %>
>
> <select name="Division">
> <% 'Loop through the recordset to make each entry
> in the list. %>
> <% do while not cars.eof %>
> <Option value = "<%= cars(1) %>"> <%= cars
> (0) %></Option>
> <%cars.movenext
> loop%>
> </select>
>
> How can I make the drop down contain unqiue values that
> is not repeating any of the items in the list?
>
> Any help appreciated.
> Thanks.
>

[Aaron [SQL Server MVP]]

Uh, why would it have repeating items? Do you not have a primary key on
tblEV3Location? If not, why not?

What's with the tbl prefix? Why use the tablename prefix throughout the
query when you're only referencing one table?

SELECT Division, Code
FROM tblEV3Location
GROUP BY Division, Code
ORDER BY Division

If that doesn't do what you want, see [url]http://www.aspfaq.com/5006[/url] -- which
deals with providing us enough information so that we understand the problem
and your requirements.

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"LC" <lc@hotmail.com> wrote in message
news:5e2901c474d1$cd9f42d0$a601280a@phx.gbl...

> Hi,
>
> Lets say I connected to an Access database and created an
> sql and then created a drop down list.
>
> <%
> strSQL = "SELECT tblEV3Location.Division,
> tblEV3Location.Code FROM tblEV3Location
> ORDER BY tblEV3Location.Division;"
>
> set cars=adoCon.execute(strSQL)
> %>
>
> <select name="Division">
> <% 'Loop through the recordset to make each entry
> in the list. %>
> <% do while not cars.eof %>
> <Option value = "<%= cars(1) %>"> <%= cars
> (0) %></Option>
> <%cars.movenext
> loop%>
> </select>
>
> How can I make the drop down contain unqiue values that
> is not repeating any of the items in the list?
>
> Any help appreciated.
> Thanks.
>

[lc]

It is not the same question.

>-----Original Message-----
>Why are you posting the same question again?
>
>--
>[url]http://www.aspfaq.com/[/url]
>(Reverse address to reply.)
>
>
>
>
>"LC" <lc@hotmail.com> wrote in message
>news:5e2901c474d1$cd9f42d0$a601280a@phx.gbl...

>> Hi,
>>
>> Lets say I connected to an Access database and created

an

>> sql and then created a drop down list.
>>
>> <%
>> strSQL = "SELECT tblEV3Location.Division,
>> tblEV3Location.Code FROM tblEV3Location
>> ORDER BY tblEV3Location.Division;"
>>
>> set cars=adoCon.execute(strSQL)
>> %>
>>
>> <select name="Division">
>> <% 'Loop through the recordset to make each entry
>> in the list. %>
>> <% do while not cars.eof %>
>> <Option value = "<%= cars(1) %>"> <%= cars
>> (0) %></Option>
>> <%cars.movenext
>> loop%>
>> </select>
>>
>> How can I make the drop down contain unqiue values that
>> is not repeating any of the items in the list?
>>
>> Any help appreciated.
>> Thanks.
>>

>
>
>.
>

[dave]

strSQL = "SELECT DISTICT tblEV3Location.Division, ..........



"LC" <lc@hotmail.com> wrote in message
news:5e2901c474d1$cd9f42d0$a601280a@phx.gbl...

> Hi,
>
> Lets say I connected to an Access database and created an
> sql and then created a drop down list.
>
> <%
> strSQL = "SELECT tblEV3Location.Division,
> tblEV3Location.Code FROM tblEV3Location
> ORDER BY tblEV3Location.Division;"
>
> set cars=adoCon.execute(strSQL)
> %>
>
> <select name="Division">
> <% 'Loop through the recordset to make each entry
> in the list. %>
> <% do while not cars.eof %>
> <Option value = "<%= cars(1) %>"> <%= cars
> (0) %></Option>
> <%cars.movenext
> loop%>
> </select>
>
> How can I make the drop down contain unqiue values that
> is not repeating any of the items in the list?
>
> Any help appreciated.
> Thanks.
>

[joker]

Don't you mean 'strSQL = "SELECT DISTINCT tblEV3Location.Division,
...........'?

dave wrote:

> strSQL = "SELECT DISTICT tblEV3Location.Division, ..........
>
>
>
> "LC" <lc@hotmail.com> wrote in message
> news:5e2901c474d1$cd9f42d0$a601280a@phx.gbl...
>

>>Hi,
>>
>>Lets say I connected to an Access database and created an
>>sql and then created a drop down list.
>>
>><%
>>strSQL = "SELECT tblEV3Location.Division,
>>tblEV3Location.Code FROM tblEV3Location
>>ORDER BY tblEV3Location.Division;"
>>
>>set cars=adoCon.execute(strSQL)
>>%>
>>
>><select name="Division">
>><% 'Loop through the recordset to make each entry
>>in the list. %>
>><% do while not cars.eof %>
>><Option value = "<%= cars(1) %>"> <%= cars
>>(0) %></Option>
>><%cars.movenext
>>loop%>
>></select>
>>
>>How can I make the drop down contain unqiue values that
>>is not repeating any of the items in the list?
>>
>>Any help appreciated.
>>Thanks.
>>

>
>
>

[David C. Holley]

My suspicion is that the underlying database design could use some work.
Why would you ever have more than one division if the table contains
details on all of the divisions?

David H

joker wrote:

> Don't you mean 'strSQL = "SELECT DISTINCT tblEV3Location.Division,
> ..........'?
>
> dave wrote:
>

>> strSQL = "SELECT DISTICT tblEV3Location.Division, ..........
>>
>>
>>
>> "LC" <lc@hotmail.com> wrote in message
>> news:5e2901c474d1$cd9f42d0$a601280a@phx.gbl...
>>

>>> Hi,
>>>
>>> Lets say I connected to an Access database and created an
>>> sql and then created a drop down list.
>>>
>>> <%
>>> strSQL = "SELECT tblEV3Location.Division,
>>> tblEV3Location.Code FROM tblEV3Location
>>> ORDER BY tblEV3Location.Division;"
>>>
>>> set cars=adoCon.execute(strSQL)
>>> %>
>>>
>>> <select name="Division">
>>> <% 'Loop through the recordset to make each entry
>>> in the list. %>
>>> <% do while not cars.eof %>
>>> <Option value = "<%= cars(1) %>"> <%= cars
>>> (0) %></Option>
>>> <%cars.movenext
>>> loop%>
>>> </select>
>>>
>>> How can I make the drop down contain unqiue values that
>>> is not repeating any of the items in the list?
>>>
>>> Any help appreciated.
>>> Thanks.
>>>

>>
>>
>>

>