Re: XML Error = invalid character Unicode 0x19.

[Matt Quackenbush]

Probably a result of a copy/paste from Word.  Look for ' - ' (a space, a
dash, a space) within that block.  Word creates some stupid-ass "smart
character" when that is typed in.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308583
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Error = invalid character Unicode 0x19.

[Dominic Watson]

Apparently, the org.apache.commons.lang.StringEscapeUtils java class'
escapeXml method escapes this (and other) characters properly. So
something like:




When I first tested this out I found that the
org.apache.commons.lang.StringEscapeUtils class could not be found so
I had to install the org.apache.commons.lang package which can be
found here:

http://commons.apache.org/downloads/download_lang.cgi

Note: I've not been able to test this with a string that produces the
error you are having.

HTH

Dominic

2008/7/4 Mike Kear <[EMAIL PROTECTED]>:
> I'm getting this error in a XML job i'm doing and I can't see where
> this illegal character is creeping in.  The offending text field is
> one called 'description',   - i know that becuase if i remove it from
> the XML I get valid XML.
>
> Unicode 0x19 is called End of Medium and is a control character.
>
> So i have used trim() on the data going into the description element, and also
> XMLFormat().   I would have thought that XMLFormat() would have fixed
> it, but it hasn't.   I can't see where this character is creeping in,
> becuase it's a control character.
>
> I've also tried setting the page encoding to UTF-8 to see if that
> makes any difference but it doesn't.
>
> I've googled for quite a while now, and there are lots of people who
> see this problem - it's on forums everywhere, but no one seems to give
> an answer that works.
>
> Has anyone here come across this problem and solved it?  ( The problem
> seems to be common to PHP and .Net applications too, but none of them
> have posted an answer that i have found. )   If you got round it, what
> did you do?
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308584
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: XML Error = invalid character Unicode 0x19.

[Mike Kear]

You were on the right track, Matt.   It was one of those smart quotes
- a curly apostrophe, as a result of a paste from word.  I deleted
that character and replaced it with a ASCII one and the XML validated.
   Also i used the suggestion Terry gave me - replace chr(25) with
nothing and that did worked on another record that was giving the same
error.

Now to figure out what to do about the 200 fields on several hundred
thousand records, now I know what's causing it to break.  I am hoping
i am going to be able to think of a way to loop through them all
instead of spending the rest of the day typing out a replace function
in each field.  (sigh).   Story of my life with this project!

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On Fri, Jul 4, 2008 at 5:53 PM, Matt Quackenbush <[EMAIL PROTECTED]> wrote:
> Probably a result of a copy/paste from Word.  Look for ' - ' (a space, a
> dash, a space) within that block.  Word creates some stupid-ass "smart
> character" when that is typed in.
>
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308585
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: undefined value error... weird...

[Will Tomlinson]

 
> 4 : 
> 5 : 
> 6 : SELECT dealerID, username, first_name, last_name
> 7 : FROM tblsozo_dealers
> 8 : WHERE username = '#finduser[1]#'
> 9 : 
> 

1. Dump cgi scope to see what's in your server_name variable. 

2. More of a heads up - the list is about to jump you for not using 
 in your WHERE clause. :) 

Whenever in doubt, dump! 

hth,
Will 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308586
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: cfmail cc doesn't work

[Jenny Gavin-Wear]

Hi Rick,

I'm not sure your reasoning for the solution is quite there.  CF doesn't
check email addresses are valid in the To or CC, it would only reject the
email from CF if the validation failed for username/password - and as long
as these were correct, then it would be dealt with by the mail servers bad
mail rules.  If the From email address wasn't valid the message might be
rejected if relaying was being attempted.

Jenny

-Original Message-
From: Richard Steele [mailto:[EMAIL PROTECTED]
Sent: 03 July 2008 23:01
To: CF-Talk
Subject: Re: cfmail cc doesn't work


Wow, ok! [EMAIL PROTECTED] was not setup in my server's mailserver. So it's
interesting that cfmail won't send to ANY of the addresses if one of the
addresses is not set up.

> Why doesn't this work?
>
>  from="[EMAIL PROTECTED]" subject="Cover missing for #title2x#
> #number#">
> #title2x# cat## #number# is in stock.
>
> when this does work.
>
>  subject="Cover missing for #title2x# #number#">
> #title2x# cat## #number# is in stock.
>
> Thanks in advance.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308587
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: XML Error = invalid character Unicode 0x19.

[Dominic Watson]

> Now to figure out what to do about the 200 fields on several hundred
> thousand records, now I know what's causing it to break.  I am hoping
> i am going to be able to think of a way to loop through them all
> instead of spending the rest of the day typing out a replace function
> in each field.  (sigh).   Story of my life with this project!

If the org.apache.commons.lang.StringEscapeUtils java class works, it
could save you a whole heap of work! ;)

Dominic
-- 
Blog it up: http://fusion.dominicwatson.co.uk

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308588
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Create query?

[Jenny Gavin-Wear]

I recall seeing somewhere that it is possible to build a query on the fly?

The scenario is, I will have some data values which could be contained in
form generated structs.  I will need to search the struct for the column
name existing, and when it does, use those values for the generated query.

Hope this makes sense,

