Recordset Disappears from Behaviours Panel

[The_FedEx_Guy]

I came back to a page that was working fine when I uploaded it to my server.

But somehow the record count was not working. So I had a look at the file and it seemed fine.
The only thing that was odd was that the Server Behaviour panel was showing a little red Exclamation Mark on the side.

And I noticed that the Recordset was missing.

How can I get it back? I think this is why the count is not working.

The strange thing is I still have the recordset in my page code.

:'(

mysql_select_db($database_db, $db);
$query_jobs_locations = "SELECT city_name, count(jobs.job_id) as job_count
FROM city
LEFT JOIN restaurants ON
restaurants.rest_city = city.city_name
LEFT JOIN jobs ON
restaurants.rest_id = jobs.rest_id AND
job_status = 'ON'
GROUP BY city_name";
$jobs_locations = mysql_query($query_jobs_locations, $db) or die(mysql_error());
$row_jobs_locations = mysql_fetch_assoc($jobs_locations);
$totalRows_jobs_locations = mysql_num_rows($jobs_locations);

[Newsgroup_User · Accepted solution]

From my experience this happens when you make manual corrections and DW
has no clue how to work with it.

Most of my recordsets are this way because I use loads of store
procedures and multiple vars that DW does not support.