follow up to "displaying SQL results on webpage"

Discussion in 'Programming' started by Chenks, Aug 23, 2013.

Share This Page

  1. Chenks

    Chenks Registered Trader

    Joined:
    Jan 5, 2002
    Messages:
    3,741
    Likes Received:
    0
    OK well i got a working (albeit very slow) version working.
    basically just to get it working i used a separate query for each team per day (so 55 queries in total!).

    it displays the results in a table as required.

    now, it takes about 2 minutes to run all those queries which isn't great.
    going thru the optimising process now to cut it down.

    using 1 query per team, i am trying this in the html/vb code to display only the records i need for each day, however i can't seem to get the do/while look to run more than once.

    Code:
    		
    
    
    			
    			
    			 ()
    
    			
    
    			, 
    
    			
    
    			
    
    			
    
    			-----------------------------
    
    			
    			
    		
    		
    			
    			
    			 ()
    
    			
    
    			, 
    
    			
    
    			
    
    			
    
    			-----------------------------
    
    			
    			
    			
    			
    
    
    the first once produces the correct data, but the second one produces nothing at all (it should have 1 record, and the query (team1) does as expected).

    can i only run a do/while loop once?
     
  2. Chenks

    Chenks Registered Trader

    Joined:
    Jan 5, 2002
    Messages:
    3,741
    Likes Received:
    0
    sorted, forgot to reset the internal data point before starting the loop again.