|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Sloow database.. |
|
From: |
Chris H |
|
Date: |
10/4/1999 2:48:20 AM |
|
IP: |
130.67.43.123 |
Here is my code for a shopping cart(some of it at least)
<% set ORS = Conn.Execute("SELECT * FROM [choices] WHERE [choicenumber]=" & RS("itemnumber") )
<%
If RS("choicepossibility")>0 then
Response.Write("<select name=choice1 size=1>")
Response.Write ("<option selected value=Choice1>Choose here!</option>")
Do While Not ORS.EOF
Response.Write ("<option value=" &ORS("choice1") &"> " & ORS("choice1") &"</option>")
ORS.MoveNext
Loop
Response.Write "</select>"
end if
%>
I have 3 dropdown menues, so this code is repeated 3 times..
And it is very slow...anyone got good info on how to speed it up?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
