Listing Data from mdb. in a listbox

obekdik wrote:
> This is the same thing I did before I wrote the code it didn't make what I want. By this ?t only shows I data ? want to see all the data

Sounds like your doing something wrong, or I am misunderstanding your
problem.

The code you showed doesn't include the loop, so something didn't work.

Dooza

This is the same thing I did before I wrote the code it didn't make what I want. By this ıt only shows I data ı want to see all the data

obekdik wrote:
> Hello guys thx for help
>
> I have a huge database with about 3000 datas. This database holds 8 different
> tables with 4 5 different colomns. I tried to build a web interface for my
> collegues to enter their datas by using this interface. I face a problem.
>
> What I want to do for ex. is make a list of Company Names in a text box by
> calling them from my mdb. I tried to use the code in the attachment, that code
> but by that I could only list one agent name to the page. How can show the
> whole agent names in a box and make them choose one from the list for the new
> entry
>
> <select name="AgentName" size="1" id="AgentName">
> <option value="">Agent...</option>
> <option value="<%=rs1("AgentName")%>"><%=rs1("AgentName")%></option></select>
>

You need to loop through your recordset.

Its easy to do using the built in behaviours in Dreamweaver CS3.

1. Create your recordset
2. Insert list/menu from the Form panel
3. Select your list on the page, then from the properties panel click on
Dynamic
4. Select your recordset, label and value.
5. Job done, grab yourself a coffee and marvel at the power of Dreamweaver.

Dooza