critera search in FP DB

  • Thread starter Thread starter TNSysman
  • Start date Start date
T

TNSysman

I'm trying to move a ticket ordering system from paper to an internal
intranet, so I am trying to maintain the 'feel' of the ticket to minimize the
learning curb for the users. I'm not THAT new to FP but I haven't come across
this problem before.

This is the FP generated code from the DRW in criteria.
Why doesn't this work?

fp_sQry="SELECT * FROM Results WHERE (C1 = '::C1::' OR C2 = '::C1::' OR C3
= '::C1::' OR C4 = '::C1::' OR C5 = '::C1::' OR C6 = '::C1::' OR C7 =
'::C1::' OR C9 = '::C1::' OR C9 = '::C1::' OR C10 = '::C1::' OR C11 =
'::C1::' OR C12 = '::C1::' OR C13 = '::C1::' OR C14 = '::C1::' OR C15 =
'::C1::' OR C16 = '::C1::' OR C18 = '::C1::' OR C18 = '::C1::' OR C19 =
'::C1::' OR C20 = '::C1::' OR C21 = '::C1::' OR C22 = '::C1::' OR C23 =
'::C1::' OR C24 = '::C1::' OR C25 = '::C1::' OR C26 = '::C1::' OR C27 =
'::C1::' OR C28 = '::C1::' OR C29 = '::C1::' OR C30 = '::C1::' OR C31 =
'::C1::' AND rundateMO = '::month::') ORDER BY ID DESC"

The C1, C2 etc feilds are dates. The users click a check box for the date
they need there ad to run. It can be multiple dates.
The rundateMO field is for the month.

When I use the form, for example, searching for ads to run on the 6th of
Apr. (c6=6, rundateMO1 = 4) It will return any month with the 6th. Even if I
enter the month as 12, 4, 15, or XXX.

Thanks in advance for any help.
 
Change the where clause:

fp_sQry="SELECT * FROM Results WHERE ((C1 = '::C1::' OR C2 = '::C1::'
OR C3
= '::C1::' OR C4 = '::C1::' OR C5 = '::C1::' OR C6 = '::C1::' OR C7
=
'::C1::' OR C9 = '::C1::' OR C9 = '::C1::' OR C10 = '::C1::' OR C11 =

'::C1::' OR C12 = '::C1::' OR C13 = '::C1::' OR C14 = '::C1::' OR C15
=
'::C1::' OR C16 = '::C1::' OR C18 = '::C1::' OR C18 = '::C1::' OR C19
=
'::C1::' OR C20 = '::C1::' OR C21 = '::C1::' OR C22 = '::C1::' OR C23
=
'::C1::' OR C24 = '::C1::' OR C25 = '::C1::' OR C26 = '::C1::' OR C27
=
'::C1::' OR C28 = '::C1::' OR C29 = '::C1::' OR C30 = '::C1::' OR C31
=
'::C1::') AND rundateMO = '::month::') ORDER BY ID DESC"

Note the extra brackets.
Change this in the grey code in code view, and save the page whilst in
code view. The maroon code will be updated when the page is saved.
 
Back
Top