Re: Outdated Adobe Performance-Tuning Info
On 9/10/08, Jamie Jackson [EMAIL PROTECTED] wrote: On 9/10/08, Mark Kruger [EMAIL PROTECTED] wrote: Also, if you are running JRUN multi-server the settings for the simultaneous threads available to JRUN is very important. It is set to 50 by default... But needs to be adjusted according to how many instances you are running and your hardware resources. Start with 5x the number of procs/cores + 10 or 15 as the starting point for JRUN, then 5x the number of procs/cores divided by the number of instances for simultaneous... That would be a starting point BTW, where *is* this setting for JRun? Found this in the CF Admin (JRun Master Request Limits). I *had* been looking around in JMC. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Outdated Adobe Performance-Tuning Info
The following articles, from early 2006, provide some guidance as to performance tuning CFMX on Windows. ColdFusion MX: Tips for performance and scalability http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18540 Windows platform-specific performance settings http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17277sliceId=2 However, they refer to outdated versions of CFMX, JVM, Windows, and IIS. Are more recent versions of these documents available? If not, can anyone comment on what guidelines, if any, have changed since then? One of the things I've noticed so far: Simultaneous Requests. The simultaneous requests setting on the Settings page of the ColdFusion Administrator has the largest impact on the scalability characteristic of an application (performance under load). This setting dictates how many threads will be used to simultaneously process incoming requests. For most applications, a good starting point for the optimal value for this setting is 3 per processor--a dual processor machine could be set to 6 simultaneous requests. The only way to find the optimal value for this setting is to test your application under load with different values until you find which one provides the best performance under load. There is no single setting (that I've found) in the CFMX 8 administrator, as it seems to have more granular settings (pertaining to template, flash remoting, CFC function calls, etc.). Therefore, I don't have any guidance as to what are good starting values for these settings. Thanks, Jamie ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Outdated Adobe Performance-Tuning Info
Thanks for the link. I read through your and Steven's blog posts. However, something that complicates things (I think) is that our environment is like that of a web host: We have multiple CF instances per server, and in many cases, many sites per instance. It would be hard to do a real-world load test on this, I would think (aside from tinkering with production during peak hours). Also, CFMX *8* seems to have at least four different places where you can set a max requests value, so there are even more variables to contend with now. I think I'd have to defer to a better-informed person's guidelines as to what is a middle of the road starting value for these things. I wouldn't mind having the option of a single, more crude overall max request setting, actually. Further, my question about Windows-specific tuning recommendations still stands. I would guess that the Windows Server 2000 Adobe recommendations (including registry hacks to networking) would be applicable to 2003, but since I'm not an expert in this area, I wouldn't mind a sanity check there, either. By the way, here are some shorter URLs that will survive wrapping better: ColdFusion MX: Tips for performance and scalability http://www.adobe.com/go/tn_18540 Windows platform-specific performance settings http://www.adobe.com/go/tn_17277 Thanks again, Jamie On 9/10/08, Mark Kruger [EMAIL PROTECTED] wrote: Jamie, Testing and experience are your best guides. I have a post on this topic here http://www.coldfusionmuse.com/index.cfm/2006/5/4/higher.simultaneous.request s -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2008 8:56 AM To: CF-Talk Subject: Outdated Adobe Performance-Tuning Info The following articles, from early 2006, provide some guidance as to performance tuning CFMX on Windows. ColdFusion MX: Tips for performance and scalability http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18540 Windows platform-specific performance settings http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17277sliceId=2 However, they refer to outdated versions of CFMX, JVM, Windows, and IIS. Are more recent versions of these documents available? If not, can anyone comment on what guidelines, if any, have changed since then? One of the things I've noticed so far: Simultaneous Requests. The simultaneous requests setting on the Settings page of the ColdFusion Administrator has the largest impact on the scalability characteristic of an application (performance under load). This setting dictates how many threads will be used to simultaneously process incoming requests. For most applications, a good starting point for the optimal value for this setting is 3 per processor--a dual processor machine could be set to 6 simultaneous requests. The only way to find the optimal value for this setting is to test your application under load with different values until you find which one provides the best performance under load. There is no single setting (that I've found) in the CFMX 8 administrator, as it seems to have more granular settings (pertaining to template, flash remoting, CFC function calls, etc.). Therefore, I don't have any guidance as to what are good starting values for these settings. Thanks, Jamie ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Outdated Adobe Performance-Tuning Info
On 9/10/08, Mark Kruger [EMAIL PROTECTED] wrote: Jamie, So you are running JRUN/Multi-server? Is that correct? Yes. Does each instance have it's own JVM settings or do they all share the same JVM.config file? It seems they all share D:\JRun4\bin\jvm.config. Is it possible/advisable to do otherwise? Also, if you are running JRUN multi-server the settings for the simultaneous threads available to JRUN is very important. It is set to 50 by default... But needs to be adjusted according to how many instances you are running and your hardware resources. Start with 5x the number of procs/cores + 10 or 15 as the starting point for JRUN, then 5x the number of procs/cores divided by the number of instances for simultaneous... That would be a starting point This is the first time I've worked on a real (non dev) Web server on a VM, so I'm not sure how that figures in. If the VM shows a single processor, do I go with that figure, or do I find out what the host system actually has? Seems like 7 simultaneous threads would get me at a decent ballpark, given 3 instances in a (presumed) 1 processor VM. BTW, where *is* this setting for JRun? but you will need to test. If you can't test then you will need to monitor and adjust in real time Not pretty. A multi-server setup is very complicated. It's a little scary running one without a staging environment A bit of the cart before the horse :) I'm setting up stage right now, but production is on the fast track, too. Thanks again for the replies, Jamie -Mark -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2008 9:32 AM To: CF-Talk Subject: Re: Outdated Adobe Performance-Tuning Info Thanks for the link. I read through your and Steven's blog posts. However, something that complicates things (I think) is that our environment is like that of a web host: We have multiple CF instances per server, and in many cases, many sites per instance. It would be hard to do a real-world load test on this, I would think (aside from tinkering with production during peak hours). Also, CFMX *8* seems to have at least four different places where you can set a max requests value, so there are even more variables to contend with now. I think I'd have to defer to a better-informed person's guidelines as to what is a middle of the road starting value for these things. I wouldn't mind having the option of a single, more crude overall max request setting, actually. Further, my question about Windows-specific tuning recommendations still stands. I would guess that the Windows Server 2000 Adobe recommendations (including registry hacks to networking) would be applicable to 2003, but since I'm not an expert in this area, I wouldn't mind a sanity check there, either. By the way, here are some shorter URLs that will survive wrapping better: ColdFusion MX: Tips for performance and scalability http://www.adobe.com/go/tn_18540 Windows platform-specific performance settings http://www.adobe.com/go/tn_17277 Thanks again, Jamie On 9/10/08, Mark Kruger [EMAIL PROTECTED] wrote: Jamie, Testing and experience are your best guides. I have a post on this topic here http://www.coldfusionmuse.com/index.cfm/2006/5/4/higher.simultaneous.r equest s -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2008 8:56 AM To: CF-Talk Subject: Outdated Adobe Performance-Tuning Info The following articles, from early 2006, provide some guidance as to performance tuning CFMX on Windows. ColdFusion MX: Tips for performance and scalability http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18540 Windows platform-specific performance settings http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17277sli ceId=2 However, they refer to outdated versions of CFMX, JVM, Windows, and IIS. Are more recent versions of these documents available? If not, can anyone comment on what guidelines, if any, have changed since then? One of the things I've noticed so far: Simultaneous Requests. The simultaneous requests setting on the Settings page of the ColdFusion Administrator has the largest impact on the scalability characteristic of an application (performance under load). This setting dictates how many threads will be used to simultaneously process incoming requests. For most applications, a good starting point for the optimal value for this setting is 3 per processor--a dual processor machine could be set to 6 simultaneous requests. The only way to find the optimal value for this setting is to test your
Segfault Running Vspider
I'm not sure if this is a Linux (Ubuntu) specific problem or not, but I'm
getting a segfault, as well as some cryptic DNS errors.
I'd appreciate any leads as I have no ideas as to how to troubleshoot this
(aside from opening up permissions on the collection with chmod ug+rwx -R
/opt/jrun4/verity/collections/peerta_upitoolkit/, which was a shot in the
dark, and which I've already done).
Thanks,
Jamie
Here's the script I'm running:
verityBinPath=/opt/jrun4/verity/k2/_ilnx21/bin/
verityRoot=/opt/jrun4/verity/
projectVerityRoot=/var/www/apps/peerta/wwwroot/verityk2spider/
${verityBinPath}vspider \
-start http://localhost:9501/upitoolkit/ \
-cmdfile ${projectVerityRoot}runIndex.txt \
-collection ${verityRoot}collections/peerta_upitoolkit \
-style ${verityRoot}Data/stylesets/ColdFusionVspider \
-prefixmap ${projectVerityRoot}mappath.txt
And here's the segfault:
vspider - Verity, Inc. Version K5.5.0 (_ilnx21, Jun 29 2005)
I18nMsg Info: Error(): Couldn't find Install Dir
2008/01/17 10:49:26 Info: [vspider] (ind006000) Message database loaded from
[/opt/jrun4/verity/k2/common/ind.msg].
2008/01/17 10:49:27 Info: [vspider] (ind012207) Last indexing job was
interrupted 2 time(s). Running in auto-restart mode.
2008/01/17 10:49:27 Info: [vspider] (ind006001) License loaded from
[/opt/jrun4/verity/k2/common/runtime.lic].
2008/01/17 10:49:27 Info: [vspider] (ind005005) Licensed for local spidering.
2008/01/17 10:49:27 Info: [vspider] (ind005008) Not licensed for remote
spidering.
2008/01/17 10:49:27 Progress: [vspider] (ind031000) Inserting
[http://localhost:9501/upitoolkit/].
2008/01/17 10:49:27 Progress: [vspider] (ind031000) Inserting
[http://localhost:9501/upitoolkit/intake.html].
2008/01/17 10:49:27 Progress: [vspider] (ind031000) Inserting
[http://localhost:9501/upitoolkit/about.html].
2008/01/17 10:49:27 Progress: [vspider] (ind031001) Updating
[http://localhost:9501/upitoolkit/about.html].
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E0-1514 (Drvr):
Vgw:vgwhttp: DNS Lookup failure - Host unknown.
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E3-0604 (Vgw):
Error: Cannot open gateway stream.
2008/01/17 10:49:31 Warn: [vspider] (ind002006) VDK: WarnE2-0527 (Document
Index): Document 1 (http://localhost:9501/upitoolkit/): Stream error (-2) -
SKIPPING.
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E0-1514 (Drvr):
Vgw:vgwhttp: DNS Lookup failure - Host unknown.
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E3-0604 (Vgw):
Error: Cannot open gateway stream.
2008/01/17 10:49:31 Warn: [vspider] (ind002006) VDK: WarnE2-0527 (Document
Index): Document 2 (http://localhost:9501/upitoolkit/intake.html): Stream error
(-2) - SKIPPING.
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E0-1514 (Drvr):
Vgw:vgwhttp: DNS Lookup failure - Host unknown.
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E3-0604 (Vgw):
Error: Cannot open gateway stream.
2008/01/17 10:49:31 Warn: [vspider] (ind002006) VDK: WarnE2-0527 (Document
Index): Document 4 (http://localhost:9501/upitoolkit/about.html): Stream error
(-2) - SKIPPING.
../runIndex_upitoolkit.sh: line 9: 9151 Segmentation fault (core dumped)
${verityBinPath}vspider -start http://localhost:9501/upitoolkit/ -cmdfile
${projectVerityRoot}runIndex.txt -collection
${verityRoot}collections/peerta_upitoolkit -style
${verityRoot}Data/stylesets/ColdFusionVspider -prefixmap
${projectVerityRoot}mappath.txt
~|
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:296742
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Segfault Running Vspider
Side note: I hadn't noticed this one before (near the very top of the output): I18nMsg Info: Error(): Couldn't find Install Dir Not surprisingly for a Verity issue, I'm finding absolutely nothing (but this thread) when I Google I18nMsg verity, I18nMsg vdk, or I18nMsg vspider. So, if anybody's got any insight into that piece, let me know. Hopefully it's a clue into the problem at large. Thanks, Jamie ~| 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:296795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Segfault Running Vspider
2008/01/17 10:49:31 ERROR: [vspider] (ind002006) VDK: Error E0-1514 (Drvr): Vgw:vgwhttp: DNS Lookup failure - Host unknown. Do you have pages that redirect to another server? Hi Dave, Nope, these are pretty straightforward, and all URLs mentioned in the error *are* available when I browse them. Any more ideas? Thanks, Jamie 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:296792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfsearch won't return suggestions-related keys in status structure
(CFMX 7) Using: cfsearch name=site_results type=internet collection=#request.verityspider# criteria=#verityKeywords# status=site_results_status suggestions=always ContextPassages = 1 ContextBytes = 200 maxrows=50 / I'm expecting the following keys in site_results_status *found *searched *time *suggestedQuery *keywords *keywordScore but I'm only getting the bare-bones keys: *found *searched *time What could be going wrong? It seems straightforward, but my experience doesn't match the docs. I filed a bug report with Adobe, but Adobe's bug list might be a rocky place, where my seed can find no purchase. Besides, maybe I'm just screwing something up, or maybe there's some undocumented caveats that you helpful folks might be able to point out. Thanks, Jamie ~| 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:290982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Unable to Create a Verity Collection
[CFMX 7 Multi-Server on Ubuntu Linux] I'm trying to create a collection from the CF Admin, but I'm getting: Unable to create collection testMe. Unable to create collection testme. An error occurred while creating the collection: com.verity.api.administration.ConfigurationException: Fail to create the index. (-6220) I'm not sure where to go from here... Thanks, Jamie ~| 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:285079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Purging Removed Docs from Verity Spider Collection
How does one manage to automatically remove dead (removed) pages from the collection? I'd think that if it got a 404, then it'd remove it, but that doesn't *seem* to be the case. If this is documented somewhere, please let me know... Thanks, Jamie ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JDBC Connection Problem
It turned out that the driver wasn't happy here, D:\jrun4\servers\xxx\cfusion.ear\cfusion.war\WEB-INF\lib\basisjdbc.jar, and CFMX7 was only half-heartedly using it. I probably could have added the path to the classpath, but instead, I just moved the jar up to a higher lib directory (D:\jrun4\servers\lib). Works fine now. Thanks, Jamie I'm trying to connect to a database via JDBC. I can connect through Java apps running on the Web server (using CFMX7's built-in JVM), but the same data source configuration in the CFMX7 admin throws an error: Connection verification failed for data source: BASIS10 java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection Here's what I'm using to (successfully) connect directly through a Java app (personal info exxed out). D:\JRun4\jre\bin\java -classpath .;D:\jrun4\servers\xxx\cfusion. ear\cfusion.war\WEB-INF\lib\basisjdbc.jar TestConnection com.opentext. basis.jdbc.BasisDriver jdbc:opentext:basis://xxx:[EMAIL PROTECTED] xx:7300/library_docs xxx xxx Any ideas what's wrong, or how to troubleshoot? Thanks, Jamie P.S. Yes, it's a weird DB (OpenText BASIS), but it uses JDBC. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JDBC Connection Problem
I'm trying to connect to a database via JDBC. I can connect through Java apps running on the Web server (using CFMX7's built-in JVM), but the same data source configuration in the CFMX7 admin throws an error: Connection verification failed for data source: BASIS10 java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection Here's what I'm using to (successfully) connect directly through a Java app (personal info exxed out). D:\JRun4\jre\bin\java -classpath .;D:\jrun4\servers\xxx\cfusion.ear\cfusion.war\WEB-INF\lib\basisjdbc.jar TestConnection com.opentext.basis.jdbc.BasisDriver jdbc:opentext:basis://xxx:[EMAIL PROTECTED]:7300/library_docs xxx xxx Any ideas what's wrong, or how to troubleshoot? Thanks, Jamie P.S. Yes, it's a weird DB (OpenText BASIS), but it uses JDBC. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfimport vs. cfmodule/cf_MyTag for Custom Tag Calls
I (think) I've seen folks recommending cfimport over cf_MyTag and cfmodule template=MyTag for custom tag calls. I usually use a custom tag for header/footer inclusion like this cf_MySiteHeadFoot ... my body /cf_MySiteHeadFoot But was wondering if there's an advantage to cfimport. (Also, does cfimport allow cf-mapped paths now? I read that it didn't used to, at least.) Can someone straighten me out as to the pros and cons of cfimport, cf_MyTag, and cfmodule? Thanks, Jamie ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfcUnit Configuration Management
I'll play with Apache again, at some point. For now, I'll svn ignore the cfcunit dir that's sitting in my web root, and I'll do the same with the meta data. I'll tell the team to drop cfcunit in their web root, set a cf mapping to /org (cfcUnit's top level directory), and manually set up the build. Thanks, Jamie ~| 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:269638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfcUnit Configuration Management
I just got my first cfcUnit test going and automated in Eclipse. Now, I'm wondering about configuration management... My CFML sites generally are structured on the server in the same way they're stored in SVN. Each server has an SVN working copy, and I can deploy with simple svn updates. I'm not sure how the cfcunit directory fits into my configuration. One clean solution would be to make a directory alias in my virtual host (Apache) to a shared cfcunit directory in the filesystem, and also create a /cfcunit CF mapping to it. However, when I tried this, it didn't work. Also, I'm wondering how much, if any of the eclipse metadata (e.g., .settings .externalToolBuilders) to commit to SVN (in order to share with the team). Does anybody have any good approaches? Thanks, Jamie ~| 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:269513 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX7 Java version compatibility
Kevin, I believe flash remoting doesn't work with JVM 1.5. We just had to downgrade because of this. Leon How do you point CF to the right JVM? Change an environment variable? Change some config file? Thanks, Jamie ~| 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:267746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX7 Java version compatibility
Kevin, I believe flash remoting doesn't work with JVM 1.5. We just had to downgrade because of this. Leon How do you point CF to the right JVM? Change an environment variable? Change some config file? I'm asking because I get this when I run jrun.exe: Q:\c:\jrun4\bin\jrun.exe Exception in thread main java.util.zip.ZipException: The system cannot find th e file specified at java.util.zip.ZipFile.open(Native Method) at java.util.zip.ZipFile.init(ZipFile.java:111) at java.util.jar.JarFile.init(JarFile.java:127) at java.util.jar.JarFile.init(JarFile.java:65) ~| 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:267749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX7 Java version compatibility
Kevin,
I'm asking because I get this when I run jrun.exe:
Q:\c:\jrun4\bin\jrun.exe
Exception in thread main java.util.zip.ZipException: The system cannot find
th
e file specified
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.init(ZipFile.java:111)
at java.util.jar.JarFile.init(JarFile.java:127)
at java.util.jar.JarFile.init(JarFile.java:65)
Okay I found where to change the JVM (jvm.config):
#
# VM configuration
#
# Where to find JVM, if {java.home}/jre exists then that JVM is used
# if not then it must be the path to the JRE itself
java.home=C:/JRun4/jre
#
# If no java.home is specified a VM is located by looking in these places in
this
# order:
#
# 1) bin directory for java.dll (windows) or lib/ARCH/libjava.so (unix)
# 2) ../jre
# 3) registry (windows only)
# 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre)
#
and since it's already pointing to its own JRE, I don't know why I'm
getting this error when running jrun.
Ideas?
THanks,
Jamie
~|
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:267753
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX7 Java version compatibility
I'm asking because I get this when I run jrun.exe: I don't think you can just run jrun.exe without specifying the appropriate parameters, and having the appropriate environment variables set. Why are you trying to run jrun.exe directly? What happens if you run jrun -start cfusion? Can you run the appropriate instance from the JRun Launcher? Hi Dave, I was getting the same error when specifying the server to start. I haven't had problems like this before, it's just this one developer's machine. Thanks, Jamie ~| 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:267785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Foreign Characters in Verity Results
Last BUMP before I give up on this thread... thanks. One more bit of info: I can type the Ñ and ñ characters into the page source and can view them just fine in the browser. However, the problem I am having is limited to these foreign (Spanish) characters in CFSEARCH/Verity results. Thanks, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:266338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HoF (CF-Talk) Password Reminder (Not Working)
Bump... (BTW, I've emailed Michael Dinowitz a couple times, too. Michael, heeelp...) On 12/13/06, Jamie Jackson [EMAIL PROTECTED] wrote: TWIMC, The HoF mailing list password reminder claims to have sent me a message, but I've gotten no mail. It's not in my spam box or anything. I can't change my subscription prefs as a result, and can't easily reply directly to any existing thread, as I'm on the digest version. Can someone at HoF help me out, please? Thanks, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Foreign Characters in Verity Results
Jamie Jackson wrote: I'm using Verity spider to crawl the site. Some of the pages are in Spanish, and on the site, the accented characters show as question marks: T?rminos Espa?ol/Ingl?s Sobre el Bienestar del Ni?o what encoding for those pages? If I'm interpreting Eclipse's properties properly, the displaying page is UTF-8 P.S. I added the following tag to the html-head meta http-equiv=CONTENT-TYPE content=text/html; charset=utf-8 and is the data on those pages utf-8? Eclipse properties shows: Default (inherited from container: UTF-8) so I assume so... The above tag yields the question marks. Before I added the above tag, the accented characters showed as very strange characters, so the question marks are somewhat of an improvement. no that's actually worse. a box is a char that can't be rendered. the ? is garbaged data. Actually, you know what? I think those characters, while gmail/the browser displayed them as question marks, were actually boxes when I pasted them into notepad. In fact, I kept getting the emails returned, because CF-Talk claimed they were encoded emails. I had to replace the boxes (in notepad) with real question marks, so that the mail would go through to CF-Talk. I hope that wasn't too confusing. Where do I go from here? Thanks for the reply, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HoF (CF-Talk) Password Reminder (Not Working)
Yes, under the current system, you're stuck if your primary email address becomes extinct. Your proposed solution will solve the problem. Also, thanks for emailing me my password. Now I can reply to threads as easily as create them. (I had been stuck in digest mode, with no easy way to respond to individual threads.) Thanks!! Jamie I think that the email is going to a different account than you are expecting. The email was sent (twice today) and I've copied the info and sent it directly as well. I'm responding here because this is a common issue with people who subscribe with more than one posting address (a feature that may be unique to this list/forums). I'll alter the system to tell you what address the information was sent to as well as giving the option to send to all addresses subscribed to an account. TWIMC, The HoF mailing list password reminder claims to have sent me a message, but I've gotten no mail. It's not in my spam box or anything. I can't change my subscription prefs as a result, and can't easily reply directly to any existing thread, as I'm on the digest version. Can someone at HoF help me out, please? Thanks, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Foreign Characters in Verity Results
One more bit of info: I can type the Ñ and ñ characters into the page source and can view them just fine in the browser. However, the problem I am having is limited to these foreign (Spanish) characters in CFSEARCH/Verity results. Thanks, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HoF (CF-Talk) Password Reminder (Not Working)
Anyone subscribed in any mode has full access to the lists through the archives. There's even an option to only post from the archives and not receive any mail at all. I'm going to have to write better copy for the list options and abilities. There's a lot more going on then most people know. :) The archives are actually how I normally replied to an existing thread, however without a password (and since the primary email had been extinct), the only way to do anything was through email (which, without a password, had been stuck in digest mode). Your proposed enhancement solves these problems, though. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Weird formatting problem
Well, you *did* misspell cellpsacing (sic). Also, check to make sure you're not modifying the table through CSS. I cannot look at this anymore. I have the following include that has a table with no cellpadding or cellspacing, but still shows spacing. Can anyone see why? inc_navleftside_b.cfm table cellpadding=0 cellspacing=0 bgcolor=#99 tr td table width=100% border=0 cellpadding=0 cellpsacing=0 CFOUTPUT query = ResState tr td bgcolor=##CC width=100%a href=index. cfm?stateAbbrev=#resState.StateAbbrev##Trim(resState. StateName)#/a/td /tr /CFOUTPUT /table /td /tr /table Where included... table border=0 cellspacing=0 cellpadding=0 width=100% !--- DISPLAY SUBCATS --- CFIF IsDefined(url.qcid) tr td valign=TOPCFINCLUDE template=inc_navleftside_a.cfm /td /tr tr td height=20nbsp;/td /tr /CFIF tr td valign=TOPCFINCLUDE template=inc_navleftside_b.cfm /td /tr /table Doug B. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Foreign Characters in Verity Results
I'm using Verity spider to crawl the site. Some of the pages are in Spanish, and on the site, the accented characters show as question marks: T?rminos Espa?ol/Ingl?s Sobre el Bienestar del Ni?o However, if I search from the command line (via rck2), the characters look good: Términos Español/Inglés Sobre el Bienestar del Niño How can I fix this? Thanks, Jamie P.S. I added the following tag to the html-head meta http-equiv=CONTENT-TYPE content=text/html; charset=utf-8 The above tag yields the question marks. Before I added the above tag, the accented characters showed as very strange characters, so the question marks are somewhat of an improvement. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:265638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HoF (CF-Talk) Password Reminder (Not Working)
TWIMC, The HoF mailing list password reminder claims to have sent me a message, but I've gotten no mail. It's not in my spam box or anything. I can't change my subscription prefs as a result, and can't easily reply directly to any existing thread, as I'm on the digest version. Can someone at HoF help me out, please? Thanks, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:263940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Document Categories in Verity
Say I've got a bunch of PDF documents, and each PDF can fit into one or more categories. When indexing them with Verity, is there a way to associate the PDFs with categories? Bottom line is I need to be able to group the PDFs by category in the search results: Your search found the following documents: My Category A: doc1.pdf doc2.pdf My Category B: doc1.pdf doc4.pdf My Category C: doc2.pdf doc3.pdf Strategies I'm contemplating (but don't know if they're possible): Add a keywords to the PDF files directly (in PDF properties) and have Verity return these in a custom field that I can manipulate at display-results time. Somehow hold the PDF categories in a DB, and do some lookups at display-results time (keeping the DB and filesystem in synch would be unpleasant). Any ideas? Thanks, Jamie ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 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:263330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JRun Serverstore
The serverstore is related to the conenctor. So unless your running multiple instances, the answer is yes. I take that to mean that you should have a serverstore per cfmx *instance*, and that whatever virtual hosts use that instance should point to that serverstore. In other words, there is a one-to-one relationship between cfmx instances and serverstores. I also assume that is true of any java app under jrun, that each of these (whether they be cfmx instances, or some other java app) should have their own serverstore. Did I get that right? Thanks, Jamie P.S. I haven't found any documentation yet that suggests that serverstore is deprecated. Please post a link if you've found one? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JRun Serverstore
Hi All, I'm trying to get the lowdown on the serverstore property of the jrun4 connector. I read the docs (below*), but I'm not sure of the implications. For instance, say I've got lots of unrelated virtual hosts defined in Apache. Can all of these virtual hosts share the same serverstore, or should a new serverstore be created for each new virtual host? Some colleagues have an issue in one of their context roots, where they intermittently get Forbidden Error, and I'm trying to determine serverstore belongs on the list of suspects. (I'd ask this on the JRun list, but that list looks pretty dead.) Thanks! Jamie *(The serverstore property specifies the name of the file containing the machine names and JRun proxy ports for all JRun servers in a cluster. This file is named jrunserver.store by default. The proxyservers property contains a semicolon delimited list of the JRun servers in a cluster. The web server connector populates this property automatically when it starts up and detects that the bootstrap JRun server participates in a cluster. The following figure shows this process:) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Escaping parentheses in table names (querying MS Access DB)
The table name is qry 1(1) (everything between the quotes). SELECT * FROM [qry 1(1)] I tried the above, but it yields: Error Executing Database Query. Undefined function 'FormatNumber' in expression. Any ideas? Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
On 9/26/06, Jamie Jackson [EMAIL PROTECTED] wrote: The table name is qry 1(1) (everything between the quotes). SELECT * FROM [qry 1(1)] I tried the above, but it yields: Error Executing Database Query. Undefined function 'FormatNumber' in expression. Any ideas? Thanks, Jamie Jim Wright Wrote: SELECT * FROM `qry 1(1)` Thanks, but same issue with that syntax. Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Escaping parentheses in table names (querying MS Access DB)
On 9/26/06, Jamie Jackson [EMAIL PROTECTED] wrote: The table name is qry 1(1) (everything between the quotes). SELECT * FROM [qry 1(1)] I tried the above, but it yields: Error Executing Database Query. Undefined function 'FormatNumber' in expression. Any ideas? Thanks, Jamie Claude Schneegans wrote: Shoot the moron who created such a stupid table name! ;-) Interesting approach, but that's frowned upon in my workplace. ;-) Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
On 9/26/06, Jamie Jackson [EMAIL PROTECTED] wrote: On 9/26/06, Jamie Jackson [EMAIL PROTECTED] wrote: The table name is qry 1(1) (everything between the quotes). SELECT * FROM [qry 1(1)] I tried the above, but it yields: Error Executing Database Query. Undefined function 'FormatNumber' in expression. Any ideas? Thanks, Jamie Jim Wright Wrote: SELECT * FROM `qry 1(1)` Thanks, but same issue with that syntax. Jamie Jim Write Wrote: Did you do an grave accent (ascii 96), not a single quote? That works in a local version of Access. Yeah, I used the `. Unfortunately, what works *in* Access doesn't necessarily work from CF. For instance (it's been a while since I've used Access from CF, so don't quote me on this), * is the wildcard while *in* Access, but from, say CF, you need to use the normal %. Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Escaping parentheses in table names (querying MS Access DB)
I don't think this is going to be possible. I think the tables will have to be renamed. I hate Access for (among other things) allowing such odd, non-interoperable entity names. I was hoping not to have to dig into this ugly, inherited DB. However, I hope I'm wrong, and that someone knows a workaround Jamie On 9/26/06, Jamie Jackson [EMAIL PROTECTED] wrote: The table name is qry 1(1) (everything between the quotes). SELECT * FROM [qry 1(1)] I tried the above, but it yields: Error Executing Database Query. Undefined function 'FormatNumber' in expression. Any ideas? Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using same Apache instance for CF5 and CFMX7?
Hi, On my local development machine, I've got CF5 running on Apache 2.0.58(using the 2.0.43-xx connector from http://home.nextron.ch/coldfusion/). Is it possible to use the same Apache instance for CFMX7, or will I need to install another Apache instance? I'm guessing I'd need to be able to specify a connector for each virtual host, but I don't know how/if that's possible. If it's not possible, I suppose I'd need to use different ports between CF5 sites and CFMX7 sites, to specify which Apache I want to handle the request... Thanks, Jamie ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246254 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Charting a Baseline in Coldfusion
Say I've got a normal bar chart, but I want to call out a flat baseline behind the bars. For instance, maybe I've got bars indicating Joe, Sally, and Mary's GPA, and want to show a horizontal baseline (say class average) *behind* the bars. I seem to need this sort of chart fairly often, and was wondering if it's possible in CF charting. It doesn't *seem* to be, but I'm looking for confirmation. Thanks, Jamie ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244885 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: vspider
Someone asked me about vspider and verity today, but I have never used it. This obviously is not installed by default with CFMX7, so is it a free download or? Actually, it is installed by default with CFMX 7. I have read up a bit on it, Can vspider collections be setup and managed totally via CFML as with normal verity collections, or doe sanything manual need to be done by the cfadmin? You can use vspider with existing Verity collections, I think, but you will have to run vspider from the command line (or through CFEXECUTE). I have had had big problems in the past with indexing via CFEXECUTE (hung, corrupt indexes), but anyway, my real question is... Does vspider work with Linux on CFMX 7.x? [It didn't work in CFMX 6.x, though some (conflicting) MM documentation would have led one to believe otherwise.] Thanks, Jamie ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244886 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
Differences among the three CFMX configuration options
We are going to be installing CFMX7 on our new servers, but I'm not clear on the pros and cons of each installation configuration. There's: A. Server Configuration (JRun is hidden) B. Multiserver Configuration C. J2EE Configuration Is there a feature matrix of these three? Otherwise, can someone provide the pros and cons of each? (I'm probably not interested in A) Among the things I'm interested in (but are not immediate needs): Ability to use CF view/controller on a Java model; ability to JRun apps and CF apps sharing the same domain (under, say different context roots); etc. Thanks, Jamie ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238383 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: How to determine JDBC driver version in use
By the way, this was fortuitous, because I found that 2.0.11 beats the snot out of 3.1.10 for my application. The new driver takes 50ms PER VARCHAR FIELD to retrieve one row of data, whereas the old one performs as I would expect, and executes my queries TEN TIMES faster. Wow. Maybe you should do some googling to see if there are any known bugs with that driver that might cause that. I might, but I found empirically that 3.1.8 and 3.1.12 performed just as badly as 3.1.10, so I don't think it's particular to exactly one release. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238384 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
How to determine JDBC driver version in use
I don't know how to CONCLUSIVELY determine which version of the JDBC driver that a given instance of CFMX is using. I made up my own function (see below*), but I'm not completely sure it's trustworthy, because of the surprising results I get. Can somebody give me the authoritative way to determine the driver version IN USE? Thanks, Jamie * Is this a valid way to get which version of the driver a given datasource is using? I made it up. cffunction name=getJDBCDriverInfo output=false returntype=struct hint=returns a JDBC driver info cfargument name=dsn type=string required=yes cfargument name=catalog type=string required=yes hint=catalog(name) is, for example, the 'db' name (according to MSSQL) or the 'schema' name (according to ORACLE) cfargument name=username type=string required=yes cfargument name=password type=string required=yes cfscript // declare local variables var dss = ; var conn = ; var mdata = ; /* create a datasource service */ // Create a service factory dss = CreateObject(java, coldfusion.server.ServiceFactory); // get a datasource service dss = dss.getDataSourceService(); /* configure connection */ // set CF datasource name conn = dss.getDataSource(dsn); // set db login conn = conn.getConnection(username,password); // get metadata from connection mdata = conn.getMetaData(); // provide some info about the driver driverSct[MajorVersion] = mdata.getDriverMajorVersion(); driverSct[MinorVersion] = mdata.getDriverMinorVersion(); driverSct[DriverVersion] = mdata.getDriverVersion(); driverSct[Name] = mdata.getDriverName(); /cfscript !--- cfdump var=#mdata# --- !--- return the query of metadata --- cfreturn driverSct /cffunction ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237698 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: model glue/reactor question
I haven't scrutinized your code, but when I can't get a troublesome routine to run any more quickly, I often cache its result in a persistent scope (application is my favorite). That's one way to sweep it under the rug. Jamie Hi all. I'm building an app using model glue and reactor. I'm having an issue with a function I wrote that returns my navigation to me, appropriately nested. The function is a recursive one, and works as designed, no problem there. BUT, it's painfully slow, even with debugging and reactor regeneration disabled. SO, I'm wondering if any of you can look at how I've approached this and tell me if anything jumps out at you as obviously inefficient. Thanks! The specs: End value returned: div id=menu0Administration/div div id=menu1view reports/div div id=menu1search employees/div div id=menu2easy on the bottom line/div div id=menu1enrollment stats/div div id=menu1system reports/div div id=menu1Company profile/div div id=menu1manage system users/div div id=menu1message center/div div id=menu0Enrollment/div div id=menu1new hire enrollment/div div id=menu1life status event/div div id=menu1view current benefits/div div id=menu0About Us/div div id=menu0Cwes features/div div id=menu1streamlined open enrollment/div div id=menu1customizable reports/div div id=menu1ease of use/div div id=menu1one stop shop/div div id=menu0Contact Us/div My nav table structure: NavigationID (primary key, auto incrementing integer); name (varchar, name of my nav item); output_text (varchar, text to use for the nav item); link (varchar, link for the nav item); parentid (integer, ID of the parent navigation item (= navigationID)); navorder (tinyint, sort order for navigation) The CFC performing the nav building: cfcomponent displayname=Controller output=false hint=I am a sample model-glue controller. extends=ModelGlue.Core.Controller cfset variables.reactor = application.recordfactory / cfset variables.navcontainer = / cffunction name=Init access=Public returnType=controller. navcontroller output=false hint=I build a new SampleController cfargument name=ModelGlue required=true type=ModelGlue. ModelGlue / cfargument name=InstanceName required=true type=string / cfset super.Init(arguments.ModelGlue) / cfreturn this / /cffunction cffunction name=getNav access=public returnType=void output=false cfargument name=event type=ModelGlue.Core.Event required=false cfargument name=parentID type=numeric required=yes default=0 / cfargument name=level type=numeric required=yes default=0 / cfset var objNav = / cfset var objItem = / !--- grab all the elements whose parent is 'arguments.parentID' --- cfset objNav = variables.reactor.creategateway(navparent). getByFields(parentid=arguments.parentid) / !--- loop through query --- cfloop query=objNav !--- add this item to global variable --- cfset variables.navcontainer = variables.navcontainer div id=menu arguments.levelobjNav.name /div chr(10) / !--- check for children. If there are any, call this function recursively --- cfif variables.reactor.createrecord(navparent). load(navigationid=objNav.navigationid).getnavchilditerator(). hasmore() cfset getNav(parentID = objNav.navigationID, level = arguments. level + 1) / /cfif /cfloop !--- loop finished --- !--- return final variable --- cfif arguments.level eq 0 cfset arguments.event.setValue(navtext,variables.navcontainer) / /cfif /cffunction /cfcomponent ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237700 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: How to determine JDBC driver version in use
Here's what's goofy about that: I think that the native MySQL drivers (not mentioned in the blog) have a different package/class name than the latest ones from MySQL. I don't know if I could prove anything from a similar experiment, but maybe... Jamie I think this may be what you need. http://www.bpurcell.org/index.cfm?mode=entryentry=988 On 4/13/06, Jamie Jackson [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237713 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: How to determine JDBC driver version in use
It looks pretty correct to me. (Although with the CFAdmin API there may be another way to get the metadata object without instantiating the undocumented serviceFactory object.) What kind of results are you seeing? Well, Sir Isaac Dealey (sorry, that's how I have always read your name ;-), I'm glad you asked... What I get is: DriverVersion 2.0.11 NameMark Matthews' MySQL Driver If this is true, it stuns me in several ways: 1. I thought that version 3.1.8 was installed. 2. I suspect that the reported driver is the CFMX 6.1 native MySQL driver. :-O 3. The datasource WORKS with our 5.x databases, which I *think* isn't supposed to be true of the native drivers (due to authentication protocols, among potential others). I can't reconcile 1, 2, and 3, and I wish you had told me my function was all wrong. Can someone help me make sense of this? Also, where can I find the *documented* CFAdmin API of which you write? I'd love to have a peek at the documented clockwork of CFMX. I've only delved into the dark side for lack of documentation. Thanks, Jamie ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237717 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: cfexecute buffer causing hangs?
Hmm, I'm probably one of the people you've seen while Googling the subject. While I haven't tried cfexecuting the vspider stuff from CFMX7, I've had significant problems with it from CF5. Are you saying that you had problems when you didn't specify an output file or, or when you did? I wasnt' quite sure what you meant by the console in this context. Dumping the output to a browser had some fairly well known limitations, but I'm interested in knowing whether there are also problems even when specifying an output file. Thanks, Jamie Hi everyone, In my continued work with the Verity Vspider I came across something interesting today. It seems that the cfexecute tag has an issue with buffering output that is returned from the spawned process. This is CFMX 7.0.1 Enterprise running on Windows 2003 Server Standard. I searched high and low and found a lot of people that had and have issues with cfexecute, but a good amount weren't using the tag and its arguments in the correct way. That being said, I DID find a problem that I emailed product support about. I can't say this with absolute certainty about all cfexecute command-line processes that output a significant amount of data, but I did discover that after a certain amount of log data output to the console, the vspider process just hangs. I suspect this would be the case with other programs, too. As I was reading the forums and other areas on the web, I noticed people with this same problem that were running apps like zip programs that would verbosely output all the actions being taken. There is a specific command in a vspider config file that you can use to specify the type of logging. The initial command I was using is: -loglevel verbose. Changing it to: -loglevel nostdout took care of the hanging process! I hope this might help others having this problem with this or other applications, or at least bring attention to a potential bug. I am pretty sure it's a bug but haven't tested any other apps except vspider, although removing the standard output to the console with the above switch did take care of the problem, which tells me it's definitely not related to the vspider program itself. Andy ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237719 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
SOT: Full-Featured Host (Preferably Local)
I've been tasked to come up with some estimates with regard external hosting. We are developing a large-scale CFMX survey, and we would probably need a farm of 2 or more dedicated app/web servers (clustered or using sticky sessions). Also, we would probably need replicated databases (MySQL, probably). We usually host our own sites, but we can't provide protection against extended power outages (we've got a couple hours worth of UPS, but no generators), and the new building we're moving into will not have ISP redundancy (not yet, anyway). I haven't dealt with an external host beyond personal and small business Web sites, so I'm not sure where to start, but I need a host with all the options: *(maybe user-managed and possibly user-configured) dedicated machines *high availailability *preferably local, so if we have user-configured, user managed machines, we could easily deliver them, etc. *etc., etc. I would need to discuss a lot with them to iron out the details. Does anyone have a host or contact they would recommend? Thanks, Jamie Jackson Fairfax, VA ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230358 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
Clustering CFMX 6.1 (J2EE Session Sharing)
I'm trying to cluster CFMX 6.1 on JRun 4, but I'm getting stuck early in the process. I'm trying to register a remote server, but after I input the parameters (remote JNDI port, host name, and server name), my server appears, as I would expect. However, I would expect the server to be running, since it is already running on the remote machine. When I try to start it remotely (from the JMC), the start (green arrow) button spawns a JS popup: To start or stop a remote server, another running server on the remote host must already be registered with the JMC. It *is* already running on the remote machine. Can anyone help me get past this one step? If I can get get a remote JRun instance registered properly, I think I'll be well on my way to J2EE session sharing in CFMX. Thanks, Jamie ~| 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:208062 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: J2EE Sessions / session.urlToken
Hi Chris, Check the help on urlSessionFormat, I think there's a switch to turn off the token append. You mean to switch off CFID/CFTOKEN only? Otherwise, I don't see any utility in turning of the entire token in urlSession format... BTW, I don't believe there is a (documented) switch in urlSessionFormat (http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca115.htm), but let me know if you find otherwise. Thanks, Jamie On Wed, 13 Oct 2004 10:46:56 -0400, in cf-talk you wrote: CFID/CFTOKEN are still used to identify client variables stored in the database. Check the help on urlSessionFormat, I think there's a switch to turn off the token append. best, Chris Norloff -- Original Message -- From: Jamie Jackson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 12 Oct 2004 17:10:33 -0400 I've got a couple questions about session.urlToken under J2EE sessions: When J2EE sessions are enabled, why does session.urlToken bother with CFID/CFTOKEN anymore. The fact that both are there confuses me. I wonder which takes precedence? Do I lose the extra security that the uniqueness of jsessionID affords (i.e. can someone still hack the CFID/CFTOKEN and hijack a session)? Also, I'm using urlSessionFormat, and am getting the urltoken appended, even with cookies turned on. Any suggestions as to how to troubleshoot this? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
J2EE Sessions / session.urlToken
I've got a couple questions about session.urlToken under J2EE sessions: When J2EE sessions are enabled, why does session.urlToken bother with CFID/CFTOKEN anymore. The fact that both are there confuses me. I wonder which takes precedence? Do I lose the extra security that the uniqueness of jsessionID affords (i.e. can someone still hack the CFID/CFTOKEN and hijack a session)? Also, I'm using urlSessionFormat, and am getting the urltoken appended, even with cookies turned on. Any suggestions as to how to troubleshoot this? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX 6.1 Bug? WEB-INF directory showing up in my CF site.
Looks like JRun dumps a WEB-INF directory (full of generated classes) inside www roots that happen to be named www. (Linux box.) Seems that this has been happening since the JRun CFMX updater that we ran on Aug 30. Can anyone shed light on this? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site.
Well, I know one way that you won't get it back. It's to uncheck Save Class Files* in the CF Admin. However, I'd like to know how to *really* fix this (have the classes be saved in the normal spot under cfusion's WEB-INF directory, not in my Web root(s)). I posted a bug to MM, but I don't know what becomes of those. In the meantime, we've set an apache rule to restrict Web access to the otherwise publicly accessible class files. Thanks for confirming the issue, Gav. Jamie *When you select this option, the class files generated by ColdFusion are saved to disk for reuse after the server restarts. Macromedia recommends this for production systems. During development, Macromedia recommends that you do not select this option. On Tue, 5 Oct 2004 17:00:44 +0100, in cf-talk you wrote: Same problem at our end on Solaris. It looks like the updater has to re-compile all CFCs but somehow gets the location wrong and dumps them into the web root. We backed them up (just in case) and deleted them and they haven't come back since. On Tue, 5 Oct 2004 16:16:24 +0100, Gavin Brook [EMAIL PROTECTED] wrote: I have seen the same thing on a windows installation. I ran the latest updater and it now places the cached class files into a web-inf directory in the webroot of my application. Mine root isn't called www either. Very weird. Gav -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: 05 October 2004 15:42 To: CF-Talk Subject: CFMX 6.1 Bug? WEB-INF directory showing up in my CF site. Looks like JRun dumps a WEB-INF directory (full of generated classes) inside www roots that happen to be named www. (Linux box.) Seems that this has been happening since the JRun CFMX updater that we ran on Aug 30. Can anyone shed light on this? Thanks, Jamie _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: webroot level?
On Thu, 22 Jul 2004 18:46:16 +0200, in cf-talk you wrote: What I wanted it todo was not toneed to do the flip trick of choosing servers, but for it to know this automatically... there MUST be a way as all I am asking is WHERE is Application.cfm residing, from there I can work out all the other paths and urls MD Here's what I've done: // In the application root's Application.cfm request.rootDir = getDirectoryFromPath(getCurrentTemplatePath()); ... but it sets a request variable. Why are you resistant to the request variable? Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OO Coding Relational Databases
On Thu, 22 Jul 2004 13:13:46 -0400, in cf-talk you wrote: One of the biggest issues I have getting fully into OO programming usings CFCs is my understanding of how data comes from a relational database, into an object and vice versa.Most of the CF resources I have found talk plenty about CFCs, but they completely ignore working with OO code and a database. Can somebody point me to any resources that might help fill in the gaps here? Thanks -- Jeff As you will see (from the agile link you were given), there are a few ways to do it: 1: I think they call it brute force, where data access is in the business objects themselves (queries right in the classes). This is generally frowned upon. 2: Data Access Objects (DAOs) (As described in sort of a Mach II context here: http://livedocs.macromedia.com/wtg/public/machiidevguide/models.html) I think some of the Mach II sample apps will reflect this same Object/DAO/Gateway idea of DB interaction. 3: Persistence frameworks: These are widely available as products for Java development, but I don't know of any CF persistence frameworks, per se. (Though I'm sure there's a way to tap into those Java frameworks.) I started to build a CF RDB persistence framework in my last project, but the requirements weren't enough for me to complete it. Anyway, a persistence framework is a big effort. >From my research on the matter -- revealing a general antipathy toward option 1 and the steep learning curve (assuming we have similar backgrounds) of option 3 -- I would point you toward option 2, to start with. I'm an OO newbie, so take all the above with a grain of salt. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC Design for Multiple Person Roles
I'd suggest posting to the newsgroup comp.object. It's a highly academic make-your-head-spin kinda newsgroup, but tell them you're a newbie (unless you aren't ;) and they'll speak English. Thanks, Jamie On Thu, 22 Jul 2004 14:58:09 -0500, in cf-talk you wrote: In our school, as would many other schools, we have people who are of multiple roles.The roles would mainly include: Student, Faculty, Employee. Currently, I have a single CFC that wraps all three user roles in one. I don't really care for that method, but I haven't seen a solution, good or bad, that lets me break up the different roles into separate objects. A user may be a(n): Employee-only Employee and faculty Employee and student Employee, faculty and student Faculty-only Faculty and student Student-only A base class would be User, but how do I extend this base class to include each possibility of the other roles? Some differences are: A faculty has a method that returns all courses they teach. A student has a method that returns all courses in which they are enrolled. Can anyone suggest a OO design principle that may satisfy these needs? Thanks! M!chael A. Dawson Manager, Programming and Software Development Office of Technology Services University of Evansville 1800 Lincoln Avenue Evansville, IN 47722 812-479-2581 If you can read this, you are umop apisdn. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
UDF within a Custom Tag
I have had a problem a couple times when I've tried to put a UDF within a custom tag. CF insists that the function has been declared more than once. I figured this was because of the sort of doubling effect the start/end execution modes have, but the problem persists even when I have cfif thistag.executionmode is endcfexit method=exittag/cfif at the top of the custom tag. I think that when I've encountered this, I've had to remove the UDF, request-scope it, and put it in the general UDF library, even though it really is just a private method of the custom tag. Solutions? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 16:38:03 +0100, in cf-talk you wrote:
You are getting this error as by default Custom Tags are called twice
internally AFAIK..
So are UDFs not allowed within Custom Tags?
I also tried wrapping the function declaration in a testing
conditional:
cfif not isdefined(doOption)
cfscript
function doOption() {
...
}
/cfscript
/cfif
But CF complains that doOption is a complex variable, and it can't
test for its definition. Is there a way to do an existence test on
UDFs, or is there a cleaner way to do UDFs in Custom Tags?
Thanks,
Jamie
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 10:45:21 -0500, Raymond Camden [EMAIL PROTECTED] wrote: Are you still running 6.0? I believe they fixed this in 6.1. Nope, running 6.1. Any ideas with that in mind? Might I be doing something wrong? In 6.0 I resorted to either using request scoped vars or using code to cfinclude the UDF when executionmode=start. Also, if you just want the tag to run in start mode, you can simply put this at the end of your custom tag: cfexit method=EXITTAG No need to check execution mode. This one line will simply make the custom tag run in start mode. Neat trick, thanks. I guess the only thing I don't like about it is it's kinda buried down there. Cleaner, though. On Wed, 21 Jul 2004 11:25:25 -0400, Jamie Jackson [EMAIL PROTECTED] wrote: I have had a problem a couple times when I've tried to put a UDF within a custom tag. CF insists that the function has been declared more than once. I figured this was because of the sort of doubling effect the start/end execution modes have, but the problem persists even when I have cfif thistag.executionmode is endcfexit method=exittag/cfif at the top of the custom tag. I think that when I've encountered this, I've had to remove the UDF, request-scope it, and put it in the general UDF library, even though it really is just a private method of the custom tag. Solutions? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 12:00:48 -0400, Ben Doom [EMAIL PROTECTED] wrote: I'd set a request-scoped variable just before or after my function declaration (ie request.functionnameIsDeclared or something else you'll never use anywhere else) and check for its existence. --Ben Doh! Why didn't I think of that? :) It's a teeny bit tedious to have to do this, but it's better than moving the private UDF elsewhere. Thanks! Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 12:11:13 -0400, in cf-talk you wrote: On Wed, 21 Jul 2004 10:45:21 -0500, Raymond Camden [EMAIL PROTECTED] wrote: Are you still running 6.0? I believe they fixed this in 6.1. Nope, running 6.1. Any ideas with that in mind? Might I be doing something wrong? Whoops, I forgot for a moment which environment this app's in. Our CFMX boxes are all 6.1, but this old site happens to be on _CF5_, not MX at all. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 12:00:48 -0400, in cf-talk you wrote:
I'd set a request-scoped variable just before or after my function
declaration (ie request.functionnameIsDeclared or something else
you'll never use anywhere else) and check for its existence.
--Ben
That's a great idea, and one I hadn't thought of; however, it doesn't
seem to work:
The following gives the same error I've had all along:
cfif NOT isDefined(request.doTocOptionIsDeclared)
cfscript
function doTocOption(myQuery, contextFilePrefix) {
...
}
request.doTocOptionIsDeclared = true;
/cfscript
/cfif
The error associated with the above is:
Routines cannot be declared more than once.
The routine doTocOption has been declared twice in different
templates.
Furthermore, within cfscript blocks, function declarations seem to be
disallowed within conditionals, so the following also doesn't work:
cfscript
if (NOT isDefined(request.doTocOptionIsDeclared)) {
function doTocOption(myQuery, contextFilePrefix) {
...
}
request.doTocOptionIsDeclared = true;
}
/cfscript
The above yields:
Just in time compilation error
Invalid parser construct found on line 220 at position 3. ColdFusion
was looking at the following text:
function
Invalid _expression_ format. The usual cause is an error in the
_expression_ structure.
Lame :(
Thanks,
Jamie
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 17:36:07 +0100, in cf-talk you wrote: I believe this is a known bug - stumbled across it myself a while back. Since then I have resorted to declaring udfs outside a tag Kola Darn, should have been easy to have private methods in Custom Tags. Oh well, thanks for the sanity check. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 13:29:40 -0400, in cf-talk you wrote:
What about using isCustomFunction() or isFunction from
http://cflib.org/udf.cfm?ID=286
Qasim
I just tried your suggestion, and it behaved the same as if I didn't
have the conditional in there at all:
cfif NOT isFunction(doTocOptionIsDeclared)
cfscript
function doTocOption(myQuery, contextFilePrefix) {
...
}
/cfscript
/cfif
The error associated with the above is:
Routines cannot be declared more than once.
The routine doTocOption has been declared twice in different
templates.
Thanks for the reply,
Jamie
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 15:39:05 -0400, in cf-talk you wrote:
Shouldn't you be doing this?
cfif NOT isFunction(doTocOption)
cfscript
function doTocOption(myQuery, contextFilePrefix) {
...
}
/cfscript
/cfif
Yes, sorry, just a typo in the post, but not in my experiment.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 12:43:39 -0700, in cf-talk you wrote:
You can also just do isdefined('doTocOption') to see if the function has
been created.
Normally, maybe; however, not within the context of a Custom Tag (it
just doesn't work). :-/
Thanks,
Jamie
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 15:53:27 -0400, in cf-talk you wrote: I just tried your suggestion, and it behaved the same as if I didn't I encountered the same problem once and no suggestion was able to get around the problem. It looks like the function is compiled twice, no matter any CFIF you may put aroud it, even CFIF thisTag.execution mode, nothing. Yup, that's what I'm seeing. Thanks for confirming the behavior, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UDF within a Custom Tag
On Wed, 21 Jul 2004 15:39:19 -0500, in cf-talk you wrote: Jamie - If you are on CF5 you only have 2 choices really... Use the request scope. You would define the UDF in the request BEFORE you call the custom tag. Ie, Application.cfm may cfinclude a file of UDFs where each UDF is copied to the request scope. You would call the UDF in the CT by using request.foo() In the custom tag, use cfinclude to include the file only in executionMode = start. Hi Ray, I am already using the request scope, I just wanted to know what/if I was doing wrong when trying the UDF declaration within the CT. Since what I was doing is *theoretically* right, I'm satisfied to consider this a bug, and will continue to use the request scope workaround. Thanks for validating the request scope workaround and offering the second (cfinclude) workaround. So, umm, case closed or something. ;-) Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Dynamically writing/running a CF tag?
In CF5, I've written a wrapper for the cfmail tag so that it does multipart emails (HTML + Text + attachments, etc.). Right now, I construct the final cfmail tag as a variable, then I write that variable (the cfmail tag) to a file, then include it, then delete it. This is inefficient, but it is to get around the fact that you can't do things like this: !--- can't conditionally include attributes --- cfmail from=#attributes.from# to=#attributes.to# cfif isdefined(attributes.server)server=#attributes.server#/cfif cfif isdefined(attributes.port)port=#attributes.port#/cfif cfif isdefined(attributes.query)query=#attributes.query#/cfif / Is there some way around the file write/include/delete method? ...Any ideas at all? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamically writing/running a CF tag?
On Fri, 4 Jun 2004 11:20:25 -0400, in cf-talk you wrote: From: Jamie Jackson In CF5, I've written a wrapper for the cfmail tag so that it does multipart emails (HTML + Text + attachments, etc.). Right now, I construct the final cfmail tag as a variable, then I write that variable (the cfmail tag) to a file, then include it, then delete it. This is inefficient, but it is to get around the fact that you can't do things like this: !--- can't conditionally include attributes --- cfmail from=#attributes.from# to=#attributes.to# cfif isdefined(attributes.server)server=#attributes.server#/cfif cfif isdefined(attributes.port)port=#attributes.port#/cfif cfif isdefined(attributes.query)query=#attributes.query#/cfif / Is there some way around the file write/include/delete method? ...Any ideas at all? I'm not sure about QUERY, but I'm pretty certain that SERVER and PORT can be left blank So you could do CFPARAM NAME=attributes.server default= CFPARAM NAME=attributes.port default= CFMAIL FROM=#attributes.from# TO=#attributes.to# SERVER=#attributes.server# PORT=#attributes.port# You can't put a CF tag within the main part of another CF tag, you can in the content part of it, but not in the building part of it Right, I thought I might be able to default server and port to either blank, or dynamically determine the CF-default server, and default the port to 25. However that still leaves the query attribute. As a rule, I don't use the query attribute, anyway, but others in my organization might. Is there no way around this hurdle, other than the workaround I'm already using? (I'll be happy with a no answer, as long as it's definitive.) Thanks again, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamically writing/running a CF tag?
Yeah, that's the sort of creative thinking I was looking for. That would be a great hidden feature of built-in tags if it works... I'll let you know. Thanks, Jamie On Fri, 4 Jun 2004 09:17:53 -0700, in cf-talk you wrote: Have you tried passing attributeCollection to the CFMAIL tag, just like you would to a custom tag or CFMODULE call?I have no idea if it'd actually work, but it's worth a shot, as it would provided exactly the functionality you're looking for. Cheers, barneyb -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 8:10 AM To: CF-Talk Subject: Dynamically writing/running a CF tag? In CF5, I've written a wrapper for the cfmail tag so that it does multipart emails (HTML + Text + attachments, etc.). Right now, I construct the final cfmail tag as a variable, then I write that variable (the cfmail tag) to a file, then include it, then delete it. This is inefficient, but it is to get around the fact that you can't do things like this: !--- can't conditionally include attributes --- cfmail from=#attributes.from# to=#attributes.to# cfif isdefined(attributes.server)server=#attributes.server#/cfif cfif isdefined(attributes.port)port=#attributes.port#/cfif cfif isdefined(attributes.query)query=#attributes.query#/cfif / Is there some way around the file write/include/delete method? ...Any ideas at all? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamically writing/running a CF tag?
No dice, but that would have been slick. ;-) An unknown attribute 'attributeCollection' has been encountered... :( Thanks, Jamie On Fri, 4 Jun 2004 09:17:53 -0700, in cf-talk you wrote: Have you tried passing attributeCollection to the CFMAIL tag, just like you would to a custom tag or CFMODULE call?I have no idea if it'd actually work, but it's worth a shot, as it would provided exactly the functionality you're looking for. Cheers, barneyb -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 8:10 AM To: CF-Talk Subject: Dynamically writing/running a CF tag? In CF5, I've written a wrapper for the cfmail tag so that it does multipart emails (HTML + Text + attachments, etc.). Right now, I construct the final cfmail tag as a variable, then I write that variable (the cfmail tag) to a file, then include it, then delete it. This is inefficient, but it is to get around the fact that you can't do things like this: !--- can't conditionally include attributes --- cfmail from=#attributes.from# to=#attributes.to# cfif isdefined(attributes.server)server=#attributes.server#/cfif cfif isdefined(attributes.port)port=#attributes.port#/cfif cfif isdefined(attributes.query)query=#attributes.query#/cfif / Is there some way around the file write/include/delete method? ...Any ideas at all? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamically writing/running a CF tag?
On Fri, 4 Jun 2004 11:20:25 -0400, in cf-talk you wrote: From: Jamie Jackson In CF5, I've written a wrapper for the cfmail tag so that it does multipart emails (HTML + Text + attachments, etc.). Right now, I construct the final cfmail tag as a variable, then I write that variable (the cfmail tag) to a file, then include it, then delete it. This is inefficient, but it is to get around the fact that you can't do things like this: !--- can't conditionally include attributes --- cfmail from=#attributes.from# to=#attributes.to# cfif isdefined(attributes.server)server=#attributes.server#/cfif cfif isdefined(attributes.port)port=#attributes.port#/cfif cfif isdefined(attributes.query)query=#attributes.query#/cfif / Is there some way around the file write/include/delete method? ...Any ideas at all? I'm not sure about QUERY, but I'm pretty certain that SERVER and PORT can be left blank Nope, just tried it. If the attributes are present, it expects valid values. I could probably determine the defaults for some of these (using maybe cfregistry to get the default mail server, etc.), but I think it might approach the overhead of the write/include/delete method. Thanks for the feedback, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dynamically writing/running a CF tag?
Hmm, that's one I hadn't thought of. However, I don't think I'm up for writing all those combos logic (though your solution would execute faster). I award you 50 creativity points. Thanks for the idea, Jamie On Fri, 04 Jun 2004 14:16:56 -0600, in cf-talk you wrote: Here's a silly thought... Why not create several templates with your cfmail tag, but each one with a different combo of attributes? Then you simply call the appropriate template based on what attributes you've got for that particular send. I don't know how many different attributes you've got to deal with, hence can't say how many different combos it would result in... Either that, or have default values for those attributes that you use if you don't have values coming from whatever source. So if you had a 'server' var, you'd use it, but if not, use '127.0.0.1' (for itself) or some other value as a default outgoing server. That would solve some issues. --Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Session Variables Suddenly Stopped Working
Sounds like a change was made from the CF Admin -- a change that now requires you to lock shared scopes. Locking Server/Application/Session scope Full Checking would do this, I think. If you have to live with this global change in the CF Administrator (shared host, or something), then lock all of your application/session scope reads with read-only locks and lock all of your application/session scope writes with exclusive locks. Same with server scoped vars, though those are fairly unusual. Jamie On Thu, 03 Jun 2004 15:13:56 +, in cf-talk you wrote: I played with some of the error handling and was able to get a little more information. The message says Application.applicationName is in a scope that contains data shared across threads and cannot be accessed without an active lock. I know very little about session variables and locking.Does that mean the problem is with the lock itself? From: KeAnne Hoeg [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Session Variables Suddenly Stopped Working Date: Thu, 03 Jun 2004 10:45:57 -0400 I inherited a site that uses session variables to track users' paths through the site and to handle the Admin login section.The code worked fine until yesterday when it suddenly stopped working.The only information I get is Processing Error.Does anyone have any idea why it suddenly stopped working?One of the admins was able to log in as recently as 6/1. Here's the code in the Application.cfm file: cfapplication name=solarcenter sessionmanagement=Yes clientmanagement=Yes applicationtimeout=#createTimespan(0,0,90,0)# sessiontimeout=#CreateTimespan(0,0,90,0)# cflock name=#APPLICATION.applicationName# type=Exclusive timeout=20 throwontimeout=Yes !--- If Session-Tracker does not exist, generate it --- cfparam name=APPLICATION.SessionTracker default=#StructNew()# !--- Log current user --- cfscript sUserInfo = StructNew(); sUserInfo.Address=#CGI.REMOTE_ADDR#; sUserInfo.CFID=#session.cfid#; sUserInfo.Token=#session.cftoken#; sUserInfo.Address=#CGI.REMOTE_ADDR#; sUserInfo.Time=#Now()#; sUserInfo.Template=#CGI.CF_Template_Path#; ID = #session.cfid##session.cftoken#; /cfscript cfset dummy = StructInsert(APPLICATION.SessionTracker, ID, sUserInfo, true) /cflock [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_ConsoleCommand and CFX_Execute
I'm trying to find an alternative to cfexecute (which doesn't work well with some commands, I've found), and I'm now looking at CFX_ConsoleCommand and CFX_Execute (both at http://www.intrafoundation.com/coldfusion.html). Two questions: How do these tags differ, and what do I do with the downloads? It looks like they're in C++ source code, which I don't know how to configure and compile, etc. Is this really what I'm expected to do? Can anyone compile these for me and send me the dll, or is that not even possible? Any tips? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFX_ConsoleCommand and CFX_Execute
On Wed, 2 Jun 2004 17:07:04 +0100, in cf-talk you wrote: Your install them as CFX custom tags. They do come with the DLL. you need. Ack, you're right. I was looking in subdirectories that I thought were the root. :-/ If you mail me off list I can send you an Updated DLL what will allow you to get Output 1 2 out in the return. Okay, once I figure out what that means (and if I need it), I'll send you an email. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Troubles with cfexecute
Hi Pete, The output file thought crossed my mind, too, but I don't think that's it. Check out your processes right when you run your command, and you'll see the vspider process die an early death (that is, if we're in the same boat). (My problem is with early vspider process termination, rather than a real hang.) If you find anything out, please let me know, and I'll do the same. Corrections to my original post, FWIW: It turns out I haven't tested the command using cfx_execute yet (having problems calling it), so I've really only tested using cfx_exec and cfexecute. Also, it also turns out that we temporarily changed the CF Application service to use a *domain* admin account, as opposed to a local admin account. Thanks, Jamie On Wed, 26 May 2004 17:44:32 -0400, in cf-talk you wrote: Jamie, We're in the process of developing a K2-based search engine populated by vpsider, and I've ran into similar problems as well. While I haven't tested it enough to say so with any certainity, I have noticed that the vspider process hanging does seem to be roughly coincident with me opening the specified output text file while vspider is still running. I'm planning to do some more testing myself tomorrow, but I would suggest running it again via cfexecute, but then (if you haven't taken this precaution already) not opening the output file until the last modified time stamp hasn't changed for several minutes. Pete - Original Message - From: Jamie Jackson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 26, 2004 11:56 AM Subject: Troubles with cfexecute [CF5/Win2k] I'm trying to run Verity Spider (vspider.exe) commands using cfexecute. Some of the commands stop mid-way through, and the process dies. I am using batch files to keep the cfexecute as uncomplicated as possible, and I'm also using long timeouts, as well as output files. The same batch files work like a champ from the command line itself, but as I stated, they hang early in the process, and then the process dies. I've tried the commands using cfx_exec and cfx_execute with the same results, which led me to believe it was somehow a permissions issue. We then changed the CF Application service's account to use local admin, and that's having the same problems. It just seems that no matter how I try to get CF to execute this batch file, it just dies under the influence of CF itself. So... Any idea why this is happening? Also, does anyone know a good way to execute a batch file in some other creative way from a browser, or some other way to insulate the execution of the command from whatever's causing it to fail? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Troubles with cfexecute
[CF5/Win2k] I'm trying to run Verity Spider (vspider.exe) commands using cfexecute. Some of the commands stop mid-way through, and the process dies. I am using batch files to keep the cfexecute as uncomplicated as possible, and I'm also using long timeouts, as well as output files. The same batch files work like a champ from the command line itself, but as I stated, they hang early in the process, and then the process dies. I've tried the commands using cfx_exec and cfx_execute with the same results, which led me to believe it was somehow a permissions issue. We then changed the CF Application service's account to use local admin, and that's having the same problems. It just seems that no matter how I try to get CF to execute this batch file, it just dies under the influence of CF itself. So... Any idea why this is happening? Also, does anyone know a good way to execute a batch file in some other creative way from a browser, or some other way to insulate the execution of the command from whatever's causing it to fail? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Troubles with cfexecute
On Wed, 26 May 2004 11:56:36 -0400, in cf-talk you wrote: [CF5/Win2k] I'm trying to run Verity Spider (vspider.exe) commands using cfexecute. Some of the commands stop mid-way through, and the process dies. I am using batch files to keep the cfexecute as uncomplicated as possible, and I'm also using long timeouts, as well as output files. edited for clarity The same batch files work like a champ from the command line itself, but as I stated, cfexecute commands hang early in the process, and then the process dies. /edited for clarity I've tried the commands using cfx_exec and cfx_execute with the same results, which led me to believe it was somehow a permissions issue. We then changed the CF Application service's account to use local admin, and that's having the same problems. It just seems that no matter how I try to get CF to execute this batch file, it just dies under the influence of CF itself. So... Any idea why this is happening? Also, does anyone know a good way to execute a batch file in some other creative way from a browser, or some other way to insulate the execution of the command from whatever's causing it to fail? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Problem with CFEXECUTE
On Wed, 26 May 2004 16:06:43 -0400, in cf-talk you wrote: Hi, Is there any way I can specify the work directory for a program executed via CFEXECUTE? I'm trying to execute PKZIP to unzip files, but files are unzipped into C:\windows\win32 which is not where the PKZIP program is and definitely not where I want the files to be stored. I can`t find any parameter in PKZIP either to specify this directory. How about a batch file that you run from cfexecute? c: cd blah\blah\unzipDirectory c:\program files\pkzip\pkzip %1 Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dots in variable names behaving unexpectedly
Can someone give me the lowdown on why... registrant.emergencyPhone.Phone.countryCode = 1; ...is equivalent to... registrant[emergencyPhone][Phone][countryCode] = 1; Is this new in CFMX? I used to name variables with dots in them to sort of give pseudo-scopes to groups of variable. Maybe it's always behaved this way, but I never had occasion to dump one? This has very strange consequences when doing something like this (please try running this form yourself): form action="" method=post input type=hidden value=123 name=blah.blee.bloo input type=submit name=submit value=submit /form cfscript form.blah.blee.bloo = 234234; /cfscript cfdump var=#form# The dump shows both variables in the form scope, but shows the true, posted form variable as a simple variable (blah.blee.bloo), but the locally set form variable is a structure of structures. I guess the lesson is not to have dots as delimiters in form vars anymore, but can someone explain what's at work here? Also, can I (and should I) always expect that this dot notation for structures will work, and can I start using (and relying on) that notation? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
isSimpleType() ?
Does anyone know of an existing function that determines whether a var is either a complex or simple datatype? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cached views
On Fri, 5 Mar 2004 07:58:15 -0600, in cf-talk you wrote: - Original Message - From: Jamie Jackson I don't know if this is related, but if I've got a view (using *) that depends on other views, and I alter a sub-view, I get column caching even directly within enterprise manager. I put a utility in my app to call a view cache-clearing sproc to rememedy this. Hm... These views do depend on sub-views. But, the views themselves aren't using *, just the cf queries calling the views. I'd still be interested in your view cache-clearing sproc, though. Sorry, I didn't see your reply until now. This is the sproc I made to clear views. Now that I look at it, it refreshes all the views on the server, so you'll probably want to restrict it to a single database... Jamie CREATE PROC sp_RefreshAllUserViews AS DECLARE @ViewName varchar(255) DECLARE ViewCursor CURSOR FOR SELECT TABLE_NAME FROM information_schema.views WHERE not table_name like 'sys%' OPEN ViewCursor FETCH NEXT FROM ViewCursor INTO @ViewName WHILE @@fetch_status = 0 BEGIN exec sp_refreshview @ViewName PRINT 'Refreshed ' + @ViewName FETCH NEXT FROM ViewCursor INTO @ViewName END CLOSE ViewCursor DEALLOCATE ViewCursor GO [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Clearing all Cached Queries (Attn: Ray C.)
Ray, You told me once of a way to clear out all cached queries at once, but I'll be darned if I can find the thread. Would you please repeat? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC: Non-native argument types and returntypes?
I'm not having much luck restricting cffunction's returntype to custom data types (e.g. FooObject). Likewise, I can't specify a custom data type as a cfargument type. The only place I seem to be having luck in this regard is in my init() methods, where I'm returning this, and specifying the appropriate cffunction returntype. For now (with the exception of the properly restricted init() method), I'm opening up these attributes by using the type any wherever I'm passing around a custom data type. What's the trick to restricting input and output to custom types? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Non-native argument types and returntypes?
On Thu, 18 Mar 2004 09:16:08 -0600, in cf-talk you wrote: Can you show us your code? I've had no issue using custom types. One thing to remember - If I can't get it going, I'll try to condense the code to the problem area. If your CFC method has a returnType of dog, but the CFC itself doesn't know what dog is - ie, maybe it's in a different package, then you should switch your returnType to contain the full path to dog, ie, soemthing like com.animals.fourlegged.smelly.dog I tried that, but I'll give it another shot. Thanks for the tip, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Paragraphformat tag and the like
On Wed, 17 Mar 2004 12:28:55 -0500, in cf-talk you wrote:
Question.
I have an issue where when I use the CF paragraphformat function my last
line gets a p/p, even if I trim the textarea field first.
I think trim handles whitespace, but not control characters. You might
need to do something like this instead of trim():
cfscript
function superTrim (str) {
return rereplace(str, ([[:cntrl:]]|[[:space:]])+$, , all);
}
/cfscript
cfoutput
#paragraphFormat(superTrim(myQuery.myField))#
/cfoutput
Jamie
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CF OO: Help with implementing DB-persisted object inheritance (i.e. the SQL aspect)
Say I've modeled the inheritance in this manner (table per class): http://www.agiledata.org/essays/mappingObjects.html#MapEachClassToTable I'm having a tough time figuring out how to join a (subclass's) table whose name comes from a column value. Assuming this is the right way to go about it, how would I join the Person superclass to the Employee subclass? Person -- IDNameType 1Jamie JacksonEmployee -- used in join -- Employee -- IDSalary 1100.00 -- I can't just do... SELECT t1.Name, t2.Salary FROM Person t1 LEFT JOIN Employee t2 t1.Id = t2.Id WHERE t1.ID = 1 ... Since I don't know the (Employee) table name until after a query. Is there a SQL (preferably vanilla) trick to doing this dynamic join in a single query, or do I have to use multiple queries (or sprocs)? Alternatively, should I wimp out and use views (which would likely be reused for reporting)? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF OO: Help with implementing DB-persisted object inheritance (i.e. the SQL aspect)
Nevermind. This stuff's starting to come into focus now. Jamie On Tue, 16 Mar 2004 10:27:31 -0500, in cf-talk you wrote: Say I've modeled the inheritance in this manner (table per class): http://www.agiledata.org/essays/mappingObjects.html#MapEachClassToTable I'm having a tough time figuring out how to join a (subclass's) table whose name comes from a column value. Assuming this is the right way to go about it, how would I join the Person superclass to the Employee subclass? Person -- IDNameType 1Jamie JacksonEmployee -- used in join -- Employee -- IDSalary 1100.00 -- I can't just do... SELECT t1.Name, t2.Salary FROM Person t1 LEFT JOIN Employee t2 t1.Id = t2.Id WHERE t1.ID = 1 ... Since I don't know the (Employee) table name until after a query. Is there a SQL (preferably vanilla) trick to doing this dynamic join in a single query, or do I have to use multiple queries (or sprocs)? Alternatively, should I wimp out and use views (which would likely be reused for reporting)? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFCs: Overloaded Constructors ?
What are some workarounds for (pseudo-) overloading constructors in CFMX 6.1? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help me figure out cfexecute problem?
On Fri, 12 Mar 2004 20:38:22 -0500, in cf-talk you wrote: I'm not sure how to debug this, as I'm pretty much out of ideas. I'd think it a permissions problem, if it weren't for the facts: AFAIK, all the necessary resources seem to be read/written/executed: 1. the command runs (but halfway, then hangs) 2. the output file is written (halfway) 3. the config file is read in (otherwise, the command wouldn't even get started) Perhaps the timeout value isn't long enough? I've got the cfexecute timeout set for 10 minutes (600). This should be plenty, considering that when run from directly from the command line, the same command completes in ~30-60 seconds. Can you think of any (environmental or other) differences between a cfexecute-run command and a directly-run command? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFCs: Overloaded Constructors ?
Okay, pretty much what I figured. Thanks for the confirmation, Jamie On Mon, 15 Mar 2004 12:07:43 -0800, in cf-talk you wrote: You can have one method that has optional arguments for the different variations on the overloaded method.For each valid argument combination, you can run separate code, maybe even a separate private method for each. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 11:55 AM To: CF-Talk Subject: CFCs: Overloaded Constructors ? What are some workarounds for (pseudo-) overloading constructors in CFMX 6.1? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: cfqueryparam analog in Java
I had the (not so?) bright idea of using Java as the Model in an MVC app (with CF for the View and Controller). I started to program the DB layer, and rediscovered, by contrast, how easy CF made every aspect of queries, especially the functionality handled by cfqueryparam. What that single tag does with NULLs, single-quoting, data binding, special character escaping by DB type, inherent security, etc., is pretty darn remarkable. As I sit here second-guessing the Java decision, I'm wondering if there's anything remotely as high-level as cfqueryparam in the Java world. Does anybody know? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: cfqueryparam analog in Java
On Fri, 12 Mar 2004 12:30:11 -0800, in cf-talk you wrote: As I sit here second-guessing the Java decision, I'm wondering if there's anything remotely as high-level as cfqueryparam in the Java world. Does anybody know? Not sure what you are trying to do, or if you are doing this already, but you could use a PreparedStatment. Here are some examples: http://www.fluffycat.com/java/JavaNotes-PreparedStatement.html I assume you are hitting the database via jdbc in your classes Yes, that's exactly what I was looking for. It also explains the debug output of queries when using cfqueryparam. ;) Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help me figure out cfexecute problem?
I'm having a problem with one command when run with cfexecute. The command runs to completion when run from the machine's command line, but when run from cfexecute the command runs for a little while, then hangs. Here is the command: cfexecute name=C:\CFusionMX\lib\_nti40\bin\vspider arguments=-cmdfile C:\cygwin\var\www\arc\admin\search\scripts\index.txt outputfile=C:\cygwin\var\www\arc\admin\search\output\indexOutput.txt timeOut=600/cfexecute I've also put the above into a batch file, which runs fine from the command line, but exhibits the same behavior as the above. I'm not sure how to debug this, as I'm pretty much out of ideas. I'd think it a permissions problem, if it weren't for the facts: AFAIK, all the necessary resources seem to be read/written/executed: 1. the command runs (but halfway, then hangs) 2. the output file is written (halfway) 3. the config file is read in (otherwise, the command wouldn't even get started) Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cached views
I don't know if this is related, but if I've got a view (using *) that depends on other views, and I alter a sub-view, I get column caching even directly within enterprise manager. I put a utility in my app to call a view cache-clearing sproc to rememedy this. However, if you don't want to go that far, and you aren't doing query caching, maybe you could do something like this to guarantee freshness? (This is based on your own workaround.) blah = createUUID(); // or gettickcount(), or something SELECT * FROM Y WHERE '#blah#' = '#blah#' Jamie On Thu, 4 Mar 2004 16:08:05 -0600, in cf-talk you wrote: Hey All, So, I've discovered that CF seems to be caching queries whether or not I want it to. So, for instance, I have a query like so: SELECT* FROMY If Y is a view and I change the view to add a new column, I have to add something like WHERE 1=1 to force it to see the new view. If I take the WHERE 1=1 back off, it reverts to the old view again. We don't have trusted cache turned on. This is on a dev box, set up to be as dynamic as possible. Does CFMX internally convert the * to a column list that gets cached? (Yes, yes, I know that * is not a best practice unless you're really using all the columns. But, really, I'm using all the columns. Every single one. All 86 computed columns of the query. That's why I created the view.) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OOAD and CFCs?
Excellent information. I don't know if you blog, or otherwise make your experiences known, but I'd be very interested to know how the Java/CFML Mach-II hybrid turns out, and what you learn from the project. Thanks very much for your feedback. Jamie On Tue, 02 Mar 2004 16:13:52 -0800, in cf-talk you wrote: Jamie, I'm currently implementing a client project in Mach-II using CFCs for the Controller-View and Java for the Model. So far I'm pretty happy with the way things are coming together. I too found the incomplete OO implementation of CFCs frustrating (particularly the lack of interfaces) and prefer modeling the business rules and objects in Java. CF is much better on the front-end however and can run rings around JSPs. I've found Mach-II a good framework for melding the two together. Here are the gotchas I've found so far in using Java w/ CF: - the Java classes must reside in the CF web root, or possibly in a classpath defined in the CF administrator. That has a couple consequences: 1. you can't run your hybrid apps on a shared host 2. you have to be careful with naming conventions and shared classes between apps because all the classes will reside under the same root. Not as neat and tidy as pure Java web apps. - supposedly changes to classes placed in webroot/WEB-INF/classes are automatically picked up by CF, but I have not found this to be the case. Instead, I'm finding I have to stop-start CF after every change for the changes to be recognized. Big hassle. Fortunately, I'm used to doing TDD w/ JUnit, so the code gets tested pretty thoroughly in Java before moving it into the app. - CF uses log4j 1.1.3, so your Java code must too. Big bummer, particularly since log4j 1.3 purportedly will resolve a log archiving problem on Windows. Also, this suggests the possibility of big conflicts down the road. If my Java code uses a third-party library and a future release of CF incorporates a different version of that library, it seems very possible that my code will no longer work if the api of CF's version of the library is different. I'm still early in the process of using Mach-II and using CF and Java together, but so far both seem promising. Dave Jones NetEffect At 05:47 PM 3/2/04 -0500, you wrote: After having been asked to extend one too many spaghetti-code procedural applications, I have started to suspect that there *is* something to the idea of OO. I am now anxious to try this out (probably with Mach-II, for lack of a better idea), but I am concerned that some of my OOAD using UML training will become invalidated by CFCs' incomplete implementation of OO. My question is pretty vague at this point, but I'm wondering what to look out for, with regard to OOAD and its implementation in CFCs. Also, I'm wondering if there's some sort of Java as the Model / CFMX as the View and Controller approach that I should consider (what ever became of Mach-II for Java, BTW?) Another side question: Can anyone recommend any references for how to go about implementing the Class Model in code (as well as its interaction with RDB-persisted data)? Any feedback, links, suggested reading, etc., is appreciated. Thanks, Jamie -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC location issues
On Tue, 2 Mar 2004 09:14:34 -0800, in cf-talk you wrote: As I was driving in to work today, I thought to myself, Gee Barney, Java has the perfect solution to this, the CLASSPATH, why doesn't CF have one of those?So I thought I'd pass the idea around, and see what people thought before I go running to Macromedia.I'm not sure the best way to implement it, but the CFAPPLICATION tag seems like a prime candidate: cfapplication cfcpath=/path/to/dir,/other/dir / Then you could define the search path for CFCs at the application level (where it really ought to be, IMHO), rather than at the server instance level (which only works for dedicated instances, where server and app are the same level).That would also let you define the search path with your application config, rather than the server config, which has benefits, at least to me. Still have to have the server-level mappings and whatever else, but this would put control of CFCs back in the developer's hands, not in the server admins. What do people think about that kind of solution?I think it's a good one, but then I thought of it. Sounds very similar to this thread (which discusses app-specific custom tag directories): http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesThreadID=30147forumid=4#151236 Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OOAD and CFCs?
After having been asked to extend one too many spaghetti-code procedural applications, I have started to suspect that there *is* something to the idea of OO. I am now anxious to try this out (probably with Mach-II, for lack of a better idea), but I am concerned that some of my OOAD using UML training will become invalidated by CFCs' incomplete implementation of OO. My question is pretty vague at this point, but I'm wondering what to look out for, with regard to OOAD and its implementation in CFCs. Also, I'm wondering if there's some sort of Java as the Model / CFMX as the View and Controller approach that I should consider (what ever became of Mach-II for Java, BTW?) Another side question: Can anyone recommend any references for how to go about implementing the Class Model in code (as well as its interaction with RDB-persisted data)? Any feedback, links, suggested reading, etc., is appreciated. Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFID/CFTOKEN newbie question
You have to pass around cfid/cftoken in the URL, but I believe that URLSessionFormat() will take some of the tedium out of it: http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt2113.htm#4471249 Jamie On Tue, 2 Mar 2004 16:25:11 -0500, in cf-talk you wrote: Is there a best practice for handling CFID/CFTOKEN for browsers w/o cookies? Thanks, Howie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
