asp script to show element if 2 recordset are both empty?

This is a discussion on "asp script to show element if 2 recordset are both empty?" within the Classic ASP section. This forum, and the thread "asp script to show element if 2 recordset are both empty? are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Classic ASP

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Oct 12th, 2005, 10:44
New Member
Join Date: May 2004
Location: United Kingdom
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
asp script to show element if 2 recordset are both empty?

Hi,
I have two recordsets in one page - i want to hide an element if both recordsets are empty. If either sets have data then it can be seen. Any ideas?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Oct 12th, 2005, 10:59
Reputable Member
Join Date: Aug 2003
Location: United Kingdom
Posts: 341
Thanks: 0
Thanked 0 Times in 0 Posts
Code: Select all
IF [recordset1].EOF and [recordset2].EOF then
     'do code to show something
End if
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old Oct 12th, 2005, 11:36
New Member
Join Date: May 2004
Location: United Kingdom
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
now it seems to make it dissappear regardless

its hiding the region all the time now?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old Oct 12th, 2005, 19:31
Reputable Member
Join Date: Aug 2003
Location: United Kingdom
Posts: 341
Thanks: 0
Thanked 0 Times in 0 Posts
Sorry, that should have been:

Code: Select all
IF not [recordset1].EOF and not [recordset2].EOF then
     'do code to show something
End if
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old Dec 1st, 2005, 10:24
New Member
Join Date: Nov 2005
Age: 30
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Re: asp script to show element if 2 recordset are both empty?

now that the right code:

[EDIT] SPAM LINKS REMOVED[/EDIT]

Last edited by Rob; Dec 1st, 2005 at 15:05.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
asp, script, show, element, recordset, both, empty

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
form element disable script thenamenoonehastaken JavaScript Forum 1 Apr 21st, 2008 09:39
Add class if input not empty on-the-fly Aso JavaScript Forum 3 Feb 28th, 2008 16:47
isset and empty karinne PHP Forum 15 Jan 28th, 2008 12:37
show hide script problem Scribble69 JavaScript Forum 5 Nov 27th, 2006 18:40
XHTML Block Element in an Inline Element gohankid77 Web Page Design 6 Jul 27th, 2004 10:15


All times are GMT. The time now is 16:02.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42