PDA

View Full Version : Help with a Database Query (I Think)




mpw
Jan 4, 2006, 07:28 AM
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.



Wes
Jan 4, 2006, 08:22 AM
Just a stab in the dark:

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

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

Not sure if either of those would work, but worth a try.

sakasune
Jan 4, 2006, 09:20 AM
It's been awhile since i touched SQL but 'LIKE' might work also (that might just be Oracle though).

mpw
Jan 4, 2006, 10:08 AM
Just a stab in the dark:

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

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

Not sure if either of those would work, but worth a try.
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.

mpw
Jan 4, 2006, 11:24 AM
It's been awhile since i touched SQL but 'LIKE' might work also (that might just be Oracle though).
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.

belvdr
Jan 4, 2006, 04:42 PM
It's been awhile since i touched SQL but 'LIKE' might work also (that might just be Oracle though).

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.