RE: WildCard query

2009-07-23 Thread cftalk
You can also this little gem (cfdbinfo) http://www.cfquickdocs.com/cf8/#cfdbinfo -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: July-22-09 9:23 PM To: cf-talk Subject: Re: WildCard query You can grab a list of all of the columns of any table and loop

Re: WildCard query

2009-07-23 Thread Tom Jones
. Thanks, tom On Jul 23, 2009, at 9:24 AM, cftalk wrote: You can also this little gem (cfdbinfo) http://www.cfquickdocs.com/cf8/#cfdbinfo -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: July-22-09 9:23 PM To: cf-talk Subject: Re: WildCard query You

Re: WildCard query

2009-07-23 Thread David McGuigan
/cf8/#cfdbinfo -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: July-22-09 9:23 PM To: cf-talk Subject: Re: WildCard query You can grab a list of all of the columns of any table and loop through them pretty easily ( they syntax varies

Re: WildCard query

2009-07-22 Thread David McGuigan
You can grab a list of all of the columns of any table and loop through them pretty easily ( they syntax varies with your database vendor ). MySQL is just: describe tableName On Wed, Jul 22, 2009 at 9:10 PM, Tom Jones tjo...@acworld.com wrote: Hello, I'm migrating some pages from Lasso to

Re: Wildcard characters in filepath?

2008-08-31 Thread Claude Schneegans
Is there some way I can use cfhttp to access the files listed on the web page and download them? No, in order to use CFFTP, you need some FTP account on the aimed server. I click on the link and it takes me to a page in the browser that lists the files I need. Ok, then you do have the name of

RE: Wildcard characters in filepath?

2008-08-31 Thread Rick Faircloth
Thanks for the tips, Claude! -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, August 31, 2008 9:42 AM To: CF-Talk Subject: Re: Wildcard characters in filepath? Is there some way I can use cfhttp to access the files listed on the web page

RE: Wildcard characters in filepath?

2008-08-30 Thread Dave Phillips
Have you tried: /2008_0830_??/ ? That's how you would do it at the command line in windows anyway. Dave -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 10:56 AM To: CF-Talk Subject: Wildcard characters in filepath? How can I use

Re: Wildcard characters in filepath?

2008-08-30 Thread Claude Schneegans
How can I use wildcard characters in a file path? In a file path for what ? If it is for an HTTP request, the answer is no. If it is for CFFILE, it is still no. Using wild cards could mean that several files could be returned, and both HTTP and CFFILE can deal with only one file at a time.

RE: Wildcard characters in filepath?

2008-08-30 Thread Rick Faircloth
:08 PM To: CF-Talk Subject: Re: Wildcard characters in filepath? How can I use wildcard characters in a file path? In a file path for what ? If it is for an HTTP request, the answer is no. If it is for CFFILE, it is still no. Using wild cards could mean that several files could

RE: Wildcard characters in filepath?

2008-08-30 Thread Justin D. Scott
The files would follow this format: II20080830_033219_ACR.log If you're downloading via FTP then you can get a list of the remote files, then loop through the resulting query object to look for the files you want. From the filenames it looks like you're downloading images from MLXchange. I'm

RE: Wildcard characters in filepath?

2008-08-30 Thread Rick Faircloth
Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 1:54 PM To: CF-Talk Subject: RE: Wildcard characters in filepath? The question would really just apply to files. I would be automating a daily download from a specific directory to which I have access. The files would follow

RE: Wildcard characters in filepath?

2008-08-30 Thread Rick Faircloth
wildcards at all. Thanks for the tip! Rick -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 2:04 PM To: CF-Talk Subject: RE: Wildcard characters in filepath? The files would follow this format: II20080830_033219_ACR.log If you're

Re: Wildcard characters in filepath?

2008-08-30 Thread Claude Schneegans
The question would really just apply to files. Well, it DOES depend on how you want and can finally get the file. Is the file on YOUR server, or somewhere else. Is the file accessible through HTTP, FTP ? If the file is not on your server, surely you cannot use CFdirectory. If you only have HTTP

Re: Wildcard characters in filepath?

2008-08-30 Thread Claude Schneegans
using so regExp. I mean *some* regExp. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive:

RE: Wildcard characters in filepath?

2008-08-30 Thread Rick Faircloth
, but can't. Is there some way I can use cfhttp to access the files listed on the web page and download them? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 3:56 PM To: CF-Talk Subject: Re: Wildcard characters in filepath? using so

Re: Wildcard SSL cert

2007-09-20 Thread Matthew Williams
I think he meant that pansy blue color that NC state boasts ;). What he really meant to say was Go Penn State!. Hey Rick, are you part of the CFUG in RDU? Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| Get

Re: Wildcard SSL cert

2007-09-20 Thread Rick Root
On 9/20/07, Matthew Williams [EMAIL PROTECTED] wrote: I think he meant that pansy blue color that NC state boasts ;). What he really meant to say was Go Penn State!. Hey Rick, are you part of the CFUG in RDU? It's Carolina that wears pansy blue, not NC State... NCSU is Red. Michigan plays

Re: Wildcard SSL cert

