[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Recordset filtering

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
Nugs
Asked:
Nugs
  • 2
1 Solution
 
gabssCommented:
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
 
NugsAuthor Commented:
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
 
gabssCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now