Re: Parsing transitional HTML using xmlparse()

2010-12-20 Thread denstar
Railo has a function called htmlParse() that will "clean up" html into xhtml, but I /think/ it's only a Railo deal. You can use something like JTidy, or Jericho HTML parser, etc., etc., if you're uncertain of what the input will be, and just need valid output. If you *know* that it will only be

Re: Where Woes

2010-12-20 Thread Sean Corfield
On Mon, Dec 20, 2010 at 8:59 PM, Rob Voyle wrote: > Yes Why? the quotes > I have other query's where it works fine without quotes. If you have a numeric column then #var# will work. If you have a varchar column, you need '#var#' because the SQL syntax requires a 'string'. But I'd recommend you

Re: Where Woes

2010-12-20 Thread Rob Voyle
Hi Jerry and Greg Thanks. Yes Why? the quotes I have other query's where it works fine without quotes. Rob On 20 Dec 2010 at 23:51, Jerry Johnson wrote: > > you need to surround the program variable with single quotes, like > so > > where programCode1='#program#' > > Please ask if you

Re: Where Woes

2010-12-20 Thread Jerry Johnson
you need to surround the program variable with single quotes, like so where programCode1='#program#' Please ask if you need an explanation of why. Jerry Milo Johnson On Mon, Dec 20, 2010 at 11:48 PM, Rob Voyle wrote: > > Hi Folks > > I have a mysql table that I am querying with CF > > On

Re: Where Woes

2010-12-20 Thread Greg Morphis
Wrap it in quotes and use wrote: > > Hi Folks > > I have a mysql table that I am querying with CF > > One of the columns is programCode1 > > I have a where statement: > > where programCode1=#program# > > that returns the error message: > Unknown column 'atmBaltimore41' in 'where clause' > > atmBa

Where Woes

2010-12-20 Thread Rob Voyle
Hi Folks I have a mysql table that I am querying with CF One of the columns is programCode1 I have a where statement: where programCode1=#program# that returns the error message: Unknown column 'atmBaltimore41' in 'where clause' atmBaltimore41 is the value of #program# If I put the atmBa

Parsing transitional HTML using xmlparse()

2010-12-20 Thread Michael Grant
I have the following code pseudo code as an example: Some text here and br's that don't close. I would like to parse this with xmlParse so that I can use dot notation to traverse it as a struct. However when I use xmlParse I get an error because the img and br tags aren't closed. The

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Mike Chabot
Generally, unless you have a specific need to use UUIDs/GUIDs, such as in replication scenarios, integers are the better choice. Kimberly Tripp has a great presentation on this subject if you ever get a chance to take one of her classes. She spends an hour detailing all the ways the use of GUIDs n

RE: Leading space added with CF9.0.1

2010-12-20 Thread Andrew Scott
Just a quick not as this is not a solution. Doesn't need the hashes in anyway shape or form. Is the correct way to do it. Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: Debbie Morris [mailto:deb_mor...@comcast.net] > Sent: Tuesday, 21 December 20

RE: PDF printing issues

2010-12-20 Thread Mark A. Kruger
Tim, There are many tips and tricks to optimizing your pdf generation. Most of them boil down to removing or streamlining the external resources needed. So, for example, if you use an exteneral CSS file, cfdocument has to... -Resolve the URL to the css file -"get" the CSS file via cfhttp -"rend

RE: Leading space added with CF9.0.1

2010-12-20 Thread Debbie Morris
Thanks for all the help, Matt! I'll have to take a look around to see where all of these functions are being used. Quite a few of them seem to be set to "remote"... -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Monday, December 20, 2010 2:34 PM To: cf-t

PDF printing issues

2010-12-20 Thread Tim Do
We're having a bit (HUGE) of a problem printing PDFs created by using cfdocument. We just updated our PDF generator to us CF instead of html2pdf. We are having many users complain that it takes 20-30 minutes to print out PDFs (20-25pgs). The file size itself is about 1mb so file size isn't t

RE: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Russ Michaels
Which is exactly what I am trying to do here http://www.cfmldeveloper.com/page.cfm/coldfusion-vs-railo-1, sadly I am not getting much input from others so I am only able to update it base don my own experiences, but as I migrate apps between Cf/Railo I do take note of things I have to fix and I do

Re: Leading space added with CF9.0.1