Jenny




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308589
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Create query?

[Dominic Watson]

Yep,

Lookup the query functions in the docs (ie. QueryNew(), QueryAddRow(),
QuerySetCell(), QueryAddColumn().

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0367.htm

HTH

Dominic

2008/7/4 Jenny Gavin-Wear <[EMAIL PROTECTED]>:
> I recall seeing somewhere that it is possible to build a query on the fly?
>
> The scenario is, I will have some data values which could be contained in
> form generated structs.  I will need to search the struct for the column
> name existing, and when it does, use those values for the generated query.
>
> Hope this makes sense,
>
> Jenny
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308590
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Using CF variable in cfdocument filename

[Dirk Dinnewet]

Dominic, thanks for the quick and concise answer. One learns
every day. 

>Yep ;)
>
>
>
>
>
>fontembed="yes" filename="#VARIABLES.dateiname#" overwrite="yes">
> 
>
>
>Have a search for tutorials on using variables in ColdFusion; there
>are several ways to do this and they are all fundamental to
>programming in CF (the problem is very easy when you have a solid
>understanding of how CF uses variables).
>
>HTH (and that dateiname = filename, my German sucksen)
>
>Dominic
>
>-- 
>Blog it up: http://fusion.dominicwatson.co.uk 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308591
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 vs .Net or PHP - need arguement help

[David Fekke]

Tom,

Good .NET developers are more expensive than a good CF developer, or at least 
that has been my experience. 

That is not the argument I would make though, I would use developer 
productivity. You can query a database and output the result with two tags or 
two lines of code. Compare that ease of use with any other language including 
the latest media darlings like Ruby and Python.

Hope this helps,
David 

> On Wednesday 02 Jul 2008, [EMAIL PROTECTED] 
> [EMAIL PROTECTED] wrote:
> > angencies talk about that there's more, less expensive developers 
> out there
> > with these other technologies.  
> 
> Uh huh, but they'll take longer to get stuff done than the more 
> expensive CF 
> developers.
> 
> -- 
> Tom Chiverton
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in 
> England and Wales under registered number OC307980 whose registered 
> office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, 
> Manchester, M3 3EB.  A list of members is available for inspection at 
> the registered office. Any reference to a partner in relation to 
> Halliwells LLP means a member of Halliwells LLP.  Regulated by The 
> Solicitors Regulation Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above 
> and may be confidential or legally privileged.  If you are not the 
> addressee you must not read it and must not use any information 
> contained in nor copy it nor inform any person other than Halliwells 
> LLP or the addressee of its existence or contents.  If you have 
> received this email in error please delete it and notify Halliwells 
> LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.com.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308592
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

[OT] SEO Tip

[Adrian Lynch]

Any pointers as to which is better?

1. www.domain.com/99/keyword1/keyword2/

2. www.domain.com/keyword1/keyword2/99/

99 relates to a page/article/entry/whatever, so I was wondering if placement
of this ID is important for better SEO.

I've read and been told that things to the left are rated higher so 2 would
be better for that. But surely the page and the last element should be
related? So is the page these URLs point to more about keyword2 or 99?

Cheers.

Adrian Lynch


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFC Tutorial now on line

[Will Swain]

Hi Mike,

I enjoyed your first tutorial and am looking forward to seeing the next one.

As a long time cf user who hasn't made the move to fully oo, I'm right in
the middle of a concerted effort to crack the OO thing this time, so these
tutorials have come a a good time for me. Thanks for your work on them. It's
much appreciated.

Cheers

Will

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: 03 July 2008 21:16
To: CF-Talk
Subject: Re: CFC Tutorial now on line

I'm delighted at the number of people who've had a look at the tutorial i
made on using object oriented approach to coldfusion
programmingI am mid way through the second part, which will
explain some of the odd things the first tutorial expects you to just
accept without question.And you'll learn some more of the concepts
of Object oriented programming, with a very low "jargon quotient".
Hopefully I'll have it posted on my company's web site by the end of the
weekend, all being well.

For those who haven't been following along,  I wrote a tutorial about how to
use object-oriented  techniques in coldfusion, intended for those who are
having trouble wading through the maze of jargon and
terminology that surrounds all that stuff.I had problems getting
started with it and wished there was a plain-language tutorial or two so i
could learn the basics first, and then understand the jargon later.

In the first part, we take a simple real estate application and employ
object-oriented principles to make update/edit/add/delete functionality -
reusing code, reusing forms, simplifying a lot of things and demonstrating
how OO can help in the daily programming life.

The second part adds to this, and takes the OO concepts further,
giving the basis of a live application.   At the end of part 2, you'll
be able to understand all the basic concepts of OO ColdFusion, even if you
arent across all the terminology yet,  and you'll be able to make your own
apps that run reliably, and allow the reuse of code, separation of business
logic and display elements and plenty of other good stuff.

To see part one, go to http://afpwebworks.com  and there's a link in the
sidebar.  Let me know if it's of any use to you.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer AFP Webworks
http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from
AUD$15/month



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308594
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: XML Error = invalid character Unicode 0x19.

[rex]

