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]
