ASP :: Sort, Filter And Paging In One?

Filter?
I've got a website that I've been making some changes too as of late. It's not my website so I've been learning a lot, especially since I'm fairly new to coding and webdesign. So keep in mind, I'm just a newb. If there's not enough info here to allow anyone to help, just say so and I'll figure it out on my own. Here's my problem...

This site I'm working on has all kinds of directories and allows certain people within a company to upload files to certain directories. I've got a .asp file that shows all of the content providers for all directories in a table.

I want to make it so that in my directorylist.php file there's a button that will allow a user to click on this "View Content Providers for this Directory" button and it will read/filter this asp file, and spit out a list of only the users who have authority to upload files to that particular directory that the user is looking at.

Is there some way to link the two files to do that? Or is it just a change I need to make in the loop in the asp file or perhaps a change in the php file? I'll provide a piece of code from the .asp file. Code:

Filter
On my page i run a SQL query that selects certain records from the database,
Is there any way to select a specific record from the recordset then another one. e.g. say i run a SQL that picks up all records with ID < 30 and then i want to pick one with an ID of 1 and then one with an ID of 4 without re-running the SQL query?

.filter Using MID
I had an sql statement like 'WHERE MID(id,4,1) = 3' but when I try to use the filter method it returns the error:

'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'

rs.filter = "MID(id,4,1) = 3"
Thats what its supposed to look like right

Rs.Filter
I've used Rs.Filter several time sin my code and they all work fine. However when I use

Code:

Rs.Requery adAsyncExecute
Rs.Filter = DateDiff("n",lastedit,NOW) < 15

I get
Quote:
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Am I typo'ing something or can I just not use DateDiff in a filter?

SQL And Month Filter
I am trying to get my SQL Query to to through a list of faults, and pull all the records from the previous month (say now is july(7) it pulls all from june (6)

the current SQL i have is....

SELECT Faults.DateAdded, Faults.[Teacher ID], Faults.[Computer ID], Faults.[Type of Fault], Faults.[Description of Fault], Faults.Fixed
FROM Faults
WHERE ((Month([DateAdded])=Month([Date])-1));

but this doesn't work, can anyone assist?

Filter Criteria
I'm using APS VBScript web page on an Access2000 database and I am trying to select from a recodset using a date as the criteria.
I keep getting ADODB Data Type Mismatch errors no matter what I do to the database field (which hold a date/time) or the URL.
My URL looks something like ... result.asp?id='3/20/2005'...
The database field is an Access date/time field formatted to mm/dd/yyyy.

ISAPI Filter
Isapi is installed and rules are working. Now I have to change the links of my shopping cart from dynamic to url friendly.
How can I change the internal links of my cart in an automatic manner (some script maybe)? I am trying to avoid to go trhought the proces of 'seach and replace'.
I know it is possible to do it in PHP with one scripf for each kind of friendly url link. I am wondering if this can be done in ASP, better said, if the scripts are already done ready to adapt as I am not a coder.

Distinct Filter
I have information in a database with the following structure:
3 Divisions - each division has several districts. Each district has several regions and each region has several areas.
I have a recordset of every area with the region, district and division they belong to.
I have 4 drop down menus on my page - area region, district and division.
How can I filter my recordset before each dropdown, so it only has DISTINCT records

Asp+Filter Database
How do I create an asp page that searches two tables in my database. I want to create a page with multiple drop down lists which a visitor selects to filter my database results. For example a visitor can select to search the database for products with COLOR red and SIZE large - or COLOR black and SIZE small - How do I do this? Is it complicated because I am new to this ASP lark

Filter Members
I want to dynamicaly filter the members in my pivottable.
Here you see how it's done the static way:

pview.RowAxis.InsertFieldSet pview.FieldSets("manager)
Set fld = pview.FieldSets("manager").Fields(0)
fld.FilterFunction = c.plFilterFunctionInclude
fld.FilterMembers = Array("ZWAENEPOEL Geert","VAN COILLIE Caroline")

but I receive the selected members from another page, they are all in
the field 'selectedmembers', so I tried this:

fld.FilterMembers = Array(selectedmembers.value)

Filter Problem
i have recordset rs on that i am applying filter as:

rs.Filter = " PRCD = '"&product&" ' and HQ_NAME='"&hqs"' "

here,PRCD is Column of datatype varchar(20)
HQ_NAME is Column of datatype varchar(20)

the problem is with PRCD,if substitue value directly as :

PRCD='SLO1NMK' filter is working but PRCD = '"&product&" '
not working.where as HQ_NAME='"&hqs&"' is working individually fine

MS Word Filter
Does anyone know where to find a good working MS Word-tag filter, or how to build this.

Alphabetic Filter
I've got a Access database of business information.I've made an ASP page with 26 hyperlinks, relating to each letter of the alphabet.I want each hyperlink to fire up a page which only shows the business names starting with that letter of the alphabet.
How can I write the href?I've got:

<a href=cat.asp?business=<% = rsProds("biz") %>>A</a> that wouldn't work since we only want businesses starting with A to be shown.
How do I make the value for bizname pass an sql LIKE 'A%' statement to cat.asp?
Is there a way to minimize the code for each hyperlink or does each letter have to be written out?What will the SQL statement in the resultant page the variable's sent to (cat.asp) look like?

How Can I Filter By Folder
How can I filter by folder with ASP & Site Server 3.

I have no control over the catalog.

Counting Records After Filter
I have an access table which I filtered with the code below.

'''''''''## FILTER AND SORT MAIN TO SOFTWARE ##''''''''''

rsMain.Filter = "asset = ' " & rsSoft("assetnumber") & " '"

'''''''''## END FILTER AND SORT MAIN TO SOFTWARE ##''''''''''

My question is is there a command that will return the amount of records in rsMain without using loops (while Do ect)?

Recordset Filter Bug - No Error
I'm having a weird problem when I use a filter on a recordset. Basically, when the filter is applied, no records show up. However, if I assign a value from any field of the recordset to a variable (which i don't have to use anywhere), and then apply the filter afterwards, it works properly. Code:

ASP Recordset Filter Failure
With the following code snippet:

<%="complexid =" & rsComplex("ComplexID")%>
<% rsPhoto.filter = "complexID =" & rsComplex("ComplexID") %>
<%response.Write("<br>ID: " & rsPhoto("complexID"))%>

I get an 80020009 error on the last line.

The first line appears in the HTML output as complex=589, so I know
that there is a valid value available for the filter.

This worked once and hasn't worked since.

The rsPhoto recordset is viewable in a seperate page. The complexID in
the associated table has a value of 561 in the complexID column.

Filter Bad Words Using Regexp
is it possible (i heard u can replace) to filter out bad words using regexp? I'm using Replace() but it sucks without ALOT of extra code... but using regexp it seems better, with ignorecase, etc.

How would I do it? O, here's the way it is now:

<%= Decode(ChkBadWrds("Comment")))%>

