Re: WildCard query
Tom, in the ColdFusion code that handles the form submission, you can do something like this: describe yourTableName That query will get a list of all of the fields of your table. Then, in your search query, you can loop through them like this: select * from yourTableName where or #field# like That will search every field in your table for a match to the text field contents from the form they submitted. Good luck. On Thu, Jul 23, 2009 at 8:17 PM, Tom Jones wrote: > > Sorry, I thin I might not explained my self very well. Al though the > "cfdbinfo" looks really cool and I think I can use it in a report > generator tool I want to do, so thanks. > > So what I want is a single form field that will search the entire > table without having to specify which column. > > 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 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 wrote: > > > >> > >> Hello, > >> I'm migrating some pages from Lasso to Coldfusion and one of the > >> current pages in Lasso has a query to search any field/column for a > >> value. I have never done this with coldsuion before so I'm not sure > >> how to go about this. > >> > >> thanks, > >> tom > >> > >> > >> > >> > >> > >> > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WildCard query
Sorry, I thin I might not explained my self very well. Al though the "cfdbinfo" looks really cool and I think I can use it in a report generator tool I want to do, so thanks. So what I want is a single form field that will search the entire table without having to specify which column. 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 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 wrote: > >> >> Hello, >> I'm migrating some pages from Lasso to Coldfusion and one of the >> current pages in Lasso has a query to search any field/column for a >> value. I have never done this with coldsuion before so I'm not sure >> how to go about this. >> >> thanks, >> tom >> >> >> >> >> >> > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WildCard query
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 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 wrote: > > Hello, > I'm migrating some pages from Lasso to Coldfusion and one of the > current pages in Lasso has a query to search any field/column for a > value. I have never done this with coldsuion before so I'm not sure > how to go about this. > > thanks, > tom > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 with your database vendor ). MySQL is just: describe tableName On Wed, Jul 22, 2009 at 9:10 PM, Tom Jones wrote: > > Hello, > I'm migrating some pages from Lasso to Coldfusion and one of the > current pages in Lasso has a query to search any field/column for a > value. I have never done this with coldsuion before so I'm not sure > how to go about this. > > thanks, > tom > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard characters in filepath?
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 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 the files, and you can get them by > HTTP, not FTP. > Then you can extract the file names from the page, and get them using > CFHTTP. > Of course, extracting the file names from the page can be done for free > if you a fluent in regExp, > (this is to save Bobby some comments;-) > You can also get them more easily if RegExp is not your cup of tea using > CF_REextract, see > http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard characters in filepath?
>>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 the files, and you can get them by HTTP, not FTP. Then you can extract the file names from the page, and get them using CFHTTP. Of course, extracting the file names from the page can be done for free if you a fluent in regExp, (this is to save Bobby some comments;-) You can also get them more easily if RegExp is not your cup of tea using CF_REextract, see http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
Gotcha... I wonder if cfhttp can help with this situation. I've never used cfhttp for anything and only know what I just read in the docs, but I'm still not clear on what I can do with it. The way one of my data vendors works is like this: They send me an email every morning with a link to my directory of files for the day. I click on the link and it takes me to a page in the browser that lists the files I need. I've started using FF 3 to download the files because Windows Explorer's ftp capability just wasn't able to get the job done. I've tried getting into the site via ftp, 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 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard characters in filepath?
>>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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard characters in filepath?
>>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 access, you can only get all files names, no filter, provided the server allows directory browsing. If you have an FTP access, then you can get the list of all files, no filter either. When you have all files names, you can loop on them and find the one that meets your criterion using so 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard characters in filepath?
That's exactly what I'm doing, Justin. And I'm trying to integrate data from two different data providers with very different db schemas and will probably have to add a third provider who yet another different db schema to the mix. Trying to get all this data in every day, parse it, then get it into my local database, then uploaded to my production server is a big pain. I'm able to almost completely automate the process with one vendor, but the other one is the one that's causing all the problems and has me searching for wildcard methods, etc. You're right about the cfftp function. I do use that with one and I'm trying to get the other one to give me direct access via ftp instead of having to click links on their site to get to the data folders. If I can get direct access via ftp I can use the listdir feature of cfftp to create that list of filenames and bypass having to use 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 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 in the midst of updating all our MLS code here as well so I can feel > your pain. > > > -Justin Scott ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
I think, at least as far as remote access to ftp sites are concerned (which is part of my issue), I see in the docs that I can use "listdir" in cfftp to get the files in a directory, so that solves the download side. And I read in this blog: http://www.bennadel.com/index.cfm?dax=blog:1221.view can a pipe can be used to provide multiple filters to do this: And a ? can be used to designate single-characters wild cards. Thoughts on this? Rick > -Original Message- > From: Rick 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 this format: > > II20080830_033219_ACR.log > > Everything but the hour/minute/second part is consistent each day: > > II20080830_xx_ACR.log > > The x's are where I need variable characters since that's the exact > hour/minute/second the file is created. > > But thinking about your comments about using cfdirectory, would I be > able to access the directory the files are in each day, get a list, > and download them via ftp each day? > > Can cfdirectory read a remote directory and provide a list of files? > > I glanced around the docs and google but didn't see an answer, so thought > it'd just be quicker to ask than research all day. > > Rick > > > > > -Original Message----- > > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > > Sent: Saturday, August 30, 2008 1: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 be returned, and > > both HTTP and CFFILE can deal with only one file at a time. > > > > However, you could use CFDIRECTORY action="list" with a filter to get > > the name of the file. > > > > > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
> 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 in the midst of updating all our MLS code here as well so I can feel your pain. -Justin Scott ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 this format: II20080830_033219_ACR.log Everything but the hour/minute/second part is consistent each day: II20080830_xx_ACR.log The x's are where I need variable characters since that's the exact hour/minute/second the file is created. But thinking about your comments about using cfdirectory, would I be able to access the directory the files are in each day, get a list, and download them via ftp each day? Can cfdirectory read a remote directory and provide a list of files? I glanced around the docs and google but didn't see an answer, so thought it'd just be quicker to ask than research all day. Rick > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 30, 2008 1: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 be returned, and > both HTTP and CFFILE can deal with only one file at a time. > > However, you could use CFDIRECTORY action="list" with a filter to get > the name of the file. > > ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 be returned, and both HTTP and CFFILE can deal with only one file at a time. However, you could use CFDIRECTORY action="list" with a filter to get the name of the file. ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
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 wildcard characters in a file path? Is it possible? I have a data vendor that makes data available for download using file paths that use as part of the path, .../2008_0830_103028/ In other words the paths are auto-generated and include the year, date, hour/minute/second, in the file path. I want to just specify the year and date in the path and use .../2008_0830_xx/... so I can automate the data processing. I could use "contains", I guess, but I'd rather specify the path using variable characters. How can I do this? Rick ~| 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: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard SSL cert
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 Rick, are you part of the CFUG > in RDU? > > Matthew Williams > Geodesic GraFX > www.geodesicgrafx.com/blog > > ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Wildcard SSL cert
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 ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard SSL cert
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 Penn State this weekend. Big game for Michigan if they're to prove they're still a capable football team. Beating Notre Dame 38-0 proves nothing, since they might as well have been playing the Hicksville School for Wayward Girls. And yes, I attend some of the TACFUG meetings and some of the RDAUG meetings. -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard SSL cert
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 involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Wildcard Certificate and CFHTTP over SSL
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 cert), but not the production systems. Wes ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Wildcard Certificate and CFHTTP over SSL
> 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 PROTECTED]> wrote: > > We're running CFMX 7.0.2 (using JRun4) and have everything set up > and working with the exception that CFHTTP calls to our server, which > has a wildcard SSL certificate (*.rgu.ac.uk) are not working. > > > > My immediate suspicion is that when trying to connect to https://www. > rgu.ac.uk, CFHTTP is seeing the certificate as *.rgu.ac.uk, deciding > it is not a match for www.rgu.ac.uk and therefore rejecting the > connection. The root certifying authority has been added to trustStore, > ordinary CFHTTP connection work, as do CFHTTP to other SSL sites with > 'normal' certificates. > > -- > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com. au/blog/ Yep - we definitely have restarted the servers. I'm not so sure about my original theory now either as our test servers also use the same wildcard certificate, and they appear to be able to connect using the wildcard without a problem... :( ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard Certificate and CFHTTP over SSL
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 PROTECTED]> wrote: > We're running CFMX 7.0.2 (using JRun4) and have everything set up and working > with the exception that CFHTTP calls to our server, which has a wildcard SSL > certificate (*.rgu.ac.uk) are not working. > > My immediate suspicion is that when trying to connect to > https://www.rgu.ac.uk, CFHTTP is seeing the certificate as *.rgu.ac.uk, > deciding it is not a match for www.rgu.ac.uk and therefore rejecting the > connection. The root certifying authority has been added to trustStore, > ordinary CFHTTP connection work, as do CFHTTP to other SSL sites with > 'normal' certificates. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: wildcard
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 perhaps? SELECT name FROM qDirList WHERE name LIKE This will get jsmith.pdf, jsmith2.pdf... But will also get jsmith-big-sexy.pdf (so be carefule). Also, LIKE in query of queries IS case sensitive so careful on that to. You can do a LOWER() on the name first if you like. Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 11:41 AM To: CF-Talk Subject: wildcard 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 character such as "*"? For example: #name*# I tried this and got an error. See my code below. Thanks for any help. Robert O. HWW name: #i# no. of files: #dirlist.recordcount# #name# ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: wildcard
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 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 > character such as "*"? > > For example: > #name*# You could do it on the cfdir call IIRC http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a20.htm ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: wildcard
> 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 > character such as "*"? > > For example: > #name*# You could do it on the cfdir call IIRC http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a20.htm ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: wildcard
You can form a query of queries on the directory query perhaps? SELECT name FROM qDirList WHERE name LIKE This will get jsmith.pdf, jsmith2.pdf... But will also get jsmith-big-sexy.pdf (so be carefule). Also, LIKE in query of queries IS case sensitive so careful on that to. You can do a LOWER() on the name first if you like. ... Ben Nadel www.bennadel.com Certified Advanced ColdFusion Developer Need Help? www.bennadel.com/ask-ben/ -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 11:41 AM To: CF-Talk Subject: wildcard 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 character such as "*"? For example: #name*# I tried this and got an error. See my code below. Thanks for any help. Robert O. HWW name: #i# no. of files: #dirlist.recordcount# #name# ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard in statements
and 3) because to people who are familiar with regular expressions (and probably those not so familiar), the RE solution is MUCH more readable than the string manipulation code. IMHO, RegEx are the way to go for most solutions because you end up with cleaner code. Anything you can do with an RE can be done with 'normal' string manipulation, and the RE is probably the slower choice in a lot of situations. However, the easy-to-parse code and the ability to scale up and the problem gets more complex more than makes up for that extra 60 nanoseconds that the RE took to process. My $0.02 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 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. > :) > > > 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 > > execute faster > > than any regex... > > > > "http://www.mysite.com/folder/"; > > AND right(cgi.http_referer,4) EQ ".cfm"> > > > -- > > mailto:[EMAIL PROTECTED] > > Friday, February 21, 2003, 4:25:29 PM, you wrote: > > > ML> Can a wildcard character, such as a "*" be used > > successfully in the > > ML> following statement, or is there a better way: > > > ML> > "http://www.mysite.com/folder/*.cfm";> > > > ML> Thanks, Mark > > > ML> > > ~~ > > ~~~| > > Archives: > > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > > Subscription: http://www.houseoffusion.com/cf_lists/index. > > cfm?method=subscribe&forumid=4 > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > This list and all House of Fusion resources hosted by > > CFHosting.com. The place for dependable ColdFusion > > Hosting. > > > Unsubscribe: > http://www.houseoffusion.com/cf_lists/uns > > ubscribe.cfm?user=633.558.4 > > > > s. isaac dealey954-776-0046 > > new epoch http://www.turnkey.to > > lead architect, tapestry cms http://products.turnkey.to > > tapestry api is opensource http://www.turnkey.to/tapi > > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard in statements
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. :) > 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 > execute faster > than any regex... > "http://www.mysite.com/folder/"; > AND right(cgi.http_referer,4) EQ ".cfm"> > -- > mailto:[EMAIL PROTECTED] > Friday, February 21, 2003, 4:25:29 PM, you wrote: > ML> Can a wildcard character, such as a "*" be used > successfully in the > ML> following statement, or is there a better way: > ML> "http://www.mysite.com/folder/*.cfm";> > ML> Thanks, Mark > ML> > ~~ > ~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/cf_lists/index. > cfm?method=subscribe&forumid=4 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > This list and all House of Fusion resources hosted by > CFHosting.com. The place for dependable ColdFusion > Hosting. > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard in statements
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 execute faster than any regex... http://www.mysite.com/folder/"; AND right(cgi.http_referer,4) EQ ".cfm"> -- mailto:[EMAIL PROTECTED] Friday, February 21, 2003, 4:25:29 PM, you wrote: ML> Can a wildcard character, such as a "*" be used successfully in the ML> following statement, or is there a better way: ML> http://www.mysite.com/folder/*.cfm";> ML> Thanks, Mark ML> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard in statements
See what I mean? That was much better advice than mine. :)
( even in spite of the corny slash-dot joke ) :)
> Note that this regex lets
> http://www.mysite.com/folder/subfolder/folder3/this.is.the
> .file.cfm
> and
> http://www.mysite.com/folder/.cfm
> through.
> You may want to get even fancier and do something like
> refind("http://www\.mysite\.com/folder/[^/.]+\.cfm";,
> cgi.http_referrer)
> Heehee. Slashdot!
> And, as always, an open invitation to the Dojo, aka
> CF-RegEx:
> http://www.houseoffusion.com/cf_lists/index.cfm?method=thr
> eads&forumid=21
> where the CF Regex ninjas will be happy to help 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
> :
> :
> : > No, not with a direct string comparison. You must
> make
> : > your pilgrimage to
> : > the temple of RegEx.
> :
> : > 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.
> :
> : : REfind("^http://www\.mysite\.com/folder/.*\.cfm$",cgi.ht
> tp_referer) GT
> : 0>
> :
> : And if you find youself wanting this sort of thing
> often, subscribe to the
> : cf-regex list also @houseoffusion.com - low traffic, but
> lots of great
> : advice if you're ever stuck.
> :
> : s. isaac dealey954-776-0046
> :
> : new epoch http://www.turnkey.to
> :
> : lead architect, tapestry cms
> http://products.turnkey.to
> :
> : tapestry api is opensource
> http://www.turnkey.to/tapi
> :
> : certified advanced coldfusion 5 developer
> : http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
> :
> :
> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Signup for the Fusion Authority news alert and keep up
> with the latest news in ColdFusion and related topics.
> http://www.fusionauthority.com/signup.cfm
> Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard in statements
Note that this regex lets
http://www.mysite.com/folder/subfolder/folder3/this.is.the.file.cfm
and
http://www.mysite.com/folder/.cfm
through.
You may want to get even fancier and do something like
refind("http://www\.mysite\.com/folder/[^/.]+\.cfm";, cgi.http_referrer)
Heehee. Slashdot!
And, as always, an open invitation to the Dojo, aka CF-RegEx:
http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21
where the CF Regex ninjas will be happy to help 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
:
:
: > No, not with a direct string comparison. You must make
: > your pilgrimage to
: > the temple of RegEx.
:
: > 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.
:
: http://www\.mysite\.com/folder/.*\.cfm$",cgi.http_referer) GT
: 0>
:
: And if you find youself wanting this sort of thing often, subscribe to the
: cf-regex list also @houseoffusion.com - low traffic, but lots of great
: advice if you're ever stuck.
:
: s. isaac dealey954-776-0046
:
: new epoch http://www.turnkey.to
:
: lead architect, tapestry cms http://products.turnkey.to
:
: tapestry api is opensource http://www.turnkey.to/tapi
:
: certified advanced coldfusion 5 developer
: http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
:
:
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard in statements
> No, not with a direct string comparison. You must make > your pilgrimage to > the temple of RegEx. > 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. http://www\.mysite\.com/folder/.*\.cfm$",cgi.http_referer) GT 0> And if you find youself wanting this sort of thing often, subscribe to the cf-regex list also @houseoffusion.com - low traffic, but lots of great advice if you're ever stuck. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard in statements
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 of RegEx. 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 21, 2003 1:25 PM > To: CF-Talk > Subject: Wildcard in statements > > > Can a wildcard character, such as a "*" be used successfully in the > following statement, or is there a better way: > > http://www.mysite.com/folder/*.cfm";> > > Thanks, Mark > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard in statements
No, not with a direct string comparison. You must make your pilgrimage to the temple of RegEx. 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 21, 2003 1:25 PM > To: CF-Talk > Subject: Wildcard in statements > > > Can a wildcard character, such as a "*" be used successfully in the > following statement, or is there a better way: > > http://www.mysite.com/folder/*.cfm";> > > Thanks, Mark > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
