Re: Large recordsets turned into text file

2005-08-25 Thread Alan Rother
We had the same problem. We found that anything over 5 was crashing our server using the old school cfloop over a variable. Check out cflib.org http://cflib.org and search for this QueryToCSV2 It uses JAVA and the toString method. It reduced our export time by about 2000% and now I have

Re: Storing UDF in application scope

2005-09-13 Thread Alan Rother
If your goal is to be able to use the function on any page in the application you could put it in a file that is then included in the application.cfm. This will make the function available for local use on any page called in the whole application. On 9/13/05, Jim Davis [EMAIL PROTECTED] wrote:

Re: OT: Mail server

2005-09-19 Thread Alan Rother
Smartermail. http://www.smartertools.com/Products/SmarterMail/Default.aspx It's not free, but it is pretty cheap and it works really well. On 9/19/05, Cedric Villat [EMAIL PROTECTED] wrote: What do you guys recommend as a good Windows-based mail server? Preferably open-source, but paid

Re: Credit card storage

2005-09-21 Thread Alan Rother
I agree with Matt, it's not illegal. It does violate SOME credit card companies policies regarding the proper handling of credit card data. The one exception to the rule is if you encrypt the data when you store it. Don't use a one way hash, you need to use a strong encryption algorithm.

Re: OT - js - determine which submit button was submitted?

