CMS Suggestions Needed

We are considering building a site that would allow visitors to upload images and stories and allow comments from other visitors. We would also like ad management and an rss feed of the stories and possibly a map integration so people can see where the stories come from. Any suggestions on an

Re: CMS Suggestions Needed

Ian, I'd like to suggest taking a look at Sava CMS (www.gosava.com), our free open-source ColdFusion CMS. It's got the features you're looking for: 1. User uploaded content (both text and file-based) 2. Integrated advertising manager 3. Extensive RSS support Your concept sounds similar to a

Graphing Missing Data Values

I am trying to create a graph based on a partial set of data, however I don't seem to be able to get ColdFusion's interpolation feature to work. Basically, I have a daily timeline, however not every day has a value to be graphed. My specific question is: how do I tell the cfchart to ignore the

Book about Java and ColdFusion

Hello everybody, Which book is the best to learn Java in coldfusion? Regards, Piotr ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

left outer join on query of query function

hi, i have been following the following link that discusses how to do a left outer join on a query of query: http://www.bealearts.co.uk/blog/2007/06/20/how-to-do-an-outer-join-in-query-of-queries/ this is the code that is meant to do it: cfquery name=”joinQuery” dbtype=”query”

RE: left outer join on query of query function

i have been following the following link that discusses how to do a left outer join on a query of query: http://www.bealearts.co.uk/blog/2007/06/20/how-to-do-an-outer- join-in-query-of-queries/ this is the code that is meant to do it: cfquery name=”joinQuery”

Re: Book about Java and ColdFusion

Piotr, It's a little old but Java for Coldfusion developers is excellent. It was a book ahead of its time. http://www.amazon.com/Java-ColdFusion-Developers-Eben-Hewitt/dp/0130461806/ref=sr_1_1?ie=UTF8s=booksqid=1214778095sr=8-1 Rick Mason On Sun, Jun 29, 2008 at 3:24 PM, Piotr Artman [EMAIL

Re: left outer join on query of query function

thanks Dave, i basically have just copied and pasted the code from the link i pasted above: do you have any idea how to rectify this or even if this would work. the guy indicates that his code is the finished product but now that credibility is lost, so just wondering whether you think it is

RE: left outer join on query of query function

i basically have just copied and pasted the code from the link i pasted above: do you have any idea how to rectify this or even if this would work. I hadn't read the link, just looked at your code. Not having read the code, I didn't realize that joinQuery would contain a single record with

Merge two tables/queries, NOT identical, can't use Union

This is probably the dumbest question I've posted yet, but my mind is numb and I'm not getting anywhere, no matter how much I google terms. I have three tables in a MS Access DB: Owners, Vehicles, Other. Owners is owner info, Vehicles is car info, Other is misc items info. Vehicles and Other

Any way to make this query work like this?

Hi, all... Any way to make this kind of query work? cfquery name=get_properties datasource=c21ar select p.street_number, p.street_name, p.city from properties p where p.city exists in #session.approved_cities#

Re: Any way to make this query work like this?

select p.street_number, p.street_name, p.city from properties p where p.city in (#session.approved_cities#) Although you should use cfqueryparam. On Mon, Jun 30, 2008 at 12:56 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... Any way to make this kind of

Re: Any way to make this query work like this?

WHERE p.city IN cfqueryparam value=#session.approved_cities# list=yes cfsqltype=cf_sql_varchar / On Sun, Jun 29, 2008 at 9:56 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... Any way to make this kind of query work? cfquery name=get_properties datasource=c21ar

Re: Any way to make this query work like this?

In fact cfqueryparam is the best solution, now I see your data is a string: select p.street_number, p.street_name, p.city from properties p where p.city in (cfqueryparam cfsqltype=cf_sql_varchar value=#session.approved_cities# list=true) On Mon, Jun 30, 2008 at 1:07 PM, James Holmes [EMAIL

Re: Any way to make this query work like this?

On Sun, Jun 29, 2008 at 10:07 PM, James Holmes [EMAIL PROTECTED] wrote: select p.street_number, p.street_name, p.city from properties p where p.city in (#session.approved_cities#) Although you should use cfqueryparam. without the cfqueryparam would probably need

RE: Any way to make this query work like this?

Hmmm... can't get that to work. This is MySQL 5... can you verify it works? I get an Error 500 from the browser. Rick -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 1:08 AM To: CF-Talk Subject: Re: Any way to make this query work like

RE: Any way to make this query work like this?

Couldn't get either of those approaches to work, either... ??? Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 1:10 AM To: CF-Talk Subject: Re: Any way to make this query work like this? On Sun, Jun 29, 2008 at 10:07 PM, James

Re: Any way to make this query work like this?

Agreed, hence my followup post. On Mon, Jun 30, 2008 at 1:10 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Sun, Jun 29, 2008 at 10:07 PM, James Holmes [EMAIL PROTECTED] wrote: select p.street_number, p.street_name, p.city from properties p where p.city in