How would I do something similar using regexp?

Filter Multple Records
I am fairly new to ASP and have a lot of fun trying to solve problems, which so far I have been able to do. This one has me stumped however.
I have an access database that feeds my asp pages, and I have one table in there that users can submit their names/address etc. for our services. What I would like to do is have them be able to submit the states they provide services in (we're a trucking company) and I think the best way MIGHT be checkboxes (please correct me if I am wrong.
What my big problem is though, is how do I create a search page for our users that allow them to sort through these records by 1 or 2 states, and type of service?
I basically would like a page where our users can specify say Florida and Alabama and flatbed truck, and it would query through the pages and show all those records. I have done simple searches, but the sheer number of states has me a little confused on both how to structure my database as well as how to search it.

Filter Multiple Entries
I have a database for projects. Some managers are responsible for multiple projects. I want to dynamically populate a list of project managers, choose a manager, and display a complete list of his/her projects. I have a few problems 1) I cannot figure out how to list a project manager's name only once in and 2) I don't have a clue how to compile all the projects for each manager so that when his/her name is chosen it will display all the records.

Filter Duplicated Records
i have many records that are duplicates....i would like to remove the duplicates......can asp help me with that?For example,

i have four fields, A-D
I would like to compare all the for fields with the rest of the records.....to make sure if there are any records that are the same, if yes, delete them

Filter HTML Tags
I have constructed a simple guestbook application using ASP and a SQL server backend. My problem is that when a person post a message and it displays on the site, if they paste HTML code or any other scripting languages in there, it will post and execute on the site which is what I don't want to happen.

Is there a way or a script out there using ASP that when the user post the message it will scan for key scripting tags and filter them out?

