Code

Re: Result of a query

Raoul — Thu, 05 Oct 2006 08:14:53 GMT

Hi Matt,
thank you for your hint. My problem now is that I don't know what kind of expression I should use to test rows in the rule condition. Can you help me?
Thank you. Raoul

Re: Result of a query

Matt Faus — Wed, 04 Oct 2006 18:03:54 GMT

Oh, ok. You should be able to translate the code above into three rules.

Rule 1: no condition, fire query to secondary dom
Rule 2: if rows on secondary dom > 0, change view
Rule 3: if rows on secondary dom = 0, display message

Re: Result of a query

Raoul — Wed, 04 Oct 2006 07:35:44 GMT

Hi Matt,
thank you for help. Language of code is js, but actually button query start a "query action" with secondary connection , not a "coded query" into onclick event.
I'm waiting for your reply.
Thank you. Raoul

Re: Result of a query

Matt Faus — Tue, 03 Oct 2006 16:17:29 GMT

This shouldn't be too hard. What language are you using? Below is some psuedo-code for achieving this:

IssueQuery();

NodeList = SecondaryDom.selectNodes( "/my:xpath/my:toNodes" );
if( NodeList.length > 0 )
ChangeView();
else
DisplayMessage();

I hope this helps, if you provide the language that you are using I will be able to provide a more tailored code snippet.

Result of a query

Raoul — Tue, 03 Oct 2006 12:27:41 GMT

Hi all,
I have a button query that search for a code into an access db. I need to know if this query return some records or not. If return one or more records I should change view, if no records return I should display a message. Can you help me?
Thanks in advance.
Raoul