RE: [ cf-dev ] Regex

2003-10-20 Thread Rich Wild
rereplacenocase(mystring, ([a|p]), \1 class=whatever , ALL) should do it, haven't tested it though. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p

Re: [ cf-dev ] Regex

2003-10-20 Thread Damian Watson
Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something | \2 class=somethingelse]' in the second attribute? #rereplacenocase(body, '([a|p])', '\1 class=mainBody', ALL)# - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: [ cf-dev ] Regex

2003-10-20 Thread Rich Wild
nope. you'll need 2 regexs for that. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something |

RE: [ cf-dev ] Regex

2003-10-20 Thread Stephen Pope
\1 refers to a back-reference ( the stuff between the brackets in the regex) .. if you wanted 2 you'd need 2 reg-ex's ! I think .. it is Monday morning ! Regards Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:36 To: [EMAIL PROTECTED]

Re: [ cf-dev ] Regex

2003-10-20 Thread Damian Watson
Got it now, not only is it Monday morning, I'm also at the lower end of the regex learning curve- a painful combination if there ever was one ;0) It's beginning to make sense though, I've passed the brain scramble stage... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To:

RE: [ cf-dev ] Regex

2003-10-20 Thread Stephen Pope
Ive avoided regex for so long but so much stuff here is in Perl that I couldn't avoid it any longer ! Its quite a learning curve hehe but with a bizarre sense of satisfaction at the end ! :¬) Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October

RE: [ cf-dev ] Regex

2003-10-20 Thread Rich Wild
yea - it is difficult to get your head around, but once you start using them and feeling the awesome power of the Death Star, erm... regex then you'll find them immensely rewarding - especially when you can lose 9 or 10 lines of replace code. -Original Message- From: Stephen Pope

RE: [ cf-dev ] Regex

2003-10-20 Thread Kevin Faulkner
are there any good tutorials around? I've hardly used it at all, but it seems similar to sed which I've used in a previous lifetime. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:56 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Regex yea - it is

[ cf-dev ] ColdFusion Studio 5 + Crash

2003-10-20 Thread Robertson-Ravo, Neil (RX)
I seem to remember this happending way back where on exit : CF Studio would crash out with a The instruction at 0x referenced memory could not be read at 0x. The memory could not be read Anyone know or remember a fix for this...? N -- ** Archive:

RE: [ cf-dev ] Regex

2003-10-20 Thread Stephen Pope
I've found some Perl books very helpful .. There is a chapter (well a couple of chapters) in O'Reilly Learning Perl book which really helped me get my head around RegEx (ie its nice and slow just like me hehe).. I know there is a O'Reilly book called Mastering Regular Expressions which is

RE: [ cf-dev ] Regex

2003-10-20 Thread Ellwood
awesome power of the Death Star!! Fantastic ;-) -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:56 To: '[EMAIL PROTECTED]' are there any good tutorials around? I've hardly used it at all, but it seems similar to sed which I've used in a

Re: [ cf-dev ] Regex

2003-10-20 Thread Damian Watson
Ok then, one final thang... I've now bunged the list tag in there: #rereplacenocase(body, '([a|p|li])', '\1 class=mainBody', ALL)# but the end result in the code is: L class=mainBodyI eep! Why it do dat? - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: [ cf-dev ] Regex

2003-10-20 Thread Damian Watson
Is that enough self-satisfaction to power a small windmill Stephen? Could be an alternative form of energy in the future all thanks to regex :) Kevin, I think Paul J on this list has a website with explications and stuff... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To:

RE: [ cf-dev ] Regex

2003-10-20 Thread Rich Wild
this bit: [a|p|li] only matches single characters, you its finding the L and using that in the replace. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 10:02 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Ok then, one final thang...

[ cf-dev ] OT FTP

2003-10-20 Thread Paul_Swingewood
Can anyone tell me if BT openwoe block port 21. I can't ftp to my server at home :( I wonder if anyone else can see it Regards - Paul 81.132.105.14 * The information contained within this

Re: [ cf-dev ] Regex

2003-10-20 Thread Damian Watson
Is there a way around that -- just tried a couple of things to no avail! - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 10:07 AM Subject: RE: [ cf-dev ] Regex this bit: [a|p|li] only matches single characters, you its finding

RE: [ cf-dev ] OT FTP

