Recent content by nsampson1

Hi dwhdhw instead of using where JobNo in (@jobno) in your stored proc, try using: where charindex(jobno,@jobno) > 0 that should work Neil

Someone answered my question in another forum - just thought I would post the answer incase anyone finds it useful: the trick is to delete the entry from the old list on each loop: <cfset oldlist=&quot;1,2,4,7,9,12,22,31,35&quot;> <cfset newlist=&quot;&quot;> <cfset...

Hi Anyone know how to randomize a comma delimited list in coldfusion? eg &quot;1,2,3,4,5,6,7,8,9&quot; into &quot;4,7,3,2,5,1,8,9,6&quot; thanks in advance Neil

Hi I get a location code 26 error (server too busy) whenever I try to use a cffile for uploading small gif images (10k). The error still occurs immediately after a restart of all cf services and even after a reboot of the server. My system resources are fine with 50% CPU usage and 600MB of...

there are many similar postings to this on the allaire (now macromedia) forums (go to support, then coldfusion on the macromedia site) but allaire/macromedia have been loathe to admit to any performance issues at all. many of these threads suspect that the performance issues are caused by the...

I solved this one soon after I posted the above. I allowed the CF service to interact with the desktop (setting in services control panel on NT) and gave the CFexecute a timeout value and it all works fine

I'm running an application that receives around 2000 concurrent hits at busy times. Despite all possible optimisation in the CF administrator, coldfusion still ground to a halt every couple of hours and the logs would become full of 242 errors. Although my app is still written in CF, I had to...

Hi I'm trying to use cfexecute to run a batch file at: E:\batch\batch.bat and CF is reporting an error 'windows NT error 2 occured' when trying to run the cfexecute tag. I've checked permissions on the OS but I can't think of what else the problem could be Any ideas? Neil

Hi I need to compile a piece of code that sits on a 3rd party's web page and calls a random banner image with corresponding click-through url which rotates on every page load. The list of banners and clickthroughs is pulled from an sql database on our servers. I'm using iframes to run a...

Hi I have a web application that receives around 2 bn hits per month. For every single one of these connections, the app checks for the existence of a cookie and sets one if it doesn't already exist. Due to this high load our current bandwidth usage exceeds 10MB per sec and incoming traffic...

Hi Mark I'm experiencing 232 errors right now and it's bringing our whole system down. I know it's been a while since you posted this thread but I was wondering if you came up with a solution. At one point we were getting 232 errors every 2 seconds. cfstat showed a large queue of requests and...

Hi I'm tracking user visits to a page by including a 1 pixel gif image in the page and pointing it to a .cfm tracking page like: <img src=&quot;tracking.cfm?user=#user#&quot;> In the tracking page, a query updates a counter and returns a 1 pixel gif using CFContent like this: <CFCONTENT...

Hi Can anyone confirm a rumour that Macromedia have halted the production of Spectra? I'm keen to learn and use spectra but I don't want to waste my time if it's days are numbered. thanks Neil

GunJack the banner ads appear on affiliates' websites (third parties who display banners that are tracked with our software). When a user clicks on a banner, on any of the affiliates' websites and for any merchant, our CF code checks for the existence of a cookie (ie has the user clicked on one...

Hi GunJack Although the cookie will not pass to the third party's website, we supply our third parties with a piece of hard-coded html that they insert into their landing page (ie the page I'm trying to redirect to). This script kicks off a coldfusion script at our domain which checks for the...