Re: problems querying date in access 2007

Is your original query actually missing the quotes? Because this: WHERE expenseDate > #1/1/2006# means WHERE expenseDate > 0.000498 mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 3 March 2010 11:05, GLM wrote: > > I don't use access too often and there a

How do people transfer data between databases nowdays?

Now that my dev machine is being rebuilt, one of the things i have to do is work out if the way I've been doing things is still the best way of doing them. The subject that's exercising my mind right now is how to transfer data between my staging MS SqlServer2005 database and the production datab

Re: date calculations driving me batty!!

> OK - THIS works __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| Want

Re: migrating to coldfusion 9

We had a problem with all the sandboxes. I'm not sure if we could have organised it differently but after the upgrade, all the sites where we had set up sandboxes so they could have cffile and cfdirectory and createobject enabled, were broken for most of a day until we could create them all aga

Re: date calculations driving me batty!!

ered there correctly. > > > > __ Information from ESET NOD32 Antivirus, version of virus signature > database 4910 (20100302) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > ~~

Re: date calculations driving me batty!!

t; ______ Information from ESET NOD32 Antivirus, version of virus > signature database 4910 (20100302) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > ~| Wa

problems querying date in access 2007

I don't use access too often and there appears to be major differences between 2003 and 2007. I've just wasted the last 2 hours trying to get a simple query to work. I'm trying to make a basic query for example: WHERE expenseDate > #1/1/2006# and < #1/1/2007#. Every query except for

Re: date calculations driving me batty!!

rectly* as as 21 days Checking the database - the dates ARE getting entered there correctly. __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. htt

Re: date calculations driving me batty!!

I did not test it, but maybe try changing it to this? ** The ## is causing a evaluation and is not needed when used like this. Maybe it is causing the issue. -- /Kevin Pepperman "They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety."

date calculations driving me batty!!

dates - it's a day off again... Anybody have ANY ideas whatsoever? I sure don't ______ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~~~

CFDIVs within custom tag problem

Hi devs! I have run into a strange problem that probably has a simple fix but I can't work it out. I have tag cf_commentform that displays a feedback cfform within a cfdiv. The user enters comments, and the form submits inline. Works great. Some pages call cf_commentform more than once.

RE: CF8 richtext cfextarea: remove styling from pasted txt?

Thanks Will. That sounds familiar now that I think about it. Cheers. -Original Message- From: Will Swain [mailto:w...@hothorse.com] Sent: March-02-10 7:58 PM To: cf-talk Subject: RE: CF8 richtext cfextarea: remove styling from pasted txt? I'm guessing it's a typo and he means the 'Pas

RE: CF8 richtext cfextarea: remove styling from pasted txt?

I'm guessing it's a typo and he means the 'Paste from Word' function of the richtext editor - it's a toolbar option. -Original Message- From: Paul H [mailto:p...@smashedvision.com] Sent: 03 March 2010 00:42 To: cf-talk Subject: RE: CF8 richtext cfextarea: remove styling from pasted txt?

RE: CF8 richtext cfextarea: remove styling from pasted txt?

Sorry Tony could you please clarify what you mean by "paste from work function"? I'm not sure how to go about that. Thanks again. -Paul -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: March-02-10 7:16 PM To: cf-talk Subject: Re: CF8 richtext cfextarea: remove s

Re: CF8 richtext cfextarea: remove styling from pasted txt?

And still maintain links, bold italics, etc? Paste from work function and check 'ignore font face definitions' and check 'remove styles definitions'. Otherwise they can always first copy to notepad then copy from notepad to the editor. ~~

RE: migrating to coldfusion 9

The only thing I know about is that you need to brace yourselves lest you are blown away by the fact that it will be 40 faster than what you are used to. :) http://www.adobe.com/products/coldfusion/pdfs/cf9_performancebrief_ue.pdf ~Brad Original Message Subject: migrating to

CF8 richtext cfextarea: remove styling from pasted txt?

I've put together a very simple html editor for a client using the cf8 richtext cftextarea but the problem I'm having is that whenever the users cut and pastes, the styling of their original data (most often from MS Word) is also pasted into the text area. Is there an easy way to automatically re

