CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

Apologies if this has been asked and answered countless times, but... We're about to upgrade our infrastructure from CF7 to 8, and are trying to determine if the Enterprise edition is worth the cost. We've heard (mostly from our hosting company) that CF8 Enterprise running on a 64-bit server

Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

Thanks for the reply. So it's really the case that there's no way to access an Excel doc via the 64-bit edition? That could be a bit of a stumbling block. The ability to run 64 bit is sometimes worth the cost... More to do with hardware than CF :) For one thing you can run a huge heap on 64x

Get time zone for address?

Hi, Apologies if this is answered elsewhere. Does anybody know of a product or service that can return a time zone for a given address? For example, I'd like to pass in 1600 Pennsylvania Avenue, Washington, DC 20500, and get back Eastern or something like that. Thanks in advance, Ben

Re: Get time zone for address?

Both interesting options, though the google maps .kml file doesn't appear to contain any time zone data. I did a little more googling, and found some web services that will return a time zone for a given zip code. That's more of what I'm after. Here are a few I found. No idea if any are

Re: cfqueryparam, cached execution plans, and changing table structure

Hi Mark, In this particular case, the query used the * command. I know it's a no-no. however, when I ran my simple test to try and re-create on my laptop, I tried both with the * command and by specifying fieldnames. I couldn't recreate in either case. I'll keep at it. Ben Does your

cfqueryparam, cached execution plans, and changing table structure

We hit a problem with morning relating to cfqueryparam. A query using cfqueryparam referenced a table whose structure had been changed (we added a column). It appears the execution plan had been cached, and either CF7 or SQL Server 2000 wasn't smart enough to figure out that the table had

Re: cfqueryparam, cached execution plans, and changing table structure

Tom, Thanks for the reply, but I don't think that would solve the problem. The issue is that the execution plan itself is cached, and so it doesn't know about the underlying database changes. If I run a different query, it won't affect this execution plan. And even if it did, that's still

Re: cfqueryparam, cached execution plans, and changing table structure

Thanks, Jochem, for the reply. I glanced at that call just briefly; does it clear *all* stored execution plans, or just a specified one? It seems like the only way it would be useful in this context is if it cleared them all, since we have no way of knowing which plans are cached. A larger

Re: cfqueryparam, cached execution plans, and changing table structure

Thanks, Jochem, for the reply. I glanced at that call just briefly; does it clear *all* stored execution plans, or just a specified one? It seems like the only way it would be useful in this context is if it cleared them all, since we have no way of knowing which plans are cached. I

Re: cfqueryparam, cached execution plans, and changing table structure

God, so annoying. So, let me see if I really have this straight. Let's pretend I have a table called user that has two columns: firstname and email. I write a query like this (shortened syntax): cfquery SELECT firstname FROM user WHERE email = cfqueryparam cfsqltype=varchar

Re: cfqueryparam, cached execution plans, and changing table structure

), but I'll try to get it to happen again. Thanks again, Ben Ben Mueller wrote: cfquery SELECT firstname FROM user WHERE email = cfqueryparam cfsqltype=varchar value=#form. email# /cfquery MS SQL Server caches the execution plan. Then, I add a lastname column to the user

SQL Server connection best practice?

Hi all, I'm not even sure how to pose this question, so I did a poor job of searching the archives, if this question has already been answered. We're running CFMX7 and SQL Server 2000 in Windows2003 Server. I know there are a variety of ways that one can get CF to talk to a SQL Server box:

Re: SQL Server connection best practice?

Okay, that's kind of what I thought. I think the SequeLink thing is what I was thinking of wrt to the ODBC driver. Thanks, Dave. ColdFusion only supports JDBC, so you'll be using JDBC. You can either use a pure Java JDBC driver, or you can connect to ODBC datasources using SequeLink as a JDBC

Solutions for cfqueryparam/cachedwithin problem?

Hi all, Given that you can't use cfqp and cachedwithin at the same time (serious bummer), are there best practices for when you want to do both? All of the solutions I can think of (application/server caching, some sort of custom cachedwithin thing, etc) just seem annoying. Also, is there

Re: Solutions for cfqueryparam/cachedwithin problem?

This has been fixed in CF 8. Awesome. Thanks, all. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive:

cfqueryparam and dynamically-created SQL

, Ben Mueller ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm

Re: cfqueryparam and dynamically-created SQL

