|
Sorted Record Listing with Search v2.0
|
Email
|
| Submitted on: |
1/21/2001 1:44:57 PM |
| By: |
Lewis E. Moten III
|
| Level: |
Intermediate |
| User Rating: |
By 16 Users |
| Compatibility: |
ASP (Active Server Pages) |
| Views: |
33086 |
|
(About the author) |
|
|
|
After getting great reviews on the previous version, I finally got time to do the rewrite that I promised everyone. This code allows you to easily create lists of your data with pagination, sorting, and filtering. The end result is a very nice layout of your data. You choose which fields come back (an the captions for each one in the header). Choose which fields are searched. Setup the default field that is sorted when visitor first views page. Now supports databases with list ordering. This time I have included a database so it should work as soon as you add the files to your website.
|
 |
| |
|
 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
|
 1/22/2001 9:01:55 AM: Jos Krause
Hello Sir!
I think your 2.0 is truly some pretty awesome stuff!
But I haven't been able to test it out due to an error that arrose:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'ADODB'
/search/inc/clsdatabase.asp, line 901
I tried somethings but alas I cannot fix it. (Some day...some day) anyway I created a subdir called search anunzipped the content then ran the default.asp and gotten that error.
Hope you can assist me (us).
Friendly greetings from The Netherlands.
Jos Krause.
(If this comment was disrespectful, please report it.)
|
1/22/2001 2:13:03 PM: Lewis Moten
Ack! the type library must be missing. I usually put this line in my Global.ASA file, but you can put it as the first line in clsDatabase.asp. I'll post an updated zip file when I get home from work this evening.
(If this comment was disrespectful, please report it.)
|
1/22/2001 4:01:58 PM: Jos Krause
I am sorry to disturb you once again. But another error was presented by me:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'msSearchFieldAry'
/search/Inc/clsDatalist.asp, line 132
Maybe if you are willing we could go trough the code in 1 time to see why it doesn't run on my machine and it does on yours?
You can always contact me on ICQ (16478641) Or irc would be fine and mail ofcourse ;)
I so want to see your system in action!
Joseph.
(If this comment was disrespectful, please report it.)
|
1/22/2001 4:56:32 PM: Lewis Moten
Thanks for the help guys! I installed this on my computer at work and found those same errors and fixed them. I uploaded the fixed version. Let me know if you have any more problems. :)
(If this comment was disrespectful, please report it.)
|
1/22/2001 8:00:05 PM: DCP
I get a type mismatch error (line 175 of datalist.asp. Any thoughts?
(If this comment was disrespectful, please report it.)
|
1/22/2001 9:58:50 PM: Lewis Moten
Third times a charm? It worked on the computer at work (might be a vbScript version that handles dynamic arrays differently?). I got home and was welcomed with another report of an error. Well, I downloaded the code and sure enough, I had the same error. Fixed and uploaded. Enjoy!
(If this comment was disrespectful, please report it.)
|
1/31/2001 8:52:00 PM: DCP
Downloaded new code (which didn't seem to have any changes) and still have the same error (type mismatch line 175 in datalist.asp). Maybe your upload didn't work properly.
(If this comment was disrespectful, please report it.)
|
2/1/2001 2:46:27 AM: wayne
Active Server Pages error 'ASP 0223'
TypeLib Not Found
/datalist/Inc/clsDatabase.asp, line 1
Hi,
This looks truly awesome! I however
get the following error:
METADATA tag contains a Type Library specification that does not match any Registry entry.
Please could you advise me what the prob might be.
Thanks
Wayne
(If this comment was disrespectful, please report it.)
|
2/1/2001 3:31:11 AM: Wayne Heather
Hi , your script looks excellent.
I however get the following error.
Please could you sherd some light.
Active Server Pages error 'ASP 0223'
TypeLib Not Found
/datalist/Inc/clsDatabase.asp, line 1
METADATA tag contains a Type Library specification that does not match any Registry entry.
(If this comment was disrespectful, please report it.)
|
2/12/2001 7:39:23 PM: John
Thanks for sharing this with us. I can tell you this code does work with no real problems. Thanks for keeping it up to date. Now I just need to figure it all out and see what you have here. It is well organized code that takes a little getting used to. Thanks for the hard work. I definately appreciate it.
(If this comment was disrespectful, please report it.)
|
4/11/2001 3:38:51 PM: Jeret
Lewis:
RE: Sorted Record Listing with Search V2.0
Using version downloaded on 11-APR-01
After unzipping the files, when I click
on default.asp the app loads into
InterDev, but when attempting to view
in browser nothing happens. Is there
something on my computer that needs
to be set for this?
This also happens when I attempt to
open default.asp from the browser.
Thanks,
Jeret
jeretm@yahoo.com
PS: I enjoyed your art work :-)
(If this comment was disrespectful, please report it.)
|
5/6/2001 6:12:00 PM: Lewis Moten
Jeret - You need to put this code on a web server that is capable of executing ASP pages. Make sure your link in the browser begins with http:// and not file://
(If this comment was disrespectful, please report it.)
|
6/6/2001 2:10:19 PM: digitalpeer
EXCELLENT CODE
(If this comment was disrespectful, please report it.)
|
6/15/2001 8:36:08 AM: Roland
what is wrong?
(If this comment was disrespectful, please report it.)
|
6/15/2001 9:51:03 AM: Lewis Moten
Roland ... can you be more specific?
(If this comment was disrespectful, please report it.)
|
7/17/2001 5:45:35 PM: Jim Farmer
Lewis, Great Job I have D/l the code and got it running without any problems.I am using my existing access database with no problems. I am how ever fairly new to asp and databse. can you point me in some direction as to how I can build the (add del edit forms) utilizing your existing pages. I am not looking for you to code them for me just a suggestion on what other reading material I can use to help me.
(If this comment was disrespectful, please report it.)
|
7/26/2001 9:16:08 AM: hb
Hi,
I tried to choose an SQL Server smalldatetime field for searching but it doesn't work. I'd like to view all records having the same date. Any suggestions?
Thanks.
(If this comment was disrespectful, please report it.)
|
12/4/2001 4:51:07 PM: Ceajai
Hi!
I used your previous version, I thought I'd upgrade. I came across an error however (probably on my part) and I have tried many time to fix it with no avail, please help!
Microsoft VBScript compilation error '800a0400'
Expected statement
/Applications/Cause/Datalist/Inc/clsDatalist.asp, line 611
End Class
(If this comment was disrespectful, please report it.)
|
2/22/2002 9:21:37 AM: giel
help... i cann't download the zip file. anyone please send it to my mail?
(If this comment was disrespectful, please report it.)
|
7/2/2002 12:05:40 AM: David Rodriguez
Marvelous, 5 globes.
(If this comment was disrespectful, please report it.)
|
7/2/2002 8:28:42 AM: Lewis Moten
Thanks for the Globes David!
(If this comment was disrespectful, please report it.)
|
7/28/2002 1:38:20 PM: Will
It looks wicked - and runs with no errors - however ... it doesn't do anything? Click on the page numbers or from the drop down list and it stays at page 1, clicking on the other field headings to sort also does nothing ... any thoughts ... am i being stoopid? ... is there something else needed to be setup before it works?
(If this comment was disrespectful, please report it.)
|
7/28/2002 1:46:43 PM: Will
Sorry, was me - not looking hard enough ... basically for anyone else here having trouble with this excellent script, when accessing it through the browser make sure it reads e.g: http://localhost/datalist/default.asp?Query=gb and NOT http://localhost/datalist/?Query=gb or the script doesn't function! Good work Lewis!
(If this comment was disrespectful, please report it.)
|
11/8/2002 8:56:18 PM:
any idea when you'll make this XML based? I am new to programming and would prefer to work in XML for the database instead of access or sql.
(If this comment was disrespectful, please report it.)
|
2/20/2003 4:08:15 PM: Robert Rowe
Wonderful code. Just what I was needing.
(If this comment was disrespectful, please report it.)
|
4/5/2003 1:36:10 AM: sachin_d77
Superb....
(If this comment was disrespectful, please report it.)
|
5/7/2003 1:43:29 AM:
Sir,
This code is excellent but I've found an problem.
When there is only one record in the list, I try to click
(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.
|
