Hi there,

I've got an ASP script which allows people to search an SQL database from
our Intranet. It was working perfectly until we added new data to the
database. Now when we search on that new data, only some rows are returned
and not others. Basically the information stored is employee info, so say i
added to new rows, one for Joe Bloggs and one for Andy Smith. Now when i
search for Andy through the intranet search form, no rows are returned, but
when i search for joe, his field is returned. I've tried to make the rows
exactly the same (except the actual name and ID number) but still no
luck....i've also tried doing this in access (where the database was
originally written and the same thing is happening).

ARGH!

Neile

--

Neile Bermudes
Network Support Analyst
ECB IT Dept
--> 0207 4321241



The contents of this e-mail are the property of the ECB.  This e-mail (and any attachments) 
are confidential and intended for use by the named recipient(s) only.  It may contain 
confidential or privileged information.  Any opinions expressed herein are those of the 
individual and not necessarily those of the ECB. If you are not the intended recipient would 
you please immediately delete this e-mail and any attachments from your computer system 
without publishing, copying or distributing it, and notify the sender at the ECB.  Do not 
disclose this e-mail or the information disclosed herein to any other person, use it for any 
purpose other than intended, or copy, distribute or store the information on any medium. 
Copyright in this e-mail and attachments created by us belong to ECB and the author also 
asserts the right to be identified as such and to prevent any misuse.  Please conduct your 
own virus checks.  The ECB does not accept responsibility or liability for any virus or any 
loss or damage caused by such software virus.  Our web site is at http://www.ecb.co.uk.

>> The error is on line 8
>>
>
> How do you know? I didn't post any code...
>

Exactly

Cheers
Ken


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Neile Bermudes" <Neile.Bermudes@e...>
Subject: [asp_databases] No results returned on some data


: Hi there,
:
: I've got an ASP script which allows people to search an SQL database from
: our Intranet. It was working perfectly until we added new data to the
: database. Now when we search on that new data, only some rows are returned
: and not others. Basically the information stored is employee info, so say
i
: added to new rows, one for Joe Bloggs and one for Andy Smith. Now when i
: search for Andy through the intranet search form, no rows are returned,
but
: when i search for joe, his field is returned. I've tried to make the rows
: exactly the same (except the actual name and ID number) but still no
: luck....i've also tried doing this in access (where the database was
: originally written and the same thing is happening).
:
: ARGH!
:
: Neile

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~