Solved

Recordset filtering

Posted on 2003-11-03
4
315 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
ID: 9677197
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
ID: 9681691
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
ID: 9685821
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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