MySQL TimeStamp error

2009-12-21 Thread Stefan Richter
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

Re: Looking for Select Full Tag Functionality in Aptana / CFECLIPSE

2009-12-21 Thread Peter Boughton
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

Re: MySQL TimeStamp error

2009-12-21 Thread James Holmes
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.

Re: Searching a Date Range

2009-12-21 Thread Damo Drumm
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:

Re: MySQL TimeStamp error

2009-12-21 Thread Dave Watts
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

Renumber pdf pages

2009-12-21 Thread David Mineer
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

Re: changing cfreport format with direct link

2009-12-21 Thread David Mineer
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

Re: Renumber pdf pages

2009-12-21 Thread Leigh
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

XMPP gateway cfc as a web service?

2009-12-21 Thread Jon Sala
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

Re: Looking for Select Full Tag Functionality in Aptana / CFECLIPSE

2009-12-21 Thread denstar
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

Re: XMPP gateway cfc as a web service?

2009-12-21 Thread Jason Fisher
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:

CF Error after new install

2009-12-21 Thread Jason Slack
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

Re: CF Error after new install

2009-12-21 Thread Andrew Scott
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

Re: CF Error after new install

2009-12-21 Thread Jason Slack
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:

Re: CF Error after new install

2009-12-21 Thread Andrew Scott
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

Re: CF Error after new install

2009-12-21 Thread Jason Slack
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

Re: CF Error after new install

2009-12-21 Thread Andrew Scott
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

Load CF Page - get asked to save binary data?

2009-12-21 Thread Jason Slack
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

Re: Load CF Page - get asked to save binary data?

2009-12-21 Thread Mark Mandel
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

Re: XMPP gateway cfc as a web service?

2009-12-21 Thread Sean Corfield
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

RE: CF Error after new install

2009-12-21 Thread Asha K S
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