Best way to design this page ?

Posted on 2004-10-29
Medium Priority
Last Modified: 2010-04-06

I need to create a page to do a specific task but I do not know if it is possible or which web development language would be best to use (I have a small amount of experience using ASP)

I am interested to hear from anyone with more experience than myself that could point me in the right direction.

The page needs to have 5 buttons along the top, clicking the buttons will populate a list type box on the left of the page with different information depending on the button clicked, the info is stored in an Access database.
Upon selecting a value from the list box another larger list box is displayed (filling the remainder of the page) with more detailed information from the Access database, clicking a value from this list box will open a new page with further detailed info.

I have used ASP and DSN connection-less (I think it's called) to connect to an Access database in the past but as this runs server side I don't think I can use it to do this new page.

I have considered the following ideas but not sure if they will work or if there is a better way ?

Using ASP - recursive page, the buttons would be a form, when button clicked the page is refreshed, if a value has been past back to the page then depending on this value use ASP to populate the list box, same idea when the list box is clicked to populate the main bigger list box.

Using Javascript 1 - Populate 5 list boxes using ASP, use javascript or forms to create 5 buttons, when clicked the buttons cause the relevant list box to be displayed (don't know how to get the 5 list boxes to be displayed in the same place on the page though), also cannot work out how to populate the main bigger list box.

Using Javascript 2 - Use javascript or forms to create 5 buttons, use Javascript to connect to database, use 1 list box that is populated depending on button clicked, use onclick of list box to run Javascript to populate main bigger list box.

I appreciate any advice you can give
Question by:duckp

Accepted Solution

rlibrandi earned 672 total points
ID: 12444554
I've used ASP to do exactly what you're looking for and it's worked very well.  

Any ADO connection (DSN or DSN-less) always runs server-side in ASP.  DSN-less connection just means that the server doesn't need an ODBC DSN configured to connect to the database.  

Assisted Solution

phpisthefuture earned 664 total points
ID: 12444685
You can either use ASP and Access or PHP/MySQL, they will both work fine. If you have some ASP background, you can go ahead and start with ASP/Access.
A great tutorials series for ASP:
Tons of ASP scripts, most of them have GPL, so you can play with them.
After you start working on it, you can always ask questions about the code.
Good luck and let us know if you have further questions.

Expert Comment

ID: 12446945
I wouls use ASP. The design part .... I am more into .net so for my ASP pages I try to build the controllers to keep the display logic seperate.

I would keep the display page seperate than the logic of accesing the dbase the controller page can be an asp where u provide different services to the display pages. Its easy ... jsut write an if then else loop and depending on the request serve them the output..

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


Expert Comment

ID: 12447125
You can do the if..then...else logic in straight ASP.  The code on the page gets pretty big, though.

Expert Comment

ID: 12447148
I know dude thats the problem :) ... But I have developed seperate controllers for different operations and i delegate my tasks that way code is managable ... and easy for maintenance

Author Comment

ID: 12448510
Thanks for the comments but I'm still unsure how to tackle this project.

Is it possible to populate different list boxes on a page using ASP depending on the click of a button ?

Should the buttons be created using Javascript or form buttons ?

Could you explain the controller page idea, sounds good but I don't understand how it works.



Assisted Solution

rohanbairat3 earned 664 total points
ID: 12448617
Create those buttons as form buttons. On click of a button you can post back the form to itself and populate the list with asp ..

here is one of the way to do it ...
 Set objConn = server.createobject("ADODB.Connection")
      Set objUserData = Server.CreateObject("ADODB.Recordset")
       objConn.ConnectionString =  "DSN=dsnanme;UID=username;PWD=password;"
strSQL = "Select listitem FROM urtable group by listitem  order by listitem "

<SELECT NAME="Comments" SIZE=3 MULTIPLE <%=disableCommentsBox%>>
                   If objUserData.EOF Then
              Do While Not objUserData.EOF

                   <option value ="<%=objUserData("listitem ")%>">objUserData("listitem ")</option>

         End If

Expert Comment

ID: 12448651
The controller thing is ok ... dont worry about that too much .....

you can put in the code i have written as a generic function. pass table name column name and list box name to it so it can create as many list boxes you want.

So if a user clicks the Submit button send a request parameter or session parameter back ....  you can write a java script to do that too...


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question