Smarty Forum Index Smarty
WARNING: All discussion is moving to https://reddit.com/r/smarty, please go there! This forum will be closing soon.

Foreach de smarty me muestra solo primer caracter de arreglo

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Smarty Forum Index -> Language: Spanish
View previous topic :: View next topic  
Author Message
jarodriguez
Smarty n00b


Joined: 27 Feb 2008
Posts: 3

PostPosted: Wed Feb 27, 2008 4:04 pm    Post subject: Foreach de smarty me muestra solo primer caracter de arreglo Reply with quote

Hola a todos
Estoy utilizando para bases de datos adodb

tengo un idex.php con este codigo

Code:
<?php
  $sql = 'select contact_id, name, nick from contacts ';
  $smarty->assign('results', $db->GetRow($sql));
  ---- llamado al template index.tpl



en index.tpl

Code:
{foreach key=cid item=con from=$results}
    <a href="contact.php?contact_id={$cid}">{$con.contact_id} - {$con.nick}</a><br />
{/foreach}


El resultado que me da es
1-A

o sea me devuelve solo el primer caracter de cada columna, sin embargo cuando utilizo la variable fuera del foreach me muestra correctamente los campos, o sea:

index.tpl

Code:
Mostrando los campos: "{$result.contact_id}"<br/>
Y el nick del user es: {$result.nick}


Esto ultimo me mostraria en el navegador

Mostrando los campos: 15
Y el nick del user es: Andormetus
Back to top
View user's profile Send private message
mrtinez
Smarty Rookie


Joined: 31 Jan 2005
Posts: 26
Location: Mexico

PostPosted: Wed Feb 27, 2008 4:50 pm    Post subject: Foreach de smarty me muestra solo primer caracter de arreglo Reply with quote

Hola, prueba con execute.

$smarty->assign('results', $db->Execute($sql));


saludos.
Back to top
View user's profile Send private message Visit poster's website
mrtinez
Smarty Rookie


Joined: 31 Jan 2005
Posts: 26
Location: Mexico

PostPosted: Wed Feb 27, 2008 4:57 pm    Post subject: Foreach de smarty me muestra solo primer caracter de arreglo Reply with quote

tambien puede funcionar como lo tienes pero cambiando la forma de leer el registro en el template.

{foreach key=cid item=obj from=$rs}
<a href="contact.php?contact_id={$cid}">{$obj}</a><br />
{/foreach}


espero te sea de utilidad.
Back to top
View user's profile Send private message Visit poster's website
jarodriguez
Smarty n00b


Joined: 27 Feb 2008
Posts: 3

PostPosted: Wed Feb 27, 2008 6:13 pm    Post subject: Foreach de smarty me muestra primer caracter de arreglo Reply with quote

Mario, el problema de utilizar execute es que me devuelve mas de un resultado y solo quiero q me muestre una sola fila... q como vi en adodb es utilizando getRow, ademas en el ejemplo q aparece en la pagina de smarty utilizan getAssoc pero tampoco me funciona con eso.
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Smarty Forum Index -> Language: Spanish All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
Protected by Anti-Spam ACP