Advice on Simple Structured Sql Query (Search)

Hi All,
I have created a well structured cross relationship db.. To extract all
the details out is not a problem but i am trying to now include a
simple search to filter results.. Where is the best place to build the
query, within my .Net web app or within a sp itself..
My basic setup is a table with a list of jobs (Jobs_Jobs) and fields
(JobID, Title, Keywords) and then another table that lists the
locations of the jobs(Jobs_Locations) and fields(ID,JobID,LocationID)..
What i am then trying to do is include a keyword search and a location
search together, i need to make it boolean as well and split keywords
up and then search within these to make sure they are in the
locations.. In my head it seemed fairly approchable but cant seem to
grasp it and cant find any decent tutorials.. Could you please point me
in the right direction: Do i need to be using dynamic sql', Should i
be doing most of the work within .net
A typical search would be for:
Keywords: IT,Graduate
Within Location: 12,35,48
I can do one or the other but not combined.. I also dont know how to
split up the keywords to make them two seperate keywords..
If anyone can point me in the right direction as this is my last
hurdle.. On this project at least :)Have a look at
http://www.sommarskog.se/dyn-search.html and
http://www.sommarskog.se/arrays-in-sql.html
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"ponyoo" <anthonykallay@.hotmail.com> wrote in message
news:1133857887.366250.221060@.g14g2000cwa.googlegroups.com...
> Hi All,
> I have created a well structured cross relationship db.. To extract all
> the details out is not a problem but i am trying to now include a
> simple search to filter results.. Where is the best place to build the
> query, within my .Net web app or within a sp itself..
> My basic setup is a table with a list of jobs (Jobs_Jobs) and fields
> (JobID, Title, Keywords) and then another table that lists the
> locations of the jobs(Jobs_Locations) and fields(ID,JobID,LocationID)..
> What i am then trying to do is include a keyword search and a location
> search together, i need to make it boolean as well and split keywords
> up and then search within these to make sure they are in the
> locations.. In my head it seemed fairly approchable but cant seem to
> grasp it and cant find any decent tutorials.. Could you please point me
> in the right direction: Do i need to be using dynamic sql', Should i
> be doing most of the work within .net
> A typical search would be for:
> Keywords: IT,Graduate
> Within Location: 12,35,48
> I can do one or the other but not combined.. I also dont know how to
> split up the keywords to make them two seperate keywords..
> If anyone can point me in the right direction as this is my last
> hurdle.. On this project at least :)
>

ADO Error Code:0x80040e4d

Hello all,

I use Crystal Report v9, SQL server 2000.
When I try to connect to a Database via ADO, I got the following error.

Login failed.
Details :ADO Error Code:0x80040e4d
Source:Microsoft OLE DB Provider for SQL Server
Description:Login failed for usexxxxxxx
SQL State: 42000
Native Error:18456

Is there anyone how has this problem?
How can I fix this?

Thanks in advance,
Do.

--
Message posted via http://www.sqlmonster.com"Do Park via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:9caa7e6d6eff41c1984f7334221dc753@.SQLMonster.c om...
> Hello all,
>
> I use Crystal Report v9, SQL server 2000.
> When I try to connect to a Database via ADO, I got the following error.
> Login failed.
> Details :ADO Error Code:0x80040e4d
> Source:Microsoft OLE DB Provider for SQL Server
> Description:Login failed for use'xxxxxxx'
> SQL State: 42000
> Native Error:18456
> Is there anyone how has this problem?
> How can I fix this?
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com

"Login failed" suggests that you need to check the login you're using to
connect with - is it a SQL login, or a Windows account; are you using a DSN
or a connection string; can you connect from osql.exe or Query Analyzer
using the same account (or another account) etc.

Simon|||I use Windows authentication. I can access other databases via the same way
(Crystal Report). I connected this database via ADO successfully two or
three days ago. There was no change in my environment and SQL Server.

Best regards,
Do.

--
Message posted via http://www.sqlmonster.com|||Do Park via SQLMonster.com (forum@.SQLMonster.com) writes:
> I use Windows authentication. I can access other databases via the same
> way (Crystal Report). I connected this database via ADO successfully two
> or three days ago. There was no change in my environment and SQL
> Server.

Probably there was. Unfortunately, it is impossible for us who don't
have access to your environment to tell what is going on. You will
have to see your local admin to sort it out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp