nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to get the count

ishkmi

iw_sql_query result_set = 'all_products'.....
when we use iw_sql_query and get the result to result_set how can we check whether the result_set contains any results in side perl

i try $varCountResult=scalar keys %all_products;
and also try if(%all_products) it also didnt works

it doesnt work ???

can some one help

Find more posts tagged with

Comments

Adam Stoller

iw_sql_query result_set = 'all_products'.....
when we use iw_sql_query and get the result to result_set how can we check whether the result_set contains any results in side perl

i try $varCountResult=scalar keys %all_products;
and also try if(%all_products) it also didnt works

it doesnt work ???

can some one help

I haven't used the iw_sql_query XML tag much (if at all) - but taking a quick look at the module used for that function, I'm thinking that all_products will be a reference to a hash and not a hash itself - so try:

$varCountResult = keys %{$all_products};

and see if that works any better.

ishkmi

I haven't used the iw_sql_query XML tag much (if at all) - but taking a quick look at the module used for that function, I'm thinking that all_products will be a reference to a hash and not a hash itself - so try:
$varCountResult = keys %{$all_products};
and see if that works any better.

i try this but it doesnt work..?

Phanie

I guess you can try iw_sql_iterate on recordset of your query and can count the query results.

We tried this way in one of our PTs.

----
Phanie

ishkmi

I guess you can try iw_sql_iterate on recordset of your query and can count the query results.

We tried this way in one of our PTs.

----
Phanie

thanks buddy but its not what i'm expecting i want to check wether the result set contain any records..

Ambuj

thanks buddy but its not what i'm expecting i want to check wether the result set contain any records..

Please try below attached code for checking whether resultset have any value or not?
[html]
$ss = $dbhost->prepare(qq{select from });
$rc = $ss->execute;
$fieldname = 0;
while (($fieldname) = $ss->fetchrow_array)
{

}

$dbhost->disconnect;
[/html]

ramana9

Hi ,

I am stuck with getting the count of the result_set in the .

Can anyone suggest me on how do I get the count of the result_set ?

Thanks,
-Ramana

ramana9

Hi ,

I am stuck with getting the count of the result_set in the iw_sql_query.

Can anyone suggest me on how do I get the count of the result_set ?

Thanks,
-Ramana

ISCBorisB

Hi ,

I am stuck with getting the count of the result_set in the iw_sql_query.

Can anyone suggest me on how do I get the count of the result_set ?

Thanks,
-Ramana

try <iw_perl>my $count = scalar(@YourSetName);</iw_perl>
(from the code it looks like an array of hashes)

ramana9

I tried
my $count = scalar(@YourSetName); .
It always giving 0.

nipper

I tried
my $count = scalar(@YourSetName); .
It always giving 0.

And you are certain the data is there ?

do this

foreach (@YourSetName) {
print "$_ \n";
}

log to a file or however your viewed the $count.