Webmaster Forum / ColdFusion / Advanced Techniques / October 2007

Hi all, here is some code I am using to successfully consume a web service:
[Q]<cfinvoke webservice="http://mydomain/myservice.asmx?wsdl"
    method="MyMethod"
    returnvariable="wstoken">

I would like to ask if anyone has an idea why am I getting a
"Connection Failure: Status code unavailable" error  when calling a
web service via a cfhttp get.  May I know what could be the reason the
error?  We have confirmed that the web service was available during

Hi i have a SQL database with a login table
i am using the username as the email address, but when the email is
name.surname.com.edu.net.au
my login script throws back username not found

How do i achieve this ??
<cftransaction>
     <cfquery datasource="ORACLE">...</cfquery>
     <cfquery datasource="DB2">...</cfquery>

I have got an application.cfc. Wiyh a onapplicationstart defining the
application.DNS.
But when I use the Application.DNS in a cfc located in a subdirectory it fails
because it can't find any application.DNS variables.

need some help.  I have a field in a table that I use to dynamically build a
src for <a href> (let's call it "link_var")  What is retained in the link_var
field is a string to append to a url links together variables.  An example of  
a db entry would be "ID=#ID#&test=#test#"   In ...

I have a list of properties that is very large on Sundays. Normally it works
fine Monday-Saturday. The larger listing (54mg and 65,000 listings are
causing a  java.lang.OutOfMemoryError: GC overhead limit exceeded.
What I would like to do is split the list in half and do it in 2 ...

I don't think that answer is one of the available types for a cfargument tag.  The cfml reference manual will tell you what the acceptable types are.  If you don't have one, the internet does.

I have 7 flat text files. Can I use cfhttp to turn each of them into a query
and then UNION then into one useable query?

I am trying to grab the files names that are in the database and then loop
over that list to use cfhttp to create queries which I then join to create
one master query to select all the distict cities from the list. I am
calling the function 'Cities'

I am trying to pull only one record per MLSNumber using DISTINCT for MySQL,
but it isn't working. What am I doing wrong? Also, is there a way to pull
the most recent record of the 2+ based on PostDate?
Select

As you can see from my past postings I am working on a reality site and it
needs to download files everyday and use them so people can search against
them for homes. There are 5 total files per day. (Residential, Vacant Land,
Condos, Photos, and MultiFamily). Monday - Saturday ...

How to I set this to a variable? It seems to have a problem with the dash in
the 'last-result'.
<cfset LastUpdated =
#Zestimate['SearchResults:searchresults'].response.results.result.zestimate.last-updated.XmlText#>

I have checkbox base on db. If user check checkbox then it has differenct cost
and if not checked then it has different cost and finally i would like to
calculate total and dispaly in text box on fly before submiting the form.  I am
not sure how it will work on fly. Please advice ...

I have a cilent who would like to give users the ability to search his entire
web site - all the records stored in all the tables in his database.  I've
created tons of searches in the past using multiple, joined tables, but is
there a better way to do this?  I have never used CF ...