Re: HostMySite: Linux Builder + CF No Longer Offered

2007-07-23 Thread Tom Chiverton
On Saturday 21 Jul 2007, [EMAIL PROTECTED] wrote: terms of support. I think this has a LOT to do with the fact that SeeFusion, the software we use to keep CF in control on shared servers, doesn't work in a Linux Environment. So you'll be offering the service based on CF8, that has this built

Re: Export to Quickbook/Ms Money

2007-07-23 Thread Tom Chiverton
On Monday 23 Jul 2007, [EMAIL PROTECTED] wrote: Can anyone point me to resources that explain how to export a Recordset to a Quickbooks ? Similar to any bank website where you can download you transaction to your software. Does quickbooks take CSV files ? In which case, just construct the

Re: This is a good one - another Regex question

2007-07-23 Thread Mark Henderson
Claude Schneegans wrote: IMO, the format you are trying to modify is by far more correct than the result you are trying to attempt. Agreed. And the question, although once posed, still beckons - Jide, why do you want to do this again?? What precisely are you gaining by moving the closing

Re: This is a good one - another Regex question

2007-07-23 Thread Mark Henderson
Jide Aliu wrote: Thanks for your reply Claude. I know that formatting wise it's madness to have p tags round ul tag, but the problem we are having is that we are suppplying xml data to a vendor for some reason their system won't accept ul listing without p tags round them. That is my

RE: Export to Quickbook/Ms Money

2007-07-23 Thread Dawson, Michael
Google for OFX. There is an ofx.net web site with the xml syntax, but it appears to be down now. M!ke -Original Message- From: Yannick Morin [mailto:[EMAIL PROTECTED] Sent: Sunday, July 22, 2007 7:39 PM To: CF-Talk Subject: Export to Quickbook/Ms Money Can anyone point me to

Re: Help with Query

2007-07-23 Thread Brian Peddle
If all your photos will have prices you won't need to left join you can just join on them. Joel Watson wrote: Joe, First of all I am not sure if you need LEFT JOIN for both comments and prices. My first example was based on the assumption that you could have photos without comments and

hooking up IMS Lite

2007-07-23 Thread Dominic Watson
Hi, We have a client that wants to use IMS lite to send out mass emails and IMS lite has already been 'put' on their server. They would like to get an estimate on how long it would take us to 'hook it up to cfmail'. Having no experience of IMS I thought I'd ask the question to someone who has!

Re: Help with Query

2007-07-23 Thread Joel Watson
If all your photos will have prices you won't need to left join you can just join on them. Joel Watson wrote: That's true, but when I combine it with the LEFT OUTER JOIN on the comments, it screws up the comments. While it will return the prices information fine, it duplicates the

CDDocument Image problem

2007-07-23 Thread Chad Gray
I am trying to use CFDocument to make a PDF of a web page. I have an image that produces what kinds of looks like a missing image icon in the PDF. When I click on thing in Acrobat it says There was an error processing an annotation or link. There was a problem reading this document (14).

RE: CDDocument Image problem

2007-07-23 Thread Chad Gray
Ya, I put the images in a public folder and chaged my image path to: img src=http://websitename/images/invoicelogoNEW.jpg border=0 Now the image shows up in the PDF. So what permissions does CFDocument need on images to place them into the PDF??? Right now SYSTEM has full permissions, and

RE: CDDocument Image problem

2007-07-23 Thread Ben Nadel
I had a problem with IMGs a while back. It turned out to be a problem with the Router, not with ColdFusion: http://www.bennadel.com/index.cfm?dax=blog:266.view I don't understand server stuff that much, but this might help. .. Ben Nadel Certified Advanced ColdFusion MX7

GROUP BY RIGHT()?

2007-07-23 Thread Robert Rawlins - Think Blue
Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery

RE: GROUP BY RIGHT()?

2007-07-23 Thread Ben Nadel
Not sure if you can do that, but you might want to try getting the file extension as a calculated column in the query SELECT ( RIGHT( filename, 3 ) ) AS ext Then, in the CFOutput, you could group=ext .. Ben Nadel Certified Advanced ColdFusion MX7 Developer

Re: GROUP BY RIGHT()?

2007-07-23 Thread Charlie Griefer
cfquery name=foo datasource=bar SELECT filename, right(filename, 3) AS ext, othercol FROM table ORDER BY right(filename, 3) /cfquery cfoutput query=foo group=ext that, of course, assumes you only have file extensions of 3

Re: GROUP BY RIGHT()?

2007-07-23 Thread Brian Kotek
No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar):