Filter A Recordset With Pagination
Let's say initially I have 1000 records in the recordset object, I display 100 records at a time. Therfore there are 10 pages of 100 records each. But then I filter the recordset now it contains 500.

Therfore I should display 5 pages of 100 records each. But the problem is that I'm unable to page through the filtered recordset. What I mean is that the filtering works and it displays the right number of pages but when I "flip" the page it changes back to the original (1000 records).

Filter Html-tags
im building a small messageboard and i want to filter all html-tags except these ones:

<b> <i> <img.........> <font....>

how to build such a reg exp pattern?

Filter Records Via A Paremeter
I have a login script workiong fine now thanks to some help getting the include working. Now the problem is as follows.In my include file is the following line:

You logged in as: <B><%=Session("userlogin")%></B>

Now what i would like to do, is have it so when the records within the Access database are displayed, it filters them to show only records where the value within one of the fields id the same as the user name (userlogin)

Select Sort
I have a script that I want to display the returned list numerically in. The database is deciding how to order the list, and is being displayed pretty loosely. Is there anyway I can sort the returned list numerically here? Code:

Sort By Part
I have a database table, that I need to sort by PART of the contents of a field (named rFieldName in the table):sample contents of this field are:Code:

qid_5_question_1
qid_12_question_5_0_1
qid_12_question_5_0_2
qid_12_question_5_1_1
qid_12_question_5_1_2
qid_12_question_5_2_1
qid_12_question_5_2_2
qid_12_question_5_3_1
qid_12_question_5_3_2
qid_6_question_2I need to sort his field by the value that appears AFTER the 3rd underscore, and if applicable BEFORE the 4th underscore
Is this possible - can you help please - I have no idea where to start on this as I've never had to try to do something like this before.

JS Sort Function
I have a JS/ASP application that sorts a SQL populated table.
This works great, and sorts the data fine, apart from my currency columns.
It wants to read the data as text as far as i can gather. Ths data in ASP
looks like this -
<% =formatcurrency(RS("income"),2)%>
I have tried changing this to a number (formatnumber) and hard coding a £
sign, yet it still wants to read the data as text, rather than numerical?
How can i get my JS function to read currency or if not, eliminate the
forehand figures. I need the data to appear as a currency, yet be sorted as
a number (rather than taking the 2st digit)if this is a
common problem (sorting currency) and there was a universal solution around
this

Sort Text
I've lurked on here for awhile but I've come upon something I'm having trouble with.
I have a database table of movie titles and I want to sort by the column, but ignore the articles in the title, "a", "an" or "the"... "The Lion King" would be under L... "A Bronx Tale" would be listed under "B", etc.
Does anyone have a function that does this or know of another method? Or am I forced to enter them as "Lion King, The", for example?

Sort Array
Which would be faster?

1) Bubble sort
2) Join Array remove empty delimaters and then Split.

I am thinking the second would be a faster routine wouldn't it?

Sort Order?
I have a form that is created dynamically, and all is working fine. But I want users to add an sort order to help list phrases in a certain order.

<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="10">
Phrase1

<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="20">
Phrase2

so on, so forth...

And one clicks on the form, and a SQL statement is executed.
However, when I create the SQL statement,

INSERT INTO table1
(FormId,AdvantageId,SortOrder)
VALUES (<call from form ID>,<advantages>,<advantsort>)

Then it loops to allow the next phrase to be entered. The statement also takes the value from every other sort order value including that ones that are in different lines. Which in result, gives me an error, saying the insert columns exceed that of the available columns in the table.

Table Sort
I would like sort table. The table is createobject method (open a function
and use SAP connection) and the table not use recordset. is it possible sort
table for example or how can i sort table columns.

set objTable = myFunc.tables ("Sales")

objTable.sortColumn="SalesID", Asc

How To The Sort FileSystemObject?
I'm trying to sort the fso. The file names are named june2004, july2004, august2004, ect... I need to sort them in chronological order starting with the latest one first.

The files were recently created so sorting them by the modified or created date will not work. The only other way is to them by the name of the file. I tried converting name of the file into a date using CDate (formated the file names as July 2004, August 2004, ect...) but it did not work. Code:

Sort Problem
region = array("a", "b", "c", "d")
I am sorting in desc order that is d, c, b, a, it works fine. Is there a way to sort them as d,c,a,b? How do I do? thanks.
Code:select* from mytable Order by region desc

