You should be able to use the SQL count() function in your query to return the number of rows, and then query again to get specific rows. The actual returned results may vary in their look/feel depending on what DBMS you use, but the premise is the same.<div>
<br></div><div>For example, let's say there's a table named "id_name" with 2 columns ("id","name") that allows duplicates.</div><div><br></div><div>table - id_name</div><div>ID | NAME</div>
<div>1 | Matthew</div><div>2 | Matthew</div><div>3 | Robert</div><div>4 | Matthew</div><div><br></div><div>select count(NAME) from id_name - should return 4, the ac</div><div>select count(NAME) from id_name where NAME="Matthew" - should return 3</div>
<div><br></div><div>Matthew Saskin</div><div><a href="mailto:msaskin@gmail.com" target="_blank">msaskin@gmail.com</a><br>203-253-9571<br><br>
<br><br><div class="gmail_quote">On Sat, Nov 13, 2010 at 2:20 AM, shary shary <span dir="ltr"><<a href="mailto:shaary1@hotmail.com">shaary1@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<br><br><font color="#0000ff" face="Comic Sans MS">1- its version is 7.0.1 with Sr4.</font><br>
<font color="#0000ff" face="Comic Sans MS">2- Infact this table can have more than more rows agains one field. Infact what i need to know first how many row returns after query to DB and if it has more than 1 row then get the data of all rows and save them in to an array and to access all of them one by one.</font><br>
<font color="#0000ff" face="Comic Sans MS"></font> <br>
Reagrds<br>
sheeraz<br><div class="hm"> <br>
<hr>
Date: Thu, 11 Nov 2010 09:03:33 -0600<br>Subject: Re: [cisco-voip] 2 rows DB query for UCCX<br>From: <a href="mailto:avholloway%2Bcisco-voip@gmail.com" target="_blank">avholloway+cisco-voip@gmail.com</a><br>To: <a href="mailto:shaary1@hotmail.com" target="_blank">shaary1@hotmail.com</a><br>
CC: <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></div><div><div></div><div class="h5"><br><br>1. I have an idea about this, but not sure if it's available in 7.0(1) (you are on 7.0(1) correct? which SR?).
<div>2. You cannot get the number of rows returned from the DB Read Step. Under the success branch, create a loop, using a label and a goto step, that executes the DB Get step until it lands in the No Data branch. Keep track of your loop count to know how many records were returned.</div>
<div><br></div>
<div>Anthony<br><br>
<div>On Thu, Nov 11, 2010 at 12:16 AM, shary shary <span dir="ltr"><<a href="mailto:shaary1@hotmail.com" target="_blank">shaary1@hotmail.com</a>></span> wrote:<br>
<blockquote style="border-left:#ccc 1px solid;padding-left:1ex">
<div>hi folks,<br>I have 2 queries regardin the UCCX 7.0.2. <br> <br>1- My customer wants to catch the Call Release Event performed by the Agent on CAD and put it into any report. So i want to ask how would i catch this event and put it in customize report.<br>
<br>2- During DB fetching i got 2 rows against the one field and my ask is to chcek if DB is returing 2 rows against one field then it should ask for some more information otherwise go directly to agent. How can i check this option in a "Success option" of DB Read Node.<br>
<br> <br><br><font color="#0000ff" face="Lucida Handwriting, Cursive">Regards,</font><br><font color="#0000ff" face="Lucida Handwriting">Sheeraz Saeed lodhi.</font><br><br><br><br></div><br>_______________________________________________<br>
cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div> </div></div></div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>