Google API in ColdFusion

Posted on 2011-10-06
Last Modified: 2012-05-12
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,
Question by:hefterr
    LVL 15

    Expert Comment

    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:

    Easy to use and gives you the full search listing back.
    LVL 1

    Author Comment

    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.

    LVL 1

    Author Comment

    Is there an interface with Yahoo that i could use?  I found this link :

    What do you think?
    LVL 1

    Accepted Solution

    Hi Tomarse111,
    I don't think it's possible to do what i wish.  Do you mind if I just close out this question.

     Your reference was how to integrate google into your site so that static pages could be searched via a "site search form field.  This is not what I was looking for.

    LVL 1

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Title # Comments Views Activity
    NotAlone Challenge 20 65
    countClumps  challenge 10 66
    hasOne  challenge 59 62
    WMI, model #, retrieving information 10 49
    CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
    This is an explanation of a simple data model to help parse a JSON feed
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now