1. Welcome to the new MacRumors forums. See our announcement and read our FAQ

Help with a Database Query (I Think)

Discussion in 'Web Design and Development' started by mpw, Jan 4, 2006.

  1. mpw
    Guest

    #1
    http://www.any domain.com/80256C0D005D32A8/WhiteContactDetails?SearchView&Query=([Surname]%20EQUALS%20Williams)&Start=1&SearchOrder=4

    If I query the white pages website above it returns all the listings with the surname Williams.

    Is there any thing I can do to that address to return all the listings for Williams and for example Williamson and Williamstone etc.?

    The same source used to allow this but they changed the query screen so you had to visit their sponsor and now you have to put in the whole name exactly which screws me cause I can't spell.

    Thanks in advance.
     
  2. Wes
    macrumors 68020

    Wes

    #2
    Just a stab in the dark:
    Code:
    http://www.domain.com/80256C0D005D32A8/WhiteContactDetails?SearchView&Query=([Surname]%20CONTAINS%20[B]Williams[/B])&Start=1&SearchOrder=4
    
    http://www.domain.com/80256C0D005D32A8/WhiteContactDetails?SearchView&Query=([Surname]%20EQUALS%20[B]Williams*[/B])&Start=1&SearchOrder=4
    
    Not sure if either of those would work, but worth a try.
     
  3. macrumors member

    #3
    It's been awhile since i touched SQL but 'LIKE' might work also (that might just be Oracle though).
     
  4. mpw
    Guest

    #4
    Cheers tried both and neither do what I want although both do work at giving records with Williams just in different orders and Williams* gives one extra record.
     
  5. mpw
    Guest

    #5
    Same again it works but displays the same info.

    Another thing the results are limited to 100 records. I see the 'Start=' but nowhere that would limit the number of records, any ideas?

    I also note that the error page I get states a full name is required for privacy reasons so that might just be that, fair enough.
     
  6. macrumors 601

    #6
    This isn't SQL here. This is going straight to the web server code. They can hardcode the limit and how the query works, so you may have to deal with what they give you.
     

Share This Page