Link to home
Start Free TrialLog in
Avatar of hefterr
hefterrFlag for United States of America

asked on

Google API in ColdFusion

Hi,
I have a form field that I'd like to pass to Goggle (or some search engine) and get the results back using CFHTTP so I can use the results on my page (not Googles).

Does anyone know how to do this? I see many posts on integrating Google with your site but it is indexing your static pages.  This is not what i want.

To be specific, I need to seach through an Organization Name column based on what a user keys and determine if it's in our table or ask the user if it's new.  I'd like to search with the native string and if nothing is found try the "Google suggestion".

When you misspell something in a Google Search, it come back with "Showing results for xxxxxxxxxxxx".
Is ther an API where I can pass a search argument and get that "Showing results for xxxxxxxxxxxx"?

Thanks in advance,
hefterr
Avatar of Tomarse111
Tomarse111
Flag of United Kingdom of Great Britain and Northern Ireland image

Google does not allow outside HTTP access to its results; you'll get some response back that says something along the lines of "This ours, get your own".

You can however integrate Google into your site via this api:

http://www.google.co.uk/sitesearch/

Easy to use and gives you the full search listing back.
Avatar of hefterr

ASKER

Hi Tomarse111,
This integration is not what I am looking for as it it is only using data on your pages.  I ultimately need to search a data base column in a table for a "fuzzy match".  I don't think they search your databases? (we are using SQL Server 2005)

For example
Someone keys in an organization name of :
Microsift (misspelled)

I want to find Microsoft.  If you key this into most search engines, they come back with:
Showing results for microsoft

They have the "fuzzy logic" search that I'd like to use on my site.  Or have them be able to do the same against my tables?

Any other search engines?  Any ideas?

I've looked into "SQL Server Full Text Search"  but it misses typos.

hefterr
Avatar of hefterr

ASKER

Is there an interface with Yahoo that i could use?  I found this link :
http://developer.yahoo.com/coldfusion/howto-reqRestCF.html

What do you think?
ASKER CERTIFIED SOLUTION
Avatar of hefterr
hefterr
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hefterr

ASKER

My request could not be acommplished.  I had to research this myself.