Re: Installing CFMX 7
Have you tried netstat to see what's using that port? systernals also has a tcp port monitoring utility you can try out as well... Phill B wrote: Well I'm sad to say that this didn't work. Why would they make a product that is so hard to install? I'm starting to regret the upgrade. On 7/23/06, Mike Soultanian [EMAIL PROTECTED] wrote: I had that exact same problem. I'm not exactly sure what I did, but I know that the silent install helps things out... so... Uninstall your current version and do a silent install as described here: http://tinyurl.com/8g3dr then run the web connector. mike.. Phill B wrote: So I got my upgrade to MX 7 and a new development server. Well I'm trying to install it and Im having some trouble. I'm installing on a Windows 2003 server and IIS. The first issue is the message that it installed but the web server connectors did not install successfully. One possible reason is that port 51011 is blocked Then when I try to use the Web Server Configuration Tool I get the error Could not connect to and jrun/coldfusion servers on host localhost. Great. So, I found this on the adobe site http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19575 Does this look like the right thing to do to fix the problem? I would hate to go through all of that to find out it was the wrong path. Any advice will be appreciated. Thanks guys ~| 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:247728 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFReport, IE, and active content problem
On Tuesday 25 July 2006 19:15, Kris Jones wrote: By better HTML wrapper do you mean change the way I'm calling the object, e.g., object, vs. embed? Since I am calling a CFReport tag, I don't have control over how that is returned. I'm unsure how I could I am fairly sure there was/is a CFML tag that you can wrap around your call to CFReport. As we don't use it, I don't recall anything much more about it, sorry ! -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:247729 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problems with CFMAIL and Exchange 2003
On Tuesday 25 July 2006 17:10, Terry C. Mergl wrote: exchange all the messages end up in the undeliverable folder. Does it offer an excuse (in a log file somewhere) as too why ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:247730 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I just made a new CFC it has to with the classpath
On Sunday 23 July 2006 06:55, dan plesse wrote: Hello All, This could be my final java solution (300+) To what ? After making a 2 line classloader I found out that I was having trouble with anything other then public methods In what way ? Surely you can't call anything other than public methods, by definition. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:247731 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: execute a DTS package via Stored Proc?
No, anyone can run it if given the necessary permissions within a proxy account. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:32 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| 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:247732 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: execute a DTS package via Stored Proc?
Didn't work for me, thus why I had to go to the lengths I did. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 10:34 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? No, anyone can run it if given the necessary permissions within a proxy account. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:32 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| 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:247733 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
reading large text file
Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247734 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
I discovered the problem with bringing up a file in a directory where it no longer resides at another time. It was a ColdFusion file, using IE 6. The pages were not protected by login or any security. It was just an unexplainable problem and so was this. Do you know if my server people could be right in that there is no server cache? And can you tell me if the code for application.cfm below is correct? Thanks, Lewis cfcomponent output=false cfset this.name=MSFWGrantees cfset this.sessionManagement=True cfset this.loginstorage=Session cfset this.sessiontimeout=createtimespan(0,0,10,0) cfset This.clientmanagement = false cfset This.applicationtimeout=createtimespan(5,0,0,0) cffunction name=onRequestStart returntype=boolean output=true cfset REQUEST.datasource=wdsc !--- Check to see if the user is logged in, if not force them to now --- cfinclude template=ForceUserLogin.cfm cfreturn true /cffunction /cfcomponent ~| 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:247735 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: reading large text file
Simple answer, don't use CF! it is poor at this kind of operation - especially when coupled with DB interaction. Saying that you could possibly employ some Asynchronous code to speed it up but chances are it wouldn't make much difference. I would stick with getting the DB to do it, via DTS. N -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 13:36 To: CF-Talk Subject: reading large text file Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247736 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading large text file
Heh, Martin, I feel your pain. I just finished up a project yesterday doing the exact same thing - do a search on DTS in the archives to see all my questions about it. It isn't the easiest thing in the world to set up and get all the pieces running, but once you do,it is about 2000X faster than using CF. Of course, you need to be running SQL Server 7+ to be able to take advantage of it. So, the first question is, what flavor DB are you running? Ray Martin Thorpe wrote: Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247737 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Even with no server cache, the cfclasses folder holds the compiled classes and can continue to do so if a file is deleted. The cflogout thing is a different problem. These questions are for the cflogout thing: How is is IE set to check for new content in the page? If you clear your IE cache and revisit the page after logging out, do you still appear logged in? If you then try a protected page, are you actually still logged in? On 7/26/06, Lewis Billingsley [EMAIL PROTECTED] wrote: I discovered the problem with bringing up a file in a directory where it no longer resides at another time. It was a ColdFusion file, using IE 6. The pages were not protected by login or any security. It was just an unexplainable problem and so was this. Do you know if my server people could be right in that there is no server cache? And can you tell me if the code for application.cfm below is correct? Thanks, Lewis cfcomponent output=false cfset this.name=MSFWGrantees cfset this.sessionManagement=True cfset this.loginstorage=Session cfset this.sessiontimeout=createtimespan(0,0,10,0) cfset This.clientmanagement = false cfset This.applicationtimeout=createtimespan(5,0,0,0) cffunction name=onRequestStart returntype=boolean output=true cfset REQUEST.datasource=wdsc !--- Check to see if the user is logged in, if not force them to now --- cfinclude template=ForceUserLogin.cfm cfreturn true /cffunction /cfcomponent ~| 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:247738 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reading large text file
I am at a loss at why it was difficult to be honest - maybe the problem was you are not an SA on the prod box as normally, a DTS setup etc is a breeze. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 14:08 To: CF-Talk Subject: Re: reading large text file Heh, Martin, I feel your pain. I just finished up a project yesterday doing the exact same thing - do a search on DTS in the archives to see all my questions about it. It isn't the easiest thing in the world to set up and get all the pieces running, but once you do,it is about 2000X faster than using CF. Of course, you need to be running SQL Server 7+ to be able to take advantage of it. So, the first question is, what flavor DB are you running? Ray Martin Thorpe wrote: Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247739 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading large text file
Yeah I am on Oracle, sorry should have mentioned that at the beginning. Yeah I have written a thing before actually using SQL loader and it is very sweet can't think why I totally forgot about it, thanks for the jolt of memory, cheers. To you MS SQL guys thanks for the advice but no DTS here, just Oracle script. better to have something other than CF do this reallyHammer in hand, everything looks like a nail, eh? If using Oracle, could use SQL Loader. DK On 7/26/06, Martin Thorpe [EMAIL PROTECTED] wrote: ~| 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:247748 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cflogoff tag
Yes, that's the setting I meant and you have it set right. If deleting cookies is the only thing that works, it's probably because you are being assigned a new session on the next request (assuming you are now storing the login in the session as per your posted code). On 7/26/06, Lewis Billingsley [EMAIL PROTECTED] wrote: I'm not sure which setting you mean when you say new content. But, the setting that says, Checks for newer versions of stored pages, says Every Visit to the Page. Here's what I just did: Whenever I go to clear cache, I clear temporary Internet files, History, and Cookies, right? So this time I cleared each one separately. Deleting cookies only between sign-ins was the only one to work. Maybe we're beginning to get somewhere with this. Thanks, Lewis Even with no server cache, the cfclasses folder holds the compiled classes and can continue to do so if a file is deleted. The cflogout thing is a different problem. These questions are for the cflogout thing: How is is IE set to check for new content in the page? If you clear your IE cache and revisit the page after logging out, do you still appear logged in? If you then try a protected page, are you actually still logged in? ~| 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:247750 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFeclipse Task List
Files over RDS arent in a Project per-se so the Tasks and bookmarks will not work. its in a invisible project most of the time that is just a repository so Eclipse doesnt look at that. Sorry folks... cant think of a fix for TODOing your remote files. MD On 7/26/06, Terry Schmitt [EMAIL PROTECTED] wrote: I've had similar issues with RDS and cfeclipse. RDS just doesn't seem to play well with some of the eclipse/cfeclipse features. I develop remotely over VPN and generally use RDS due to it's speed. I've found that Tasks, Bookmarks, and Projects don't work over RDS. I had trouble with cfeclipse 1.3 and RDS as well, but since I really wanted to try 1.3, I have started mapping a drive to my development server and now have all the features back working. The only down side is that working with the mapped drive really slows down file saves. Terry I suggest you get the 1.3 beta, seems to work there as well as the Web Standards Tools Which I belive if you go to Help Software update New Software Callisto you should see it there HTH -Original Message- From: David Brown [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 19:24 To: CF-Talk Subject: Re: CFeclipse Task List Same here On any resource and the Where description contains is blank. From what I can tell it should work unless I am missing something. I think I will install cfeclipse on another system without the rds plug in and see what happens. David ~| 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:247760 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Converting valid XHTML to Plain Text...
Here is a simple example of how I do it in ColdFusion cfsavecontent variable=getID xsl:stylesheet xmlns:xsl=http://www.w3.org/1999/XSL/Transform; version=1.0 xsl:output method=text/ xsl:template match=/ xsl:for-each select=BSNews/child::* xsl:value-of select=@id /, /xsl:for-each0 /xsl:template /xsl:stylesheet /cfsavecontent -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:247761 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Consuming ColdFusion Webservice with .NET
OK, We are developing an API which is called via a Web Service wrapper. This is all good and is working - ColdFusion pages can call the remote service, pass in the relevant XML and get back the XML response. No problems there. We kno it working via cfinvoke etc. We are now testing the Web Service being called by .NET with no luck at all. The WSDL, as you would expect is cool apart from some odd namespace declarations at the top which seem to be the physical folder struct to the Web Service only reversed I.e. If the web service is in inetpub\wwwroot\a\b\c\foo.cfc then the namespace is http://c.b.a/ You would think that as a remote Webservice could and should be called with any technology. Anyone had any problems with .NET and ColdFusion based services? Any pointers? Thanks N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| 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:247762 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Consuming ColdFusion Webservice with .NET
Anyone had any problems with .NET and ColdFusion based services? Any pointers? Yep...if you return a query from your CF based webservice .NET will choke on what's called a QueryBean. Matt Small on-list wrote a DLL for .NET to help it past this issue...I have a zipped copy if you need it. Ultimately I converted queries to XML and changed the return type to string (I have the XML conversion code if you'd like that too). 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 ~| 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:247763 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Consuming ColdFusion Webservice with .NET
I'm not passing comoles objects from ColdFusion, only XML (plain text effectively). All complex objects are turnes into XML before being sent back. This should work out of the box, but it isn't. The problem is that for some reason the .NET code cannot get a binding due to the garbage namespace - givh is auto-generated. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:24:52 2006 Subject: Re: Consuming ColdFusion Webservice with .NET Anyone had any problems with .NET and ColdFusion based services? Any pointers? Yep...if you return a query from your CF based webservice .NET will choke on what's called a QueryBean. Matt Small on-list wrote a DLL for .NET to help it past this issue...I have a zipped copy if you need it. Ultimately I converted queries to XML and changed the return type to string (I have the XML conversion code if you'd like that too). 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 ~| 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:247764 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I just made a new CFC it has to with the classpath
However if you cfdump var=#workbook.init()# Errors with Unable to find a constructor for class jxl.Workbook that accepts parameters of type ( ). So object [unknown type] must be an object type Class The javaloader.cfc init() methods calls the protected constructor and finally errors. If someone did not have access to the source and did not know about the static methods their would be no way to get around this problem. I guess is my method never initializes the class in the first place because it does not have an init() method. So it never calls the protected method in the first place. That is your big boy cfset added = createObject(component, CLASSPATH).add_jar(C:\CFusionMX7\wwwroot\jxl.jar) Works on any coldfusion page i.e cfm, cfc, component and even inside gateways. cfset Workbook = createObject(java, jxl.Workbook) returns a class of object [unknown type] cftry cfset Workbook.init() cfcatch type=any cfdump var=#cfcatch# /cfcatch /cftry I get the same error as before. ~| 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:247765 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfhtmlhead and webservice woe
Ok, so I've got ajaxcfc running pretty smoothly, but I still need some help with my major catching point-cfhtmlhead. As part of my CFC, I cfsavecontent a page from our application and return the html to stick in an the innerHTML of a div on the ajax page. Our application uses cfhtmlhead a lot to stick javascript in the head of the document for various reasons. The problem is that CF appends the htmlhead information to the top of the return value that my CFC sends back to the browser and that really screws stuff up. Ajaxcfc sees this coming back from the webservice: script language=JavaScript1.2 type=text/javascript !-- This comes from the cfhtmlhead tag and totally screws up ajaxcfc -- /script _4304_1153931164505 = 'This is my content being returned'; DWREngine._handleResponse('4304_1153931164505', _4304_1153931164505); So the obvious answer here is probably Don't use cfhtmlhead you idiot, but I'm trying to NOT have to write as much as my application as possible-I want a scalable fix that will still let me include or cfmodule any page in my app and simply return the resulting HTML from the CFC. I can find every instance of cfhtmlhead and put an if statement around it or something, that that sounds like a kludgy fix. Is there a pretty way to handle this? ~Brad ~| 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:247766 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Consuming ColdFusion Webservice with .NET
h...I did encounter an issue using the CFXML set of tags...generated a bunch of line breaks and whitespace in the XML that buggered things uphad to switch to another method of generating the XML (which I can send ya) 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 ~| 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:247767 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Odd Query issue
I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery Scott -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| 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:247768 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Consuming ColdFusion Webservice with .NET
Again nope - XML is alll in one long string. I am sure the problem is the auto-generated stuff where it put that bollox namespace in. When I create a web reference in .NET it fails when debugging as it cannot bind or something or other. The service is .NET Certified :-) I just cannot get at it with ..NET! Now, either I am doing something wrong here or the wsdl is nonsense to anything but ColdFusion. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:34:59 2006 Subject: Re: Consuming ColdFusion Webservice with .NET h...I did encounter an issue using the CFXML set of tags...generated a bunch of line breaks and whitespace in the XML that buggered things uphad to switch to another method of generating the XML (which I can send ya) 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 ~| 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:247769 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Odd Query issue
What happens if you put it into a cfqueryparam? What happens if you select job_id from jobs? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:42:27 2006 Subject: RE: Odd Query issue I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery Scott -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. . Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| 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:247770 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd Query issue
Have you tried surrounding the job_id with brackets such that: Update jobs set status=0 where [job_id]=1 Perhaps, and I'm only stabbing in the dark here, job_id becomes a reserved word when submitting certain types of statements to your DBMS (where they might become jobs)? Try it and see. Cheers, Kris I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery ~| 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:247771 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Consuming ColdFusion Webservice with .NET
Now, either I am doing something wrong here or the wsdl is nonsense to anything but ColdFusion. Well I at least can tell you that is not true ;-) 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 ~| 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:247772 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Installing CFMX 7
Well I'm sad to say that this didn't work. Why would they make a product that is so hard to install? I'm starting to regret the upgrade. What exactly didn't work? Normally, the product isn't hard to install at all. 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! ~| 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:247773 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Generating very large pdf files with cfdocument
Has anyone else had issues when generating .pdf's using cfdocument? I have around 400 .jpg 15 - 25kb jpg images I am trying to make into a ..pdf using cfdocument and a simple img tag. I am on Windows 2003 and CF Enterprise 7.02, and jrun climbs to about 1.4 GB of ram and just sits there munching, and while that wouldn't be so bad, it stops ANY other process from running in CF! No web requests, notta. Does cfdocument use multiple threads? Anyone else had this problem? Here is my code, its pretty simple... !---// Create a pdf from this file //--- cfdocument format=PDF pagetype=custom orientation=portrait marginbottom=.5 marginleft=.5 marginright=.5 margintop=.5 pageheight=7 encryption=128-bit userpassword=#session.password# permissions=AllowPrinting pagewidth=8.5filename=d:\temp\checkfile.pdf !---// Loop through these files and send each one to a pdf //--- cfoutput query=DirList img src=temp/#name# /cfoutput /cfdocument Chris Peterson ~| 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:247774 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installing CFMX 7
I didn't get any response from the silent install portion of course but the Web Server Configuration Tool gave me the same error I got before Could not connect to and jrun/coldfusion servers on host localhost. On 7/26/06, Dave Watts [EMAIL PROTECTED] wrote: Well I'm sad to say that this didn't work. Why would they make a product that is so hard to install? I'm starting to regret the upgrade. What exactly didn't work? Normally, the product isn't hard to install at all. 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! ~| 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:247775 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Odd Query issue
I tried with a qryparam yesterday, no change. Selecting job_id from jobs works as well. If I run select * from information_schema.columns where table_name = 'jobs' the column comes back as well. This is one of those weird it worked fine for yrs up until yesterday and nothing in the code or table changed things. I'm thinking something is corrupt in the database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 12:32 PM To: CF-Talk Subject: Re: Odd Query issue What happens if you put it into a cfqueryparam? What happens if you select job_id from jobs? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:42:27 2006 Subject: RE: Odd Query issue I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery Scott -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. .. Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| 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:247776 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating very large pdf files with cfdocument
We've had problems generating any PDFs with cfdocument when there are linked images or css. Doesn't matter the size of the document. Haven't been watching resource hogging with regard to it, but I'd like to hear if you find that is the source of the problem. There was a post here a week or two ago that discussed this a bit. Here's the link: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:46071 The fix involves simple host file change. It didn't resolve it completely for us, but maybe it will work for you. Cheers, Kris Has anyone else had issues when generating .pdf's using cfdocument? I have around 400 .jpg 15 - 25kb jpg images I am trying to make into a ..pdf using cfdocument and a simple img tag. I am on Windows 2003 and CF Enterprise 7.02, and jrun climbs to about 1.4 GB of ram and just sits there munching, and while that wouldn't be so bad, it stops ANY other process from running in CF! No web requests, notta. Does cfdocument use multiple threads? Anyone else had this problem? ~| 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:24 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Installing CFMX 7
I didn't get any response from the silent install portion of course but the Web Server Configuration Tool gave me the same error I got before Could not connect to and jrun/coldfusion servers on host localhost. Did you check to see if the ports used by JRun are available? 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! ~| 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:247778 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Odd Query issue
What happens when you try to do a delete statement that you know will fail (so you don't delete data): DELETE FROM jobs WHERE job_id != job_id This should never be true, but I am curious as to if it throws the same error. ... Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:16 PM To: CF-Talk Subject: RE: Odd Query issue I tried with a qryparam yesterday, no change. Selecting job_id from jobs works as well. If I run select * from information_schema.columns where table_name = 'jobs' the column comes back as well. This is one of those weird it worked fine for yrs up until yesterday and nothing in the code or table changed things. I'm thinking something is corrupt in the database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 12:32 PM To: CF-Talk Subject: Re: Odd Query issue What happens if you put it into a cfqueryparam? What happens if you select job_id from jobs? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:42:27 2006 Subject: RE: Odd Query issue I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery Scott -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. ... Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| 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:247779 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Converting valid XHTML to Plain Text...
Why reinvent the wheel if 'lynx -nolist -dump http://google.com' works ? Before sending the message, this was one thing I looked into. The problem is I am trying to covert an XHTML string in memory to plain text. I tried looking for Java-based Lynx version that I might be able to use to use an API to do this with, but haven't found a method. -Dan ~| 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:247780 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Consuming ColdFusion Webservice with .NET
But you do agree that a working web service in ColdFusion should be able to be invoked via .NET out of the box? (assuming, as we have clarified, that it's simple types being passed and it's .NET safe) This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:57:40 2006 Subject: Re: Consuming ColdFusion Webservice with .NET Now, either I am doing something wrong here or the wsdl is nonsense to anything but ColdFusion. Well I at least can tell you that is not true ;-) 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 ~| 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:247781 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converting valid XHTML to Plain Text...
This can be done with XSLT: plain text is one of the possible output options. Depending on how fancy (or not) the results need to be, it might be a LOT of XSLT, but I'm pretty sure you're not the first person to want to do this, and I'd guess that you can probably find a lot of code out there on the net to get you started. Once again, this was one of the first avenues I looked for. I was not able to find an XSLT's that would try to format HTML to nicely formatted plain text (meaning it keeps the basic formatting of the text.) The biggest hurdle I see w/XSLT is that trying to convert table's to anything remotely like they look on screen is going to be difficult (if not impossible.) This is still an option, but it would take me a while to put together a complete bug-free implementation. -Dan ~| 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:247782 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd Query issue
This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps. - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org On 7/26/06, Scott Mulholland [EMAIL PROTECTED] wrote: I tried with a qryparam yesterday, no change. Selecting job_id from jobs works as well. If I run select * from information_schema.columns where table_name = 'jobs' the column comes back as well. This is one of those weird it worked fine for yrs up until yesterday and nothing in the code or table changed things. I'm thinking something is corrupt in the database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 12:32 PM To: CF-Talk Subject: Re: Odd Query issue What happens if you put it into a cfqueryparam? What happens if you select job_id from jobs? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:42:27 2006 Subject: RE: Odd Query issue I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery Scott -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. .. Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| 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:247783 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd Query issue
Does the update work in Query Analyser? Which DB is it again? What drivers you using (and what ColdFusion) This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 17:42:27 2006 Subject: RE: Odd Query issue I just wrote these two tests and ran them, same result...the select works, the update gives Invalid column name 'job_id'. cfquery name=testSelect datasource=#request.dsnName# Select * from jobs where job_id = 1 /cfquery cfquery name=testSelect datasource=#request.dsnName# Update jobs set status = 0 where job_id = 1 /cfquery Scott -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. . Ben Nadel www.bennadel.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~| 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:247784 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: tab navigator with multiple rows of tabs?
Tom Chiverton wrote: On Wednesday 26 July 2006 16:42, Rick Root wrote: Is it possible using flash forms to build a tab navigator with MULTIPLE rows of tabs? Guess what was posted on here only a few days ago... :-) Thanks for not helping, I already googled. http://www.google.com/search?hl=enlr=rls=GGLG%2CGGLG%3A2005-44%2CGGLG%3Aenq=tabnavigator+multiple+tabs+%2Bsite%3Ahouseoffusion.com I guess I'll google some more. Rick ~| 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:247785 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd Query issue
This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps. - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~| 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:247786 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Edit mode
All, I have a content management tool that I'm trying to edit an existing entry. The problem is everytime I try and edit the following data, I see the flash video instead of the code. What can I use in CF to force the code to be displayed in the form field value instead of the video gui. input name=vow_object_code type=text id=vow_object_code maxlength=100 CFIF ISDEFINED (Edit)value=cfoutput#get_vids.vow_object_code#/cfoutput/CFIF CODE BEING PASSED TO VALUE ATTRIBUTE BELOW I've taken the and and replaced them with ( and ) so the video interface doesn't start up here as well. (object width=425 height=350) (param name=movie value=http://www.domainname.com/v/qjWQNwv-GJ4;) (/param) (embed src=http://www.domainname.com/v/qjWQNwv-GJ4; type=application/x-shockwave-flash width=425 height=350) (/embed) (/object) ~| 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:247789 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reactor informational page?
Does anyone have a page that walks through using Reactor? I've found the livedocs site for it but that's more detailed. I'm looking for more of a basic informational page on it's benefits. Bueller? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| 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:247787 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Consuming ColdFusion Webservice with .NET
But you do agree that a working web service in ColdFusion should be able to be invoked via .NET out of the box? (assuming, as we have clarified, that it's simple types being passed and it's .NET safe) Absolutely! We recently wrote a tonne of webservices which are being consumed in .NETall of them return XML strings 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 ~| 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:247788 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Automated user registration
Hi. I need to provide an API to one of our partner sites to be able to create users on our database. Basically, when somebody comes to our site from our partners' site, it needs to be a API/Web service that creates a user record on our db, and returns the username and password back to the partner site so that they can store it in their database for automated logins in future. We are using CF MX 7 and our partner uses ASP .Net. Please provide some help. Can this be a web service? If so, an example app, or a little guidance would help. Thanks, Ken. ~| 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:247790 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhtmlhead and webservice woe
Brad Wood wrote: Ok, so I've got ajaxcfc running pretty smoothly, but I still need some help with my major catching point-cfhtmlhead. Don't use CFHTMLHEAD in your application.cfm or whatever then. Or, if you do, wrap code around it that causes it *NOT* to happen on ajax calls. cfif refindnocase(\.cfc,CGI.SCRIPT_NAME) is 0 cfhtmlhead ... /cfif Maybe that'd help. Rick ~| 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:247792 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Installing CFMX 7
Well. I cant find the windows firewall so I can only assume that it wasn't installed. So there shouldn't be any port blocking there. The server is behind a firewall but that shouldn't stop internal port traffic should it? It never stopped me from installing CF on other servers behind the same firewall. I did just notice that they installed McAfee Enterprise 8 on the server. It has built in port blocking but it isn't blocking the required ports as far as I can tell. I am going to try and disable it and install again to see if that will help. I tried netstat and I didn't see port 51011 listed. Doesn't that just mean nothing is connected to it at that moment? On 7/26/06, Dave Watts [EMAIL PROTECTED] wrote: I didn't get any response from the silent install portion of course but the Web Server Configuration Tool gave me the same error I got before Could not connect to and jrun/coldfusion servers on host localhost. Did you check to see if the ports used by JRun are available? 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! ~| 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:247791 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhtmlhead and webservice woe
That's funny, in CFAjax this doesn't cause a problem at all. I was just blogging about using firebug and noticed how it comes back differently in the response, so that preceding script blocks don't break the return. http://www.fergusonhouse.com/blog/index.cfm/2006/7/26/firebug-cfajax One of the other guys here at the office was having trouble trying to use AjaxCFC and when we looked at the response in firebug, you could see the differences in the response that was messing things up. Try looking at your posts and responses in firebug and you'll see the difference too. My coworker is planning to jump into the AjaxCFC code and fix this, but has yet to find the time. * Ken Ferguson 214.636.6126 * Brad Wood wrote: Ok, so I've got ajaxcfc running pretty smoothly, but I still need some help with my major catching point-cfhtmlhead. As part of my CFC, I cfsavecontent a page from our application and return the html to stick in an the innerHTML of a div on the ajax page. Our application uses cfhtmlhead a lot to stick javascript in the head of the document for various reasons. The problem is that CF appends the htmlhead information to the top of the return value that my CFC sends back to the browser and that really screws stuff up. Ajaxcfc sees this coming back from the webservice: script language=JavaScript1.2 type=text/javascript !-- This comes from the cfhtmlhead tag and totally screws up ajaxcfc -- /script _4304_1153931164505 = 'This is my content being returned'; DWREngine._handleResponse('4304_1153931164505', _4304_1153931164505); So the obvious answer here is probably Don't use cfhtmlhead you idiot, but I'm trying to NOT have to write as much as my application as possible-I want a scalable fix that will still let me include or cfmodule any page in my app and simply return the resulting HTML from the CFC. I can find every instance of cfhtmlhead and put an if statement around it or something, that that sounds like a kludgy fix. Is there a pretty way to handle this? ~Brad ~| 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:247793 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Installing CFMX 7
Well so much for disabling the McAfee. Still got the same errors. On 7/26/06, Phill B [EMAIL PROTECTED] wrote: Well. I cant find the windows firewall so I can only assume that it wasn't installed. So there shouldn't be any port blocking there. The server is behind a firewall but that shouldn't stop internal port traffic should it? It never stopped me from installing CF on other servers behind the same firewall. I did just notice that they installed McAfee Enterprise 8 on the server. It has built in port blocking but it isn't blocking the required ports as far as I can tell. I am going to try and disable it and install again to see if that will help. I tried netstat and I didn't see port 51011 listed. Doesn't that just mean nothing is connected to it at that moment? On 7/26/06, Dave Watts [EMAIL PROTECTED] wrote: I didn't get any response from the silent install portion of course but the Web Server Configuration Tool gave me the same error I got before Could not connect to and jrun/coldfusion servers on host localhost. Did you check to see if the ports used by JRun are available? 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! ~| 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:247794 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installing CFMX 7
Hey Phil, Just an FYI, using tcpview ( http://www.sysinternals.com/utilities/tcpview.html ), the ports being used by jrun on my laptop are: 1046 2522 2920 7999 8500 8999 51011 orrr after typing that out, I did a quick search on google and found this: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18336 good luck, Mike Dave Watts wrote: I didn't get any response from the silent install portion of course but the Web Server Configuration Tool gave me the same error I got before Could not connect to and jrun/coldfusion servers on host localhost. Did you check to see if the ports used by JRun are available? ~| 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:247795 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PostgreSQL 8 and CFMX 7
Greetings! I couldn't find very much information on this all in one place, and I couldn't find anything on how to do it with CFMX7, so I took the liberty of drawing up a quick-and-dirty how-to on getting CFMX 7 to talk to and work with a PostgreSQL 8 database once I got things figured out. You can check it out here: http://www.viviotech.net/docs/postgresql8_cfmx7.pdf If anyone feels like making changes to it, or explaining something better then I did, (or making a web page out of it) the original Open Office 2.0 document is here: http://www.viviotech.net/docs/postgresql8_cfmx7.odt I'd welcome any suggestions. =) I really like PostgreSQL, and it's a bummer that CFMX doesn't support it out of the box. Hope this helps! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| 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:247796 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installing CFMX 7
On 7/26/06, Phill B [EMAIL PROTECTED] wrote: Well so much for disabling the McAfee. Still got the same errors. It's worth noting that Adobe provides free installation support for ColdFusion. http://www.adobe.com/support/programs/installation.html Regards, Dave. ~| 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:247797 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Template Editor
Looking for a solution to take a HTML page that would be constructed as a template for a web user to update designated sections (i.e background colors, all text, add text, add images, etc) then save it back to HTML and would be sent in an Email. Is anyone using any type of web program or have a good solution for this? ~| 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:247798 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Edit mode
On Jul 26, 2006, at 1:41 PM, [EMAIL PROTECTED] wrote: input name=vow_object_code type=text id=vow_object_code maxlength=100 CFIF ISDEFINED (Edit) value=cfoutput#get_vids.vow_object_code#/cfoutput/CFIF Try using a textarea instead? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| 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:247799 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
spacing and cfformitem
My flash form has too much space between a cfformitem type=text and the next item on the form. I've tried both type=text with a style attribute setting the margin to 0, and I also tried type=html with the textformat tag setting leading to 0.. neither had any effect. Ideas? Rick ~| 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:247800 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Template Editor
If you want a web site builder with ready made templates, then there are a few around. Checkout these 2 http://www.swsoft.com/ http://www.sitegalore.com/ Or you could roll your own using a CMS system. Snake -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 19:32 To: CF-Talk Subject: Template Editor Looking for a solution to take a HTML page that would be constructed as a template for a web user to update designated sections (i.e background colors, all text, add text, add images, etc) then save it back to HTML and would be sent in an Email. Is anyone using any type of web program or have a good solution for this? ~| 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:247801 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
String Manipulation: get filename out of path
I have this string, C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguide.pdf I want to parse out the name of the pdf. How do I do this? D ~| 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:247802 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Installing CFMX 7
it's not so much about what ports are blocked, it's more about what ports are currently in use. i.e. you can have a web server on port 80, a firewall installed, and you still won't be able to install another web server on the same port of that machine. That's why you use a program such as tcpview to make sure the ports in question are not *already* in use by another program. mike Phill B wrote: Well so much for disabling the McAfee. Still got the same errors. ~| 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:247803 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: String Manipulation: get filename out of path
From: [EMAIL PROTECTED] I have this string, C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguide.pdf I want to parse out the name of the pdf. How do I do this? cfset FileName = GetFileFromPath(C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguid e.pdf) Sixten ~| 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:247804 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: String Manipulation: get filename out of path
Use the GetFileFromPath() function. There are a very large number of helpful CFML functions built right into the main CFML application servers--as soon as you can find the time, read through them a bit. Josh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 3:16 PM To: CF-Talk Subject: String Manipulation: get filename out of path I have this string, C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguide.pdf I want to parse out the name of the pdf. How do I do this? D ~| 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:247805 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: String Manipulation: get filename out of path
Getfilefrompath() Extracts the filename from a fully specified path. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 2:16 PM To: CF-Talk Subject: String Manipulation: get filename out of path I have this string, C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguide.pdf I want to parse out the name of the pdf. How do I do this? D ~| 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:247806 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: String Manipulation: get filename out of path
We use: #listlast(cgi.SCRIPT_NAME,'/')# ? On 7/26/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have this string, C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguide.pdf I want to parse out the name of the pdf. How do I do this? D ~| 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:247807 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Odd Query issue
Yeah, its ms-sql, and yes, does seem silly that I hadn't done that yet ;) Query analyzer gave me the same result for the update but with a better error message, Invalid column job_id, Procedure jobs_UTrig. Looks like it's an issue with one of my relationships/constraints. Thanks, Scott -Original Message- From: Brian Rinaldi [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:34 PM To: CF-Talk Subject: Re: Odd Query issue This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps. - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~| 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:247808 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: String Manipulation: get filename out of path
i was going to say listLast() as well...but getFileFromPath() (as suggested by everyone else so far) sounds like the better option. Either will work, but if I'm looking at my code later and see a getFileFromPath(), I'm going to know exactly what that snippet of code is doing. On 7/26/06, M [EMAIL PROTECTED] wrote: We use: #listlast(cgi.SCRIPT_NAME,'/')# ? On 7/26/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have this string, C:\CFusionMX7\wwwroot\Inherent\mich_state_bar\PDFS\userguide.pdf I want to parse out the name of the pdf. How do I do this? D ~| 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:247809 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Odd Query issue
Looks like you have an update trigger on the update. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Scott Mulholland [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 20:29:47 2006 Subject: RE: Odd Query issue Yeah, its ms-sql, and yes, does seem silly that I hadn't done that yet ;) Query analyzer gave me the same result for the update but with a better error message, Invalid column job_id, Procedure jobs_UTrig. Looks like it's an issue with one of my relationships/constraints. Thanks, Scott -Original Message- From: Brian Rinaldi [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:34 PM To: CF-Talk Subject: Re: Odd Query issue This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps. - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~| 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:247810 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Odd Query issue - SOLVED
Thanks for all help all, turns out a trigger on the table was referencing the job_id field in a different table that was recently changed. All the queries work now. -Original Message- From: Brian Rinaldi [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:34 PM To: CF-Talk Subject: Re: Odd Query issue This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps. - Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org ~| 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:247811 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flash form printing
Is there some quick and easy way to print the contents of a flash form if the form has a scrollbar. Currently, I can right click on it and select print, but that only prints the currently visible portion. Thanks -- There's snakes upon your ladder And there's dice upon your skirt There's lipstick on my collar And there's sweat upon my shirt ~| 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:247812 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: String Manipulation: get filename out of path
On 26 Jul 2006, at 12:34, Charlie Griefer wrote: i was going to say listLast() as well...but getFileFromPath() (as suggested by everyone else so far) sounds like the better option. I assume that getFileFromPath() uses System.getProperty (file.separator) to parse the string, which would be more portable than listLast(). -- Joseph Lamoree ~| 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:247813 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flash form printing
With a little Actionscript, you can specifically target the whole content container. Unfortunately, that doesn't do anything about the existing right click menu. !k -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 1:48 PM To: CF-Talk Subject: Flash form printing Is there some quick and easy way to print the contents of a flash form if the form has a scrollbar. Currently, I can right click on it and select print, but that only prints the currently visible portion. Thanks -- There's snakes upon your ladder And there's dice upon your skirt There's lipstick on my collar And there's sweat upon my shirt ~| 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:247814 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: execute a DTS package via Stored Proc?
I did get it working for some client. This article helped: http://www.novicksoftware.com/Articles/SQL-Server-2000-SP3-and-xp_cmdshell-Woes.htm Client had a stored proc that ran a couple DTS packages using xp_cmdshell. CF ran SP as a non-sysadmin SQL user, with execute permission on master.dbo.xp_cmdshell Here's the rule (changed in SQL 2000 SP3, and seemed like this SP broke when they did the update): Either you run xp_cmdshell as a user in the sysadmin role, in which case it runs the command as the SQL Agent service's login user (IIRC), or you have to setup the non-sysadmin job proxy account (which really was a [EMAIL PROTECTED] to get working :} ) Not sure if all these steps were necessary, but here's what we did (this was a standalone system, so no group policies applied): 1. SQL user to run needs execute permission on master.dbo.xp_cmdshell 2. Created windows user, added to computer's Administrators group (temporarily - rule out filesystem permission issues) 3. Local security policy - allow that user to Logon as Service; close, reopen the local security policy, make sure the effective policy is Allow 4. Also used the SQL EM to (temporarily) change the SQL Agent's login user to that windows user, then changed back 5. I also had to restart the SQL Agent service, and the SQL Server service. I think that's all, and not sure 4 was necessary, but it worked, and the non-sysadmin SQL user now can run xp_cmdshell, with the SQL Agent proxy user set up. - David On 7/26/06, Snake [EMAIL PROTECTED] wrote: Didn't work for me, thus why I had to go to the lengths I did. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 10:34 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? No, anyone can run it if given the necessary permissions within a proxy account. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:32 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Don't you have to be the SA in order to do exec master..xp_cmdshell @execcommand I don't remember the reasons, but I couldn't do it the easy way when I tried. I need to do it as a speciifc user who only had access to his own database. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:03 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? How do you mean? This will work if you have the correct settings in there no worries - granted it does not have any defensive stuff in their but if your DTS is say, a simple import - it will be job done. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 14:15 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? If only it were that easy. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 13:40 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc? Holy sh*^seriously long winded when this will do.. DECLARE @execcommand varchar(100) select @execcommand = 'dtsrun /Syourserver /Uusername /Ppassword /Npackagename'' exec master..xp_cmdshell @execcommand :-) ~| 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:247815 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: reading large text file
No need using DTS. One word: bcp and xp_shell to execute it and it is super fast. -Original Message- From: J W [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 6:40 AM To: CF-Talk Subject: Re: reading large text file Remember tho... DTS is great on SQL7 and SQL2000, but its GONE in SQL2005. It was replaced by the fairly overly complex SSIS (SQL Server Integration Services). Its not as cut and dry as DTS. You can import DTS tasks in as legacy within SQL2005 but We had some older tasks on SQL7 that didn't transfer over to SQL2005 right. I am not even sure if you can kick a SSIS task off within coldfusion either. Agreed. Huge text files, find some other means to import them into your database other than coldfusion. Jeff On 7/26/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I am at a loss at why it was difficult to be honest - maybe the problem was you are not an SA on the prod box as normally, a DTS setup etc is a breeze. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 14:08 To: CF-Talk Subject: Re: reading large text file Heh, Martin, I feel your pain. I just finished up a project yesterday doing the exact same thing - do a search on DTS in the archives to see all my questions about it. It isn't the easiest thing in the world to set up and get all the pieces running, but once you do,it is about 2000X faster than using CF. Of course, you need to be running SQL Server 7+ to be able to take advantage of it. So, the first question is, what flavor DB are you running? Ray Martin Thorpe wrote: Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247816 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reading large text file
No need using DTS. One word: bcp and xp_shell to execute it and it is super fast. -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 5:36 AM To: CF-Talk Subject: reading large text file Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247817 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reading large text file
Hi Martin, Just gone through a similar process with a 2.65gb csv with the uk post code db. (27 million records) I used DTS and it did take a while, but 74mb should process quite quickly. Might be worth checking the server spec? Best of luck, Jenny -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 13:36 To: CF-Talk Subject: reading large text file Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247818 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: String Manipulation: get filename out of path
Josh Adams wrote: Use the GetFileFromPath() function. There are a very large number of helpful CFML functions built right into the main CFML application servers--as soon as you can find the time, read through them a bit. I second that motion! I wrote a custom tag back in the CF 4 days to do exactly what I later found out was already handled by GetFileFromPath() DOH! =) Rick ~| 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:247819 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with cflogoff tag
personally i just have the logout process set the session username/authorization to . Works for me :-) Jenny -Original Message- From: Billingsley, Lewis - ETA CTR [mailto:[EMAIL PROTECTED] Sent: 24 July 2006 19:10 To: CF-Talk Subject: Problem with cflogoff tag Hi, I'm sort of a low-end intermediate developer. I'm having trouble getting the cflogout tag to work. I read somewhere that it was better to create an application.cfc file rather than an application.cfm file for the login framework, but with either one the logout tag does not work. My book says it takes no attributes. Someone said something about setting a timeout somewhere, but I didn't get which timeout or where - or how. It looks like the THIS scope may have a timeout I can set, but I can't figure it out. I'm not even sure if the login framework actually uses the session scope somehow, either and how I would do that if it did. As you can see, I'm in need of enlightenment. Thank you. Lewis ~| 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:247820 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Ajax and passing a ####
I tried posting this message through the houseoffusion website, but got an error, so I'll post it again. I apologize if this appears twice. If you are passing the value within Javascript, you can apply the escape() function. I had the same problem when I was doing an ajax call from within my app. But it was in the link to the page that AJAX calls, which passes url parameters. So I had to do this 'myCFCode.cfm?param1='+escape(valueToPassIn); Hope this helps, Ali ~| 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:247821 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
decrypt an old tag
I have an old custom tag I bought and paid for years and years ago and still need . Apparently, after moving it to an upgraded server (4.0 to MX), it no longer works. Apparently, the company that sold it to me is now out of business. I don't think the tag is supported or sold. It's FuseAds. The only thing I can really think to do is decrypt the tag. I remember there used to be a utility floating around out there to do it, but I can't find it. H. ~| 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:247822 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: decrypt an old tag
http://www.novabean.com/ -Original Message- From: Howard Owens [mailto:[EMAIL PROTECTED] Sent: 27 July 2006 04:40 To: CF-Talk Subject: decrypt an old tag I have an old custom tag I bought and paid for years and years ago and still need . Apparently, after moving it to an upgraded server (4.0 to MX), it no longer works. Apparently, the company that sold it to me is now out of business. I don't think the tag is supported or sold. It's FuseAds. The only thing I can really think to do is decrypt the tag. I remember there used to be a utility floating around out there to do it, but I can't find it. H. ~| 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:247823 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: decrypt an old tag
+1 -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 4:52 PM To: CF-Talk Subject: RE: decrypt an old tag http://www.novabean.com/ -Original Message- From: Howard Owens [mailto:[EMAIL PROTECTED] Sent: 27 July 2006 04:40 To: CF-Talk Subject: decrypt an old tag I have an old custom tag I bought and paid for years and years ago and still need . Apparently, after moving it to an upgraded server (4.0 to MX), it no longer works. Apparently, the company that sold it to me is now out of business. I don't think the tag is supported or sold. It's FuseAds. The only thing I can really think to do is decrypt the tag. I remember there used to be a utility floating around out there to do it, but I can't find it. H. ~| 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:247824 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Barcode Generation - HELP !!
Anyone used this and can point me in the right direction? http://www.fusionzone.com/applications/barcode/tour.cfm Thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 01:53 To: CF-Talk Subject: RE: Barcode Generation got a bit further then get: Error occurred in tag CFX_IMAGE Unexpected error occurred while processing tag.BRThe cause of this error is yet unknown. The error occurred in C:\CFusionMX\CustomTags\barcode.cfm: line 1151 Called from C:\CFusionMX\CustomTags\barcode.cfm: line 1 Called from C:\Inetpub\democart.fasttrackonline.co.uk\admin\barcodes\sample.cfm: line 24 1149 : action=IML 1150 : file=NEW 1151 : x=#bcw# 1152 : y=#bcha# 1153 : commands= -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 25/07/2006 ~| 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:247825 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Automated user registration
Can you connect directly to their DB? Is a name/password absolutely all they'll need to create a new account record? Even so, as long as they tell you what's needed to create an account that should be fine. If you can connect direct then you could create the record during the registration process on your site. Jenny -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 18:47 To: CF-Talk Subject: Automated user registration Hi. I need to provide an API to one of our partner sites to be able to create users on our database. Basically, when somebody comes to our site from our partners' site, it needs to be a API/Web service that creates a user record on our db, and returns the username and password back to the partner site so that they can store it in their database for automated logins in future. We are using CF MX 7 and our partner uses ASP .Net. Please provide some help. Can this be a web service? If so, an example app, or a little guidance would help. Thanks, Ken. ~| 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:247826 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Barcode Generation - HELP !!
We have a customer on one of our servers using it, so it does work. -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:07 To: CF-Talk Subject: RE: Barcode Generation - HELP !! Anyone used this and can point me in the right direction? http://www.fusionzone.com/applications/barcode/tour.cfm Thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 01:53 To: CF-Talk Subject: RE: Barcode Generation got a bit further then get: Error occurred in tag CFX_IMAGE Unexpected error occurred while processing tag.BRThe cause of this error is yet unknown. The error occurred in C:\CFusionMX\CustomTags\barcode.cfm: line 1151 Called from C:\CFusionMX\CustomTags\barcode.cfm: line 1 Called from C:\Inetpub\democart.fasttrackonline.co.uk\admin\barcodes\sample.cfm: line 24 1149 : action=IML 1150 : file=NEW 1151 : x=#bcw# 1152 : y=#bcha# 1153 : commands= -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 25/07/2006 ~| 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:247827 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cool feature I didn't know about
Nice Chris, thanks, saves a lot of time ! -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 19:34 To: CF-Talk Subject: Cool feature I didn't know about Most of you probably know this, but I thought I would share because I will use this all the time. How often do you need to output a total line at the bottom of a report? You probably do one of 2 things: 1) Increment a variable while outputting your query, or b) perform a query of queries. I found this trolling online and needed to share, lets say you have a query called 'getData' and a column named 'rev' and you needed a total. Just do this: #arraySum(getData['rev'])# You can use any array functions (avg, max, min) against a query column referenced like this. This seems a lot easier to read to me too! Chris Peterson ~| 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:247828 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Automated user registration
If you create a CFC and specify it as remote, then this is essentially your web service. It will even be SOAP compatible. Check livedocs.macromedia.com for more info on creating CFC's, or look in the sample apps that come with coldfusion. Snake -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 18:47 To: CF-Talk Subject: Automated user registration Hi. I need to provide an API to one of our partner sites to be able to create users on our database. Basically, when somebody comes to our site from our partners' site, it needs to be a API/Web service that creates a user record on our db, and returns the username and password back to the partner site so that they can store it in their database for automated logins in future. We are using CF MX 7 and our partner uses ASP .Net. Please provide some help. Can this be a web service? If so, an example app, or a little guidance would help. Thanks, Ken. ~| 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:247829 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading large text file
In addition to doing DTS, you could just use a bulk insert... as long as the SQL Server account has privileges to do so, coldfusion can run a bulk insert query from cfquery ... only thing is the text file has to be accessible by the SQL Server (ie, usually residing on the SQL Server machine itself) Rick ~| 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:247830 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Barcode Generation - HELP !!
It's much easier to go with your own decryption than it is to pay them for theirs. Try something like: (of course you'll have to download cfdecrypt.exe, but it's out there with a simple Google) cfdirectory action=list recurse=Yes name=mydir directory=c:\fergusonhouse\lesdon\investabiz filter=*.cf* cfloop query=mydir cfexecute name=c:\fergusonhouse\cfdecrypt.exe arguments=#directory#\#name# #replacenocase(directory,'\lesdon\','\lesdondecrypted\')#\#name# / cfoutput #directory#\#name# ||| #replacenocase(directory,'\appdir\','\appdecrypted\')#\#name#br /cfoutput /cfloop Ken Ferguson 214.636.6126 -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 4:15 PM To: CF-Talk Subject: RE: Barcode Generation - HELP !! We have a customer on one of our servers using it, so it does work. -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:07 To: CF-Talk Subject: RE: Barcode Generation - HELP !! Anyone used this and can point me in the right direction? http://www.fusionzone.com/applications/barcode/tour.cfm Thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 01:53 To: CF-Talk Subject: RE: Barcode Generation got a bit further then get: Error occurred in tag CFX_IMAGE Unexpected error occurred while processing tag.BRThe cause of this error is yet unknown. The error occurred in C:\CFusionMX\CustomTags\barcode.cfm: line 1151 Called from C:\CFusionMX\CustomTags\barcode.cfm: line 1 Called from C:\Inetpub\democart.fasttrackonline.co.uk\admin\barcodes\sample.cfm: line 24 1149 : action=IML 1150 : file=NEW 1151 : x=#bcw# 1152 : y=#bcha# 1153 : commands= -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 25/07/2006 ~| 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:247831 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Barcode Generation - HELP !!
Hi Russ, did you have to do anything not in their docs? thanks, Jenny -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:15 To: CF-Talk Subject: RE: Barcode Generation - HELP !! We have a customer on one of our servers using it, so it does work. -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:07 To: CF-Talk Subject: RE: Barcode Generation - HELP !! Anyone used this and can point me in the right direction? http://www.fusionzone.com/applications/barcode/tour.cfm Thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 01:53 To: CF-Talk Subject: RE: Barcode Generation got a bit further then get: Error occurred in tag CFX_IMAGE Unexpected error occurred while processing tag.BRThe cause of this error is yet unknown. The error occurred in C:\CFusionMX\CustomTags\barcode.cfm: line 1151 Called from C:\CFusionMX\CustomTags\barcode.cfm: line 1 Called from C:\Inetpub\democart.fasttrackonline.co.uk\admin\barcodes\sample.cfm: line 24 1149 : action=IML 1150 : file=NEW 1151 : x=#bcw# 1152 : y=#bcha# 1153 : commands= -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 25/07/2006 ~| 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:247832 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Ajax and passing a ####
Ali Awan wrote: If you are passing the value within Javascript, you can apply the escape() function. I had the same problem when I was doing an ajax call from within my app. But it was in the link to the page that AJAX calls, which passes url parameters. So I had to do this 'myCFCode.cfm?param1='+escape(valueToPassIn); I don't think that would do anything because it would just escape things that aren't friendly in URLS, but coldfusion would still see the actual values. Ie, coldfusion does not see %20, it sees a space in the url variable. Thus, you're STILL passing in # signs, and when cfajax runs its Evaluate() statement, it's still gonna evaluate the CFML functions. This really has to be fixed within cfajax itself, using the solution mentioned earlier in the thread (and posted on opensourcecf.com) Rick ~| 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:247833 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading large text file
His performance is normal when using SQL it is v.poor at this kind of thing. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Jenny Gavin-Wear [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 21:26:40 2006 Subject: RE: reading large text file Hi Martin, Just gone through a similar process with a 2.65gb csv with the uk post code db. (27 million records) I used DTS and it did take a while, but 74mb should process quite quickly. Might be worth checking the server spec? Best of luck, Jenny -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 13:36 To: CF-Talk Subject: reading large text file Hello all. I am uploading a 74 + MB tab delimited text file that I am then reading and inserting the values into a database. The problem is it always times out, or just takes too long (did not finish over night) to read the file. It is uploaded fine. Any suggestions about how I may approach this to make it work with such large files? I looked at a bit of Java code someone had posted here but it went no quicker really. I was thinking of maybe chopping the file into slices and then processing but not too sure how I would approach this. Any opinions or ideas/tips would be gratefully accepted. Thanks for reading. Cheers Martin ~| 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:247834 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reading large text file
You could upload it to the SQL box via FTP (or any machine the SQL box can see) and trigger it that way - then the file does not need to be named the same each time giving a little more flexibility. If you mean BCP then I would advise against it :-) it is not logged. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 22:26:26 2006 Subject: Re: reading large text file In addition to doing DTS, you could just use a bulk insert... as long as the SQL Server account has privileges to do so, coldfusion can run a bulk insert query from cfquery ... only thing is the text file has to be accessible by the SQL Server (ie, usually residing on the SQL Server machine itself) Rick ~| 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:247835 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Barcode Generation - HELP !!
I never used it myself so I dunno, all I know is that we have someone using it on the server. I don't recall every having to setup anything special for them though to get it to work. Although it is possible that someone else may have dealt with this client I spose, but generally any coldfusion config stuff goes through me. -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:33 To: CF-Talk Subject: RE: Barcode Generation - HELP !! Hi Russ, did you have to do anything not in their docs? thanks, Jenny -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:15 To: CF-Talk Subject: RE: Barcode Generation - HELP !! We have a customer on one of our servers using it, so it does work. -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 22:07 To: CF-Talk Subject: RE: Barcode Generation - HELP !! Anyone used this and can point me in the right direction? http://www.fusionzone.com/applications/barcode/tour.cfm Thanks, Jenny -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: 25 July 2006 01:53 To: CF-Talk Subject: RE: Barcode Generation got a bit further then get: Error occurred in tag CFX_IMAGE Unexpected error occurred while processing tag.BRThe cause of this error is yet unknown. The error occurred in C:\CFusionMX\CustomTags\barcode.cfm: line 1151 Called from C:\CFusionMX\CustomTags\barcode.cfm: line 1 Called from C:\Inetpub\democart.fasttrackonline.co.uk\admin\barcodes\sample.cfm: line 24 1149 : action=IML 1150 : file=NEW 1151 : x=#bcw# 1152 : y=#bcha# 1153 : commands= -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 25/07/2006 ~| 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:247836 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: reading large text file
Didn't he say he was using Oracle? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 23:24 To: CF-Talk Subject: Re: reading large text file You could upload it to the SQL box via FTP (or any machine the SQL box can see) and trigger it that way - then the file does not need to be named the same each time giving a little more flexibility. If you mean BCP then I would advise against it :-) it is not logged. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 22:26:26 2006 Subject: Re: reading large text file In addition to doing DTS, you could just use a bulk insert... as long as the SQL Server account has privileges to do so, coldfusion can run a bulk insert query from cfquery ... only thing is the text file has to be accessible by the SQL Server (ie, usually residing on the SQL Server machine itself) Rick ~| 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:247837 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading large text file
Yes, yes, he did. :) Snake wrote: Didn't he say he was using Oracle? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 23:24 To: CF-Talk Subject: Re: reading large text file You could upload it to the SQL box via FTP (or any machine the SQL box can see) and trigger it that way - then the file does not need to be named the same each time giving a little more flexibility. If you mean BCP then I would advise against it :-) it is not logged. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 22:26:26 2006 Subject: Re: reading large text file In addition to doing DTS, you could just use a bulk insert... as long as the SQL Server account has privileges to do so, coldfusion can run a bulk insert query from cfquery ... only thing is the text file has to be accessible by the SQL Server (ie, usually residing on the SQL Server machine itself) Rick ~| 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:247838 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reading large text file
I would except oracle to have something similar to BCP though -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: 27 July 2006 00:12 To: CF-Talk Subject: Re: reading large text file Yes, yes, he did. :) Snake wrote: Didn't he say he was using Oracle? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 26 July 2006 23:24 To: CF-Talk Subject: Re: reading large text file You could upload it to the SQL box via FTP (or any machine the SQL box can see) and trigger it that way - then the file does not need to be named the same each time giving a little more flexibility. If you mean BCP then I would advise against it :-) it is not logged. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Rick Root [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wed Jul 26 22:26:26 2006 Subject: Re: reading large text file In addition to doing DTS, you could just use a bulk insert... as long as the SQL Server account has privileges to do so, coldfusion can run a bulk insert query from cfquery ... only thing is the text file has to be accessible by the SQL Server (ie, usually residing on the SQL Server machine itself) Rick ~| 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:247839 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading large text file
If you mean BCP then I would advise against it :-) it is not logged. BCP is logged...it can be minimally logged if certain criteria are met. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| 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:247840 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reading large text file
Snake wrote: I would except oracle to have something similar to BCP though Yeah, it's called sql*loader Rick ~| 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:247841 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Converting valid XHTML to Plain Text...
Dan, Have you considered using XSL to transform it? Valid XHTML can be considered XML and CFMX does support XSL transformations (via XmlTransform()). -Jeff Dan G. Switzer, II wrote: I've been looking for a good solution to this problem for a while. I'm trying to convert valid XHTML into formatted plain text. The couple of tools I've found are all command line tools, but I'm really hoping to find a java/xslt solution. So that I'm clear, I'm looking for something that would turn something like: p This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. /p ol li Item 1 /li li Item 2 /li li Item 3 /li /ol Into: This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. 1. Item 1 2. Item 2 3. Item 3 Thanks, Dan ~| 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:247842 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
converting xls to csv
I have codes for saving in XLS, but need to change it in CSV format. What do you need to change? cfsavecontent variable=results cfcontent type=application/vnd.ms-excel table tr themployee/th thfirstname/th thmiddlename/th thlastname/th thaddr1/th thaddr2/th thcity/th thstate/th thzip/th thhmphonenbr/th thdatehired/th thtermdate/th thdepartment/th thdepartmen2/th thjobcode/th thjobdescrip/th thempstatus/th themergconta/th themergphone/th /tr cfoutput query=GetTP2000 tr td#employee#/td td#firstname#/td td#middlename#/td td#lastname#/td td#addr1#/td td#addr2#/td td#city#/td td#state#/td td#zip#/td td#hmphonenbr#/td td#datehired#/td td#termdate#/td td#department#/td td#departmen2#/td td#jobcode#/td td#jobdescrip#/td td#empstatus#/td td#emergconta#/td td#emergphone#/td /tr /cfoutput /table /cfsavecontent /body /html Cffile action=write file=D:\ bla.Get.xls output=#results# I need to keep the column headers above. tia ~| 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:247843 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4