Re: mySQL, datetime, and ColdFusion date objects

2010-05-18 Thread Scott Brady
Well, I guess that's the problem. I was certain there was a cf_sql_datetime (and pretty certain I've been using it for years :) ). I guess I'd expect CF to throw an error for an invalid sql type. Thanks! Scott On Mon, May 17, 2010 at 7:46 PM, Leigh cfsearch...@yahoo.com wrote: Well, a

Re: Transaction locking table, not sure where or why...

2010-05-18 Thread Jochem van Dieten
On Sat, May 15, 2010 at 9:04 AM, Paolo Broccardo wrote: @Brad What puzzles me though is the fact that I set every transaction (the writes and the reads) relating to this process to read uncommitted yet the problem still persisted. But if you set a session (i.e. a connection) to read

Remove html characters

2010-05-18 Thread Rick Sanders
Hey all, What's the best way to remove html characters and make something plain text? reReplace? Thanks, Rick Webenergy ~| Order the Adobe Coldfusion Anthology now!

RE: Remove html characters

2010-05-18 Thread Paul Alkema
Try this... cfset html = 'pa href=test with link/a /p' cfset withoutHtml = REReplaceNoCase(html,a .*(href=[']?)([^' ]+)[' ][^]+([^]+)/a,\3: \2,all) cfset withoutHtml = REReplaceNoCase(withoutHtml,p[^]*,Chr(10),all) cfset withoutHtml = REReplaceNoCase(withoutHtml,[^]+,,all)

RE: Remove html characters

2010-05-18 Thread Rick Sanders
That's what I thought. I would have to put all the tags in there I want to remove like div, strong, font, etc... Thanks. -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Tuesday, May 18, 2010 10:57 AM To: cf-talk Subject: RE: Remove html characters Try

Re: Remove html characters

2010-05-18 Thread Casey Dougall
On Tue, May 18, 2010 at 9:38 AM, Rick Sanders c...@webenergy.ca wrote: Hey all, What's the best way to remove html characters and make something plain text? reReplace? Maybe something like this, there are a couple functions in cflib for this. http://cflib.org/udf/stripHTML

RE: Remove html characters

2010-05-18 Thread Robert Harrison
be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5124 (20100518) __ The message was checked by ESET Smart Security. http://www.eset.com

ColdFusion MX 7 Configuration Transfer

2010-05-18 Thread Donnie Carvajal
We are setting up another server to add to the server farm for one of our apps for load balancing. Needless to say, all of the configuration needs to be the same as the current live servers. Is there a way to transfer the ColdFusion Configuration from one of the current live servers to the

CFMenu Woes

2010-05-18 Thread Kris Sisk
I just launched a new website that uses a cfmenu. The layout is designed for at least a 1024x768 resolution. What we're running into is that the cfmenu javascript doesn't always function correctly in IE7 at resolutions of 800x600 or below. When the user sets their resolution to 1024x768 and

Re: ColdFusion MX 7 Configuration Transfer

2010-05-18 Thread Jochem van Dieten
On Tue, May 18, 2010 at 4:47 PM, Donnie Carvajal wrote: We are setting up another server to add to the server farm for one of our apps for load balancing.  Needless to say, all of the configuration needs to be the same as the current live servers.  Is there a way to transfer the

Re: Remove html characters

2010-05-18 Thread Tom Chiverton
On Tuesday 18 May 2010 15:33:01 you wrote: #REReplace(trim(MYTEXTSTRING), [^]*, , All)# But if I say that this is the other thing, which is that thing, it'll go all wrong... -- Tom Chiverton Helping to centrally extend industry-wide plug-and-play slick products as part of the IT team of

Re: ColdFusion MX 7 Configuration Transfer

2010-05-18 Thread Donnie Carvajal
On Tue, May 18, 2010 at 4:47 PM, Donnie Carvajal wrote: We are setting up another server to add to the server farm for one of our apps for load balancing.  Needless to say, all of the configuration needs to be the same as the current live servers.  Is there a way to transfer the

RE: Remove html characters

2010-05-18 Thread Paul Alkema
I don't know if this will actually help you or not, But I figured it might help someone someday. Lol If your using MSSQL and pulling the data your looking to strip from a database, than you can actually do this from a mssql user defined function. -- FIRST, RUN THE CODE BELOW ONCE TO CREATE

Re: ColdFusion MX 7 Configuration Transfer

2010-05-18 Thread Jochem van Dieten
On Tue, May 18, 2010 at 5:27 PM, Donnie Carvajal wrote: ColdFusion stores its configuration in the various neo-*.xml files in the lib folder so if you copy those to the new server the system will have an identical configuration. If you have Enterprise Edition, you can also export a CAR on the

Re: mySQL, datetime, and ColdFusion date objects

2010-05-18 Thread Leigh
Well, I guess that's the problem. I was certain there was a cf_sql_datetime (and pretty certain I've been using it for years :) ).  I guess I'd expect CF to throw an error for an invalid sql type. Yes, that was my expectation too. But I _think_ CF does not not validate the types. IIRC, it

