|
 |
asp_web_howto thread: need a "no records found" message
Message #1 by "taherm@f... on Fri, 15 Jun 2001 17:08:39
|
|
i have designed an asp results page. it displays appropirate results. but
if there are no results found teh page is blank-because nothing is found
in the recordset1.
i wnat to display a message that "no records found".
how can i do this
is there anything like
<% if recordset1.value=false then response.write " No record found"
end if%>
i am just guessing i dont know if teh above statement is right
thanks in advance
Message #2 by Jerry Diegel <jerry.diegel@h...> on Fri, 15 Jun 2001 13:39:18 -0500
|
|
actually its:
If recordset1.eof then
Response.WRite "No Records Found"
End If
You also one of the ways to make sure you have records before you start
looping through them.
-----Original Message-----
From: taherm@f...
[mailto:taherm@f...]
Sent: Friday, June 15, 2001 12:09 PM
To: ASP Web HowTo
Subject: [asp_web_howto] need a "no records found" message
i have designed an asp results page. it displays appropirate results.
but
if there are no results found teh page is blank-because nothing is
found
in the recordset1.
i wnat to display a message that "no records found".
how can i do this
is there anything like
<% if recordset1.value=3Dfalse then response.write " No record found"
end if%>
i am just guessing i dont know if teh above statement is right
thanks in advance
Message #3 by "TomMallard" <mallard@s...> on Fri, 15 Jun 2001 21:47:57 -0700
|
|
if not recordset1.BOF then
'you've got something
while not recordset1.EOF
'loop though it
wend
else
response.write "No records found.<br>" & vbcrlf
end if
tom
----- Original Message -----
From: <taherm@f...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Friday, June 15, 2001 5:08 PM
Subject: [asp_web_howto] need a "no records found" message
> i have designed an asp results page. it displays appropirate results. but
> if there are no results found teh page is blank-because nothing is found
> in the recordset1.
> i wnat to display a message that "no records found".
> how can i do this
>
> is there anything like
>
> <% if recordset1.value=false then response.write " No record found"
> end if%>
> i am just guessing i dont know if teh above statement is right
> thanks in advance
>
Message #4 by "Alex Shiell, ITS, EC, SE" <alex.shiell@s...> on Mon, 18 Jun 2001 11:16:25 +0100
|
|
<% if recordset1.eof then
response.write " No record found"
end if%>
-----Original Message-----
From: taherm@f...
[mailto:taherm@f...]
Sent: 15 June 2001 18:09
To: ASP Web HowTo
Subject: [asp_web_howto] need a "no records found" message
i have designed an asp results page. it displays appropirate results.
but
if there are no results found teh page is blank-because nothing is
found
in the recordset1.
i wnat to display a message that "no records found".
how can i do this
is there anything like
<% if recordset1.value=3Dfalse then response.write " No record found"
end if%>
i am just guessing i dont know if teh above statement is right
thanks in advance
|
|
|
View Cart
