That works. I thought dbform should default to %<<search criteria>>% to minimise any confusion (e.g. you don't want to tell a user to put % before a <<search criteria>>). Any idea why it defaulted to <<search criteria>>%?
> -----Original Message----- > From: Henner Kollmann [SMTP:[EMAIL PROTECTED]] > Sent: 03 February 2003 11:25 > To: 'J M Okomba' > Subject: AW: [dbforms] Searching example > > For me it works if you say %tes as filter. Only tes can not work because > sql query will be build as name like 'tes%'. Results in nothing. > > > > > -----Urspr�ngliche Nachricht----- > > Von: J M Okomba [mailto:[EMAIL PROTECTED]] > > Gesendet: Montag, 3. Februar 2003 12:00 > > An: 'Henner Kollmann' > > Cc: '[EMAIL PROTECTED]' > > Betreff: RE: [dbforms] Searching example > > > > > > > > Just added a search in the edit form. The problem is now > > reverse: I can't navigate beyond the first search result. > > Attached is the modified form: <<authorsEdit.jsp>> > > >From the table contents a search for 'tes' should give more than one > > >result, > > so I should be able to navigate. But that's not happening. > > > > Please help. > > > > > -----Original Message----- > > > From: Henner Kollmann [SMTP:[EMAIL PROTECTED]] > > > Sent: 03 February 2003 08:57 > > > To: 'J M Okomba' > > > Cc: dbf > > > Subject: AW: [dbforms] Searching example > > > > > > > Many thanks Henner. It's working. Just as an extension to it, > > > > is it possible to restrict navigation to the search results? > > > > When I hit the next button I am seeing results outside the > > > > search criteria. > > > > > > In the example searching is working only for the list - not for the > > > edit. So if you hit the edit button you will get the whole > > resultset. > > > To restrict navigation to search you must search in the edit form! > > > > > > Regards, > > > Henner > > ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
