#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    11

    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.
  2. #2
  3. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    try LIKE instead of =. As in codeProject LIKE 'vpm%'.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Montreal, Canada
    Posts
    486
    Rep Power
    11
    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 !

    that's what happens when you need to correct others people script and work them better doh !
  6. #4
  7. No Profile Picture
    Moderator =(8^(|)
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Feb 2002
    Location
    Sacramento, CA
    Posts
    1,710
    Rep Power
    14
    Hehe. Ya, it's always the small ones that bite you .

IMN logo majestic logo threadwatch logo seochat tools logo