hi,
i am using a join query in action class and getting its
recordset like this
$conn = Propel::getConnection();
$stmt = $conn->prepareStatement($query);
$this->rs=$stmt->executeQuery();
1----- i am using this rs in template like this
<?php
while( $rs->next())
{
<a href="<?php echo url_for('listing/show?id=' . $rs-
>getString('listingid') . '&prop_category=' . $prop_category .
'&listing_type=' . strtolower($listing->getLongListingType()) .
'&property_type=' . strtolower($listing->getPropertyType()).'&city=' .
$rs->getString('listing_city') . '&area=' . $rs-
>getString('listing_area'))?>">
<?php echo $rs->getString('propertyname');?></a>
<?php }
?>
in this case it is not showing the recordset value in template .
2-----other way
<?php
while(true)
{
$rs->next();
try { $rs->getString('listingid'); } catch(Exception $e)
{break;}?>
<a href="<?php echo url_for('listing/show?id=' . $rs-
>getString('listingid') . '&prop_category=' . $prop_category .
'&listing_type=' . strtolower($listing->getLongListingType()) .
'&property_type=' . strtolower($listing->getPropertyType()).'&city=' .
$rs->getString('listing_city') . '&area=' . $rs-
>getString('listing_area'))?>">
<?php echo $rs->getString('propertyname');?></a>
<?php }
?>
In this case it is working properly and showing all records but an
error message is diplaying
Warning: array_key_exists() [function.array-key-exists]: The second
argument should be either an array
/usr/share/php/symfony/vendor/creole/drivers/mysql/MySQLResultSet.php
on line 109
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