Re: Project Time Tracking Software?

2007-07-23 Thread Cosmina Stefanache
Hi Aaron, I don't know if you are still interested in a time tracking application. I would like to suggest Fanurio (http://www.fanuriotimetracking.com) which does both time tracking and invoicing (I’m one of the people involved in this project). We have designed Fanurio to help freelancers

Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Jason Fill
I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data access

RE: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Leitch, Oblio
I've been working with FB recently, and what I wish I could do is create functions like we do fuseactions, and be able to use them in the includes. -Original Message- From: Jason Fill [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:26 AM To: CF-Talk Subject: Model Glue -

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread C. Hatton Humphrey
On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: I am looking for several opinions on all these frameworks and any others. I'm basically in the same boat and have decided to work with Fusebox. I'd love to hear thoughts/experiences on this topic too!

RE: GROUP BY RIGHT()?

2007-07-23 Thread Robert Rawlins - Think Blue
Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread John Paul Ashenfelter
If everyone's worked with Fusebox, why not just pick Fusebox? There's always a lot of concern over performance and frameworks -- bluntly, unless you're doing *phenomenal* transaction volume with very tight time tolerances, the framework shouldn't be an issue. Scaling out horizontally or

name conflicts with cffile action=move

2007-07-23 Thread Rebecca Younes
Is there any reason why cffile action=move doesn't support the nameconflict attribute, like action=upload, or is this just a design oversight? ~| ColdFusion is delivering applications solutions at at top companies around the

RE: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Peterson, Chris
I will throw my $.02 towards model-glue:Unity. I have been doing OO based .cfc's now for several years, and MG:U really clicked with me. You have your model (which is basically events setup that fire off controller message-listeners). The model simply says 'ok, I have a request for something

RE: GROUP BY RIGHT()?

2007-07-23 Thread Adrian Lynch
An ORDER BY? Adrian -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:45 To: CF-Talk Subject: RE: GROUP BY RIGHT()? Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie

Re: GROUP BY RIGHT()?

2007-07-23 Thread Charlie Griefer
did you ORDER BY appropriately? you need to ORDER BY the column(s) on which you're grouping. On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that

RE: Web Based Project Management Tool

2007-07-23 Thread Oğuz_Demirkapı
Oğuz Demirkapı wrote: Of course it is my issue if I say this code does not support Unicode. But I think we have a different situation when we say, the code support Unicode. your static text, your encoding. do any other files in ray's blog have a BOM? I do not want BOM support. I just

RE: Web Based Project Management Tool

2007-07-23 Thread Oğuz_Demirkapı
Thanks for the advice but we decided to use OpenSVN Trac as platform for this non-profit organization. By the way this product also does not support Unicode. ;) -Original Message- From: Mark Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, July 21, 2007 11:09 PM To: CF-Talk

RE: name conflicts with cffile action=move

2007-07-23 Thread Ben Nadel
I always thought it would be COOL if MOVE and COPY did handle the naming conflict as well. I can't see any downside to giving users the option to leverage CF for that. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help?

MySQL Client

2007-07-23 Thread Oğuz_Demirkapı
Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, Oğuz Demirkapı Sr.

Re: MySQL Client

2007-07-23 Thread Ben Doom
I use the tools published by MySQL. Administrator and Query Browser, specifically. --Ben Doom Oğuz_Demirkapı wrote: Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I

Re: mysql and media servers

2007-07-23 Thread Raymond Camden
The MySQL script file is meant to be run either at the command line with mysql tools, or with a MySQL client, like Aqua Data Studio. On 7/21/07, Peter Donahue [EMAIL PROTECTED] wrote: Good evening everyone, I just finished creating the database and the DSN for Blog CFC. My first question is

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread JJ Cool
I am looking for several opinions on all these frameworks and any others. Currently we are trying to figure out which one(s) we need to focus on evaluating so start a plan to port our current system into a framework. Our current system is basically a ton of cfincludes with the data

Re: MySQL Client

2007-07-23 Thread Jordan Michaels
I second the MySQL tools recommendation. You can find the tools here: http://www.mysql.com/products/tools/ Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Ben Doom wrote: I use the tools published by MySQL. Administrator

LDAP SSLv3