2010-12-20 Thread Matt Quackenbush
Oh, as an aside, I noticed that you have access="remote" set on your MapFormat function. Unless you are directly exposing that CFC and method to a web service or are hitting it directly via URL (e.g. http://yoursite.com/your.cfc?method=MapFormat), you will want to set that to "public" instead.

Re: Leading space added with CF9.0.1

2010-12-20 Thread Matt Quackenbush
As a general rule, you will always want output="false" on your tag-based functions. Pretty much the only exception to that is if you are truly wanting to output from within that function. #foo# The issue is that CF generates whitespace in its processing of tags. So, to keep that fr

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Phillip Vector
Of course I check the values and such when I need to. But for something like a "I forgot my password" system, I'd rather give them a "key" of a UUID then an integer. On Mon, Dec 20, 2010 at 10:44 AM, Dave Watts wrote: > >> If you are using it as an ID, I go with UUID. Makes it a little harder >>

RE: Leading space added with CF9.0.1

2010-12-20 Thread Debbie Morris
That actually does take care of the space issue. Thanks! So what exactly does that attribute do? I read the docs but I'm still not clear. I checked the other pages that use the MapFormat function and they all still seem to function correctly, so it seems I should be safe leaving it set to fals

Re: Leading space added with CF9.0.1

2010-12-20 Thread Matt Quackenbush
Since you say the extra whitespace disappears if you assign a variable first, I don't think this is the solution to your problem, but for kicks and grins, try setting output="false" on your MapFormat . ~| Order the Adobe Coldfus

Re: Exporting a Spreadsheet file

2010-12-20 Thread Rick Colman
This worked! TNX. On 12/20/2010 10:46 AM, Ian Skinner wrote: >On 12/20/2010 10:41 AM, Rick Colman wrote: >> This works fine in IE, etc. : >> >> > value="buylist_job_#session.projectid#.xls"> > This is the way I usually see and use that tag. > > > > NOTE the *filename=* part of the value para

Re: Exporting a Spreadsheet file

2010-12-20 Thread Ian Skinner
On 12/20/2010 10:41 AM, Rick Colman wrote: > This works fine in IE, etc. : > > value="buylist_job_#session.projectid#.xls"> This is the way I usually see and use that tag. NOTE the *filename=* part of the value parameter. ~~

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Dave Watts
> If you are using it as an ID, I go with UUID. Makes it a little harder > to put into the URL to look up things they shouldn't. If your applications allow people to substitute values and see things they shouldn't see, you have bigger problems than integers vs UUIDs. Dave Watts, CTO, Fig Leaf So

Exporting a Spreadsheet file

2010-12-20 Thread Rick Colman
This works fine in IE, etc. : However, in Google Chrome, it writes a file with a .CFM extension instead of a .XLS extension, causing problems for users. Anyone else seen this problem? Is the a CF workaround? Rick. ~| Order

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Dave Watts
> So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5 > Ent and an enterprise application with millions of rows in the table? Do you plan to use these records anywhere other than this database server (replication, migration)? If so, use a UUID. But you might want to let the

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Jason Fisher
Using UIDs makes it much easier to move data between servers or databases or even tables later, too, if you ever need to. For instance, moving records from production down to staging, when there's been testing going on in staging ... may have 100 records with IDs between 105 and 204 in each d

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Phillip Vector
If you are using it as an ID, I go with UUID. Makes it a little harder to put into the URL to look up things they shouldn't. On Mon, Dec 20, 2010 at 9:34 AM, Brian Polackoff wrote: > > So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5 > Ent and an enterprise application

Re: Auto Incrementing Seed vs CF UUID

2010-12-20 Thread John M Bliss
Auto Incrementing Seed - bigint (max 9,223,372,036,854,775,807 rows) or int (max 2,147,483,647 rows) CF UUID (max functionally infinite rows) ...so choose the smallest one of those that is large enough to be future-proof for your table. NOTE: when I use UUID, I don't use CF UUID. Instead, I use

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Sean Corfield
On Mon, Dec 20, 2010 at 7:20 AM, <> wrote: In Gmail, this post seems to be from an anonymous user... > I hate those open source or free stuff. ...so I visited the HoF site and I see it's Claude Schneegans, in which case the negativity makes perfect sense. > The more undocumented free gadgets

Auto Incrementing Seed vs CF UUID

2010-12-20 Thread Brian Polackoff
So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5 Ent and an enterprise application with millions of rows in the table? Thanks for all your feedback, Brian ~| Order the Adobe Coldfusion Anthology now!

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread James Holmes
http://www.getrailo.org/index.cfm/documentation/compatibility/cfml-compatibility/ -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 21 December 2010 01:20, <> wrote: > > The least would be some good docs about what's in CF and is not in Railo, and > vice versa. ~~~

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread David McGraw
There are docs on the Railo site which details exactly what is and isn't supported across the different platforms. I use Railo, I find is a great alternative for most of my clients. - Then again, we develop in multiple languages, so to me, it's just another language to know the difference in synt

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Claude Schnéegans
>>When it comes to CFML programming the docs for Railo is pretty much the same as ColdFusion. "Pretty much", until you find something that works under CF and does not under Railo. Most of the time, it is only a detail, but it can cost you hours. The least would be some good docs about what's i

Leading space added with CF9.0.1

2010-12-20 Thread Debbie Morris
I'm in the process of building a new CF9.0.1 server to replace our existing 7.0.2 production server. I'm confused about the behavior I'm seeing when testing one section of the site. There is a link that is generated to point to a PDF of a map. On the new server, the link is incorrectly generat

RE: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Russ Michaels
Documentation for Railo is indeed poor, but they are aware and they are working on it, it has been improving slowly and there is now a good installer as well. But remember this is really only with regards with installing and setup. When it comes to CFML programming the docs for Railo is pretty muc

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Matthew Lesko
> I tried to give a test to Railo some months ago. > The lack of documentation made me give up after a few days. > I finally upgraded to CF 9. > Documentation is the most important thing for developers. > For the same reason, I hate Mozilla. > It may be many times better than Explorer, but their d

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Matthew Lesko
> you may also find this comparison helpful. > > http://www.cfmldeveloper.com/page.cfm/coldfusion-vs-railo-1 > > Russ > > On Mon, Dec 20, 2010 at 11:26 AM, Matthew Lesko > wrote: > Thanks I've added this to an answer on the site. Comments are just as interesting as the actual comparison.

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Claude Schnéegans
>>Open source, or free, does not automatically equal crappy documentation. At least for the two examples I gave, YES! >>And what kind of docs are you looking for in your browser? Mostly Javascript and CSS. As far as HTML is concerned, there are not really differences. ~~

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Raymond Camden
Wow, this is incredible. You hate open source and free stuff? Really? I've used plenty of commercial software with crappy documentation. Open source, or free, does not automatically equal crappy documentation. And what kind of docs are you looking for in your browser? On Mon, Dec 20, 2010 a

Re: JRun 404 without index.cfm (Win2008 R2 / CF9)

2010-12-20 Thread Jeff Chastain
>Did you add index.cfm to the 'list' of default files in IIS? > Not quite that obvious Scott ;-) Yeah, IIS has the index.cfm setup as the first default document and the 404 page I am getting is not the IIS page, thus my assumption that it is the JRun 404. The layout is very basic, dark grey

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Claude Schnéegans
I tried to give a test to Railo some months ago. The lack of documentation made me give up after a few days. I finally upgraded to CF 9. Documentation is the most important thing for developers. For the same reason, I hate Mozilla. It may be many times better than Explorer, but their documentation

