Odd problem - not retrieving any records
3 posts by 2 authors in: Forums > CMS Builder
Last Post: June 16, 2010 (RSS)
I have a table of records in which no records are being read using the getRecords code.
First, let me start by mentioning I do not have any publish/remove dates, hidden flags or anything like that on this section.
Here is some code from the header. I've included a second table in which I'm getting records no problem
list($coursesRecords, $coursesMetaData) = getRecords(array(
'tableName' => 'courses',
));
print_r($coursesRecords);
$coursesRecord = $coursesRecords[0]; // get first record
//get all of the instructors - if we are displaying instructors, we will loop thru for each one
list($instructorsRecords, $instructorsMetaData) = getRecords(array(
'tableName' => 'instructors',
));
print_r($instructorsRecords);
The instructors print no problem, the course I'm not getting anything.
I'm also getting back records for several other tables, so I'm a bit confused as to what this could be.
Is there a "debugging" mode such that I can see what's going on in getRecords?
Thanks,
Gary.
First, let me start by mentioning I do not have any publish/remove dates, hidden flags or anything like that on this section.
Here is some code from the header. I've included a second table in which I'm getting records no problem
list($coursesRecords, $coursesMetaData) = getRecords(array(
'tableName' => 'courses',
));
print_r($coursesRecords);
$coursesRecord = $coursesRecords[0]; // get first record
//get all of the instructors - if we are displaying instructors, we will loop thru for each one
list($instructorsRecords, $instructorsMetaData) = getRecords(array(
'tableName' => 'instructors',
));
print_r($instructorsRecords);
The instructors print no problem, the course I'm not getting anything.
I'm also getting back records for several other tables, so I'm a bit confused as to what this could be.
Is there a "debugging" mode such that I can see what's going on in getRecords?
Thanks,
Gary.
Re: [garyhoffmann] Odd problem - not retrieving any records
By Chris - June 16, 2010
Hi Gary,
Can you please post the complete PHP source code for your page, as well as a description of (or link to) what the results are?
Does nothing print for print_r($coursesRecords)?
There is a debugging mode which shows you the SQL generated for your getRecords call. I'm not sure it'll help, but you can always try it:
Can you please post the complete PHP source code for your page, as well as a description of (or link to) what the results are?
Does nothing print for print_r($coursesRecords)?
There is a debugging mode which shows you the SQL generated for your getRecords call. I'm not sure it'll help, but you can always try it:
list($coursesRecords, $coursesMetaData) = getRecords(array(
'tableName' => 'courses',
'debugSql' => true,
));
All the best,
Chris
Chris
Re: [chris] Odd problem - not retrieving any records
Nevermind on this one. I'm calling this page with a querystring and did not put the allowSearch to false on the getRecords command, so it was trying to create a query with my querystring parameters.