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.
