Re: Little help with a query please...

Les, That looks good. Did you try running that directly in your database? While I was looking at your query, I thought I would toss out how I would have written it, which removes an extra conditional and an extra variable: SELECT id_page,headline,content,section FROMpa

Re: Little help with a query please ... FIXED

I know it's late and all but what did you do differently? Here's what you had earlier and looks the same.. lol Like I said.. it's late! WHERE section <> 'news' AND ( headline LIKE or content LIKE OR ) AND ( headline LIKE

RE: Help us Please - CF 5 Server Licenses

Exactly what I was thinking. This guy sounds like a complete idiot. Ask him exactly how he is going to replace the functions that your CF servers carry out now and how he plans to pay for that out of HIS IT budget. This retard must have a boss . it's time to get locked and loaded!

Re: Little help with a query please...

Do you not have access to a SQL editor you could put that outputted SQL into? Should point out where the syntax issue is.. Do this SELECT id_page, headline, content, section FROM pages WHERE section <> 'news' AND (

Re: Little help with a query please ... FIXED

This did the trick: WHERE section <> 'news' AND ( headline LIKE or content LIKE OR ) AND ( headline LIKE or content LIKE ) ~| Order t

Re: Little help with a query please...

On 5/4/2011 9:11 PM, Greg Morphis wrote: > > Take your query and wrap it in a cfoutput tag instead of cfquery. > Remove the cfqueryparams and just have the variables. That's this: WHERE section <> 'news' AND ( headline LIKE '%bob%' or content LIKE '%bob%' OR headline LIKE '%robert%' or content L

Re: Little help with a query please...

Take your query and wrap it in a cfoutput tag instead of cfquery. Remove the cfqueryparams and just have the variables. This should output exactly what is being passed to your DB. Can you post this query or maybe you'd even see what's wrong. Plus if you run that query against your DB it should gen

Re: Little help with a query please...

On 5/4/2011 8:15 PM, Greg Morphis wrote: > > the double quotes? > like '%bob%' or '%ted%' That's just in the outputted version. I've rewritten it again though. Output is now: WHERE section <> 'news' AND ( headline LIKE '%barnett%' OR content LIKE '%barnett%' OR headline LIKE '%shale%' OR conten

RE: CF Builder setup - plugin or standalone?

You can change the icon in the taskbar, I do this so that I can tell which Eclipse install is which. Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] > Sent: Thursday, 5 May 2011 12:15 AM > To: cf-talk >

Re: Little help with a query please...

the double quotes? like '%bob%' or '%ted%' On Wed, May 4, 2011 at 7:04 PM, Les Mizzell wrote: > > Below is for a search interface I'm working on. > > A single word into the query works fine. > > I've a function that cleans the input, removes common words, and builds > a list. The list is getting

Little help with a query please...

Below is for a search interface I'm working on. A single word into the query works fine. I've a function that cleans the input, removes common words, and builds a list. The list is getting built properly. If I input "bob,ted" I get an vague syntax error (shared hosting - robut reporting is o

Re: CF Builder setup - plugin or standalone?

On 5/4/2011 9:54 AM, Rachel Lehman wrote: > > I've been running the CF Builder 2 Beta as a plugin to my Eclipse Helios > install. I also have Aptana, CFEclipse (from before), Mylyn/Foglyn and > MercurialEclipse running as part of my core work environment. I feel like CF > Builder doesn't run ve

Re: CF Builder setup - plugin or standalone?

I've been running CFBuilder standalone with my other common plugins added to that install as my main setup since day one, across 1.0 and 2.0 versions. Works great. The only problem I've had is that some of my more advanced plugins won't install in a bare CFBuilder install because of dependencies o

Re: Robot hitting cached version of application scope?

You might wanna LCASE that variable so this doesn't happen again. On Wed, May 4, 2011 at 11:16 AM, Michael Kaplan wrote: > > This robot is calling our site with a capitalized letter (i.e.: > www.Website.com). A browser would automatically change this to > www.website.com, but the robot isn't

Re: CF9's cfmail remove attribute not working at Crystal Tech

Jochem, that's an interesting idea and I'll give it some thought. The downside is that it will slow down page processing somewhat since sending mail would be synchronous. Thanks. ~| Order the Adobe Coldfusion Anthology now! ht

Re: CF9's cfmail remove attribute not working at Crystal Tech

Uh, well, that's what I suggested in my original post. :-) I wanted to see if anyone else had experience with better ideas. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/d

Re: Robot hitting cached version of application scope?

> Do you have any code which dynamically sets or changes the application > name? Yes! Lightbulb! We have multiple domains running the same codebase, and the application name comes from the domain. Our application scope for each site refreshes nightly via a scheduled task. This robot is calli

Re: Robot hitting cached version of application scope?

> Everything else is current--data being returned from the database is from > today. It's just the application scope that has somehow become cached for > this user only. Do you have any code which dynamically sets or changes the application name? Dave Watts, CTO, Fig Leaf Software http://www.fi

Re: Robot hitting cached version of application scope?

> It might simply be that the robot is using today information it has on > a page it got on April 12. Thanks, but that's not the case. I have put a try/catch block in the code that logs the application variables being used at the time the robot triggers the error. I can see that the applicatio

Re: Robot hitting cached version of application scope?

It might simply be that the robot is using today information it has on a page it got on April 12. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Arc

Re: Help us Please - CF 5 Server Licenses

>>new IT manager, and unless we can find the purchasing documents, he will >>wipe the servers. Talk to his boss and consider wiping the IT manager. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Cold

Robot hitting cached version of application scope?

I have a baffling issue going on with one of my websites. A robot called Spinn3r has been hitting the site regularly over the past couple of weeks. Its User-Agent is Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.19; aggregator:Spinn3r (Spinn3r 3.1); http://spinn3r.com/robot) Gecko/20100401

Re: CF9's cfmail remove attribute not working at Crystal Tech

On Tue, May 3, 2011 at 7:23 PM, Dave Burns wrote: > I just spent an hour working with a tech at Crystal Tech diagnosing an email > problem which ended up with me realizing that the very convenient "remove" > attribute that is new to CF9's cfmail tag will not work in their environment. > The rea

Re: CF9's cfmail remove attribute not working at Crystal Tech

well if you are storing the attachments within your own webspace, then why not just have a schedule that cleans them up each night, then you wont have to worrk about deleting them before they been sent. On Wed, May 4, 2011 at 4:57 PM, Dave Burns wrote: > > Thanks, Russ. Interesting. I've always

Re: CF9's cfmail remove attribute not working at Crystal Tech

Thanks, Russ. Interesting. I've always ruled out using CF's temp directory for security reasons. I'm on shared hosting at CT. If I'm generating PDF invoices and account statements for customers, seems like I don't want them sitting around in the temp directory where other people on the same box

Re: Help us Please - CF 5 Server Licenses

Just to point out.. These archives are googled and cached for .. well.. forever. You may not want to refer to people as a tool if you plan on working in the future. Just sayin. On Wed, May 4, 2011 at 8:02 AM, Pete Ruckelshaus wrote: > > Sounds like your new IT manager is a tool.  I hope he has a

RE: Help us Please - CF 5 Server Licenses

Surely wiping the servers and deleing your apps would not be allowed by the bosses ? surely they need those apps. -Original Message- From: Ken Hammond [mailto:khamm...@saleminc.com] Sent: 04 May 2011 16:08 To: cf-talk Subject: Re: Help us Please - CF 5 Server Licenses HAHA - I was thi

Re: Help us Please - CF 5 Server Licenses

If you cannot get any help from Adobe, you may want to consider using one of the open source CFML engines like Open BlueDragon (http://www.openbluedragon.org/) or Railo (http://www.getRailo.com). Unless there is something very weird about your setup, after recreating your data sources, and inp

Re: Help us Please - CF 5 Server Licenses

HAHA - I was thinking the same thing! -Original Message- From: Pete Ruckelshaus To: cf-talk Date: Wed, 4 May 2011 11:02:05 -0400 Subject: Re: Help us Please - CF 5 Server Licenses Sounds like your new IT manager is a tool. I hope he has a plan to rewrite those legacy apps! On Wed

Re: Help us Please - CF 5 Server Licenses

Sounds like your new IT manager is a tool. I hope he has a plan to rewrite those legacy apps! On Wed, May 4, 2011 at 8:58 AM, Ralph B Littleleaf wrote: > > Our department has several legacy CF servers running CF 5. They have > worked great for us which is good since the student workers who dev

Re: CF Builder setup - plugin or standalone?

Ah, come on! You can change that, just point it to the file! C:\Program Files (x86)\Adobe\Adobe ColdFusion Builder 2\cf.ico Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Au

Re: CF Builder setup - plugin or standalone?

On Wed, May 4, 2011 at 9:54 AM, Rachel Lehman wrote: > > I'm thinking of rebuilding my environment using the CFB standalone, then > installing Mylyn /Foglyn (Mylyn may be included in CFB, not sure) and > MercurialEclipse as plugins. Has anyone done this and how well does it work? > > I went with

Re: CF Builder setup - plugin or standalone?

That makes a lot of sense. I'll give it a try. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/

Re: CF Builder setup - plugin or standalone?

Rachel, If I were to hazard a guess, running CFB2 as a plugin, within your current config, is having some conflicts with Aptana and CFEclipse, as there are bits from both built in to CFB2. I would suggest a separate Eclipse install, with the CFB2 plugin, plus your Mylyn/Foglyn and MercurialEc

CF Builder setup - plugin or standalone?

I've been running the CF Builder 2 Beta as a plugin to my Eclipse Helios install. I also have Aptana, CFEclipse (from before), Mylyn/Foglyn and MercurialEclipse running as part of my core work environment. I feel like CF Builder doesn't run very well in this configuration, whenever I try to run

Re: Help us Please - CF 5 Server Licenses

If you register your license on the Adobe site, and then show your idiot IT manager, maybe he will accept this ? Otherwise perhaps you can get some receipt from Adobe. I do have a spare CF5 license as it goes if you would like to make me an offer, otherwise I think your only option is ebay. On

RE: Help us Please - CF 5 Server Licenses

If you have the serial numbers I would call Adobe. It's possible they are registered there - especially if you bought a subscription as well. I'd say they will probably work with you on this. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com

Re: Help us Please - CF 5 Server Licenses

> Unfortunately, our department has been under budget > constraints for the past three years. We cannot afford > to buy new CF licenses even with an educational > discount nor hire new programmers to modify our > legacy CF code to work with the lattest CF platform. Hi Ralph, I unfortunately do no

Help us Please - CF 5 Server Licenses

Our department has several legacy CF servers running CF 5. They have worked great for us which is good since the student workers who developed the departmental applications on them have left years ago. But now we got a new IT manager, and unless we can find the purchasing documents, he will

Re: Synonym Dictionary

thanks Russ, good link >Richard, > >If MySQL cannot do it natively then you have this functionality also built >right into CF with SOLR. >Check this > >http://bloggeraroundthecorner.blogspot.com/2009/08/searching-for-synonyms.html > >

Re: Bless

On Mon, May 2, 2011 at 11:48 AM, Mike Kear wrote: > Thankfully I'd heeded good advice and > used tried worked.    They were submitting urls with parameters like : > /index.cfm?pid=111825&pgm=../../../../../../../../../../proc/self/environ&guestprogID=2 >  and many many variations. That is not an