Recent content by cash0

Hi, the situation is: I've got a block of code that uses a cftransaction - and inside the cftransaction tags, I have a cfinvoke. The function I call with the cfinvoke also uses cftransaction tags - so techically I have nested the cftransactions - but they are in two different functions. So put...

OK. I've finally fixed it I think. Bill, I implemented what you described above, but found that I still had a problem. After many hours of trial and error I realised that it wasn't reading more than 64k either. I don't know if it is a ColdFusion limitation or a SQL server limitation. Anyway...

I've finally fixed it I think. Initially I thought it was to do with wddx, but then I soon realized that the SQL query just was not writing more and 64000 characters. Furthermore, it didn't read more than 64k either. I don't know if it is a ColdFusion limitation or a SQL server limitation. So...

Hi, I'm having problems with the length of SQL statements. I have a string of xml that can be very long - the problem is that the xml string is getting cut off at the 64000th character when I create the SQL statement. The following is ColdFusion code. For those not familiar with ColdFusion -...

I checked that, but that is not the case. My attention has turned to the update query that places the wddx data into the database. My code looks something like: ------------ <cfwddx action=&quot;cfml2wddx&quot; input='#this.arevisions#' output=&quot;xmlrevisions&quot;> <cfquery...

I'm having trouble with truncated wddx packets. The error message is usually something like: &quot;WDDX packet parse error at line 1, column -1. End of entity not allowed; an end tag is missing.. &quot; The problem is that the wddx xml string is getting truncated. So decided I count the number...

I've decided to just use cflocation to load an error page. Probably the smarter option anyway. Cfsavecontent may not be all that practical in this instance, but I can see how it can really be useful. Thanks anyway.

Is there an equivalent ColdFusionMX command to response.clear in ASP? I have an error handler function that displays an error message when an error occurs. But, since the error is likely to occur half way through processing the page, some page output is likely to have been processed ready to be...

Thankyou

This may be easy but I'm damned it I can find a solution. I need to create a node with an attribute. Here's my code so far for creating the node: Set currentElement = objXML.documentElement Set currentElement = currentElement.selectSingleNode(&quot;/cv/Experience&quot;) Set inode =...

I got around my original problem with the invalid class sting, but I now have this extra complication of the instability. Damn. I definetly don't have the time to create COM components, or try anything too fancy. I think I'll just have to see how I go. My site won't have high loads, or...

Hi, I'm having trouble instantiating the MSXML2.FreeThreadedDOMDocument.4.0 object from asp. It claims that the class string is invalid, but my server HAS xml parser 4 on it, so it should work - shouldn't it... Any ideas?

I have an access query that I call from ASP with the following where clause: WHERE level = [CompLevel] Now, I have a drop down box in which the user can specify 'less than', 'greater than', or 'equal to' a certain value. I want to know how I can pass in < or > or = into the above WHERE clause...

Damn it! I solved my own problem before I got through typing it out. I thought I'd better post it anyway in case somebody else had the same problem. I solved it by using % instead of * in the LIKE clause.The original question is below... ------------------------------------------ Hi I've got...

Thanks. I think I'll go with the DTS option. But, will I be able to connect to the source database from another network. I've done this from inside an intranet from one database to another, but never tried it from totally different network.