Thanks, all, for your replies. So, a follow-up question: will SQL create multiple prepared statements for each condition? If so, that's great. My fear is that it will only create 1 prepared statement for each cfquery block, so if the current statement doesn't match the previous statement,

Re: cfqueryparam and dynamically-created SQL

Try not to think about queryparam as a performance benefit so much, The performance increase isn't really anything that massive, think about it from a security perspective. Without cfqueryparam people will add, edit and remove content from your database, gain access to secure sections of your

Re: cfqueryparam and dynamically-created SQL

Oh my goodness me, still wrong! Should be: SELECT email FROM user u WHERE country = cfqueryparam cfsqltype=cf_sql_varchar value=#somecountry# AND ( Len('cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#') = 0 OR state = cfqueryparam cfsqltype=cf_sql_varchar value=#somestate#) Phew!

cfqueryparam and dynamically-created SQL

would have otherwise gained from using cfqueryparam? If so, I would guess this is a common issue people run into. Is there a best practice for handling this kind of situation? Thanks in advance, Ben Mueller ~| Get the answers you

OS X Spotlight plugin for CF files?

It would appear that, by default, OS X Spotlight will not index .cfm files, and that in order to get Spotlight to index them, one has to somehow install a plugin. Have people been able to get Spotlight to search CFM files? If so, are there instructions on the web anywhere? I've spent some

Re: CF8 configuration issues in a VM environment

Hope I'm not just spreading FUD, but I suspect that's not possible. On W2K3, the only way to get a mapped drive letter is to run CF under a login session - i.e., login to the server, map the drive, then start CF as a console app. I'd presume XP would be the same. Jaime Metcher Thanks to both

Re: MS SQL 2005 vs CFMX 7.02Ent

Will, I'm struggling against the very same thing at present. Did you ever figure out the problem? Ok, we recently switched to running MS SQL 2005 servers in an Active/Passive cluster on Win2003 (64Bit). While we were testing we had no issues with DB access. After migrating most of our

Problem connecting CF8 to SQL2005 developer edition via JDBC

Hi all, I'm attempting to configure a development environment with IIS, CFMX8 and SQL Server 2005 developer edition, all running on top of XP SP2. The process just to get to this point has been painful enough, but now I've hit a bug that I cannot seem to get around. I was hoping somebody

Re: Problem connecting CF8 to SQL2005 developer edition via JDBC

Okay, after all that, I just answered my own question. I had created a SQL user, and set the default database on that SQL user to be the one I wanted. However, I had *not* specifically added that user to the list of users on that database. I don't recall needing to do that in SQL Server

Re: MS SQL 2005 vs CFMX 7.02Ent

I don't know if it's specifically relevant or not to this thread, but I solved my issue. As I described in a different thread on the subject, I had created a SQL user and had declared a specific database as the default database in SQL Server 2005. However, I needed to specifically add that

CF8 configuration issues in a VM environment

I'm running CF8 developer edition on XP in a VMWare virtual machine on top of OS X Tiger. My goal is to use the XP virtual machine as my development enviroment for IIS,CF8 and SQL Server, and ideally have all cf files in a shared directory, so I can access and edit those files from within OS

Re: CF8 configuration issues in a VM environment

Replying to my own thread... I've bailed on trying to get IIS and CF on XP to recognize files that live on the OS X side and are accessed via shares; at least for now. Instead, the home directory for all my CF files will be on the XP box, and I'll share those folders and then read the shares

Re: CF8 configuration issues in a VM environment

Ian, I bet you're absolutely right, and I should have thought of that myself. I'll test your theory over the weekend. Thanks very much for the advice. Could this be a permission thing? I know to do something similar to what you are describing with multiple computers on a network rather then

Re: CF8 configuration issues in a VM environment

Ian, I had a chance to test, and yes indeed, it was a permissions problem. Once I set the user on the CF service to one that had broader privileges (in this case, admin privileges), it worked just fine. One wrinkle: when I added an additional custom tags directory mapping, the CF

Re: Is cfqueryparam worth it?

Correct, I meant val(), not int() the nice thing about this is that if URL.userID isn't an integer, int() returns 0 Are you sure you're using the function int() ? I tried, and if the argument is not a number, the function does not return 0, but throw an error. And if the parameter is not an

Re: Is cfqueryparam worth it?

