Post reply

ASP page problem

  • July 5, 2004 at 1:56 am

    #161171

    i have an ASP page

    which has one option box,

    it is used for displaying customer names from customer master.

    now that asp page has 10 option box for selecting customer names,

    what iam doing is populating a recordset with customer names,

    with rs.movefirst and then do while loop

    then again for another option box

    rs.movefirst

    and loop till eof

    and the customer master has over 1000 customers and thats why it is slowing the page.

    can i make a clone of option box, something like that.

    so that the page gets load faster,.

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 5, 2004 at 11:26 pm

    #513385

    Try this:

    populate all ten option box on only one loop.

  • July 5, 2004 at 11:46 pm

    #513387

    *CooL*

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 5, 2004 at 11:58 pm

    #513389

    thats not possible dude,

    iam populating the

    i need to close use "" tag after

    fully populating the option box.

    which i cannot use if i loop all the

    combo list at once..

    got me ??

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 12:30 am

    #513396

    You can build the HTML for the second option box in a string and write the contents of that string afterwards ....

  • July 6, 2004 at 3:20 am

    #513417

    Hi,

    That seems quite a lot of customers to be presenting on a single web page, even in a number of drop-downs.

    Have you thought of putting in a filter mechanism i.e. "all customers beginning with" so that you are not returning so many entries at the same time.

    Take it easy

    Graeme

  • July 6, 2004 at 4:28 am

    #513425

    not that, it has lots of customers

    there is a page called

    dailyactivity.asp

    where marketing executive will type what he has done the whole day.

    so there are six option boxes.

    then there is

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 4:30 am

    #513426

    not that, it has lots of customers

    there is a page called

    dailyactivity.asp

    where marketing executive will type what he has done the whole day.

    so there are six option boxes.

    then there is

    field of detailed report

    proposed action

    followupdate

    this is how it is arranged

    and there are seven such rows

    ..

    so any way so that i can speed up the entire thing

    <input types are porposely wrong spelled

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 4:31 am

    #513427

    not that, it has lots of customers

    there is a page called

    dailyactivity.asp

    where marketing executive will type what he has done the whole day.

    so there are six option boxes.

    option11>

    then there is

    textarea1> field of detailed report

    textarea1> proposed action

    inpute type1=text1>followupdate

    this is how it is arranged

    and there are seven such rows

    ..

    so any way so that i can speed up the entire thing

    <input types are porposely wrong spelled

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 4:33 am

    #513428

    not that, it has lots of customers

    there is a page called

    dailyactivity.asp

    where marketing executive will type what he has done the whole day.

    so there are six option boxes.

    option11 where user will select company name he visited

    then there is

    textarea1 field of detailed report

    textarea1 proposed action

    inpute type1=text1followupdate

    this is how it is arranged

    and there are seven such rows

    ..

    so any way so that i can speed up the entire thing

    <input types are porposely wrong spelled

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 4:35 am

    #513429

    not that, it has lots of customers

    there is a page called

    dailyactivity.asp

    where marketing executive will type what he has done the whole day.

    so there are six option boxes.

    option where user will select company name he visited

    then there is

    textarea field of detailed report

    textarea proposed action

    inpute type=text followupdate

    this is how it is arranged

    and there are seven such rows

    ..

    so any way so that i can speed up the entire thing

    input types are porposely wrong spelled

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 4:40 am

    #513430

    not that, it has lots of customers

    there is a page called

    dailyactivity.asp

    where marketing executive will type what he has done the whole day.

    so there are six option boxes.

    option where user will select company name he visited

    then there is

    textarea field of detailed report

    textarea proposed action

    inpute type=text followupdate

    this is how it is arranged

    and there are seven such rows

    ..

    so any way so that i can speed up the entire thing

    input types are porposely wrong spelled

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • July 6, 2004 at 9:31 am

    #513470

    Here is the code I use to solve this. I use this on the hundreds of .asp pages I have written and it works everytime. Of course, you need to change the names of the objects for your page.

    <select name="emp_manager_name" size="1">

    <%sql="sp_getManagerName '"+emp_id+"'"

    Set MyConn=Server.CreateObject("ADODB.Connection")

    Set MyCommand=Server.CreateObject("ADODB.Command")

    MyConn.Open "DSN=downSouth;UID=intranet;PWD=justdoit"

    Set RS=Myconn.Execute(sql)%>

    <%WHILE NOT RS.EOF%>

    <option> <%=RS.Fields.Item("emp_manager_name")%></option>

    <%RS.MoveNext%>

    <%WEND%>

    <%RS.Close%>         

    </select>

  • July 9, 2004 at 4:19 am

    #514029

    Not this dude,

    u r code is okay for 1 <select-> box

     

    what i want is there are atleast 7 select box in my asp page,

    and there are around 1000 customers, it takes time too much time to load

    the asp page, what iam trying to do is minimize the load time.

     

    by populating all the records in one <--select box> and then clone that

    select box  7 times, so that i minimize the load time got it ??

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply