Vince,

I had a really neat scroll wheel category selector that worked great. However, I just updated my site, and not the function I wrote is old code and does not connect to the database to get the SectionID and sectionName

Could you look at my connection script to see if it is just a simple fix. I used this all the time on my site before the update.

This was added to incfunctions.asp and use to work

</script>
<%
Dim section
Dim section_numRows

Set section = Server.CreateObject("ADODB.Recordset")
section.ActiveConnection = sDSN
section.Source = "SELECT sectionID, sectionName FROM sections ORDER BY sectionName ASC"
section.CursorType = 0
section.CursorLocation = 2
section.LockType = 1
section.Open()

section_numRows = 0
%>


Then this was added to any webpage to get the scroll wheel

<form name="form1">
<div align="center">
<select name="menu1" class="scroll" onChange="MM_jumpMenu('parent',this,0)">
<option value="categories.asp" selected>Go to class</option>
<%
While (NOT section.EOF)
%>
<option class="scroll" value="products.asp?cat=<%=(section.Fields.Item("sectionID").Value)%>"><%=(section.Fields.Item("sectionName").Value)%></option>
<%
section.MoveNext()
Wend
If (section.CursorType > 0) Then
section.MoveFirst
Else
section.Requery
End If
%>
</select>
</div>
</form>


If this can be easily fixed.. I would so much appreciate this as I used this all the time when accessing my site. Seems the way the connection to the database works is different from old version of ect I was using. I was using capture card version still...

Scott

Hi Scott
Do you get an error of any kind? Also, have you tried displaying the data source "sDSN" just to make sure that it is set?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater