Re: Database Search Results Are Incorrect

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 04/22/04 

Date: Thu, 22 Apr 2004 12:11:07 -0700

Thanks for all of your feedback! The site link with query
explinations was helpful. However, I'm not getting the
right results even if my query is exact. If I
say "equals" and put in exact criteria that I know
matches a record in my data I get no results returned.
Any other ideas as to what I could be doing wrong?

Karen - I am pulling data from a database management
program that is not part of the microsoft word suite. I
am able to export to excel but not access. This morning I
attempted to export my excel data into access but when I
upload it to my site the data is not recognized in the
database wizard. Any ideas?

Thanks so much for your help! I'm desperate.

>-----Original Message-----
>If you are using a wildcard query (e.g. company
LIKE '::company::*'), which
>has multiple conditions which you OR together, you may
be getting all
>records because of the combination of wildcard
conditions, blank form
>fields, and the ORs which you use to string them
together. For example, in
>the WHERE clause I posted above, if the form field was
empty, the
>translation would be "company like '*'" which returns
all records. Now
>combine that with another field that DOES have a value,
but the conditions
>are ORed together:
>
>SELECT blah from blah WHERE
>company LIKE '*' OR FullName LIKE 'Mary*'
>
>Notice that the first condition allows ALL records,
while the second
>condition filters the result set. However, the OR means
that any record
>satisfying EITHER condition is a match. The above query
would return ALL
>records.
>
>--
>HTH,
>Kevin Spencer
>..Net Developer
>Microsoft MVP
>Big things are made up
>of lots of little things.
>
>"Melissa" <anonymous@discussions.microsoft.com> wrote in
message
>news:2BFA6A17-F853-42B2-A9D9-
7E4660956AEC@microsoft.com...
>> I have been trying for quite some time to put
together .asp database
>search and results pages (using the front page wizard)
and have been
>unsuccessful. I am currently using front page 2003
(though I've tried this
>with both 98 and 00) and the database is connected
properly and is in excel
>format. (i've also tried this using an access database)
I have tried many
>different variations of search criteria (starts with,
equals, contains,
>ect...) but my results do not return correctly in any
instance. If I set the
>criteria to "contains" then I get the entire database as
my result. I am not
>very saavy with code, but am willing to try anything to
make this work. I'm
>very frustrated and can't figure out what I'm doing
wrong. Here's a link to
>my attempt at this search feature:
>> http://www.caassistedliving.org/Templates/Assoc.asp.
Please excuse the
>look of this site. I am working on a complete re-vamp.
>> please please please help!
>> Thanks.
>
>
>.
>

Relevant Pages

  • Re: [PHP] Re: find (matching) person in other table
    ... than, say, 25 or 50, re-run the query and change the letters matched to 4, ... Well, see, if the match isn't exact, it won't return anything. ... Look at the Levinshtein PHP ... There's a lot of unnecessary work you're making PHP and your database do. ...
    (php.general)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)