Webmaster Forum / ColdFusion / Advanced Techniques / April 2005

Hi
I have a database that has amongst others the fields "Price" and "Quantity".
What i need to do is multiply the "Price" by the "Quantity" for each record
and then add them all up to give a "Subtotal"

Does anyone know of a way to capture debugging information? I need to be able to manipulate this data in my code. Any help would be greatly appreciated.
Thanks,
Sarah

I am getting this error when I try and run this query update.
Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error in UPDATE statement.  

Greeting!
I have a form that submit MULTIPLE list from the <select> tag. When the list
had send to action page, I need to run <cfquery> for retrieve data that match
the contents inside the list.

I have been over and over this.  I am trying to update a simple table.  I took
this script from the same server using a different DSN.  I keep getting this
error.
Error Executing Database Query.  

I have a website running on an admittedly over-taxed, out-dated,
in-bad-bad-BAD-need-of-replacing server.  The server handles its own under
normal load, but running a script that loops over a whopping 22 Verity
collections (one of which has approx. 16,000 documents) to reindex ...

Help. I have an e-commerce site where the receipt I need to email out must
contain the returned information of two queries. I know a <cfmail> tag can't
have a <cfoutput query=****> tag residing in it. And all the information I've
been finding gives me information on sending the ...

I've searched the 'net and the forums for the answer to this question, but
cannot find a solution.
All use activity is logged in a database. I am using J2EE session variables
and need to log when a session expires after a browser closes. The application

Hello,  I have experienced several occasions where I make a change to the body
of a component and then when I run the page, the changes are not reflected.  I
have to go so far as to restart my computer in order to see the changes.  Does
Cold Fusion cache cfComponent code?  ...

I've got a CF MX 6.1 Server with 2 sites on it.  However, no matter what domain
I type in the same site comes up.  I am aware that there are some changes that
can be made to CF Server confguration that will rememdy this problem.  I am
unable to find the documentation on this.

For a shopping cart-enable site, what is the best way to store and transfer a
user's session data from non-secure to secure?  The secure section will contain
the form for them to enter their credit card information as well as submit to
the 3rd party payment gateway and back again ...

I have a problem with user right click on the url link, I was able to hide the
real url (dislay a fake url) on the status bar when user 'mouse over' an url
link, but cannot hide it when users 'right click' on the link.
is there a solution or it cannot be done at all?

Hi, I'm trying to consume a web service that uses a custom data type for the
input params.
The service is here: http://www.webservicex.net/CurrencyConvertor.asmx?wsdl
Here is the code that I'm using to invoke it:

Hi, we are currently working on a project where we need to call some Siebel
CRMOnDemand WebServices. When we use the cfinvoke tag to call for a simple
webservice (time.wsdl), we get the following error :   Could not generate stub
objects for web service invocation.   Name:

Im hoping someone can help, as im going out of my mind here!  Ive managed to
invoke a flight status web service into my application, however, im having a
little trouble with the times of flights etc.  Basically, upon invokin the web
service, it returns a complex type;