Dominic Watson wrote:
> Apparently, the org.apache.commons.lang.StringEscapeUtils java class'
> escapeXml method escapes this (and other) characters properly. So
> something like:
>
>  'org.apache.commons.lang.StringEscapeUtils')>
> 
>
> When I first tested this out I found that the
> org.apache.commons.lang.StringEscapeUtils class could not be found so
> I had to install the org.apache.commons.lang package which can be
> found here:
>
> http://commons.apache.org/downloads/download_lang.cgi
>
> Note: I've not been able to test this with a string that produces the
> error you are having.
>
> HTH
>
> Dominic
>
>   
I remember using safetext 
(http://cflib.org/index.cfm?event=page.udfbyid&udfid=56) to remove the 
special chars like:

‘the quicj’

Dr – jhg


and other stuff. Please test and I hope it works

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308595
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[Rick Root]

James, that looks like a very distinct possibility.

I'll give that a try and report back in a day or so...

If it works.. I owe ya!

Rick

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308596
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Coldfusion restarting itself

[Maureen Barger]

Also try to find the files hs_err_pid*.log on your disk. Not sure where they
get stored on windows boxes (your java dir I would expect; on unix it's in
the holding id's user directory). There is usually a good dump there that
tells you what was going on.

On Fri, Jul 4, 2008 at 7:40 AM, Rick Root <[EMAIL PROTECTED]> wrote:

> James, that looks like a very distinct possibility.
>
> I'll give that a try and report back in a day or so...
>
> If it works.. I owe ya!
>
> Rick
>
> --
> Rick Root
> New Brian Vander Ark Album, songs in the music player and cool behind
> the scenes video at www.myspace.com/brianvanderark
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308597
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: undefined value error... weird...

[Jessica Kennedy]

Duly noted on queryparams!  Problem still is that I can't replicate the 
problem... if I cfdump the vars when I go back to refresh the page the error 
goes away, and I can't figure out how to get it back.

I've considered the issue being in the application variable not declaring 
first.  this code is in a stored template called to the page... could that be 
it, and if so,,, how can I fix it??


> 1. Dump cgi scope to see what's in your server_name variable. 
> 
> 2. More of a heads up - the list is about to jump you for not using 
>  in your WHERE clause. :) 
> 
> Whenever in doubt, dump! 
> 
> hth,
> Will 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308598
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: [OT] SEO Tip

[Casey Dougall]

On Fri, Jul 4, 2008 at 5:56 AM, Adrian Lynch <[EMAIL PROTECTED]>
wrote:

> Any pointers as to which is better?
>
> 1. www.domain.com/99/keyword1/keyword2/
>
> 2. www.domain.com/keyword1/keyword2/99/
>
> 99 relates to a page/article/entry/whatever, so I was wondering if
> placement
> of this ID is important for better SEO.
>
>
If the content on keyword page is relevant then the url won't matter.

www.domain.com/99/keyword1/keyword2

This would be better to manage from a editor point of view.  where you don't
need to know the keyword name because you should be able to type
www.domain.com/99/ 

And that will redirect you to

www.domain.com/99/keyword1/keyword2/

It's extremely important that urls either 301 redirect or go to completely
different pages. meaning you should not have

www.domain.com/99/keyword1/keyword2/ and
www.domain.com/99/keyword132/keyword56

pointing to the same page.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308599
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: undefined value error... weird...

[Will Tomlinson]

> Duly noted on queryparams!  Problem still is that I can't replicate 
> the problem... if I cfdump the vars when I go back to refresh the page 
> the error goes away, and I can't figure out how to get it back.

Are you just trying to grab the server name? Looks like you're jumping thru an 
extra hoop converting it to an array like that.

Just use this:  listFirst(cgi.server_name, ".")

Doubt that solves your problem. Just something I noticed. 

Will



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308600
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: undefined value error... weird...

[Will Tomlinson]

Maybe somethin like this would work?


 
 
 




WHERE username =  




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308601
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

2 Related CFDIV's

[Michael Grove]

I have been at this for a while,
I am trying to create 2 cfdivs. One shows a cart total and total items and the 
other has a link labled add to cart.

Pressing the add to cart needs to activate the first div so that it ads the 
products and increments the numbers. Then the second div with the link needs to 
change or blank out.

I can get the first to change no problem, but can not get the message in the 
link div to change.

Here is my code... any help would be greatly appreciated.

THIS IS THE DIV WITH THE LINK AND MESSAGE



ADD
 TO CART



THIS IS THE ONE THAT ADDS THE PRODUCT AND INCREMENTS THE CART NUMBERS




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308602
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Why would this query return this error?

[Rick Faircloth]

Hi, all...

Why would this query return this error:

'Unknown column 'properties.mls_number' in 'on clause'

Here's the query:



 select p.property_id, p.mls_number, p.street_number, p.street_name,
p.city, p.state, p.remarks, p.property_type, p.list_price,
o.mls, o.office_name, o.display_order,
min( pp.photo_filename) as prop_photo_filename
   from properties p, offices o, property_photos pp

  left join property_photos
 on substring_index(properties.mls_number, '_', 1) = 
property_photos.photo_mls_number
and p.mls = pp.mls

  left join offices
 on p.listing_office_mls_id = o.mls_office_id
and p.mls = o.mls
   
  where p.property_type <> 'rental'   
  
   group by properties.mls_number
   order by offices.display_order
  limit 10
  


Suggestions?

Thanks!

Rick




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308603
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Why would this query return this error?

[Greg Morphis]

you have the properties table aliased as 'p'..

On Fri, Jul 4, 2008 at 11:10 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> Hi, all...
>
> Why would this query return this error:
>
> 'Unknown column 'properties.mls_number' in 'on clause'
>
> Here's the query:
>
>  cachedWithin="#CreateTimeSpan(0,0,0,0)#">
>
> select p.property_id, p.mls_number, p.street_number, p.street_name,
>p.city, p.state, p.remarks, p.property_type, p.list_price,
>o.mls, o.office_name, o.display_order,
>min( pp.photo_filename) as prop_photo_filename
>   from properties p, offices o, property_photos pp
>
>  left join property_photos
> on substring_index(properties.mls_number, '_', 1) = 
> property_photos.photo_mls_number
>and p.mls = pp.mls
>
>  left join offices
> on p.listing_office_mls_id = o.mls_office_id
>and p.mls = o.mls
>
>  where p.property_type <> 'rental'
>
>   group by properties.mls_number
>   order by offices.display_order
>  limit 10
>
> 
>
> Suggestions?
>
> Thanks!
>
> Rick
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308604
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF8 / CFGRID / HREFKEY /CFLAYOUT newbie question

[Lawrence Mak]

Hi all,

I'm building a datagrid that is similar to what Charles described 
(http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:52906#285912), 
except that my datagrid resides in a tabbed layout. 

I have built a normal  version in the following way:
1. set the href of the cell to 
javaScript:ColdFusion.navigate('targetpage.cfm?id=#id#','tabname')
2. set the cell's onlcick attribute to 
"ColdFusion.layout.selectTab('layoutname','tabname')" to switch display to the 
tab.

Although this works fine, I'm not sure if this is the correct way to do it.

My question is: how can I achieve the same result using cfgrid? in 
cfgridcolumn, can I use the same .navigate function, but reference the id 
column in the hrefkey attribute? can I just use 'targetpage.cfm?id=' as URL and 
expect the value of hrefkey to be attached at the end?

Thanks in advance for any suggestions.

Lawrence 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308605
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would this query return this error?

[Rick Faircloth]

Thanks for the reply, Greg...

I had tried it with the alias, but I still get the same
error.

Rick


> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 12:15 PM
> To: CF-Talk
> Subject: Re: Why would this query return this error?
> 
> you have the properties table aliased as 'p'..
> 
> On Fri, Jul 4, 2008 at 11:10 AM, Rick Faircloth
> <[EMAIL PROTECTED]> wrote:
> > Hi, all...
> >
> > Why would this query return this error:
> >
> > 'Unknown column 'properties.mls_number' in 'on clause'
> >
> > Here's the query:
> >
> >  > cachedWithin="#CreateTimeSpan(0,0,0,0)#">
> >
> > select p.property_id, p.mls_number, p.street_number, p.street_name,
> >p.city, p.state, p.remarks, p.property_type, p.list_price,
> >o.mls, o.office_name, o.display_order,
> >min( pp.photo_filename) as prop_photo_filename
> >   from properties p, offices o, property_photos pp
> >
> >  left join property_photos
> > on substring_index(properties.mls_number, '_', 1) = 
> > property_photos.photo_mls_number
> >and p.mls = pp.mls
> >
> >  left join offices
> > on p.listing_office_mls_id = o.mls_office_id
> >and p.mls = o.mls
> >
> >  where p.property_type <> 'rental'
> >
> >   group by properties.mls_number
> >   order by offices.display_order
> >  limit 10
> >
> > 
> >
> > Suggestions?
> >
> > Thanks!
> >
> > Rick
> >
> >
> >
> >
> >
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308606
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would this query return this error?

[Rick Faircloth]

Well, I'm not getting an error after removing
", office o, properties pp" out of the first "from" line

and creating the property_photos alias in the first "left join" line,
as in "left join property_photos pp"

and creating the offices alias in the second "left join" line,
as in "left join offices o"

so the query ends up like this, with all aliases in use:



 select p.property_id, p.mls_number, p.street_number, p.street_name,
p.city, p.state, p.remarks, p.property_type, p.list_price,
o.mls, o.office_name, o.display_order,
min( pp.photo_filename) as prop_photo_filename
   from properties p

  left join property_photos pp
 on substring_index(p.mls_number, '_', 1) = pp.photo_mls_number
and p.mls = pp.mls

  left join offices o
 on p.listing_office_mls_id = o.mls_office_id
and p.mls = o.mls

  where p.property_type <> 'rental'

   group by p.mls_number
   order by o.display_order
  limit 10



However, the thing that's really my problem now (and was before I ran into this 
issue),
is that I'm not getting any of the "office" data returned in the query.
A dump of these 10 records say "empty" for o.mls, o.office_name, and 
o.display_order.

And I've checked the database to make sure the data is there and property 
referenced.
I was getting this for quite awhile while working on this app, but now it's not 
pulling
in the office data via the query.

See anything wrong in the query?

Rick



> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 12:15 PM
> To: CF-Talk
> Subject: Re: Why would this query return this error?
> 
> you have the properties table aliased as 'p'..
> 
> On Fri, Jul 4, 2008 at 11:10 AM, Rick Faircloth
> <[EMAIL PROTECTED]> wrote:
> > Hi, all...
> >
> > Why would this query return this error:
> >
> > 'Unknown column 'properties.mls_number' in 'on clause'
> >
> > Here's the query:
> >
> >  > cachedWithin="#CreateTimeSpan(0,0,0,0)#">
> >
> > select p.property_id, p.mls_number, p.street_number, p.street_name,
> >p.city, p.state, p.remarks, p.property_type, p.list_price,
> >o.mls, o.office_name, o.display_order,
> >min( pp.photo_filename) as prop_photo_filename
> >   from properties p, offices o, property_photos pp
> >
> >  left join property_photos
> > on substring_index(properties.mls_number, '_', 1) = 
> > property_photos.photo_mls_number
> >and p.mls = pp.mls
> >
> >  left join offices
> > on p.listing_office_mls_id = o.mls_office_id
> >and p.mls = o.mls
> >
> >  where p.property_type <> 'rental'
> >
> >   group by properties.mls_number
> >   order by offices.display_order
> >  limit 10
> >
> > 
> >
> > Suggestions?
> >
> > Thanks!
> >
> > Rick
> >
> >
> >
> >
> >
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308607
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Why would this query return this error?

[Rick Faircloth]

If I query for just all the office data and dump it,
I do get all of the office table info, but I can't get
it with the query below...

???


> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 12:53 PM
> To: CF-Talk
> Subject: RE: Why would this query return this error?
> 
> Well, I'm not getting an error after removing
> ", office o, properties pp" out of the first "from" line
> 
> and creating the property_photos alias in the first "left join" line,
> as in "left join property_photos pp"
> 
> and creating the offices alias in the second "left join" line,
> as in "left join offices o"
> 
> so the query ends up like this, with all aliases in use:
> 
>  cachedWithin="#CreateTimeSpan(0,0,0,0)#">
> 
>  select p.property_id, p.mls_number, p.street_number, p.street_name,
> p.city, p.state, p.remarks, p.property_type, p.list_price,
> o.mls, o.office_name, o.display_order,
> min( pp.photo_filename) as prop_photo_filename
>from properties p
> 
>   left join property_photos pp
>  on substring_index(p.mls_number, '_', 1) = pp.photo_mls_number
> and p.mls = pp.mls
> 
>   left join offices o
>  on p.listing_office_mls_id = o.mls_office_id
> and p.mls = o.mls
> 
>   where p.property_type <> 'rental'
> 
>group by p.mls_number
>order by o.display_order
>   limit 10
> 
> 
> 
> However, the thing that's really my problem now (and was before I ran into 
> this issue),
> is that I'm not getting any of the "office" data returned in the query.
> A dump of these 10 records say "empty" for o.mls, o.office_name, and 
> o.display_order.
> 
> And I've checked the database to make sure the data is there and property 
> referenced.
> I was getting this for quite awhile while working on this app, but now it's 
> not pulling
> in the office data via the query.
> 
> See anything wrong in the query?
> 
> Rick
> 
> 
> 
> > -Original Message-
> > From: Greg Morphis [mailto:[EMAIL PROTECTED]
> > Sent: Friday, July 04, 2008 12:15 PM
> > To: CF-Talk
> > Subject: Re: Why would this query return this error?
> >
> > you have the properties table aliased as 'p'..
> >
> > On Fri, Jul 4, 2008 at 11:10 AM, Rick Faircloth
> > <[EMAIL PROTECTED]> wrote:
> > > Hi, all...
> > >
> > > Why would this query return this error:
> > >
> > > 'Unknown column 'properties.mls_number' in 'on clause'
> > >
> > > Here's the query:
> > >
> > >  > > cachedWithin="#CreateTimeSpan(0,0,0,0)#">
> > >
> > > select p.property_id, p.mls_number, p.street_number, 
> > > p.street_name,
> > >p.city, p.state, p.remarks, p.property_type, p.list_price,
> > >o.mls, o.office_name, o.display_order,
> > >min( pp.photo_filename) as prop_photo_filename
> > >   from properties p, offices o, property_photos pp
> > >
> > >  left join property_photos
> > > on substring_index(properties.mls_number, '_', 1) =
property_photos.photo_mls_number
> > >and p.mls = pp.mls
> > >
> > >  left join offices
> > > on p.listing_office_mls_id = o.mls_office_id
> > >and p.mls = o.mls
> > >
> > >  where p.property_type <> 'rental'
> > >
> > >   group by properties.mls_number
> > >   order by offices.display_order
> > >  limit 10
> > >
> > > 
> > >
> > > Suggestions?
> > >
> > > Thanks!
> > >
> > > Rick
> > >
> > >
> > >
> > >
> > >
> >
> >
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308608
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Why would this query return this error?

[Greg Morphis]

Can you provide a few rows of data from each table? I'll be gladly to help

On Fri, Jul 4, 2008 at 12:08 PM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> If I query for just all the office data and dump it,
> I do get all of the office table info, but I can't get
> it with the query below...
>
> ???
>
>
>> -Original Message-
>> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
>> Sent: Friday, July 04, 2008 12:53 PM
>> To: CF-Talk
>> Subject: RE: Why would this query return this error?
>>
>> Well, I'm not getting an error after removing
>> ", office o, properties pp" out of the first "from" line
>>
>> and creating the property_photos alias in the first "left join" line,
>> as in "left join property_photos pp"
>>
>> and creating the offices alias in the second "left join" line,
>> as in "left join offices o"
>>
>> so the query ends up like this, with all aliases in use:
>>
>> > cachedWithin="#CreateTimeSpan(0,0,0,0)#">
>>
>>  select p.property_id, p.mls_number, p.street_number, p.street_name,
>> p.city, p.state, p.remarks, p.property_type, p.list_price,
>> o.mls, o.office_name, o.display_order,
>> min( pp.photo_filename) as prop_photo_filename
>>from properties p
>>
>>   left join property_photos pp
>>  on substring_index(p.mls_number, '_', 1) = pp.photo_mls_number
>> and p.mls = pp.mls
>>
>>   left join offices o
>>  on p.listing_office_mls_id = o.mls_office_id
>> and p.mls = o.mls
>>
>>   where p.property_type <> 'rental'
>>
>>group by p.mls_number
>>order by o.display_order
>>   limit 10
>>
>> 
>>
>> However, the thing that's really my problem now (and was before I ran into 
>> this issue),
>> is that I'm not getting any of the "office" data returned in the query.
>> A dump of these 10 records say "empty" for o.mls, o.office_name, and 
>> o.display_order.
>>
>> And I've checked the database to make sure the data is there and property 
>> referenced.
>> I was getting this for quite awhile while working on this app, but now it's 
>> not pulling
>> in the office data via the query.
>>
>> See anything wrong in the query?
>>
>> Rick
>>
>>
>>
>> > -Original Message-
>> > From: Greg Morphis [mailto:[EMAIL PROTECTED]
>> > Sent: Friday, July 04, 2008 12:15 PM
>> > To: CF-Talk
>> > Subject: Re: Why would this query return this error?
>> >
>> > you have the properties table aliased as 'p'..
>> >
>> > On Fri, Jul 4, 2008 at 11:10 AM, Rick Faircloth
>> > <[EMAIL PROTECTED]> wrote:
>> > > Hi, all...
>> > >
>> > > Why would this query return this error:
>> > >
>> > > 'Unknown column 'properties.mls_number' in 'on clause'
>> > >
>> > > Here's the query:
>> > >
>> > > > > > cachedWithin="#CreateTimeSpan(0,0,0,0)#">
>> > >
>> > > select p.property_id, p.mls_number, p.street_number, 
>> > > p.street_name,
>> > >p.city, p.state, p.remarks, p.property_type, p.list_price,
>> > >o.mls, o.office_name, o.display_order,
>> > >min( pp.photo_filename) as prop_photo_filename
>> > >   from properties p, offices o, property_photos pp
>> > >
>> > >  left join property_photos
>> > > on substring_index(properties.mls_number, '_', 1) =
> property_photos.photo_mls_number
>> > >and p.mls = pp.mls
>> > >
>> > >  left join offices
>> > > on p.listing_office_mls_id = o.mls_office_id
>> > >and p.mls = o.mls
>> > >
>> > >  where p.property_type <> 'rental'
>> > >
>> > >   group by properties.mls_number
>> > >   order by offices.display_order
>> > >  limit 10
>> > >
>> > > 
>> > >
>> > > Suggestions?
>> > >
>> > > Thanks!
>> > >
>> > > Rick
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308609
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

jsmx and progress bar

[Richard White]

hi, does anyone know if there is a progress bar that can be used with jsmx

thanks 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308610
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[Rick Root]

On Fri, Jul 4, 2008 at 9:04 AM, Maureen Barger <[EMAIL PROTECTED]> wrote:
> Also try to find the files hs_err_pid*.log on your disk. Not sure where they
> get stored on windows boxes (your java dir I would expect; on unix it's in
> the holding id's user directory). There is usually a good dump there that
> tells you what was going on.

Actually.. I did find that file and mentioned it in my original email:

The contents are here: http://cfm.pastebin.com/f208c730d

Now... Having made the change to attempt to disable hotspot.. I'm
still getting the exact same error.

"java.lang.OutOfMemoryError: requested 30233088 bytes for jbyte in
C:\BUILD_AREA\jdk6_04\hotspot\src\share\vm\prims\jni.cpp. Out of swap
space?"

It's happened 15 or so times since I made the change this morning and
restarted the server.  frak!

So... more googling turned up this:

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18548

i'm gonna try increasing my maxPermSize again.  The site has
approximately 330,000 .cfm files ... for now (until they implement a
virtual directory system instead of using real directories)

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308611
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Coldfusion restarting itself

[Rick Root]

On Fri, Jul 4, 2008 at 2:44 PM, Rick Root <[EMAIL PROTECTED]> wrote:
>
> So... more googling turned up this:
>
> http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18548
>
> i'm gonna try increasing my maxPermSize again.  The site has
> approximately 330,000 .cfm files ... for now (until they implement a
> virtual directory system instead of using real directories)

I can't set that value to 512mb.  I had it set to 392MB.  But at 512
coldfusion won't start.

I also can't increase my JVM heap past 1280.  CF won't start in either
condition.

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308612
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would this query return this error?

[Rick Faircloth]

Well, just FYI...

Here's my final solution.  (It turns out that I need another
clause in my where statement... "and p.mls = o.mls"
to make it work:



 select p.property_id, p.mls_number, p.street_number, p.street_name,
p.city, p.state, p.remarks, p.property_type, p.list_price, 
p.listing_office_mls_id, 
o.mls, o.office_name, o.display_order,
min( pp.photo_filename) as prop_photo_filename
   from properties p
  
  left join offices o
 on p.listing_office_mls_id = o.mls_office_id 
  
  left join property_photos pp
 on substring_index(p.mls_number, '_', 1) = pp.photo_mls_number
and p.mls = pp.mls

  where p.property_type <> 'rental'
and p.mls = o.mls

   group by p.mls_number
   order by o.display_order  
   



> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 1:08 PM
> To: CF-Talk
> Subject: RE: Why would this query return this error?
> 
> If I query for just all the office data and dump it,
> I do get all of the office table info, but I can't get
> it with the query below...
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308613
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Why would this query return this error?

[Will Tomlinson]

>  cachedWithin="#CreateTimeSpan(0,0,0,0)#">
>   
 
Rick, is this some CF2 technique I missed out on? Whatsup with caching it for 0?

:)

Will 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308614
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Why would this query return this error?

[Greg Morphis]

maybe he intends on caching it?
or perhaps it was cached and he's reruning the query to clear the cached query?

On Fri, Jul 4, 2008 at 5:28 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote:
>> > cachedWithin="#CreateTimeSpan(0,0,0,0)#">
>>
>
> Rick, is this some CF2 technique I missed out on? Whatsup with caching it for 
> 0?
>
> :)
>
> Will
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308615
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[James Holmes]

