I have gotten as far as I can with the coding, I am trying to run an automated
search on google for stock information, once I run the search i want to p
of the information into a database, here's what I've put together so far, I'm
brand new at CFMX so the detail you can provide the better.

<html>
<head>
<title>Untitled Doent</title>
<meta http-equiv="Content-Type" content="text/html; cht=iso-8859-1">
</head>


<cfinvoke
webservice="http://api.google.com/GoogleSearch.wsdl"
method="doGoogleSearch"
returnvariable="aGoogleSearchResult">
<cfinvokeargument name="key" value="JDnnCARQFHLYkutHzEbGExqZWyadiqnM"/>
<cfinvokeargument name="q" value="TSX:AC"/>
<cfinvokeargument name="start" value="0"/>
<cfinvokeargument name="maxResults" value="9"/>
<cfinvokeargument name="filter" value="false"/>
<cfinvokeargument name="restrict" value="false"/>
<cfinvokeargument name="safeSearch" value="false"/>
<cfinvokeargument name="lr" value="lang_en"/>
<cfinvokeargument name="ie" value="latin2"/>
<cfinvokeargument name="oe" value="latin2"/>

</cfinvoke>

<cfset stock_symbol = "TSX:AC">
<cfset hits = aGoogleSearchResult.estimatedTotalResultsCount>
<cfset hitdate = dateformat(now(),'mm/dd/yy')>
<cfset results = aGoogleSearchResult.getResultElements()>
<cfset curResult = structNew()>
<cfset curResult.url = results.getURL()>
<cfset curResult.title = results.getTitle()>
<cfset curResult.summary = results.getSummary()>
<cfset curResult.snippet = results.getSnippet()>
<cfset curResult.hostname = results.getHostName()>
<cfset curResult.cachedsize = results.getCachedSize()>

<cfquery name="insertStocks" datasource="aircanada">
insert into aircanada(stock_symbol,hits,hitdate,URL)
values('#stock_symbol#',#hits#,'#hitdate#','#URL#' )


</cfquery>



<body>
<strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Total
number
of hits: </font></strong> <font color="#990000" size="2" face="Verdana, Arial,
Helvetica,
sans-serif"><cfoutput>#aGoogleSearchResult.estimatedTot alResultsCount#</cfoutput
></font>
</body>
</html>