2007-07-23 Thread Greg Johnson
I know that coldfusion MX's cfldap tag is limited to SSLv2. But the question is, how do I get around that problem. Im looking for a ready to go solution as I am working on an important project. So I ether need a custom tag, or specific instructions. I will be using the LDAP calls for the

RE: MySQL Client

2007-07-23 Thread Chad Gray
I like HeidiSQL formerly known as MySQL-Front. http://www.heidisql.com/ -Original Message- From: Oğuz_Demirkapı [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 12:29 PM To: CF-Talk Subject: MySQL Client Hi all, I am using Navicat (navicat.com) as MySQL client now but I

RE: MySQL Client

2007-07-23 Thread Andy Matthews
Man... The interface on that HeidiSQL app is HORRIBLE. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 1:55 PM To: CF-Talk Subject: RE: MySQL Client I like HeidiSQL formerly known as MySQL-Front. http://www.heidisql.com/ -Original

Re: MySQL Client

2007-07-23 Thread Chris Montgomery
Oğuz_Demirkapı said the following on 7/23/2007 11:29 AM: Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. I use SQLyog: http://www.webyog.com/en/ -- Best regards, Chris Montgomery

CFC With Remote Access

2007-07-23 Thread Chad McCue
I have a cfc that is called from JS that returns a string, works perfectly on CF6 but is not working on CF7. My JS and cfc are below. Again this exact code is working on my beta server with CF6 on it. The production server is set up the same besides having CF7. When I try to alert(result) on CF6 I

RE: CFC With Remote Access

2007-07-23 Thread Peterson, Chris
Not sure about the differences from CF6 to 7, but you should add var declarations to the beginning of your file to ensure no funky variable values or un-expected behavior. I would re-write it like this: CFFUNCTION name=FindPromoCode returntype=string output=no access=remote CFARGUMENT

Re: MySQL Client

2007-07-23 Thread Terry Schmitt
I would highly recommend Datastudio by Aquadata. It is a great Query tool that is cross-platform and works with all of the popular databases. I use it for MSSQL and MySQL. The table and column insight is great. I have recently settled on DBManager by DBTools for general MySQL admin. It has a

Re: hooking up IMS Lite

2007-07-23 Thread Matt Robertson
very easy. If you've ever config'd a mail server before you should be in for about 5 minutes' work. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get involved in the latest ColdFusion discussions,

Re: HostMySite: Linux Builder + CF No Longer Offered

2007-07-23 Thread Matt Robertson
Its the same old story for shared ColdFusion hosting... morons can code in crap that takes the server out and blows everyone else up with it. A service nightmare even if the host has CF knowledge. Takes me back to the days when I was on shared CF hosting at Interland. Anyone remember that

news and press releases - need help!

2007-07-23 Thread Steven Sprouse
I tried on here before without much luck, but I really need to know how to set up some code that allows us to notify people on a mailing list when we've posted a new news or press release item. I'm assuming I need to set up a database that will hold the people who register, but how will we

Re: CFC With Remote Access

2007-07-23 Thread Ian Skinner
What happens if you put a properly rendered URL to that CFC method into a browser? Do you get the string you expect or something else. Do note that a ColdFusion error page would return a 200 status code because it is a properly returned web page, just not the page, one usually wants.

Re: news and press releases - need help!

2007-07-23 Thread Nicholas M Tunney
Why not set up an RSS feed? I've done that before with a certain level of success. I created an admin interface that allowed me to add news items, and a CF page that fed the RSS feed. That way people can manage their own subscriptions. -- Nicholas M. Tunney Blog: http://www.nictunney.com

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Jason Fill
Thank you all for the input on this topic. I defiantly think that in the short term and to get started Fusebox would have the smallest learning curve - which would allow us to get going fairly quick. While that is great, our main goal here is to adopt a framework that will be flexible and

Re: HostMySite: Linux Builder + CF No Longer Offered

2007-07-23 Thread Greg Fuller
Thanks, I'm gonna give Vivio VPS a shot if their CF8 pricing is comparable to their CF7 pricing when it is announced. I'm just waiting on CF8. --Greg On 7/20/07, Jamie Price [EMAIL PROTECTED] wrote: Unfortunally HostMySite just discontinued the shared Linux Builder + CF plans, and won't offer

Re: news and press releases - need help!