Sort Options
Can u help me generate a javascript to sort the options(list) in an asp listbox control?

Sort By Relevancy
I have an SQL string that does a search using

SELECT * WHERE Titlename LIKE '%Crimson%' AND Titlename LIKE '%Skies%' order BY Titlename

This gives me all results containing both "Crimson" and "Skies". But I want a result that contains exactly "Crimson Skies" to appear first in addition to the blended results.

Trying To Sort By Month
I have an Access "date/time" column and I am trying to use SQL to select by month. I thought the code below would work (to query for records in april for example) but I am still getting all the records regardless of when the date is.

SELECT *
FROM comm
WHERE comm_requested_date = month(4)

Basically, I have a drop menu with the months and I want to query the DB for all records for a particular month.

Sort From Database
how i can make it sort alphabetic? From a database.

Sort Posts
I have a simple address-script (its actually a guestbookscript that I changed a bit). Part of the code looks like this:

Code: ....

Sort Through My Database
Is it possible to do the following in asp. I have a flash game which saves the name time and email of the users race. Is it possible to sort through my database (ms access) and then display the quikest 10 in flash as high scores? This is my load.asp where my database results are at the mo.

Sort Records Using ASP
I have Table Named "League_Table" in MS Access and data Stored in Table as follow
Tm P W D L Pt
ABL 2 0 0 2 0
HBL 2 1 1 0 4
KRL 2 2 0 0 6
PIA 1 1 0 0 3
.....................
.....................
.....................
.....................
.....................
.....................

There are 16 Teams in League. Now I want to sort Records on the basis of Points, assign Rank to Teams and display on Web page using ASP.

Problem Using Date As Filter For Record
I am trying to filter a recordset by 3 fields. character name, username, and date.

(some of you may have seen this who have helped me on a few other problems. You guys rock!)

The query runs fine, until I introduce the date element. It says that my syntax is incorrect. I am trying this.

"Select * from fieldname Where valueOne = Request.Querystring("value") and valueTwo = Request.Querystring("value2") and date = date()"

I am sure this is blatantly obvious to some of you, but i can't get it to work. I have put date in a variable:

Dim currentDate
currentDate = date()

and tried "... where date = currentDate"

Any suggestions?

Filter 2nd Drop Down List Value From DIFFERENT Tables
I have coded 2 drop down lists. For ur info, currently my 2nd drop down list's content is being retrieved from one single table in database only. What if I would like to make the content of my 2nd drop down list to be populated with data from 2 different tables?

What i mean here is that, the selected value in 1st drop down list will determine data from which table to be loaded into the 2nd drop down list. Earlier I'ved coded my SQL statement as:

SQL = "SELECT x.language_ID, x.language_name, y.msg_category " &_
"FROM Language x INNER JOIN outMessageENContent y " &_
"ON x.language_ID = y.language_ID"

where data for 1st drop down list is loaded from table x and data for 2nd drop down list is loaded from table y.

My 1st drop down list only has 2 values., which are 'English' and 'Chinese'.Now I would like to make it as, if user select 'English', then my 2nd drop down list will refer to that particular 'English' table, while selecting 'Chinese' will allow 'Chinese' table's data to be loaded into my 2nd drop down list.

So what shall I change in order to filter the 2nd drop down list's content according to the selection from 1st drop down list? Shall I modify my SQL statements?

IIS Search: Filter Asp Code In Abstracts
I'm having bit of a problem with a search engine. I got an intranet running in a company with IIS, Indexing Server and ASP. I've realized a search engine which also returns abstracts from the documents.

Most pages in the website are ASP pages. That doesn't mean that it draws all its contents from databases. I'm using ASP for other stuff as well. So they're basically documents, but with extras and hence ASP.

I excluded all sorts of things, e.g. "_" directories, like _vti and _private. Also directories like "include" are left out as people don't need to search for javascript code or css style sheets. Those are not relevant to the users. And finally I also give people the opportunity to make files non-searchable with a quick tag.

So what's the problem? When I perform a search e.g. for "body" (without the "" quotes) it would in this example return some results and one of those results got an abstract with evident pieces of ASP code. Code:

Sort, Filter And Paging In One?

does anyone know where i can get a good free javascript that sorts, filters and pages my ASP page? if it will work with my ASP page and if this is the best way?