Re: CF 8 Crash "ColdFusion 8 Application Server service terminated with service-specific error 2 (0x2)."
We JUST ran into this same error. The cause was we editted the max amount of RAM the JVM could use (via cf administrator>Java and JVM - to 2048 MB -- our server has 4096 MB. (We did this a few weeks ago, and forgot about it. We just rebooted, and whack - the cf service would not start. We manually opened jvm.config in notepad, decreased it back to 1024 MB and everything working now. Matts >We finally fixed this. > >Not sure WHY (suspect an almost full HD) but the /runtime/jre/bin/ >folder was empty after applying the 8.0.1 update. Just copied the >files from an 8.0.0 installation and reran the update. Things "appear" >to be working now but who knows how much longer i'll be able to say >that :) > >jonese > > >> ~| 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:333966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Web Service File Permission Issue
Hi All, Rick, thank you for moving this over to CF-Talk... appreciate your efforts. To answer some questions. 1. Create file (I have remote desktopped in, as Administrator) in that directory, created a .txt file, it has the following permissions: - Administrator, Network Service, Domain User (IUSR_this domain)... (among others) readable via HTTP://www.thisdomain.com/services/captcha/image_store/theFileiJustCreated.txt 2. Have I set the temp directory in ImageCFC... no it is its default of: 3. The file created by the image.cfc when invoked as a web service has permissions of: Administrator IUSR_domain_making_the_request System 4. The /services/captcha/image_store/ folder has permissions set to: Administrator IUSR_creating/this_domain etc... all set to propagate to child objects etc... **This app/service was working with CFMX 7.x During upgrade we also moved some domains around etc... and I think a file permission issue cropped up. Originally we were running this service on the 'default IIS6.0' domain, and we moved it to another domain (same machine, same IP etc). We have checked hosts file in windows/system32/drivers/etc -- originally this was causing an issue where CF admin could not 'register' the service as our firewall prevents browsing of domains on our machine (some dns setup thing).. so we have set hosts to send any requests to www.theservicesdomain.com to our internal 192.168.168.2 (this is a shared IP for about 35 domains)... not sure if that would have anything to do with this -- can't imagine it would?? Many thanks, Matts ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Service File Permission Issue
Hi All, Rick, thank you for moving this over to CF-Talk... appreciate your efforts. To answer some questions. 1. Create file (I have remote desktopped in, as Administrator) in that directory, created a .txt file, it has the following permissions: - Administrator, Network Service, Domain User (IUSR_this domain)... (among others) readable via HTTP://www.thisdomain.com/services/captcha/image_store/theFileiJustCreated.txt 2. Have I set the temp directory in ImageCFC... no it is its default of: 3. The file created by the image.cfc when invoked as a web service has permissions of: Administrator IUSR_domain_making_the_request System 4. The /services/captcha/image_store/ folder has permissions set to: Administrator IUSR_creating/this_domain etc... all set to propagate to child objects etc... **This app/service was working with CFMX 7.x During upgrade we also moved some domains around etc... and I think a file permission issue cropped up. Originally we were running this service on the 'default IIS6.0' domain, and we moved it to another domain (same machine, same IP etc). We have checked hosts file in windows/system32/drivers/etc -- originally this was causing an issue where CF admin could not 'register' the service as our firewall prevents browsing of domains on our machine (some dns setup thing).. so we have set hosts to send any requests to www.theservicesdomain.com to our internal 192.168.168.2 (this is a shared IP for about 35 domains)... not sure if that would have anything to do with this -- can't imagine it would?? Many thanks, Matts ~| 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:287593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cftimer does not work
Hi all, CF 8.01 Standard Windows 2003 I cannot get cftimer to display anything -- dont think it is even running. I HAVE checked the following boxes in CFADMIN Debug Output Settings> - Enable Robust Exception Information (CHECKED) - Enable AJAX Debug Log Window (CHECKED) - Enable Request Debugging Output (CHECKED) Custom Debugging Output - Timer Information (CHECKED) (all of these ones are checked except flash compile errors and messages. This is the code I've put on the page REST OF MY CFCODE -- nothing ever appears (I dont need a special URL.string i.e. ?debug=true) right? I get no errors, page displays just fine (minus the lack of cftimer info). Many thanks for any help! Matts ~| 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:311422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Alter table - modifying an Enum field in MYSQL
Hi All, Have run across a VERY STRANGE behaviour in CF 8.01 / mySQL 5.0 I've got a code snippet to modify vaules in an enum field in our database. ALTER TABLE the_table MODIFY the_field ENUM(#my_new_list#) NOT NULL; ; Results in an CF/mySQL error... for SOME reason my_new_list when inside the gets transformed to "A","B","C","D".. which mySQL does not like. I have found that if use: ALTER TABLE the_table MODIFY the_field ENUM('#ListChangeDelims(my_new_list,"','")#') NOT NULL; Things work... Anyone have a reason why the first does not work.. and I hope this saves someone some grief! Cheers, Matts ~| 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:311494 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Alter table - modifying an Enum field in MYSQL
Wow, CF developer for too many years, and I've never come across that tag before... many thanks Azadi! Matts >cf by default will escape single quotes in the sql statement values by >doubling them. use #PreserveSingleQuotes(my_new_list)# function to >counter this. > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > > >Developer MediaDoc wrote: >> ~| 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:311507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftimer does not work
Anyone else experiencing this behaviour? Thanks, Matts >Hi all, > >CF 8.01 Standard >Windows 2003 > >I cannot get cftimer to display anything -- dont think it is even running. > >I HAVE checked the following boxes in CFADMIN >Debug Output Settings> >- Enable Robust Exception Information (CHECKED) >- Enable AJAX Debug Log Window (CHECKED) >- Enable Request Debugging Output (CHECKED) > >Custom Debugging Output >- Timer Information (CHECKED) > (all of these ones are checked except flash compile errors and messages. > >This is the code I've put on the page > > > REST OF MY CFCODE > > >-- nothing ever appears (I dont need a special URL.string i.e. ?debug=true) >right? > >I get no errors, page displays just fine (minus the lack of cftimer info). > >Many thanks for any help! > >Matts ~| 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:311523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cftimer does not work
Oh boy, thanks a TON RAY... somehow some IP's got in the IP restrictions, so that was the cause... MANY MANY thanks, this has 'bugged' me for 1/2 a year! Matts >Check the IP restrictions for db output in the admin. > > > >> Hi all, >> >> CF 8.01 Standard >> Windows 2003 >> >> I cannot get cftimer to display anything -- dont think it is even running. >> ~| 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:311598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RegEx (REMatch) experts?
Hi All, Have NOT ventured into regular expressions much at all. Now I have the need for one, and wonder if anyone has one made for this scenario. Search engine, want user to be able to enter multiple words, also phrases. Want my SQL to loop over the phrases and words with an AND... (the SQL I can handle!). For example, user types in "Healthy Eating" kids schools "Ontario Canada" ReMatch would produce an array of Healthy Eating kids schools Ontario Canada my SQL search would loop over these 4 words/phrases. I've found a PHP regex that does this exact thing.. but the syntax must be different in CF and PHP for the regex part. preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), $match_words); Anyone have a CF equivalent? Thanks a bunch, Matts ~| 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:313354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx (REMatch) experts?
Thanks to those who have provided some guidance (on and off list)! Note to those still using ReFIND (and its kin)... REMatch removes the need to do any substring manipulations -- it throws the results into an array as is! Here is the solution Cheers, Matts > Hi All, > > Have NOT ventured into regular expressions much at all. Now I have the > need for one, and wonder if anyone has one made for this scenario. > > Search engine, want user to be able to enter multiple words, also > phrases. Want my SQL to loop over the phrases and words with an AND... > (the SQL I can handle!). > > For example, user types in "Healthy Eating" kids schools "Ontario > Canada" > > ReMatch would produce an array of > Healthy Eating > kids > schools > Ontario Canada > > my SQL search would loop over these 4 words/phrases. > > I've found a PHP regex that does this exact thing.. but the syntax > must be different in CF and PHP for the regex part. > > preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), > $match_words); > > Anyone have a CF equivalent? > > Thanks a bunch, > > Matts ~| 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:313394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx (REMatch) experts?
Thanks to those who have provided some guidance (on and off list)! Note to those still using ReFIND (and its kin)... REMatch removes the need to do any substring manipulations -- it throws the results into an array as is! Here is the solution Cheers, Matts > Hi All, > > Have NOT ventured into regular expressions much at all. Now I have the > need for one, and wonder if anyone has one made for this scenario. > > Search engine, want user to be able to enter multiple words, also > phrases. Want my SQL to loop over the phrases and words with an AND... > (the SQL I can handle!). > > For example, user types in "Healthy Eating" kids schools "Ontario > Canada" > > ReMatch would produce an array of > Healthy Eating > kids > schools > Ontario Canada > > my SQL search would loop over these 4 words/phrases. > > I've found a PHP regex that does this exact thing.. but the syntax > must be different in CF and PHP for the regex part. > > preg_match_all('#(?:"([^"]+)")|([^ ]+)#', trim($keywords), > $match_words); > > Anyone have a CF equivalent? > > Thanks a bunch, > > Matts ~| 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:313395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Redirecting
Hi All, Have a site whose DNS is not controlled by us. They (the DNS controllers), have setup a URL to redirect at the DNS level (so they tell me), www.abc.com/french to come to our site via an IP address. When we get this visitor, they need to get to our FRENCH page. Our standard default page is the english one. I've looked through the CGI scope, and there is ZERO indication in that scope that they are coming from www.abc.com/french (our HTTP referrer is empty string). Is there anyway WE can get this to work, or is it on their end at the DNS. (Its a government client, so any changes we request take ~ 1 month!). We are on CF 7.0, IIS 6.0. Many thanks, Matts ~| 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:314678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RegEx (REMatch) experts?
A quick follow up to this, and some improved code (thanks to those on the RegEx list). (?:"([^"]+)")|([^ ]+) Cheers, Matts ~| 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:315169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Converting an AJAX response to coldfusion object
Hi all, I am probably not using the correct 'language' here -- forgive me new to the AJAX world. I have a lovely cfgrid populated by binding it to a CFC. Everything works great. I have some 'filters' that let the users filter the data in the grid. Now the client has asked to have a 'download grid data to excel.' I've done this many times in the past - just not with AJAX data. Now I am stuck. The data is in a javascript object, which I'd like to convert to a coldfusion object. I've tried statements like and I've set 'theData' via javascript like var theData= ColdFusion.Grid.getGridObject('resource_list'); But I keep getting errors on variable theData not found. a) if I don't specify returnFormat in my CFC, what format does cfgrid data come back as? (JSON, WDDX?). b) how can I convert the javascript object into a coldfusion object? c) or should I be doing something totally different :-) I am missing something -- help/suggestions much appreciated! Cheers, Matts ~| 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:328563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Converting an AJAX response to coldfusion object
Thank you all kindly for your suggestions. I followed instructions on the Blog mentioned. called this function: function doDownload() { var mygrid = ColdFusion.Grid.getGridObject('reg_list'); var mydata = mygrid.getDataSource(); var params = mydata.lastOptions.params; var dir = params.dir; var searchString = document.reg_form.searchString.value; var campus_code = document.reg_form.campus_select.value; var start_dt = document.reg_form.start_dt.value; var end_dt = document.reg_form.end_dt.value; var year = '#contest_year#'; document.location.href='download.cfm?year='+year+'&searchString='+searchString+'&campus_code='+campus_code+'&start_dt='+start_dt+'&end_dt='+end_dt; } Which invoked the cfc that bound to my grid. Works like a charm! Many many thanks, Matts ~| 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:328581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Saving Form Structure to use on another page
Hi all, I've run into a similar issue... and my brain is frozen as well :-) I want my form processing page to copy the FORM structure into a session variable, so that it can be used on other pages for the same user. I have session management turned on. SHOULD copy the FORM structure into a SESSION key called FORM, with the FORM structure in it. If I cfdump SESSION I see it. But when I access any other page in the app, the SESSION.FORM exists, but is empty... CF is clearing out that key/value... All my other 'simple' session variables are still there... any ideas? Regards, Matts ~| 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:302114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFGRID / SQL - am I dreaming?
Hi Everyone, I have a great ajax/cfgrid mockup working. Sorting, filtering etc.. all working very well. Client has just asked if I can extend it a little more. Gridrow 1 = "Title" they would like the words "NEW" to be prefixed to the title (and stand out in a bold, coloured font) if the item has a create date that is 3 months from today. I need to do this either at the SQL select or after if I re-parse the recordset and change the field "Title" to include this information. Creating another column in the cfgrid is not an option. So my quesiton. 1. Is this possible in SQL? (using if/then and insert (not insert into table, but insert something into a Select returned field) statements??) I'd need someting like IF create_d between <3 months ago> and Then INSERT(title,0,0,'NEW') AS new_title (the insert syntax is: (field, location, replace x chars, replaced text) OR 2. Can I parse through a recordset in CF 8 (in a CFC) add this where needed and still return a query that the grid is bound to? Anyone have a code sample that does this? Many thanks, Matts ~| 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:305326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGRID / SQL - am I dreaming?
Hi Matts, I would suggest the following: This will work in cfgrid, you will get your results displayed in cfgrid with the HTML code to support a bolded, coloured "NEW". > Hi Everyone, > > I have a great ajax/cfgrid mockup working. Sorting, filtering etc.. > all working very well. Client has just asked if I can extend it a > little more. > > Gridrow 1 = "Title" > they would like the words "NEW" to be prefixed to the title (and stand > out in a bold, coloured font) if the item has a create date that is 3 > months from today. > > I need to do this either at the SQL select or after if I re-parse the > recordset and change the field "Title" to include this information. > Creating another column in the cfgrid is not an option. > > So my quesiton. > > 1. Is this possible in SQL? (using if/then and insert (not insert into > table, but insert something into a Select returned field) > statements??) > > I'd need someting like > IF create_d between <3 months ago> and > Then > INSERT(title,0,0,' style="font-style:bold;color:#00;">NEW') AS new_title > > (the insert syntax is: (field, location, replace x chars, replaced > text) > > OR > > 2. Can I parse through a recordset in CF 8 (in a CFC) add this where > needed and still return a query that the grid is bound to? Anyone have > a code sample that does this? > > Many thanks, > > Matts ~| 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:305333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MS WORD DOCX Question
Hi All, I have a working app that lets users upload docs to a clients 'admin' people. Recently a few users have been uploading MS OFFICE 2008, MS WORD .docx files. The 'admin' people dont have this latest version, but have downloaded the compatibility pack that lets them open them. Trouble is on the admin side of the application Im using a redirect to the file on the file system (redirects to say http://www.theirdomain.com/files/the_file.docx - and I get an "The request is not supported." error. Okay, try via then , and it opens in MSWORD, but even though MS WORD has the compatibility pack === no luck. I have tried changing the type="application/msword" to a variety of mime formats.. still no luck. So does anyone have any suggestions? I'd settle for them being able to click on hyperlink download/save file, then open it in MS WORD (where word could then convert). Thanks, Matts ~| 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:321634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MS WORD DOCX Question
Thanks Jason, that indeed provided the solution. I used the following two articles to setup the new mime types. http://sensisbledefault.wordpress.com/2007/03/05/office-2007-iis-6-mime-types-docx-pptx-xlsx/ http://support.microsoft.com/kb/936496 (This third described added MIME TYPES in another location in IIS - which did not work). http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/cd72c0dc-c5b8-42e4-96c2-b3c656f99ead.mspx?mfr=true Cheers, Matts >Some notes on the right MIME type for the Office 2007 formats, which IIS6 >doesn't know how to handle. > >http://www.jameskovacs.com/blog/ConfiguringIIS6ToServeOffice2007FileFormats. >aspx ~| 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:321636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4