2005-09-22 Thread Alan Rother
Instead of using actual submit buttons, you could use input type=button name=b1 onclick=MySubmitFunction(This.name http://This.name) Then you need to create a javascript function that is setup to accept your call and it will inheriently pass in the name of the button as one of the parameters. Use

Weird CFENCODE Problem

2005-09-26 Thread Alan Rother
Hey all, I know I've done this beofre and it worked. But this time is went all weird on me. I need to provide someone with a bunch of code and we don't want them messing with it. So I used the command line utility CFENCODE to encode/encrypt all of the files. It worked fine, I used \v 2 like the

Re: Stuck on saving times in a SQL server database

2005-10-01 Thread Alan Rother
The problem is your cfqueryparam You are using the type cf_sql_DATE You need to use cf_sql_timestamp If you use the DATE type, it will only pass the DATE portion of your timestamp into the field. On 10/1/05, Dawson, Michael [EMAIL PROTECTED] wrote: A few things to try: 1. Insert today's

Re: image manipulation in coldfusion?

2005-10-04 Thread Alan Rother
Wow... yeah... Alagad is nice, but the stuff from eFFlare is awesome. If you are in a shared envirnment I would go with alagad. On 10/4/05, Bryan Stevenson [EMAIL PROTECTED] wrote: now i'm torn. I've used ImageCR3 in the past and yes, it's a great product with absolutely fantastic

Re: OT: FTP Server

2005-10-07 Thread Alan Rother
Search for War FTP. It's made by this eccentric coder and is totally free. It's very secure and very stable. The only catch is that is will not allow itself to be used on any .gov or .mil sites. On 10/7/05, Mark A Kruger [EMAIL PROTECTED] wrote: has anyone here used bulletproof ftp?

Re: Stupid Date Question

2007-06-15 Thread Alan Rother
Only one problem with this code cfif isDefined(form.Year) and isDefined(form.Month) and isDefined( form.Day) cfif IsDate(CreateDate(form.year,form.month,form.day)) Date Valid cfelse Date is invalid /cfif /cfif If the data entered into either of the three form fields is invalid, the

Re: CFFTP

2007-06-27 Thread Alan Rother
if the .RecordCount is GT 0 If Yes, your file exists. HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent

Re: Meeting Reservation System

2007-06-27 Thread Alan Rother
Hey Eric, What do you mean exactly by, Meeting Reservations System. I work for a company that specializes in meeting software. We might have what you're looking for. On 6/27/07, Eric J. Hoffman [EMAIL PROTECTED] wrote: Does one exist in CF? I have googled, and checked CFTagStore, but not

Re: SQL to Retrieve One Record from Several Possible Records

2007-06-28 Thread Alan Rother
,pseason.person_addresses FROM PSeason INNER JOIN RoomTypes ON PSeason.addr_type = RoomTypes.addr_type WHERE pseason.id = '133' ORDER BY RoomTypes.OrderID /cfquery -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: Would this be tacky?

2007-07-03 Thread Alan Rother
I agree, Don't be afraid of sesion vars. I have apps that drop huge structs and arrays into each users session. This is the way to go. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: Would this be tacky?

2007-07-03 Thread Alan Rother
Will is talking about making the value persist across multiple page loads. The cg.http_referer would be incorrect at the final processing point. He needs to lock in a value as soon as the user starts a multi step process. On 7/3/07, Christopher Jordan [EMAIL PROTECTED] wrote: Yeah, but isn't

Re: Coldfusion MX7 Developer Exam for certification, a must? Where is the location of the exam?

2007-07-05 Thread Alan Rother
where is the location of the exam? (Around the world and especially in Asia please) http://www.adobe.com/support/certification/ HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: How to print directly from coldfusion code

2007-07-09 Thread Alan Rother
This isn't the BEST solution... But I used it once. Do you have an eFax acct and access to a FAX machine? If you do you can efax the result to your fax machine and in effect, print your reports. It's not a highly cost effective strategy, but it does work. On 7/9/07, Andy Matthews [EMAIL

Re: Best way to read a zip file?

2007-07-09 Thread Alan Rother
cfdirectory filter it by *.zip and look for your particular zip file by doing a query of queries It has the size in the result set On 7/9/07, Johnny Le [EMAIL PROTECTED] wrote: Hi, What is the best way to find out the size (in bytes) of a zip file? I use cffile to read it and then use the

Re: cfqueryparam and XML

2007-07-17 Thread Alan Rother
the text type. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| ColdFusion 8 beta – Build next generation applications today. Free beta download on Labs

Re: cfqueryparam and XML

2007-07-17 Thread Alan Rother
Why would you use text? Umm, cause there isn't a cfqueryparam cfsqltype=CF_SQL_XML value=#myXML# How would you do it using cfqueryparam? -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: Stopping a Screen Scrape

2007-07-18 Thread Alan Rother
I think as an intellectual challenge it would be fun to try to thwart the screen scraper, but how much does the upgrade cost? I don't really personally care or want to know what you charge for the upgrade, but think of it in terms of, We charge $xx.xx for the upgrade, the fix is going to take me

Re: [NEWS] Top 100 ColdFusion websites by Alexa rank

2007-08-06 Thread Alan Rother
WHOO HOOO!!! One of my company's sites made the list! #88... Sofitel North America Sorry, I had to.. =] On 8/6/07, Rey Bango [EMAIL PROTECTED] wrote: yea, yea... u did! LOL. Glad its up again. I'd like to know who created the page. Rey Phillip M. Vector wrote: No.

Re: any idea how to

2007-08-08 Thread Alan Rother
LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006

Re: any idea how to

2007-08-08 Thread Alan Rother
(703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:11 PM To: CF-Talk Subject: Re: any idea how to LEFT MID AND RIGHT cfset variables.myDateString

Re: I'm Old - ColdFusion 4.x

2007-08-09 Thread Alan Rother
Well... Big question. The coolest change since the 4.x days is the introduction of the Developer Edition of CF. You can now download the trial edition from the Adobe site and install it on your personal workstation at home and the license never expires. So you can play with it all you want this

Re: Dynamic Menu

2007-08-12 Thread Alan Rother
It would be helpful to see the query so we can see where you are going wrong. On 8/12/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Chaps, I've done this kind of thing before, but for some reason I'm struggling to remember quite how I did it. I'm building a dynamic menu

Re: Need CF Studio 5

2007-08-14 Thread Alan Rother
You can buy Homesite 5.5 by itself from the Adobe store for $99. https://store1.adobe.com/cfusion/store/index.cfm?store=OLS-USview=ols_catcatType=PRODUCTSnr=0 =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: (ColdFusion 8) Struct to XML

2007-08-14 Thread Alan Rother
Well... If you just want to turn a struct in some sort of XML, there is always good ole WDDX... It's XML How much control do you need over the XML format? On 8/14/07, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm looking around and can't seem to find a simple way to transform a structure

Re: Return File Extension

2007-08-27 Thread Alan Rother
BUT, you can protect against it by doing this cfif ListLen(filename, .) GTE 2 On 8/27/07, Rick Root [EMAIL PROTECTED] wrote: Keep in mind that if a file has no extension, #listLast(filename,.)# won't return the desired result of Rick

Re: OT: NetSol Hosting

2007-08-27 Thread Alan Rother
My advice is, don't host with Network Solutions. They don't offer ColdFusion hosting. Use someone like CrystalTech.com On 8/27/07, Andrew Tyrone [EMAIL PROTECTED] wrote: Hello everyone, We're converting two sites from ASP to ColdFusion and I was wondering if anyone had any tips or general

Re: OT: NetSol Hosting

2007-08-27 Thread Alan Rother
: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 3:47 PM To: CF-Talk Subject: Re: OT: NetSol Hosting My advice is, don't host with Network Solutions. They don't offer ColdFusion hosting. Use someone like CrystalTech.com On 8/27/07, Andrew Tyrone [EMAIL PROTECTED

Re: OT: NetSol Hosting

2007-08-27 Thread Alan Rother
Right there with you one the murky bit. It took me too long to find the section that mentions they offer CFMX as a Pro option. If your client has their heart set on using it, my main concern would be what features are missing. GoDaddy for example won't let you use createobject, negating an Java

Re: CF7 to CF8 upgrade or interoperability issues?

2007-08-28 Thread Alan Rother
Yeah, it's either DW, your browser or even IIS caching CSS and Images. On 8/28/07, Brian Kotek [EMAIL PROTECTED] wrote: CF doesn't cache images or CSS files. On 8/28/07, Jason Durham [EMAIL PROTECTED] wrote: I'm having a terrible time with DW8 and CF8 on my development box (single

Re: Multiple Users Per Cookie.

2007-09-01 Thread Alan Rother
Robert, If multiple users access your website from the same computer, there are several possible scenarios: 1. They are all logging into the same computer as the same user, therefore windows will not know it's a different user, therefore their browser will contain the same set of cookies between

Re: List of Coldfusion Bloggers

2007-09-07 Thread Alan Rother
Raymond Camden built this one. http://www.coldfusionbloggers.org =] On 9/7/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hi everybody: Does anyone has a list of CF Bloggers? I learnt lots of things from forta.com (Ben Forta's blog) and I really think other CF Bloggers can do the same for

Re: Design/Web Development Agencies that has a strong CF core

2007-10-02 Thread Alan Rother
What industry are they in? We specialize in hospitality, although we do have other customers. www.interactivesites.com On 10/2/07, Jochem van Dieten [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Does anyone know of or had expereince workign with a reputatble Web Design/Development

Using Japanese Text and CFIMAGE

2007-10-12 Thread Alan Rother
Hey All, Anyone out there used CF8 and CFIMAGE to create dynamic images that contain Japanese (well,really any double byte text language. Russian, Chinese, etc...) text yet? I'm having no luck on it, any help would be greatly appreciated. =] -- Alan Rother Adobe Certified Advanced ColdFusion

Re: Stop View Source

2007-10-19 Thread Alan Rother
and it gets stored on the users computer. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Check out the new features and enhancements in the latest product

Re: Moving from CF to .Net - need training advice/direction

2007-10-18 Thread Alan Rother
to write ASP.net. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Check out the new features and enhancements in the latest product release - download

Re: UNZIP

2007-10-22 Thread Alan Rother
If you are using CFMX or better, there is a great custom tag on the cflib for it. It's basically a hundred line java function. It's wicked fast and works great. =] On 10/22/07, Ben Doom [EMAIL PROTECTED] wrote: cfzip? :-) --Ben Doom Richard Colman wrote: Can anyone recommend a tag for

Re: TinyUrl's?

2007-10-23 Thread Alan Rother
. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver

Re: TinyUrl's?

2007-10-23 Thread Alan Rother
You don't have to go through all that, you can just cflocation them off to the correct URL -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Get the answers

Re: Using ColdFusion to determine if user has Flash player?

2007-10-24 Thread Alan Rother
As far as I know of, the only way to deter min if a browser has the Flash plugin is using Javascript. So if you want CF to know, you'll need to send it the info from JS via an AJAX type request of in a hidden form field. But by itself, CF cannot detect much of anything about your browser. On

Re: sms

2007-11-12 Thread Alan Rother
to the message are defined by you in a CFC you assign to that gateway, telling it what to do on certain events. The pieces you may be missing are access to a an SMS gateway, you will ether need to setup one up or buy access to one from a commercial provider. -- Alan Rother Adobe Certified Advanced

Re: blocking spambots

2007-11-14 Thread Alan Rother
What exactly is on your AddComments page? I am assuming it is some sort of form, correct? If so, one of the fastest ways to stop bot submissions is a good ole captcha. While not 100% perfect, it does hose most of the simpler bots. CF8 has it built in, but if not there are several options out

Re: blocking spambots

2007-11-14 Thread Alan Rother
the bot bums that your form is a waste of their efforts and they will stop. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Get involved in the latest

Re: error caused by cfqueryparam inside cfif

2007-11-26 Thread Alan Rother
and not a boolean... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now

Re: Checking that a file is to be uploaded

2007-11-27 Thread Alan Rother
a valid email address' HTH =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins

Re: sql and order by ?

2007-11-28 Thread Alan Rother
ORDER BY LEFT(FieldName, 4), Right(FieldName, (LENGTH(FieldName)-4) ) That should do it, assuming the date part is always the same length. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: Stop View Source

2007-12-05 Thread Alan Rother
Flex is just a tool for generating swfs. The decompilers I've used can decompile it back to actionscript, but not back to it's MXML. That would be extremely difficult. On Oct 19, 2007 10:49 AM, Russ [EMAIL PROTECTED] wrote: Can they really? I've had luck decompiling Flash 7 files, but nothing

Re: VPS hosting, anyone?

2007-12-13 Thread Alan Rother
I can't speak to it personally, but I have heard from people I trust that this company has a good VPS product. Looks like a great price and again, I've heard they have great customer service. http://www.ahphosting.net/vps.htm#advancedshared On Dec 13, 2007 10:54 AM, Rizal Firmansyah [EMAIL

Re: Efflare Imageflare1.5 Issue

2007-12-13 Thread Alan Rother
If you find out anything, please let me know. I've been fighting with the same problem for a year now. I find the only way to solve the issue is to reboot the whole server. Then it goes away for a week or so. =] On Dec 13, 2007 2:43 PM, Arturo Jones [EMAIL PROTECTED] wrote: I'm using

Re: File Download Manager

2006-03-29 Thread Alan Rother
side application you can't control how the end users computer handles the download and stoarge of the temp file that is created while the file is being downloaded. Just my 2 cents =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Pulling a random record from the DB

2006-03-29 Thread Alan Rother
as normal and then add the NEWID() AS Whatever column name you want and then order by it HTH -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236461

Re: Pulling a random record from the DB

2006-03-29 Thread Alan Rother
You could alwys just say F it and manually pick a record. =] Oh yeah, where do I sign up and what do I win? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com

Re: OT: mail to fax?

2006-04-05 Thread Alan Rother
I have worked with eFax, the system works pretty well, but the customer service can really be a pain. All the same I would reccommend them. It does work really well. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Rick Root's image.cfc errors

2006-04-12 Thread Alan Rother
solution to the problem. I usually have to open the images in Photoshop and resave them without the embedded color profile. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http

Re: Auction Software.

2006-04-13 Thread Alan Rother
I almost hate to mention this, but have you considered just using ebay? Seems like it would be alot easier and far less time consuming than getting your own system up and running. I mean, why re-invent the wheel -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Listing a complete directory and file path structure

2006-04-18 Thread Alan Rother
an example somehwere I will try to dig up and I will send it to you. HTH =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238019 Archives: http

Re: Listing a complete directory and file path structure

2006-04-18 Thread Alan Rother
Yeah... listen to Massimo... This is way better -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238028 Archives: http://www.houseoffusion.com

Re: 3rd Party Cookie Reading [try to explain again]

2006-04-24 Thread Alan Rother
is it you are trying to get from that cookie? Maybe there is another way to accomplish you actual end goal. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm

Re: I got Advanced !!!

2006-05-03 Thread Alan Rother
Technically speaking andy matthews Adobe Certified Advanced ColdFusion MX 7 Developer web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: I got Advanced !!!

2006-05-03 Thread Alan Rother
I'm not an Adobe Certified Advanced ColdFusion MX 7 Developer, My certificate specifically says that I am a Macromedia Certified Advanced ColdFusion MX 7 Developer =] On 5/3/06, Nathan Strutz [EMAIL PROTECTED] wrote: On 5/3/06, Alan Rother [EMAIL PROTECTED] wrote: Technically speaking

Re: Web Cam - Race Track

2006-05-04 Thread Alan Rother
. that should be enough info overload to get you started. Hope that helps =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer / Former IT specialist at an Security Company ~| Message: http://www.houseoffusion.com

Re: What CMS for .cfm?pageid=

2006-05-05 Thread Alan Rother
Can you give me an example site? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239691 Archives: http://www.houseoffusion.com/cf_lists

Re: Search Realestate multiple listings

2006-05-09 Thread Alan Rother
to the data. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http

Re: Component question

2006-05-09 Thread Alan Rother
cfargument name=myArgument type=string default=myDefaultString required=no -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240006 Archives

Re: Search Realestate multiple listings

2006-05-09 Thread Alan Rother
Yeah, most will let you get the IDX frame. I wanted a web service so I could control the search and display aspects myself. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http

Re: Looping through Directories

2006-05-10 Thread Alan Rother
There is another alternative. If you have a computer running CF7, cfdirectory has a recursive attribute now. You could install CF7 developer edition on a desktop on the attach the removeable drive to it and then run the process there... Just a thought. =] -- Alan Rother Macromedia Certified

Re: Losing Application Variables Randomly...

2006-05-10 Thread Alan Rother
I've seen this before. Most likely you have two or more apps on the same server using the same application name. =] Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com

Re: apache module for coldfusion and php as one handler

2006-05-12 Thread Alan Rother
I dont have an answer, but I have to ask, WHY? If you MUST use some php code you could always have it on a seperate file then call it using cfhhtp, then out puit it's results onto your cf page. Ok I guess I do have an answer... =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7

Re: Hype 2.0

2006-05-12 Thread Alan Rother
for it and keep them from mis-using it. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240407 Archives: http://www.houseoffusion.com/cf_lists

Re: Coldfusion validating a standard form?

2006-05-12 Thread Alan Rother
I don't suppose we could either see the actualy page (link) or the output HTML of the page could we? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm

Re: Hiding Files from a client with access

2006-05-12 Thread Alan Rother
, it then shuts the app down. HTH, and if you do use any of my suggestion, I did'nt tell you to do it, I dont know you and you are legally on your own. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Excel2Query/Query2Excel

2006-05-13 Thread Alan Rother
I agree These tags are worth it. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240490 Archives: http://www.houseoffusion.com/cf_lists

Re: Shared host with ISAPI Rewrite

2006-05-13 Thread Alan Rother
I don't know about that ISAPI filter in particular, but CrystalTech has installed some isapi filters for me in the past. It adds like $10 a month to the hosting cost. www.crystaltech.com =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: OOD/Design Patterns and ColdFusion.

2006-05-16 Thread Alan Rother
Hey Crow... Do we want to know how you found that site? =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240678 Archives: http

Re: Resetting a CF application.

2006-05-18 Thread Alan Rother
I usually add a restart to the onRequest method like this cfif IsDefined(url.Init) cfset foo = onApplicationStart /cfif This is off the cuff and has not been tested or validity, so use a guideline only. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: aba number lookup web service

2006-05-24 Thread Alan Rother
= variables.foo.getFedACHs().getFedACHData() cfset bankName = foobar[1].getAddress() HTH =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241377

Re: aba number lookup web service

2006-05-24 Thread Alan Rother
It is tough being me =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241385 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm

Re: Recursive Custom Tag

2006-05-25 Thread Alan Rother
I always just keep count in the rquest scope. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241511 Archives: http://www.houseoffusion.com

Re: Problems with LEN

2006-06-01 Thread Alan Rother
cfif LEN(Form.FirstName) GT 0 You also do not need to do the GT 0, ColdFusion boolean operators use all non 0 values as TRUE. And you should also TRIM your values as someone may have entered a space into the field cfif LEN(TRIM(Form.FirstName)) =] -- Alan Rother Macromedia Certified Advanced

