Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
 All Forums
 General
 Design issues
 Neat Category selector
Author « Topic »  

mrbeanbag
New Member

USA
54 Posts

Pre-sales questions only
(More Details...)

Posted - 02/08/2022 :  10:54:29  
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

Vince
Administrator

41803 Posts

Posted - 02/08/2022 :  23:42:39  
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
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.02 seconds. Snitz Forums 2000