After,getting,great,reviews,previous,version,
Quick Search for:  in language:    
After,getting,great,reviews,previous,version,
   Code/Articles » |  Newest/Best » |  Community » |  Jobs » |  Other » |  Goto » | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
ASP/ VbScript Stats

 Code: 132,008 lines
 Jobs: 198 postings

 
Sponsored by:

 

You are in:

 
Login


 

 


Latest Code Ticker for ASP/ VbScript.
if i remember, this is a M. Harris code sample
By ask on 8/24


MTS Registration Script
By Igor Krupitsky on 8/23


Click here to see a screenshot of this code!Creating Windows Users with ASP and ADSI
By jamespwalters on 8/23

(Screen Shot)

News Poster (Advanced)
By Martin Kilbryde on 8/22


Print a web document through MS Word
By ask on 8/22


Click here to see a screenshot of this code!ADSI Domain Group Explorer
By Gordon Asbach on 8/22

(Screen Shot)

_-~Who is looking at your site? v2.0!~-_
By John on 8/22


Using HTML Option to Display Current Month
By Patrick Ingle on 8/20


FdB: Free Database (Aka Fake Database)
By TV2k.net on 8/19


Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!





Affiliate Sites



 
 
   

Sorted Record Listing with Search v2.0

Print
Email
 
winzip icon
Submitted on: 1/21/2001 1:44:57 PM
By: Lewis Moten  
Level: Intermediate
User Rating: By 14 Users
Compatibility:ASP (Active Server Pages)

Users have accessed this code 11399 times.
 

(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.

 
winzip iconDownload 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 Winzipto 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:
1)Re-scan downloaded files using your personal virus checker before using it.
2)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...   
1) 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.   
2) 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.   
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 95 submission(s) by this author

 

 
Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
Reason:
 
Your Vote!

What do you think of this code(in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
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.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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.
<!--METADATA TYPE="TypeLib" 
NAME="Microsoft ActiveX Data Objects 
2.5 Library" 
UUID="{00000205-0000-0010-8000-00AA006D2
EA4}" VERSION="2.5"-->
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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/clsDatal
ist.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.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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. :)
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
1/22/2001 8:00:05 PM:DCP
I get a type mismatch error (line 175 
of datalist.asp.  Any thoughts? 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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 :-)
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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://
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/6/2001 2:10:19 PM:digitalpeer
EXCELLENT CODE
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/15/2001 8:36:08 AM:Roland
what is wrong?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/15/2001 9:51:03 AM:Lewis Moten
Roland ... can you be more specific?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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/cls
Datalist.asp, line 611 
End Class
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
2/22/2002 9:21:37 AM:giel
help... i cann't download the zip file. 
anyone please send it to my mail?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/2/2002 12:05:40 AM:David Rodriguez
Marvelous, 5 globes.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/2/2002 8:28:42 AM:Lewis Moten
Thanks for the Globes David!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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?
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
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?Qu
ery=gb and NOT 
http://localhost/datalist/?Query=gb or 
the script doesn't function! Good work 
Lewis!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
Add Your Feedback!
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this code has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.
 
Name:
Comment:

 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | ASP/ VbScript Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyright© 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.