Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 4, 2006, 07:28 AM   #1
mpw
Guest
 
Join Date: Jun 2004
Help with a Database Query (I Think)

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.
mpw is offline   0 Reply With Quote
Old Jan 4, 2006, 08:22 AM   #2
Wes
macrumors 68020
 
Wes's Avatar
 
Join Date: Jun 2001
Location: London
Send a message via ICQ to Wes Send a message via AIM to Wes Send a message via MSN to Wes Send a message via Yahoo to Wes
Just a stab in the dark:
Code:
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.
Wes is offline   0 Reply With Quote
Old Jan 4, 2006, 09:20 AM   #3
sakasune
macrumors member
 
Join Date: Mar 2004
It's been awhile since i touched SQL but 'LIKE' might work also (that might just be Oracle though).
sakasune is offline   0 Reply With Quote
Old Jan 4, 2006, 10:08 AM   #4
mpw
Thread Starter
Guest
 
Join Date: Jun 2004
Quote:
Originally Posted by Wes
Just a stab in the dark:
Code:
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 is offline   0 Reply With Quote
Old Jan 4, 2006, 11:24 AM   #5
mpw
Thread Starter
Guest
 
Join Date: Jun 2004
Quote:
Originally Posted by sakasune
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.
mpw is offline   0 Reply With Quote
Old Jan 4, 2006, 04:42 PM   #6
belvdr
macrumors 68040
 
Join Date: Aug 2005
Quote:
Originally Posted by sakasune
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.
belvdr is offline   0 Reply With Quote

Reply
MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Help with port forwarding for Security software? PPFee Mac Applications and Mac App Store 1 Dec 11, 2011 03:34 PM
Need help with a simple question (I think) motownflip MacBook Pro 4 Jan 9, 2011 04:38 PM
help with excel for mac 2008 damiang72 Mac Applications and Mac App Store 0 Nov 14, 2010 06:19 AM
Help with my Parents PC. (I told them to buy a Mac, but no they don't listen) Hummer Community Discussion 15 Apr 15, 2007 12:14 PM
Help with entourage database gear02 Mac Applications and Mac App Store 1 Aug 1, 2006 05:05 PM


All times are GMT -5. The time now is 09:38 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

Privacy / DMCA contact / Affiliate and FTC Disclosure
Copyright 2002-2013, MacRumors.com, LLC