Solved

Recordset filtering

Posted on 2003-11-03
4
311 Views
Last Modified: 2010-04-25
Hey there again,

I was wondering, i have a asp page setup to filter the recordset acording to the URL parameter and the column in the database called sectCode .. eg. when the url parameter reads ?sectCode=web then it filters all the records with "web" in the db's sectCode field. What i want to be able to do is give the records the ability to be in more than one section. So the sectCode filed in the database will read "web, print" and when filtering for web, it will find the records, and when filtering for print it will find the record. Is there a way i can do this?  

Nugs
0
Comment
Question by:Nugs
  • 2
4 Comments
 
LVL 1

Expert Comment

by:gabss
Comment Utility
If you go into the source code and change the SQL by using the AND or OR commands this could help...


If you have the source i'll have a look.....


I dont think DW set dialog boxes can cope with this " complex instructions " ummmm complex my A***** lol

Simple stuff yeh.....

G
0
 
LVL 2

Author Comment

by:Nugs
Comment Utility
Yes i thought there would be a little SQL to do the trick, not sur how to implement that so if you could i would appreciate any help.

Here is the current recordset code for the page:

<%
Dim SectionSlides__MMColParam
SectionSlides__MMColParam = "1"
If (Request.QueryString("SectCode") <> "") Then
  SectionSlides__MMColParam = Request.QueryString("SectCode")
End If
%>
<%
Dim SectionSlides
Dim SectionSlides_numRows

Set SectionSlides = Server.CreateObject("ADODB.Recordset")
SectionSlides.ActiveConnection = MM_portfolioConn_STRING
SectionSlides.Source = "SELECT * FROM SectionSlides WHERE SectCode = '" + Replace(SectionSlides__MMColParam, "'", "''") + "'"
SectionSlides.CursorType = 0
SectionSlides.CursorLocation = 2
SectionSlides.LockType = 1
SectionSlides.Open()

SectionSlides_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
SectionSlides_numRows = SectionSlides_numRows + Repeat1__numRows
%>

Would i change the following line?

SectionSlides.Source = "SELECT * FROM SectionSlides WHERE SectCode = '" + Replace(SectionSlides__MMColParam, "'", "''") + "'"

Thanks for the help!
Nugs
0
 
LVL 1

Accepted Solution

by:
gabss earned 25 total points
Comment Utility
im using php mysql and had a similar problem....

The solution i found was

SELECT * FROM directory WHERE MATCH (keywords,title) AGAINST ('%%%s%%')

this only works on full text and iif using to fields then daul indexing....

http://www.mysql.com/doc/en/Fulltext_Search.html


Hope this helps ?



0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now