Questions tagged [coldfusion-8]

For issues relating to using ColdFusion, version 8.

ColdFusion is a server-side rapid application development platform, from Adobe. ColdFusion 8 new features include

  • Built in AJAX for various UI elements. This is based ext-js
  • Exchange support
  • RSS
  • ZIP files
580 questions
4
votes
2 answers

Using BETWEEN on a varchar field not a numeric field?

I am using ColdFusion 8 and SQL Server 2008 R2. I am trying to query a column of values to get rows with a value within a range. The column SHOULD be numeric, but it's not. It's setup as a varchar (by someone else). There are 100,000+ rows of data.…
Evik James
  • 10,335
  • 18
  • 71
  • 122
4
votes
1 answer

Cfqueryparam with LIKE with wildcard is slower than not using cfqueryparam

[Edit: Edited based on Leigh's suggestions I consistently have an issue with where using column like is slower than by about 30ms. column like 'abc%' Before the plan is cached, both…
J.T.
  • 2,606
  • 15
  • 31
4
votes
1 answer

how to send test request to usps test server to access ZipCodeLookup API?

i have registered myself with usps.com/webtools and get username/password. when i am sending test request to usps test server, i am getting error "Error getting USERID attribute"…
user1553658
  • 41
  • 1
  • 1
  • 5
4
votes
1 answer

CF8 and AES decrypting MySQL AES: encodings are not same

This has become more of an exercise in what am I doing wrong than mission critical, but I'd still like to see what (simple probably) mistake I'm making. I'm using mysql (5.1.x) AES_ENCRYPT to encrypt a string. I'm using CF's…
Steve
  • 2,776
  • 3
  • 25
  • 44
4
votes
1 answer

VisualVM and Coldfusion 8: why no memory sampling available?

We are trying to use VisualVM to track down some memory leakage in CF8, however, cannot get the tool to work 100%. Basically, everything comes up, except the Memory sampling. Says that the "JVM is not supported". However, all the other features…
jzimmerman2011
  • 1,806
  • 2
  • 24
  • 37
3
votes
3 answers

Fail to catch Exception

I'm using SVNKit and the only way I found out to test Authentification to the server is by using method testConnection() of class SVNRepository. The method doesn't return a boolean but throws an Exception. public abstract void testConnection() …
Francis P
  • 13,377
  • 3
  • 27
  • 51
3
votes
2 answers

How to make ARGUMENTS optional in ColdFusion 8?

I have been using ColdFusion 8 / 9 / 10 regularly. The code below works just great in CF9 and CF10. (I developed it in 9). It does NOT work in CF8 though. If you run the code below (at the bottom) in CF9 and CF10, you should get the HTML results…
Evik James
  • 10,335
  • 18
  • 71
  • 122
3
votes
3 answers

How to use cfparam for a structure in CF8?

I need to pass a structure to a method, but it will not always be defined. Is there something like this that would work? When I try this I get, the argument passed to the function is not of type…
RandyLahey
  • 979
  • 4
  • 10
  • 26
3
votes
1 answer

ColdFusion Reports

Is it possible to run reports generated by ColdFusion Report builder on CFMX7? More explicitly, is it possible to change the report generation engine in CF7 to CF8?
Tom Hubbard
  • 15,820
  • 14
  • 59
  • 86
3
votes
1 answer

ColdFusion 8 scheduler not rescheduling task

I have just done a clean install of CF8 on a Windows 2000 machine. I have a scheduled task I need to run every 15 minutes on this machine, and the machine does little else. The task is set up as normal through CF admin, but for some reason, when…
Ciaran Archer
  • 12,316
  • 9
  • 38
  • 55
3
votes
1 answer

QuerySetCell on a column with a numeric name in ColdFusion

I'm attempting the use QuerySetCell to change value of a specific column in a query object, and have been receiving this error: Column names must be valid variable names. They must start with a letter and can only include letters, numbers, and…
A.Wack
  • 478
  • 1
  • 4
  • 9
3
votes
2 answers

what is the best way to test if a struct exists before inserting it in an array?

This is about coldfusion... I have an array of structs in which I would like to get only dictinct values. What is the best way to test if a structure already exists in my array before inserting this one ? Should it be possible to test this with…
michel
  • 81
  • 1
  • 9
3
votes
2 answers

Is it possible to convert an XML string into JSON in ColdFusion Fusion 8

I'm in a situation, where i receive a query containing XML string. I'm supposed to convert it to json. I wrote a small CF Function, that traverses/parse through the XML and conveniently transforms it into a json. Now the problem is, the XML schema…
novein
  • 53
  • 1
  • 5
3
votes
3 answers

MySQL / ColdFusion 8 : sql-mode

We've been doing some testing with ColdFusion and MySQL and are a bit puzzled. We know that there are different 'sql-mode' flags you can set in the /etc/my.cnf file which will cause MySQL to behave certain ways, depending on the modes defined. We…
Mike Jr
  • 175
  • 2
  • 7
3
votes
1 answer

Why does the ColdFusion hash function return different results in these scenarios?

This is the first time I've noticed this behaviour from ColdFusion. I came across this while updating a query to use . The code runs on a ColdFusion 8 platform. I do not have reference for its behaviour outside of this…