Here are some more detailed informations you asked for: The form has to search always for 4 numbers. The result may show 4 numbers or less (when matched). Position is not important. Search will be always for 4 numbers. All 4 fields have numbers. There are no empty fields in DB.
On 11 Wrz, 16:19, mdipierro <[email protected]> wrote: > Will your search form accept one number or 4? Do you need to search > for records that have any of the numbers of all of the numbers? Are > the position (1,2,3,4) and the numbers important? Is 4 fixed or may > that increase in the future? Can the value of any of the no_x fields > be None or other than a number? > > On Sep 11, 12:12 am, elfuego1 <[email protected]> wrote: > > > Hello, > > > I need to create a search form. > > In my DB I have fields with numbers. Now I need to look up the DB and > > find out if the numbers I enter are there already or not. > > > db.define_table('numbers', > > Field('no_1', length=18), > > Field('no_2', length=18), > > Field('no_3', length=18), > > Field('no_4', length=18), > > Field('date', 'date',default=now) > > > I'd like to get two kinds of information from the DB. > > 1. If there is a matching record in DB: > > I'd like to display all fields with matching numbers and a date > > when that happend (last field in DB contains a date). > > 2. If there is NO MATCH: > > I'd like to get answer: „No matching record found”. > > > Can you tell me what should I do to generate a search form with four > > input fields and run their contetns against my DB? > > > Best regards. > >