I think this has been asked answered, but I want to be clear on something about cfqueryparam. All of the examples in this thread show cfqueryparam being used in a WHERE clause, and I understand the benefits of doing that now. Will I get the same benefit if I use them on an INSERT statement,

Re: Is cfqueryparam worth it?

Thanks, Dave. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive:

Re: Is cfqueryparam worth it?

Mike, Thanks for the response. But the question is this: what benefits will I get from saying this: cfqueryparam cfsqltype=cf_sql_integer value=#val(url.userid)# over just this: #val(url.userid)# Am I going to see a significant performance increase? For the sake of argument, pretend that

Is cfqueryparam worth it?

I'm trying to determine if cfqueryparam is really worth using. For data validation, we tend to do something like this: SELECT username FROM user where userID = #int(URL.userID)# the nice thing about this is that if URL.userID isn't an integer, int() returns 0, and the query executes and

Re: Is cfqueryparam worth it?

Okay, now I need to do some homework. Are there resources anywhere that can help tell me what queries would benefit from such things? My knowledge of SQL is decent, but isn't quite *that* deep. I would think all queries would benefit from that. Ben Am I going to see a significant

Re: Is cfqueryparam worth it?

Dave, thanks for the reply. I won't bore you with details, but suffice it to say that we prefer getting empty recordsets back in some cases because it makes our overall error handling and application flow better--granted, perhaps to the detriment of application performance. However, for us

Re: Is cfqueryparam worth it?

All, Thanks so much. I think I'm sold, especially if performance benefits are really as much as double, by and large. As far as why we want empty recordsets returned, 99.9% of the time, actual data is returned from these queries, and so the .1% that a bogus value is passed in, we find that

Re: Is cfqueryparam worth it?

-But-Apparently-Still-Ignored Dan Vega http://www.danvega.org/blog/ On 8/10/07, Ben Mueller [EMAIL PROTECTED] wrote: Mike, Thanks for the response. But the question is this: what benefits will I get from saying this: cfqueryparam cfsqltype=cf_sql_integer value=#val(url.userid

Manually re-point CFMX to updated JVM

? Perhaps my changing an XML file somewhere? Thanks in advance, Ben Mueller ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive

Re: Manually re-point CFMX to updated JVM

use the web-based administrator to re-point CFMX to the right JVM. Is there a way to do this manually? Perhaps my changing an XML file somewhere? Thanks in advance, Ben Mueller ~| ColdFusion MX7 by Adobe® Dyncamically

Re: Daylight Savings Time Change (Slightly OT, but relevant)

Sun's website appears to have 1.4.2_13 as the latest. Are we safe installing that version, or should we stick to 1.4.2_11? We're running CFMX 7. Our hosting company said we should install 1.4.2_11, but I've also heard that we should always install the latest, so I'm not sure quite what to

Re: Daylight Savings Time Change (Slightly OT, but relevant)

That's pretty much the answer I was looking for. Thanks, Eric. Ben Adobe wont support you if you install past 1.4.2_11 so if you dont have support your fine Eric On 3/13/07, Ben Mueller [EMAIL PROTECTED] wrote: ~| Create

Create a webservice that returns a structure, to be consumed by .NET

a querystring. That should suit my needs for now, but if I ever need to return more complex data than just string data, it would be nice to have this problem solved. Thanks in advance, Ben Mueller ~| Upgrade to Adobe ColdFusion

Re: Create a webservice that returns a structure, to be consumed by .NET

Rick, Thank you so much for the reply. You may have just saved me from a week of banging my head against my desk. So, a question: when you convert the structure to an array, does that mean that the caller then needs to know which return variable is in each position of the array? So, they'd

Re: Create a webservice that returns a structure, to be consumed by .NET

Thanks for the reply. I don't know anything about that UDF, but I don't think I want to go that route, simply because XML processing can be slow, and if I have to convert every struct to an XML format prior to handing it off to the web service engine, that's probably more of a performance hit

Re: Create a webservice that returns a structure, to be consumed by .NET

I have to correct myself. Of course, Mik, I can convert the structure to XML, which is then passed as a string to the remote server. That string would then have to be re-serialized to an XML doc before they can do anything with it. I'm investigating whether this makes sense. Thanks for the

Re: Create a webservice that returns a structure, to be consumed by .NET

