Page list by city

Hi,

For the getRecords statement with a where clause there are a couple of things you could try:

I notice that you have a capital letter on city in your where clause, although you can save a field name with a capital letter, usually CMS builder will set the field up to be completely lowercase, so I'd double check that is correct.

Is the city being generated by a list field that uses the 'get options from database (advanced)' to generate the list of cities? If it is then difference between values and labels is that the value is what is stored in the database field and the labels is meant to be a more descriptive name that you might want to display on the page. Your where clause needs to contain the cities value and not its label.

If neither of these work, could you post up what is returned after you add this code:

// load records from 'rentals'
list($rentalsRecords, $rentalsMetaData) = getRecords(array(
'tableName' => 'rentals',
'loadUploads' => true,
'allowSearch' => false,
));

showme($rentalsRecords[0]);

It should output what is being stored in the first value of the $rentalsRecord variable.

Thanks!

Hi,

Just a guess...

If you're pulling list values from a database using the record number 'num' field for option values and a text field for option labels, you may have to add the pseudo field 'your_field:label' to your filter, instead of just 'your_field' so that it returns a text value instead of a number.

Use <?php showme($record['your_field']);exit; ?>

And in your list records call, 'debugSql' => true,

to help see what's going on.

Good luck,

Jerry Kornbluth

Oh that didnt work at all

// load records from 'rentals'
list($rentalsRecords, $rentalsMetaData) = getRecords(array(
'tableName' => 'rentals',
'loadUploads' => true,
'allowSearch' => false,
));


http://mesaverderentals.com/2012/GilbertRentalList.php?City=Gilbert



this is the code City is correct

<b>Record Detail</b><br/>
Record Number: <?php echo htmlencode($detailRecord['num']) ?><br/>
Move In (value): <?php echo $detailRecord['move_in'] ?><br/>
Move In (label): <?php echo $detailRecord['move_in:label'] ?><br/>
Move In Pending : <?php echo htmlencode($detailRecord['move_in_pending']) ?><br/>
NOTICE: <?php echo htmlencode($detailRecord['notice']) ?><br/>
Cross Street: <?php echo htmlencode($detailRecord['cross_street']) ?><br/>
Map Link: <?php echo htmlencode($detailRecord['map_link']) ?><br/>
Address: <?php echo htmlencode($detailRecord['address']) ?><br/>
City (values): <?php echo join(', ', $detailRecord['City:values']); ?><br/>
City (labels): <?php echo join(', ', $detailRecord['City:labels']); ?><br/>
State: <?php echo htmlencode($detailRecord['state']) ?><br/>
Zip: <?php echo htmlencode($detailRecord['zip']) ?><br/>
Bedroom (value): <?php echo $detailRecord['bedroom'] ?><br/>

attached the file

thanks

Not trying to use record number just trying to ge the cities to each have there own page.

Not sure, but wouldn't allowSearch' => false, stop the city value from being searched?

Perfect --set to true

and removed

showme($rentalsRecords[0]);