Maybe your order by statement? <CFQUERY datasource="XYZ" name="zona_destino"> SELECT destino.nombre AS destino_nombre, zona.nombre AS zona_nombre FROM zona INNER JOIN destino ON zona.zona = destino.zona ORDER BY zona_nombre, destino_nombre </CFQUERY>
Needs to be <CFQUERY datasource="XYZ" name="zona_destino"> SELECT destino.nombre AS destino_nombre, zona.nombre AS zona_nombre FROM zona INNER JOIN destino ON zona.zona = destino.zona ORDER BY zona.nombre, destino.nombre </CFQUERY> On Wed, 16 Mar 2005 16:07:54 -0400, Javier Flores <[EMAIL PROTECTED]> wrote: > Hi everyone! > > I would like to know if someone see any mistake here... I got a error on my > server... "Too few parameters. Expected 2" > > I just want to show... > zona_nombre1 > destino_nombre1 > destino_nombre2 > zona_nombre2 > destino_nombre3 > destino_nombre4 > . > . > . > > <CFQUERY datasource="XYZ" name="zona_destino"> > SELECT destino.nombre AS destino_nombre, zona.nombre AS zona_nombre > FROM zona INNER JOIN destino ON zona.zona = destino.zona > ORDER BY zona_nombre, destino_nombre > </CFQUERY> > <table width="222" border="0" cellpadding="0" cellspacing="0"> > <cfoutput query="zona_destino" group="zona_nombre"> > <tr> > <td colspan="2">#zona_nombre#</td> > </tr> > <cfoutput> > <tr> > <td width="13"> </td> > <td width="209">#destino_nombre#</td> > </tr> > </cfoutput> > </cfoutput> > </table> > > Any idea? > > JJ > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
