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 - there is >no more 1.5 gig limitation on the JVM heap size. That's very important for >some applications that have reached their limit. You can also use cfthread >and fine tune the threading for other processes that used to be limited... > >We had a plan for a 2 LB server solution for a customer with a couple >million visitors a day. We moved them to a single 64 bit server (connected >to a 64 bit MSSQL server) and they haven't had a single timed out response >yet. We are moving at a leisurely pace to get the other server in the LB >since there are no longer any performance issues. > >Just remember, you can't run Jet (Access or Excel) on 64 bit. If you are >using Access or the jet driver to hit excel etc then you should reconsider. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 offers a serious performance boost over CF8 standard, but I haven't really been able to find any other sources that line up cost vs. performance in any meaningful way. We'd of course like to run Enterprise, but our business guys are likely to balk at the cost unless we have some good ammunition. Our current production environment is 2 web boxes running Windows2003, IIS and CF7 Standard. Glancing at the features of Enterprise over Standard, it's probably the case that we only really care about server monitoring and maybe high-volume email--aside from speed improvements. Another wrinkle is that we're going to move to a virtual server environment (specifically, Hosting.com's "Cloud 9" service, which runs on top of VMWare, and just sounds really cool). If anybody has any words of wisdom about that kind of environment (e.g. "it's production-ready" or "run screaming now"), it would be appreciated. Thanks in advance, Ben ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 good, nor about pricing: http://www.strikeiron.com/sample/ZipCodeInformation_v3_0/ZipCodeInfo.aspx http://www.fraudlabs.com/zipcodeworldUS.aspx http://www.webservicex.net/uszip.asmx and here's a page that consolidates some options out here: http://www.remotemethods.com/home/valueman/validati/zipcodes ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 query do "select * ..." or "select fieldname, ..."? > >We always avoid "select * ..." and that avoids lots of potential issues >with caching in CF or in the SQL server (and I think it makes for >easier-to-maintain code, even though it is more verbose). > >Thanks > Mark > >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 changed, and so the query bombed. I found an old post on it >here: > >http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B >270-3056B422E2F6FCAB > >and it seems the only solutions are to cycle the CF service or >change any query (in some minor way) to force CF to create a new >execution plan. Frankly, both of those solutions blow. We're >constantly updating our site, and if we have to cycle the CF service on >our production servers every time we make a database change, we'll >simply be forced to abandon cfqueryparam entirely. > >Somebody please tell me there's some other solution here. > >Thanks in advance, >Ben ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam, cached execution plans, and changing table structure
Now that I would *almost* understand and forgive. But we seem to have gotten the error when we added a column that was *not* referenced in the query. So, all we did was add a column--we didn't alter the query at all. Of course, I can't recreate on my laptop (running CF8 and SQL2005 locally), but I'll try to get it to happen again. Thanks again, Ben > Ben Mueller wrote: > > > > SELECT firstname > > FROM user > > WHERE email = email#> > > > > > > MS SQL Server caches the execution plan. Then, I add a "lastname" > column to the user table. I don't change the query at all. I re-hit > the query while the execution plan is cached. It breaks? > > Probably not if you add a column, only if you delete one and keep > referencing it: > > CREATE TABLE user (A, B, C) > > > > > > > > ALTER TABLE user DROP COLUMN C > > > > Jochem ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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): SELECT firstname FROM user WHERE email = MS SQL Server caches the execution plan. Then, I add a "lastname" column to the user table. I don't change the query at all. I re-hit the query while the execution plan is cached. It breaks? Thanks again. > > It sounds like the only time this is a problem is under the > following circumstance: alterations to an existing DB table where a > related execution plan is stored in memory. > > Correct. > > > > I'm mostly annoyed that this doesn't "just work". Maybe that's > unrealistic of me, but I don't think it's unreasonable of me. > > It is a MS SQL Server issue. Oracle, PostgreSQL etc. do not have this > > problem, they flush their cache on schema changes. So I agree that it > is > not unrealistic to expect that it would be handled automatically. > Jochem ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 don't know, you might evenneed one of the other DBCC FREE. > commands. Try it :) Yeah, I'll try it all right. Just was hoping you might know off the top of your head. > > A larger question is this: isn't this a huge headache for > everybody? We update our site a lot--sometimes several times a day > > If by update you mean a schema change I think you are the exception > rather then the rule. Well, it's a mix. Sometimes, we just make CF code changes, but we do make changes to our database with some regularity. It sounds like the only time this is a problem is under the following circumstance: alterations to an existing DB table where a related execution plan is stored in memory. If we create a new table, or if (by luck) no referencing execution plan isn't stored in memory, then we're okay. I'd say we make changes like that as often as a few times a week? There might be a week or so that goes by where we don't make a change like that, and then a week will come along where we make a host of such changes. Is this really the exception rather than the rule? I would think that most sites are under constant evolution, database included. I suppose I'm trying to get a sense of how the community at large deals with these issues. Do people take databases offline when making structural changes, or make a habit of cycling the SQL service (which would probably clear the cache, but I'm not sure), or do people routinely call the SQL procedure you highlighted above? I'm mostly annoyed that this doesn't "just work". Maybe that's unrealistic of me, but I don't think it's unreasonable of me. Thanks again, Ben ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 question is this: isn't this a huge headache for everybody? We update our site a lot--sometimes several times a day--and if having around means we need to add an extra step to our process of getting stuff out to our production servers, that just seems like a big pain. Maybe I'm asking for too much here, but I suppose I would expect that if a cached execution plan bombed in SQL Server, it would automatically attempt to re-compile, under the assumption that the cached plan is out of date. Thanks again, Ben > The execution plan is cached in the database so there is no way CF > could > possible know it is cached, let alone the cache needs to be flushed. > > > > and it seems the only solutions are to cycle the CF service or > change any query (in some minor way) to force CF to create a new > execution plan. > > What you need is to flush the cache in the database server. Look into > > DBCC FREEPROCCACHE and its cousins. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 not a solution I would run with. That would mean that for every database change I make, I would have to be the first one to hit the associated cached query. Our site has enough traffic that it's very likely a user would hit one of these queries before me, and would therefore see an error. Ben > If all you need to is run a query against the new table, why not just > do that > from a plain old CFML page ? > > -- > Tom Chiverton ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 changed, and so the query bombed. I found an old post on it here: http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B270-3056B422E2F6FCAB and it seems the only solutions are to cycle the CF service or change any query (in some minor way) to force CF to create a new execution plan. Frankly, both of those solutions blow. We're constantly updating our site, and if we have to cycle the CF service on our production servers every time we make a database change, we'll simply be forced to abandon cfqueryparam entirely. Somebody please tell me there's some other solution here. Thanks in advance, Ben ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 proxy of sorts. I'd strongly recommend using just JDBC. > >JDBC requires that your SQL Server be configured to listen on TCP/IP. It >doesn't support Named Pipes. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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: ODBC, JDBC, Named Pipes, and so on. I don't even pretend to know what all of that really means. The question is what's the best practice these days? I think at one point, ODBC was faster, but then JDBC was recommended, and now I'm no longer sure. This came up because I ran a query in SQL Server query analyzer that returned the result set in 0 milliseconds. however, running it using CFQUERY (debugging enabled) showed that the query took about 800ms to execute. The recordset returned is pretty big, so I'm assuming that the bulk of the 800ms is the transfer time, and that got me to thinking about the above question. Any guidance is appreciated. Thanks, Ben ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 any word as to whether this issue will ever be resolved? Thanks in advance, Ben ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam and dynamically-created SQL
>Oh my goodness me, still wrong! Should be:
>
>SELECT email
>FROM user u
>WHERE country = value=#somecountry#>
>AND ( Len('') = 0
>
> OR state = )
>
>Phew!
>
>Dom
Interesting idea, Dom. Thanks. But do you really need the quotes around the
cfqp inside the len() statement? I would think not.
Ben
~|
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/messageid:291993
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 site, steal important >information from you, names, address, credit card information and so on. > >queryparam really is important... _really_ important ... I can't stress that >enough. > >Why is it that you find it annoying? Because of the extra few moments it >takes to code? It really is worth that extra few seconds to wrap up all your >dynamic parameters, once you get in to the habbit you won't even think twice >about it. I get the fact that it's important to prevent SQL injection attacks, etc etc. While I certainly see the value of that, I must admit that I'm not sold on cfqueryparam for that reason alone. Our web application tends to check incoming data before it even gets to a SQL statement. So, while I have started using cfqp everywhere, I probably wouldn't use it for security alone. Hate me if you must. (-; I am also interested in the performance benefit, and what would annoy me is if the presence of a statement inside a block negated any performance benefit gained from cfqp. There are a few cases on our site where adding cfqp seems to have made a non-trivial difference in performance, and I would hate to think that in all other other places I use it, I may be doing more harm than good in terms of performance. (I'm only slightly annoyed by how verbose the tag is, but not enough to stop using it). Anyway, thanks all for the replies. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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, it would discard the previous one and create a new one. I have a bunch of queries that have 8 or more conditions, almost all in the WHERE clause. Obviously, the more conditions there are, the greater the likelihood that any one individual call won't match the previous one. I know cfqp is really good and all that, but this would be pretty annoying if I got no real performance benefit. > >Yes, to the extent that you are less likely to have another query with the >same prepared statement (and the same execution plan, of course) that can be >run again. Frankly, though, I wouldn't worry too much about that, since >coding around that causes all kinds of problems. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ ~| 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/messageid:291972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfqueryparam and dynamically-created SQL
Posted this yesterday, but it didn't seem to go through... I became a convert to cfqueryparam, thanks to this list, about 2 months ago. Since then, I've wondered about this kind of statement (shortened here): SELECT username FROM user WHERE lastname = AND Does the presence of the block inside the SQL negate the speed benefits I would get from using cfqueryparam? I'm kind of hoping not, but guessing yes. Thanks in advance for the advice, 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/messageid:291968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam and dynamically-created SQL
Hi all, I've become a convert to cfqueryparam after posting a question about it to this group several months back. Since then, I've started wondering about the benefits of it if there are statements in a block. For example: SELECT email FROM user u WHERE country = AND state = Does the presence of the statement inside the cfquery block negate all the performance benefits I would have otherwise gained from using ? 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 are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 time doing Google searches, but have come up empty so far. Any help is appreciated. Thanks. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 of you for the reply. I didn't try associating the mapped drive with the account associated with the CF service. However, given that the Samba-based solution seems to work fine, and people seem to speak highly of Samba's reliability, I see no reason to change it. But I might try it just to see if it'll work, given that it would simplify the setup process if I could just use the share folders that VMWare configures out of the box. Ben ~| 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-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 user to the database as well. So it was a two-step process: 1) create user account (and, optionally, assign default database); 2) specifically add that user to any database you wish to access from CF. Maybe everybody already knew that, but i don't remember needing the second step in SQL Server 2000. Hope it helps somebody. ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 2000--I thought that setting a default database was enough. So, perhaps this is new to SQL 2005, or perhaps I just don't recall doing that in SQL 2000. Anyway, I hope that helps somebody. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 else may have already run
into this.
When I attempt to connect to SQL Server via the CF administrator, I get the
following error message:
Connection verification failed for data source: trumpDBtest
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot
open database {my database} requested by the login. The login failed.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]Cannot open database {my database} requested by the login.
The login failed.
I'm not much of a DBA, and it's the first time I've ever worked with SQL Server
2005, but here's what I've managed to work through:
1. I figured out that SQL Server 2005 needs to be running in "Mixed Mode
Authentication" instead of "Windows Authentication Mode".
2. By default, SQL Server 2005 disabled connections to it via Named Pipes and
TCP/IP. I enabled both (though, I think I only really needed to enable TCP/IP).
3. I attempted to use a MS JDBC driver instead of the CF JDBC driver, but
ended up with pretty much the same error message. I followed directions at the
following URL, modifying from 2005 Express to 2005 where necessary:
http://www.fusioncube.net/?p=59
4. I downloaded the latest version of Java (1.4.2_15), and pointed CFMX8 to it
instead of the JVM that comes with CFMX8.
5. I set up a login account in SQL Server 2005 that I then invoke from the cf
administrator (I called it "cfuser"). I set the default database on that SQL
user to be the DB I wanted, and I unchecked "enforce password policy".
It certainly appears I'm actually getting to SQL Server 2005 from Cold Fusion,
and that the failure is happening once I've made the initial connection. I
read someplace that somebody with a similar problem was forced to set up an
ODBC connection, but a) I don't really know how to do that, and b) it certainly
seems like I should just be able to use the built-in JDBC drivers, dammit. (-;
Any guidance is greatly appreciated.
Thanks,
Ben
~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289217
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 databases to > the SQL 2005 Cluster we are not getting the same error a few times a > day that crashes our whole CFMX application (which is running behind a > load balancer across three CFMX servers. > > The error we see is this: (note: az_tar is a valid name of a DB) > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open > database "az_tar" requested by the login. The login failed. > Date: 09/05/2007 > Time: 06:16:08 > > The login permissions are set right and have not changed from the > previous server to this server cluster. Also, the logins work most of > the day without an issue then all of a sudden for reasons unknown to > us this error pops up across most or all the databases on this server. > > > We found a MS JDBC driver (Microsoft SQL Server 2005 JDBC Driver 1.1) > that they state "In its continued commitment to interoperability, > Microsoft provides a Java Database Connectivity (JDBC) driver for use > with SQL Server 2005." > > My questions are: > Has anyone see this issue before? > And if so, what was the problem/solution? > Has anyone tried this MS JDBC Driver and what were your results? > > Thank You, > Wil Genovese ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 administrator didn't like using the mapped drive (i.e. "Z:\customtags\"), but it seems to work well with a SMB share (i.e. "\\osx-machine\user\sites\customtags\"). Anyway, thanks again for the nudge. I probably would have torn my hair out for days over that one. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 >multiple virtual systems on the same computer, would require some >modification of from the default CF setup on windows. By default, CF >runs under a 'localsystem' account and has no access to any network >resources. I can imagine that this restrict the CF service to the local >'virtual' system locking it out of other 'networked' virtual systems. >If so, it should just be a matter of creating a user of the CF service >that has the required permissions to all the pieces. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 from the OS X side via Samba. I suspect that should work reasonably well. > 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 X. ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 X. I have IIS configured so that its home directory is a Samba share I set up on the OS X side and then can access from the PC side. I am able to browse to standard HTML documents in a browser both from the OS X side and the XP side. So, I'm fairly confident that IIS is configured properly. After getting IIS to work, I installed CF8 as a standalone install, and had it configured to run on top of all IIS websites. I am now having two problems. I have no idea if either can be solved, but I was hoping somebody may have a few pointers. Problem 1 I created a simple "index.cfm" file that contains the following code: #test# When I navigate to that URL on either the OSX or XP side, I see a CF missing page error. Why index.html would work, but index.cfm in the exact same directory would *not* work is beyond me. Problem 2 I would like to create a custom tags path mapping to either the SMB share or a mapped drive on the OS X side. However, every time I attempt that, Cold fusion shows the error "Unable to add custom tag path [mypath]". For example, "X:\customtags\", where "X:\" is a folder within a shared VMWare shared folder. I realize what I want to do is kind of convoluted, but it frankly all seems reasonably straightforward, so I'm not sure what the stumbling block is. Any pointers or advice is appreciated. Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is cfqueryparam worth it?
I think this has been asked answered, but I want to be clear on something about . All of the examples in this thread show 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, e.g.: INSERT INTO user (firstname,lastname) VALUES ( , ) I'm going to guess the simple answer is "yes", but I'm not sure if bind variables work the same with insert (or even UPDATE) statements as they would with SELECT statements. Thanks again, Ben ~| 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-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 integer, but a real number, it return the >closest integer value, >not 0, It is the purpose of the function. > >You probably meant using the val() function. > >-- >___ >REUSE CODE! Use custom tags; >See http://www.contentbox.com/claude/customtags/tagstore.cfm >(Please send any spam to this address: [EMAIL PROTECTED]) >Thanks. ~| 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-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 our app logic is much nicer if we go ahead and return the empty recordset. Given that it's such a small percentage, we're not too concerned for the speed loss. If that ends up killing us...well...you guys aren't to blame. (-; But seriously, thanks very much for the advice. Ben ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 performance increase? For >> the sake of argument, pretend that sample query I included in >> my first post is heavily hit. I'm running SQL Server 2000 >> (soon to upgrade to 2005). > >The answer will depend on whether that particular query benefits from a >generic, reusable execution plan. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! > >This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 the trade-off has been well worth it to this point. But, if the general consensus is that using will really speed up execution in most cases, then perhaps we'll start using it. In the cases where it does increase performance, does it do so because SQL bind variables are used? Thanks again, Ben >> the nice thing about this is that if "URL.userID" isn't an >> integer, int() returns 0, and the query executes and simply >> returns no records. For us, this is a far preferable method >> than what cfqueryparam would do, which is to bomb before >> executing the query. > >You'd rather run a query unnecessarily than avoid running the query? Why not >just catch the exception? > >> Then today I discovered that cfqueryparam supports bind >> variables, which theoretically will improve database >> performance. So now the question is: how much does it >> improve performance? Am I really going to notice it? > >In some cases, you'll see significant performance increases. In other cases, >you won't. In still other cases, you may see performance degradation. All >that said, I'd recommend that you use it in every case, because it will >generally provide better performance in most cases. > >> Should I really switch my queries over to something like this: >> >> SELECT username >> FROM user >> where userID = > value=#int(URL.user_id)#> > >I would do without the Int part, myself, and just catch the appropriate >exception. That's what exceptions are for! > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! > >This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is cfqueryparam worth it?
Thanks, Dan. We know about SQL injection attacks, and that's why we have things like this: #int(URL.userID)# If the value isn't an integer, then int() returns 0, and the query will not throw an exception. Preventing injection attacks isn't enough of an incentive to use cfqueryparam--at least for us--since we generally have less-verbose means of preventing them. Thanks again, Ben > Ben, > Please take a look at the following post by Ben Forta. This should > clear up > some "why" issues for you. > > http://www.forta.com/blog/index. cfm/2005/12/> 21/SQL-Injection-Attacks-Easy-To-Prevent-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: > > > > > > > > over just this: > > > > #val(url.userid)# > > > > Am I going to see a significant performance increase? For the sake > of > > argument, pretend that sample query I included in my first post is > heavily > > hit. I'm running SQL Server 2000 (soon to upgrade to 2005). > > > > > > > > > > > > > > > > >As many others have said, there is never a reason NOT to use > > >cfqueryparam. > > > > > >You can still use your trick and cfqueryparam doesn't have to > bomb: > > > > > > > > > > > >M!ke > > > > > >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 simply returns no > records. > > >For us, this is a far preferable method than what cfqueryparam > would do, > > >which is to bomb before executing the query. > > > > > >Then today I discovered that cfqueryparam supports bind variables, > which > > >theoretically will improve database performance. So now the > question > > >is: how much does it improve performance? Am I really going to > notice > > >it? Should I really switch my queries over to something like > this: > > > > > >SELECT username > > >FROM user > > >where userID = > >value=#int(URL.user_id)#> > > > > > >Any advice is appreciated. > > > > > >Thanks, > > >Ben > > > > ~| 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/messageid:285973 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is cfqueryparam worth it?
Mike, Thanks for the response. But the question is this: what benefits will I get from saying this: over just this: #val(url.userid)# Am I going to see a significant performance increase? For the sake of argument, pretend that sample query I included in my first post is heavily hit. I'm running SQL Server 2000 (soon to upgrade to 2005). >As many others have said, there is never a reason NOT to use >cfqueryparam. > >You can still use your trick and cfqueryparam doesn't have to bomb: > > > >M!ke > >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 simply returns no records. >For us, this is a far preferable method than what cfqueryparam would do, >which is to bomb before executing the query. > >Then today I discovered that cfqueryparam supports bind variables, which >theoretically will improve database performance. So now the question >is: how much does it improve performance? Am I really going to notice >it? Should I really switch my queries over to something like this: > >SELECT username >FROM user >where userID = value=#int(URL.user_id)#> > >Any advice is appreciated. > >Thanks, >Ben ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 simply returns no records. For us, this is a far preferable method than what cfqueryparam would do, which is to bomb before executing the query. Then today I discovered that cfqueryparam supports bind variables, which theoretically will improve database performance. So now the question is: how much does it improve performance? Am I really going to notice it? Should I really switch my queries over to something like this: SELECT username FROM user where userID = Any advice is appreciated. Thanks, Ben ~| 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-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Manually re-point CFMX to updated JVM
I think I found the answer. The JVM path is specified in this file: [cfroot]\runtime\bin\jvm.config > I did a very dumb thing. While upgrading to JVM 1.4.2_11, I > uninstalled JVM 1.4.2_07 before pointing CFMX to _11. Of course, my > CFMX installation is pointing to _07, so I obviously can't 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 transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Manually re-point CFMX to updated JVM
I did a very dumb thing. While upgrading to JVM 1.4.2_11, I uninstalled JVM 1.4.2_07 before pointing CFMX to _11. Of course, my CFMX installation is pointing to _07, so I obviously can't 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 ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 do. Thanks, Ben >Thanks for the info! > >Rick > >-Original Message- >From: Paul Hastings [mailto:[EMAIL PROTECTED] >Sent: Saturday, March 10, 2007 12:21 PM >To: CF-Talk >Subject: Re: Daylight Savings Time Change (Slightly OT, but relevant) > >Rick Faircloth wrote: >> the Java install that comes (for me anyway) from Sun? Just download >> and install the latest JDK from there? > >following adobe's advice on this probably is a good idea, so no, not the >latest >version (1.5/1.6) but the latest version that adobe says is ok w/cf, >1.4.2_11 or >"later" as damon the slave driver says on his blog: > >http://www.dcooper.org/blog/client/index.cfm?mode=entry&entry=287B2577-4E22- >1671-5265508349E9FEBD ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 argument can be, for now, "querystring","xml", or "struct". If the caller chooses querystring, then I return a URL encoded querystring for the results (replacing the ampersand with pipes as the outer delimiters). If the caller chooses xml, then I return xml as a string that the caller can then re-serialize into an XML document. If we have any partners that use CF, then they can get a struct back. Thanks to all for the advice. For anybody who's interested, here's my "formatreturn" code, plus one supporting function (note: this code only works on structures that have simple values--if the structure values are arrays, queries, etc, then this code bombs): ')> ")> #xmlformat(structfind(arguments.struct,key))#")> ")> ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 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 than > I'd like to take. > > But aside from that, I'm betting that wouldn't work anyway. The web > service engine *does* convert the structure into XML before shipping > it to the remote server, but the problem is that the XML format is not > one that is part of the standard web service formats (as I understand > it). I'm betting structToXml() converts the structure into a format > that also isn't part of the standard web service formats. > > I just tried your suggestion, and it does seem to work, but I think > I'll probably still avoid it. Good to know the option exists, though. > Thanks, Mik. > > > >Couldn't you just do something like this: > > > > > > > >Mik > > > > > >At 02:06 PM 3/2/2007, you wrote: >> ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 than I'd like to take. But aside from that, I'm betting that wouldn't work anyway. The web service engine *does* convert the structure into XML before shipping it to the remote server, but the problem is that the XML format is not one that is part of the standard web service formats (as I understand it). I'm betting structToXml() converts the structure into a format that also isn't part of the standard web service formats. I just tried your suggestion, and it does seem to work, but I think I'll probably still avoid it. Good to know the option exists, though. Thanks, Mik. >Couldn't you just do something like this: > > > >Mik > > >At 02:06 PM 3/2/2007, you wrote: >> ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 have to know that "errorcode" is array[1], and "errormessage" is array[2], and so on, right? If that's the case, then I probably don't want to go that route. Seems like too many chances for them to screw up (i.e. "I thought first name was array[5], not array[4]", and so on). I think I'll just serialize the data to a string. >BTW, here is an example of a function from the wrapper CFC code > > >returntype="Array" displayname="authByUsername" > hint="Verify a username and password against DB2"> > > > > > DEFAULT=""> > > > > > arguments.uname, > arguments.pword, > arguments.specificlogins, > arguments.specificgroups, > arguments.other_restrictions, > "ADVANCE/ER" > )> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Create a webservice that returns a structure, to be consumed by .NET
I know, I know, this is a bad idea, but it *seems* possible, so I want to find out just how ugly the process is. I'm writing some web services for which I'd very much like to return CF structures, since that's the most logical way for me to structure the data. Of course, I can consume these web services with Cold Fusion, but our partners are using .NET. I understand that CF structures are not converted to any web service format that can easily be consumed by .NET (or probably PHP, etc). I read on Adobe's livedocs that you can create a cfcomponent that mirrors the format of a CF structure, somehow return *that*, and then .NET will be able to interpret the structure correctly. However, the LiveDocs examples were thin at best. So, here's what I'm hoping to find: 1. Somebody who's had previous experience with this, and can tell me if this is even worth trying. 2. Some sample CF code that shows me how to structure my webservices. Ideally, I want the coding process to be as simple as possible for the callers, so if the solution requires a ton of hoop-jumping in .NET, then I'll do something else. My fallback is to just serialize the data into something like 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 MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Text encoding
Thanks for the replies. The short answer is that we've begun taking some content on our site (stored mostly in a SQL Server) and outputting RSS feeds. Some of the content is entered by end-users, and so sometimes they paste in odd characters like ü and so forth. SQL, CFMX and most modern browsers seem fine with handling those characters as they are. However, XML is not nearly so friendly with characters like that. I realized after I wrote this post that the simplest thing to do in RSS is to replace ü with u (and so on), but the issue still stands that I need some function 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 >this because they see odd characters when outputting data from their access >database because they aren?t using the Unicode driver > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 ü. I know that ASC() will do this with a single character, but I need to be able to do it on an entire string of text. Any help is appreciated. Thanks, Ben ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
jrun-iis6-wildcard.dll really is required?
Hi, I'm trying to understand the functional difference between the two extensions that are mapped from IIS to CFMX7 (on Windows 2003 Server). By default, these two are mapped (in this order): \runtime\lib\wsconfig\1\jrun_iis6_wildcard.dll \runtime\lib\wsconfig\jrun_iis6.dll My understanding from reading previous posts here is that the "jrun_iis6.dll" extension is used for standard .cfm page execution, and the wildcard extension is used by flash remoting, RDS, and anything else that may invoke CFMX without a .cfm page extensions. Given this understanding, it sounds like I should be able to remove the wildcard dll if all I want is standard .cfm pages to execute in a browser. However, that is not my experience. If I remove the wildcard mapping, then load a .cfm page in a browser, the page will "load", but no data is returned--the page is blank, as is the source. So, 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 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241220 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Don't wait for webservice?
(-; On Jun 21, 2005, at 5:47 PM, Jared Rypka-Hauer - CMG, LLC wrote: > Hey Ben, > > Don't be put off by the reference to 6.0... there's more similarity > between > 6.1 and 7 than 6 and 6.1. > > 6.0 was a freaky little animal that was deprecated almost as soon > as it was > released. So to say you're 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. The tag may or may not work under CFMX 6.0. >> The tag itself is CF version independent. However, due to >> unexplainable reasons some users have reported problems when using >> CFX_HTTP5 with CFMX 6.0. >> >> >> but maybe I'll have a look anyway. >> > > > > > -- > --- > - > Buy SQLSurveyor! > http://www.web-relevant.com/sqlsurveyor > Never make your developers open Enterprise Manager again. > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Don't wait for webservice?
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. The tag may or may not work under CFMX 6.0. The tag itself is CF version independent. However, due to unexplainable reasons some users have reported problems when using CFX_HTTP5 with CFMX 6.0. but maybe I'll have a look anyway. On Jun 19, 2005, at 10:05 PM, One User wrote: > May want to look here: > > http://www.cftagstore.com/tags/cfxhttp5.cfm > > >> I would like to use a web service to invoke a function on a remote >> server, but I explicitly *don't* want my local 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 > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Don't wait for webservice?
I would like to use a web service to invoke a function on a remote server, but I explicitly *don't* want my local 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 ~| 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://www.houseoffusion.com/lists.cfm/link=i:4:209843 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 handy for me. > > Thanks, > Will > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfcomponent/function inheritance issue?
Good to know. Thanks, Ian. > The way you are using init() it is unnecessary. You can do this in > the components pseudo constructor. > > > > > > > > > . > > > Anything that is placed between the opening and the > first will always be run. The main problem with this is > there is no way to pass arguments to the "constructor". If one needs > the constructor then, the init() function is the way to go. > > > > -- > 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 . > To: CF-Talk . > Subject: cfcomponent/function inheritence issue? . > . > I've just started learning cfcomponents as of a few days ago, and > have . > liked what I've seen so far, but I'm having what I think is an . > inheritence issue. . > . > I have a component with three functions: an init, and then two other . > functions. The init function sets a bunch of variables that I'd like > to . > have access to throughout the component. The other functions invoke > the . > init function if the init variables haven't been set yet. . > . > In each function, I'd like to return the global vars returned by the > init . > function, plus a bunch of stuff unique to each function. The trouble > is . > that the variables from the first function call end up as part of the . > overall instance data, and are then somehow getting returned in . > subsequent function calls. . > . > I'm sure it's something silly, but here's my sample code: . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > . > .. > and here's how I'm invoking it: . > . > . > . > . > . > . > . > . > . > What I would expect from the first cfdump is a structure containing > the . > "initvar" and "func1var"; and from the second cfdump a structure with . > "initvar" and "func2var". However, my second cfdump call returns . > "initvar", "func1var" and "func2var". . > . > So, it would seem that the line of code where I declare this in my > first . > function: . > . > . > . > is not only setting s to the value of mystruct, but also the other > way . > around. That is a surprise to me. . > . > Any help is appreciated. . > . > Thanks in advance, . > Ben Mueller . > . > . > . > . > . > . ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207886 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfcomponent/function inheritence issue?
Thanks again for the suggestions. Last question, I swear: why do you not like
using the 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 method, or do you
simply prefer to not have functionality buried in your components that resides
outside of the functions?
>Well, theres a lot of answers to that question, but heres two:
>
>
>Way I would do it:
>
>
> testcom = createobject("component","path.to.component");
> testcom.init();
>
>
>
>Another way, which I wouldnt do:
>
>
>
>
> init();
>
>
>
>
>
>
>
>
~|
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://www.houseoffusion.com/lists.cfm/link=i:4:207881
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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: I could call any function in my component at any time, so I have no way of guaranteeing that init has been called previously. If the above code is not advised, then how can I ensure that my init function is called? >If you do this: > > > > >Then s is not a struct, but a pointer to mystruct, so whenever you set a >property of s, you are in fact setting a property of mystruct. > > >Also, personally, theres no way i would do this: > > > > >I would do: > > > >if mystruct isnt defined, then the component hasnt been inited, which means >the code isnt right, and an error should be thrown. ~| 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://www.houseoffusion.com/lists.cfm/link=i:4:207875 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
setting session vars to database field values
I'm pretty sure that you don't need the evaluate in the first part of your
The evaluate statement is going to try to return a value, but you don't have a
value for session.#column_name# yet.
Try this instead:
There may be other issues with your code, but that's the one that stood out to
me.
>I have a database with an unknown field set. I want to take whatever
>is in the DB and make a session variable for it.
>
>
>
>
> select column_name
> from user_tab_columns
> where upper(table_name) = upper('empower_project_data')
> ORDER BY column_name
>
>
>
>SELECT *
>FROM empower_project_data
>WHERE project_id = #project_id#
>
>
>
>
>
>
>
> #column_name#
>
>
> evaluate('project_retrieval.#column_name#')>
>
>
>
>This gives an error that you can't set a value to a function, which I
>understand. I'm not sure how to set a session var where I want it to
>be the same name as the column in the database, without knowing that
>column name ahead of time.
>
>--
>Daniel Kessler
>
>Department of Public and Community Health
>University of Maryland
>Suite 2387 Valley Drive
>College Park, MD 20742-2611
>301-405-2545 Phone
>www.phi.umd.edu
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207865
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfcomponent/function inheritence issue?
I've just started learning cfcomponents as of a few days ago, and have liked what I've seen so far, but I'm having what I think is an inheritence issue. I have a component with three functions: an init, and then two other functions. The init function sets a bunch of variables that I'd like to have access to throughout the component. The other functions invoke the init function if the init variables haven't been set yet. In each function, I'd like to return the global vars returned by the init function, plus a bunch of stuff unique to each function. The trouble is that the variables from the first function call end up as part of the overall instance data, and are then somehow getting returned in subsequent function calls. I'm sure it's something silly, but here's my sample code: .and here's how I'm invoking it: What I would expect from the first cfdump is a structure containing the "initvar" and "func1var"; and from the second cfdump a structure with "initvar" and "func2var". However, my second cfdump call returns "initvar", "func1var" and "func2var". So, it would seem that the line of code where I declare this in my first function: is not only setting s to the value of mystruct, but also the other way around. 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?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207862 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Nest query inside structure in CFMX web service?
I found a solution, though I admit I'm not totally happy with it. I can serialize a query into WDDX, then add it to my structure that is returned by the web service. On the other side, I can pick up that WDDX object, and de-serialize it back into a CF query object. That seems to work, but I worry about performance issues, and I don't really like the fact that the de-serializing step is required on the other end. It makes my data a little harder to understand out of the box. > I would like to nest a query object inside of a structure that is > returned by a web service I'm 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Nest query inside structure in CFMX web service?
I would like to nest a query object inside of a structure that is returned by a web service I'm 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 if I start to see odd behavior again, I'll re-post. One question: under what circumstances will the .class files *not* be updated? Does the administrator check file dates, and only refresh if the .class and related .cfc files are out of sync, or does it re-write them no matter what? Thanks, Ben ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 should be avoided when calling web services. > >This is absolutely not true. > >I tried your example on CFMX 7 and was unable to reproduce your >behavior. I could change the CFC and the WSDL changed. I could use the >same invoke (even without refreshing the stubs!) and it worked. I >refreshed the web service and it still worked. BEN: I've got CFMX 6.1 (version 6,1,0,83762) running. I don't know if anything changed between my version and CFMX 7 > >Be aware that CF jumps through a bunch of hoops to try and match >cfinvoke arguments with the correct function arguments in the proxy >stub. The CreateObject() syntax gives you a web service object, and you >are then directly calling the proxy function that matches your >arguments. > >I see two possibilities: > >1. The proxy function you are calling is not getting changed to match >the changes in the web service. >2. The Java "skeleton" that is created from your CFC and is publishes as >a web service by CF (via the web service engine) is not getting >regenerated, so proxy object generated from the WSDL is not changing. > >One thing to check is that the WSDL for the service changes each time >you change your CFC. Do you have trusted cache turned on? If the WSDL >does change, this will eliminate #2. BEN: Trusted cache is off for me, and has always been off. Then you should make sure you are >refreshing the web service the in CF admin after verifying that the WSDL >has changed. Check out the 'stubs' directory, do the web service class >files get updated? If you continue to see the behavior after checking >these things, then we might want to drill further to see if the argument >matching code in CF needs fixing. BEN: Very interesting. I found the "stubs" directory, and found a couple of things that seem off. To preface, I'm making an assumption (perhaps incorrectly), that all folders within the "stubs" folder that start with "WS" are webservices. 1. There are 13 folders which start with "WS" in the "stubs" folder. yet I only have 3 published web services in the CF administrator--one locally on my machine, and two remote. When I was first testing web services, I connected to a bunch of public web services that I found on xmethod. Once I figured out what I needed to, I deleted the references to those web services in the CF administrator. I would expect that the related web service info in the "stubs" folder would get deleted as well. That does not seem to be the case. Perhaps this is correct behavior, but it seems wrong. 2. Tom, you appear to be right that the web service class files (and all other associated files as well) are *not* getting updated when I click the "refresh" button in the CF Admin interface, even if I make changes to my webservice (I've added a couple of functions today, for example). How odd. Regardless, I am still able to access the updated web service and all new functions using the createobject method. I haven't tried to use this morning. > >P.S. Going on vacation for a week tomorrow, so please CC me directly on >any response as I will be turning off CF-Talk. > >-- >Tom Jordahl >Macromedia Server Development ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Error with cfargument type="numeric" order?
Thanks for everybody's help. Using createobject did, in fact, solve the
problem. Looks like 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:
obj = createobject("webservice","[webservice address]");
results = obj.myfunction(argument1,argument2,argument3);
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205179
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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, however, so you might try that instead of the CFINVOKE tag. > > cheers, > barneyb ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Error with cfargument type="numeric" order?
I've hit what looks a lot like a bug in cffunction/cfargument when invoked as a
web service. I haven't tested this code in a non-webservice environment.
In short, I can produce a "Web service operation "[function name]" with
parameters {[arguments]} could not be found" error by varying the order in
which my arguments appear when an argument of type="numeric" is included.
here is my invoke call:
And here is the cffunction, invoked as the above webservice:
I can change the order of the arguments in the call until I'm blue
in the face, and everything works fine.
However, if I change the order of the arguments in the call, I can
get the error message I indicated above. Yes, I am refreshing the web service
after each change.
This breaks:
This breaks:
This breaks:
So, in short, as long as the numeric arguments are listed *first* everything
works. As soon as they aren't, the web service "can't be found".
Other interesting notes:
1. If there is only 1 numeric argument, my experience is even stranger. Just
now, I wasn't able to get the web service to function properly at all. Yet, I
have another web service that does have a single numeric incident which does
work. In that case, the argument is listed last.
2. I can have any number of arguments if they are of type "string"
3. It doesn't seem to matter if I pass the arguments in as I have shown above,
or with the argumentcollection parameter, or with the tag.
4. If I add in a type="boolean" argument, then the following appears to be
true:
a) I can have 1 numeric argument
b) the numeric argument can be listed first
c) the numeric argument can be listed second *as long as* the boolean argument
is listed first
d) any other argument ordering will produce the above error
So, I see four possibilities:
1. I've lost my mind
2. This is a genuine bug
3. The refresh feature of the CF Administrator doesn't work under some
circumstances
4. Arguments must be listed 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
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205169
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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: http://www.houseoffusion.com/lists.cfm/link=i:4:205001 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfcomponent state persistence
This is probably a *really* stupid question, but I'm going to ask it anyway... If I make a call to a , specifically as a web service, the object that it instantiates only persists for that single page request, correct? Meaning, there is no simple way to make 1 web service call to instantiate the object, and then make subsequent calls against that particular instantiation later, right? It would appear that two calls, one right after the other on a page, and calling the same remote web service, creates a new session each time on the remote server. So, I couldn't even set the object to a session scope variable if I wanted to--at least not easily. It doesn't entirely sound like any of what I suggest is a good idea to begin with, but I just need to make sure I understand this point. Also...if I invoke a cfcomponent locally (not as a web service), does 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 to go was to build authentication into the service itself, but I wasn't sure. That's the route I'll take. I haven't toyed with , so I'll avoid that for now. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Password-protecting CFMX web services
Again, sorry if this has been asked and answered, but I scoured the web and this list as best I could, and didn't find a suitable answer. I would like to apply a username and password to some web services I'm creating in CFMX 6.1. I naively assumed that either the or tag would have username/password attributes that would allow me to assign those values. I figured, hey, there's a username and password field on the cfinvoke tag that passes those values to a web service--shouldn't there be the opposite feature on the web service itself? Obviously, there is not. So then I tried assigning a username and password to my test web service within the CF Admin interface. A very annoying way to have to do it, but if it works, I can live with it. Well, imagine my surprise when I tried to invoke that web service *without* passing a username and password. I assumed the service would kick back some kind of error, but instead, it actually kicked back the data. So, that seems to suggest that the username/password field within the CF Administrator is useless. Obviously, there's something I'm missing here, but I am at a loss to figure out what 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/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204716 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 open and hit "refresh" after changing the associated code? That's fine, but seems kind of annoying. >If you look in the web services page of the CF administrator, there is a >way to refresh registered web services when they change. A web service >is automatically registered when it is used in cfinvoke. > >There is no way for CFMX to know if the WSDL on a web service has >changed, since it is generated every time it is requested by the >underlying Axis web service engine. When you changed the parameters of >your function, you changed the WSDL but the "stubs" (Java code generated >to use the service) were not regenerated, so this is why you get the >error. > >Hope that helps. > >-- >Tom Jordahl >Macromedia Server Development ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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. I saved a new .cfc file with my struct configuration, and it worked fine. Then I changed my new .cfc file, tried to reload the page, and I got the same Axis error. If I create a *new* .cfc file with the new code, then it works. if anybody has any insight into why that might be happening, I'd be glad to hear why. I thought maybe it had to do with the fact that I'm saving class files in the CF administrator, but even if I uncheck that option, I still get that funky Axis error. This sort of has the smell of a bug in CFMX, but it seems so big that they would have fixed it by now. So...it must be me. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Trouble with web services, complex return objects in 6.1
Sorry if this has been asked and answered already, but... I'm exploring web services for the first time, and have already run into a puzzler. It seems that I get a rather ugly error message if I try to return a complex object (query, structure) from my web service, whereas a simple string value returns properly. Here is my code: The web service: The invokation: http://[theurl]/helloworld.cfc?wsdl"; method="test" returnvariable="astring"> This works fine. However, if I change the web service to this: .I get a rather hideous (and unhelpful) looking error message that starts out like this: "Could not perform web service invocation "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. Software Engineer Cognitive Arts ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204350 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFILE slow. Is there a good replacement?
So, you write file manipulation in PERL, then reference those scripts from using ? >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 of our >file processing with PERL...it is fast really fast. Perl is also >comfortably stable and easy to program in. > > >Adam H ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202794 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 file itself. I didn't test Robocopy, since it does not appear to be part of the standard Windows 2000 install, and therefore I'd like to shy away from it. Of course, Xcopy may still be fundamentally buggy (e.g. fails to copy sometimes), but the following code seems to work okay. It copied 662MB of data from one folder to another on the same computer in 95 seconds. The same task using cffile and cfdirectory would probably take well over an hour. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFILE slow. Is there a good replacement?
Thanks for the advice. The "timeout" thing has me confused, though. What I really want to do is wait until the process has completed copying. Let's say that could take as much as 10 minutes (hopefully won't ever be that high, but not out of the question)--do I really set the timeout to 600? And then, if it happens to take longer than 600 seconds, what then? Presumably, the rest of the page continues to execute, but the copy is still happening. How do I trap that condition? I suppose I could do a combination of the two posts here: set a high timeout AND have xcopy/robocopy write an output file, which I could then search for some kind of "done" string. Does that sound reasonable, or am I totally off base? >I recommend robocopy. It's part of the windows toolkit or somesuch. >Microsoft makes it. It's quite fast and reliable. A good step up from xcopy. > >As for returning when 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: >> ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202674 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFFILE slow. Is there a good replacement?
Our CFMX application needs to do a lot of file manipulation (moving files to production, archive, etc). I've used the cfdirectory and cffile tags for a while to do these operations, but as we grow, those tags just don't scale terribly well. I've run a few tests where I invoked XCOPY from within a cf page, and the file operations were just blindingly fast. However, there are two apparent problems with XCOPY: 1) sometimes, for unexplained reasons, XCOPY doesn't actually copy everything I ask it to; 2) I don't see an easy way to get an "I'm done" response back from XCOPY, so I can tell my CFMX application to continue on to the next task. Of course, it's possible that I'm missing some basic information that would make either cffile faster or would make my XCOPY problems go away, but assuming I have all my ducks in a row, I'm wondering what other solutions are available to me? 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 ~| 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://www.houseoffusion.com/lists.cfm/link=i:4:202656 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 XML entities. There are only five >> built-in XML entities - the three you have, plus """ and >> "'". The second three are not, unless you've defined >> them within a DTD somewhere (which you haven't in this >> example). Even if you do define them within a DTD, I don't >> know how CF's XML parser will deal with that. > >I should add that I think you can use actual character entities using >numeric codes, although I haven't tested that with CF. So, instead of >"©" you could use "©". > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
problem with parsexml
I'm running CFMX 6.1 with the latest cumulative update from Macromedia (we installed the updater patch about a month ago). Recently, we've hit a problem with parsexml() that I cannot figure out. It seems to choke on certain entity references, but not all of them. I've got some test code to illuminate the problem: These work (just a few examples): &")> <")> >")> These bomb (again, just a few examples): ")> —")> £")> I've searched the web and have found precious little information about this. I suppose it could be related to the cumulative updater, but that somehow seems unlikely. Any help is appreciated. 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://www.houseoffusion.com/lists.cfm/link=i:4:201599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 > their hardware. 5 more iMacs!). Are you saying eBay runs on 10 iMacs? that would be pretty amazing... -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
