Handling search/grid behavior when search results are 0

[david7777777777]

Can someone point me in the right direction as to how I need to code and if statement for my grid if the search results in no recorde returned? I've got a simple SQL statement in my record set as follows:

SELECT LastName, FirstName, MiddleInitial, Department
FROM tbl_employees
WHERE Department = ?

I'm setting the parameter in code from a listbox DTC as follows:

Sub lstDepartments_onchange()
rsEmployees.setParameter 0,lstDepartments.getValue()
End Sub

Then I've got a command button opening the record set. If no records are returned, I'd like the page to remain in an appropriate mode to be able to immediately handle another attempt at a search with input by the user and prompt the user to "try again" with a message that says something like "no records found, try again..."

 

[MerlinB]

After the grid, try adding
<% if rsEmployees.recordCount() = 0 then
Response.Write &quot;No emplyees here - Try Again!&quot;
%>

If you are confident you can change the grid DTC code to add a Empty Recordset message property - that is printed whenever the grid is empty.

Your onchange method should then close/open the recordset.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[david7777777777]

I tried adding that piece of server code and it doesn't like it. It wouldn't even load the page so traces were not available. I tried to type the code manually and when the little drop-down window opened that shows all the available properties or methods for the record set, &quot;recordCount&quot; was not in the list. Does this matter?

 

[MerlinB]

Yes. Try
getCount()

recordCount is the ado method that getCount calls!

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[david7777777777]

It didn't like that either, but thanks for the help. I'll have to dust off my Visual Basic book or JavaScript book to write some client-side code I guess. Feel free to toss me any more clues if you have any though. Thanks.

 

[MerlinB]

this is server-side code. If it is client-side code that you need then I am not too sure of the requirements.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[david7777777777]

yes, I understand that this is server-side code, but that's the problem: I don't know what I need, client or server code. How do I determine what I need: what is the criteria for determining this?

 

[MerlinB]

I assume here that you have a combo, and depending on the selection, either a grid shows or not..

Well, for client side code you:
load up an array with all of the details that could be displayed in the grid - and then a load of javascript to dynamically create the table elements. This is the essence of RDO and client-side data-binding objects - but these tend to only work in IE.

For Server Side code you:
cause a submit to occur when the combo changes, then well you know the rest.

Off to the office party now!

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[david7777777777]

I'm pretty JavaScript ignorant, I'm going to get my book out. Our office party is tomorrow. It's at

http://www.rubyskye.com

Enjoy the party. If you make it to work tomorrow then you did not properly enjoy the party!