This is not a problem of query! You use free form select with whereClause, so none of the build in sorting and searching will work!
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Julio Ortuzar O. > Gesendet: Mittwoch, 22. Oktober 2003 18:13 > An: [EMAIL PROTECTED] > Betreff: [dbforms] Sort fields in within query > > > Hi, I have a query defined in dbforms-config.xml. Query works > excelent, everything is fine. When I use sort tags within the > dbform tag, nothing happens. None of the 16 fields defined > seem to want to sort. > > Query definition in dbforms-config.xml looks something like: > > <query name= "qry" from= " ...."> > <field name="..." fieldType="..." size="..." isKey="true"/> > <field name="..." fieldType="..." size="..." > sortable="true"/> ... <field name="..." fieldType="..." > size="..." sortable="true"/> </query> > > Sort tag looks something like > > <db:dbform whereClause="<%= strWherePart %>" maxRows="<%= > strNumFilas %>" dbConnectionName="..." tableName="qry" > multipart="false" autoUpdate="false" followUp="..." > <db:header> > .... > <db:sort fieldName="..."/> > .... > </db:header> > .... > </db:dbform> > > > Any restrictions as to using sort fields within queries? > > Thanks, > > Julio Ortuzar > > > > > ------------------------------------------------------- > This SF.net email is sponsored by OSDN developer relations > Here's your chance to show off your extensive product > knowledge We want to know what you know. Tell us and you have > a chance to win $100 > http://www.zoomerang.com/survey.zgi?> HRPT1X3RYQNC5V4MLNSV3E54 > > > _______________________________________________ > DbForms Mailing List > http://www.wap-force.net/dbforms ------------------------------------------------------- This SF.net email is sponsored by OSDN developer relations Here's your chance to show off your extensive product knowledge We want to know what you know. Tell us and you have a chance to win $100 http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
