› › SQL Action is not selecting correct data

SQL Action is not selecting correct data


Scenario:

Perform SQL Select Action to retrieve multiple fields.

Issue:

SQL statement 'works' however not all the data is retrieved.

EXTOL error message:

No Error message

Resolution:

Re-review SQL action to ensure there are not multiple entries of the same field in the SQL statement. Also make sure all fields are accounted for.
By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.