Have you cleared out the contents of the cfclasses folder? Try
stopping CF, deleting everything in that folder
(C:\CFusionMX\wwwroot\WEB-INF\cfclasses or the equivalent) and then
starting CF. This might make the original error go away.

On Sat, Jul 5, 2008 at 2:50 AM, Rick Root <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 4, 2008 at 2:44 PM, Rick Root <[EMAIL PROTECTED]> wrote:
>>
>> So... more googling turned up this:
>>
>> http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_18548
>>
>> i'm gonna try increasing my maxPermSize again.  The site has
>> approximately 330,000 .cfm files ... for now (until they implement a
>> virtual directory system instead of using real directories)
>
> I can't set that value to 512mb.  I had it set to 392MB.  But at 512
> coldfusion won't start.
>
> I also can't increase my JVM heap past 1280.  CF won't start in either
> condition.
>
> --
> Rick Root
> New Brian Vander Ark Album, songs in the music player and cool behind
> the scenes video at www.myspace.com/brianvanderark
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308616
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would this query return this error?

[Rick Faircloth]

Come on, Will!

You haven't heard of this technique?  I figured you would have been under
the NDA, too, but I guess not.  Anyway,



It's a soon-to-be-released update to CF 8 regarding artificial 
intelligence.
If you set up the cachedWithin but leave it blank, CF analyses you code
and determines if a cache is appropriate for your app.