Re: Coldfuson host for the Islands of Guernsey?

2006-06-02 Thread Alan Rother
Here is a dedicated host, if they HAVE to be in that region, then they may HAVE to get their own box http://www.submarine.gg/products/Offshore-Hosting-Guernsey/ -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Moving CF Variables to registry requires a restart?

2006-06-06 Thread Alan Rother
I have to ask the question, why would you want to move to using the registry? My understanding was that it only still exists to facilitate some backwards compatibility. Using the DB or server memory is far more efficient. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7

Re: Moving CF Variables to registry requires a restart?

2006-06-06 Thread Alan Rother
Got it... That makes ALOT more sense. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242654 Archives: http://www.houseoffusion.com

Re: soEditor

2006-06-06 Thread Alan Rother
http://www.fckeditor.net/ It's all you will ever need. It's open source and well documented for virtually every language you could want to use it in. Also, the soEditor hasn't been updated in like 3 years. It's basically dead. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
I've used it. Can you show us the SQL you are having a problem with? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243360 Archives: http

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
BY P.CategoryID, C.CategoryName -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
and performing calculations, such as in my example, I wanted to know how many products were in the Products table, but instead of just knowing how many altogether, I wanted to know BY category, which is what the SQL GROUP BY does. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
Are you trying to get a count of all of the books by Genre? Or are you trying to get a list of all of the genres? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Message: http://www.houseoffusion.com