2007-09-20 Thread Matthew Williams
My apologies, there's too many teams in this state to follow. I figure that since I'm finally close to a CFUG (closest in PA was near Philly), I should get to it some time. I wanted to make the one in July but ran out of time. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog

Re: Wildcard SSL cert

2007-09-20 Thread Ben Doom
No, he used to live in Kentucky. Also, he doesn't really pay attention to sports. Maybe, someday, he will learn to stop teasing people. --Ben Doom Matthew Williams wrote: I think he meant that pansy blue color that NC state boasts ;). What he really meant to say was Go Penn State!. Hey

Re: Wildcard Certificate and CFHTTP over SSL

2007-05-16 Thread James Holmes
I tried your site and get a connection error too, However I also tried one of our sites, also using a wildcard cert (not from the same provider as yours) and that worked fine. Did you restart CF (or even all of JRun) after adding the CA cert to the keystore? On 5/16/07, Colin Jones [EMAIL

Re: Wildcard Certificate and CFHTTP over SSL

2007-05-16 Thread Colin Jones
I tried your site and get a connection error too, However I also tried one of our sites, also using a wildcard cert (not from the same provider as yours) and that worked fine. Did you restart CF (or even all of JRun) after adding the CA cert to the keystore? On 5/16/07, Colin Jones

Re: Wildcard Certificate and CFHTTP over SSL

2007-05-16 Thread Wes Middendorff
What version is your SSL. SSLv3 can produce similar results. I had a similar situation and had to create a java class and seperate keystore for SSLv3 certificates. CFHTTP does not support SSLv3 and should not work at all, but in my situation I was able to connect to a testing platform (same

RE: wildcard

2006-09-14 Thread Ben Nadel
You can form a query of queries on the directory query perhaps? cfquery name=qFileSet dbtype=query SELECT name FROM qDirList WHERE name LIKE cfqueryparam value=jsmith%.pdf / /cfquery This will get jsmith.pdf, jsmith2.pdf...

RE: wildcard

2006-09-14 Thread COLLIE David
I have pdf files in a directory that CF reads using cfdirectory. It finds the filename under the user's name such as jsmith.pdf, but at times a user may have two pdf files in the directory such as jsmith.pdf and jsmith2.pdf. How can I have it find both instances? Can I use a wildcard

RE: wildcard

2006-09-14 Thread Orlini, Robert
Thanks Collie! Got it working. -Original Message- From: COLLIE David [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 11:58 AM To: CF-Talk Subject:RE: wildcard I have pdf files in a directory that CF reads using cfdirectory. It finds the filename under

RE: wildcard

2006-09-14 Thread Orlini, Robert
Thanks Ben! Works now. Also, pointed to the wrong directory...my bad -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 11:46 AM To: CF-Talk Subject:RE: wildcard You can form a query of queries on the directory query

RE: Wildcard in statements

2003-02-21 Thread Barney Boisvert
No, not with a direct string comparison. You must make your pilgrimage to the temple of RegEx. cfif REfind(http://www\.mysite\.com/folder/.*\.cfm;, cgi.http_referer) GT 0 that should do it. barneyb -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Friday, February

RE: Wildcard in statements

2003-02-21 Thread Mark Leder
Thanks fellow pilgrim :o) Thanks, Mark -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, February 21, 2003 4:30 PM To: CF-Talk Subject: RE: Wildcard in statements No, not with a direct string comparison. You must make your pilgrimage to the temple

RE: Wildcard in statements

2003-02-21 Thread S . Isaac Dealey
No, not with a direct string comparison. You must make your pilgrimage to the temple of RegEx. cfif REfind(http://www\.mysite\.com/folder/.*\.cfm;, cgi.http_referer) GT 0 I'd add the beginning of string and end of string markers just to be thorough. cfif

RE: Wildcard in statements

2003-02-21 Thread Ben Doom
: -Original Message- : From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] : Sent: Friday, February 21, 2003 5:25 PM : To: CF-Talk : Subject: RE: Wildcard in statements : : : No, not with a direct string comparison. You must make : your pilgrimage to : the temple of RegEx. : : cfif REfind(http://www

RE: Wildcard in statements

2003-02-21 Thread S . Isaac Dealey
defeat your enemies .. er .. problems. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] : Sent: Friday, February 21, 2003 5:25 PM : To: CF-Talk : Subject: RE: Wildcard in statements

Re: Wildcard in statements

2003-02-21 Thread jonhall
Question already answered, but I don't see why the wouldn't be possible with standard string functions. Just looking at your single line of pseudo-code, it looks like you want to know if the referer is a cfm template in a certain directory. This bit of code would do that and would definitely

Re: Wildcard in statements

2003-02-21 Thread S . Isaac Dealey
There's no reason why it couldn't -- those of us familiar with regular expressions answered the question with regex immediately for 2 reasons: 1) because the way the question is phrased brings regex immediately to mind for us and 2) because to a man with a hammer, every problem looks like a nail.

RE: Wildcard in statements

2003-02-21 Thread Barney Boisvert
barneyb -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Friday, February 21, 2003 6:12 PM To: CF-Talk Subject: Re: Wildcard in statements There's no reason why it couldn't -- those of us familiar with regular expressions answered the question with regex