The strange thing is, they just can't seem to get it to work on the samples of 
code
you've shared on this list.  It breaks the function every time.

And that is tremendously surprising, however, for those of us who know you best,
because after all, we know that you are the epitome of "artificial" 
intelligence.

:o)

Rick

PS - You're right, Greg...


> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 7:06 PM
> To: CF-Talk
> Subject: Re: Why would this query return this error?
> 
> maybe he intends on caching it?
> or perhaps it was cached and he's reruning the query to clear the cached 
> query?
> 
> On Fri, Jul 4, 2008 at 5:28 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> >>  >> cachedWithin="#CreateTimeSpan(0,0,0,0)#">
> >>
> >
> > Rick, is this some CF2 technique I missed out on? Whatsup with caching it 
> > for 0?
> >
> > :)
> >
> > Will
> >
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308617
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[Rick Root]

On Fri, Jul 4, 2008 at 8:41 PM, James Holmes <[EMAIL PROTECTED]> wrote:
> Have you cleared out the contents of the cfclasses folder? Try
> stopping CF, deleting everything in that folder
> (C:\CFusionMX\wwwroot\WEB-INF\cfclasses or the equivalent) and then
> starting CF. This might make the original error go away.

Trying that now, I'll let you know.

CF has restarted itself 28 times in the last 6 hours.  wtf!

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308618
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why would this query return this error?