2003-10-20 Thread Robertson-Ravo, Neil (RX)
This could the type of thing in which they block access to certain IP's if they are not in a certain range...to protect them. Several ISP's work this way -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 10:18 To: [EMAIL PROTECTED] Subject: [

[ cf-dev ] dwmx delay when saving

2003-10-20 Thread Kola Oyedeji
When using RDS in DWMX 2004, every time I hit save a dialog pops up and I have to wait for around 30 seconds while it 'puts' the files I'm working on. Can this be disabled some how? Thanks Kola Oyedeji Certified Advanced Coldfusion Developer, ICLP London DDI: +44 (0) 208 256 9034 (Ex.2204)

RE: [ cf-dev ] ColdFusion Studio 5 + Crash

2003-10-20 Thread Kola Oyedeji
Can't remember a fix for this. What platform is this on? Kola -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: 20 October 2003 09:57 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] ColdFusion Studio 5 + Crash I seem to remember this

Re: [ cf-dev ] dwmx delay when saving

2003-10-20 Thread Stephen Moretti
Nope... The delay is DW connecting to the server. Login authentication etc Stephen Kola Oyedeji wrote: When using RDS in DWMX 2004, every time I hit save a dialog pops up and I have to wait for around 30 seconds while it 'puts' the files I'm working on. Can this be disabled some how?

RE: [ cf-dev ] dwmx delay when saving

2003-10-20 Thread Stephen Pope
Bah .. DWMX2004 takes about 30 seconds to save a file locally on my machine anyway .. let alone on a remote server .. hang on I'm repeating myself ! Someone mentioned something about turning off caching to make it run faster in a couple of posts from before but Ive no idea where that option is !

RE: [ cf-dev ] dwmx delay when saving

2003-10-20 Thread Kola Oyedeji
Okay so I've moved to using a network join. Much better. I suppose RDS may as well be removed from the product as I imagine its useless in its current incarnation. Kola -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 10:43 To: [EMAIL PROTECTED]

Re: [ cf-dev ] dwmx delay when saving

2003-10-20 Thread Stephen Moretti
Bah .. DWMX2004 takes about 30 seconds to save a file locally on my machine anyway .. let alone on a remote server .. Oh that's not good! I don't get that with dwmx6.1 - files save straight off. I only get a delay when connecting and uploading to a remote server for obvious reasons. If

RE: [ cf-dev ] ColdFusion Studio 5 + Crash

2003-10-20 Thread Robertson-Ravo, Neil (RX)
WindozeI am sure there was something..if not a fix, a workaround.. something to do with Network mappings or something. I have tried to find it all on MM but they have removed the Studio stuff! -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 20 October 2003

RE: [ cf-dev ] dwmx delay when saving

2003-10-20 Thread Paul_Swingewood
I use dreamweaver MX v6.0 (I think its the one before the new one) I use it with RDS and it takes 5 secs or so to save a page. Its absolutely crap in that respect. CF Studio is far better. Does exactly what it says on the tin. However, if you are using other macromedia products then DMWX come

[ cf-dev ] Excel parsing

2003-10-20 Thread Ellwood
Does anyone have or know of a good resource for parsing and excel document in = coldfusion MX and I don't mean displaying it using CFCONTENT. I want to be able = to import an excel document and then write the columns into their relevant = columns in an access database. And I want to do all this

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Paul Fennell
Why dont you just set up and excel datasource and connect to that and update back to the access db -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 11:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Excel parsing Does anyone have or know of a good resource

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Kevin Faulkner
If the EXCEL files could be CSVs , then read the file into memory via CFFILE then loop thru delimitting with chr(10)chr(13) and do an insert each row. This may even wotk with .XLS, but .CSV I know works. -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 20 October 2003

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Ellwood
Hmmm...Is it that simple? -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 11:18 To: '[EMAIL PROTECTED]' If the EXCEL files could be CSVs , then read the file into memory via CFFILE then loop thru delimitting with chr(10)chr(13) and do an insert

[ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Allan Cliff
We use this method and it seems to work quite well except that certain OS seem to save CSV as chr(10) as their separator even though CSV should mean comma. You would have to set up some code to detect this. We also limit the use to 1000 rows per upload. - Original Message - From:

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Kevin Faulkner
It definately is if you can ensure your input file is a csv, as I said, can't confirm MS don't overflow it with escape and display characters if it's an .XLS But if you're happy with csv's then let me know and I'll be happy to share an exampole with you. I've done an automated billing script

RE: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Ellwood
Its only while the site is being set up so I could use the access import but I thought it might be a nice feature for the members to use if they want to upload multiple items and have the excel form. I think Kevins idea is a goer and will attempt that now. I am anticipating (after speaking to the

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Justin
There is a CVS format to CFMX query tag somewhere. If you need to do excel natively that Jakarta project has a project that does that. Can't remember the name. ... ok I looked it up http://jakarta.apache.org/poi/index.html , http://jakarta.apache.org/ last option, use excel via COM ,check out

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Ellwood
Excellent. Would be interested to see. -Original Message- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 11:43 To: '[EMAIL PROTECTED]' It definately is if you can ensure your input file is a csv, as I said, can't confirm MS don't overflow it with escape and display

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Ellwood
Cheers. Looks daunting but will wade my way through it now as I have little else to do anyway ;-) -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 12:06 To: [EMAIL PROTECTED] There is a CVS format to CFMX query tag somewhere. If you need to do excel

RE: [ cf-dev ] Regex

2003-10-20 Thread Adrian Lynch
How does this work for you... cfset text = a href=http://www.google.com;GOOGLE/apA para graph sir/pliList/liliAnother one/li / cfoutput #HTMLEditFormat(text)# p/p #HTMLEditFormat(REReplaceNoCase(text, ([a|p|li]), \1 class=mainBody, ALL))# p/p

[ cf-dev ] Email problem

2003-10-20 Thread Sandeep Shetty
Hi, We are having problems with junk emails being sent out, sometimes we can see coldfusion code in the email header which suggests there could be a problem linked to the cfmail tag in cf5 I know I have posted this question before on this list and one of the suggestions was to upgrade to cfmx6.1 .

RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Kevin Faulkner
Here we go; let me know if you have any queries/other issues. Cheers... CFTRANSACTION CFFILE ACTION=READ FILE=#application.fileLoc#/#yourFilename# VARIABLE=inFile CFOUTPUT cfloop index=line list=#inFile# delimiters=#CHR(13)##CHR(10)# CFQUERY

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Rich Wild
I guess you could save the results of every search in new tables and then on every subsequent search, see if that search has been performed and just call up the results of it rather than doing the search again. Perhaps purge the searches every day or so etc. -Original Message- From:

[ cf-dev ] Cross Site Scripting vulnerability

2003-10-20 Thread duncan . cumming
FYI: Macromedia ColdFusion SQL Error Pages Cross Site Scripting Vulnerability http://www.net-security.org/vuln.php?id=3005 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For

[ cf-dev ] CFTREE submission

2003-10-20 Thread Kevin Faulkner
Hi Folks, Am I missing something, but can a CFTREE CFFORM be submitted by double-clicking one of the 'children' elements itself, or does a separate SUBMIT button need to be added? If so, I recall someone mentioning a good alternative to CFTREE, but can't seem to find it? Kevin

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Robertson-Ravo, Neil (RX)
Hey, There are lots and lots of things you can do. First off, what version of SQL Server is it? As the Query Optimizer in the versions are very different, especially from 7 to 2000. You can even speed up a SELECT * from a table in SQL Server by using Hints. SQL Server uses the Q.O. to

[ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Excel parsing

2003-10-20 Thread Allan Cliff
Need to know if the excel fields have commas in them. i.e. are they text fields. If they are then List get at will only retrieve until the comma. - Original Message - From: Kevin Faulkner To: '[EMAIL PROTECTED]' Sent: Monday, October 20, 2003 2:29 PM Subject: [cfmail] RE: [

RE: [ cf-dev ] Cross Site Scripting vulnerability

2003-10-20 Thread Christopher Dawes
This shouldn't be a problem if you create nice custom error pages. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 20 October 2003 10:38 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] Cross Site Scripting vulnerability FYI: Macromedia ColdFusion SQL

Re: [ cf-dev ] Cross Site Scripting vulnerability

2003-10-20 Thread Stephen Moretti
Thats a canny old security notification I'm sure I saw that one go through the security updates and NTBugTraq months ago Stephen [EMAIL PROTECTED] wrote: FYI: Macromedia ColdFusion SQL Error Pages Cross Site Scripting Vulnerability http://www.net-security.org/vuln.php?id=3005 -- **

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Colm Brazel
Also you can use the block factor, indexes on fields in the where clause, as in http://www.johnwbartlett.com/CF_tipsNtricks/index.cfm?TopicID=10 worth having a look at queryof queries, splitting database into group of smaller databases and performing one query of query on the different

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Robertson-Ravo, Neil (RX)
Well you can only use the table datatype on SQL 2000. But you simply use it much the same as any variable you can declare or SET. think of it as a virtual table in memory...one step up from a temporary table. The chances are that you have Auto Statistics switched on, but there are certain

RE: [ cf-dev ] OT: Secondary DNS

2003-10-20 Thread Giles Roadnight
Thanks for that. My e-mail was going a bit weird on Friday so I didn't actually get this e-mail until now. Some e-mails I never got hence the late reply. I have signed up with gradwell.com and it seems to be a really good service - get a backup mail server too. Giles Roadnight

[ cf-dev ] OT: Search Engine listing Companies

2003-10-20 Thread Giles Roadnight
I'm sure that you all get hundreds of spam e-mail a day from companies guaranteeing top ranking on Google. Of course it is impossible to guarantee this but I was wondering if any of these companies are any good. Anyone got any good experiences with any of them? Thanks Giles Roadnight

[ cf-dev ] Talking of SQL server...

2003-10-20 Thread Ian Westbrook \(FDM\)
...while we're on the subject of SQL server - I currently use Access, but sooner of later I'm going to gave to kick up to SQLserver. Are there any good online resources/introductory books to inform me about the migration of Access db to SQLserver and how to use/administer SQLserver? TIA Ian W

RE: [ cf-dev ] OT: Secondary DNS

2003-10-20 Thread Colm Brazel
www.zoneedit.com 1st 5 are free-) Colm I do not have enough information Data, Star Trek. Colm Brazel MA CB Publications www.cbweb.net http://www.cbweb.net Macromedia-Dublin UserGroup Manager http://www.mmug-dublin.com [EMAIL PROTECTED]

RE: [ cf-dev ] Talking of SQL server...

2003-10-20 Thread Paul Fennell
Thankfully sql server has the handy upsizing wizard to export access to sql db And sql has SQL books on line http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp Open your existing database inside of Access and choose Tools Database Utilities Upsizing Wizard. Once the wizard

Re: [ cf-dev ] OT: Search Engine listing Companies

2003-10-20 Thread Damian Watson
These guys seem pretty cool: http://www.sitescreamer.com/ -- they've got some handy tools on their site (down near bottom on blue nav bar) - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:28 PM Subject: [ cf-dev ] OT:

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Albert Popkov
Normally: Denormalise data, implement some caching, build proper indexes, buy more memory, get proper disk system, consider distributed system, etc If you send a little bit more details about your data, how it is accessed and updated, I may be able to help better. -Original

[ cf-dev ] OT: DWMX 2004 trial

2003-10-20 Thread Aidan Whitehall
Is it possible to install the DWMX 2004 trial alongside DWMX (got all of Studio MX installed on my development box) or does it install over the top? If we don't get the upgrade after it expires, I want to ensure going back to DWMX isn't a PITA. Thanks -- Aidan Whitehall mailto:[EMAIL

RE: [ cf-dev ] Talking of SQL server...

2003-10-20 Thread Robertson-Ravo, Neil (RX)
Access has an upsize wizard for Access to SQL Server, but thats about as far as it gets for the actual migration stuff. Access and SQL Server are whole different beasts with SQL Server obviously giving you the grown-up capabilities of an enterprise level RDBMS. You will begin to leverage Stored

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Justin
Is there a way in MS SQL server to put a table into a memory?? Thanks Justin -Original Message- From: Albert Popkov [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 14:53 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL DB speed Normally: Denormalise data, implement some caching,

RE: [ cf-dev ] SQL DB speed

2003-10-20 Thread Robertson-Ravo, Neil (RX)
erm, yes (and no). In SQL server 2000 you can out data into the TABLE datatype, while that is not in memory as far as CF is concerned, it is for SQL Server. -Original Message- From: Albert Popkov [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 15:19 To: [EMAIL PROTECTED] Subject: RE: [

RE: [ cf-dev ] OT FTP

2003-10-20 Thread Duncan Fenton
Paul, I can see you at ftp://81.132.105.14 with no password. (You might want to consider requiring a password :-) I am using freeserve dialup. HTH, Duncan Fenton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 10:18 To: [EMAIL PROTECTED]