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

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

New Member

54 Posts

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

Posted - 02/08/2022 :  10:54:29  

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

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_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>
If (section.CursorType > 0) Then
End If

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...



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?


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
This page was generated in 0.02 seconds. Snitz Forums 2000