[Bobby Hartsfield]

> we know that you are the epitome of "artificial" intelligence.

I see there is no need for introductions... you've apparently met Will :-)

..:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 04, 2008 10:42 PM
To: CF-Talk
Subject: RE: Why would this query return this error?

Come on, Will!

You haven't heard of this technique?  I figured you would have been under
the NDA, too, but I guess not.  Anyway,



It's a soon-to-be-released update to CF 8 regarding artificial
intelligence.
If you set up the cachedWithin but leave it blank, CF analyses you
code
and determines if a cache is appropriate for your app.



The strange thing is, they just can't seem to get it to work on the samples
of code
you've shared on this list.  It breaks the function every time.

And that is tremendously surprising, however, for those of us who know you
best,
because after all, we know that you are the epitome of "artificial"
intelligence.

:o)

Rick

PS - You're right, Greg...


> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 7:06 PM
> To: CF-Talk
> Subject: Re: Why would this query return this error?
> 
> maybe he intends on caching it?
> or perhaps it was cached and he's reruning the query to clear the cached
query?
> 
> On Fri, Jul 4, 2008 at 5:28 PM, Will Tomlinson <[EMAIL PROTECTED]>
wrote:
> >>  >> cachedWithin="#CreateTimeSpan(0,0,0,0)#">
> >>
> >
> > Rick, is this some CF2 technique I missed out on? Whatsup with caching
it for 0?
> >
> > :)
> >
> > Will
> >
> 
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308619
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[Rick Root]