HomePortals?

2010-05-18 Thread Sandra Clark
Just ran across this while searching for a Coldfusion Wiki that needs to run alongside Commonspot. Anyone heard of it? Any pros or cons regarding it? I'm willing to download it, but unfortunately, my time is limited to get this project done and I don't have a lot of time to play with something

Re: HomePortals?

2010-05-18 Thread Barney Boisvert
The guy who built it happens to be sitting at the desk next to me. ;) It's not really a wiki, but it might serve the need. Canvas and Codex are both real CFML wiki packages, and they should run next to CommonSpot, I'd think. cheers, barneyb On Tue, May 18, 2010 at 9:44 AM, Sandra Clark

Re: HomePortals?

2010-05-18 Thread Gerald Guido
Are talking about MiniWiki? If so all you have to do to run the wiki is unzip and place the homportals folder under your web root dir and set up Miniwiki's config file. It was painless. HTH G! On Tue, May 18, 2010 at 12:44 PM, Sandra Clark sclarkli...@gmail.comwrote: Just ran across this

Force SSL

2010-05-18 Thread Donnie Carvajal
Does anyone know of a way to force SSL for all files in a web site? This solution should handle non-Coldfusion pages such as PDF files as well. I am using Windows 2003 with IIS. Thanks, Donnie ~| Order the Adobe

Re: Force SSL

2010-05-18 Thread Barney Boisvert
Make a HTTP host that simply redirects to the same domain-relative URI, except over HTTPS. Then every request will be either over SSL or forward to one that is. cheers, barneyb On Tue, May 18, 2010 at 10:00 AM, Donnie Carvajal donnie.carva...@transformyx.com wrote: Does anyone know of a way

Re: Remove html characters

2010-05-18 Thread Jochem van Dieten
On 5/18/10, Rick Sanders wrote: What's the best way to remove html characters and make something plain text? reReplace? Will the HTML be well-formed? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the

Re: Remove html characters

2010-05-18 Thread Wil Genovese
I use this to create text part message from HTML. This lets you keep basic line break formatting while stripping tags. !---# # TextMessage #

Extra Comma prepends to a form variable

2010-05-18 Thread funand learning
Hi All, I have a form variable which contains a list for example ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive:

Comma Prepending to a form variable

2010-05-18 Thread funand learning
Hi All, I have a form variable which contains a list of names like input type=hidden name=varList value=coldfusion,java,dotnet when I go from the current page to another page and I check the above form value, I have it as input type=hidden name=varList value=,coldfusion,java,dotnet I am

Re: Comma Prepending to a form variable

2010-05-18 Thread Gerald Guido
It sounds like you have two form fields with the same name attribute. That would add the extra comma. G! On Tue, May 18, 2010 at 1:49 PM, funand learning funandlrnn...@gmail.comwrote: Hi All, I have a form variable which contains a list of names like input type=hidden name=varList

Re: Comma Prepending to a form variable

2010-05-18 Thread Wil Genovese
My best guess is that the functions of forms in HTML would not do this unless there is another form field of the same name preceding this on on the form page. Then upon submit the first one being blank is being prepended to the form field you really want. Wil Genovese One man with courage

RE: Comma Prepending to a form variable

2010-05-18 Thread Paul Alkema
Is it possible that you have more than one field with the name varList on the page? If you have two form field on the same page with the same name. Your action page will insert a comma in the form fields to delimit the fields. Paul Alkema http://paulalkema.com/ -Original Message- From:

Re: Comma Prepending to a form variable