Re: Group By function for MS SQL Server Express 2005?

2006-06-13 Thread Alan Rother
Not really, it's just a habit. I like to explicitlly control the name of the resulting variable. Dave is right, as usual, you can just leave it and it will retain it's given column name. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer

Re: Disaster recovery license for Coldfusion

2006-08-31 Thread Alan Rother
of mind and saved time in the event of a failure. Just my 2 cents. When in doubt, read the EULA -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80

Re: Problem with uploading Zip file. Anyone please help me!!

2006-08-31 Thread Alan Rother
cfhttp method=post url=http://www./upload.html; username= password= resolveurl=yes multipart=Yes cfhttpparam name=UploadFile file=D:\Websites\scripts\ebaymotorpro\AETA89337\ebaymotorpro_AETA89337.zip type=file mimetype=application/zip /cfhttp -- Alan Rother Macromedia

Re: Branch target offset too large for short?

2006-09-19 Thread Alan Rother
Do you have any cftransaction tags? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information

Re: CFMX7 and .NET integration

2006-09-22 Thread Alan Rother
Blue Dragon.Net www.NewAtlanta.com This is what is was designed for. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up

Re: easiest/fastest to implement payment processor?

2006-09-22 Thread Alan Rother
I've used USAePay and it was really easy, they even have a CF tag available to use as a module. It's all cfhttp posts. =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion

Re: credit cards

2006-09-25 Thread Alan Rother
. Also, this is important, try as hard as possible to convince your client/boss that storing CC numbers in your own database is a really bad idea and can open you up to all sorts of legal action if your data is compromised. HTH =] -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7

Re: Database Interations - overloaded sites

2006-09-25 Thread Alan Rother
to the users. -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your

Re: Coldfusion Zip Code Store Locator

2006-09-26 Thread Alan Rother
Are you looking for a Postal Code Database, or a fully formed program for doing radius searches based on zip code? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority

Re: Custom Google map with preset map points?

2006-09-29 Thread Alan Rother
Contact John Blayter. He wrote a CF tag set that does this. It's really easy to use. [EMAIL PROTECTED] or [EMAIL PROTECTED] =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion

  1   2   3   4   5   6   >