Solved

Recordset filtering

Posted on 2003-11-03
4
316 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
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 …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 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