?
Solved

Data displayed from dropdown moving down the page

Posted on 2013-06-21
5
Medium Priority
?
286 Views
Last Modified: 2013-06-21
Below is the code in my sub that is displaying the inventory when a color is chosen from a dropdown menu.  When you select the first color in the list it lists the inventory directly next to 'Available Inventory:' When you select the second color it moves down 2 lines, the third color moves down 3 lines.  I assume it has to do with my loop, any ideas?

    intrecordcount = objRS.recordcount
    stylecount = 0

    response.Write "<tr><td><font size=""2pt"">Available Inventory: </font></td>"
    
    while not objRS.eof
    
    stylecount = stylecount + 1
    
    response.Write "<td>"& vbCRLF

    if request.QueryString("Color_id") <> "" then    'if there is a color selected show that colors inventory
        if clng(objrs.fields("color_id")) = clng(request.QueryString("Color_id")) then
            if isnull(objRS.fields("Color_value")) then
            else
            response.write ("<font size=""2pt"">"&objRS.fields("Color_value")&" - </font>")
            end if
            if isnull(objRS.fields("Size_value")) then
            else
            response.write ("<font size=""2pt"">"&objRS.fields("Size_value")&" - </font>")
            end if
            response.Write ("<font size=""2pt"">"&objRS.fields("Inventory")&"</font>")    
            end if
         end if


    if intrecordcount = stylecount then
        response.Write "</td></tr>"
    else
       response.Write "</td></tr><tr><td>"
    end if
   
    objRS.movenext
    wend

    response.Write "<tr><td colspan=""2""><hr color=""dfdfdf"" /></td></tr>"& vbCRLF

Open in new window

0
Comment
Question by:AdrienneSperber
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 58

Expert Comment

by:Gary
ID: 39266606
In your loop your moving to the next row with each iteration, you are also setting <td> at the start and end so that will be double up.
But your question is not really clear what is moving/wrong, when you change a select box, when you reload the page...?
0
 
LVL 9

Author Comment

by:AdrienneSperber
ID: 39266626
The dropdown uses an onchange function and reloads the page to display the inventory for the color selected in the menu.  The inventory that is displayed moves down a space on the page.
0
 
LVL 58

Expert Comment

by:Gary
ID: 39266641
Post the actual html from the page or better a link
0
 
LVL 9

Author Comment

by:AdrienneSperber
ID: 39266662
0
 
LVL 58

Accepted Solution

by:
Gary earned 2000 total points
ID: 39266686
You're obviously selecting all colors in the sql, why not just select the rows that match the color then you wouldn't have all those blank rows where the color doesn't match the ID.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

765 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