2010-05-18 Thread funand learning
You are right guys...Thanks a lot for the hint...that really helped me... On Tue, May 18, 2010 at 1:59 PM, Paul Alkema paulalkemadesi...@gmail.comwrote: Is it possible that you have more than one field with the name varList on the page? If you have two form field on the same page with the

cfdocument / cflocation

2010-05-18 Thread Nando
Hi, I'd like to run a cflocation after generating a PDF using cfdocument, however, all efforts have failed. It seems all code after a cfdocument tag that pushes a PDF to browser for download is ignored. I've even attempted to set a variable *before* running the cfdocument tag

Re: cfdocument / cflocation

2010-05-18 Thread Dave Watts
I'd like to run a cflocation after generating a PDF using cfdocument, however, all efforts have failed. It seems all code after a cfdocument tag that pushes a PDF to browser for download is ignored. When you use CFLOCATION, users don't see the page containing the CFLOCATION tag. Instead, they

Re: cfdocument / cflocation

2010-05-18 Thread Wil Genovese
Nando, Typically when I do PDF creation I want the user to download and save the PDF. To do that I use a combination of CFHEADER and CFCONTENT. Doing this forces the users browser to download the PDF instead of viewing it the browser. Here is an example of how to do this. cfdocument

Now() vs getDate() MsSQL CFMX

2010-05-18 Thread Sean N Henderson
Over the past few years the drift between now() and getDate() has grown to almost 10 minutes. Using CFMX6.1 (J2RE 4_2_11), Win2K3 and SQL2K. What's the tweak/fix or where should I look? (Besides upgrading to newer software stack) Have poured over the CF Admin and Enterprise Manager to no

Re: Now() vs getDate() MsSQL CFMX

2010-05-18 Thread Alan Rother
Now() polls the server running CF system's clock time, getDate() does the same except on the box that hosts the SQL Server. My assumption is any difference between the two would be the result of the two server's clocks not being in sync. This can happen if the servers do not make use of a central

RE: Now() vs getDate() MsSQL CFMX

2010-05-18 Thread Justin Scott
My assumption is any difference between the two would be the result of the two server's clocks not being in sync. I concur with that assessment. If you have access, I'd recommend setting the servers to use an NTP time server to keep them in sync with the rest of the world. -Justin

inserting a new record with identity key using cfgrid bind onchange

2010-05-18 Thread sarah mfr
I got an error message on trying to insert a row to a table with an identity column using cfgrid onchange I would like also to use a stored procedure instead of cfquery I just need how to call it and how to pass arguments to it Please look below is the code,component, and error message My

Error trapping

2010-05-18 Thread Rick Sanders
Hey all, I've tried using the cferror tag and having the error emailed to me but instead it throws an http 500 error and the error doesn't get emailed. What's the easiest way to have an error on a cfm page trapped, emailed, and then redirected to an error page? Thanks, Rick

Re: mySQL, datetime, and ColdFusion date objects

2010-05-18 Thread Scott Brady
That makes sense. It also explains why it was warning me of data truncation. Scott On Tue, May 18, 2010 at 10:35 AM, Leigh cfsearch...@yahoo.com wrote: Well, I guess that's the problem. I was certain there was a cf_sql_datetime (and pretty certain I've been using it for years :) ). I

RE: Error trapping

2010-05-18 Thread andy matthews
That probably means there's a coldfusion error in your error page. Try removing all CF code and just put text on the page. See if that gets emailed to you then slowly work back in your error logic. andy -Original Message- From: Rick Sanders [mailto:c...@webenergy.ca] Sent: Tuesday,

Re: Now() vs getDate() MsSQL CFMX [spamtrap bayes][spamtrap heur]

2010-05-18 Thread Paul Hastings
On 5/19/2010 3:56 AM, Sean N Henderson wrote: Over the past few years the drift between now() and getDate() has grown to almost 10 minutes. Using CFMX6.1 (J2RE 4_2_11), Win2K3 and SQL2K. use an NTP timeserver for *all* your servers. if in the US try http://www.time.gov/

Re: Now() vs getDate() MsSQL CFMX [spamtrap bayes][spamtrap heur]

2010-05-18 Thread Dave Watts
Over the past few years the drift between now() and getDate() has grown to almost 10 minutes.  Using CFMX6.1 (J2RE 4_2_11), Win2K3 and SQL2K. use an NTP timeserver for *all* your servers. if in the US try http://www.time.gov/ Yes. And to elaborate a bit on this, you should have your own