On Fri, Jul 4, 2008 at 10:59 PM, Rick Root <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 4, 2008 at 8:41 PM, James Holmes <[EMAIL PROTECTED]> wrote:
>> Have you cleared out the contents of the cfclasses folder? Try
>> stopping CF, deleting everything in that folder
>> (C:\CFusionMX\wwwroot\WEB-INF\cfclasses or the equivalent) and then
>> starting CF. This might make the original error go away.
>
> Trying that now, I'll let you know.
>
> CF has restarted itself 28 times in the last 6 hours.  wtf!

Okay that bought me 45 minutes of stability, after I deleted almost
50,000 class files.

After 45 minutes, there were about 4000 class files... now there are
about 5500 class files in that directory

Rick

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308620
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Why would this query return this error?

[Rick Faircloth]

Will's reputation precedes him wherever he goes!

;o)

> -Original Message-
> From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 04, 2008 11:30 PM
> To: CF-Talk
> Subject: RE: Why would this query return this error?
> 
> > we know that you are the epitome of "artificial" intelligence.
> 
> I see there is no need for introductions... you've apparently met Will :-)
> 
> ..:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
> http://cf4em.com
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308621
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: undefined value error... weird...

[Jessica Kennedy]

That might work assuming the error is in fact in the empty array... i needed a 
full array for a while, but it isn't necessary anymore, so that'll be something 
I will change.