RE: Prevent Cross-Site Scripting in ColdFusion 5

It's easy enough to write your own function for this sort of thing. Here's the basis of how I might approach it: At that point you could do anything you wanted to with REQUEST.key or REQUEST.value. andy -Original Message- From: Donnie Carvajal [mailto:donnie.carv

Re: migrating to coldfusion 9

sounds good, thanks for your feedback. >We have started to move some applications to CF9. No real issues as it was >a full Flex frontend other then a few of our own mistakes where we may have >left something un var scoped. Which while it cause some errors ( fixed in < >5 mins ) are good thing

Re: Prevent Cross-Site Scripting in ColdFusion 5

I have checked CFLib.org. They have a couple of UDF's for handling URL variables, but nothing that appeared like it would parse through CGI.query_string or use some sort of regular expression to encode or remove unwanted vars without losing the variables by encoding the ampersand and equal si

Re: Prevent Cross-Site Scripting in ColdFusion 5

Have you checked CFLib.org yet? Great collection of UDF's. Maybe something there that can help you. Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/l

Re: migrating to coldfusion 9

We have started to move some applications to CF9. No real issues as it was a full Flex frontend other then a few of our own mistakes where we may have left something un var scoped. Which while it cause some errors ( fixed in < 5 mins ) are good things IMO as it encourages better coding practise.

Prevent Cross-Site Scripting in ColdFusion 5

I have an app that is written in ColdFusion 5 and there are several places in the app where CGI.query_string is used to set the query string on the href of an anchor tag. I need a clean way to scrub the CGI.query_string variable. I can't use URLEncodedFormat because all of the ampersands and

migrating to coldfusion 9

hi, we are starting the process from migrating our coldfusion 8 applications to a coldfusion 9 server. i havent found issues by searching the web, is there anything we should look out for? thanks ~| Want to reach the ColdF

Re: Local DEV setup, multiple projects/websites

On Tue, Mar 2, 2010 at 3:09 AM, Kevin Pepperman wrote: ... > The config files can be generated using ANT, so a config file can exist for > every possible situation from the beginning of a project. Ant ROCKS! I used to want to mirror the environments too, going so far as making VM images and what

RE: Why, oh why won't my batch file run via cfexecute?

Thanks for the help and tips, Dave! It would be nice to know for *certain* what the issue was. I'm still not sure what was causing CF9 to go offline and then refuse to restart after attempting to run some of the .bat files. I'm not even sure that was the problem. With this last install of CF9,

Re: Why, oh why won't my batch file run via cfexecute?

> So, it turns out that the account under which the CF service is running > is critical for executing .bat files involving local software. Service accounts may often have trouble running things that you can run under your own account. This could be caused by permissions or different environment v

Re: Why, oh why won't my batch file run via cfexecute?

> Before having a chance to run with ProcMon, I reinstalled CF9 > tested the bat file without success, decided to change the > logon account setting to "Interact with Desktop" (or whatever it says), > as I remember having an issue with that...but I think that was when I was > trying to use a third

RE: Serious, intermittent problem with CF Web Service

So the dev site hits the WS fine and the live site is intermittent - and they share the same physical server? Do they share the same instance of CF? Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Leon Mi

RE: Why, oh why won't my batch file run via cfexecute?

Well, it turns out that the problem (up to this point) was the account that the CF service was running under. It was on the default "Local Account". I changed that to allow "Interact with Desktop", but that wasn't enough. I then changed to the service to run under my personal user account and t

Re: Serious, intermittent problem with CF Web Service

> I doubt that we're going to upgrade to CF9. The thought of paying $4000 to > Adobe for an upgrade that may or may not fix our > problem (and is sure to come with its own new problems) just turns my stomach. Well, I'd definitely recommend that you try the 30-day trial first! You might also want

Re: Serious, intermittent problem with CF Web Service

Nope. They're on the same physical server and using the same DNS. ~| 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/gro

Re: Serious, intermittent problem with CF Web Service

I doubt that we're going to upgrade to CF9. The thought of paying $4000 to Adobe for an upgrade that may or may not fix our problem (and is sure to come with its own new problems) just turns my stomach. I hate having to upgrade for bug fixes! I'm going to be looking at Bluedragon and Railo. I'm

RE: Why, oh why won't my batch file run via cfexecute?

Before having a chance to run with ProcMon, I reinstalled CF9 tested the bat file without success, decided to change the logon account setting to "Interact with Desktop" (or whatever it says), as I remember having an issue with that...but I think that was when I was trying to use a third party FTP

Re: Why, oh why won't my batch file run via cfexecute?

Run ProcMon while making the request. http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx >If all else fails, it may be worth trying the System Command contribution on >Ria. > >http://systemcommand.riaforge.org/ > >That way you can get the error returned to the output. >

RE: Local DEV setup, multiple projects/websites

I believe it is IIS7...I don't think there was a new IIS release with 7. I remember reading an article written by the guy in charge of the division that integrates IIS with Windows. Apparently after IIS 5.1 (the crippled XP Pro version), they got beat up so bad by developers, he said he was NEVE

Re: Local DEV setup, multiple projects/websites

> > IIS on XP (and I believe Vista and Win7 that aren't server versions) > doesn't allow multiple sites. It only allows for 1 site. That's why > our development team runs apache locally. > That is what got me using Apache locally. After a while I actually started to prefer Apache over IIS. I h

RE: Local Server Crashes - How to back up settings

Thanks this will help a lot I hope! -Original Message- From: Jacob [mailto:ja...@excaliburfilms.com] Sent: Tuesday, March 02, 2010 10:30 AM To: cf-talk Subject: RE: Local Server Crashes - How to back up settings What I backup.. In the ColdFusion directory: \bin\neo-*.xml (Your CF Ad

Re: Local DEV setup, multiple projects/websites

IIS on Vista and Windows 7 does allow for multiple sites. Just saying. Vista runs IIS7. not sure what Win7 runs, I'm not on a Windows 7 machine here. On Tue, Mar 2, 2010 at 10:29 AM, Scott Brady wrote: > > IIS on XP (and I believe Vista and Win7 that aren't server versions) > doesn't allow mu

RE: Local DEV setup, multiple projects/websites

Scot, You can still use XP (and Win 2000 standard) and IIS and have multiple sites if you install a very useful utility XP Pro IIS Admin by JetStat.com You can add in XP IIS many sites and through the utility to acticate the site you want work on. I use it long time and it's just fine. No proble

RE: Local Server Crashes - How to back up settings

What I backup.. In the ColdFusion directory: \bin\neo-*.xml (Your CF Admin settings) \webroot\WEB-INF\web.xml \customtags\*.* If I have to reinstall, all my settings and custom tags are there. When I build a new server, I copy the above and everything works. -Original Message- From:

Re: Local DEV setup, multiple projects/websites

IIS on XP (and I believe Vista and Win7 that aren't server versions) doesn't allow multiple sites. It only allows for 1 site. That's why our development team runs apache locally. It's not ideal, since our production environments are IIS, but other than mod-rewrite/ISAPI rewrite and slightly dif

Local Server Crashes - How to back up settings

Hi all, So I still don't have ColdFusion working. I've decided to just reinstall CF, but I need to back up all of the Admin settings. How can I do that without ColdFusion running? Thanks, Steve ~| Want to reach the

Re: Local DEV setup, multiple projects/websites

On Tue, Mar 2, 2010 at 4:23 AM, Tom Chiverton wrote: > Well, of course, but I don't understand how differing live and development > environments is ever a good thing. As Kevin pointed out, different people have development environments. Some in a very isolated corporate environment may work on o

Re: Local DEV setup, multiple projects/websites

> > Well, of course, but I don't understand how differing live and development environments is ever a good thing. In an Ideal situation this holds true, especially if you are a lone developer or are stuck a single platform. Many people work in team environments so having the flexibility to have

Re: Local DEV setup, multiple projects/websites

On Monday 01 Mar 2010, Cameron Childress wrote: > end up with a buncha hosts file entries everyone on the team has to > manage. For me, it's much less work. YMMV. Well, of course, but I don't understand how differing live and development environments is ever a good thing. -- Helping to colla