OK I think I've resolved this. It works when I use a "Contains" implicit query,
rather than an "Equal to" implicit query.
Giddyup.
Tom
"Tom Christ" <[EMAIL PROTECTED]> wrote:
>>Yes, the checked value is set to "1". I followed your advice, and here is the Query
from my log (this try is using a list box instead, but values are the same
and so
are the results):>>Yes=1>No=0>>With "Yes" Selected:>>20 Oct 11, 1999
at 09:15:04.134 Terse
Debug 221> DSRdbmsService
DSRdbmsService:c:939385921643:w:93938>5946805:execute SQL
command: |SELECT ALL FormData.ID, FormData.SubName, >FormData.Date,
FormData.SubTitle,
FormData.SubMStop, FormData.SubAddr, >FormData.SubCity, FormData.SubSt,
FormData.SubZip,
FormData.SubCountry, >FormData.SubIntel, FormData.SubEmail,
FormData.XConName, FormData.XConTitle,
>FormData.XConMStop, FormData.XConAddr, FormData.XConCity, FormData.XConSt,
>FormData.XConZip,
FormData.XConCountry, FormData.XConIntel, FormData.XConEmail,
>FormData.Product,
FormData.SerNum, FormData.ReqRec, FormData.Backg, >FormData.SysType,
FormData.CusEnv,
FormData.Comp, FormData.CustName, >FormData.CustContName, FormData.CustTitle,
FormData.CustAddr,
FormData.CustCity, >FormData.CustSt, FormData.CustZip, FormData.CustCountry,
FormData.CustPhone,
>FormData.CustEmail, F>ormData.Response, FormData.Complete FROM >FormData
WHERE (FormData.Complete
LIKE '1%') ORDER BY FormData.ID DESC|>>With "No" Selected (this returns
correct
results):>>7 Oct 11, 1999 at 09:14:53.168 Terse Debug 535>
DSRdbmsService DSRdbmsService:c:939385921643:w:93938>5946805:execute
SQL command: |SELECT ALL FormData.ID, FormData.SubName, >FormData.Date,
FormData.SubTitle,
FormData.SubMStop, FormData.SubAddr, >FormData.SubCity, FormData.SubSt,
FormData.SubZip,
FormData.SubCountry, >FormData.SubIntel, FormData.SubEmail,
FormData.XConName, FormData.XConTitle,
>FormData.XConMStop, FormData.XConAddr, FormData.XConCity, FormData.XConSt,
>FormData.XConZip,
FormData.XConCountry, FormData.XConIntel, FormData.XConEmail,
>FormData.Product,
FormData.SerNum, FormData.ReqRec, FormData.Backg, >FormData.SysType,
FormData.CusEnv,
FormData.Comp, FormData.CustName, >FormData.CustContName, FormData.CustTitle,
FormData.CustAddr,
FormData.CustCity, >FormData.CustSt, FormData.CustZip, FormData.CustCountry,
FormData.CustPhone,
>FormData.CustEmail, F>ormData.Response, FormData.Complete FROM >FormData
WHERE (FormData.Complete
LIKE '0%') ORDER BY FormData.ID DESC|>>Thanks,>Tom C.>>"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>
wrote:>>>are you sure you changed the "checked value">on the search page
check box
to "1" - ?>>have you tried turning on terse/verbose debug>in the RDBMS
service to
see exactly what>query is being sent?>>-Chip>Team NetDynamics>>"Tom Christ"
<[EMAIL PROTECTED]>
wrote:>>>I have created a basic search page, based on >several fields from 1
MS Access
table. One >of the fields in the table is a Yes/No >field, which returns 0
(No)
and 1 (Yes) to >ND as values when I perform a normal query, >and I can
display>these
as checkboxes on my >query results page (not search results >page). The
problem
is, when I have the >checkbox on my search page (I have also >tried radio
buttons
- which I would like to >use), it returns records matching when box >is
unchecked
(value 0),>but no records when >box is checked (value 1). What do I need to
>do
to get the correct results?>>I am using ND 4.1.3>>Thanks!>Tom C.
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
