SitePoint Sponsor

User Tag List

Page 2 of 2 FirstFirst 12
Results 26 to 28 of 28
  1. #26
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,323
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    that actually looks okay -- i bet it's a bad value in u_field

    at any rate, what's happening now appears to be in the realm of ASP, and so i must take my leave -- i don't do ASP

    however, one common strategy is to modify your code slightly, and instead of submitting the sql query for execution, just display it -- that way you get to see the exact string that's being passed in to access

    use response.write or whatever it is (did i mention i don't do ASP?)

    rudy

  2. #27
    SitePoint Zealot
    Join Date
    Jul 2002
    Posts
    144
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    RUDY, I DONT EVEN KNOW WHERE TO START. YOU HAVE HELPED ME SOOOOOOOOOOOOOOOOOOOO MUCH ON THIS!!!!

    Although I probably will never have the chance to help you in anyway since you are an expert in your field (SQL mostly I assume). Therefore, all I can give in return is my thanks and my newbie help if you need it lOl (yeah right!)


    Sincerely,

    Spaz

    PS: your hunch with the u_field is probably right!
    stay tuned for updates on my newbie situation!!

    One more quick Question:

    can you specify which table for the search field?

    ex. WHERE tablename.field LIKE u_input

    because I really really think its the u_field variable because it contains names that tblPrograms doesnt have
    Last edited by SpazBoy; Jul 29, 2002 at 14:37.
    Just a little boy trying to make his way into the world...
    ~~~Spaz Boy
    Programmer + Gamer = ProGamer

  3. #28
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,323
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    can you specify which table for the search field? absolutely, because since you are constructing the sql string in your ASP program, you can search on whatever you want

    the challenge now is to design your form (and the ASP logic behind that) in such a way that it makes sense to the users who will be running the search

    good luck

    rudy
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •