advanced search

[rajesh]

hi,
I building a advanced search funcationality
with 3 listbox and 5 checkbox

so want I want that you can search with all possible ways'
cross searching
but when working checkbox's (you can checked multiple)
together is not working
when select one checkbox is working
but selecting more give no output

so what i am doing wrong here
may someone can give me input how to solve this damn search

here is my sql statement
SELECT Call.CallID, Call.IntakeDate, Call.IntakeBy, Call.SystemID,
Call.ShortDescription, Call.PriorityID, Call.CustomerName,
Q_LastLogstatus.CallStatusID, Q_LastLogstatus.CallStatus, Tblstatus.fimage,
Tblcontype.typeimage, Call.[Service Request], Call.CallTypeID,
Call.CallDescription, Support.SupportTeamID FROM ((Tblstatus RIGHT JOIN
((Call INNER JOIN Q_LastLogstatus ON Call.CallID = Q_LastLogstatus.CallID)
LEFT JOIN Finance ON Call.CallID = Finance.CallId) ON Tblstatus.fstatusid =
Finance.chgapproval) INNER JOIN Tblcontype ON Call.FunORCorr_change =
Tblcontype.typeid) INNER JOIN Support ON Call.IntakeBy = Support.SupportID
where call.callid like 'varcallid' and (call.systemid like 'varsystem' and
Q_LastLogstatus.callstatusid like 'varstatus') and (support.supportteamid
like 'varsupport' ) and (funorcorr_change like 'varfun' and
funorcorr_change like 'varservice' and funorcorr_change like 'varCOR' and
funorcorr_change like 'varproblem' and funorcorr_change like 'varincident'
and call.systemid like 'varsystem') and (funorcorr_change like 'varservice'
and call.systemid like 'varsystem') and
( funorcorr_change like 'varservice' or funorcorr_change like 'varincident'
and call.systemid like 'varsystem' ) and (funorcorr_change like 'varservice'
or funorcorr_change like 'varincident' and Q_LastLogstatus.callstatusid like
'varstatus')


and
default value = %
runtime is with "request"

perhaps some more info

if you can see funorcorr_change
this is a field in a table and can have 1 to 5 ofcourse based on the
checkbox
so
varFUN = 1
varCOR = 2
varservice = 3
varincident = 4
varproblem 5

so can someone help me building a advanced search criteria page?
gr. kisoen

[RichMcCrea]

hm.. your use of like for all of your comparisons is a little bizzare.. like
will do some string substring search tricks.. but if you are checking boolean
values (I guess since you are using checkboxes), I would build my where clause
one field at a time.. start with SELECTSTATEMENT='select stuff from tables
where 1=1' and if a checkbox is checked add the next part of the where however
makes sense for the boolean SELECTSTATEMENT=SELECTSTATEMENT + ' AND MYFIELD =
TRUE ' and so on for each boolean idea.. I am not sure where you are going
with the likes..

[rajesh]

oke,

I have coding now
SELECT Call.CallID, Call.IntakeDate, Support.SupportName,
Call.FunORCorr_change, Call.SystemID, Call.ShortDescription
FROM Call INNER JOIN Support ON Call.IntakeBy = Support.SupportID
___
where call.callid= 'varcall' or (call.systemid = 'varsystem' and
call.funorcorr_change = 'varfun') order by call.intakedate desc
___

if you can see the varcall is working fine (is based on searching for 1
particular record
the vasystem (if i do only varsystem it's working but together with varfun
not)

I hope you can help me with this I want to have a multiple search
functionality with listbox and checkbox
and cross searching but not working properly

I'm doing something wrong?
please advise
kisoen



"RichMcCrea" <webforumsuser@macromedia.com> wrote in message
news:cvp39s$4t$1@forums.macromedia.com...

> hm.. your use of like for all of your comparisons is a little bizzare..
> like
> will do some string substring search tricks.. but if you are checking
> boolean
> values (I guess since you are using checkboxes), I would build my where
> clause
> one field at a time.. start with SELECTSTATEMENT='select stuff from
> tables
> where 1=1' and if a checkbox is checked add the next part of the where
> however
> makes sense for the boolean SELECTSTATEMENT=SELECTSTATEMENT + ' AND
> MYFIELD =
> TRUE ' and so on for each boolean idea.. I am not sure where you are
> going
> with the likes..
>