Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Cassidy Symons
I'm have a really weird problem here...I've got a form, and one of the fields is called 'evaluation_required' - it's a Yes/No field with values of 1/0. The column in the database has the same name, and is a BIT field (technically TINYINT(1) since MySQL has no real BIT, but...). When I submit

RegEx - is it possible to strip all HTML except certain tags?

2004-08-25 Thread Cassidy Symons
I've been testing this out and can't find a way to strip all HTML except certain tags...is there any sort of 'not' modifier in RegEx in CF5, so I could do something like: cfset mytext = '#REReplaceNoCase(mytext,/?(NOT{b,i,strong,p,etc...}[^]*,,all)#' Which would leave in tags that aren't

Re: RegEx - is it possible to strip all HTML except certain tags?

2004-08-25 Thread Cassidy Symons
Thanks! Giving it a quick spin it looks like it's probably going to be the simplest way to accomplish what I want. Barney Boisvert wrote: RE doesn't have that kind of negation operator, in any implementation. I usually do something like this (untested): str = REreplaceNoCase(str,

Help with PreserveSingleQuotes...losing my mind here

2004-08-24 Thread Cassidy Symons
As a preface, I'm using CF5 on Win2K. I'm trying to create a UDF as follows (it will have more functions later, I know it doesn't seem very useful at the moment): cfscript function TextStore(db_string) { db_string = PreserveSingleQuotes(db_string); return db_string; } cfscript then call it

Re: Help with PreserveSingleQuotes...losing my mind here

2004-08-24 Thread Cassidy Symons
I belive that PSQ is only valid inside CFQUERY tags, because that's the only place that CF will automatically double your single quotes. Thus, you can't use it in a UDF.It's weird that it's giving you that error message, but getting the wrong message like that isn't unheard of. cfset foo =

Re: Help with PreserveSingleQuotes...losing my mind here

2004-08-24 Thread Cassidy Symons
This is just a guess, but I think the problem might have to do with the fact that you're using the same name for the local variable as you are for the argument. You should be able to do this: function TextStore(db_string) { var tmp_db_string = PreserveSingleQuotes(db_string); return

Re: Help with PreserveSingleQuotes - RESOLVED

2004-08-24 Thread Cassidy Symons
Sorry, I figured things out...I was having a brainfart. Cassidy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Help with PreserveSingleQuotes...losing my mind here

2004-08-24 Thread Cassidy Symons
Yes, I think you are. That's the default behavior for CFQUERY, and always has been. The PreserveSingleQuotes function allows you to override that behavior. As for PreserveSingleQuotes working before, the function won't produce an error if used outside of CFQUERY, but it won't have any effect

Re: 'Moving' Session variables

2004-02-03 Thread Cassidy Symons
Off the top of my head... 1) Are the two client machines behind the same proxy/firewall? I've heard of some odd things happening when two client machines appear the same to the outside world. 2) Are all of your session reads and writes locked? Cassidy [EMAIL PROTECTED] There are people who

Re: 'Moving' Session variables

2004-02-03 Thread Cassidy Symons
that they problem manifested. - Original Message - From: Cassidy Symons To: CF-Talk Sent: Tuesday, February 03, 2004 10:04 PM Subject: Re: 'Moving' Session variables Off the top of my head... 1) Are the two client machines behind the same proxy/firewall? I've heard of some odd

Re: Read the url a person came from??

2003-08-14 Thread Cassidy Symons
#CGI.HTTP_REFERER# It will sometimes have a page name attached to it (ie, http://domain.com/index.cfm), but that can be checked for and chopped off if necessary. At 05:01 PM 8/9/2003 -0500, you wrote: Hello, I was wondering if someone can point me in the right direction on what variable

Re: SQL gurus please help

2003-07-22 Thread Cassidy Symons
Change the WHERE clause to WHERE dateUpdated null At 04:51 PM 7/22/2003 -0700, you wrote: Trying to do a simple select query that filters out records against a date column. I want all records with an empty value in the date column. Here's my query... cfquery name=getData datasource=cfDS

Writing Excel files

2003-06-06 Thread Cassidy Symons
I'm looking for suggestions on the most efficient to write an XLS file via ColdFusion. I've tried COM objects (not stable enough for regular use), HTML tables being read in Excel (too slow for the quantities of data in question), and using an Excel datasource (a pain in the ass since this is

Re: Writing Excel files

2003-06-06 Thread Cassidy Symons
issue or just a general lack of stability in using an instance of Excel in that fashion, but I just couldn't get it strong enough to use it on a regular basis. At 03:53 PM 6/5/2003 -0400, you wrote: Have you checked out http://www.cfcomet.com/ yet? E - Original Message - From: Cassidy

Re: Back Buttons

2003-06-04 Thread Cassidy Symons
history.go(-2) At 03:52 PM 6/3/2003 -0400, you wrote: Is there away to make the back button do history -2 instead of -1 on certain pages... I am trying to bypass a form post page to return my users to where they origiannlly came from... Any ideas... Kris Pilles Website Manager Western Suffolk

Increase stability in Excel COM object?

2003-05-27 Thread Cassidy Symons
I've been trying to get solid, stable code for writing an XLS file using a COM object, but it seems to break every few times I try it, even with TRY/CATCH statements. I copied the basic code straight out of the Ben Forta books, then just made changes to the database stuff based upon my specific