2007-07-23 Thread Jerry Johnson
The steps are pretty simple. Front end Form to allow people to subscribe to the email. Form to allow people to UNSUBSCRIBE from the email When they ask to subscribe, add them to the database When they ask to unsubscribe, remove them from the database (or mark them inactive) Backend Form to

Re: news and press releases - need help!

2007-07-23 Thread Greg Fuller
You could download blogcfc (google it) and look at the code. It does this, and supports subscription confirmation to stop people from subscribing someone else. --Greg On 7/23/07, Jerry Johnson [EMAIL PROTECTED] wrote: The steps are pretty simple. Front end Form to allow people to subscribe

RE: CFC With Remote Access

2007-07-23 Thread Chad McCue
Pasting the url in the web browser produces the correct result. Seems to be something with the xmlhttp request. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 4:23 PM To: CF-Talk Subject: Re: CFC With Remote Access What happens if you put a

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Cutter (CFRelated)
Jason, There is a fantastic sample app, called LitePost, that Matt Woodward, Peter Farrell, Chris Scott, and few others contributed to, that is available on GoogleCode. It's way undocumented, but basically it shows a simple blogging application. The 'Model' layer is a single set of CFCs, with

RE: news and press releases - need help!

2007-07-23 Thread Oğuz_Demirkapı
Some ideas: The steps are pretty simple. Front end Form to allow people to subscribe to the email. Form to allow people to UNSUBSCRIBE from the email When they ask to subscribe, add them to the database After submit send an e-mail which contains their wish and a link to finalize the

RE: CFC With Remote Access

2007-07-23 Thread Chad McCue
My server is also behind a strict firewall, not sure if that is my problem. If it is what settings would I need to change? -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 3:47 PM To: CF-Talk Subject: RE: CFC With Remote Access Not sure

Re: MySQL Client

2007-07-23 Thread Mary Jo Sminkey
I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. I've tried the MySQL tools, DBManager and a couple others and settled on Navicat. So far it's done the best for me, particularly in terms of creating correct SQL dumps with all the proper information

Re: MySQL Client

2007-07-23 Thread Peter Donahue
Hello Mary Jo and listers, Thanks for this information. I'll need to download Navicat for Windows and give it a go. I have a MYSQL Script I need to run to create a database on a remote host. This is the database for Blog CFC. Do you need to have MYSQL installed on your local machine to use

Re: Help with Query

2007-07-23 Thread Joel Watson
If all your photos will have prices you won't need to left join you can just join on them. Joel Watson wrote: That's true, but when I combine it with the LEFT OUTER JOIN on the comments, it screws up the comments. While it will return the prices information fine, it

Running CF7 on 64 bit Windows

2007-07-23 Thread Jim McAtee
I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. I'm getting the following error trying to access the CFIDE: %1 is not a valid Win32 application. Some

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Brian Kotek
I also presented on this very topic at the Frameworks conference earlier this year. My slides and code are available for download: http://www.briankotek.com/blog/files/framework_agnostic_models_presentation_code.zip The takeaway should be that when your model is well architected and

RE: Running CF7 on 64 bit Windows

2007-07-23 Thread John Mason
CF8 will only support 64-bit on Solaris. CF7 doesn't support 64-bit. I would stick to what is supported unless your client and you are willing deal with debugging things without Adobe support. Is there a particular reason you are wanting 64-bit? Just processing power? Thread throughput? John

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Sean Corfield
On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: One concern is that a framework might add too much overhead to the application because of the use of XML files etc. The only framework any of the three has worked with is Fusebox(2 thru 5). All three frameworks have a production mode where

Re: Model Glue - Fusebox - Mach II ...... Looking for Opinions

2007-07-23 Thread Sean Corfield
On 7/23/07, Jason Fill [EMAIL PROTECTED] wrote: I think we have pretty much decided that we are going to use ColdSpring to take care of IoC. So let me throw this out, does any one of the frameworks lend itself better to the use of ColdSpring, and possible Transfer or Reactor? They all work

Re: Running CF7 on 64 bit Windows

2007-07-23 Thread Jochem van Dieten
Jim McAtee wrote: I thought I'd asked this either here or the CFServer list and was told it wasn't a problem. Can we run CF7 on 64 bit Windows Server 2003? Dual 64bit Xeon 5130s, and IIS6 as the web server. You can run CF as a 32 bit application on 64 bit Windows. Connecting to a 64 bit