Re: alternatives to cfcontent to allow large downloads
Instead of using CFCONTENT, you can use CF to create a temporary URL, then let your web server serve the file directly. For example, you could use CFEXECUTE to create a symlink to a directory containing the file, then after an hour (or whatever time you deem appropriate) you could delete the symlink. Thanks Dave. After a bit of Googling, it appears you have answered a similar question at a previous time. You mentioned using the Junction sysinternals tool to do this. I could not find that thread on houseoffusion.com, but here it is in another mail archive site: http://www.mail-archive.com/cf-talk@houseoffusion.com/msg253608.html. Looks like this might work the best for the current setup. For the future though, I guess I also want to use this opportunity to ask if people have had good experiences in general with using the Amazon S3 service. Barney seems to like it a lot, but are there any major gotchas? Thanks, George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfthread with a cffile upload
Chad, As an aside, we went down many routes for large file uploads. HTTP is simply not built for that. We finally went with an embedded FTP Java client that simplified our lives a great deal. For reference, we went with this one: http://www.utechsoft.com/products/uupload/webdemo/cart/ HTH, George On Fri, Jun 6, 2008 at 2:51 PM, Chad Baloga [EMAIL PROTECTED] wrote: Any way to upload it without loading it into memory? I know the flash form file upload will do it, but I'm working with some code that is unable to do that. Trying to find a way to upload big files faster. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
alternatives to cfcontent to allow large downloads
Hi all, CFMX 7 Enterprise on IIS and Win 2003. Relatively medium traffic website, probably about 200 or so downloads a day, ranging from 1MB to 1GB or so. This is expected to double every 3 months or so. I read that cfcontent utilizes a single thread for the duration of a file download. I also read Ben Nadel's post here: http://www.bennadel.com/index.cfm?dax=blog:1226.view on sidestepping some of that. There was a bit of discussion about using x-sendfile with lighthttpd and Apache, but I don't have that option since I am condemned to IIS. The question is: are there any other alternatives? I could initialize another instance and make it handle only the download requests, but can't really guess at the long-term viability of that. Thanks, George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: alternatives to cfcontent to allow large downloads
On Mon, Jun 9, 2008 at 3:02 PM, Barney Boisvert [EMAIL PROTECTED] wrote: Use a content delivery network (CDN) or something like Amazon S3. CDNs are usually targeted at large-scale anonymous access, which is not quite what you want. S3, on the other hand, is private by default, and can easily be accessed by secured URLs that are only accessible for a narrow window of time. So someone requests your asset, and instead of serving it with CFCONTENT, you redirect them to S3 with a URL that's only good for a handful seconds. I do this for a few different things, and it works like a charm. It also offloads the bandwidth from my infrastructure to Amazon's. I could look, but what does S3's usage policy say about that kind of offloading? Does that also mean that the application now also has to maintain assets in 2 different places? Some of my users would really balk at that. But an intriguing suggestion, nonetheless. You might be able to synthesize something like this with IIS, as well. It won't server a given asset unless it has some one-time or short-lived token attached to the URL. Set that up to protect your downloads, and then do the same compute token/redirect thing to your own IIS server and let it serve the file instead of CF. This seems more in line with keeping things in-house. I like that. Any pointers to where I could start? Or what I should google? :-) Thanks, George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: alternatives to cfcontent to allow large downloads
On Mon, Jun 9, 2008 at 12:34 PM, George Abraham [EMAIL PROTECTED] wrote: I could look, but what does S3's usage policy say about that kind of offloading? This use case is exactly the point of S3's existence. It's redundant, scalable, and ridiculously inexpensive. OK, I got off my butt and actually read through some of the stuff. Pretty impressive. Does that also mean that the application now also has to maintain assets in 2 different places? Some of my users would really balk at that. But an intriguing suggestion, nonetheless. Well, it'd be one place, on S3. No need to keep them on your infrastructure at all. There are privacy concerns, for sure, but again, S3 is designed for this use case. If the perception that Amazon's IT team is less trustworthy than the IT team at wherever your servers are located, can't help you there. ;) Hehehe, you got that right. The key there is the word 'perception.' Thanks, George ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Create PowerPoint Files
Todd, We now use Aspose (after having looked into as many alternatives as we could.) It is a pretty good piece of work and the support is pretty good too. George On 6/28/07, Todd Mathews [EMAIL PROTECTED] wrote: Thanks for the suggestion. We looked at HSLF initially but it is still a work in progress and doesn't have everything we need. Looks like we'll be doing some digging into Aspose. It's amazing how difficult PPT is to work with despite being so popular. -Original Message- From: Heald, Timothy (NIH/CIT) [C] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 8:39 AM To: CF-Talk Subject: RE: Create PowerPoint Files POI, one of the Apache projects contains Java objects to allow you to create all different kinds of M$ format documents. The specific part of it for PowerPoint is HSLF. http://poi.apache.org/hslf/index.html -- Timothy J. Heald | NIH-Contractor | iGate Enterprise Business Intelligence Branch (EBIB) Division of Enterprise and Custom Applications, CIT/NIH/DHHS Office: 301.594.5611 | Fax: 301.443.7010 | Email: [EMAIL PROTECTED] -Original Message- From: Todd Mathews [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 7:43 PM To: CF-Talk Subject: Create PowerPoint Files We need to be able to create PPT file output from CF. Has anyone else done this that can share any info? We're looking at the Aspose components and would love to hear from anyone else who has used them or might have some CF centric sample code. It is amazing how difficult it is to write PPT files. We'd be in heaven if we could simply change the output type of a .cfr file to crank out the PPT docs since we already use it for the PDF version. Unfortunately it isn't that simple so it looks like we'll be using Aspose to do the job and code the output 'old school' to generate the PPT report. If anyone has any better suggestions or experience with Aspose, please share! ;) Todd ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SSL Domain redirect without error message
Victor, If you do have access to the web server's configuration, why not define a site called https://xyzdomain.com and then have a single page in the home directory there that redirects to the correct site: https://www.xyzdomain.com? I usually have a single such directory that I have all such sites point to and there I have a index.cfm page that essentially has this code: cfif ListFirst(CGI.HTTP_HOST,.) NEQ www cflocation url=https://www.#CGI.HTTP_HOST#') addtoken=No /cfif or some similar type of code. Other people may have better solutions though. HTH George On 4/17/07, Victor Moore [EMAIL PROTECTED] wrote: Hi, I have the following scenario: site: https://www.xyzdomain.com has a valid SSL certificate if users type https://xyzdomain.com they get invalid cert error. What is the best way to do a redirect (from https://xyzdomain.com to https://www.xyzdomain.com https://xyzdomain.com/ ) without getting an error. One possible solution (I think) is to have a redirect file (basically a js script) and then pointing the 403.4 message to this file (not tested yet). Are there any other solutions? Thanks Victor ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SSL Domain redirect without error message
Hmm, that is true, the middle site would also have to have the SSL cert cover it. George On 4/17/07, Victor Moore [EMAIL PROTECTED] wrote: Hi George, Thank you for your response. Unfortunately it won't work (as far as I can tell). I am ding a redirection now, but the message pops up before the redirection occurs. Either I'm doing something wrong or the only way to do it is to get a wild card ssl certificate that covers both domains : www.xyzdomain.com and xyzdomain.com https://www.xyzdomain.com/ Thanks Victor On 4/17/07, George Abraham [EMAIL PROTECTED] wrote: Victor, If you do have access to the web server's configuration, why not define a site called https://xyzdomain.com and then have a single page in the home directory there that redirects to the correct site: https://www.xyzdomain.com? I usually have a single such directory that I have all such sites point to and there I have a index.cfm page that essentially has this code: cfif ListFirst(CGI.HTTP_HOST,.) NEQ www cflocation url=https://www.#CGI.HTTP_HOST#') addtoken=No /cfif or some similar type of code. Other people may have better solutions though. HTH George ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SSL Domain redirect without error message
You know, the best thing to do might be to give them a domain not found error when they enter in xyzdomain.com. That way, they do recheck the address. George On 4/17/07, George Abraham [EMAIL PROTECTED] wrote: Hmm, that is true, the middle site would also have to have the SSL cert cover it. George On 4/17/07, Victor Moore [EMAIL PROTECTED] wrote: Hi George, Thank you for your response. Unfortunately it won't work (as far as I can tell). I am ding a redirection now, but the message pops up before the redirection occurs. Either I'm doing something wrong or the only way to do it is to get a wild card ssl certificate that covers both domains : www.xyzdomain.com and xyzdomain.com https://www.xyzdomain.com/ Thanks Victor On 4/17/07, George Abraham [EMAIL PROTECTED] wrote: Victor, If you do have access to the web server's configuration, why not define a site called https://xyzdomain.com and then have a single page in the home directory there that redirects to the correct site: https://www.xyzdomain.com ? I usually have a single such directory that I have all such sites point to and there I have a index.cfm page that essentially has this code: cfif ListFirst(CGI.HTTP_HOST,.) NEQ www cflocation url=https://www.#CGI.HTTP_HOST#'https://www.#CGI.HTTP_HOST%23%27) addtoken=No /cfif or some similar type of code. Other people may have better solutions though. HTH George ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading params from a file v/s getting them from a file
Thanks for your input Justin. However, I already have a bunch of heavy-duty CFCs running in the application scope. I was thinking that I did not want to increase that load. I also don't know how much is enough in the application scope. I should probably just get something like SeeFusion and go do a bunch of tests. Ah well! George On 4/13/07, Justin Scott [EMAIL PROTECTED] wrote: I'm a bit late on this thread, but if you're reading in site settings on every page request it would make more sense to put them into the application scope instead of the session scope. If you have multiple sites running on the same application you could use a structure to store the data that is read in on the first request (or on application start if using application.cfc) keyed based on the site id. Once read once you won't have to process that data on every request and it will be stored in memory once instead of a new copy for each visitor. -Justin Scott | GravityFree Client Care Special Forces Unit 1960 Stickney Point Road, Suite 210 Sarasota | FL | 34231 | 800.207.4431 941.927.7674 x115 | f 941.923.5429 www.GravityFree.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 2:18 PM To: CF-Talk Subject: Re: reading params from a file v/s getting them from a file Hmm, maybe I can learn some stuff here about session variables. Well, the parameters (and their values) themselves are sizeable in nature. Sort of like defaultTextForMessage='some text 150 characters long' and so on. Is storing them in the session advisable? Thanks, George On 4/12/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 12 Apr 2007, George Abraham wrote: Yes it is read at every request. For example, the navigational menu for every site is different, so the params XML file will have to be read every request to see what the menu items are. The only thing I store in a session variables is an ID identifying the site. Right. Why can't you store the parsed parameters in the session too ? -- Tom Chiverton ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading params from a file v/s getting them from a file
Hmm, maybe I can learn some stuff here about session variables. Well, the parameters (and their values) themselves are sizeable in nature. Sort of like defaultTextForMessage='some text 150 characters long' and so on. Is storing them in the session advisable? Thanks, George On 4/12/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 12 Apr 2007, George Abraham wrote: Yes it is read at every request. For example, the navigational menu for every site is different, so the params XML file will have to be read every request to see what the menu items are. The only thing I store in a session variables is an ID identifying the site. Right. Why can't you store the parsed parameters in the session too ? -- Tom Chiverton ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading params from a file v/s getting them from a file
Yes it is read at every request. For example, the navigational menu for every site is different, so the params XML file will have to be read every request to see what the menu items are. The only thing I store in a session variables is an ID identifying the site. George On 4/12/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Wednesday 11 Apr 2007, George Abraham wrote: Well, this is an application that will be serving multiple websites (with different vHost names.) When a session is initiated with the application, it determines which site it is. Then there are a host of params that are set according to the site. Since these params don't change much, I decided I would cache them periodically in a site-specific XML file and then read that XML file, instead of going to the database to get these params. Yes, Err, right. So you're not reading it at every request (like your first post said) ? -- Tom Chiverton ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading params from a file v/s getting them from a file
Well, this is an application that will be serving multiple websites (with different vHost names.) When a session is initiated with the application, it determines which site it is. Then there are a host of params that are set according to the site. Since these params don't change much, I decided I would cache them periodically in a site-specific XML file and then read that XML file, instead of going to the database to get these params. Yes, the inclusion of the XML file is done in the request initializing code. Does all that make sense? Or am I going about this the wrong way? Thanks, George On 4/11/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 06 Apr 2007, George Abraham wrote: I cannot however set these params in say an application.cfm or any such initializing code. OOI, why not ? ~| 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:275008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
reading params from a file v/s getting them from a file
Hi all, Working with CFMX7 on Windows. I was wondering about the performance differences of using CFFILE to read in an XML settings/params file for every request as opposed to going to the database to get these settings for every request. These settings/params do not change much and even if they do, the changes occur in the off-hours. I cannot however set these params in say an application.cfm or any such initializing code. Thanks, George ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server Error 8179: Could not find prepared statement with handle x
Hi all, One of our CFMX 7 applications (which was working fine before) suddenly started throwing this error - SQL Server Error 8179: Could not find prepared statement with handle x. The funny part is, it throws the error at pretty much any point in the application without any apparent reason in the sequence of code. If I comment out that code, then the some other query code will malfunction the same way with a different value for x. I looked around for solutions, but could not get any usable ones. One thing that worked for us is to increase the maximum number of pooled statements by 1 in the datasource and then the problem went away. However it would be nice to know why the heck it happened in the first place. Thanks, George ~| 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:266038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Server Error 8179: Could not find prepared statement with handle x
Hmm, we did have other problems with the current drivers we are using that was shipped with the product by (then) Macromedia. Mayve we can look at this driver you mention. Thanks, George On 1/9/07, Richard Kroll [EMAIL PROTECTED] wrote: George, We ran into the same problem a few months ago. What we found was the error was thrown on random queries that had CFQUERYPARAMs in them (which was almost every query in our application). Somewhere on the net I found an article explaining that it had something to do with the drivers. We switched our drivers to the jTDS JTDS drivers for MS SQL 2k and the problem went away. HTH Rich Kroll -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 8:38 AM To: CF-Talk Subject: SQL Server Error 8179: Could not find prepared statement with handle x Hi all, One of our CFMX 7 applications (which was working fine before) suddenly started throwing this error - SQL Server Error 8179: Could not find prepared statement with handle x. The funny part is, it throws the error at pretty much any point in the application without any apparent reason in the sequence of code. If I comment out that code, then the some other query code will malfunction the same way with a different value for x. I looked around for solutions, but could not get any usable ones. One thing that worked for us is to increase the maximum number of pooled statements by 1 in the datasource and then the problem went away. However it would be nice to know why the heck it happened in the first place. Thanks, George ~| 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:266044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server Error 8179: Could not find prepared statement with handle x
Thanks, George On 1/9/07, Richard Kroll [EMAIL PROTECTED] wrote: The drivers we used are located at http://jtds.sourceforge.net/ Rich Kroll ~| 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:266062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF7 SQL Server connection problems
Hi Steve, I am running SQL Server 2K with the JDBC drivers provided by Macromedia (as installed with CFMX 7 Server.) George On 12/2/06, Steve Brownlee [EMAIL PROTECTED] wrote: What DB are you running and what driver are you using to connect? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 01, 2006 7:41 AM To: CF-Talk Subject: CF7 SQL Server connection problems Hi, I hesitate to even ask for help for this issue, since it might be really specific to our situation. But here goes. The error message below pops up in our exception logs once in a while. Immediately I look at the database server to see if there were any networking problems, but things are sailing fine there. And the weird thing it that the error might not be thrown at any particular query/stored procedure. It could pop up anywhere. After the error pops up, the JRUN service for this particular CF instance starts taking up lots of CPU time and then all responses are sluggish. Then the only way to bring the server back to normal is to restart the service. Well, I assumed that was the only way. Then I started thinking, maybe there could be a way to clear the database connections without restarting the service. Well, any ideas on what could be causing this error, or how I can mitigate its consequences? Do let me know if you need any other info. Regards, George ~| 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:262618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 SQL Server connection problems
Hi, I hesitate to even ask for help for this issue, since it might be really specific to our situation. But here goes. The error message below pops up in our exception logs once in a while. Immediately I look at the database server to see if there were any networking problems, but things are sailing fine there. And the weird thing it that the error might not be thrown at any particular query/stored procedure. It could pop up anywhere. After the error pops up, the JRUN service for this particular CF instance starts taking up lots of CPU time and then all responses are sluggish. Then the only way to bring the server back to normal is to restart the service. Well, I assumed that was the only way. Then I started thinking, maybe there could be a way to clear the database connections without restarting the service. Well, any ideas on what could be causing this error, or how I can mitigate its consequences? Do let me know if you need any other info. Regards, George Error,jrpp-806,12/01/06,10:02:11,mediamanager,Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: E:\mediamanager\index.cfm, line: 1206 coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:201) at cfpermissions2ecfc1012649645$funcSETGLOBALPERMISSIONBITSFORONEACCOUNT.runFunction(E:\mediamanager\components\permissions.cfc:1206) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:348) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke( UDFMethod.java:258) at coldfusion.filter.FunctionAccessFilter.invoke( FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cffusebox2einit2ecfm1640136274._factor7(E:\mediamanager\fusebox.init.cfm:219) at cffusebox2einit2ecfm1640136274._factor8(E:\mediamanager\fusebox.init.cfm:1) at cffusebox2einit2ecfm1640136274.runPage (E:\mediamanager\fusebox.init.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cffusebox42eruntime2ecfmx2ecfm830196681._factor12(E:\mediamanager\fusebox4.runtime.cfmx.cfm:170) at cffusebox42eruntime2ecfmx2ecfm830196681._factor16(E:\mediamanager\fusebox4.runtime.cfmx.cfm:2) at cffusebox42eruntime2ecfmx2ecfm830196681._factor17(E:\mediamanager\fusebox4.runtime.cfmx.cfm:1) at cffusebox42eruntime2ecfmx2ecfm830196681.runPage (E:\mediamanager\fusebox4.runtime.cfmx.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfindex2ecfm1672779347.runPage(E:\mediamanager\index.cfm:9) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java :210) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke( ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke( RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java :78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java :257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java :541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable( ThreadPool.java:426) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~| 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:
SOT: card reader to interface with web browser
Hi, Is there any way a card reader (for id card swipes) can interface with a web browser that is running a web application? Or do we have to write special client software for the interface? We could run this using ActiveX controls on the client-side browser too, I guess. Thanks, George ~| 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:247516 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: XML storage of metadata in database fields
All, I tried searching for information on this, but I am probably not searching for the right jargon. We have an application that allows users to specify (at initial setup time) to specify what kind of metadata they want to enter when they work with digital media within the application. For example, one user may want to upload a bunch of Word doc files and then enter a set of metadata (say Title, Description, Source, Location, etc.). Another user may want to enter a combination of images, docs and movie files and then enter a different set of metadata (say Title, Description, Period, Style, Location, Dates, Sequence, etc.) If we go the traditional database route, this would involve lots of dynamically named fields which I envision as really messy. We think that storing these individual metadata sets as XML data (keyed to ID fields in the db) would be the way to go. Does anybody have any experience/thoughts on this approach? It would be really nice to read any articles or whitepapers on this too. Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245053 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: XML storage of metadata in database fields
On 6/29/06, Nick de Voil [EMAIL PROTECTED] wrote: I think the key question is, what are you going to use the metadata for? If you are going to want to use metadata fields for searching/sorting/analysis, I would go with the traditional database route. This is what we do in our CMS. A little complicated maybe - you need a lot of tables to get a really flexible solution - but not messy. Yes we will be using these metadata fields, maybe not as much for sorting, but definitely for searching. We do use a different searching mechanism that is not tied to the db at all, except to the primary key. If the metadata of each set of objects is of interest only as a sort of guide to that set of objects in isolation once retrieved from the repository, and particularly since you mention Sequence, then your idea is a bit reminiscent of a manifest file that you attach to objects in an object packaging scheme like IMS Content Packaging, which is a desperately complicated e-learning interoperability standard but you might be interested in some of the concepts: http://www.imsproject.org/content/packaging/cpinfo10.html http://www.imsproject.org/metadata/mdbest01.html Actually Nick, one of the requirements of this project (at least down the line) is to be able to export the set of objects as a learning object using IMS. So yes, I am a bit familiar with that. George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245057 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: XML storage of metadata in database fields
Dov, thanks for this. Any readings on approach 4? George On 6/29/06, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: There are several approaches to solving this type of problem, imho, and each one has costs and benefits, and I've given each of them a report card (A being best, F being worst): 1) Xml into a field (as originally speculated) Benefits: flexible design, structured data once retreived Costs: useless for searching, data not typed, (all strings), storage bloat due to markup DB Normal Design Grade: D Performance Grade: C Dev Ease Grade: A- 2). Create a properties table with 3 fields, ID , key, val and put clustered index on ID and Key, and unclustered index on key Benefits: still flexible, searchable by field Costs: a bit more db complexity, but with proper indexing costs can be minimized. Still all data are strings DB Normal Design Grade: B+ Performance Grade: A- Dev Ease Grade: B 3) Similar to 1 but use java.util.Properties for flat key-value pairs Benefits: somewhat easy to search key=value substrings can be searched for, cheaper than xml if all you want is key val pairs (xml more flexible in terms of design of data) Costs: most of the same costs as xml DB Normal Design Grade: D Performance Grade: B- Dev Ease Grade: B+ 4). Improve #2 above with 3-4 properties table, one for date vals, one for numeric , one for strings etc Benefit: well designed, normalized, type safe (good for aggregate fcns like sum, avg etc). Performance shouldn't be impacted with smart indexing Costs: more complicated, dao objects would need to run a union query (easiest) or know which tables have which properties (harder, but better, you can let users define their own types which helps you with the ui, and then you'd know what keys belong in what tables) DB Normal Design Grade: A- Performance Grade: B- Dev Ease Grade: C+ 5) Actually let users design tables and columns per object type Benefit: Perfectly normalized DB design, no joins needed to assemble metadata on an object, you can do all aggregate queries, etc, Type Safe Cost:Will complicate the DB, users choices can impact db performance if not careful, Difficult to develop DB Normal Design Grade: A+ Performance Grade: A Dev Ease Grade: D I've done variations of the above and its definitely one of those TMTOWTDI kind of things Hth Dov -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Thursday, June 29, 2006 6:50 AM To: CF-Talk Subject: Re: XML storage of metadata in database fields We have an application that allows users to specify (at initial setup time) to specify what kind of metadata they want to enter when they work with digital media within the application. For example, one user may want to upload a bunch of Word doc files and then enter a set of metadata (say Title, Description, Source, Location, etc.). Another user may want to enter a combination of images, docs and movie files and then enter a different set of metadata (say Title, Description, Period, Style, Location, Dates, Sequence, etc.) If we go the traditional database route, this would involve lots of dynamically named fields which I envision as really messy. We think that storing these individual metadata sets as XML data (keyed to ID fields in the db) would be the way to go. Does anybody have any experience/thoughts on this approach? I think the key question is, what are you going to use the metadata for? If you are going to want to use metadata fields for searching/sorting/analysis, I would go with the traditional database route. This is what we do in our CMS. A little complicated maybe - you need a lot of tables to get a really flexible solution - but not messy. If the metadata of each set of objects is of interest only as a sort of guide to that set of objects in isolation once retrieved from the repository, and particularly since you mention Sequence, then your idea is a bit reminiscent of a manifest file that you attach to objects in an object packaging scheme like IMS Content Packaging, which is a desperately complicated e-learning interoperability standard but you might be interested in some of the concepts: http://www.imsproject.org/content/packaging/cpinfo10.html http://www.imsproject.org/metadata/mdbest01.html Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245058 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: SOT: XML storage of metadata in database fields
On 6/29/06, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 29 June 2006 11:09, George Abraham wrote: We have an application that allows users to specify (at initial setup time) Why not just add the users choice as columns ? Tom, If each user was allowed to specify their metadata fields, wouldn't we land up with a huge number of fields, most of which would be empty? Or am I understanding you wrong? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245060 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: XML storage of metadata in database fields
We do use SQL Server 2000 currently and we had heard that SQL Server 2005 was much better for working with XML. That did factor into our curent thoughts. George On 6/29/06, Snake [EMAIL PROTECTED] wrote: BTW SQL Server now supports XML natively, so if you store XML in the database, you can parse it a lot easier. Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245073 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
changing/adding code to pages within cfide/administrator
Hi, We decided that we would actually follow the directions by Macrodobe that say that you should also independently secure the CF admin within your ColdFusion server. So we did; using another authentication application (IIS-based) that basically protects the directory under which the admin pages resides. However since the authentication application is in essence an organization-wide app, anyone with a valid username and password can still get to the admin pages. Thus we have reduced the set of attackers from the whole world to just the people at our organization. We then wanted to specify a restricted set of users (the authorization component) using the application.cfm within cfide/administrator. However these files are all encrypted (posibly for IP reasons.) What can we do in such a case? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239047 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: changing/adding code to pages within cfide/administrator
Chris, IP-based security is what we looked at first, but we wanted to be a little more flexible. Maybe that is the way to go. Thanks, George On 4/28/06, Peterson, Chris [EMAIL PROTECTED] wrote: George, Be sure you don't block the /CFIDE/ directory completely, as flash based forms and CFFORM's depend on scripts inside that virtual folder. If you are using IIS, you should be able to setup IP or subnet based restrictions on the /CFIDE/administrator folder. We have all admin's in a specific subnet here, so its easy to do for us. I know its not perfect, but it does prevent casual browsing and poking around. If you wanted to be really paranoid, restrict it to only 127.0.0.1, that way you can only ever admin it from the server itself. Be sure to use a strong CF-Administrator password too! Hope this helps, Chris Peterson -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, April 28, 2006 10:44 AM To: CF-Talk Subject: changing/adding code to pages within cfide/administrator Hi, We decided that we would actually follow the directions by Macrodobe that say that you should also independently secure the CF admin within your ColdFusion server. So we did; using another authentication application (IIS-based) that basically protects the directory under which the admin pages resides. However since the authentication application is in essence an organization-wide app, anyone with a valid username and password can still get to the admin pages. Thus we have reduced the set of attackers from the whole world to just the people at our organization. We then wanted to specify a restricted set of users (the authorization component) using the application.cfm within cfide/administrator. However these files are all encrypted (posibly for IP reasons.) What can we do in such a case? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239051 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: multiple uploads and cffile and cfmx instances
OK, the way we managed to 'solve' it was a weird procedure. Apparently this problem stemmed from using a particular IP or domain name. So we got a new domain name, pointed that to a new IP address, created a new JRUN instance and then this worked. Damned weird! George On 3/15/06, George Abraham [EMAIL PROTECTED] wrote: I was wondering if anyone ever encountered this problem which I had posted quite a while ago. If so, any luck resolving it? Some additional info: I tried to use just a single file input in the form. This worked really weirdly. Most times, it would upload part of the file. So if it was an image, it would upload about 25-75% of it and the image showed up cut off at the bottom. About 5 times of tryin to do this, after some time, the dreaded '500 unexpected end of part' error shows up. Thanks, George On 12/13/05, George Abraham [EMAIL PROTECTED] wrote: All, This is a bit of strange bug that we noticed recently. Out infrastructure is on CFMX 7.01 Enterprise with 6 instances of CFMX running on the same IIS server with about 20 websites. I was testing a multiple upload Java applet that was working fine on my small CFMX developer test box. After transferring it to a staging site on the infrastructure, I noticed that the multiple uploads were not working. So I changed the applet to a bunch of HTML inputs (type=file) to see what happened then. The same error happens. The error is this: JRun Servlet error: 500 unexpected end of part I tried everything that I could think of to see if there was a problem in the code. Everytime there was a single upload, it worked. But multiple uploads all crashed. I then transferred the code to another CFMX instance on the same server. And it worked fine without a hitch. So we tried to wipe out the buggy CFMX instance, installed another instance with the same name as that instance and it failed yet again on the multiple uploads. Anybody have any ideas? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237990 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: multiple uploads and cffile and cfmx instances
I was wondering if anyone ever encountered this problem which I had posted quite a while ago. If so, any luck resolving it? Some additional info: I tried to use just a single file input in the form. This worked really weirdly. Most times, it would upload part of the file. So if it was an image, it would upload about 25-75% of it and the image showed up cut off at the bottom. About 5 times of tryin to do this, after some time, the dreaded '500 unexpected end of part' error shows up. Thanks, George On 12/13/05, George Abraham [EMAIL PROTECTED] wrote: All, This is a bit of strange bug that we noticed recently. Out infrastructure is on CFMX 7.01 Enterprise with 6 instances of CFMX running on the same IIS server with about 20 websites. I was testing a multiple upload Java applet that was working fine on my small CFMX developer test box. After transferring it to a staging site on the infrastructure, I noticed that the multiple uploads were not working. So I changed the applet to a bunch ofHTML inputs (type=file) to see what happened then. The same error happens. The error is this: JRun Servlet error: 500 unexpected end of part I tried everything that I could think of to see if there was a problem in the code. Everytime there was a single upload, it worked. But multiple uploads all crashed. I then transferred the code to another CFMX instance on the same server. And it worked fine without a hitch. So we tried to wipe out the buggy CFMX instance, installed another instance with the same name as that instance and it failed yet again on the multiple uploads. Anybody have any ideas? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235486 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: Can moving from cf server 5 to mx7 cause an app to stop working?
Steve, I recently moved an app from CF5 to CFMX7 and I did not have any significant problems. Any chance you could post code/errors? George On 2/26/06, Steve Kahn [EMAIL PROTECTED] wrote: Aaron - good point. I set up a demo on the sql server and did a cfform/ action to insert data and it threw an error. Enterprise manager shows the table exists but has no data entered. Sounds like a server related issue now, but im far from thru the woods on these errors. Thanks Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233519 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: Suggestion for the list
Why not? I learnt a heck of a lot from it! George On 2/17/06, Aaron Roberson [EMAIL PROTECTED] wrote: I can't beleive you guys are still talking about this... -Aaron On 2/17/06, Dave Watts [EMAIL PROTECTED] wrote: I haven't read through the entire thread, but I though the problems were mostly not because people start talking about something irrelevant in the same thread (which you can't solve by programming), but when people reply to an old thread to start a completely new thread (with a brand new subject). The issue was that the same messageid is kept in the headers, and some programs would think it's the same thread. Therefore the message id needs to be stripped out for threads like this and started anew. That sounds somewhat reasonable - I haven't read through the entire thread either. People do, however, legitimately change thread subject line on occasion without changing the actual topic of the thread. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232735 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: passing multiple values from the same form field
Hi, By saying 'I want to pass these options along with the productID and qty', are you saying that when you submit the form, the values are not being passed to the action page? Otherwise Ian's answer about the array notation for form data seems right. In simple terms, the radio button for option1 will be named form.option1(when the action page sees it) and it's value will be #form.option1#. If you know the total number of options, you can loop through that number like so (not tested): cfloop from=0 to=thatNumber index=thisNumber cfif StructKeyExists(form,'option#thisNumber#') cfset whateverVariable = #form[option thisNumber]# /cfif /cfloop George On 2/3/06, j s [EMAIL PROTECTED] wrote: It is for a form which will display a product. That product has options you can add to. Like Coffee, you can have the option of whole milk/skim/cream, sugar/equal/brown, caffine/decafe and so on. I want to pass these options along with the productID and qty. The possible values that are passed are: FORM.ProductID, FORM.Qty FORM.Option1 (option#count#) FORM.Option2 FORM.Option3 And so on... The Options are created dynamic so I don't know how many option groups (ie milk, sweeatner) I will have for each option (whole, skim, equal, splenda). This is why I have the input name= option#counter#. Since I'm working with radio input each group of options must have a unique name so I can select either whole milk, skim whole milk skim milk all have input nmes option1 white sugar, equal all have input names option2 The sku and qty are stored in a cartTable with a unique key for each line. Options will be insert in a seperate table which will only store the optionID and the cartID. Anyway, I don't know how to pass the many options along with the productID and qty. Can you point me to how to do this? I have no idea what you are really trying to do. It sounds very convoluted. But hopefully the answer to your question is the array notation for form data. It usually is for these kinds of serially numbered fields. #form[fieldname counter]# HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231352 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: passing multiple values from the same form field
Well, Normally if you want to loop over form fields, you can use something like this: cfloop list=#form.fieldnames# index=thisField cfset whateverVariable = #StructFind(form,thisField)# /cfloop George On 2/4/06, j s [EMAIL PROTECTED] wrote: It is passed to tag first. What I'm not clear on is how to loop the form fields. cfmodule template=productAdd.cfm action = add ProductID = #FORM.ProductID# qty = #FORM.Qty# options = #FORM.Option.CurrentRow# Hi, By saying 'I want to pass these options along with the productID and qty', are you saying that when you submit the form, the values are not being passed to the action page? Otherwise Ian's answer about the array notation for form data seems right. In simple terms, the radio button for option1 will be named form.option1(when the action page sees it) and it's value will be #form.option1#. If you know the total number of options, you can loop through that number like so (not tested): cfloop from=0 to=thatNumber index=thisNumber cfif StructKeyExists(form,'option#thisNumber#') cfset whateverVariable = #form[option thisNumber]# /cfif /cfloop George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231368 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
storing query results while paging through
All, I don't use session variables at all, but this might a good time to use them. I have a search page that takes in a search term, runs a query and then displays the results. The user is allowed to click into a result and then page through the search resultset while in a result (via Previous/Next controls). Since I don't store the query results anywhere, I basically run that query every single time that the user presses Previous or Next (just so that I can find out where the user is while s/he is paging through and what the previous and next results are.) For an intensive search (which this is turning out to be), this means every time that the user does anything with the resultset, I am running a 4 or 5 second operation. Highly inefficient, I suspect. How do I cache the query results? Is a session variable the best option? I guess cookies would not be bad, but they are limited in the amount they can hold. How do people tackle this problem anyway? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230224 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: storing query results while paging through
Justin, Suppose the query is named 'getResults' and I have enabled the cachedwithin attribute. Say user1 comes along and searches for 'Portugal'. The query 'getResults' is cached. Then user2 comes along and searches for 'Spain'. This happens while user1 is paging through the resultset for 'Portugal'. Then user3 comes along (while the sessions for user1 and user2 are still on) and searches for 'Argentina'. What happens to the cache for 'getResults' while all this is happening? How does CFMX 7 (which I am on) handle all these interactions for cached queries? Thanks, George On 1/23/06, Justin D. Scott [EMAIL PROTECTED] wrote: Assuming your query pulls all of the results and you use the startrow and maxrows attributes when outputting, you could just use the cachedwithin attribute of cfquery itself to store the results in memory without all the fuss of session variables. This will also have the benefit of using the same cache if multiple sessions search for the same thing while it's in the cache. -Justin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 10:34 AM To: CF-Talk Subject: storing query results while paging through All, I don't use session variables at all, but this might a good time to use them. I have a search page that takes in a search term, runs a query and then displays the results. The user is allowed to click into a result and then page through the search resultset while in a result (via Previous/Next controls). Since I don't store the query results anywhere, I basically run that query every single time that the user presses Previous or Next (just so that I can find out where the user is while s/he is paging through and what the previous and next results are.) For an intensive search (which this is turning out to be), this means every time that the user does anything with the resultset, I am running a 4 or 5 second operation. Highly inefficient, I suspect. How do I cache the query results? Is a session variable the best option? I guess cookies would not be bad, but they are limited in the amount they can hold. How do people tackle this problem anyway? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230231 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: storing query results while paging through
On 1/23/06, Dave Watts [EMAIL PROTECTED] wrote: When you use CACHEDWITHIN/CACHEDAFTER, CF identifies cached queries not just by name, but by connection and by the actual SQL statement. So, each user would generate their own cached query, and CF would only reuse one of them if another request used one of the previously-entered search criteria. Ah, so there is a diffrentiation by connection as well (hence by session)? I knew that there was a diffrentiation by actual SQL statement. That is good to know. Thanks all! George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230234 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: storing query results while paging through
Well, I completely forgot that we were using stored procedures for our db calls. So the cachedwithin property goes out the window. Now I am just storing the storedproc results in the session scope and using them from there. Thanks, George On 1/23/06, Justin D. Scott [EMAIL PROTECTED] wrote: The cache is based on the query name, as well as the actual query going to the SQL server. If the search string is different, then the query would be different, so it would get cached independently of the others. Note that if you are using cfqueryparam in the query, it cannot be cached with cachedwithin. -Justin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 12:13 PM To: CF-Talk Subject: Re: storing query results while paging through Justin, Suppose the query is named 'getResults' and I have enabled the cachedwithin attribute. Say user1 comes along and searches for 'Portugal'. The query 'getResults' is cached. Then user2 comes along and searches for 'Spain'. This happens while user1 is paging through the resultset for 'Portugal'. Then user3 comes along (while the sessions for user1 and user2 are still on) and searches for 'Argentina'. What happens to the cache for 'getResults' while all this is happening? How does CFMX 7 (which I am on) handle all these interactions for cached queries? Thanks, George On 1/23/06, Justin D. Scott [EMAIL PROTECTED] wrote: Assuming your query pulls all of the results and you use the startrow and maxrows attributes when outputting, you could just use the cachedwithin attribute of cfquery itself to store the results in memory without all the fuss of session variables. This will also have the benefit of using the same cache if multiple sessions search for the same thing while it's in the cache. -Justin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 10:34 AM To: CF-Talk Subject: storing query results while paging through All, I don't use session variables at all, but this might a good time to use them. I have a search page that takes in a search term, runs a query and then displays the results. The user is allowed to click into a result and then page through the search resultset while in a result (via Previous/Next controls). Since I don't store the query results anywhere, I basically run that query every single time that the user presses Previous or Next (just so that I can find out where the user is while s/he is paging through and what the previous and next results are.) For an intensive search (which this is turning out to be), this means every time that the user does anything with the resultset, I am running a 4 or 5 second operation. Highly inefficient, I suspect. How do I cache the query results? Is a session variable the best option? I guess cookies would not be bad, but they are limited in the amount they can hold. How do people tackle this problem anyway? Thanks, George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230242 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: WOT: Gmail's interesting approach to usernames
But I can't login as georgeabraham only as george.abraham, so that conflicts with the implementation. George On 1/17/06, Munson, Jacob [EMAIL PROTECTED] wrote: From reading their site, it sounds like your email address is really georgeabraham(AT)gmail.com. I'm not positive, but when I read that page you posted the link to, it looked like the gmail server just ignore anything with a (.) in them, so when you signed up for george.abraham, their server really created it as georgeabraham. Otherwise they would have conflicts, like you are describing. -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 17, 2006 3:09 PM To: CF-Talk Subject: Re: WOT: Gmail's interesting approach to usernames It would be OK if they had stopped the second George Abraham to sign up from using that name! Otherwise it is a seriously flawed design! [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229882 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
WOT: Gmail's interesting approach to usernames
All, I happened to read the exchange where Gmail thought some CF-Talk mail was spam and tagged it thus. Today, I just realized an interesting 'feature' about Gmail. I own a Gmail account with the username george.abraham (note the period between the words.) I Do NOT however own georgeabraham (no period between the words george and abraham.) For the past 2 months, I have been intermittently getting email that was addressed to georgeabraham(AT)gmail.com. I kept wondering why I am getting this person's email. I finally decided to complain about/investigate it. I found this in Gmail's FAQ. http://mail.google.com/support/bin/answer.py?answer=10313bug=1query=messages+dotctx=bugflow Is this acceptable? It sounds like a pretty interesting approach to usernames to me. George ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229821 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: Scripting DB records in enterprise manager
Scripting will only create those tables, not populate them. If you want to populate, use the import/export data wizard in Enterprise Manager. If your new tables are already created, then just point the wizard to them, else the wizard can also create them for you, if I am not mistaken. George On 1/11/06, Mike | NZSolutions Ltd [EMAIL PROTECTED] wrote: hi guys, I need to duplicate some existing tables to a new SQL database. i am trying to script my sql server db, and include all records - not just the table structure. i am using the generate SQL script tool, but cannot seem to include the records. does anyone know what i am not doing? Regards Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229303 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: ColdFusion Cookbook
Ray, I second Massimo's suggestion to model on. I can also serve (like Matthieu has volunteered) to be a potwasher for this. George On 1/5/06, Massimo Foti [EMAIL PROTECTED] wrote: While the site isn't quite ready yet, I'd love to get some feedback on what you would like to see on the site. I hope to have something up within a few days and will post again when the initial site is launched. You may want to take a look at the way ActiveState does for Python and other languages. Their Python cookbook was bornonlie and was later pinted by O'Reilly: http://aspn.activestate.com/ASPN/Python/Cookbook/ Massimo ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228458 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: bas64Decode
OK, I feel like a moron now! Thanks for pointing me the right way George On 12/29/05, Bobby Hartsfield [EMAIL PROTECTED] wrote: cfset str = tobase64(This is the string) cfset str = tostring(tobinary(str)) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, December 29, 2005 7:31 PM To: CF-Talk Subject: bas64Decode All, I have a base64-encoded string which I need to decode. I can't seem to find a CF function that actually does this. Any ideas? Thanks, George ~| 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:228020 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
bas64Decode
All, I have a base64-encoded string which I need to decode. I can't seem to find a CF function that actually does this. Any ideas? Thanks, George ~| 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:227960 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
multiple uploads and cffile and cfmx instances
All, This is a bit of strange bug that we noticed recently. Out infrastructure is on CFMX 7.01 Enterprise with 6 instances of CFMX running on the same IIS server with about 20 websites. I was testing a multiple upload Java applet that was working fine on my small CFMX developer test box. After transferring it to a staging site on the infrastructure, I noticed that the multiple uploads were not working. So I changed the applet to a bunch of HTML inputs (type=file) to see what happened then. The same error happens. The error is this: JRun Servlet error: 500 unexpected end of part I tried everything that I could think of to see if there was a problem in the code. Everytime there was a single upload, it worked. But multiple uploads all crashed. I then transferred the code to another CFMX instance on the same server. And it worked fine without a hitch. So we tried to wipe out the buggy CFMX instance, installed another instance with the same name as that instance and it failed yet again on the multiple uploads. Anybody have any ideas? Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226917 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 the name of a file upload
We use a Java applet called ImageUploader from Aurigma (http://aurigma.com). It has worked pretty well so far. It does show the current status of the upload for one file or multiple files while the upload is taking place. George On 12/12/05, James Holmes [EMAIL PROTECTED] wrote: You'll probably need to use a java applet or some other method of uploading the file. This is one thing I've always thought was lacking in the CFFILE tag - a way to specify the upload temp file name for this very situation. On 12/13/05, Burns, John D [EMAIL PROTECTED] wrote: So, anyone have any ideas on how CF ties the temporary upload filename to the final cffile path/filename? That's what I'm trying to figure out so that I could cfdirectory the tmp folder with a filter on the filename to get the file size as it is uploading. I'd check every second and display a status bar type graphic for the user showing them how much has been uploaded. Any thoughts? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| 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:226919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cffile upload large files again!
All, For uploading multiple files to the server, we use a Java applet which works quite well. Now, the sizes of the files could vary. People might upload 10 files that are 2MB each or 100 files that total about 200MB together. Sometime people could even upload about a gig of files if they so liked and wanted to wait that long, I expect. Anyway, when I last used cffile for upload for large files (using CF 4.5, if you please), there were all sorts of crappy issues you had to deal with. Are there still issues with using cffile for large files? I recently tested out the app with about 175MB of files with the largest file being about 76 MB abd the CF server crapped out on me. Looked up the application log and there wasn't one line of log in there that said anything significant happened. Am I better off using the FileReader class in Java? Or any other option? Thanks, George ~| 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:226448 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cffile upload large files again!
Thanks Dave, I don't see any UDFs on cflib that deal with what you talk about, though? I searched using various terms, but nothing turned up. I do understand what you say about streaming the file while uploading. Can this be done using the java.io.InputStream class? George On 12/7/05, Dave Carabetta [EMAIL PROTECTED] wrote: I would absolutely look into alternative solutions to cffile in this case. Remember, the cffile tag reads the *entire* file into memory (if it can) and only then does the action request. I'll bet money that your crap out was an OutOfMemory error at the Java level -- you were just looking at the wrong log file, which is why you didn't see it. If you're serious about allowing uploads of the sizes you're talking about, then streaming the file will be much more efficient. There are some UDFs at cflib.org to help you out with this. Also, if you're using MX 7, there is a new memory throttle on the Settings page called Maximum size of post data to help prevent against DoS attacks. Make sure that you up the default 10MB setting to the size of the largest file you anticipate to accept, or you'll hit that road block as well. Regards, Dave. ~| 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:226468 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: Verity Help
Greg, How about building a Searchable table with the record ID as the primary key and a text (or blob) field called SearchTerms. Then the first time that this gets built, just concatenate all the results of the 35 tables together and dump it into SearchTerms with the RecordID. If you have a lastUpdated field in your db for that record, next time you want to update the SearchTerms field, simply run a query that checks to see what records were updated in (say) the last 24 hours and run the 35-table join only for those records to update the Searchable table. Or is a new table out of the question? HTH George On 12/7/05, Greg Johnson [EMAIL PROTECTED] wrote: Ok, I have a database with 35 tables in it. I need to index fields from each of the tables so that it can all be searched and return the record numbers to pull out all the details. But bringing back every record with 35 tables joined takes so long things time out. So my plan was to query a table, add it to a collection, then do the next and add it to the same collection. IOW each query appends to the body field of 1 collection with seperate cfindex calls. However each time I use an index statement, it erases what is curently there. Any ideas other them building the body in a variable or file and then indexing that? Thanks Greg ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cffile upload large files again!
Robert, That one specifically talks about reading in text files already residing on the server. I bet that could easily be modified for reading in uploaded files. Thanks for the link. George On 12/7/05, FROEHLING, ROBERT (AIT) [EMAIL PROTECTED] wrote: George, Take a look at this technique by John Bartlett. http://johnwbartlett.com/cf_tipsntricks/index.cfm?TopicID=96 Robert ~| 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:226487 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
enabling debugging in CFMX7 Enterprise
All, We are running CFMX Enterprise with multiple instances of CFMX on 5 different servers. I was trying to enable debugging on a particular instance A and I went into A's CFAdmin to do so. I checked the requisite boxes in the debugging page, set my client's IP in the IP page and then checked the web application to see if the exception was being displayed in a 'robust' manner. To my surprise, no, there wasn't any additional info. I finally had to enable robust exception information in the main CFMX Admin to show this additional info. Why is this necessary? Shouldn't each of the instances have independence in deiciding this kind of thing? Or am I overlooking something? Thanks, George ~| 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:226180 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: enabling debugging in CFMX7 Enterprise
Steve, I did resolve the issue, it seemed that I was using a different CF Admin, just like you mentioned. The confusion was definitely there. There was a drop in the communication between the people who set it up and the developers, hence the confusion. But I do think your idea of turning on the built-in servers is good and I will suggest it. Thanks, George On 12/6/05, Steven Erat [EMAIL PROTECTED] wrote: George, What do you mean when you refer to the main CFMX Admin? What makes any one of the five CF Admins the main CF Admin? Whether they are clustered or not, you'd still have to go to each one independently to tune the settings, unless you are using CFMX 7.01 on WebSphere Network Deploy where WebSphere federates the changes from the main server to each of the clustered nodes. To avoid the confusion when dealing with numerous instances, I usually turn on each built-in webserver for each instance, and set unique ports for every one, (e.g., 8510, 8511, 8512, etc) regardless of whether they are all independent and each configured for external webserver instances or whether they are clustered and configured collectively for one webserver instance. Then test a sample page outside the CFAdmin using the built-in webserver on its unique port to continue the guarantee that you are testing the intended server. -Steven Erat On 12/6/05, George Abraham [EMAIL PROTECTED] wrote: All, We are running CFMX Enterprise with multiple instances of CFMX on 5 different servers. I was trying to enable debugging on a particular instance A and I went into A's CFAdmin to do so. I checked the requisite boxes in the debugging page, set my client's IP in the IP page and then checked the web application to see if the exception was being displayed in a 'robust' manner. To my surprise, no, there wasn't any additional info. I finally had to enable robust exception information in the main CFMX Admin to show this additional info. Why is this necessary? Shouldn't each of the instances have independence in deiciding this kind of thing? Or am I overlooking something? Thanks, George ~| 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:226234 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
interacting with java and return a ColdFusion query
All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225917 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: interacting with java and return a ColdFusion query
Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| 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:225919 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: interacting with java and return a ColdFusion query
Hmm, I am not sure I get what you mean. Sorry for my dullness! Lucene returns search results in the form of a list like so: http://lucene.apache.org/java/docs/api/org/apache/lucene/search/Hits.html. Do I then take that list and transform it into a Query? How do I do that? Thanks, George On 12/2/05, Katz, Dov B (IT) [EMAIL PROTECTED] wrote: So you can use #queryNew()# function within CF pages to produce the query result. -Dov -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:27 AM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java 2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225924 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: interacting with java and return a ColdFusion query
Oh yeah, I am familiar with Aaron's tag. That was the basis of the CFX tag that I had written. Is the CF_Lucene tag available somewhere? I don't have access to the DRK. George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Well, I still think you can use cfquery to get at the cotent. On one of the DRK's there was a CF_Lucene tag set which did quite a lot with CF and Lucene. There are also numerous other sites which mention Lucene and ColdFusion working in tandem One is Aarons (albeit old!) http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_cold fusion.html HTH -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:27 To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query Hehehe, I did not even think to explain that I wasn't querying just a database. The Java set of libraries is Lucene and I am querying the index that Lucene has built up for a particular search string. I want to return the result that Lucene generates back to CF in the form of a CF query object. I have already done this using a CFX tag, but I need to do some more somersaults within the Java class, so I want to ditch using the CFX tag and use a class that I can query using CreateObject. Thanks, George On 12/2/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I'm lost, what is wrong with cfquery? -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 02 December 2005 14:17 To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2.htm# 1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225925 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: interacting with java and return a ColdFusion query
Well, I managed to get something working with everybody's help here. Thanks everyone! I'll try and post the exact solution, when I polish it. George On 12/2/05, Gaulin, Mark [EMAIL PROTECTED] wrote: You can also create an arbitrary QueryTable (with columns you specify). I wish there was a way to do this without having to reference cfusion.jar... I do it to help maintain a back-end (in java) vs front-end (in cfml) distinction in the system. -Original Message- From: Dave Ross [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 12:09 PM To: CF-Talk Subject: Re: interacting with java and return a ColdFusion query yes, Mark's correct. You can populate a coldfusion.sql.QueryTable with a java.sql.ResultSet (passed into the constructor). I usually only resort to a java wrapper class when there's a specific reason that the java calls cannot be coded in CFML. Is that the case here? I think you need to use the class coldfusion.sql.QueryTable to do what you want. It's in either cfx.jar or cfusion.jar. Mark -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Friday, December 02, 2005 9:17 AM To: CF-Talk Subject: interacting with java and return a ColdFusion query All, I am working with CFMX and a set of Java libraries. I need to code a Java class that can serve as the liaison between CFMX and Java. This class will interact with the Java libraries and return the information to CF in the form of a CF query (using com.allaire.cfx.Query.) I want to stress that I am not making a Java CFX tag, I am just using com.allaire.cfx.Query. However I looked through this site ( http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/CFXRef_Java2 .. htm#1142286) for the methods available for the Query interface and I don't see any way to actually add a query or to name its columns. This is possible only through the Request interface. How can I name a CF query and its columns in a Java class and then return it to CFMX? Hope that makes sense! TIA, George ~| 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:225970 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
jrun memory usage on multiple CFMX instances
All, We have a Windows 2003 server that has five CFMX instances running on it which service five different sites. The average memory usage for the jrun.exe (when absolutely nothing is hitting the sites) is about 53MB. Together they eat up about 300MB. Is this normal? If not, what is normal? TIA, George ~| 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:225518 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: jrun memory usage on multiple CFMX instances
Beautiful! Thanks! George On 11/29/05, Douglas Knudsen [EMAIL PROTECTED] wrote: sounds normal to me. DK On 11/29/05, George Abraham [EMAIL PROTECTED] wrote: All, We have a Windows 2003 server that has five CFMX instances running on it which service five different sites. The average memory usage for the jrun.exe (when absolutely nothing is hitting the sites) is about 53MB. Together they eat up about 300MB. Is this normal? If not, what is normal? TIA, George ~| 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:225564 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: Ceiling of Verity collections...
It also depends on what your scale of collections are. If you are going to hit the ceiling of 250,000 objects sooner than you think, then you might be better off looking at Lucene or using a Google search appliance, depending on the money you have to throw at this. We currently use Lucene in conjunction with CFMX and it is an absolute joy. If I had enough time, I would write an entire process of how to do this, since it can get really irritiating for someone trying to do it. By the way, I am not using it to index web pages, I am using it to index databases. George On 11/29/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: As you said, I think it is a case of agree to disagree ;-p I really don't like Verity - but then again I have used others to compare it to - and Verity is nothing compared to them, -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 29 November 2005 15:54 To: CF-Talk Subject: Re: Ceiling of Verity collections... On 11/29/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: To add, and you are right, I haven't used verity in CF7 - I avoid it like the plague (plus we are tied into using FAST ESP methinks). Does Verity in CF7 still lock users out of a collection/search when it indexes? If it does, that alone indicates a poor search tool. Afaik no. In the past you had to go lock heavy w/ Verity. You no longer need to do that. Don't get me wrong, like I said, Verity is great tool for small sites and for CF bods to point it to location and say make it searchable, but it is in no way an enterprise level tool anymore. On the cuff of me calling it crap, what can you say that Verity offers me which would change my mind (in comparison to other tools such as Google, FAST etc?) I would wager not that much if any. To be honest I don't know. I haven't used either of them. As I said, they may certainly be better, even loads better, but Verity/CF is free and included in the product, so before spending more money, or integrating something else like Lucene, one should take a look. -Ray ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225567 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: Best Practice - Omit The and other common words Text Input for Search and another question
Hi Les, I would also look at enabling full-text search on (I am assuming) SQL Server and using the CONTAINS clause. You might still have to filter out the 'The', but it might also help on other situations. George On 11/12/05, Adrian Lynch [EMAIL PROTECTED] wrote: If The is the only word causing you problems, look for it at the beginning of the search(it would have to be the beginning as you don't want to take it from the middle of a string) term and remove it before it gets passed to SQL. Ade -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 11 November 2005 16:55 To: CF-Talk Subject: Best Practice - Omit The and other common words Text Input for Search and another question Let's say I'm searching book titles in a database. I want to find The Red Tent. However, in the database, it's listed as Red Tent, The. So: search books where Title like '%#formtitle#%' So, the following will find it: Red Tent Red Tent The exact title The Red Tent won't. 1. What's the best way to exclude common words from what's entered in the form field. 2. How would I do something a little more comparitive? Assume the book title is actually The Big Fat Tent that is Red and if I enter Red Tent into the search field, I'd like it to come up. The only thing I can think of here would be to take each word entered into the form field - The Red Tent - put them in a list - The, Red, Tent - and then do a search for the terms in the list. Any other ideas? A verity search will NOT work in this case, as there's a ton of other tables with joins and all sorts of other rotten stuff involved... -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224028 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: reload Java classes
Jeff, Yep, that is what I am doing now too: a commented out main() that does the same crap. Once in a while though, I mess up somewhere and damn, I have to restart the CFMX service. It also takes a sight more time to restart than CF 5 used to, but for all the stuff I get with CFMX, I don't really mind that. George On 11/9/05, Jeff S [EMAIL PROTECTED] wrote: Gah! And a thousand coises! Thanks, George On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote: This topic seems to come up often with no solution that I've seen. I have the same situation and spent quite a bit of time reading articles written by people that claim it's possible in MX, as well as reading the JRun and CF documentation with none of the proposed solutions working for me. Finally after sending emails to several article authors (with no responses) I read this http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1561.htm and moved on without hope of finding an answer unless one of the authors responds to me. To get around the problem for now, I just create a main method that runs the class files and run them on a command line. This has gotten be through 90% of the development process of all the stuff I've created. ~| 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:223815 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: Browser-based XML editor
All, This is more of an exploratory question than anything. Has anybody used browser-based XML editors like BitFlux, Xopus or any such? What are your experiences and would you recommend any? I want something that just shows either the XML document (in all its indented glory) or a tree structure of the document with editable nodes. Some of the ones that I have seen seem to do a whole lot more than I want or are really client-intensive (as in the client has to download some software before being able to do any editing in the browser.) Also some are IE only or are Mozilla/Firefox only. Xopus is oh-my-gosh expensive. If anybody needs any information about this, take a look at this site: http://www.geniisoft.com/showcase.nsf/WebEditors which is a list of web editors in general. Thanks, George ~| 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:223839 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: Browser-based XML editor
Hmm, I hadn't thought of that one. Will take a look at it. Thanks, George On 11/10/05, Kevin Aebig [EMAIL PROTECTED] wrote: If you want to any xml doc formatted and easily collapsed, you can use the Flash Tree component and load the xml into that... that's probably the easiest way to do it. To make it full editable, it gets a little more complicated... =] Cheers, Kevin -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: November 10, 2005 10:28 AM To: CF-Talk Subject: SOT: Browser-based XML editor All, This is more of an exploratory question than anything. Has anybody used browser-based XML editors like BitFlux, Xopus or any such? What are your experiences and would you recommend any? I want something that just shows either the XML document (in all its indented glory) or a tree structure of the document with editable nodes. Some of the ones that I have seen seem to do a whole lot more than I want or are really client-intensive (as in the client has to download some software before being able to do any editing in the browser.) Also some are IE only or are Mozilla/Firefox only. Xopus is oh-my-gosh expensive. If anybody needs any information about this, take a look at this site: http://www.geniisoft.com/showcase.nsf/WebEditors which is a list of web editors in general. Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223857 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
reload Java classes
All, Before I give up on this (since I have searched the Interweb and have not got any solutions), I wanted to ask the people on the list about this. I have a Java program that is currently under development and I call Java class using the cfobject tag. I am having to restart the CFMX 7 server every single time that I have to make a change to the class. Is there absolutely no way the class can reload itself without this constant restarting? I can already hear the sighs out there! No, I am not deploying CF in a J2EE environment , so I can't modify jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K. Thanks, George ~| 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:223676 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: calling java class from CFMX
Robert, Sorry for dropping off. I just read this email. I did find out that I was thinking badly about it. I did do this by actually instantiating the Java class using cfobject. Thanks, George On 11/7/05, Robert Munn [EMAIL PROTECTED] wrote: WHy not just call your Java class using CFOBJECT to instantiate the native Java object? In order to do that, you'll need to reference your additional classes in the CFMX classpath arguments. If you need this class to have some special security permissions, you might also want to consider writing a wrapper class that calls the other class by impersonating another user account. All, CFMX 7 on Win 2000 (a test server). I wrote a Java program and compiled it on the server under another user account (not the one running the CFMX service). The program compiled correctly and I was able to run it using the command line. Now it imports some specific java libraries that are not in the JRE. I want to be able to run this Java class peridocally so I thought I could simply add a CF task that cfexecutes the class using the cmd.exeprogram. I know that this might be a security issue. I have two questions: 1. Is it a security issue? If so, how else can I run the Java class? It is a normal java program with a main() method that directs various methods. 2. If not a security issue, does the account that runs CFMX (currently a local system account) have to be one that is not a system account? I am currently running the cfexecute by calling the complete classpath that is required for the java program to execute. However I am just getting a blank page and nothing else. Regards, George ~| 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:223678 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: reload Java classes
Gah! And a thousand coises! Thanks, George On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote: keep on restarting that server :) http://livedocs.macromedia.com/jrun/4/Getting_Started_with_JRun/intro5.htm hot deploy works wehn a jsp or servlet is called. So, CreateObject() will not effect this. DK On 11/9/05, George Abraham [EMAIL PROTECTED] wrote: All, Before I give up on this (since I have searched the Interweb and have not got any solutions), I wanted to ask the people on the list about this. I have a Java program that is currently under development and I call Java class using the cfobject tag. I am having to restart the CFMX 7 server every single time that I have to make a change to the class. Is there absolutely no way the class can reload itself without this constant restarting? I can already hear the sighs out there! No, I am not deploying CF in a J2EE environment , so I can't modify jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K. Thanks, George ~| 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:223706 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: Generate PPT slides from CF
If you are ready to risk Automation of Office components on your server using CF, then I do have some code that might help you. Email me offline and I can send it to you. Or you could look at the code at CFcomet: http://cfregex.com/cfcomet/. Regards, George On 11/9/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: John Paul - So this is really a separate file type and presentation system? We are supporting corporate customers who are really tied to PPT already so we really need something that can generate a PPT slide completely. Yep -- alternative system. Tough challenge! The only thing I can think of is really complicated -- using VBA to write the slide directly. Something like using cfobject and the underlying com object as shown in this VBA example http://skp.mvps.org/ppt00046.htm#2 Argh! :) John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 10:43 AM To: CF-Talk Subject: Re: Generate PPT slides from CF On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: I'm trying to generate PPT slides from CF and I'm running into some difficulty. I've got some reports that users can run whenever they're like and the display in HTML by default. On one report, we put a Powerpoint button that spits out the same HTML and just specifies the filename as .ppt and returns the header for that. This works fine for a simple tabled report as PPT converts the HTML to a slide. The issue that I'm running into is when there is an image on the report. If I put it in as an img src... it works fine, but if you don't have access to the internet, it won't work. I'd like to somehow embed an image in there so that users can take it on the road for presentations. Anybody done something like this or have any ideas? I've looked in the exchange for tags but haven't had much luck. This doesn't *exactly* meet the requirements, but there's a web-based presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that feels a lot like PowerPoint (unless you use really fancy transistions) but is all (x)HTML under the hood. It *might* be easier just to use it since you can use the HTML you are already building directly in a slide, embed images, etc -- and then package it all up to take on the road. It's a single HTML file, a theme, a JS file, and any media you include. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:223710 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
calling java class from CFMX
All, CFMX 7 on Win 2000 (a test server). I wrote a Java program and compiled it on the server under another user account (not the one running the CFMX service). The program compiled correctly and I was able to run it using the command line. Now it imports some specific java libraries that are not in the JRE. I want to be able to run this Java class peridocally so I thought I could simply add a CF task that cfexecutes the class using the cmd.exeprogram. I know that this might be a security issue. I have two questions: 1. Is it a security issue? If so, how else can I run the Java class? It is a normal java program with a main() method that directs various methods. 2. If not a security issue, does the account that runs CFMX (currently a local system account) have to be one that is not a system account? I am currently running the cfexecute by calling the complete classpath that is required for the java program to execute. However I am just getting a blank page and nothing else. Regards, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223435 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: [SPAM : 8.1] Re: Rumors from Max..
Umm, We actually support both CF5 and CFMX in our environment. Both are pretty stable for what they do. But things like CFCs in CFMX do make life a whole lot easier. George On 11/4/05, Snake [EMAIL PROTECTED] wrote: Perhaps because his CF5 server is stable and doesn't fallover nearly as much as CFMX. -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 04 November 2005 15:03 To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. If you can't see a reason to move to MX from 5, then you may be hoplessly lost. -Adam On 11/3/05, Terry Troxel [EMAIL PROTECTED] wrote: If you are basically a scripter why would you think a move to java is A good thing, especially with all the problems it seems come up with The java odbc conectivity issues and the ms breaking my java setup. I love CF5 and just am reluctant to go to 6.1 or 7. C'mon guys convince me. Terry -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 9:13 AM To: CF-Talk Subject: Re: [SPAM : 8.1] Re: Rumors from Max.. Why exactly was CFMX6 needed to save the product from CF5, if that's what you meant? Just curious as I am still in love with 5.0 Terry Troxel I think he's referring to the move to Java. ~| 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:223200 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: Find no records
Maybe this will work. I may not be understanding what you need. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT UserID FROM tbl_020eventDetails e) /cfquery On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters datasource=user020 SELECT u.userID, u.firstName, u.lastName, u.emailAddress, u.password, e.userID FROM tbl_020publicUsers u INNER JOIN tbl_020eventDetails e ON u.userID e.userID /cfquery I thought something like the above might work but doesn't seem to. Any help would be great, thanks. Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222979 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: Philosophy Q: SP's or CFQUERY?
I do second the too lazy to write SQL code if I don't have to. I have recently had the luxury of having in my team a person who is more DB-aware than I am. So now I just write library CFCs that have functions that call the SPs. Periodically when I see that there is a one-off query that really does not need to be an SP, then I write it myself. The decision to do this is totally subjective though. I would be interested in seeing if there are really objective reasons to convert some 'inline' queries to SPs. For example, how does one decide if the following inline queries are to be coverted to SPs: 1. A query that returns a list of FileTypes from a table FileType that populates the cffile 'accept' attribute. 2. A query that returns a particular record to display it in the browser. So it is a simple 'SELECT * FROM SomeTable WHERE SomeTableID = 'whatever(with cfquerparam)' 3. A query that has to update a table Order_Item (say) with OrderID and ItemID, but first has to delete all the relevant ItemIDs for a particular OrderID before running the update (actually new inserts). Sorry if any of the above does not make sense. It's been a long day already. Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222781 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: SOT: Image (or File) Organizer
Well, I answered my own question. Here are two JS libraries that do this in a pretty useful manner. They might be good additions to your tool library. 1. One is at http://script.aculo.us/ and the specific tool that does what I want is at: http://wiki.script.aculo.us/scriptaculous/show/SortableListsDemo 2. The other is at: http://tool-man.org/examples/ and the specific tool I needed is at: http://tool-man.org/examples/sorting.html. George On 10/18/05, George Abraham [EMAIL PROTECTED] wrote: All, One of the apps I am working on involves a fair bit of file-management. Most of the files are images or media like audio/video clips. Occasionally one of the bunches of files have to organized in some fashion involving order of display. I can hack around with JavaScript and have a select list populated with the filenames and have the users manipulate it using buttons. But a better solution would be where they can see image representations of the files (or images) and manipulate/organize them by click and drag. So obviously I either need something in Flash or a Java applet that would do this. Are there any such scripts or swfs out there that anyone is aware of? Keep in mind that the script/swf would have to be part of a form that the user would ultimately submit to update their display order in a database. Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221537 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: Image (or File) Organizer
All, One of the apps I am working on involves a fair bit of file-management. Most of the files are images or media like audio/video clips. Occasionally one of the bunches of files have to organized in some fashion involving order of display. I can hack around with JavaScript and have a select list populated with the filenames and have the users manipulate it using buttons. But a better solution would be where they can see image representations of the files (or images) and manipulate/organize them by click and drag. So obviously I either need something in Flash or a Java applet that would do this. Are there any such scripts or swfs out there that anyone is aware of? Keep in mind that the script/swf would have to be part of a form that the user would ultimately submit to update their display order in a database. Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221385 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
cf5 scheduled tasks going haywire
All, Our creaking CF5 server suddenly started behaving badly with respect to scheduled tasks. One of the tasks was something set to run every 4 hours (240 minutes). With no reason, this task started running every 30 seconds or so. I modified the task, and now all of the other tasks are doing the same thing, that is, running every 30 seconds or so. Has anybody run into this issue before? CF 5 on Windows Server 2003 with IIS 6. Thanks, George ~| 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:220799 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
dynamic structure name
Hi, One of the structures I am dealing with is populated dynamically. It looks thus: perm.public.UserGroup.#PermID#.Permname. I have a number of PermIDs I want to loop through and set some variables. Hence: cfloop list=#listOfPermIDs# index=thisPermID cfif StructKeyExists(perm.public.UserGroup.#thisPermID#,'PermName') cfdoSomething / /cfif /cfloop However I keep getting an error that the Structure name cannot end in a period(.). How can I get this to work? Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220299 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: dynamic structure name
That worked, thanks! George On 10/7/05, Adrocknaphobia [EMAIL PROTECTED] wrote: Try using a different notation like: UserGroup[permID].permName -Adam On 10/7/05, George Abraham [EMAIL PROTECTED] wrote: Hi, One of the structures I am dealing with is populated dynamically. It looks thus: perm.public.UserGroup.#PermID#.Permname. I have a number of PermIDs I want to loop through and set some variables. Hence: cfloop list=#listOfPermIDs# index=thisPermID cfif StructKeyExists(perm.public.UserGroup.#thisPermID#,'PermName') cfdoSomething / /cfif /cfloop However I keep getting an error that the Structure name cannot end in a period(.). How can I get this to work? Thanks, George ~| 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:220358 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: File uploading with firefox
Try changing the accept attribute in your cffile to accept those mimetypes. What is your upload cffile code, anyway? George On 10/6/05, Protoculture [EMAIL PROTECTED] wrote: why would I change the file extension of a word doc (.doc) to something other than a word doc in order to fix a file upload feature that should be supporting word documents? Anyway to reiterate. Its working in IE, but Firefox does not seem to identify that the file IS a word document. And this my upload fails. The MIME type of the uploaded file application/unknown was not accepted by the server Why would the same file be 'accepted by the server' by IE, but not firefox? what changes should I be making in the server configuration? ~| 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:220225 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: SQL Server 2000 Full-text search issues
Russ, I am probably a bad SQL coder, but almost all the code that I had to do with searching structured databases had about 3 times the amount of CF code interspersed with the SQL queries. Most of the time, my customers want a single search box which can take all kinds of searches. When they enter a phrase, then I have to capture the fact that it is a phrase and conduct the query one way. Now since they want some result, if not for the phrase alone but its constituents, then I have to separate that out and conduct a different search. The CONTAINS query in SQL does a lot, especially in terms of focussed results. But when it does not work for us when we want any old result that remotely has to do anything with the entered search term. I might be talking through my hat here, but I searched long and hard for answers to my problems with full-text search in SQL Server. A simple statistic (albeit anecdotal): When I was working with SQL Server FTS, I was fine-tuning a search for a client who called about once every 2 days about some result that she wanted that wasn't being captured by the query when she entered the search term. Then I would scramble around the code (both SQL and CFML) trying to make sure that everything would not break and at the same time, I could accomodate this request. After about 2 months of this, I switched to Lucene and now? Not a peep out of her! Granted there were some things I did better the second time round, but I was happy, and so was she. George On 10/2/05, Snake [EMAIL PROTECTED] wrote: What sor tof problems. I have used FULL-TEXT SEARCH many times without problem, even on a massive 13gb database with millions of records, it certainly never required the user to do anything special, they just entered their search query in the form as uusal. russ -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: 01 October 2005 14:25 To: CF-Talk Subject: Re: SQL Server 2000 Full-text search issues Hi, Full-text search on SQL Server 2K gave me huge problems. Not only was the code to conduct a full-text search cumbersome, but the user had to learn how to define searches in ways that were not really fair to the user. That is why I decided to turn to another appliance for full-text search structured databases. At first I tried using the Verity search already packaged with CFMX. However I soon ran into scaling issues in terms of the number of records that Verity will store. Since one of my dbs stores more than 100K records, that alone would take up the limits of Verity's licence. Buying an unlimited (or whatever) licence for Verity was a bazillion dollars. Similar problems with buying a Google search appliance. We decided to go with Lucene from the Jakarta project which is a simply beautiful product. And it is free. Of course you have to learn Java, but the Lucene email lists are extremely helpful. Besides Aaron Johnson has some code over at ( http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_cold fusion.html) that even talks about CF and Lucene. I know this doesn't solve your current problem, but I ran into issues with SQL server like you did and some of them were having our customers (and I, to some extent) tear their hair out. If you need some help with CF and Lucene, I can list some resources or email me offlist. George On 9/30/05, Martin Parry [EMAIL PROTECTED] wrote: I too get this on my 2003 cluster. I restored the database as a backup from my dev box (which it works on) and do a full rebuild - It takes but a second to say its complete and then gives me absolutely no results. If I find a solution I'll post it here. IF! Martin Parry http://www.beetrootstreet.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 30 September 2005 16:22 To: CF-Talk Subject: SOT: SQL Server 2000 Full-text search issues I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX 6.1) on which I have a database that has full-text enabled on a table. When I run a query against the full-text index, it returns 31 rows. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219870 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: SQL Server 2000 Full-text search issues
Hi, Full-text search on SQL Server 2K gave me huge problems. Not only was the code to conduct a full-text search cumbersome, but the user had to learn how to define searches in ways that were not really fair to the user. That is why I decided to turn to another appliance for full-text search structured databases. At first I tried using the Verity search already packaged with CFMX. However I soon ran into scaling issues in terms of the number of records that Verity will store. Since one of my dbs stores more than 100K records, that alone would take up the limits of Verity's licence. Buying an unlimited (or whatever) licence for Verity was a bazillion dollars. Similar problems with buying a Google search appliance. We decided to go with Lucene from the Jakarta project which is a simply beautiful product. And it is free. Of course you have to learn Java, but the Lucene email lists are extremely helpful. Besides Aaron Johnson has some code over at ( http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucene_coldfusion.html) that even talks about CF and Lucene. I know this doesn't solve your current problem, but I ran into issues with SQL server like you did and some of them were having our customers (and I, to some extent) tear their hair out. If you need some help with CF and Lucene, I can list some resources or email me offlist. George On 9/30/05, Martin Parry [EMAIL PROTECTED] wrote: I too get this on my 2003 cluster. I restored the database as a backup from my dev box (which it works on) and do a full rebuild - It takes but a second to say its complete and then gives me absolutely no results. If I find a solution I'll post it here. IF! Martin Parry http://www.beetrootstreet.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 30 September 2005 16:22 To: CF-Talk Subject: SOT: SQL Server 2000 Full-text search issues I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX 6.1) on which I have a database that has full-text enabled on a table. When I run a query against the full-text index, it returns 31 rows. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219828 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: applications in applications
Yes, you want single sign-on. You could do it the way you suggested, but I have a feeling that will lead to problems down the line. Maybe something like this - http://shibboleth.internet2.edu/ - along with an application management framework (even for applications around your university) is what you need. But it might be overkill if you are the only one in the campus wanting this kind of management. I don't know if my suggestion would help, but I am just throwing out the information and some thoughts from my experience. George On 9/28/05, Daniel Kessler [EMAIL PROTECTED] wrote: I only have a basic understanding of applications in CF. I have several applications in my site and each have their own logins, timeouts, and session variables. That brings up the obvious problem that someone wants to log in once and have that apply to any other login that they might come across. Currently applications have variables that are named the same but are in their own scopes. If I log in at the site level (the main page) which has it's own application.cfm and retrieve a list of applications that the user has access to, can the other applications read that there is a login at that level and then just see if they're in the application list? Am I making sense? -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu http://www.phi.umd.edu ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219413 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: post-upload file validation
Hmm, That was a test I should have done. Thanks for the info. On a related note, are any of ya'll using any multiple-file upload applets or some such that you could recommend? We are currently experimenting with Aurigma's ImageUploader (http://aurigma.com/Products/ImageUploader/) which works exceedingly well. However in certain conditions which we have to use, it crashes Firefox. (If you want to read more about a bug report, go to: https://bugzilla.mozilla.org/show_bug.cgi?id=309507) I am told that Flash 8 now has multiple file-upload capabilties, but Flash 8 penetration might be a bit low right now. Thanks, George On 9/23/05, HOFLee _ [EMAIL PROTECTED] wrote: I am assuming that cffile's 'accept' attribute does the same file-extension checking. It must use something other than file extension checking. I tried it with an Excel file renamed Book1.txt and a cffile with the accept value of text/plain and CF threw an error: The MIME type of the uploaded file application/octet-stream was not accepted by the server. Only files of type text/plain can be uploaded. Verify that you are uploading a file of the appropriate type. ~| 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:219176 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
post-upload file validation
All, We are allowing upload of files (a multiple file-upload, actually). Once the files are uploaded, short of looking at the file extension, are there any other ways of truly recognizing the file-type of an uploaded file? I am assuming that cffile's 'accept' attribute does the same file-extension checking. Thanks, George ~| 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:219014 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: CFC caching?
Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218402 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: CFC caching?
Isaac, SQL Server 2K. I renamed the stored procedure name in the cffunction, not in the db. It is in the application scope, but how does one recreate it - simply set it to null? I did have to restart the CF server service to get rid of this finally. I guess I am really curious why there is no info on this anywhere. At least I can't find any. Seems to me that no one else has run into this while developing CFCs. I change my stored procs so many times, that using CFCs this way would have me restart the CF service every so often. I must be doing something fundamentally wrong somewhere. A related question: would you instantiate an object that does auditing in the application scope or in the session scope? Initially I thought that since auditing is individual for every user, it should be in the session scope, but then some examples seem to suggest that instantiating it in the application scope is fine. Thanks, George On 9/15/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: What database? And how did you rename the procedure? I would say make sure you recreate the CFC object if it's stored in a shared scope (like say the application scope) but since the spelling was changed in the db and not in the CFC that shouldn't be relevant. Other than that, I'd say try restarting the CF server service. Umm, anybody? George On 9/14/05, George Abraham [EMAIL PROTECTED] wrote: All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:218412 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: CFC caching?
Isaac, rather than in the CFC... Once I know the name change occurred in the CFC, then shared-scopes is the first thing that comes to mind for me. Ahh, good, finally a phrase I can search on! :-) I'd have to know more about the specifics of your application to give a really useful opinion on that... What kind of audit is this, where/how is the audit used? If it's just to get a query for a report, then there's a good chance using a CFC is overkill (unless you're building it into a larger object that performs other related tasks). Maybe audit is a bad word to choose. Logging is a better word. The CFC would log specific actions that a user took so as to provide a log of the actions to the user when requested. A sort of history, if you will. Thanks, George ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFC caching?
Makes sense! Thanks for all your recommendations, people! George On 9/15/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Hey George... Trust me, you ain't the only one. ;) A CFC is executable CF so when you create an instance in a shared scope, that instance is created with the codebase in existance at the time it was instantiated. When you update the text in the code base, that does not update the contents of the CFC that's in a shared scope. In order to do that you have to use code like below, or restart the server. I assume you have this CFC in the application or session scope, yes? Try this: cfif structKeyExtists(url,reinit) cfset session.myLogger = createObject(component,my.logger.path.to.the ).init() /cfif (be sure to add locking. and be sure to use the right scope left of the equal sign.) ;) Then go to your page and add ?reinit=1 to the URL. Voila... As far as which scope to use... don't feel restricted. There's no reason you couldn't call application.logger.logUserAction(), for one thing. For another, if you have a logger class that's portable, why not use it in the app AND session scopes -- if, that is, they're doing different things. Just be sure that the primary methods in your application scope are thread safe ( i.e. use locking where required and accept parameters, use the var keyword, draw constants from the logger's instance data but don't affect that instance data). In general, anyway. Laterz, J ~| 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:218461 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
CFC caching?
All, I am relatively new to CFCs, so pardon the (perhaps) stupid question. I have a CFC like so: cfcomponent cffunction name=auditThis cfargument name=AccountID required=Yes cfargument name=TargetID required=Yes default=0 cfargument name=ActionString required=No default= cfstoredproc datasource=#request.appDSN# procedure=upIns_CreateNewAuditLogEntry cfprocparam cfsqltype=CF_SQL_BIGINT value=#arguments.AccountID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.TargetID# cfprocparam cfsqltype=CF_SQL_VARCHAR value=#arguments.ActionString# /cfstoredproc /cffunction /cfcomponent I made a simple mistake of misspelling the stored procedure and named it 'CreateNewAuditLogEntry'. Of course there was a spitting out of This SP name CreateNewAuditLogEntry is not available. I go back and change the name and add that prefix upIns_. However on running the routine, I get the error again that the This SP name CreateNewAuditLogEntry is not available. But, I changed the spelling and how come it is repeating the old error? Which leads me to believe that somewhere, something is being cached. Now I am also reminded of other CFCs that I inherited or worked with previously that gave me similar problems of retention of old settings. Oh mighty CF-Talkers, what have I encountered? Is there some setting that I have not set? CFMX7 on Windows 2000, by the way. TIA George ~| 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:218316 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: video frame capture on server side
All, I have spent a bunch of time googling for this, to no avail. Are there any server side programs (interfacing with CFMX via COM or otherwise) that can process uploaded video files and get frame captures and stuff? Thanks, George ~| 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:215431 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: SOT: video frame capture on server side
Tom, Thanks for the suggestions. Is 'convert' a program I can get somewhere? Sorry for the ignorance. George On 8/17/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 17 August 2005 16:54, George Abraham wrote:e any server side programs (interfacing with CFMX via COM or otherwise) that can process uploaded video files and get frame captures and convert can extract stills from some types of movie, otherwise you'll need to look at ffmpeg or something. Both should run on Win32 as well as native *nix. -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:215449 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: CF Licensing on VMs?
Maybe this thread on CF-server will help you? http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:10/threadid:1344 HTH, George On 8/17/05, Jim Davis [EMAIL PROTECTED] wrote: We're (FINALLY!) trying to upgrade from CF 4.5 to CF MX 7 (predicated by a required move from NT 4.0 - so CF is seen as a huge pain in the ass by management... just so you know). In any case the new machines will actually be virtual machines running on large enterprise farms. This is where the issue is coming in: although we're going to install CF on these virtual machines (which have processors, one or two, dedicated to them) the word we're getting from our infrastructure guys is that MM is demanding that licenses be purchased for the PHYSICAL box (up to 64 processors), not the VIRTUAL box. This just seems plain wrong to me. I know every is having trouble with licensing to VMs nowadays... but com'on! Anybody else seen this? Have the same problem? Jim Davis ~| 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:215460 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: SOT: video frame capture on server side
OK, I think I remember that convert is a component/command of ImageMagick. Anyway, aren't there any software out there for Windows servers that process video in the way that I am asking? Not just frame captures, but also perhaps clipping video too? Something that does not require a dedicated video server would be good. Thanks, George On 8/17/05, George Abraham [EMAIL PROTECTED] wrote: Tom, Thanks for the suggestions. Is 'convert' a program I can get somewhere? Sorry for the ignorance. George On 8/17/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 17 August 2005 16:54, George Abraham wrote:e any server side programs (interfacing with CFMX via COM or otherwise) that can process uploaded video files and get frame captures and convert can extract stills from some types of movie, otherwise you'll need to look at ffmpeg or something. Both should run on Win32 as well as native *nix. -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:215463 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: SQL - Counting rows of UNION query
Yep, Got that one. Joe Rinehart pointed out that in that case, an alias for the UNIONised table would be needed. Thanks though, Mark. George On 7/25/05, Mark A Kruger [EMAIL PROTECTED] wrote: I'm forwarding this to the list - see the explanation below. As I recall this the solution that the poster eventually settled upon. -Original Message- Mr. Kruger, I found a recent thread on houseoffusion.com in which you participated re: counting the rows of a UNION of subqueries. I had the same problem/question and pieced together an answer from other sites/discussion. I would like the original poster, George Abraham, to know the answer I found. I don't really want to join the website just to reply. I'm fairly new to SQL and I search a LOT of sites for answers. I'd drown in memberships if I signed up for all of them. I'm content to lurk, but in this case, I can help. Yours was the only email address I could find in the discussion. Would you be so kind as to post the anwser? Many Thanks, Randy Steck Answer: 1) You have to name the table that is the result of the FROM, 2) You have to use UNION ALL. If two (or more) queries return the same value, UNION will drop one and give incorrect results. UNION ALL will force all records and give a correct count. example: SELECT count(*) FROM ( SELECT * FROM tblA UNION ALL SELECT * FROM tblB ) AS AggregateTable ~| 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:212717 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: CFMX, Video resizing/repurposing
Rich, Can you send a URL for the LEAD multimedia toolkit? Just want to make sure that I have the right one. Thanks, George On 7/25/05, Rich Wild [EMAIL PROTECTED] wrote: Hi all, I've got a task to develop an online video resizing app and so I'm looking at some server side tools that will help me let a user upload a movie (of any format/size) and it'll resize it down and reformat it ready for viewing by a larger audience. I could hardly find anything suitable. The only thing I could find was the LEAD multimedia toolkit that exposes its functionality via COM. However, not being a COM expert, I didn't get very far in harnessing it. A dump of the object in cfmx reveals propertiesand methods that seemingly can't be accessed, and the documentation isn't very non-gui-application helpful to me. Does anyone have any experience in dealing with LEAD tools and CF or even better - does anyone have any ideas for tools I can use server side and that can be triggered by CF in order for me to repurpose video files uploaded by users. Price isn't too much of an issue. Many thanks, Rich Wild ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212718 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: SOT: checkbox validation problem
Larry, I don't know if you already solved this, but it appears that when there is one checkbox, the notation e.atccNum[i] where i would be 0, does not hold. Then you have to refer to it as e.atccNum alone. HTH, George On 7/21/05, Larry Lyons [EMAIL PROTECTED] wrote: I'm having a problem with a javascript validation for a form with multiple checkboxes with the same name. The validation works just fine when there is more than one checkbox (as with a results set with more than one item) however, if there is only one checkbox, it always validates to false and craps out. Any suggestions would be most appreciated. thx, larry Here's the javascript: InvalidTag language=javascript type=text/javascript function checkForNoSelections(){ var chkd = 0; var e = document.viewItems; for(var i = 0; i e.atccNum.length; i++){ if(e.atccNum[i].checked == true){ chkd = ++chkd; } } if(chkd 0){ e.submit(); return true; } else{ alert(You must select an item to display.); return false; } } /script Here's an example of the single checkbox form (there are no problems with multiple checkboxes): form action=whatever.cfm enctype=multipart/form-data method=post name=viewItems input type=Checkbox name=atccNum value=1nbsp;nbsp;1br / input type=button value=View Selections onClick=checkForNoSelections()br / input type=Reset value=Clear Selectionsbr / /form ~| 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:212560 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: OT: CFMX Java API
Shailaja, Are you specifically working with the Plumtree API or with some other application's API? Jeff's email, which by the way was sent in September 2004, seemed more related to problems with using ColdFusion and Plumtree. If it is not related to Plumtree, can you show any code for the problem that you are having? George Hi Jeff, How is the performance of the application where u integrated the java based API with coldfusion? Did it have any adverse effect on your server? Currently I am in the process of integrating the same and am really concerned abt the performance. ALso am getting this error: An exception occurred when instantiating a java object. The cause of this exception was that: . ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212251 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: OT: Sun's JAI package install
How about using ImageMagick? Might be a bit overwhelming for what you want to do, but it does it so well. http://www.imagemagick.org/script/index.php George On 7/18/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I'm trying to install the JAI package from Sun (so I can fire up some image conversions) on my Win XP SP2 machine running CF MX 7 and everytime I run the exe I get this message after the package unpacks itself: C:\WINDOWS\SYSTEM32\AUTOEXEC.NT The system file is not suitable for running MS-DOS and Microsoft Windows applications. Chose 'Close' to terminate the application. The window this shows in is titled 16 bit Windows Subsystem Any ideas?? or alternatives to TIFF image conversion to JPG/PNG/GIF (any of these would be fine) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212157 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: OT: SQL count of rows from a union query
Well, I'll be! It worked. This is the second time that this has happened to me where the absence of an alias has screwed things up. Thanks Joe! George On 7/8/05, Joe Rinehart [EMAIL PROTECTED] wrote: Hey George, AFAIK, derived tables in T-SQL need an alias...try this: SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) tblDerived (note the tblDerived as the alias) -Joe -- Get Glued! The Model-Glue ColdFusion Framework http://www.model-glue.com ~| 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:211440 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
OT: SQL count of rows from a union query
Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211370 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: SQL count of rows from a union query
Mark, I am trying to return multiple rows of similarly typed data, specifically one column named ObjectID. Only, instead of deriving the number of rows from a getResults.RecordCount, I want to do it in the SQL query itself. Your suggestion will not weed out the duplicate instances of ObjectID which a UNION would accomplish. Thanks though, it would have worked save for the fact that the database was not the best conceived. I am having the deuce of a time doing any reporting. George On 7/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211384 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: SQL count of rows from a union query
Greg, It fails even with a SELECT * FROM (SELECT UNION SELECT). George On 7/7/05, Greg Morphis [EMAIL PROTECTED] wrote: could you put it in a 3rd query? Something like.. SELECT count(*) from ( SELECT * FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) ) On 7/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: Try something like SELECT count(ObjectID) + (SELECT count(ObjectID) FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID) AS total FROMtable1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID the UNION operator is really for returning multiple rows of similarly typed data from disparate tables. That's not what you are trying to do here. -mk Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 2:22 PM To: CF-Talk Subject: OT: SQL count of rows from a union query Hi all, This one seems to be simple, but it is not working at all. I want to return a count of the rows from an T-SQL Query that involves a UNION operation. SELECT count(*) FROM ( SELECT ObjectID FROM table1 t1 INNER JOIN table2 t2 ON t1.thisID = t2.thisID UNION SELECT ObjectID FROM table1 t1 INNER JOIN table3 t3 ON t1.thisID = t3.thisID ) But SQL Server keeps saying that there is a problem near that last closing parentheses. Any solutions? George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211385 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