take a look....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a page that has a drop down box filled from an sql
database. Once a user selects something from the drop
down box and hits a select button, a table is displayed
below. When I scroll the page to view all of the table the
drop down box either disappears completely or parts of
the page will "stick" to it. The box is still there... if i click
where the drop down button is, the list still opens up ..
but it's a guess as to where the button is since it can't be
seen.

It is only happening to that control and the connection is
closed just after the drop down box is filled.. any ideas?

Thanks!
Geniene
 
over there...doncha see it? :-)



| Where would you like us to look?
|
| Bob Lehmann
|
| | > I have a page that has a drop down box filled from an sql
| > database. Once a user selects something from the drop
| > down box and hits a select button, a table is displayed
| > below. When I scroll the page to view all of the table the
| > drop down box either disappears completely or parts of
| > the page will "stick" to it. The box is still there... if i click
| > where the drop down button is, the list still opens up ..
| > but it's a guess as to where the button is since it can't be
| > seen.
| >
| > It is only happening to that control and the connection is
| > closed just after the drop down box is filled.. any ideas?
| >
| > Thanks!
| > Geniene
| >
|
|
 
No. You have not provided enough information to determine the source of the
problem.

I've never seen parts of a page stick to other parts.

Bob Lehmann
 
sounds like display artifacts like when system is running low on resources (memory) or a video card problem...if i uberstand you correctly.


| Basically it's as if the control is "frozen" except that it still works.
| Have you ever had a web application freeze and if you bring up another window
| and it partially covers the frozen app, then minimize it, a portion of the
| app's image sticks to the frozen app? Or if you move a window around over a
| frozen app you can make it all white... something like that.
|
| If i can, i will try to publish a copy from home tonight and see if i can
| recreate it so someone can see. It's driving me nuts.
|
| thanks.
|
| "Bob Lehmann" wrote:
|
| > No. You have not provided enough information to determine the source of the
| > problem.
| >
| > I've never seen parts of a page stick to other parts.
| >
| > Bob Lehmann
| >
| > | > > Ha ha ha, very funny... I just meant take a look into my problem by
| > > reading my post. I can't show my site it's an intranet tool at work.
| > >
| > > Can you do that?
| > >
| > >
| > > "Rob Giordano (aka: Crash Gordon®)" wrote:
| > >
| > > > over there...doncha see it? :-)
| > > >
| > > >
| > > >
| > | > > > | Where would you like us to look?
| > > > |
| > > > | Bob Lehmann
| > > > |
| > > > | | > > > | > I have a page that has a drop down box filled from an sql
| > > > | > database. Once a user selects something from the drop
| > > > | > down box and hits a select button, a table is displayed
| > > > | > below. When I scroll the page to view all of the table the
| > > > | > drop down box either disappears completely or parts of
| > > > | > the page will "stick" to it. The box is still there... if i click
| > > > | > where the drop down button is, the list still opens up ..
| > > > | > but it's a guess as to where the button is since it can't be
| > > > | > seen.
| > > > | >
| > > > | > It is only happening to that control and the connection is
| > > > | > closed just after the drop down box is filled.. any ideas?
| > > > | >
| > > > | > Thanks!
| > > > | > Geniene
| > > > | >
| > > > |
| > > > |
| > > >
| >
| >
| >
 
That would appear to be a video card driver issue.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Actually, this can't be the problem because I don't have this problem with
anybody elses site, only my own. And only the drop down box filled by a
query to my database. First i was thinking it could be that I didn't close
the connection and recordset but I did.

This is the code to that drop down box:

<%
Set oConn = Server.CreateObject("ADODB.Connection")
Set oRs1 = Server.CreateObject("ADODB.Recordset")
oConn.Open application("ConStr")
oRs1.Open sSql, oConn, 0,1
While Not oRS1.EOF %>
<option><%=oRs1("Name")%></option>
<%oRs1.MoveNext
Wend
oRs1.close
oConn.close%>

however I don't think there's anything wrong with this... it's something
else on the page.
 
Is this the complete code for the drop down and is this within a form?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Actually, this can't be the problem because I don't have this problem
with anybody elses site, only my own.

Does anybody else have problems with your site?

Bob Lehmann
 
Well in the mean time while I work on my site, I have another problem with
permissions to my box - but that fix will come later.
 
Try the following on a new page, etc.

<%
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open application("ConStr")

Set oRs1 = Server.CreateObject("ADODB.Recordset")
sSql = "SELECT * FROM tablename"
oRs1.Open sSql, oConn
%>

Place the above before the opening HTML tag


<td>
<form name="OrgName" method="Post" action="Default.asp">
<SELECT name="OrgName" size="1">
<option value="">[Select One]</option>
<% Do While Not oRS1.EOF %>
<option value="<%=oRs1("Name")%>"><%=oRs1("Name")%></option>
<%
oRs1.MoveNext
Loop

%>
</SELECT></td>
<td align=left><input type="submit"name="submit"value="Submit"></form></td>


After the ending HTML tag

<%
oRs1.close
Set oRs1 = nothing
%>

Note: Name is a reserve Word, suggest you change the name to something else.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


mgm said:
sSql is declared and set at the top of my page, this is the drop down box
complete:

<td><form name="OrgName" action="Default.asp">
<SELECT id=OrgName name=OrgName width=0>
<OPTION>[Select One]</OPTION>
<%
Set oConn = Server.CreateObject("ADODB.Connection")
Set oRs1 = Server.CreateObject("ADODB.Recordset")
oConn.Open application("ConStr")
oRs1.Open sSql, oConn, 2,3
While Not oRS1.EOF %>
<option><%=oRs1("Name")%></option>
<%oRs1.MoveNext
Wend
oRs1.close
oConn.close%>
</SELECT><p></td>
<td align=left><input
type="submit"name="submit"value="Submit"method="get"></form></td>



Thomas A. Rowe said:
Is this the complete code for the drop down and is this within a form?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down box control disappearing when I scroll page 2
Forms with and if/then response? 2
auto-fill 1
Forms and drop downs help 8
PowerPoint High Resolution Images from PowerPoint 0
Drop down box behavior 2
Auto Refresh Drop Down Selection 1
results form input sent to another form 1

Back
Top