I think the error might be in the application, after all... I got the same 
error randomly in a secure section of the site where there was nothing else to 
be blank.  at least now i have a pretty good idea of the cause, just not the 
solution... yet...


> Are you just trying to grab the server name? Looks like you're jumping 
> thru an extra hoop converting it to an array like that.
> 
> Just use this:  listFirst(cgi.server_name, ".")
> 
> Doubt that solves your problem. Just something I noticed. 
> 
> Will
> 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308622
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[Rick Root]

On Sat, Jul 5, 2008 at 12:05 AM, Rick Root <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 4, 2008 at 10:59 PM, Rick Root <[EMAIL PROTECTED]> wrote:
>> On Fri, Jul 4, 2008 at 8:41 PM, James Holmes <[EMAIL PROTECTED]> wrote:
>>> Have you cleared out the contents of the cfclasses folder? Try
>>> stopping CF, deleting everything in that folder
>>> (C:\CFusionMX\wwwroot\WEB-INF\cfclasses or the equivalent) and then
>>> starting CF. This might make the original error go away.
>>
>> Trying that now, I'll let you know.
>>
> Okay that bought me 45 minutes of stability, after I deleted almost
> 50,000 class files.
>
> After 45 minutes, there were about 4000 class files... now there are
> about 5500 class files in that directory

CF actually restarted 3 times in about 10-15 minutes there but it has
been running for 85 minutes now... of course, the site load is
decreasing since it's pretty late now... only averaging 2-3 requests
per second now.

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308623
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Coldfusion restarting itself

[James Holmes]

The only other suggestion I have is to try the 1.5 JDK.

On Sat, Jul 5, 2008 at 1:26 PM, Rick Root <[EMAIL PROTECTED]> wrote:
> On Sat, Jul 5, 2008 at 12:05 AM, Rick Root <[EMAIL PROTECTED]> wrote:
>> On Fri, Jul 4, 2008 at 10:59 PM, Rick Root <[EMAIL PROTECTED]> wrote:
>>> On Fri, Jul 4, 2008 at 8:41 PM, James Holmes <[EMAIL PROTECTED]> wrote:
 Have you cleared out the contents of the cfclasses folder? Try
 stopping CF, deleting everything in that folder
 (C:\CFusionMX\wwwroot\WEB-INF\cfclasses or the equivalent) and then
 starting CF. This might make the original error go away.
>>>
>>> Trying that now, I'll let you know.
>>>
>> Okay that bought me 45 minutes of stability, after I deleted almost
>> 50,000 class files.
>>
>> After 45 minutes, there were about 4000 class files... now there are
>> about 5500 class files in that directory
>
> CF actually restarted 3 times in about 10-15 minutes there but it has
> been running for 85 minutes now... of course, the site load is
> decreasing since it's pretty late now... only averaging 2-3 requests
> per second now.
>
> --
> Rick Root
> New Brian Vander Ark Album, songs in the music player and cool behind
> the scenes video at www.myspace.com/brianvanderark
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308624
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4