MySQL TimeStamp error
Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 7 to TIMESTAMP. This is usually resolved by adding the following to the advanced Datasource settings under 'Connection String' in CF Admin: noDatetimeStringSync=truezeroDateTimeBehavior=convertToNull My questions is: does anyone have a more elegant solution to this? Is there a way to avoid this error without having to remember to edit new datasources first? And should this error even be thrown - after all the value is not an invalid date/time value so why does CF have issues with it? Cheers Stefan ~| 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:329285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for Select Full Tag Functionality in Aptana / CFECLIPSE
1) Does this functionality exist in the newer versions of the Aptana / CFECLIPSE IDE? Not afaik. 2) If not, then is there some similar type of functionality that will allow me to select an entire tag and perform an indent / outdent? You can use jump to matching tag to identify the appropriate one. In the latest nightly it will underline matching tags too, making selection easier. 3) If the answer is no to questions 1 and 2, then is there a way to have the Aptana / CFECLIPSE extended to provide this functionality? (I'm willing to pay a developer to create this functionality for me.) Ask on the CFE mailing list: ( http://groups.google.com/group/cfeclipse-users ) ~| 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:329286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL TimeStamp error
Which month is the zero'th month? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/21 Stefan Richter ste...@flashcomguru.com: Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 7 to TIMESTAMP. This is usually resolved by adding the following to the advanced Datasource settings under 'Connection String' in CF Admin: noDatetimeStringSync=truezeroDateTimeBehavior=convertToNull My questions is: does anyone have a more elegant solution to this? Is there a way to avoid this error without having to remember to edit new datasources first? And should this error even be thrown - after all the value is not an invalid date/time value so why does CF have issues with it? Cheers Stefan ~| 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:329287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Searching a Date Range
Thanks alot for all your help, ~| 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:329288 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL TimeStamp error
Some of you may have encountered the following error with date/time fields in MySQL: Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 7 to TIMESTAMP. This is usually resolved by adding the following to the advanced Datasource settings under 'Connection String' in CF Admin: noDatetimeStringSync=truezeroDateTimeBehavior=convertToNull My questions is: does anyone have a more elegant solution to this? Is there a way to avoid this error without having to remember to edit new datasources first? And should this error even be thrown - after all the value is not an invalid date/time value so why does CF have issues with it? First, that is in fact an invalid date/time value. Valid date/time values resolve to an actual date/time. Second, the general approach to handling this sort of problem is to explicitly pass NULLs to the database if you don't have a corresponding actual value. So, if someone leaves a field blank, you send NULL instead of an empty string, etc. If you're using CFQUERYPARAM (as you certainly should be unless you're using stored procedures) you can use the NULL attribute with a Boolean expression that resolves to true if the field is empty: cfqueryparam ... null=yesNoFormat(not len(trim(form.datefield))) 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! ~| 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:329289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Renumber pdf pages
How do I reset the page number using cfpdf? Right now I merge 3 pdf files. So the page numbers are 1,1,1,2,3,4,5. If a user tries to print out pages 1-3 they get all three pages numbered 1 and also 2 and 3, so 5 total pages. Anyway to reset the pagenumbering when I am doing the merge, or after, with cfpdf? -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ~| 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:329290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: changing cfreport format with direct link
Don't browse directly to the report. Browse to cfm page that calls the report using cfreport. Apply conditional logic there. On Dec 21, 2009 12:58 AM, Anthony Doherty a.dohe...@advancesystems.co.uk wrote: Does anyone have any idea on this??? Hi I have designed a number of reports for a user and they are exported into PDF format. I u... Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfmUnsubscribe: http://www.hous... ~| 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:329291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Renumber pdf pages
It is not really possible with pdf's: http://old.nabble.com/Re%3A-How-can-I-add-a-footer-to-display-the-page-number-automatically--p23402916.html Aside from refactoring the existing pdf's, you _might_ have some luck with CF9's removeHeaderFooter option. I have not tried it. So that is just a guess. http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7995.html -Leigh ~| 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:329292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
XMPP gateway cfc as a web service?
I've got an XMPP gateway instance set up and working nicely (I use it as a
debugging tool to send my IM client variable values, etc.).
I'd like to call this same CFC as a web service, from a different machine - is
this possible?
The http://server/xmppmsg.cfc?WSDL comes back OK, but I get the usual
Web service operation debugmsg with parameters {msg={foo}} cannot be found.
I've refreshed the services.
--
Jon
~|
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:329293
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for Select Full Tag Functionality in Aptana / CFECLIPSE
In CFEclipse, you can double-click on a tag in the outline view, and it will select the whole thing (there's also an icon for it in the outline view). It's a little dodgy, so I'll see if it's clean-up-able before the next release. I need to add some context menus anyways, so I'll add this to the context-click for tags too. I have a Swiss bank account you can transfer the money to. Not. :)p -- Do not trust all men, but trust men of worth; the former course is silly, the latter a mark of prudence. Democritus On Mon, Dec 21, 2009 at 4:09 AM, Peter Boughton wrote: 1) Does this functionality exist in the newer versions of the Aptana / CFECLIPSE IDE? Not afaik. 2) If not, then is there some similar type of functionality that will allow me to select an entire tag and perform an indent / outdent? You can use jump to matching tag to identify the appropriate one. In the latest nightly it will underline matching tags too, making selection easier. 3) If the answer is no to questions 1 and 2, then is there a way to have the Aptana / CFECLIPSE extended to provide this functionality? (I'm willing to pay a developer to create this functionality for me.) Ask on the CFE mailing list: ( http://groups.google.com/group/cfeclipse-users ) ~| 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:329294 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XMPP gateway cfc as a web service?
Do the methods have access=remote on them? ~| 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:329295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Error after new install
Hello All, I am setting up CF 8 on a new server, CentOS 5.4. I install like normal I made sure httpd-devel was installed I run the following: /opt/coldfusion8/runtime/bin/wsconfig -server coldfusion -ws Apache -bin /usr/sbin/httpd \ -script /etc/init.d/httpd -dir /etc/httpd/conf -coldfusion -v I then run: chcon --reference=/usr/sbin/httpd /opt/coldfusion8/runtime/lib/wsconfig/1/mod_jrun22.so I am getting in /var/log/httpd/error.log: [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] 127.0.0.1:51800 connect failed[20]: 13 13 Permission denied [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] could not open serverstore /opt/coldfusion8/runtime/lib/wsconfig/1/jrunserver.store: No such file or directory [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] Couldn't initialize from remote server, JRun server(s) probably down. There is no file at: /opt/coldfusion8/runtime/lib/wsconfig/1/jrunserver.store I am not sure what goes in here. I cannot hit CFIDE/Administrator either at this point due to the errors above. Does anyone have any ideas? -ML ~| 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:329296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Error after new install
The user you are running the script with needs permission to write that file. On Tue, Dec 22, 2009 at 10:04 AM, Jason Slack applesl...@gmail.com wrote: Hello All, I am setting up CF 8 on a new server, CentOS 5.4. I install like normal I made sure httpd-devel was installed I run the following: /opt/coldfusion8/runtime/bin/wsconfig -server coldfusion -ws Apache -bin /usr/sbin/httpd \ -script /etc/init.d/httpd -dir /etc/httpd/conf -coldfusion -v I then run: chcon --reference=/usr/sbin/httpd /opt/coldfusion8/runtime/lib/wsconfig/1/mod_jrun22.so I am getting in /var/log/httpd/error.log: [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] 127.0.0.1:51800connect failed[20]: 13 13 Permission denied [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] could not open serverstore /opt/coldfusion8/runtime/lib/wsconfig/1/jrunserver.store: No such file or directory [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] Couldn't initialize from remote server, JRun server(s) probably down. There is no file at: /opt/coldfusion8/runtime/lib/wsconfig/1/jrunserver.store I am not sure what goes in here. I cannot hit CFIDE/Administrator either at this point due to the errors above. Does anyone have any ideas? -ML ~| 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:329297 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 Error after new install
The user you are running the script with needs permission to write that file. I am root ~| 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:329298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Error after new install
That doesnt mean root has permission to write to that directory. Have you tried listing that direcotry to see what user and group has permission? On Tue, Dec 22, 2009 at 1:03 PM, Jason Slack applesl...@gmail.com wrote: The user you are running the script with needs permission to write that file. I am root ~| 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:329299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Error after new install
Hi Andrew, That doesnt mean root has permission to write to that directory. Have you tried listing that direcotry to see what user and group has permission? Oh, on /opt/coldfusion8 it is nobody:root on /opt/coldfusion8/runtime/bin where wsconfig is it is: drwxrwxr-x 2 nobody root 4096 Dec 20 16:05 bin I think the installer did that. What should it be? Would I then do a chown -R user:group? -Jason ~| 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:329300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Error after new install
not 100% sure to be honest, if you installed with sudo ./coldfusion.bin then it will use the correct permissions. The error message is very clear that the file can't be accessed due to permissions, but what you have showed seems to be fine. I'll need to double check my VPS install on the permissions but it sounds like what you have is fine. Also it is never a good idea to log in as root, and you would be better of logging in as a user and using sudo. If you are 100% behind a firewall or not internet or public network you will be fine, but it is a good habit to get out of anyway. On Tue, Dec 22, 2009 at 3:37 PM, Jason Slack applesl...@gmail.com wrote: Hi Andrew, That doesnt mean root has permission to write to that directory. Have you tried listing that direcotry to see what user and group has permission? Oh, on /opt/coldfusion8 it is nobody:root on /opt/coldfusion8/runtime/bin where wsconfig is it is: drwxrwxr-x 2 nobody root 4096 Dec 20 16:05 bin I think the installer did that. What should it be? Would I then do a chown -R user:group? -Jason ~| 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:329301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Load CF Page - get asked to save binary data?
HI All, CF 8.01 and CentOS 5.4 I am moving along further, not CF loads great, Apache loads mod_jrun22.so. When I try to get to: http://my ip/cfide/administrator/index.cfm FireFox asks me to save the untyped binary data (a dialog box comes up) I recall this happening before, I just dont recall the fix and Google is not helping me. Can anyone point me in the right direction? ~| 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:329302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Load CF Page - get asked to save binary data?
I've seen this before when hitting a cf server before Apache has been configured right. Usually, it takes a browser restart to get the correct mime type to get through - 'cause the browser caches it. Mark On Tue, Dec 22, 2009 at 4:58 PM, Jason Slack applesl...@gmail.com wrote: HI All, CF 8.01 and CentOS 5.4 I am moving along further, not CF loads great, Apache loads mod_jrun22.so. When I try to get to: http://my ip/cfide/administrator/index.cfm FireFox asks me to save the untyped binary data (a dialog box comes up) I recall this happening before, I just dont recall the fix and Google is not helping me. Can anyone point me in the right direction? ~| 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:329303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XMPP gateway cfc as a web service?
On Mon, Dec 21, 2009 at 12:27 PM, Jon Sala rexha...@gmail.com wrote: I've got an XMPP gateway instance set up and working nicely (I use it as a debugging tool to send my IM client variable values, etc.). I'd like to call this same CFC as a web service, from a different machine - is this possible? Since the CFC is a regular ol' CFC, yes, as long as you set access=remote on the methods. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies US -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:329304 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 Error after new install
HI Jason, Can you manually create a file jrunserver.store under /opt/coldfusion8/runtime/lib/wsconfig/1/ and try and see if it works. Thanks, Asha. -Original Message- From: Jason Slack [mailto:applesl...@gmail.com] Sent: Tuesday, December 22, 2009 4:34 AM To: cf-talk Subject: CF Error after new install Hello All, I am setting up CF 8 on a new server, CentOS 5.4. I install like normal I made sure httpd-devel was installed I run the following: /opt/coldfusion8/runtime/bin/wsconfig -server coldfusion -ws Apache -bin /usr/sbin/httpd \ -script /etc/init.d/httpd -dir /etc/httpd/conf -coldfusion -v I then run: chcon --reference=/usr/sbin/httpd /opt/coldfusion8/runtime/lib/wsconfig/1/mod_jrun22.so I am getting in /var/log/httpd/error.log: [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] 127.0.0.1:51800 connect failed[20]: 13 13 Permission denied [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] could not open serverstore /opt/coldfusion8/runtime/lib/wsconfig/1/jrunserver.store: No such file or directory [Mon Dec 21 13:17:34 2009] [notice] jrApache[2511: 56737] Couldn't initialize from remote server, JRun server(s) probably down. There is no file at: /opt/coldfusion8/runtime/lib/wsconfig/1/jrunserver.store I am not sure what goes in here. I cannot hit CFIDE/Administrator either at this point due to the errors above. Does anyone have any ideas? -ML ~| 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:329305 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
