Re: regex in sql server...
Yes, it the same sort of thing -- a dll for SQL Server that allows regex with an extended stored procedure. I'm not sure of the specifics, but I think the "code project" ( www.codeproject.com ) is all freeware / open-source stuff... I could be wrong... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > I can't get to the link to see what you're talking about, > but if it's an > extended stored procedure that performs RegEx, we just > built a dll-based > system for SQL Server named xp_RegExLib that does just > this. Is the system > you're referring to free of charge? > Respectfully, > Adam Phillip Churvis > Advanced Intensive ColdFusion MX Training > http://www.ColdFusionTraining.com > E-mail: [EMAIL PROTECTED] > Phone: 770-446-8866 > Team Macromedia Volunteer for ColdFusion > http://www.macromedia.com/support/forums/team_macromedia/ > - Original Message - > From: "S. Isaac Dealey" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, October 05, 2002 11:18 PM > Subject: regex in sql server... >> I posted this to [EMAIL PROTECTED], but I >> thought some of the > folks >> here might be interrested in it also -- there's not much >> traffic on >> cf-regex, but you might want to subscribe to it if you >> want to comment on >> this post. >> >> I found this in a google search while trying to create a >> regex to format a >> sql script generated by enterprise manager... thought >> some of you might > find >> it interresting, possibly even useful. >> >> http://www.codeproject.com/useritems/xpRegex.asp >> >> Looks really nice -- if only I could take advantage of it >> ... The big >> problem with it ( at least for me ) is a matter of people >> with shared >> hosting not being able to get dll's and the like >> installed on the sql >> server. >> >> Isaac Dealey >> Certified Advanced ColdFusion 5 Developer >> >> new epoch >> www.turnkey.to >> 954-776-0046 >> >> > ~~ > ~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/index.cfm?sideb > ar=lists&body=lists/cf_talk > 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 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: regex in sql server...
I can't get to the link to see what you're talking about, but if it's an extended stored procedure that performs RegEx, we just built a dll-based system for SQL Server named xp_RegExLib that does just this. Is the system you're referring to free of charge? Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ - Original Message - From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, October 05, 2002 11:18 PM Subject: regex in sql server... > I posted this to [EMAIL PROTECTED], but I thought some of the folks > here might be interrested in it also -- there's not much traffic on > cf-regex, but you might want to subscribe to it if you want to comment on > this post. > > I found this in a google search while trying to create a regex to format a > sql script generated by enterprise manager... thought some of you might find > it interresting, possibly even useful. > > http://www.codeproject.com/useritems/xpRegex.asp > > Looks really nice -- if only I could take advantage of it ... The big > problem with it ( at least for me ) is a matter of people with shared > hosting not being able to get dll's and the like installed on the sql > server. > > Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > new epoch > www.turnkey.to > 954-776-0046 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
RE: Reverse PDF tools
I did some research on it once and found these. I haven't used any of the products. http://www.iceni.com/frescoSet.html http://www.iceni.com/argusSet.html http://www.iceni.com/soloSet.html http://www.research.compaq.com/SRC/virtualpaper/pstotext.html http://www.imagesolutions.com/ http://www.bcl-computers.com/products/products.htm http://www.convertzone.com/pdf2txt/ http://www.palmtop.net/super6.html http://www.pdftoall.com/ Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:44 AM To: CF-Talk Subject: Reverse PDF tools Ok... I know I can take HTML or other doc formats and automate the process of converting them into PDF format. Does anyone know of a tool that can do the reverse? I need to unpack a PDF page into source images and text. Anyone? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX and Javamail
It looks like you can just upgrade the JavaMail portion to 1.3... Try it and tell us what happened :) > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Saturday, October 05, 2002 7:29 PM > To: CF-Talk > Subject: Re: MX and Javamail > > > To answer my own question... A quick scan of the J2EE 1.3 specs shows > that Javamail 1.2 is required of a web implementation of J2EE. > So, MX uses Javamail 1.2. > > The J2EE 1.4 Proposed Final Draft does require 1.3 though, so > hopefully in the next version of MX, I'll be able to get rid of my > hokey regex and use Javamail to validate email addresses. > > -- > jon > mailto:[EMAIL PROTECTED] > > Friday, October 4, 2002, 7:14:45 PM, you wrote: > > ksc> Ahh, I see. Not sure if MX uses JavaMail, or just uses > JRun's implementation of the j2ee spec. > > ksc> - Original Message - > ksc> From: jon hall <[EMAIL PROTECTED]> > ksc> Date: Friday, October 4, 2002 5:11 pm > ksc> Subject: Re: MX and Javamail > > >> > http://java.sun.com/products/javamail/1.3/docs/javadocs/javax/mail /internet/InternetAddress.html#validate() >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
RE: Fastest way to convert a csv file to cf array/query?
This might be a long shot but if Text is the actual name of your datasource you might try to name it something else. Text MIGHT be a reserved word and somehow messing the whole thing up. HTH Stephen -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 8:07 PM To: CF-Talk Subject: Re: Fastest way to convert a csv file to cf array/query? Hmmm, I've done some hunting around and the Merant driver seems to be named "ODBC Text" which is part of JDBC from what I can make out. I'm guessing I need to select "Other" from the dropdown selection of drivers, but some of the fields I am not sure of. The JDBC URL should be: jdbc:sequelink://127.0.0.1:4011/[ODBC Text];Database=d:\www\textsource\0927ME.txt The driver class field is causing me problems though. I'm getting a No suitable driver available for text error. Text being the name of my datasource. Any thoughts? -- jon mailto:[EMAIL PROTECTED] Friday, October 4, 2002, 7:14:05 PM, you wrote: DA> On Friday, October 4, 2002, at 03:01 PM, Rob Rohan wrote: >> FYI MX doesn't seem to have the Merant driver. >> >> DA> What's the name of the driver? DA> jar -tvf macromedia_drivers.jar DA> shows many, many Merant classes on CFMX Mac OS X (Linux) -- See below DA> Dick DA> 0 Mon Apr 29 12:02:08 PDT 2002 com/merant/ DA> 0 Mon Apr 29 20:41:34 PDT 2002 com/merant/datadirect/ DA> 0 Mon Apr 29 20:41:34 PDT 2002 com/merant/datadirect/jdbc/ DA> 0 Mon Apr 29 20:41:34 PDT 2002 DA> com/merant/datadirect/jdbc/extensions/ DA> 0 Mon Apr 29 12:04:06 PDT 2002 com/merant/sequelink/ DA> 0 Mon Apr 29 20:41:38 PDT 2002 com/merant/sequelink/admin/ DA> 0 Mon Apr 29 20:41:38 PDT 2002 com/merant/sequelink/auth/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
regex in sql server...
I posted this to [EMAIL PROTECTED], but I thought some of the folks here might be interrested in it also -- there's not much traffic on cf-regex, but you might want to subscribe to it if you want to comment on this post. I found this in a google search while trying to create a regex to format a sql script generated by enterprise manager... thought some of you might find it interresting, possibly even useful. http://www.codeproject.com/useritems/xpRegex.asp Looks really nice -- if only I could take advantage of it ... The big problem with it ( at least for me ) is a matter of people with shared hosting not being able to get dll's and the like installed on the sql server. Isaac Dealey Certified Advanced ColdFusion 5 Developer new epoch www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: help with IIS 5
some more info that may help you help me diagnose this thing. This is a two partition system with W2k installed on the D drive. I didn't notice at first that the mappings were to the C:\cfusion\bin directory...I changed those to d:\cfusion\bin and am getting a different error now when trying to open CFM files I can't start the CF server either Error Occurred While Processing Request Error Diagnostic Information Error occurred while attempting to open service. Windows NT error number 1060 occurred. HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Sun, 06 Oct 2002 02:56:44 GMT Connection: close Content-type: text/html Expires: 0 Pragma: no-cache Cache-control: no-cache, no-store, must-revalidate ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: help with IIS 5
oh yea... I can see the source code ok but when I click on browse it throws the error... and yes there's a mapping for.cfm and .dbm files both to the bin directory..iscf.dll file ... - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: October 05, 2002 10:37 PM Subject: Re: help with IIS 5 > Page not found huh? Are you sure you've got the URL right? I would have > expected it to at least display the source code of the page... > > In any case... go into the "Internet Services Manager" and right click on > your website and select "Properties". Then go to the "Home Directory" tab. > About 3/4 way down that tab is a button labeled "Configuration". Click that > button. You should get another popup showing you a bunch of "Application > Mappings". Take a look and see if you can find a mapping for .cfm files. > If you don't have a mapping for .cfm files that's a problem. In that case > let me know. > > -Novak > > > - Original Message - > From: "Tim Laureska" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, October 05, 2002 7:07 PM > Subject: Re: help with IIS 5 > > > > I can view html pages in CF Studio but CFM files come up with the "page > not > > found" error > > > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: October 05, 2002 9:58 PM > > Subject: Re: help with IIS 5 > > > > > > > First question... can you view .htm pages normally? > > > > > > Second question, can you view ColdFusion pages normally? Try this quick > > > test first create a file called test.cfm and place the following in > > it: > > > > > > > > > The time is: #Now()# > > > > > > > > > Then try going to test.cfm and let me know if that works. > > > > > > -Novak > > > > > > > > > - Original Message - > > > From: "Tim Laureska" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Saturday, October 05, 2002 6:56 PM > > > Subject: help with IIS 5 > > > > > > > > > > Hello All... I have just set up a new windows 2k pro box with IIS to > > > support > > > > my CF development I'm having a problem getting CF administrator to > > > > start.. whenever I launch CF Administrator I get a "page cannot > be > > > > displayed" http500 error. > > > > > > > > I'm new to IIS, but It seems set up OK... can anyone help me out > > here > > > > are there any common set up mistkes for an IIS/CF setup > > > > > > > > Tim > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: help with IIS 5
Page not found huh? Are you sure you've got the URL right? I would have expected it to at least display the source code of the page... In any case... go into the "Internet Services Manager" and right click on your website and select "Properties". Then go to the "Home Directory" tab. About 3/4 way down that tab is a button labeled "Configuration". Click that button. You should get another popup showing you a bunch of "Application Mappings". Take a look and see if you can find a mapping for .cfm files. If you don't have a mapping for .cfm files that's a problem. In that case let me know. -Novak - Original Message - From: "Tim Laureska" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, October 05, 2002 7:07 PM Subject: Re: help with IIS 5 > I can view html pages in CF Studio but CFM files come up with the "page not > found" error > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: October 05, 2002 9:58 PM > Subject: Re: help with IIS 5 > > > > First question... can you view .htm pages normally? > > > > Second question, can you view ColdFusion pages normally? Try this quick > > test first create a file called test.cfm and place the following in > it: > > > > > > The time is: #Now()# > > > > > > Then try going to test.cfm and let me know if that works. > > > > -Novak > > > > > > - Original Message - > > From: "Tim Laureska" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, October 05, 2002 6:56 PM > > Subject: help with IIS 5 > > > > > > > Hello All... I have just set up a new windows 2k pro box with IIS to > > support > > > my CF development I'm having a problem getting CF administrator to > > > start.. whenever I launch CF Administrator I get a "page cannot be > > > displayed" http500 error. > > > > > > I'm new to IIS, but It seems set up OK... can anyone help me out > here > > > are there any common set up mistkes for an IIS/CF setup > > > > > > Tim > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
Re: help with IIS 5
I can view html pages in CF Studio but CFM files come up with the "page not found" error - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: October 05, 2002 9:58 PM Subject: Re: help with IIS 5 > First question... can you view .htm pages normally? > > Second question, can you view ColdFusion pages normally? Try this quick > test first create a file called test.cfm and place the following in it: > > > The time is: #Now()# > > > Then try going to test.cfm and let me know if that works. > > -Novak > > > - Original Message - > From: "Tim Laureska" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, October 05, 2002 6:56 PM > Subject: help with IIS 5 > > > > Hello All... I have just set up a new windows 2k pro box with IIS to > support > > my CF development I'm having a problem getting CF administrator to > > start.. whenever I launch CF Administrator I get a "page cannot be > > displayed" http500 error. > > > > I'm new to IIS, but It seems set up OK... can anyone help me out here > > are there any common set up mistkes for an IIS/CF setup > > > > Tim > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: help with IIS 5
First question... can you view .htm pages normally? Second question, can you view ColdFusion pages normally? Try this quick test first create a file called test.cfm and place the following in it: The time is: #Now()# Then try going to test.cfm and let me know if that works. -Novak - Original Message - From: "Tim Laureska" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, October 05, 2002 6:56 PM Subject: help with IIS 5 > Hello All... I have just set up a new windows 2k pro box with IIS to support > my CF development I'm having a problem getting CF administrator to > start.. whenever I launch CF Administrator I get a "page cannot be > displayed" http500 error. > > I'm new to IIS, but It seems set up OK... can anyone help me out here > are there any common set up mistkes for an IIS/CF setup > > Tim > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
help with IIS 5
Hello All... I have just set up a new windows 2k pro box with IIS to support my CF development I'm having a problem getting CF administrator to start.. whenever I launch CF Administrator I get a "page cannot be displayed" http500 error. I'm new to IIS, but It seems set up OK... can anyone help me out here are there any common set up mistkes for an IIS/CF setup Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: MX and Javamail
To answer my own question... A quick scan of the J2EE 1.3 specs shows that Javamail 1.2 is required of a web implementation of J2EE. So, MX uses Javamail 1.2. The J2EE 1.4 Proposed Final Draft does require 1.3 though, so hopefully in the next version of MX, I'll be able to get rid of my hokey regex and use Javamail to validate email addresses. -- jon mailto:[EMAIL PROTECTED] Friday, October 4, 2002, 7:14:45 PM, you wrote: ksc> Ahh, I see. Not sure if MX uses JavaMail, or just uses JRun's implementation of the j2ee spec. ksc> - Original Message - ksc> From: jon hall <[EMAIL PROTECTED]> ksc> Date: Friday, October 4, 2002 5:11 pm ksc> Subject: Re: MX and Javamail >> >http://java.sun.com/products/javamail/1.3/docs/javadocs/javax/mail/internet/InternetAddress.html#validate() >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
Re: Fastest way to convert a csv file to cf array/query? Solved
Just wanted to thank everyone for the help, unfortunately I couldn't get the Merant drivers to work. I was able to find only one document out there on setting up Merant drivers, but it wasn't pertinent to CF for the most part. Luckily I was able to use the Microsoft Text Driver and set up a ODBC socket datasource very easily, and write a bit of code to dynamically set up the schema.ini file. If anyone is interested in it let me know. Much faster than my previous solution, which I will now bury and disown. Bye bye RequestTimeout. :) jon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
RE: Dreamweaver MX keyboard shortcuts...
David, 1) Select Edit --> Keyboard Shortcuts 2) On the edit window, click on the first box next to 'Current Set' (the box should have the hint 'Duplicate Set') 3) Name your duplicated set. 4) In the Command select box, choose Menu Commands 5) Select Insert --> ColdFusion Basic Objects -- > Surround with # 6) apply Ctrl-3 on the shortcuts. More about customizing your DW MX can be found in the following article. http://www.macromedia.com/support/dreamweaver/custom/customizing_dwmx/ > Is there a way to replace the cntrl-3 short cut that does an > to surround whatever is highlighted with #'s? > > thanks > > David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
Re: Big Trouble in T-SQL land
> Now, we seem to be unable to create temporary tables. The following query > returns 0 records in CFMX but 1 record in query analyzer. no, it looks like the CREATE TABLE in the same cfquery. fails with "regular" tables too. > Anyone else? Suggestions? Glass of hemlock? move this into an SP. works there as expected. > CREATE TABLE ##xyz (a varchar(10)) btw you should always check for objects prior to creating them just in case a process croaks & leaves that table or whatever hanging about. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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