phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Puneeth Prasad" <ppune...@datasemantics.in>
Subject PrepareAndExecute statement return only 100 rows
Date Thu, 13 Oct 2016 16:36:02 GMT
Hi,

 

PrepareAndExecute statement has a default limit of returning 100 rows. To
avoid that, we use maxRowCount = -1, but it still gives only 100 rows. 

 

 I've copied the PHP code below, the highlighted part is the necessary
change to fetch all the rows possible. Can you please suggest where we've
gone wrong and how to correct it? Is there something pretty obvious we
missed out here?

 

 

curl_setopt($ch, CURLOPT_URL, "http://ip.address.of.phoenix.server:8765/
<http://120.138.8.208:8765/> ");

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

curl_setopt($ch, CURLOPT_POST, 1);

 

$headers[] = "Request:
{\"request\":\"openConnection\",\"connectionId\":\"000000-0000-0000-00000000
\"}";

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

 

$result = curl_exec($ch);

 

$headers[] = "Request:
{\"request\":\"createStatement\",\"connectionId\":\"000000-0000-0000-0000000
0\"}";

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

 

$result = curl_exec($ch);

 

$headers[] = "Request:
{\"request\":\"prepareAndExecute\",\"connectionId\":\"000000-0000-0000-00000
000\",\"statementId\": ".$a.",\"sql\": \"SELECT * FROM
TABLE_NAME\",\"maxRowCount\":-1}";

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

 

$result = curl_exec($ch);

 

$headers[] = "Request:
{\"request\":\"closeStatement\",\"connectionId\":\"000000-0000-0000-00000000
\",\"statementId\": 1}";

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

 

$result = curl_exec($ch);

 

$headers[] = "Request:
{\"request\":\"closeConnection\",\"connectionId\":\"000000-0000-0000-0000000
0\"}";

curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

 

$result = curl_exec($ch);

 

 

Thanks!

Puneeth

 


Mime
View raw message