Re: JRun 404 without index.cfm (Win2008 R2 / CF9)

2010-12-20 Thread Scott Stroz
Did you add index.cfm to the 'list' of default files in IIS? On Mon, Dec 20, 2010 at 9:59 AM, Jeff Chastain wrote: > > I could use some help pointing out the obvious here.  I have a Win2008 R2 > server that I have been working through the Adobe CF9 lock down guide on and > have setup ColdFusio

JRun 404 without index.cfm (Win2008 R2 / CF9)

2010-12-20 Thread Jeff Chastain
I could use some help pointing out the obvious here. I have a Win2008 R2 server that I have been working through the Adobe CF9 lock down guide on and have setup ColdFusion in multi-server mode. For some reason, I cannot browse the CF admin or web sites without appending /index.cfm to the url.

Re: wrong serial for CF9 upgrade

2010-12-20 Thread cf-talk
Hi Dave, excellent idea ! That worked. Thanks !! Uwe >> With Windows, when I am tiping in the new CF9-serial, >> the installation asks me for the old CF8/CFMX7 key and all >> works fine. Under Linux this question doesn't show up. > I believe that the license information is stored in a file cal

Re: What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Russ Michaels
you may also find this comparison helpful. http://www.cfmldeveloper.com/page.cfm/coldfusion-vs-railo-1 Russ On Mon, Dec 20, 2010 at 11:26 AM, Matthew Lesko wrote: > > > http://stackoverflow.com/questions/4480205/what-notable-differences-are-there-between-railo-open-bluedragon-and-adobe-cold >

What Notable Differences are there between Railo, Open Bluedragon, and Adobe Coldfusion? [Stackoverflow.com]

2010-12-20 Thread Matthew Lesko
http://stackoverflow.com/questions/4480205/what-notable-differences-are-there-between-railo-open-bluedragon-and-adobe-cold Posting here to in hopes list readers will post new, useful answers. ~| Order the Adobe Coldfusion Antho

Merry Christmas cf-talk@houseoffusion.com

2010-12-20 Thread Blizzm
Hi cf-talk@houseoffusion.com have you got all your Christmas presents? Do you need Christmas money this Holiday season? Working from home has never been easier! http://bit.ly/hDg3R8 ~| Order the Adobe Coldfusion Anthol