date:20040205

2004-02-05 Thread Jon Block, College Publisher Developer

I just wrote a UDF to do a rereplace with manipulated backreference
values. Specifically, it replaces all instances of email addresses in
a string with antiSpam email addresses.

However, I'm wondering if there was an easier way...

Is there any magic shortcut, similar to this (illegal) pseudo-code?
(i.e. Is there a way to manipulate the backreferenced value within the
rereplace function?)

rereplace(str,
 ([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
 emailAntiSpam(\1),
 all);

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: flash/web serivce integration

2004-02-05 Thread Mike Chambers

crossdomain.xml allows Flash to connect directly to webservices (or
other data) on third party domains. So, if you are controlling where
the webservice is, then you can allow direct access to it from Flash
(without usign a proxy).

If you use remoting, you will need to install a server / Flash Remtoing
adapter to act as a proxy.

More info here:

http://www.macromedia.com/devnet/mx/flash/articles/ 
fplayer_security_print.html

mike chambers

[EMAIL PROTECTED]

On Feb 4, 2004, at 2:05 PM, Barney Boisvert wrote:

 Didn't know about crossdomain.xml.  That's pretty sweet.  Remoting
 here we
 come.

 It seems like there should be a way to bind the data together, rather
 than
 having to iterate.  That's the whole point of data binding, after all,
 and
 it worked just fine in MX (not MX '04).  Oh well.

 Cheers,
 barneyb

  -Original Message-
  From: Brian LeRoux [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, February 04, 2004 1:53 PM
  To: CF-Talk
  Subject: RE: flash/web serivce integration
 
  Don't forget about the crossdomain.xml / you may have to always proxy
  via your cfc server. To answer your question, you could always
 iterate
  over the dataset and populate the different controls manually with
 the
  returned result.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: How do you clear cache in CFMX?

What if I write a script that turns off the trusted cache, then turns off
the cf server, then deletes all of my compiled (cfm) .class files that I
found in the CfusionMX directory structure, then I turn on the CF service
and turn trusted cache back on? Wouldn't that simulate a complete cache
drop? I *did* want to keep the server running but if this is the next best
way, I'll do it since I've got a cluster of machines...

Jon
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 1:53 PM
To: CF-Talk
Subject: RE: How do you clear cache in CFMX?

Hi Dave
Its the once the files have been run once part that stinks.If I were
implemeting a cache and there was a way to disable the cache I would also
cause that to flush the cache.Or at least provide some other way to do
it.
Then we'd all be happy.
Mark

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 10:50 AM
To: CF-Talk
Subject: RE: How do you clear cache in CFMX?

   cfobjectcache and cfcache aren't the solution for what
   I'm talking about. The problem is that the CF Application
   Server has trusted cache enabled. I do this because its too
   slow for it to continually read the source code off of the
   shared drive it lives on. Sometimes I come up with updates
   to my application. With the server running, I want to be
   able to say.. Dear ColdFusion, please do not stop running
   but simply reparse and recomplie all of my lovely CFM files
   because I have updated a bunch of them. I found a PPT slide
   show by Charlie Arehart which explains that there is a batch
   file that can precompile the CFM templates but I would prefer
   to have the CF appliation software recompile all templates if
   I want it to so that source code updates are reflected...
 
  To get the effect you're describing, you can simply disable
  trusted cache until all of the files have been run once.

 The feature he wants to entirely reasonable and logical. I
 hope MM adds something to make this possible in the future.

I must be missing something, then. As far as I can tell, the feature is
already present. You can currently disable trusted cache in the CF
Administrator. If you want to do that programmatically, I'm sure it's
possible with a little work.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
 _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Java Web Service

2004-02-05 Thread Pete Freitag

Qasim Rasheed wrote:

I understand this is not a Java forum but since some of the people
here have a good grasp on Java, I thought may be I should ask this
question. I am trying to develop my first Java web service for which
all the java classes has been created. Now I am wondering is there a
tool available e.g. an Eclipse Plugin, which can help me generating
wsdd, wsdl etc files In other words, I am looking for a tool with
which I can run Java2WSDL. I understand that, axis has to be used for
this purpose, but setting all those classpath etc is driving me nuts.
So any help is greatly appreciated.

Hi Qasim,

You might want to take a look at JWS files, they are basically just a Java source file named .jws instead of .java, when a J2EE server has jws files mapped to the correct servlet, things work just like a CFC, you just access http://server/MyService.jws?wsdl to get the wsdl: see my blog post on this: http://www.petefreitag.com/item/104.cfm (you can also do this on CFMX)

There is also sample JWS files that comes in the Axis SDK.

If you want to use the Java2WSDL tool, I recommend using the Ant tasks that come with Axis, then you just need to throw all the axis jar's in Ant's lib directory. There is an example of using Axis' wsdl2java tool with Ant in the web services chapter of my book as well.

__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]

Re: Spell Check custom tag needed

2004-02-05 Thread Pete Freitag

Ketan Patel wrote:

 Hi All,
 Does anybody in the forums know about freebee spell check custom tag 
 or CFX
 tag.

Not a freebie, but we make one: http://www.cfdev.com/spellcheck/

__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: REReplace: Manipulating Backreferences

2004-02-05 Thread Jon Block, College Publisher Developer

Not directly, that I've ever been able to figure out.What I have done 
(though it's kind of a pain) is to use refind to grab out the bits I 
want, and do something like

string = left(string, pos[1] - 1)  emailAntiSpam(mid(string, pos[1], 
len[1]))  right(string, pos[1]+len[1]+1, len(string));

Loop over this until pos[1] = 0;

Ugly, but it works.

Not that it will probably help you do what you're trying to do.:-(

--Ben Doom

Jamie Jackson wrote:

 I just wrote a UDF to do a rereplace with manipulated backreference
 values. Specifically, it replaces all instances of email addresses in
 a string with antiSpam email addresses.
 
 However, I'm wondering if there was an easier way...
 
 Is there any magic shortcut, similar to this (illegal) pseudo-code?
 (i.e. Is there a way to manipulate the backreferenced value within the
 rereplace function?)
 
 rereplace(str,
([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
emailAntiSpam(\1),
all);
 
 Thanks,
 Jamie

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Why can't CF see my mapped or subst'ed drives!?

Umm... I have a problem... I have a virtual drive that I call S:\. I've
tried setting it is a mapped drive and also set it as a virtual drive with
the subst utility. (I'm on windows xp pro). Anyway, from within my CF page,
when I do a directory exists on it, it doesn't see it... look

directoryExists(S:\) = NO

How do I get this to work? On my old windows 2000 server, this same script
worked fine. They just bought me a new machine running xp pro and these damn
virtual drives are 'driving' me crazy. My scripts need to be able to see
them.

(I'm running ColdFusion v5 and Windows XP Pro I know I know.. I'll be
using CFMX soon but I'm not quite there yet)

Please help!
Jon
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: flash/web serivce integration

Just web services huh?Oh well.

Now what about the inability to bind data from a web service to a GUI
component? 

Cheers,
barneyb

 -Original Message-
 From: Mike Chambers [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 10:42 AM
 To: CF-Talk
 Subject: Re: flash/web serivce integration
 
 crossdomain.xml allows Flash to connect directly to webservices (or
 other data) on third party domains. So, if you are controlling where
 the webservice is, then you can allow direct access to it from Flash
 (without usign a proxy).
 
 If you use remoting, you will need to install a server / 
 Flash Remtoing
 adapter to act as a proxy.
 
 More info here:
 
 http://www.macromedia.com/devnet/mx/flash/articles/ 
 fplayer_security_print.html
 
 mike chambers
 
 [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Another CFLogin issue - Roles

2004-02-05 Thread Michael Dinowitz

Turns out that there was an additional CFLOGINUSER in a login template that
was hard coded to Super User. It all revolved around a problem with some
code which was within a CFLOGIN that was always running, even when someone
was logged in. I'm using
CFIF Not Len(GetAuthUser())
to see if someone is logged in or not now and it's working perfectly. I'm
definitely going to have to write a paper on all this.

 Maybe it's a caching issue for you? Running this code returns false:

 cflogin
 cfloginuser name=ray password=foo roles=Enzyme Super
 /cflogin

 cfif isUserInRole(Super User)
 yes
 cfelse
 no
 /cfif
 p



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: REReplace: Manipulating Backreferences

Yeah, I've already got the UDF written, I was just thinking how nice
it would be if I could manipulate the backreference directly. It would
simplify the code a lot.

Thanks,
Jamie

On Thu, 05 Feb 2004 13:50:27 -0500, in cf-talk you wrote:

Not directly, that I've ever been able to figure out.What I have done 
(though it's kind of a pain) is to use refind to grab out the bits I 
want, and do something like

string = left(string, pos[1] - 1)  emailAntiSpam(mid(string, pos[1], 
len[1]))  right(string, pos[1]+len[1]+1, len(string));

Loop over this until pos[1] = 0;

Ugly, but it works.

Not that it will probably help you do what you're trying to do.:-(

--Ben Doom

Jamie Jackson wrote:

 I just wrote a UDF to do a rereplace with manipulated backreference
 values. Specifically, it replaces all instances of email addresses in
 a string with antiSpam email addresses.
 
 However, I'm wondering if there was an easier way...
 
 Is there any magic shortcut, similar to this (illegal) pseudo-code?
 (i.e. Is there a way to manipulate the backreferenced value within the
 rereplace function?)
 
 rereplace(str,
([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
emailAntiSpam(\1),
all);
 
 Thanks,
 Jamie
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: XML Storage

2004-02-05 Thread Massimo, Tiziana e Federica

 I looked this over. It's interesting. How difficult would this be to
 integrate into CF? It looks like a pretty involved API.

Good question... I don't have the answer :-)
Not yet at least, it's something I would love to try but it's definitely low
priority


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Linux ODBC Socket

2004-02-05 Thread Robert Shaw

Hi,
My colleague and I are new to Linux and notice there is no ODBC Socket 
option in the datasources page, is this a feature of MX? If so, can I 
create ODBC datasources some other way in ColdFusion MX on Linux (RedHat).

TIA,
Robbie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Different query results in Access/ColdFusion

2004-02-05 Thread Christina Robson

Hi there,

I'm about to pull my hair out over this problem, so I'm really hoping someone can shed some light on the situation.

I have a query (written in SQL) in my CF code that connects to an Access database.The user enters a street name, and the SQL query pulls out all the addresses containing that street name.

Sounds simple enough, right?

When I copy the SQL into the Access query designer, it gives me the correct results - it finds all the addresses with that street name.But when I embed that exact same SQL statement into my CF page, it doesn't give me the right results.

And here's the kicker - depending on what field I sort on, I get a different number of results!!!And the number varies depending on which street name I'm searching for!For a certain street name, I might get all the results when I search by Date, but only a few when I search by something else.But that could be different for other stret names.

It's really the weirdest thing, and I have NO IDEA how to go about fixing the problem.

Anybody have any ideas??

Thanks!
Christina
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

jRockit

2004-02-05 Thread Michael Wolfe

Hi All,

 
A few days ago, someone quoted Charlie Arehart regarding CFMXoptimization
tips.One of the things that was mentioned was that you should replace the
Sun JRE with jRockit.I did some research and learned that jRockit is
distributed by BEA (for free).

 
Can anyone tell me more about jRockit?Why is it better than the Sun JRE?
Is it fully compatible with the Sun version? Is it fully compatible with
CFMX?

 
Charlie, are you out there?

 
Thanks,

 --

Michael Wolfe
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Different query results in Access/ColdFusion

2004-02-05 Thread Bryan Stevenson

Post the code ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Christina Robson 
To: CF-Talk 
Sent: Thursday, February 05, 2004 10:38 AM
Subject: Different query results in Access/ColdFusion

Hi there,

I'm about to pull my hair out over this problem, so I'm really hoping someone can shed some light on the situation.

I have a query (written in SQL) in my CF code that connects to an Access database.The user enters a street name, and the SQL query pulls out all the addresses containing that street name.

Sounds simple enough, right?

When I copy the SQL into the Access query designer, it gives me the correct results - it finds all the addresses with that street name.But when I embed that exact same SQL statement into my CF page, it doesn't give me the right results.

And here's the kicker - depending on what field I sort on, I get a different number of results!!!And the number varies depending on which street name I'm searching for!For a certain street name, I might get all the results when I search by Date, but only a few when I search by something else.But that could be different for other stret names.

It's really the weirdest thing, and I have NO IDEA how to go about fixing the problem.

Anybody have any ideas??

Thanks!
Christina
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Linux ODBC Socket

2004-02-05 Thread Ben Densmore

Yes that is built into MX. It's so you can create an ODBC connection via
the ODBC control panel, then you use the ODBC Socket option and tell it
the name of the DSN you created in the ODBC Control Panel. It's used
when there is a Database that CF doesn't have a driver for. I am
currently using it for a Progress Database we have. 

Ben

-Original Message-
From: Robert Shaw [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 2:31 PM
To: CF-Talk
Subject: Linux  ODBC Socket

Hi,
My colleague and I are new to Linux and notice there is no ODBC Socket 
option in the datasources page, is this a feature of MX? If so, can I 
create ODBC datasources some other way in ColdFusion MX on Linux
(RedHat).

TIA,
Robbie

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Different query results in Access/ColdFusion

2004-02-05 Thread Christina Robson

Good idea, Bryan. :)Ok, here's my SQL statement!This gives me different results depending on what I sort on.I've yet to find a way to ensure it always gives me the right results, regardless of how I sort it. Argh. :)

Thanks!
Christina

cfquery name=getpropinfo datasource=#application.dns_name2# dbtype=ODBC

SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID) 
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
WHERE CivicAddressStreet LIKE '%#Form.civicaddress#%'
AND Municipality = '#Form.municipality#'
AND DocType = 'CONVEYANCE'
ORDER BY CivicAddressNumber asc

/cfquery

--
 Post the code ;-)
 
 Bryan Stevenson B.Comm.


 - Original Message - 
 From: Christina Robson 
 To: CF-Talk 
 Sent: Thursday, February 05, 2004 10:38 AM
 Subject: Different query results in Access/ColdFusion
 
 Hi there,
 
 I'm about to pull my hair out over this problem, so I'm really hoping 
 someone can shed some light on the situation.
 
 I have a query (written in SQL) in my CF code that connects to an 
 Access database.The user enters a street name, and the SQL query 
 pulls out all the addresses containing that street name.
 
 Sounds simple enough, right?
 
 When I copy the SQL into the Access query designer, it gives me the 
 correct results - it finds all the addresses with that street name.
 But when I embed that exact same SQL statement into my CF page, it 
 doesn't give me the right results.
 
 And here's the kicker - depending on what field I sort on, I get a 
 different number of results!!!And the number varies depending on 
 which street name I'm searching for!For a certain street name, I 
 might get all the results when I search by Date, but only a few when I 
 search by something else.But that could be different for other stret 
 names.
 
 It's really the weirdest thing, and I have NO IDEA how to go about 
 fixing the problem.
 
 Anybody have any ideas??
 
 Thanks!
 Christina
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Different query results in Access/ColdFusion

2004-02-05 Thread Christina Robson

Good idea, Bryan. :)Ok, here's my SQL statement!This gives me different results depending on what I sort on.I've yet to find a way to ensure it always gives me the right results, regardless of how I sort it. Argh. :)

Thanks!
Christina

cfquery name=getpropinfo datasource=#application.dns_name2# dbtype=ODBC

SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID) 
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
WHERE CivicAddressStreet LIKE '%#Form.civicaddress#%'
AND Municipality = '#Form.municipality#'
AND DocType = 'CONVEYANCE'
ORDER BY CivicAddressNumber asc

/cfquery
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Why can't CF see my mapped or subst'ed drives!?

2004-02-05 Thread Ian Skinner

First place to always check is that the Cold Fusion server user has access to the mapped drive, not just your personal user account on the box.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: Jon Block, College Publisher Developer [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 10:51 AM
To: CF-Talk
Subject: Why can't CF see my mapped or subst'ed drives!?

Umm... I have a problem... I have a virtual drive that I call S:\. I've
tried setting it is a mapped drive and also set it as a virtual drive with
the subst utility. (I'm on windows xp pro). Anyway, from within my CF page,
when I do a directory exists on it, it doesn't see it... look

directoryExists(S:\) = NO

How do I get this to work? On my old windows 2000 server, this same script
worked fine. They just bought me a new machine running xp pro and these damn
virtual drives are 'driving' me crazy. My scripts need to be able to see
them.

(I'm running ColdFusion v5 and Windows XP Pro I know I know.. I'll be
using CFMX soon but I'm not quite there yet)

Please help!
Jon 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: jRockit

2004-02-05 Thread Nathan C. Smith

fully compatible is a dangerous term.

 
I think JRockit meets the compatibility tests.There are many alternatives
to SUN that claim to be faster.The MS engine was supposed to be very fast.

 
I think the thing to remember is that when something appears broken, you
need to switch back to the Macromedia-provided JVM and test before you
declare something is broken or buggy.

-Original Message-
From: Michael Wolfe [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 1:36 PM
To: CF-Talk
Subject: jRockit

Hi All,

A few days ago, someone quoted Charlie Arehart regarding CFMXoptimization
tips.One of the things that was mentioned was that you should replace the
Sun JRE with jRockit.I did some research and learned that jRockit is
distributed by BEA (for free).

Can anyone tell me more about jRockit?Why is it better than the Sun JRE?
Is it fully compatible with the Sun version? Is it fully compatible with
CFMX?

Charlie, are you out there?

Thanks,

--

Michael Wolfe
[EMAIL PROTECTED] 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Why can't CF see my mapped or subst'ed drives!?

2004-02-05 Thread Won Lee

At 01:51 PM 2/5/2004 -0500, you wrote:
Umm... I have a problem... I have a virtual drive that I call S:\. I've
tried setting it is a mapped drive and also set it as a virtual drive with
the subst utility. (I'm on windows xp pro). Anyway, from within my CF page,
when I do a directory exists on it, it doesn't see it... look

I don't have the answer but the first thing I would check is too see under 
what account CF runs under in services and what accounts are allowed 
permission to your S:\ drive.

Won
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

XML storage

2004-02-05 Thread Matt Liotta

I would normally responsd to specific messages, but I am away from my 
email client. However, I wanted to address the question in regard to XML 
storage as well as the responses.

First, storing XML in an RDBMS is not a good idea. See my article on the 
subject at http://builder.com.com/5100-6388-1051795.html.

Next, if you are interested in storing XML in a native XML database then 
do take a look at Apache Xindice. See my article on the subject at 
http://www.devx.com/xml/article/9796. The Java code used in the article 
was written in a way to be used easily from CFML. I even created a CFC 
wrapper for it, but I seem to have lost it somewhere along the way. 
Although, I do remember sharing it with a list at some point so an archive 
may very well have it.

Finally, you should also be aware of a project I am participating in named 
Tahoe at http://sourceforge.net/projects/tahoe. I am currently work on 
adding support for LDAP, which is often a better place to store XML then 
an RDBMS because of its hierarchical query engine.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: XML storage

2004-02-05 Thread Tom Kitta

Matt, I have checked all of your links and none of them lead to articles you
mentioned.

TK
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 4:02 PM
To: CF-Talk
Subject: XML storage

I would normally responsd to specific messages, but I am away from my
email client. However, I wanted to address the question in regard to XML
storage as well as the responses.

First, storing XML in an RDBMS is not a good idea. See my article on the
subject at http://builder.com.com/5100-6388-1051795.html.

Next, if you are interested in storing XML in a native XML database then
do take a look at Apache Xindice. See my article on the subject at
http://www.devx.com/xml/article/9796. The Java code used in the article
was written in a way to be used easily from CFML. I even created a CFC
wrapper for it, but I seem to have lost it somewhere along the way.
Although, I do remember sharing it with a list at some point so an archive
may very well have it.

Finally, you should also be aware of a project I am participating in named
Tahoe at http://sourceforge.net/projects/tahoe. I am currently work on
adding support for LDAP, which is often a better place to store XML then
an RDBMS because of its hierarchical query engine.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Need some Flash MX Book recommendations

2004-02-05 Thread Chris Alvarado

Sorry for the Crosspost

 


 
Hello all,

I'm starting a project that will require some pretty heavy DB interation
from Flash as well as some of the more advanced stuff in FlashMX
(remoting, pushing content etc). I need books that assume you know
little to no Flash. Ive been programming Cold Fusion for nearly 7 years
now so i think it's safe to say that i have a fairly strong grasp on
that side of things.

any and all help is greatly appreciated.

Thanks all,

-chris.alvarado 
[ application developer ] 
4 Guys Interactive, Inc. 
http://www.4guys.com http://www.4guys.com/
phone: 281.807.4344 x1716 
fax: 281.807.4384
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Different query results in Access/ColdFusion

2004-02-05 Thread Suyer, Ed

Run this query, first in cf, then in native Access:

cfquery name=getpropinfo datasource=#application.dns_name2#
dbtype=ODBC
SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID) 
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
ORDER BY CivicAddressNumber asc
/cfquery

If this give you different results in cf v Access, your
application.dns_name2 is set to the wrong DSN

Otherwise, your problem is in your form variables.Try outputting them to
see what they actually look like.Perhaps they are encoded.

HTH
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Serial Number

2004-02-05 Thread kelly

How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: REReplace: Manipulating Backreferences

2004-02-05 Thread Taco Fleur

Yeah you can use back references, it would be something like the following
Pseudo code:
your spam email = taco at coldfusionist.com

 
find (\.*)\sat\s(\.*)
replace with [EMAIL PROTECTED]

 
The regex needs adjustment, but it displays how the back references could do
the trick

Taco Fleur
Bloghttp://www.tacofleur.com/index/blog/
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/

Tell me and I will forget
Show me and I will remember
Teach me and I will learn 

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Friday, 6 February 2004 4:32 AM
To: CF-Talk
Subject: REReplace: Manipulating Backreferences

I just wrote a UDF to do a rereplace with manipulated backreference
values. Specifically, it replaces all instances of email addresses in
a string with antiSpam email addresses.

However, I'm wondering if there was an easier way...

Is there any magic shortcut, similar to this (illegal) pseudo-code?
(i.e. Is there a way to manipulate the backreferenced value within the
rereplace function?)

rereplace(str,
 ([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
 emailAntiSpam(\1),
 all);

Thanks,
Jamie 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Linux ODBC Socket

2004-02-05 Thread Robert Shaw

Thanks Ben. We don't see this as a datasource type on Linux, is it a Windows 
only option? If so, is there a way to create an ODBC datasource in the CFMX 
Admin on Linux?

Robbie

-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 2:46 PM
To: CF-Talk
Subject: RE: Linux  ODBC Socket

Yes that is built into MX. It's so you can create an ODBC connection via
the ODBC control panel, then you use the ODBC Socket option and tell it
the name of the DSN you created in the ODBC Control Panel. It's used
when there is a Database that CF doesn't have a driver for. I am
currently using it for a Progress Database we have.

Ben

-Original Message-
From: Robert Shaw [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 2:31 PM
To: CF-Talk
Subject: Linux  ODBC Socket

Hi,
My colleague and I are new to Linux and notice there is no ODBC Socket 
option in the datasources page, is this a feature of MX? If so, can I 
create ODBC datasources some other way in ColdFusion MX on Linux (RedHat).

TIA,
Robbie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Fusetalk Q

2004-02-05 Thread Michael Dinowitz

I'm thinking about hacking together an email to/from for Fusetalk and was
wondering something. Is there a page in it to get a single message rather
than a full thread? For example, this url gives an entire thread:
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2threadid=
767784
I'd like something like:
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2messageid
=2763969

Anyone have a clue on this? If not, I'll have to parse each thread out into
it's individual messages which'll be a pain.
Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Serial Number

2004-02-05 Thread Ben Forta

Use the following regular _expression_:
\w{3}\d{7}

--- Ben

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:08 PM
To: CF-Talk
Subject: Serial Number

How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks! 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

A regular _expression_ is the obvious solution to me.Assuming that there 
are only 10 digits:

[a-z0-9]{3}[0-9]{7}

Would match (lowercase only, so use a re***nocase() call).

If you need more help than that, just ask.Please be specific about CF 
version, number of characters in the serial, and anything else you think 
might be relevant.

--Ben Doom

[EMAIL PROTECTED] wrote:

 How would I check to see if the first three digits of a number are
 alpha-numeric and the last 7 are numbers?
 
 Thanks!

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Commercial Real Estate Application

2004-02-05 Thread Stan Winchester

Does anyone know of a good open source Commercial Real Estate Application
that will run on CF5?

Thank you,
Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Another CFLogin issue - Roles

2004-02-05 Thread Raymond Camden

Eh? Code inside cflogin blocks will NOT run if you are logged in. Do you
have a firm example that dispproves this? If so please share as it would be
a bug.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

refind(^[a-zA-Z0-9]{3}.*[0-9]{7}$, str)

On Thu, 5 Feb 2004 12:08:26 -0800 (PST), in cf-talk you wrote:

How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks!



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Fusetalk Q

Doesn't the MM forum use FuseTalk?Sure looks like the URLs on the fusebox
forum, and I know that one is FuseTalk.

Cheers,
barneyb 

 -Original Message-
 From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 12:15 PM
 To: CF-Talk
 Subject: Fusetalk Q

 I'm thinking about hacking together an email to/from for 
 Fusetalk and was
 wondering something. Is there a page in it to get a single 
 message rather
 than a full thread? For example, this url gives an entire thread:
 http://webforums.macromedia.com/coldfusion/messageview.cfm?cat
 id=2threadid=
 767784
 I'd like something like:
 http://webforums.macromedia.com/coldfusion/messageview.cfm?cat
 id=2messageid
 =2763969

 Anyone have a clue on this? If not, I'll have to parse each 
 thread out into
 it's individual messages which'll be a pain.
 Thanks

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: RE: XML storage

2004-02-05 Thread ksuh

Remove the periods at the end of the links.

- Original Message -
From: Tom Kitta [EMAIL PROTECTED]
Date: Thursday, February 5, 2004 1:01 pm
Subject: RE: XML storage

 Matt, I have checked all of your links and none of them lead to 
 articles you
 mentioned.

 TK
-Original Message-
From: Matt Liotta [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 4:02 PM
To: CF-Talk
Subject: XML storage

I would normally responsd to specific messages, but I am away 
 from my
email client. However, I wanted to address the question in 
 regard to XML
storage as well as the responses.

First, storing XML in an RDBMS is not a good idea. See my 
 article on the
subject at http://builder.com.com/5100-6388-1051795.html.

Next, if you are interested in storing XML in a native XML 
 database then
do take a look at Apache Xindice. See my article on the subject at
http://www.devx.com/xml/article/9796. The Java code used in the 
 articlewas written in a way to be used easily from CFML. I even 
 created a CFC
wrapper for it, but I seem to have lost it somewhere along the way.
Although, I do remember sharing it with a list at some point so 
 an archive
may very well have it.

Finally, you should also be aware of a project I am 
 participating in named
Tahoe at http://sourceforge.net/projects/tahoe. I am currently 
 work on
adding support for LDAP, which is often a better place to store 
 XML then
an RDBMS because of its hierarchical query engine.

-Matt

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:CFHeader/CFContent woes.

2004-02-05 Thread Mary Jo Sminkey

Just a guess, but how about comparing the IIS config between the 2 
servers? Maybe the MIME Map File Types might have different settings. 
Not sure if that has anything to do with it, but I would think something 
has to be different in the IIS config between the 2 boxes.

Yup, that was one of the first things I checked. I agree, there must be *something* different between the two servers, but darned if I can figure it out! 


Mary Jo Sminkey
[EMAIL PROTECTED]
http://www.cfwebstore.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:CFHeader/CFContent woes.

2004-02-05 Thread Mary Jo Sminkey

 cfheader name=Content-type value=application/octet-stream

 cfheader name=Content-Disposition value='attachment; 
 filename=#FileName#'

Thanks so much Bryan, this finally did the trick! Works perfect now. Of course, I still don't know why the normal tags that worked on development were a problem. ;-) 


Mary Jo Sminkey
[EMAIL PROTECTED]
http://www.cfwebstore.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: XML storage

2004-02-05 Thread Jochem van Dieten

Matt Liotta wrote:

 I would normally responsd to specific messages, but I am away from my 
 email client. However, I wanted to address the question in regard to XML 
 storage as well as the responses.
 
 First, storing XML in an RDBMS is not a good idea. See my article on the 
 subject at http://builder.com.com/5100-6388-1051795.html.

 From that article:
The two most common solutions for storing XML in an RDBMS, 
mapping the schema to database rows and storing the entire 
document as a single character large object (CLOB) field, both 
present limitations. In the mapping method, the database has no 
awareness of the datas context or hierarchy. Parts of the XML 
document are spread around the database and physically occupy 
different parts of the server. As a result, any SQL queries 
involve a time-consuming search for and reconstruction of the 
parts. The CLOB method, on the other hand, avoids these context 
issues. Instead of mapping schema to rows, the database preserves 
the data context and hierarchy in one unit. However, a SQL query 
cannot look inside the field holding the document and interpret 
itthe only way to examine parts of a document is to return the 
whole thing in a result set.

I haven't laid hands on the final version yet, but drafts of the 
SQL-2003 standard section 14 defined an XML datatype which 
maintained the internal structure of the XML document. That means 
you can XQuery it. And there are several implementations of such 
functionality in databases.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: jRockit

2004-02-05 Thread Paul Kenney

I tried Jrockit once, and the switch was a little confusing--but that had
more to do with switching JREs in general.In talking to some people at
MAX, I heard that Jrocket is faster, but also more unstable(it crashes
faster).I personally don't know and could just be perpetuating a rumor or
severe bias...Oh well.I guess you might just want to try it out yourself
to see if it improves the performance of your own site.In the end, that's
all that counts.

Paul Kenney
WebMaster, CorporateWarriors.com
916-663-1963

-Original Message-
From: Nathan C. Smith [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 11:52 AM
To: CF-Talk
Subject: RE: jRockit

fully compatible is a dangerous term.

 
I think JRockit meets the compatibility tests.There are many alternatives
to SUN that claim to be faster.The MS engine was supposed to be very fast.

 
I think the thing to remember is that when something appears broken, you
need to switch back to the Macromedia-provided JVM and test before you
declare something is broken or buggy.

-Original Message-
From: Michael Wolfe [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 1:36 PM
To: CF-Talk
Subject: jRockit

Hi All,

A few days ago, someone quoted Charlie Arehart regarding CFMXoptimization
tips.One of the things that was mentioned was that you should replace the
Sun JRE with jRockit.I did some research and learned that jRockit is
distributed by BEA (for free).

Can anyone tell me more about jRockit?Why is it better than the Sun JRE?
Is it fully compatible with the Sun version? Is it fully compatible with
CFMX?

Charlie, are you out there?

Thanks,

--

Michael Wolfe
[EMAIL PROTECTED] 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

storing cart info - struct vs. db

2004-02-05 Thread Jim

I've got a shopping cart I've been working on.

It's big mess of nested structures and arrays. Right now it is a
structure with each key representing a ship to address. For each
address there is an array which contains a structure containing
Product ID and Qty.

As I build the public display interface I'm wondering
what would be better for performance.

Put everything I need (Product number, description, price, sale price,
etc.) in the initial structure or should I just put the minimum info
(product ID and qty) in the structure and hit the db when I need more
info.

Opinions? :)

jim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: jRockit

I've talked to one of the CFMX engineers about using jRockit with CFMX 6.1
and he said that they did extensive testing and found that it was faster in
most situations but developed stability problems and random error messages
when put under heavy load.

HTH,

Sam

--
Blog:http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
-Original Message-
From: Michael Wolfe [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 2:36 PM
To: CF-Talk
Subject: jRockit

Hi All,

A few days ago, someone quoted Charlie Arehart regarding CFMXoptimization
tips.One of the things that was mentioned was that you should replace the
Sun JRE with jRockit.I did some research and learned that jRockit is
distributed by BEA (for free).

Can anyone tell me more about jRockit?Why is it better than the Sun JRE?
Is it fully compatible with the Sun version? Is it fully compatible with
CFMX?

Charlie, are you out there?

Thanks,

--

Michael Wolfe
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Spell Check custom tag needed

we use cfdev's tag and love it.Nice interface and really easy to set up.
Well worth the cost.

Sam

--
Blog:http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--

-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 1:48 PM
To: CF-Talk
Subject: Re: Spell Check custom tag needed

Ketan Patel wrote:

 Hi All,
 Does anybody in the forums know about freebee spell check custom tag
 or CFX
 tag.

Not a freebie, but we make one: http://www.cfdev.com/spellcheck/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: REReplace: Manipulating Backreferences

That's not quite what I've got going on. Notice that while you used
backreferences, you didn't *process* them at all. (Maybe that's how I
should have phrased it: Is it possible to *process* backreferences
within REReplace?)

Please remember that AFAIK, what I'm asking about is impossible, but I
was just making sure. Also, please note that I don't need help getting
this to work in another way (i.e. with a loop), as I have already made
a UDF that does it the hard way.

cfsavecontent variable=myString
[EMAIL PROTECTED] hello [EMAIL PROTECTED] goodbye
/cfsavecontent
cfscript
// keep in mind that this is just illegal pseudocode
myString = rereplace(str,
 ([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
 emailAntiSpam(\1),
 all);
/cfscript
cfoutput
#myString#
/cfoutput

### DESIRED YIELD ###
#102;#111;o#64;#98;a#114;#46;c#111;#109; hello
#106;#105;m#64;#106;a#109;#46;c#111;#109; goodbye

Thanks,
Jamie

On Fri, 6 Feb 2004 06:11:30 +1000, in cf-talk you wrote:

Yeah you can use back references, it would be something like the following
Pseudo code:
your spam email = taco at coldfusionist.com
 
find (\.*)\sat\s(\.*)
replace with [EMAIL PROTECTED]
 
The regex needs adjustment, but it displays how the back references could do
the trick
 
 
Taco Fleur
Bloghttp://www.tacofleur.com/index/blog/
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/

Tell me and I will forget
Show me and I will remember
Teach me and I will learn 

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Friday, 6 February 2004 4:32 AM
To: CF-Talk
Subject: REReplace: Manipulating Backreferences


I just wrote a UDF to do a rereplace with manipulated backreference
values. Specifically, it replaces all instances of email addresses in
a string with antiSpam email addresses.

However, I'm wondering if there was an easier way...

Is there any magic shortcut, similar to this (illegal) pseudo-code?
(i.e. Is there a way to manipulate the backreferenced value within the
rereplace function?)

rereplace(str,
 ([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
 emailAntiSpam(\1),
 all);

Thanks,
Jamie 
_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

I've seen this notation popping up recently:

\w
\d

I see the following in the documentation
(http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt269.htm#522),
but where are the rest of them?

New in ColdFusion MX: this function supports the following special
codes in a substring, to control case conversion: 
\u - uppercase the next character 
\l - lowercase the next character
\U - uppercase until \E 
\L - lowercase until \E 
\E - end \U or \L

Thanks,
Jamie

On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:

Use the following regular _expression_:
\w{3}\d{7}
 
--- Ben
 
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:08 PM
To: CF-Talk
Subject: Serial Number


How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks! 
_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Fusetalk Q

I just confered with another team mm member that has develoepd with fusetalk
and reviewed the source code (it's available for additional price).He says
their only message view is full thread.

Sam

--
Blog:http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:15 PM
To: CF-Talk
Subject: Fusetalk Q

I'm thinking about hacking together an email to/from for Fusetalk and was
wondering something. Is there a page in it to get a single message rather
than a full thread? For example, this url gives an entire thread:
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2threadid=
767784
I'd like something like:
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2messageid
=2763969

Anyone have a clue on this? If not, I'll have to parse each thread out into
it's individual messages which'll be a pain.
Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: REReplace: Manipulating Backreferences

You are exactly correct, the replace string is processed for all CF content
BEFORE it is passed to the actual REreplace function.So there's no way to
do anything with the stuff the backreference matches except stick it in the
replace string somewhere.

Cheers,
barneyb

 -Original Message-
 From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 12:43 PM
 To: CF-Talk
 Subject: Re: REReplace: Manipulating Backreferences
 
 That's not quite what I've got going on. Notice that while you used
 backreferences, you didn't *process* them at all. (Maybe that's how I
 should have phrased it: Is it possible to *process* backreferences
 within REReplace?)
 
 Please remember that AFAIK, what I'm asking about is impossible, but I
 was just making sure. Also, please note that I don't need help getting
 this to work in another way (i.e. with a loop), as I have already made
 a UDF that does it the hard way.
 
 cfsavecontent variable=myString
 [EMAIL PROTECTED] hello [EMAIL PROTECTED] goodbye
 /cfsavecontent
 cfscript
 // keep in mind that this is just illegal pseudocode
 myString = rereplace(str,
([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
emailAntiSpam(\1),
all);
 /cfscript
 cfoutput
 #myString#
 /cfoutput
 
 ### DESIRED YIELD ###
 #102;#111;o#64;#98;a#114;#46;c#111;#109; hello
 #106;#105;m#64;#106;a#109;#46;c#111;#109; goodbye
 
 Thanks,
 Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Serial Number

2004-02-05 Thread Ben Forta

That are pretty standard regex metacharacters.

 
Some are here:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp12.htm

 
--- Ben

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:51 PM
To: CF-Talk
Subject: Re: Serial Number

I've seen this notation popping up recently:

\w
\d

I see the following in the documentation
(http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt
269.htm#522),
but where are the rest of them?

New in ColdFusion MX: this function supports the following special
codes in a substring, to control case conversion: 
\u - uppercase the next character 
\l - lowercase the next character
\U - uppercase until \E 
\L - lowercase until \E 
\E - end \U or \L

Thanks,
Jamie

On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:

Use the following regular _expression_:
\w{3}\d{7}
 
--- Ben
 
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:08 PM
To: CF-Talk
Subject: Serial Number


How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks! 
_


 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

Those are actually what you'd use in the replacement string.

I don't know offhand where in the CF docs you'd find information on the 
regular expressions themselves, but there are tons out there for Perlish 
REs, which are very, very similar to the REs in CF.

I know there are several tutorials floating around, and there are 
several good books on the subject.If you just want to ask a whole 
bunch of questions and learn about them that way, the CF-Regex list 
(also hosted by the fine people at House of Fusion) is a great resource. 
If it seems quiet, it's because it's mostly subscribed to by experts, 
who don't tend to ask too many questions.:-)However, they do tend to 
answer a lot of them.

Anyway, if you want more information on where to learn more about regex, 
just ask and I'd be happy to dump tons of info on you.:-)

--Ben Doom

Jamie Jackson wrote:

 I've seen this notation popping up recently:
 
 \w
 \d
 
 I see the following in the documentation
 (http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt269.htm#522),
 but where are the rest of them?
 
 New in ColdFusion MX: this function supports the following special
 codes in a substring, to control case conversion:
 \u - uppercase the next character
 \l - lowercase the next character
 \U - uppercase until \E
 \L - lowercase until \E
 \E - end \U or \L
 
 Thanks,
 Jamie
 
 On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:
 
Use the following regular _expression_:
\w{3}\d{7}

--- Ben


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:08 PM
To: CF-Talk
Subject: Serial Number


How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks!
_




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Calling Angel Stewart...

2004-02-05 Thread peter . tilbrook

Erm, I somehow deleted the announce message you sent regarding Plum.
Could you send me a copy to this email address? Thanks :)

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927


 Adam Churvis
 [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] 
 cement.comcc: 
Subject:Calling Angel Stewart...
 05/02/2004 15:26 
 Please respond to
 cf-talk|
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Serial Number

2004-02-05 Thread Ben Forta

Wow, I don't remember, but they have been supported for several versions
already.

 
RegEx support is quite similar to Perl nowadays (was not always that
way).

 
--- Ben

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 4:20 PM
To: CF-Talk
Subject: Re: Serial Number

Thanks, Ben(s)

How long have these been supported? I can't even remember how long
I've been writing out regexes long-hand in CF, thinking that the
shorthand classes weren't supported. I've known that POSIX bracket
expressions worked, but the class shorthand is (welcome) news to me.

Also, would you happen to know to which language's flavor of regex is
CF most similar?

Thanks,
Jamie
P.S. I do have the O'Reilly Regex book, so I have a reference for the
standard stuff.

On Thu, 5 Feb 2004 15:55:18 -0500, in cf-talk you wrote:

That are pretty standard regex metacharacters.
 
Some are here:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp12.htm
 
--- Ben
 
 
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:51 PM
To: CF-Talk
Subject: Re: Serial Number


I've seen this notation popping up recently:

\w
\d

I see the following in the documentation
(http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-p
t
269.htm#522),
but where are the rest of them?

New in ColdFusion MX: this function supports the following special
codes in a substring, to control case conversion: 
\u - uppercase the next character 
\l - lowercase the next character
\U - uppercase until \E 
\L - lowercase until \E 
\E - end \U or \L

Thanks,
Jamie

On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:

Use the following regular _expression_:
\w{3}\d{7}
 
--- Ben
 
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:08 PM
To: CF-Talk
Subject: Serial Number


How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks! 
_


 
_


 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFMX performance data MMC thingy

2004-02-05 Thread Douglas.Knudsen

Running CFMX on JRun, the J2EE way, on a winblows 2000 server box.I'm trying to pull the perf data via the performances MMC snap in for CFMX and get nada.I can see ColdFusion MX Server in the Performance object dropdown and I can see the list of coubnters, but I can't choose any of them.I see the below errors in the event log too. Anyone else have this problem?Google ain't helping me today.

The Open Procedure for service ColdFusion MX Application Server in DLL C:\WINNT\system32\cfperfmon_mx.dll failed.Performance data for this service will not be available. Status codereturned is data DWORD 0. 

'The data buffer created for the ColdFusion MX Application Server 
service in the C:\WINNT\system32\cfperfmon_mx.dll library is not 
aligned on an 8-byte boundary. This may cause problems for 
applications 
that are trying to read the performance data buffer. Contact the 
manufacturer of this library or service to have this problem corrected 
or to get a newer version of this library.' 

--
Douglas Knudsen
Alltel ACI IT Rapid Response Team

ole0.bmp 

**
The information contained in this message, including attachments, may contain 
privileged or confidential information that is intended to be delivered only to the 
person identified above. If you are not the intended recipient, or the person 
responsible for delivering this message to the intended recipient, ALLTEL requests 
that you immediately notify the sender and asks that you do not read the message or its 
attachments, and that you delete them without copying or sending them to anyone else.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

Thanks, Ben(s)

How long have these been supported? I can't even remember how long
I've been writing out regexes long-hand in CF, thinking that the
shorthand classes weren't supported. I've known that POSIX bracket
expressions worked, but the class shorthand is (welcome) news to me.

Also, would you happen to know to which language's flavor of regex is
CF most similar?

Thanks,
Jamie
P.S. I do have the O'Reilly Regex book, so I have a reference for the
standard stuff.

On Thu, 5 Feb 2004 15:55:18 -0500, in cf-talk you wrote:

That are pretty standard regex metacharacters.
 
Some are here:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp12.htm
 
--- Ben
 
 
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:51 PM
To: CF-Talk
Subject: Re: Serial Number


I've seen this notation popping up recently:

\w
\d

I see the following in the documentation
(http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt
269.htm#522),
but where are the rest of them?

New in ColdFusion MX: this function supports the following special
codes in a substring, to control case conversion: 
\u - uppercase the next character 
\l - lowercase the next character
\U - uppercase until \E 
\L - lowercase until \E 
\E - end \U or \L

Thanks,
Jamie

On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:

Use the following regular _expression_:
\w{3}\d{7}
 
--- Ben
 
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 3:08 PM
To: CF-Talk
Subject: Serial Number


How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks! 
_


 
_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: REReplace: Manipulating Backreferences

Great, that's the info I needed! :D

Thanks,
Jamie

On Thu, 5 Feb 2004 12:52:54 -0800, in cf-talk you wrote:

You are exactly correct, the replace string is processed for all CF content
BEFORE it is passed to the actual REreplace function.So there's no way to
do anything with the stuff the backreference matches except stick it in the
replace string somewhere.

Cheers,
barneyb

 -Original Message-
 From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 12:43 PM
 To: CF-Talk
 Subject: Re: REReplace: Manipulating Backreferences
 
 That's not quite what I've got going on. Notice that while you used
 backreferences, you didn't *process* them at all. (Maybe that's how I
 should have phrased it: Is it possible to *process* backreferences
 within REReplace?)
 
 Please remember that AFAIK, what I'm asking about is impossible, but I
 was just making sure. Also, please note that I don't need help getting
 this to work in another way (i.e. with a loop), as I have already made
 a UDF that does it the hard way.
 
 cfsavecontent variable=myString
 [EMAIL PROTECTED] hello [EMAIL PROTECTED] goodbye
 /cfsavecontent
 cfscript
 // keep in mind that this is just illegal pseudocode
 myString = rereplace(str,
([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+,
emailAntiSpam(\1),
all);
 /cfscript
 cfoutput
 #myString#
 /cfoutput
 
 ### DESIRED YIELD ###
 #102;#111;o#64;#98;a#114;#46;c#111;#109; hello
 #106;#105;m#64;#106;a#109;#46;c#111;#109; goodbye
 
 Thanks,
 Jamie


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

 Thanks, Ben(s)

No prob.If I'm going to claim RegEx as one of my specialties, I might 
as well develop a good rep for it.:-)

 How long have these been supported? I can't even remember how long
 I've been writing out regexes long-hand in CF, thinking that the
 shorthand classes weren't supported. I've known that POSIX bracket
 expressions worked, but the class shorthand is (welcome) news to me.

Shorthand classes (as you've referred to them) have been supported since 
6.0 -- CF5 and earlier used POSIX style only.

 Also, would you happen to know to which language's flavor of regex is
 CF most similar?

MX uses the underlying Java Oro (? I can never remember that right) 
engine, so the regex is most like Java.:-)

 P.S. I do have the O'Reilly Regex book, so I have a reference for the
 standard stuff.

Since the Java engine is built to be very Perlish, look at the Perl 
regex stuff in the Mastering book for good help.There are a few things 
that Perl can/will do that CF won't (like lookbehinds) but they're 
generally not the more used features.

--Ben Doom
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Serial Number

I strongly suspect that Rereplace and Refind are thin wrappers around the
native Java RegEx stuff.I know CFMX used an external implementation (from
Apache), because it shipped with a 1.3 JRE and the RegEx stuff is in Java
1.4, but CFMX 6.1 ships with 1.4.2, so I'd be quite surprised if it didn't
use the native Java libraries. 

The actual functions it probably users are in the Matcher class, but the
syntax explaination is located here (in the Pattern class):

http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Pattern.html

Cheers,
barneyb

 -Original Message-
 From: Ben Forta [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 1:27 PM
 To: CF-Talk
 Subject: RE: Serial Number
 
 Wow, I don't remember, but they have been supported for 
 several versions
 already.

 RegEx support is quite similar to Perl nowadays (was not always that
 way).

 --- Ben



 -Original Message-
 From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 4:20 PM
 To: CF-Talk
 Subject: Re: Serial Number
 
 
 Thanks, Ben(s)
 
 How long have these been supported? I can't even remember how long
 I've been writing out regexes long-hand in CF, thinking that the
 shorthand classes weren't supported. I've known that POSIX bracket
 expressions worked, but the class shorthand is (welcome) news to me.
 
 Also, would you happen to know to which language's flavor of regex is
 CF most similar?
 
 Thanks,
 Jamie
 P.S. I do have the O'Reilly Regex book, so I have a reference for the
 standard stuff.
 
 On Thu, 5 Feb 2004 15:55:18 -0500, in cf-talk you wrote:
 
 That are pretty standard regex metacharacters.
  
 Some are here:
 http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp12.htm
  
 --- Ben
  
  
 -Original Message-
 From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 3:51 PM
 To: CF-Talk
 Subject: Re: Serial Number
 
 
 I've seen this notation popping up recently:
 
 \w
 \d
 
 I see the following in the documentation
 (http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/f
 unctions-p
 t
 269.htm#522),
 but where are the rest of them?
 
 New in ColdFusion MX: this function supports the following special
 codes in a substring, to control case conversion: 
 \u - uppercase the next character 
 \l - lowercase the next character
 \U - uppercase until \E 
 \L - lowercase until \E 
 \E - end \U or \L
 
 Thanks,
 Jamie
 
 On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:
 
 Use the following regular _expression_:
 \w{3}\d{7}
  
 --- Ben
  
  
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 3:08 PM
 To: CF-Talk
 Subject: Serial Number
 
 
 How would I check to see if the first three digits of a number are
 alpha-numeric and the last 7 are numbers?
 
 Thanks! 
 _
 
 
  
 _
 
 
  
_
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: jRockit

2004-02-05 Thread Michael Wolfe

Thanks to all of you for the info. I think I'll stick with the Sun JRE for
now.

 --

Michael Wolfe
[EMAIL PROTECTED]


_

From: Samuel Neff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 12:35 PM
To: CF-Talk
Subject: RE: jRockit

I've talked to one of the CFMX engineers about using jRockit with CFMX 6.1
and he said that they did extensive testing and found that it was faster in
most situations but developed stability problems and random error messages
when put under heavy load.

HTH,

Sam

--
Blog:http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
-Original Message-
From: Michael Wolfe [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 2:36 PM
To: CF-Talk
Subject: jRockit

Hi All,

A few days ago, someone quoted Charlie Arehart regarding CFMXoptimization
tips.One of the things that was mentioned was that you should replace the
Sun JRE with jRockit.I did some research and learned that jRockit is
distributed by BEA (for free).

Can anyone tell me more about jRockit?Why is it better than the Sun JRE?
Is it fully compatible with the Sun version? Is it fully compatible with
CFMX?

Charlie, are you out there?

Thanks,

--

Michael Wolfe 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Different query results in Access/ColdFusion

2004-02-05 Thread J E VanOver

The great Karnac predicts it will be fixed with preservesinglequotes()

Jevo

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 11:39 AM
To: CF-Talk
Subject: Re: Different query results in Access/ColdFusion

Post the code ;-)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Christina Robson
To: CF-Talk
Sent: Thursday, February 05, 2004 10:38 AM
Subject: Different query results in Access/ColdFusion

Hi there,

I'm about to pull my hair out over this problem, so I'm really hoping
someone can shed some light on the situation.

I have a query (written in SQL) in my CF code that connects to an Access
database.The user enters a street name, and the SQL query pulls out all
the addresses containing that street name.

Sounds simple enough, right?

When I copy the SQL into the Access query designer, it gives me the
correct results - it finds all the addresses with that street name.But
when I embed that exact same SQL statement into my CF page, it doesn't give
me the right results.

And here's the kicker - depending on what field I sort on, I get a
different number of results!!!And the number varies depending on which
street name I'm searching for!For a certain street name, I might get all
the results when I search by Date, but only a few when I search by something
else.But that could be different for other stret names.

It's really the weirdest thing, and I have NO IDEA how to go about fixing
the problem.

Anybody have any ideas??

Thanks!
Christina
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Serial Number

Actually, after Ben's post, an idea occurred to me, and I found the
'jakarta-oro-2.0.6.jar' file in the 6.1 'lib' directory, so it looks like
6.1 still uses the ORO implementation, not the native Java one.

Apologies for the confusion.

Cheers,
barneyb

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 1:38 PM
 To: CF-Talk
 Subject: RE: Serial Number
 
 I strongly suspect that Rereplace and Refind are thin 
 wrappers around the
 native Java RegEx stuff.I know CFMX used an external 
 implementation (from
 Apache), because it shipped with a 1.3 JRE and the RegEx 
 stuff is in Java
 1.4, but CFMX 6.1 ships with 1.4.2, so I'd be quite surprised 
 if it didn't
 use the native Java libraries. 
 
 The actual functions it probably users are in the Matcher 
 class, but the
 syntax explaination is located here (in the Pattern class):
 
 http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Pattern.html
 
 Cheers,
 barneyb
 
  -Original Message-
  From: Ben Forta [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, February 05, 2004 1:27 PM
  To: CF-Talk
  Subject: RE: Serial Number
  
  Wow, I don't remember, but they have been supported for 
  several versions
  already.
 
  RegEx support is quite similar to Perl nowadays (was not always that
  way).
 
  --- Ben
 
 
 
  -Original Message-
  From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, February 05, 2004 4:20 PM
  To: CF-Talk
  Subject: Re: Serial Number
  
  
  Thanks, Ben(s)
  
  How long have these been supported? I can't even remember how long
  I've been writing out regexes long-hand in CF, thinking that the
  shorthand classes weren't supported. I've known that POSIX bracket
  expressions worked, but the class shorthand is (welcome) news to me.
  
  Also, would you happen to know to which language's flavor 
 of regex is
  CF most similar?
  
  Thanks,
  Jamie
  P.S. I do have the O'Reilly Regex book, so I have a 
 reference for the
  standard stuff.
  
  On Thu, 5 Feb 2004 15:55:18 -0500, in cf-talk you wrote:
  
  That are pretty standard regex metacharacters.
   
  Some are here:
  http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp12.htm
   
  --- Ben
   
   
  -Original Message-
  From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, February 05, 2004 3:51 PM
  To: CF-Talk
  Subject: Re: Serial Number
  
  
  I've seen this notation popping up recently:
  
  \w
  \d
  
  I see the following in the documentation
  (http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/f
  unctions-p
  t
  269.htm#522),
  but where are the rest of them?
  
  New in ColdFusion MX: this function supports the following special
  codes in a substring, to control case conversion: 
  \u - uppercase the next character 
  \l - lowercase the next character
  \U - uppercase until \E 
  \L - lowercase until \E 
  \E - end \U or \L
  
  Thanks,
  Jamie
  
  On Thu, 5 Feb 2004 15:16:56 -0500, in cf-talk you wrote:
  
  Use the following regular _expression_:
  \w{3}\d{7}
   
  --- Ben
   
   
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, February 05, 2004 3:08 PM
  To: CF-Talk
  Subject: Serial Number
  
  
  How would I check to see if the first three digits of a number are
  alpha-numeric and the last 7 are numbers?
  
  Thanks! 
  _
  
  
   
  _
  
  
   
 _
  
  
  

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Different query results in Access/ColdFusion

2004-02-05 Thread J E VanOver

For ANY character data, you must either use CFQUERYPARAM or
preservesinglequotes() or you are BEGGING for trouble.

SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
WHERE CivicAddressStreet LIKE '%#preservesinglequotes(Form.civicaddress)#%'
AND Municipality = '#preservesinglequotes(Form.municipality)#'
AND DocType = 'CONVEYANCE'
ORDER BY CivicAddressNumber asc

Or better:

SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
WHERE CivicAddressStreet LIKE cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=%#Form.civicaddress#%
AND Municipality = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#Form.municipality#
AND DocType = 'CONVEYANCE'
ORDER BY CivicAddressNumber asc

This form ALSO protects you from SQL invasion attacks --people entering
SQL commands into form fields in order to cause mischief in your databases.

Jevo

-Original Message-
From: Christina Robson [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 10:50 AM
To: CF-Talk
Subject: Re:Different query results in Access/ColdFusion

Good idea, Bryan. :)Ok, here's my SQL statement!This gives me different
results depending on what I sort on.I've yet to find a way to ensure it
always gives me the right results, regardless of how I sort it. Argh. :)

Thanks!
Christina

cfquery name=getpropinfo datasource=#application.dns_name2#
dbtype=ODBC

SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo
ON (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
WHERE CivicAddressStreet LIKE '%#Form.civicaddress#%'
AND Municipality = '#Form.municipality#'
AND DocType = 'CONVEYANCE'
ORDER BY CivicAddressNumber asc

/cfquery
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Serial Number

CFMX 6.1 still uses the Apache libraries because some of the J2EE versions
stll use a 1.3 JVM.

If you look in your lib directory you'll still see jakarta-oro-2.0.6.jar
which is the Apache Jakarta ORO RegExp library.

HTH,

Sam

--
Blog:http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 4:38 PM
To: CF-Talk
Subject: RE: Serial Number

I strongly suspect that Rereplace and Refind are thin wrappers around the
native Java RegEx stuff.I know CFMX used an external implementation (from
Apache), because it shipped with a 1.3 JRE and the RegEx stuff is in Java
1.4, but CFMX 6.1 ships with 1.4.2, so I'd be quite surprised if it didn't
use the native Java libraries.

The actual functions it probably users are in the Matcher class, but the
syntax explaination is located here (in the Pattern class):

http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Pattern.html

Cheers,
barneyb
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

2004-02-05 Thread Massimo, Tiziana e Federica

 Actually, after Ben's post, an idea occurred to me, and I found the
 'jakarta-oro-2.0.6.jar' file in the 6.1 'lib' directory, so it looks like
 6.1 still uses the ORO implementation, not the native Java one.

The day you will see CFML's RegExp start supporting lookbehind it should be
a signal they moved from ORO to java.util.regex :-)))

Anyway, I think the RegExp capabilities in CF MX are excellent, if you
really feel the urge to use java.util.regex, you can try this:

http://www.cfczone.org/cfcs/downloads/tmt_java_regexp.zip

Or roll your own UDF:

http://www.cfmentor.com/code/index.cfm?action="">


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

2004-02-05 Thread Massimo, Tiziana e Federica

 Since the Java engine is built to be very Perlish, look at the Perl
 regex stuff in the Mastering book for good help.

The last edition of the book has a dedicated section on Java RegExp

http://www.oreilly.com/catalog/regex2/

It mostly talks about java.util.regex package from Sun, but it covers ORO a
little bit too.

 There are a few things
 that Perl can/will do that CF won't (like lookbehinds) but they're
 generally not the more used features.

Yes, lookbehinds are missing from CFML, but they are available in
java.util.regex (see my other post)


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number

On Thu, 05 Feb 2004 16:35:42 -0500, in cf-talk you wrote:

No prob.If I'm going to claim RegEx as one of my specialties, I might 
as well develop a good rep for it.:-)

Okay, now you've asked for it ;-). Here's one I've wondered about for
a long time: Is there a good way to negate a _substring_ as opposed to
being specific about each individual character? Lemme think of a
(lame) example...

1. see jane
2. hear jane
3. watch jane

Is there a good way to match 1 and 2, besides doing something like
this... [^h][^e][^a][^r] jane or (see|watch) jane (say I don't
know about the words see or watch beforehand)

Shorthand classes (as you've referred to them) have been supported since 
6.0 -- CF5 and earlier used POSIX style only.

Whew, I'm fairly new to MX, so it's not like I had been missing out
since 4.5.

Since the Java engine is built to be very Perlish, look at the Perl 
regex stuff in the Mastering book for good help.

Great, will do.

If you just want to ask a whole 
bunch of questions and learn about them that way, the CF-Regex list 
(also hosted by the fine people at House of Fusion) is a great resource.

Okay, that's news to me. I read this list via NNTP, and CF-Regex
doesn't show on my groups list, so I'll definitely look into that,
too.

It's been a fruitful day on CF-Talk! :D

Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

My data is too controlled!

2004-02-05 Thread Richard Crawford

I received this error today:

Invalid data too controlled for CFSQLTYPE CF_SQL_TINYINT

...and I have no idea what it means.I did a Google web search and a 
Google groups search, but could find absolutely nothing.Does anyone 
have any ideas?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:OT- Java Web Service

2004-02-05 Thread Qasim Rasheed

Hello Pete,

Thanks for the reply. Well consider that using jws is not an option and I have to use java2wsdl tool from axis. I was thinking, is there some gui interface for generating wsdl and deplying wsdd on ant?

Regards

Qasim

Qasim Rasheed wrote:

all the java classes has been created. Now I am wondering is there a

tool available e.g. an Eclipse Plugin, which can help me generating

wsdd, wsdl etc files In other words, I am looking for a tool with
which I can run Java2WSDL. I understand that, axis has to be used
for
this purpose, but setting all those classpath etc is driving me nuts.

So any help is greatly appreciated.

Hi Qasim,

You might want to take a look at JWS files, they are basically just a
Java source file named .jws instead of .java, when a J2EE server has
jws files mapped to the correct servlet, things work just like a CFC,
you just access http://server/MyService.jws?wsdl to get the wsdl: see
my blog post on this: http://www.petefreitag.com/item/104.cfm (you can
also do this on CFMX)

There is also sample JWS files that comes in the Axis SDK.

If you want to use the Java2WSDL tool, I recommend using the Ant tasks
that come with Axis, then you just need to throw all the axis jar's in
Ant's lib directory. There is an example of using Axis' wsdl2java tool
with Ant in the web services chapter of my book as well.

__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/

[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]

Re:OT - Java Web Service

2004-02-05 Thread Qasim Rasheed

Hello Pete,

Thanks for the reply. Well consider that using jws is not an option and I have to use java2wsdl tool from axis. I was thinking, is there some gui interface for generating wsdl and deplying wsdd on ant?

Regards

Qasim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Serial Number