After a bit of reflection, I'm taking both suggestions. Per Rick's suggestion, I'm creating a wrapper function that just calls the real function. The wrapper is the webservice version of the function, and takes all the real function arguments, and an additional returnformat argument. This

Re: Text encoding

that can parse through a block of text, find the odd characters, and at the very least, convert it to it's character code equivalent. Unless there's a better way of handling this for RSS in general. Thanks again, Ben Mueller Yes, a 'why' may uncover a better solution. Most people usually want to do

Text encoding

Do any functions exist that will take an arbitrary string of text and convert all the non-standard characters into their character code equivalents? For example, ü (u with an umlaut) with uuml;. I know that ASC() will do this with a single character, but I need to be able to do it on an

jrun-iis6-wildcard.dll really is required?

, that would suggest one of two things: 1) the wildcard extension *is* required for standard page execution; 2) something on our environment is not configured properly. Does anybody know which of those two possibilities is the right one? Thanks, Ben Mueller

Re: Don't wait for webservice?

worried about 6.0 when you're running 6.1 isn't really comparing apples to apples. Even green ones. ;) Laterz, J On 6/20/05, Ben Mueller [EMAIL PROTECTED] wrote: Thanks for the tip, but the following line has scared me off, given that we're running 6.1: Note for CFMX 6.0 users

Re: Don't wait for webservice?

server to wait for the remote server to complete the action. I just want my local server to send the command and then move on. Is this sort of thing possible? And if so, is it considered an okay idea? Any help is appreciated. Ben Mueller

Don't wait for webservice?

, is it considered an okay idea? Any help is appreciated. Ben Mueller ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http

Re: CFC's and limiting DB queries

You can search the cf-talk reposting on google groups for that post. On Jun 11, 2005, at 10:08 PM, Will Tomlinson wrote: Does someone have the link to the previous thread where Sean explained this? I can't find it and was paying scant attention when it was first posted. Would come in

cfcomponent/function inheritence issue?

. That is a surprise to me. Any help is appreciated. Thanks in advance, Ben Mueller ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm

setting session vars to database field values

I'm pretty sure that you don't need the evaluate in the first part of your cfset statement. cfset evaluate('session.#column_name#') = evaluate('project_retrieval.#column_name#') The evaluate statement is going to try to return a value, but you don't have a value for session.#column_name#

RE: cfcomponent/function inheritence issue?

Kerry, Thanks for your help. You're certainly right about the duplicate function...and of course I should have known that already. But I'm a little confused about your statement that I shouldn't do this: cfif NOT isDefined(mystruct)cfset this.init()/cfif I could call any function in my

RE: cfcomponent/function inheritence issue?

Thanks again for the suggestions. Last question, I swear: why do you not like using the cfscript tag at the top of your components? That seems to be the cleanest solution, since you don't have to explicitly call the init function outside of the component. Is there a performance hit to this

RE: cfcomponent/function inheritance issue?

. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning . -Original Message- . From: Ben Mueller [mailto:[EMAIL PROTECTED] . Sent: Friday, May 27, 2005 8:27 AM

Nest query inside structure in CFMX web service?

building. The web service is to be consumed by CFMX. I thought I had it working at one point, but now I get an ugly error that says the QueryBean cannot be deserialized. So, now I'm wondering if I imagined my initial success. Is what I want to do legal? Thanks in advance, Ben Mueller

Nest query inside structure in CFMX web service?

if I imagined my initial success. Is what I want to do legal? Thanks in advance, Ben Mueller ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent

RE: Error with cfargument type=numeric order?

Hi Tom, First off, thanks for your detailed response. Hopefully, I'm catching you before you leave on vacation. My comments inline: Hi Ben, Looks like cfinvoke should be avoided when calling web services. This is absolutely not true. I tried your example on CFMX 7 and was unable to

RE: Error with cfargument type=numeric order?

Tom, I did as you suggested, and things seem to be working as I would have expected. I can re-order web service arguments, and I don't get errors. Also, when I refresh my web services within the CF Administrator, the .class files update. So, that's a good sign. I'll keep an eye on it, and

Error with cfargument type=numeric order?

in a particular order that I just don't know about. Any help is appreciated. Thanks in advance, Ben Mueller Sr. Software Engineer Cognitive Arts ~| Logware (www.logware.us): a new and convenient web-based time tracking

Re: Error with cfargument type=numeric order?

can i use createobject when calling it as a webservice? i didn't think so. I suspect this is an issue with web services in general, because I've seen similar problems with services provided by BlueDragon. I've never come across issues when calling methods off of a createObject() call,

RE: Error with cfargument type=numeric order?

Thanks for everybody's help. Using createobject did, in fact, solve the problem. Looks like cfinvoke should be avoided when calling web services. For anybody else who may be facing the same problem and, like me, hadn't used create object before, here's a code sample: cfscript obj =

cfcomponent state persistence

the object still only last for that one page request? I assume if I call it locally that I would have an easier time setting the object to a session variable (even if that's still a bad practice), right? Thanks in advance, and be gentle. (-; Ben Mueller Sr. Software Engineer Cognitive Arts

RE: cfcomponent state persistence

Great! Thanks for the help! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message:

Password-protecting CFMX web services

that missing piece is. Any help is appreciated. Thanks, Ben Mueller Sr. Software Engineer Cognitive Arts ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners

RE: Password-protecting CFMX web services

Thanks for the help. I admit I still don't completely understand the username/password fields in the CF Admin--I *am* invoking this test web service from another CF installation. However, I don't want to waste anybody's time teaching the basics to me. Anyway, I sort of suspected that the way

RE: Password-protecting CFMX web services

Thanks again. I guess I thought it was something more complicated than that. These fields are only relevant if the web service to which you're connecting is using web server authentication, which you'd configure in your web server software (IIS, Apache) rather than within CF.

Trouble with web services, complex return objects in 6.1

test because AxisFault faultCode:, and then goes on to say something about no such operation 'getMessage'. I've searched the web for answers, and all I've found so far are a bunch of other people who seem to have the same problem, but no solutions. Thanks in advance for any help, Ben Mueller Sr

Trouble with web services, complex return objects in 6.1

I think I just answered my own question, but I have no idea why this is happening. It looks like the configuration of the web service is cached within CFMX (I guess), so that if I change the configuration of the web service, those changes are not re-compiled or picked up by the calling page.

RE: Trouble with web services, complex return objects in 6.1

Oh God, thank you so much. I would have beaten my head against a wall for ages trying to figure that one out. I knew I had to be doing something stupid. So that begs the question: what do people do when they develop web services for CFMX? Do they just have that page of the administrator

Re: CFFILE slow. Is there a good replacement?

Thanks again for the help. I did some experimenting. You can't just check for the existence of the output file, since Xcopy creates that file right away (so it can stream output data into it). So, I need to test for the presence of the file *and* some particular string of text within the

Re: CFFILE slow. Is there a good replacement?

So, you write file manipulation in PERL, then reference those scripts from using cfexecute? One of the reasons CF is so slow is its implementation ontop of java. Java is not wildely fast with system IO, couple this with Coldfusions implelentation of cffile and you get a slow file IO. We do all

CFFILE slow. Is there a good replacement?

? I am sort of loathe to install additional software on our servers, as it makes application portability a little more tedious, but I'm not completely against it. Our application runs on Windows 2000 Advanced Server. Any help would be greatly appreciated. Thanks, Ben Mueller

Re: CFFILE slow. Is there a good replacement?

an operation is done, I think that has to do with not specifying a timeout= attribute on your cfexecute tag. If you don't add it, your process will run in another thread and you'll never know when it's done. -nathan strutz http://www.dopefly.com/ Ben Mueller wrote

Re: problem with parsexml

Numbers it is!!! Yes, or make a mapping with a dtd or schema. I often just use the number format. I don't think you can define entities within a schema. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction

problem with parsexml

. Ben Mueller Sr. Software Engineer Cognitive Arts ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http

Re: problem with parsexml

Thanks for the prompt reply. I was sort of afraid that was the answer. So...uh...I'm sure many people want to use those special characters within XML documents, divorced of CF. What's the standard practice, then? Do people just use the numeric reference then? The first three are valid

looking for a good XML editor

What are the best XML editors out there? I've heard of Arbortext, but haven't used it at all. Any that work particularly well with Cold Fusion? Any input would be appreciated. -- Archives:

RE: some high trafic cf websites please

Actually, I just heard eBay is running on FileMaker Pro and its Web Companion plug-in. Just 10 machines in a round-robin DNS, believe it or not! (they were running on 5, but they had those well-publicized service outtages a while back, so they put through a 2nd round of VC to beef up