Problems with SQL Query and a partial search - PLEASE HELP !
First of all I would like to say HI to everyone here ! and I hope I can get my little stupid problem solved. I also want to appologize for all my many mistake and bad written. I am not good in english cause I live in Montreal and my first language is french, but I still think I can be understanded and people can help me and that I might could help some people.
Here is my problem. I am in stage in a company where I need to solve the problems there and addapt t he code to be bettet and faster and help the users to work easier. I am not that good with SQL that much and I always make some little mistake some time stupid some time worse probably. ok I think the introduction is enough long.
I don't really understand why I can use the "%" and the "_" on a query string and that on another one I just can't.
If I don't use the special caracters I will get the answer but in my program, the users need to be able to use the * and ? options. It's work fines for the city and road name but doesn't work at all when you are searching for the VPM number (code projet). soo it's kinda weird.
select count(releve.noReleve) FROM Ville INNER JOIN (Rue INNER JOIN
((Compagnie INNER JOIN Releve ON Compagnie.noCie = Releve.noCie)
INNER JOIN Adresse ON Releve.noReleve = Adresse.noReleve)
ON Rue.noRue = Adresse.noRue) ON Ville.noVille = Rue.noVille
where codeProjet = 'vpm%';
on this query I am trying to know how many project name start with VPM but my result is 0 and I know I have some.
cause if I do the same thing but I use VPM1364 has my query I will get 2 answer. like here.
select count(releve.noReleve) FROM Ville INNER JOIN (Rue INNER JOIN
((Compagnie INNER JOIN Releve ON Compagnie.noCie = Releve.noCie)
INNER JOIN Adresse ON Releve.noReleve = Adresse.noReleve)
ON Rue.noRue = Adresse.noRue) ON Ville.noVille = Rue.noVille
where codeProjet = 'vpm1364';
and if I try to use VPM1364% (added the %) it won't find me any results either.
I really don't understand that error. Cause I am doing something really similar with city and roads name and it's work fine. I can use the "%" and "_" caracters and it will find my answer like I want to. It's only with CodeProjet that it doesn't work. Even if it's not a primary key and it's attribute is a string shouldn't be a problem.
I would appreciate if someone could tell me the problem or how to by-pass it ! I just don,t know ! I never got something like that before. May be it's just because I am tired I don't know.
thank you for all your time and help.
try LIKE instead of =. As in codeProject LIKE 'vpm%'.
Originally posted by bricker42
try LIKE instead of =. As in codeProject LIKE 'vpm%'.
thank you man ! I can't try it now cause I am at home but I am sure it will work ! it's just plain stupid ! I can't understand why I haven'T see it before ! :rolleyes:
that's what happens when you need to correct others people script and work them better doh ! :(
Hehe. Ya, it's always the small ones that bite you :).