Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Need Extra ASP code for DB connection
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Woody
Starting Member

United Kingdom
3 Posts

Posted - 04 November 2003 :  16:33:14  Show Profile  Visit Woody's Homepage
Hello. I would like to know how I can do this (new to this!);

I have an .asp page that searches through an Access 2000 DB. I would like to have a button that users can click (in addition to the normal search one) that will display all results from the database. At the mo, users have to put a % in the search field.

Also, I would like some .asp that will add to the screen "No Data Found" etc. if their search returns nothing.

I can send you an .asp code in .txt format if that's OK.

Thanks,

Woody

Edited by - ruirib on 04 November 2003 16:46:31

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 04 November 2003 :  16:38:20  Show Profile
is this related to the snitz forum? if not, a moderator should move this post to the Code Support: ASP (Non-Forum Related) forum

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 04 November 2003 :  18:48:28  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Can you post a link to your .txt file?

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Woody
Starting Member

United Kingdom
3 Posts

Posted - 05 November 2003 :  02:33:39  Show Profile  Visit Woody's Homepage
Hiya redbrad0.

http://www.woodyweb.me.uk/asp.txt

The live version can be found at;

http://www.angliacarfinance.com/gallery.asp


Woody
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 05 November 2003 :  10:19:57  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
http://www.eznetideas.com/snitz.txt

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

Woody
Starting Member

United Kingdom
3 Posts

Posted - 05 November 2003 :  15:19:16  Show Profile  Visit Woody's Homepage
Hi Brad,

Thanks for coming back so quickly. I had to change the following code as I was getting and VB Script error;

if rs.eof or rs.bof then
else
do until rs.eof or rs.bof


with

if rstSearch.eof or rstSearch.bof then
else
do until rstSearch.eof or rstSearch.bof


and although it still searches, the Show All button doesn't seem to work.

Any ideas??

Woody
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07