|
Sorted Record Listing with Search
|
Email
|
| Submitted on: |
8/1/2000 2:56:15 PM |
| By: |
Lewis E. Moten III
|
| Level: |
Advanced |
| User Rating: |
By 11 Users |
| Compatibility: |
ASP (Active Server Pages) |
| Views: |
24907 |
|
(About the author) |
|
|
|
This script displays records retrieved from the database. You can sort each field and jump to any page in the database. You can customize the records per page and all the colors. You may also attatch a style sheet to change the colors of each class type. this script is very close to being XML compatable. (still in the works).
|
 |
| |
Can't Copy and Paste this?
Click here for a copy-and-paste
friendly version of this code!
'**************************************
' for :Sorted Record Listing with Search
'**************************************
Copyright (C) 1998, Lewis Moten. All rights reserved. If you make changes that are of special merrit, please notify me of these changes so that I can allow others the possiblity of using them. | |
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 102 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 8/3/2000 11:35:25 AM: Sean McCormack
I went in and configured the 1stTemplate.asp to read from my database. Received the following error:error 'ASP 0115' Unexpected error /development/planet_source_code_sortedrecordlistingwithsearch/lstTemplate.asp A trappable error occurred in an external object. The script cannot continue running. Please advise.
(If this comment was disrespectful, please report it.)
|
8/3/2000 9:28:58 PM: Lewis Moten
Ok, I'm going to make a guess - but I am 84 sure that this is the reason. In the database file, you may see a line that says Set loRegExp = New RegExp. This required vbScript 5.0 or higher. It is near the bottom and is used for parsing advanced searches.
(If this comment was disrespectful, please report it.)
|
8/4/2000 4:38:51 PM: Craig Hill
Have installed the code, no sort options showing for fields, are there routines for delete
(If this comment was disrespectful, please report it.)
|
8/4/2000 9:31:05 PM: Lewis Moten
I am working on documenting this script. I'll post it as a tutorial when finnished and let you know. It may take a while.
(If this comment was disrespectful, please report it.)
|
8/19/2000 11:22:05 PM: shajeed
This Feature is really cool.I looked such a code for long time.So thanks the author to give me such.
(If this comment was disrespectful, please report it.)
|
8/20/2000 5:09:01 PM: TYP
I do not find lstCommunities.asp, edtCommunity.asp etc. in the downloaded zip file. Are these files availables?
(If this comment was disrespectful, please report it.)
|
8/20/2000 5:11:35 PM: yp
I do not find lstCommunities.asp, edtCommunity.asp etc. in the downloaded zip file. Are these files availables?
Thanks
(If this comment was disrespectful, please report it.)
|
9/5/2000 5:45:42 AM: Jazzy
I am really new to ASP, but i will like to search my contacts database, but There has been an error
(If this comment was disrespectful, please report it.)
|
9/8/2000 11:56:50 AM: Tim VeArd
Really excellent work!!! Eagarly await the tutorial about how to sort (can see the code in lstReasons.asp, but can't figure out how to activiate it). Truly appreicate you sharing this ... thanks!
(If this comment was disrespectful, please report it.)
|
9/27/2000 9:51:49 AM: Josie Desiderio (jodeside@worldnet.att.net)
great job! this code will come in handy.thank you.
(If this comment was disrespectful, please report it.)
|
9/28/2000 3:31:08 PM: SpireJFK
Although a newbie in the ASP/Database area, I can still see good when it is out there. I am benching on yah code. Thanx
(If this comment was disrespectful, please report it.)
|
10/9/2000 6:22:23 AM: Balaji
I do not find lstCommunities.asp,
edtCommunity.asp etc. in the downloaded
zip file.Where can I find these files.
(If this comment was disrespectful, please report it.)
|
10/10/2000 3:37:17 AM: balaji
I changed lsttemplate.asp to lstCommunities.asp and the code works excellent.
If U can help us to find addCommunity.asp, edtCommunity.asp,delcommunity.asp pages it would be of great help.
Waiting for ur +ve reply.
Thanx in advance.
(If this comment was disrespectful, please report it.)
|
10/10/2000 8:28:20 AM: hbn
Where's the sample database ???
(can't find it in the zip-file)
(If this comment was disrespectful, please report it.)
|
10/18/2000 5:09:00 PM: michael_janik@ctx.com
I've been trying to implement your system. Like the design on the example jpg. Having a problem though. Am new to ASP program and still have trouble with syntax. I noticed in your database.asp page you are accessing an access driver. How would I make this work with a sql database. Have gotten a query to work and return results but then I get caught with errors trying to read the records values (i.e. loRS.pagecount). Any suggestions?
(If this comment was disrespectful, please report it.)
|
10/18/2000 5:12:48 PM: MJ
Downloaded your code. I really like the look of your .jpg example. Am having trouble though (probably due to my inexperience with database and asp programming). Am not working with an Access database. Want to make it work with a sql database. Can make a query run in the 1stRecord.asp page if I create the object there (not using the loRS.Open(...)) but if I do that, I get caught when I try to read the values in the loRS record (i.e. loRS.pagesize). Is there any way to manipulate the sCONNECTION_STRING so that I can read from a SQL database? If you need any more information, please email me. Thanks.
(If this comment was disrespectful, please report it.)
|
1/4/2001 8:50:15 AM: Kermeci Nenad
I download zip file but I don't have all files that are needed. There are no mdb file.
(If this comment was disrespectful, please report it.)
|
1/29/2001 6:45:13 AM: Joseph Voros
I have downloaded the code, but the database.mdb is missing. Also, it appears that some edtCommunities.asp. addCommunities etc files are missing as well. Therefore, code does NOT work, needs modifications. Any new files, updates, database files available somewhere?
(If this comment was disrespectful, please report it.)
|
8/3/2001 1:33:04 PM: George I
I just sent you an email at your neopets account if you could please read it.
I'm having a few problems.
Thanks
(If this comment was disrespectful, please report it.)
|
1/8/2002 10:53:01 PM: Carlos Mosquera
Excelent script. Why don't use VBScript Classes for easy reuse and best performance??? please please please... I have some ideas for HTML Forms VBScript Class, can i colaborate??? please!!!!
(If this comment was disrespectful, please report it.)
|
2/14/2002 9:27:51 AM: Alessandro
A Question:
Where is the Database?
(If this comment was disrespectful, please report it.)
|
9/11/2002 10:50:22 AM:
excellent source code, but where's the .mdb file?
(If this comment was disrespectful, please report it.)
|
9/12/2002 3:49:12 PM: Lewis Moten
No MDB file is present for this version. Version 2 comes with an MDB file. Please look for it on PSC with other code I have listed.
(If this comment was disrespectful, please report it.)
|
9/12/2002 3:49:56 PM: Lewis Moten
Carlos - the second version DOES use classes.
(If this comment was disrespectful, please report it.)
|
8/21/2004 8:43:36 AM:
Excellent work!!!
But database is missing.plz send it to me.
Thanks
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
