Re: Remote Job: 3 Senior ColdFusion Developers
On Wed, Mar 18, 2015 at 1:02 PM, Phillip Vector vec...@mostdeadlygame.com wrote: This is an 8+ month contract and our client is interested in candidates who are local to the area or someone who can relocate at their own cost to the area for the duration of this project. Remote Job *sighs* The spammers have found the list. I've gotten flooded with emails like this lately. Until Later! C. Hatton Humphrey Like the saying goes, Measure Twice, Cut Onc... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4659 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: Opening Local Files
On Mon, Aug 25, 2014 at 9:39 AM, Richard White rich...@re-base.net wrote: We have created an online database program. I have a requirement for a user to store links to files contained on their local machines, then at the click of a button it will open the file. If we were to store these files on our server I know we could use cfheader and cfcontent to open the file. However, seeing as the files are stored on their local machines how can I achieve this? Assuming you mean that you need to open the file that is stored on the user's computer and do something with it on the server, there has to be a tool that transfers that file from the client first. We use a web app that does that by making use of a SoftArtisans ActiveX plug-in called XFile. It works something like this: 1. On the server, the path and filename is stored in the per-user database settings 2. When the page is pulled the active-x initiates the file-transfer and saves the file locally. The user is prompted to confirm. 3. The page continues processing. File transfer is still required, it's just handled a bit more seamlessly than an upload button or FTP. Until Later! C. Hatton Humphrey Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (Semi-OT) - site sucker app
On Wed, Aug 6, 2014 at 9:06 PM, Gerald Guido gerald.gu...@gmail.com wrote: http://www.httrack.com/ is, IMHO, outstanding. +1 for this tool Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Restrict the user from editing the excel sheet exported using cfcontent tag.
Sathya - I'm no expert on CFContent but you might be able to extend the concept presented in http://www.bennadel.com/blog/461-creating-microsoft-excel-documents-with-coldfusion-and-xml.htm which uses a CFSaveContent to create an XML definition of a spreadsheet and then CFContent to save the file. Digging further, there is also CFSpreadSheet and in http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html there is a password parameter.which, Set a password for modifying the sheet. Hope this helps. Until Later! C. Hatton Humphrey Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. On Sun, Jun 15, 2014 at 2:42 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear Friends, Is there anyway we can restrict the user from editing the excel sheet exported using cfcontent tag. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: not getting identity value from insert
On Tue, May 27, 2014 at 1:34 PM, Matthew Smith chedders...@gmail.comwrote:
SELECT @@IDENTITY AS 'Identity'
You might try using IDENT_CURRENT('#request.sqlobjectprefix#
TblEmailRecovery')
http://msdn.microsoft.com/en-us/library/ms175098.aspx
Otherwise, what are you looking for?
Until Later!
C. Hatton Humphrey
http://www.eastcoastconservative.com
Every cloud does have a silver lining. Sometimes you just have to do some
smelting to find it.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358686
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
DevEdit
I'm working on an old CMS and it's using DevEdit as its WYSIWYG. I need to figure out a way to change the configuration but the site is dead, there's no reference of it on the main company's website and Google is being particularly un-helpful. Does anyone have a copy of the DevEdit Setup guide for version 4 that they could send me? Yes, I know it's old and abandoned but it's kinda like that ugly dresser you inherited... you just can't stand to get rid of it! Thanks! Until Later! C. Hatton Humphrey Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DevEdit
Sheesh, thanks! I spent more time than I care to admit prying in different ways... I even included archive.org but was using the devedit.com site. What's sad is that I'm specifically trying to break the rules; I need to add a meta refresh into a content block and this CMS was built with such obscure logic that I figured it would be easier to slip it into a content block. When I try it though, DevEdit is replacing META with InvalidTag. Thanks again! Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. On Thu, Mar 27, 2014 at 10:14 AM, John M Bliss bliss.j...@gmail.com wrote: http://web.archive.org/web/20060112162442/http://www.interspire.com/devedit/documentation.php On Thu, Mar 27, 2014 at 10:12 AM, Jon Clausen jon_clau...@silowebworks.comwrote: http://hesab.net/book/asp.net/devedit_aspnet_demo/DevEditSetupGuideNET.pdf On Mar 27, 2014, at 10:06 AM, C. Hatton Humphrey chumph...@gmail.com wrote: I'm working on an old CMS and it's using DevEdit as its WYSIWYG. I need to figure out a way to change the configuration but the site is dead, there's no reference of it on the main company's website and Google is being particularly un-helpful. Does anyone have a copy of the DevEdit Setup guide for version 4 that they could send me? Yes, I know it's old and abandoned but it's kinda like that ugly dresser you inherited... you just can't stand to get rid of it! Thanks! Until Later! C. Hatton Humphrey Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF to groovy, awe man wth...
On Mon, Mar 17, 2014 at 9:59 AM, Dave Watts dwa...@figleaf.com wrote: That said, it may not actually be the best thing for your employer, simply because the value of existing code is very, very high, as is the cost of rebuilding applications in a new language. So, you might want to ask your employer what value they expect to get from this? I was going to say something similar... Odd switch, going from one Java bytecode language to another. However, as Ray suggested, here are some from the search results... For what it's worth my search query was: groovy programming book reviews http://www.amazon.com/Programming-Groovy-Productivity-Developer-Programmers/dp/19377853005 stars (6 reviews) http://www.amazon.com/Groovy-Action-Dierk-Koenig/dp/1932394842 4.5 stars (24 reviews) From the looks of it most of the texts are for Java developers. Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: time off tracker
There are quite a few, though none I've reviewed in the past have been in CF. Most have been built around a Time Attendance solution... at least the ones that I've looked at have been. Contact me directly and I can email you a comparison chart of the ones I last looked at (can't do attachments here). My research was a bit skewed because I was looking for a time attendance solution first and a PTO request solution second. Hatton Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. On Fri, Feb 7, 2014 at 8:16 AM, John M Bliss bliss.j...@gmail.com wrote: Hi! Does anyone know of a free/cheap Web-based time off tracker to allow employees to request time off, have it approved by supervisor, show calendar of vacations to all users, etc. Could be written in CF, but not required. Could be hosted or install-able. -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Haven't received any mail lately...
Live mic Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. On Tue, Jun 25, 2013 at 10:32 AM, Rick Faircloth r...@whitestonemedia.comwrote: Testing... -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Google checkout - going away
more on this - http://www.tweaktown.com/news/30481/google-asks-merchants-to-switch-to-google-wallet-confirms-checkout-will-be-closing-in-six-months/index.html Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. On Mon, May 20, 2013 at 10:27 PM, Raymond Camden raymondcam...@gmail.comwrote: Look for a service that supports Java. Than just wrap the calls in CF. On Mon, May 20, 2013 at 9:24 PM, Al Musella, DPM muse...@virtualtrials.comwrote: Google just notified me that they are shutting off the google checkout service as of Nov 20.. the company they referred me to doesn't support coldfusion.. Will probably change to paypal.. anyone have any better suggestions? What a pain in the neck. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Source control in CF
While I have only very limited CF experience in working with a setup where everyone develops locally, I have done quite a bit of this in C#. Something else before you bow out of the conversation - Microsoft spoils its developers with Visual Studio. In the VS environment you have a built-in test environment that includes data and web services. The multitude of IDE's available for ColdFusion don't provide this pushbutton option. Developers have been traditionally left to fend for themselves to a large degree to have a setup that allows them a safe place to test their code. Given the varying platforms CF is built in and the variety of the CFML language engines, this is not going to be made any easier. Hopefully you've gotten something from this thread! Hatton ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Source control in CF
If I may, I think there are some core concept differences between Michaels scenario and the others. What I am seeing in your questions and responses points to a corporate structure where development is not a part of IT. Correct me if I'm wrong there. In many cases the structure is different, with the two being the same with different roles but supporting each other. IT (or server admins) taking care of the hardware, patches, and environment but leaving the development environment to the developers themselves. It's a subtle difference but one that helps lessen the load and increase the skillset of the dev team. Also consider solo developers who have to do it all. I have been in all three situations and will never go back to the first. When I was first getting started I didn't know anything about servers. I learned as much as I could from whatever sources I could, especially this list, and now I can not only plan and build applications but also set up both internal and external servers and deal with the management issues that come up. So the right answer comes down to not only how you need to handle this situation but also how your company structure is and how much you want to increase the skills of your development team. Hatton ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Data synchronization question
This isn't ColdFusion specific but I figure it's worth asking here - I have two SQL 2005 servers that I am synchronizing data between using stored procedures. On one server, MAIN, I have 5 databases with identical structure that feed a database of UNION based views. On the other server, WEB, there is one database that, for about 30 of the almost 1500 tables (I didn't create the data schema nor do I have any ability to change it, it's a Microsoft product that we're reporting on) in the MAIN db structure have a similarly named table, something along these lines: MAIN table - UPR00100 WEB table dUPR00100 Every 6 hours a stored procedure on WEB fires off that does the following: TRUNCATE TABLE dUPR00100 INSERT INTO dUPR00100 (column list) SELECT (column list) FROM MAIN.Reporting.dbo.UPR00100 I'm wondering two things: 1. Is there a better way to do this data sync outside of using the stored procedure approach? The rule for the sync is that all data on MAIN wins... and there is no code on WEB that modifies the tables on WEB. 2. Would there be any kind of time and process savings to rewrite the procedures to perform and insert/update/delete process instead of always wiping and reloading? My limitations are this - I can't upgrade the database server and I can't change any of the table structures. I can only work with the synchronization functionality. Thanks! Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdot.net (was: CF vs. ASP.Net)
Im not trying to nitpick, I only noticed them (except for Coldfusion... that usually stands out to me) because I sent the link to my colleagues along with the text from the home page as a description for the link. Two things that bug me - 1. It's C# which is one code-behind language for .NET. I have yet to have someone give me a quantifiable performance-based reason why it better than other languages in the family. 2. The .NET version does not include the ASP.NET part of the equation. For example: http://www.cfdot.net/cfdot/Pages/CodeDetail.aspx?id=7 (CFOutput) the .NET code is simply setting the .Text property of a text box. Where's the creation of the object? It's a great concept but as implemented it only confuses the whole CF vs .NET conversation. Hatton ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ben Forta
It was someone rick-rolling the jobs list Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced. On Tue, Mar 30, 2010 at 6:56 PM, Jeffrey Epstein jeffr...@pobox.com wrote: Does anybody know if that post supposedly from Ben Forta is legit? The link went to some music video on YouTube, so I do not trust the email address. -JE ~| 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-jobs-talk/message.cfm/messageid:4293 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Re: .NET or JAVA? Which is a more natural step for a CF Developer
I was curious what the group's thoughts were on the two above technologies and which would be easier/more natural to move into. First and foremost, a lot of the answer depends on the other language(s) you are familiar and comfortable with. If you cut your teeth on CF alone I don't know that there is much of a point of reference in any one specific direction. I had to make the shift into the .NET world and can share my thoughts on that process. Because I grew up programming in BASIC (CoCo and qBasic) and had done relatively little in C++ / JAVA, I went with the VB.NET code-behind. C# has a syntax and flow that is much like Java, as others have said. Your observation that NET isn't a *single* language is correct. Even when working with ASP.NET you're dealing with two different languages that simply share objects. In the end it all compiles to bit code and runs on the framework the same way. The biggest thing I had to learn was the concept of events. Until I had my brain wrapped around the concept that every page submits to itself by default and don't have to have things redefined for them I struggled badly. Hatton ~| 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:325387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ecommerce emergency
That's all well and good, but I know for me personally, I don't have any cash at the moment. Unless you are willing to loan me some money to pay for it (I need it within the week), then I'll have to make due with what I got. :) I waited for someone else to say it but +1 for CF Webstore. The price point is set so well that it would cost you more in man hours to build it than to buy it. It's actively developed, customizable and constantly growing. ~| 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:324844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: YIKES! I must let internet users write SQL queries for our database!
Did I get your attention? Luckily these are read-only queries, but still! A couple of things: 1. Create a large selection of views with nice names, it will make it easier for your users to identify the tables and columns they are looking for. This will also remove or reduce the need for JOINs 2. The flex/AJAX query builder idea is a nice one, you could also provide a drop-down driven query builder and let it dynamically build the SQL statement for the user, then give the user the ability to edit the SQL. Since you're running off a replicated database the need for heavy regex checking might be reduced but you're still going to want to run the entire query through a screening to check for SQL injection. Good luck! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: expert sql challenge
Is there a MSSQL version of that puppy? On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com wrote: Nice. So group_concat works sort of like ColdFusion's valuelist method. Very nice indeed! -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: Tuesday, April 14, 2009 2:59 PM To: cf-talk Subject: Re: expert sql challenge thanks for all your replies. barney, yes we are using mysql and didnt even know about the qroup_concat. it works like a dream and where this task was taking 23 seconds to complete it is now taking a matter of milliseconds :) fantastic and thanks once again for all your replies :) What DB are you using? If it's MySQL, you can use this: select client.name, group_concat(clientphone.number) as phone numbers from client left outer join clientphone on client.id = clientphone.clientId group by client.name If it's MS SQL Server you can use a subquery with FOR XML PATH and STUFF to approximate the same functionality. Don't know about other platforms. At the very least, pull a single recordset with the same JOIN as above, but no GROUP BY, and then you can do the rollup in a single CFOUTPUT loop. That'll save you a lot of trips to the DB, and therefor a lot of wasted time. cheers, barneyb ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No Verity, no full-text indexing...search options?
Apart from a simple SQL where [column] like '%[phrase]%' clause, are there any other options out there? I also don't want to use a custom Google search, for a variety of reasons. You might make use of a dictionary web service like http://services.aonaware.com/DictService/DictService.asmx and throw the results of a match search using SOUNDEX into an IN() in your query. Just a though ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Replication Models
Don wrote: With regard to 1,498 tables, do you mean, User Tables? just for clarity. Yes, 1498 user tables. The application was originally built on a flat-file database system like DB3/4 or Foxpro and was ported to SQL Server without re-engineering the database. All of the tables have 8 character names and the column names are a max of 8 characters as well. The tables are not named intuitively, such as UPR00100 = Employee Main table, UPR00101 = Employee addresses... and so on. Trouble is that I don't know how often these tables are touched. I do know that the process of printing a check involves at least 20 tables. The application is a complete accounting package that has been modified to include benefit, deduction and tax compliance functionality. According to the Sysobjects view there are also 20,644 stored procedures and 166 views. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Replication Models
Those do not appear to be very challenging requirements. You could probably even do this without any of the built-in replication at all but with just incremental backups. How have you currently configured your backups? Do you notice a performance impact when you run a full backup? Do you notice a performance impact when you run a transaction log backup? The current schedule for backups is a full backup at 3am for the group of databases and then a transactional backup every hour from 7am to 10pm during the week. As far as the performance of these, I'll have to figure that out. For performance size doesn't matter all that much. What matters is update volume. What is the transaction log volume per hour? How long does it take to apply (replay) that transaction log volume currently? Hmm... Those are questions I don't know how to answer. However, if I'm understanding where your question process is going, you think having a process that would copy and apply the transaction logs on the SQL 2005 server might be a safer idea? That's an interesting idea! How would I accurately monitor those metrics? As I said before, there are a maximum of 18 simultaneous users based on licenses, then there are reports that can run on the data at any time. The office is generally open for a 9-10 hour period each day, not including weekends. I *could* see if it would be possible to have as much as a 12 hour lag between the systems but I doubt that would fly. Thanks for the line of thought! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Replication Models
Thanks for the comments, Don! The main thing I'm worried about is any performance hit on the publishing server. The target server can lag behind data-wise by a bit (30 minutes to an hour is an acceptable delay). The problem is the size. A MS Dynamics GP database contains 1,498 tables (not including temp tables and local tables created for check printing and reports), none of them truly normalized. I need to make sure that the transactional replication does not create any additional delay in the primary tasks being fulfilled. I guess the only way to tell is to do it and see what happens. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Replication Models
Question for anyone that handles SQL Replication: What effect would setting up transactional replication from a large Windows 2000 database (17 Gb) with moderate usage (18-20 max simultaneous connections) to a Windows 2005 server have on the performance of the Windows 2000 machine? The reason behind the question - We use Microsoft Dynamics GP with 4 different SQL databases housed on a SQL 2000 server. We are building a web application to query those databases (read only) as well as store some data that they are not set up to manage. It uses a SQL 2005 server. Right now the app is running slow because the queries are running through the SQL 2005 as a linked server. My thought in speeding things up is to set up replicated copies of the 4 databases on the SQL 2005 server. This would be a transactional replication so we have instant access to any changes made in the main system. Additionally, the remote possibility of an injection attack running back to the live Dynamics databases would be removed. Our worry is that setting up the replication would place a noticeable strain on the main server, something we cannot afford to have. Any thoughts, ideas or suggestions? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Since 172.22.1.150 is an RFC 1918 address (from the 172.16/12 range) you need to look on whichever intranet you found that address and not on a public mailinglist. If I start looking for 172.20.1.
Wow, you managed to break google's grouping! Good job! On Tue, Feb 3, 2009 at 3:19 PM, Charlie Griefer charlie.grie...@gmail.com wrote: longest. subject. ever. :) On Tue, Feb 3, 2009 at 12:16 PM, Jochem van Dieten joch...@gmail.comwrote: Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318782 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: join two databases
What is the best way to join tables across two databases servers? Say I have one MS SQL server that has a database that stores ERP product data. I have our website MS SQL server that stores extra data about the product records in the ERP database. Is it possible to hook each datasource up in CF Admin and use both DSN's in the same CFQuery? Or should you do something on the MS SQL servers to join them then hook up one datasource in CF Admin? I'm pretty sure you're going to have to do two separate queries and the do a Query of Queries to tie the two together. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: join two databases
You need to link your SQL Server instances. Google SQL Server Linked. You can link the servers both directions, if needed. With the server linked in SQL, you can create cross-server queries in the Query Analyzer/New Query editor. Well would ya look at that! Learn something new every day, thanks for the education! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Audio conversion
Does anyone know of a good cf tool for converting audio files to mp3? I looked briefly, and couldn't find any, so hoping someone else will know of one. Only thing I can think of is using CFExecute to call FFMPEG to perform the conversion. You can find it at http://ffmpeg.mplayerhq.hu/ Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Appending one file to another
Can I use cffile to append one file to another? cffile action=append output=File2.txt file=File1.txt Doesn't seem to work. (This is assuming File2.txt is too large to store in a variable.) My problem is running data through a loop to convert HTML to rtf. The process times out after about 130 records, so I have to split the process into multiple attempts. I'd like to then put the finished product all together into one file. I did this in DOS not too long ago - the command was: COPY File1.txt + File2.txt + File3.txt OutputFile.txt You should be able to do something similar using the CFExecute tag. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: On line project site
I got one project on Rent-a-Coder that was less than encouraging. Maybe it was my lack of experience in managing client expectations at the time or maybe it was what this particular client had dealt with (and gotten away with) in the past but I ended up terminating the project before completion. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4153 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Use Wordpress or BlogCFC?
I've been using BlogCFC for a number of different sites and it's very stable. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe's CF IDE, Bolt
So...anyone *not* using the Bolt beta, please raise your hands... I don't see any hands, so it must be out. Is anyone allowed to confirm that it's out and being used and therefore I didn't get a chance to work with the beta? :o( I'm not - not even sure if I'm going to until I see a good reason to change from CFEclipse and Notepad. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfpop using hotmail
Two things: 1) There's no need to bump a message twice in the span of a minute. 2) If you're getting that error message that means a few things: a) the port is correct b) CF is communicating correctly with the MSN Live server c) From the brief Google searches that I did (Hotmail POP3, MSN POP3) I found the following: http://mailcall.spaces.live.com/Blog/cns!CC9301187A51FE33!44348.entry The most telling thing is this line: PS - please note that I said Hotmail Plus users and not MSN Premium users. We are working to offer everyone POP access eventually, but for now, Hotmail Plus users are the only ones that can do so. Try accessing the email from Outlook or some other client and see if you can. If that works then there's a problem with your code, otherwise you may be out of luck for a while. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CFLoop to Define Variables
Regarding cfset SC#x# = listEelment : Since this is an 'evaluation', and I have heard that 'evaluations' cost more performance wise than using a setVariable() with a concatenated variable name, I prefer to use the first method I indicated above. However, I can't confirm this performance issue, although maybe someone else on the list has done some performance testing with 'evaluations' and can comment on that. From http://www.cfquickdocs.com/?getDoc=SetVariable#SetVariable: Description This function is no longer required in well-formed ColdFusion pages. ~| 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:310754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Anyone played with WPF (Windows Presentation Framework)?
(Cross-posting from CF-Community, sorry if you get this twice) I'm starting to do some disk based programming work and have hit an interesting roadblock. We've (my bosses, actually) want to use .NET for the disk based apps, but now that I have VS 2008 I'm presented with WinForms or WPF. From the look of things, WPF is where Microsoft is headed with the UI fight. Has anyone had to make this decision? Does anyone have resources (web or email) for this? When it comes to web, I've sold them on using CF to integrate with ..NET... (*yay*) but we have to decide on the disk-based solution. I've been playing around with both and my biggest stumbling block is the actual planning out of the interface. Amazing how much having a browser to contain everything can alleviate interface nightmares! Hatton -- George Burns - Don't stay in bed, unless you can make money in bed. -- George Burns - Don't stay in bed, unless you can make money in bed. ~| 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:308700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone played with WPF (Windows Presentation Framework)?
When you say disk based - you mean like System.IO file directory interaction? If that's the case, I highly recommend .NET. It tends to be remarkably fast in this category. I guess I could have been a little less vague on the projects - We have two systems that we use for our in-house business. One is a commercial app that is built on top of Microsoft Dynamics GP (an accounting package that uses MS SQL Server). The other is a collection of homebrew Visual FoxPro apps that have provided the functionality that the commercial app does not. Some of these apps are for interacting with the database to manipulate table data that the commercial app won't let us. Other apps provide additional functionality that are part of our business logic that are not addressed elsewhere. In the conversation I had with my boss today I made the comment that I don't want to get in the habit of coding for coding's sake or building throw-away apps. The oldest of the VFP apps that is still in use today was written almost 10 years ago. My stuff is going to be replacing it but it needs to have the same kind of shelf life. One of my biggest issues is in identifying the right tools to use and properly planning their use. I've been building web apps for 8 years, I know how utilities have to flow. I haven't been exposed to the Visual world and so now I'm looking at these two technologies and trying to figure out code and layout and interface all at the same time. I never knew how safe working inside a browser really was! Hatton ~| 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:308719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfhttp failing to retrieve page
When you go to the URL from a browser on the server itself what happens? On Fri, Jun 6, 2008 at 3:59 PM, Michael Dinowitz [EMAIL PROTECTED] wrote: OK, this one has stumped me and it shouldn't. Using cfhttp to get this url, I get no result www.comicbookdb.com/browse.php?search=Publisherletter=all I've played with the following settings with no result: useragent throwonerror redirect If I try www.comicbookdb.com I get a result I've even tried setting and sending a cookie with no result. Anyone have a clue? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfhttp failing to retrieve page
Server 2003 has an HTTP security block that affects CF's performance. Perhaps someone enabled it or cleared the safe sites list? Hatton On Fri, Jun 6, 2008 at 4:09 PM, Michael Dinowitz [EMAIL PROTECTED] wrote: It worked in the past and I'm trying it on my home test box. If the root url works, why would the deeper one fail? I tried it by direct IP and it also fails. Would there be something that the browser sends that cfhttp doesn't? On Fri, Jun 6, 2008 at 4:04 PM, Raymond Camden [EMAIL PROTECTED] wrote: Did you try a network monitor tool? Also, did it work before? Don't forget CF caches the DNS look up. If the DNS changed for the site, CF could have the wrong IP. On Fri, Jun 6, 2008 at 2:59 PM, Michael Dinowitz [EMAIL PROTECTED] wrote: OK, this one has stumped me and it shouldn't. Using cfhttp to get this url, I get no result www.comicbookdb.com/browse.php?search=Publisherletter=all I've played with the following settings with no result: useragent throwonerror redirect If I try www.comicbookdb.com I get a result I've even tried setting and sending a cookie with no result. Anyone have a clue? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307004 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is it with telecommuting?
Understandably, most places want people on-site. As a coder, I've never understood this obsession. As a geek, the location of my colleagues and/or computer are irrelevant. But see, there's the problem - we (geeks and coders) are a HUGE minority when it comes to employees and needed work resources. Not every one of us works for a web shop! When I have taught programming, I tell my students that programmers are wired differently; we see the world from a different point of view than most others... even others that embrace and encourage technology. Put another way, unless our manager was a coder at some time, they will never understand how we can operate given the right conditions. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3809 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
I get contacted by recruiters almost daily.. Why is it that in a depressed housing market, many employers won't even consider telecommuters? I do understand the reasoning behind TSI and above clearance contracts, but non secure and private employers really don't have a valid reason not to. The chances of people, especially homeowners, considering relocation right now is almost non existant. Just my $.02. discuss. Forget the cost of housing, what about the cost of GAS! I'm back to driving ~20 miles each way. When I accepted the job the numbers made sense for my budget. Now I've had to cut back on necessities, bills and RAPIDLY growing fuel costs. Mass transit is NOT an option for those of us who live in areas that don't have them. Understandably, most places want people on-site. The best tele opportunity I was was one where you went on-site for a month on the company dime and then came in for meetings every quarter. That way there was the possibility of meeting and interfacing with people and the remote aspect. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3780 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: CSS page calls and image calls from a CFC
As an adjunct to Dom's suggestion, custom tags would be a good candidate for headers and footers if you are looking to control the data that is passed to and from them. Also, something that I've run into is if I'm using AJAX to power the contents of a CFDIV, I can have no other HTML generated by a .CFC. For example. Application.cfc OnRequestStart include Header HTML Page calls file.cfc with a BIND OnRequestEnd include Footer HTML That will generate NOTHING on the BIND. If I include the header and footer on the actual page, works like magic. Hatton If I ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDiv, CFTree sync help
I'm working on a system where I have a CFForm with two elements - a
CFTree tag and a CFDiv. The CFTree is using the CF8 AJAX to populate
and that is working just fine. I need to synchronize the CFDIV
contents to the selected element on the CFTree, and that is driving me
somewhat batty.
In this instance I'm working with a folder listing on one side and
need the files on the right. It could be any scenario, though -
tables and contents, people and details, etc. I know the answer is
out there (starts humming the X-Files theme) but I'm not searching for
the right words.
So how *do* I update the contents of a CFDiv that is populated using
the bind tag (right now bind=cfc:cfc.files.getFiles({folder}))?
Thanks!
Hatton
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303984
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDiv, CFTree sync help
Found the solution...
Had to make use of the @change modifier in the bind attribute of the
CFDiv tag... wish those modifiers were better documented!
Hatton
On Tue, Apr 22, 2008 at 11:11 AM, C. Hatton Humphrey
[EMAIL PROTECTED] wrote:
I'm working on a system where I have a CFForm with two elements - a
CFTree tag and a CFDiv. The CFTree is using the CF8 AJAX to populate
and that is working just fine. I need to synchronize the CFDIV
contents to the selected element on the CFTree, and that is driving me
somewhat batty.
In this instance I'm working with a folder listing on one side and
need the files on the right. It could be any scenario, though -
tables and contents, people and details, etc. I know the answer is
out there (starts humming the X-Files theme) but I'm not searching for
the right words.
So how *do* I update the contents of a CFDiv that is populated using
the bind tag (right now bind=cfc:cfc.files.getFiles({folder}))?
Thanks!
Hatton
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303993
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I thought for sure I could use Username and Password with CFMail tag...
server=user:[EMAIL PROTECTED] is the syntax (or something along those lines) Hatton On Sat, Apr 5, 2008 at 12:47 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... I still got some customers I haven't moved from my CF 4.5 server, but have moved my mail to a new server which requires authentication. I thought I remembered being able to include authentication in the CFMail tag, but adding password=sdfdsfs and username=sdlkfjsldkj caused an error. I've set up the new mail server in the CF Admin, but there's no place in 4.5 to add authentication, so I thought I'd do it in the tag. Is it possible? Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Extracting gzip Files
I'm trying to use zip.cfc to extract an archive in CF8. I'm getting the error: Object Instantiation Exception. with the code: ioInput.init(arguments.gzipFilePath); ioInput is declared as: ioInput = CreateObject(java,java.io.FileInputStream); The file being saved is there, and the extraction path contains the file in the archive but it is locked and empty. So, two questions - first (and most obvious) do I need to use the CFC or can I use CFZip (no reference on QuickDocs about extracting GZip files)? Alternately, has anyone gotten GZip extraction working in CF8? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302503 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Extracting gzip Files
Found my issue, had nothing to do with the CFC! Though to be honest, in looking for a solution to the problem I found a better way to handle the requirement overall. Hatton On Wed, Apr 2, 2008 at 11:48 AM, C. Hatton Humphrey [EMAIL PROTECTED] wrote: I'm trying to use zip.cfc to extract an archive in CF8. I'm getting the error: Object Instantiation Exception. with the code: ioInput.init(arguments.gzipFilePath); ioInput is declared as: ioInput = CreateObject(java,java.io.FileInputStream); The file being saved is there, and the extraction path contains the file in the archive but it is locked and empty. So, two questions - first (and most obvious) do I need to use the CFC or can I use CFZip (no reference on QuickDocs about extracting GZip files)? Alternately, has anyone gotten GZip extraction working in CF8? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302510 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Reseller Hosting
If 7 is okay I'll put 100% recommendation behind Jodohost (jodohost.com) - good prices, great servers. I have been with them since 2003 and while there have been frustrating times they are responsive and efficient in dealing with issues. Hatton On Wed, Apr 2, 2008 at 7:13 PM, Peter Donahue [EMAIL PROTECTED] wrote: Hello everyone, Can anyone recommend a company offering ColdFusion reseller hosting in the U.S.? I had a plan with a host in the UK, but wish to find a U.S. hosting company in the interest of keeping costs down. An Australian reseller host would also work too. Thanks for your help. Peter Donahue ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF RDS Capability question
Been pondering a very odd thing and wondered, I know that CF can FTP to another server, but can one CF instance connect to another via RDS? Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Podcasting - what's involved?
Depends on his intentions. I use a combination of Ray Camden's Blog + FeedBurner (better tracking of RSS and some built in traffic tracking) + TalkShoe.com TalkShoe basically creates a VoIP conference call for every Talkcask. The owner schedules the recording and then calls in using either a phone, the ShoePhone (a java based VoIP phone) or some other VoIP client. The recording is stored on TalkShoe's servers and they promote talkcasts with what's live now and coming up.' Additionally, listeners can call in and join in on the call, join in a text chat and leave comments and reviews. If that's too much for him, you might also look into GCast.com. It's also phone based but instead of being a conference call where people can join in, it's you and a phone recorder ;) Good luck! Hatton On Thu, Mar 27, 2008 at 10:48 AM, Mike Kear [EMAIL PROTECTED] wrote: I've been asked by a client to set up so he can do a podcast every week or so. I'm a bit worried about this because he's not too computer literate,, so i need to take away all the technical stuff for him and make it as idiot-proof as possible. What's the best route to take for me on this do you think? Where should I go to learn what i need to do? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Any Gotcha's in using CF UUID for db record primary key?
The main reason I'm thinking about swapping is so I can eliminate the two-step process of creating, say, a database record for a new Real Estate development community for the textual information, and then requiring a user to click a link with the record id in the URL to add photos for the community. I'd go with Dominic's idea personally. From a DBA perspective I've *hated* apps that used only GUIDs for their PK... especially when I have to either manually enter data or perform manual joins. SELECT * FROM PROPERTY JOIN PICTURES ON PROPERTY.ID = PICTURES.PROPERTYID WHERE PROPERTY.ID = 928 Is lot easier than typing out a 50-odd character string. If you're worried about embedding ID's in your URL, use forms or have a second unique that is your GUID Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 and JasperReports?
Ja, but with CF7 it's an old version, and there are library conflicts with the newer stuff. I think I found a way to run it on CF8, using a classloader, but it's untested. And I don't even know what version 8 has, or if it's still in there, even. I switched to using JasperServer, which has been just freaking awesome. That, my friend, is the way to do reports! Thanks for the reply Denny! I agree that you should let the engine designed to handle the task best, handle it. I was just confused by the messages and blogs that I read in researching. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Baffling Error
I've been going through my error logs on CF8/IIS6, and repeatedly come up with this message (note the URL will be for any site that's on my server, this is an example): I'm with Matt here, it looks like someone, somewhere has a bad link to your site. Your site appears to be functioning perfectly. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Baffling Error
The problem is that there are bots pounding all my sites with malformed urls. I get anywhere from 20 to 100 per day. Is there a way to filter/regex stop that from occuring before it throws an error? Create a custom 404 that is caught by both CF and IIS/Apache that redirects to /index.cfm ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion 8 and JasperReports?
New job uses JasperReports for their PDF report generation. They're running a Tomcat server to provide the services on a different port. While digging around I found messages and blog posts pointing to the fact that CF7 (and by assumption CF8) use JasperReports for the CFReport functionality, is this correct? If it is, how difficult would it be to migrate the existing reports to CF8? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDiv not binding properly?
On Mon, Mar 17, 2008 at 1:36 AM, Mike Harman [EMAIL PROTECTED] wrote: Is the pop-up window a cfwindow or a new browser window? It's a new browser window. The curious thing is that it works on my devel machine but when I pushed the code to a staging environment it does not. Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDiv not binding properly?
script type=javascript
window.opener.ColdFusion.navigate('showfiles.cfm?user=#form.userid#,
'File');
window.close();
/script
Just to update this, I took out the window.close(); code and it works
on the staging environment.
o_O
Hatton
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301415
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDiv not binding properly?
Okay, this one is not making any sense at all to me - it *has* to be a
setting issue but I can't seem to find anything to help.
I have a CFDiv tag - cfdiv id=File bind=url:showfiles.cfm?user=#userid# /
Inside the CFDiv I have a pop-up window that allows the user to edit
or add files. This works just fine and includes the following line of
code at the end of the upload page:
script type=javascript
window.opener.ColdFusion.navigate('showfiles.cfm?user=#form.userid#,
'File');
window.close();
/script
In my development area, a win 2003 box with CF8 dev. everything works fine.
When I upload to staging, the initial page loads fine but when the
ColdFusion.Navigate calls and the window closes all I get is that nice
Loading animation.
I've enabled the AJAX debugging and the GET is being sent but it does
not report any data being returned.
Anyone have any ideas on this?
Thanks!
Hatton
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301407
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating a .cfm file on the fly
(*cough*) BeSavvvy (*cough*) On Wed, Mar 12, 2008 at 7:57 PM, Bruce Sorge [EMAIL PROTECTED] wrote: I have a client who wants me to make a change to a form he has. Currently he has a page that creates a new project that uses a WYSIWYG editor and put everything into a database table. What he wants instead is for the user to add a page name field in addition to the fields he already has, and when the user submits the form, he wants a .cfm page created with the value from the page name field being the file name. Of course I need to put the site's header and footer on there as well. So is there a way that I can create a template, and then when the form is submitted, using CFFILE or something like that to take that template and make a new page with it? Does this even make sense? Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bluedragon = open source
Distribution as I have had it explained to me means bundling BD with some other product, be it physical or software. Hatton On Mon, Mar 10, 2008 at 8:12 PM, Russ [EMAIL PROTECTED] wrote: I guess I was confused by the dual license approach they were talking about. I guess you would only need the commercial license if you intent to distribute your product and don't want to distribute the source? Is that even possible with CF? I mean yea you can encrypt your code, but it's that fairly easily decrypted? Russ -Original Message- From: Tanguy Rademakers [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 9:01 PM To: CF-Talk Subject: Re: Bluedragon = open source The one thing I think I'm reading is that it's still not for commercial use. If that's true, then it's really no better then the free bluedragon product that they're currently offer. They seemed to be open sourcing it just to get some free help with the development of the server. Where did you read that? The way i read it, BD/J2EE will be released under the GPL, minus some 3rd party libs they don't own the IP to. GPL apps may be used in a commercial setting (i.e. you may use them on your client sites, or to run your business site or office intranet - all examples that were verboten with the old BD free license), what you can't do is bundle and distribute them into/with any kind of proprietary or non-GPL product. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: qForms Question
I know I can do this in Javascript but I'm hesitant to roll my own when qForms is already validating the rest of the form (some 15 other required fields). Is there a way to do this in qForms? This should do what you want: http://www.pengoworks.com/qforms/ext/atLeastOne.htm You can use it like: oForm.textareaName.validateAtLeastOne(checkboxName); That should enforce that at least the textarea is filled in or one of the checkboxes is checked. I tried this and it does not seem to be working. I'm not getting any errors on the JS Error console so I know it's *working*. I have all of the formfields created, here is the JS call for qForms: script type=text/javascript objForm = new qForm(catrequest); objForm.catalogtype.description = catalog type; objForm.fldComments.description = general comment; objForm.catalogtype.validateAtLeastOne(fldComments); objForm.required(txtFirstName,txtLastName,txtCompany,txtEmail,txtAddress,txtCity,txtState,txtZip,txtCountry,txtPhone); objForm.txtFirstName.description = First Name; objForm.txtLastName.description = Last Name; objForm.txtCompany.description = Company Name; objForm.txtEmail.description = email address; objForm.txtAddress.description = mailing address; objForm.txtCity.description = City; objForm.txtState.description = State (or Province); objForm.txtZip.description = Zip or Postal Code; objForm.txtCountry.description = country; objForm.txtPhone.description = phone number; objForm.txtFirstName.focus(); /script Do I need to make any changes to the Form code itself? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: qForms Question
Okay, made some changes to the qForms call - script type=text/javascript objForm = new qForm(catrequest); // set the path to the qForms directory objForm.setLibraryPath(/includes/qforms/lib/qforms/); // this loads all the default libraries objForm.include(*); objForm.catalogtype.description = catalog type; objForm.fldComments.description = general comment; objForm.catalogtype.validateAtLeastOne(fldComments); objForm.required(txtFirstName,txtLastName,txtCompany,txtEmail,txtAddress,txtCity,txtState,txtZip,txtCountry,txtPhone); objForm.txtFirstName.description = First Name; objForm.txtLastName.description = Last Name; objForm.txtCompany.description = Company Name; objForm.txtEmail.description = email address; objForm.txtAddress.description = mailing address; objForm.txtCity.description = City; objForm.txtState.description = State (or Province); objForm.txtZip.description = Zip or Postal Code; objForm.txtCountry.description = country; objForm.txtPhone.description = phone number; objForm.txtFirstName.focus(); /script Now in the JS Error console I get: objForm.setLibraryPath is not a function ?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: qForms Question
You've also got to include the function that on in the page on: http://www.pengoworks.com/qforms/ext/atLeastOne.htm That code exists in /includes/qforms/lib/qforms/validation_addon.js that's why I thought forcing the include would work. (*scritch*) Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
qForms Question
I've inherited a form that is using qForms for validation. The form includes a series of three checkboxes, all with the same name but different values, further down there is a textarea. The client has asked for a validation rule that requires either one of the checkboxes to be checked, the textarea to contain a value or both. If the user does not check a box or enter something in the texarea, a validation message needs to appear. I know I can do this in Javascript but I'm hesitant to roll my own when qForms is already validating the rest of the form (some 15 other required fields). Is there a way to do this in qForms? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: qForms Question
BTW - Thanks for the quick answers! Hatton On Wed, Mar 5, 2008 at 3:21 PM, Tom McNeer [EMAIL PROTECTED] wrote: Dan, It's not a perfect solution--since you need to attach the validation to one of the fields, but that custom method will do the trick for those validate either a or b type of situations. Seems pretty good to me. So -- the method you specified will validate that EITHER one of the checkboxes is checked OR there is content in the textarea? That's the sort of thing where I always added a custom validator or at least used an Expression. Are there other examples on your site, or elsewhere, that go into this sort of validation of related fields? I must have missed them. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Feature Creep - Wants More Search Stuff ...
If you were using verity it'd be easy - cfsearch name = search_name collection = collection_name category = category[,category2,...] categoryTree = tree_location status = type = criteria criteria = search_expression maxRows = number startRow = row_number suggestions = suggestion_option contextPassages = number_of_passages contextBytes = number_of_bytes contextHighlightBegin = html_string contextHighlightEnd = html_string previousCriteria = criteria language = language The contexthilightbegin and contexthilightend would do it for you. Hatton On Tue, Mar 4, 2008 at 9:29 AM, Les Mizzell [EMAIL PROTECTED] wrote: Now they're asking - hey, when we see the search results, can we see the specific sentence that contained the keyword and highlight it? CF7 - by the way ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Microsoft Live Office
link? On Tue, Mar 4, 2008 at 3:39 PM, Don L [EMAIL PROTECTED] wrote: Has anyone tried that? And what's your experience with it? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFImage Error... Unsupported Image Type??
I've just finished working on a photo gallery and now that the client is using it she has an image that is coming up Unsupported Image Type Funny thing is that it's a JPEG that she cropped in Photoshop. Any ideas? Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFImage Error... Unsupported Image Type??
Can't tell if it was CMYK or RGB. Here's what I know from looking at the image: File Size: 640k 440px x 250px (the size of the gallery viewer) Resolution: 300dpi (grr... the bane of my existence) Bit Depth: 24 Resolution Unit 2 Color Representation Unknown That is what Vista has to say about the image. On Fri, Feb 22, 2008 at 4:49 PM, Dennis Powers [EMAIL PROTECTED] wrote: it's a JPEG that she cropped in Photoshop. She most likely saved it as a CYK image. Does the CFImage tag handle CMYK images? Dennis Powers UXB Internet - A website design and Hosting Company http://www.uxbinternet.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I ma stuck here . In coldfusion query
Looking at the query: select menuId, label, foundOn from dbo.menu where menuId IN ( select foundOn from dbo.menu where menuId=#form.selTopLevel2#) order by menuId would indicate that FoundOn is a varchar type field and menuid is an integer. Perhaps you rewrite the query to match where foundOn IN () though to be honest I'm not sure why you're doing a subquery. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I ma stuck here . In coldfusion query
Actually he can select menuId, label, foundOn from dbo.menu where CAST(menuId AS VarChar(10)) IN ( select foundOn from dbo.menu where menuId=#form.selTopLevel2#) order by menuId Again, it's a messy messy solution and linking tables are called for. That said, given what he's got to work with Hatton On Wed, Feb 20, 2008 at 3:56 PM, Rick Root [EMAIL PROTECTED] wrote: Definately can't use the IN clause for this. That's not what it does. If you insist on not changing your data structure you could try something like this. where ','+foundOn+',' LIKE '%,#value#,%' But.. dear god, I'm going to be struck by lightning for even suggesting that! FORGIVE ME SQL GODS ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I ma stuck here . In coldfusion query
That wouldn't work though, because menuId is going to be a single number.. even if casted to a string. foundOn is a string containing a comma separated list of values. You're right. I even went to the length of creating a table on my db server to prove I was right and I was wrong. Understand, I had to name my table testing and the join is U G L Y but here's how I got the results erik's looking for: select DISTINCT t1.menuId, t1.label, t1.foundOn from testing t1 inner join testing t2 ON t2.foundon LIKE '%,' + CAST(t1.menuId AS VarChar(10)) + ',%' OR t2.foundon LIKE CAST(t1.menuId AS VarChar(10)) + ',%' OR t2.foundon LIKE '%,' + CAST(t1.menuId AS VarChar(10)) OR t2.foundon = CAST(t1.menuId AS VarChar(10)) where t2.menuid = 6 order by t1.menuId You would need to replace testing with menu and the 6 with your cfqueryparam Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Box has been attacked by cowboy
Have you blocked traffic from that IP at the firewall yet? Also, when I did a lookup of the IP, it was traced to a different domain for a company that provides hosting (gege-hosting.com) but it is not coming up any more. An online scan of the IP shows that the only open access is via windows Remote Desktop The company that you traced it to is a hosting company, they sell dedicated machines. My first step would be to contact them at http://www.softlayer.com/about.html. Best of luck! Hatton On Fri, Feb 15, 2008 at 12:52 PM, Don L [EMAIL PROTECTED] wrote: Yesterday around 7pm EST my box has been ruthlessly attacked (port scan and then data/schema alternation) by 75.126.166.15, which traced to SoftLayer Technologies, Inc. in TX. My course of actions: a) prepare a law suit; b) inform FBI. On b), I don't know if I should inform FBI branch in TX or just own state or both. Evil doers must be stopped soon. Your thoughts would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help - data extraction tool
I know that I can build something to do this with relative ease but I'm wondering if there is something that already exists that I can use: We've built site for client based on relational database. Some of the attributes are Many to Many relations. Client provides us with spreadsheet of data to import that contains comma separated value list of attributes. In some cases, said value list spans multiple rows. Besides throttling the client, my goal is to have a spreadsheet (or table, which is where the data will end up) with something closer to a many-to-many feel with item number/name in one column and attribute value in another. Then I can write an INSERT statement to make the correct tie using joins. Anyone have such beastie that I can borrow? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dollars ($$$) On the Net It's Your Card
Has anyone sold/implemented these? We've got a client that wants to sell gift certificates for their physical locations and allow for print or physical delivery; their service looks like a perfect fit but we need some insight on implementing it. Anyone? (*bump*) Has anyone worked with this company? The main company is Shift4 (cute name) and they have a card processor called Dollars on the Net and a gift card system called It's Your Card. Anyone? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dollars ($$$) On the Net It's Your Card
Has anyone sold/implemented these? We've got a client that wants to sell gift certificates for their physical locations and allow for print or physical delivery; their service looks like a perfect fit but we need some insight on implementing it. Anyone? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Email Verification Tool
Okay, I'm looking at an interesting situation when it comes to sending out mass emails. We've got a client with about 9000 email addresses on their list and some 2000 are invalid Yahoo and AOL accounts. When they send, our mail server gets blacklisted. Unacceptable. My original though was to have a tool that used telnet and rcpt to commands to validate the email addresses. I've been asked to find out if there is anything out there that will do this already. I found the HexGadget components at http://hexillion.com/hg/ and wonder if it's as simple as that (and if it's fast enough). I've found http://www.pivo.com/Default.aspx?page=featuresproduct=emailvalidator the Pivo validator as well. These are COM objects that appear to handle the tasks. Any thoughts or suggestions? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email Verification Tool
Not looking at bounced emails, need to scrub the email list BEFORE messages get sent. On Jan 30, 2008 2:12 PM, Russ [EMAIL PROTECTED] wrote: Boogiebounce? Basically you need to collect your bounces somewhere where you can process then with CF. You can use boogiebounce to see what type of bounce it is, and clean up any bad bounces off your list. Russ -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 1:58 PM To: CF-Talk Subject: Email Verification Tool Okay, I'm looking at an interesting situation when it comes to sending out mass emails. We've got a client with about 9000 email addresses on their list and some 2000 are invalid Yahoo and AOL accounts. When they send, our mail server gets blacklisted. Unacceptable. My original though was to have a tool that used telnet and rcpt to commands to validate the email addresses. I've been asked to find out if there is anything out there that will do this already. I found the HexGadget components at http://hexillion.com/hg/ and wonder if it's as simple as that (and if it's fast enough). I've found http://www.pivo.com/Default.aspx?page=featuresproduct=emailvalidator the Pivo validator as well. These are COM objects that appear to handle the tasks. Any thoughts or suggestions? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Paperthin's Commonspot
The thing I didn't like about it was that they encrypt all the files so you can't really see or modify it. There might be an option to get an unencrypted version, but I don't really know, I never explored it. I'm working with BeSavvy right now and it's the same way - there is an unencrypted version that would allow us to modify and deploy code but we have to deploy it encrypted. The logic behind that is simple - intellectual property. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CMS Solution Recommendations
Can anyone recommend a Coldfusion CMS solution? Also, is your recommendation currently supported? I look at FarCry and it seems that the web site and code hasn't been updated in 2 years? I have recently become a BIG fan of BeSavvy. That is where I was recommended some time back and I will wholeheartedly forward that recommendation. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
This Again - CF Learning Resources
So I've been told that we have two people that need to learn CF (they have basic programming skills and are good with HTML/CSS) but that I can't, become a full time instructor here. My thought is to get each of them set up with a developer edition of CF8 and point them to a tutorial site that can step them through CF concepts and have them email or IM me with questions. I have the new CFWACK and have suggested book 1 as required reading for them as well. Question is this - is there a site out there that provides tutorials in a fashion that I mention (allows them to learn CF incrementally)? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: This Again - CF Learning Resources
why not send them to the adobe training class? Three days and they'll get the soup-to-nuts training they need. Can't take them off their current production requirements. They're learning on their own time. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: zip code range from xls to sql
bump.. any ideas how to do this? Hrm... it sounds to me like the logic is such that you're going to be better off making use of an array or structure to parse out the values. SQL doesn't have access to complex variable types. I would suggest creating an array of structures... each structure would contain a start value and stop value. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is it possible to open cfml page from sql server stored procedure?
My goal is to run a series of stored procedures. At one point, while I run the stored procedures, I need to run coldfusion code which has a cfquery tag and some complex if and else conditions which are easier done in coldfusion than t-sql. I would think that if it is conditionals (regardless of the complexity) that it would make more architectural sense to do everything within SQL. Granted, you may want to build a user defined function to handle the comparisons, but that would be more effective and portable than utilizing WGet or cURL. If you go the route of the executables, you will need to obtain them and install on your server. Neither are included with Windows. Your other option would be to move everything into CFML. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFSelect Required not working right?
The blank option comes through as a part of the CFC results... however I found the solution yesterday on a couple of different blogs. Apparently the coding that Adobe used for the CFForm.js validation script is only initially built to handle the MULTI select when facing a required. I had to modify it to correct the problem, as noted here: http://www.beetrootstreet.com/blog/index.cfm/2007/1/8/CFFORM-doesnt-catch-unselected-dropdown-lists-when-requiredtrue Hatton On Jan 25, 2008 6:28 AM, Azadi Saryev [EMAIL PROTECTED] wrote: and where's you blank option which is required for the 'required' attribute to work? --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com C. Hatton Humphrey wrote: I'm working on a CFForm with a CFSelect that is required. According to the LiveDocs you the required attribute requires a blank option to work... I've got the element, I have required=Yes and I have a message element but it's still not validating on submit. Any ideas? Here's the cfselect in question, the blank option is built into the recordset. cfif Evaluate(ThisRecord.#ListGetAt(variables.FormColumnList, x)#) EQ 0 cfset SelectedElement = cfelse cfset SelectedElement = Evaluate(ThisRecord.#ListGetAt(variables.FormColumnList, x)#) /cfif cfselect enabled=Yes name=#ListGetAt(variables.FormColumnList, x)# query=selectdata value=#ListFirst(ListGetAt(variables.FormMaxLengthList, x), ~)# display=#ListLast(ListGetAt(variables.FormMaxLengthList, x), ~)# selected=#SelectedElement# required=Yes message=#ListGetAt(variables.FormMessageList, x)# style=font-size: 12px;/cfselect ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFSelect Required not working right?
I'm working on a CFForm with a CFSelect that is required. According to the LiveDocs you the required attribute requires a blank option to work... I've got the element, I have required=Yes and I have a message element but it's still not validating on submit. Any ideas? Here's the cfselect in question, the blank option is built into the recordset. cfif Evaluate(ThisRecord.#ListGetAt(variables.FormColumnList, x)#) EQ 0 cfset SelectedElement = cfelse cfset SelectedElement = Evaluate(ThisRecord.#ListGetAt(variables.FormColumnList, x)#) /cfif cfselect enabled=Yes name=#ListGetAt(variables.FormColumnList, x)# query=selectdata value=#ListFirst(ListGetAt(variables.FormMaxLengthList, x), ~)# display=#ListLast(ListGetAt(variables.FormMaxLengthList, x), ~)# selected=#SelectedElement# required=Yes message=#ListGetAt(variables.FormMessageList, x)# style=font-size: 12px;/cfselect ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Selling Documents
The first thing that comes to mind is how do you let them see what's in a document without giving it away? * Store the files in a directory that is not web accessible , then copy the requested file to a temporary download area for download. * Store the files in a directory that is not web accessible , then use CFFIle to read the file into memory and CFContent to deliver it. Couple of different options, really. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flatten out a relational database
It's not a simple join that you're looking for. You'll need to make use of an index and temporary table. What is the database engine you're using for this? Hatton On Jan 23, 2008 7:35 PM, David Mineer [EMAIL PROTECTED] wrote: I need a query that will flattion out a relational database. I have 2 objects. Permits and Companies. Right now you enter a permit, then you can add 1-n companies and attach them to that permit. A query would return Permit Info 1-Company1 2-Company2 etc... I want to return Permit Info,Company1,Company2 This smacks of a crosstab or pivot query, but I am not sure how to make it work, or if either of those are a good solution. I don't just want: permit info,company1 permit info,company2 That is just an easy join. TIA, -- David Mineer Jr - The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spell Checker
But seriously, anyone have any good suggestions? I looked into the opensource 'aspell' but it seems more trouble than it would be worth. (download the compiler, download the compiler to compile the compiler, download the compiler that compiles the compiler) William - If you're trying to compile ASpell then something is seriously wrong. In order to do server-side spell checking you can implement a couple of different options... they include installing a spell-checking application such as ASpell. I've gotten this to work with FCKEdit and such. Another option is to make use of a client-side spell checker like ieSpell or Firefox's integrated spelling services. Thirdly are web based spelling services. http://wiki.fckeditor.net/Developer%27s_Guide/Configuration/Spell_Checker has information on some spell checking tools. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spell Checker
what is the server environment? On Jan 10, 2008 3:50 PM, William Seiter [EMAIL PROTECTED] wrote: There are some great suggestions here. (even the don't use words after 2003 suggestion, ;-) ) When this is eventually launched, the Googiespell limit (1000 words) will probably be used up by midday. (several active sites). I was really into it until I saw this limitation. I have found pure javascript solutions, but they seem too heavy and too slow. foundeo is the one that I have on my system for evaluation right now. Speller Pages at sourceforge.net is the one that requires aspell to be compiled (an on and on) I am trying to avoid building it from scratch as: 1. I have a deadline 2. It would cost more to build from scratch than to buy a pre-made system that runs quick and smoothly. Thank you all very much. If there are any other suggestions, please let me know. William Hey all, I am looking for a good spell-checker program for one of my sites. I was hoping someone here can point me in the right direction. I have spellcheck-cf from cfdev.com but: 1. my boss wants me to try more versions before we decide 2. it doesn't appear to have been updated recently (2003?) I am looking for something that is written from CF and Javascript, but I am willing to consider PHP or Perl, if it is simple to migrate. I am working on a deadline, as always. William ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
+6 for CFWebStore - that's how many installations we have going right now, with a few more coming down the pike soon. Pros: * It's fusebox based. * It's got solid documentation * It's completely skinnable and modifyable * It has everything you're talking about except one - Quickbooks For the QuickBooks integration, that requires a product called T-Hub by Atandra along with some custom coding on your part to build the interface. If you want to email me off-list I can talk more to that. Definitely worth the cost! Hatton On Jan 7, 2008 8:31 PM, Mary Jo Sminkey [EMAIL PROTECTED] wrote: We're looking for something already existing that can track inventory, accept gift certificates/discounts, PayPal, (possibly with an extention to tie into Quickbooks) to name a few. I think the closest products to what we want would be similar to ZenCart or ProductCart. Does anyone have any ideas for me? Be sure to check out CFWebstore as well (www.cfwebstore.com). It can handle these kinds of things (and much more!) and has very high ratings from users on the Adobe Exchange, Hotscripts, etc. Feel free to email me directly if you have specific questions you'd like addressed. We do have an active peer-to-peer user group where you can direct questions as well. --- Mary Jo Sminkey [EMAIL PROTECTED] http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
For the QuickBooks integration, that requires a product called T-Hub by Atandra along with some custom coding on your part to build the interface. If you want to email me off-list I can talk more to that. Hey Hatton, I'd be interested in hearing what you did with T-Hub. T-Hub acts as an SOAP/XML intermediary between the Quickbooks API and any web interface. In short, it handles 4 basic transaction types spanning 3 Levels: Level 1: Order Export - Sends a basic request asking for orders. The store has to return an XML structure that contains ALL information about the order including customer details (bill and ship to), payment details (method, discounts, gift certificates, extra charges), and all product details. This level of integration can be done with any store that will dump said information in a CSV file OR can be done via the XML method provided certification is attained (see note below). Level 2: Order Payment Status Update - Since T-Hub monitors Quickbooks, as soon as a payment is made on an invoice the system can be triggered to update the payment status on the website. This happens via a SOAP request where T-Hub sends a packet that includes the order number and other specifics. The web store has to acknowledge receipt of the data. It must be certified by Atandra. Order Shipment Status Update - Same as Payment, only with shipping information. Level 3: Product Inventory/Price Import - T-Hub collects the information about the products in the QB database and sends them via XML to the web store. The store must be able to dynamically add product, manufacturers, categories and update price and inventory. Certification is needed for this step. What is this certification? Atandra will certify that a store software package works with T-Hub for a fee. We have a client that needs only Level 3, but that fee is $750. We have passed that cost on to the client and are working on a client specific version of the integration code at this time. We have two other clients that are interested in the rest of the integration and are planning on building out complete integration to the T-Hub standards as soon as they commit to the quote. Certification provides a few different things. The main one being that they list packages that have been certified. It's quite the interesting business model. They built this tool to interface between QB and web... and if a web package wants to be okayed to interface with T-Hub you have to pay THEM money to test YOUR code. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql clear data
He wants to clear all *columns*, not rows. There is no real way to do this in a single SQL statement. Mark's suggestion of doing a single query to get the column names and then a second to do the update is a way to do it, if you wanted to do it all in SQL it's possible in SQL Server or MySQL by making use of a cursor and the information schema. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need a coldfusion expert and opinion... I am stranded..HELP
List - Apologies for sending this directly... I changed the TO: but apparently GMail had other ideas. Hatton Alex - I'm not sure if you've gotten any other replies for this message yet or not... your post came through at a time when most that are active on this list are sleeping (and those that aren't are working). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need a coldfusion expert and opinion... I am stranded..HELP
On Dec 27, 2007 2:41 AM, Alex Snowden [EMAIL PROTECTED] wrote: I have this music website and the designer basically left me stranded. I have been looking for a decent low-mid cost cold fusion designer/programmer for 6 months. I haven't found anyone? I looked on craigslist, get a freelancer, and even various website forums and no luck. Pretty much my investment is being drained. But I constantly find designers who BS and really never do the job as I wanted. Alex - I'm not sure if you've gotten any other replies for this message yet or not... your post came through at a time when most that are active on this list are sleeping (and those that aren't are working). First, I would suggest posting your need to the CF-Jobs list, there are contractors and firms that monitor that list on a daily basis that can contact you regarding the need. I would offer to help you out but my level of commitment would be minimal right now because of other commitments. If you want, I can offer to help make as many changes as I can on a singleton basis by quote while you look for another solution. My personal rate for contract work is $45/hr which becomes the basis for my quotes... however on quote jobs what you're quoted is what you pay. Secondly, I'm sorry that you've had such a hard time finding someone! Hopefully this list and the CF-Jobs list can help you out! You're going to find rates that vary wildly - in my own look for contractors for my work I've been offered between $30 and $150. You *will* be contacted by a number of agencies as well as individuals but I'm sure you're used to that after craigslist and getafreelancer. To be honest I have not found a single reliable resource on either list. Best of luck! Regards, Hatton Humphrey [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FCKEditor Integration with CF8 for cftextarea use
Any more problems, however, I will probably give Rick's CFFM with TinyMCE a try. I ended up doing that Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Image question...
The thing I wish it would do is add a permanent watermark on uploaded images instead of only on temp png while being shown. You can do this: 1. Read in original image 2. Read in watermark image (transparent GIF) 3. Set transparency of watermark image to 20-30% Either: 4. Mathematically locate position of watermark OR 4. Resize watermark image to size of original (in memory) THEN 5. Overlay watermark image on original image FINALLY 6. Rewrite original image to drive. This is something that can take the server some time to do - I would suggest using asynchronous processing or scheduled task to handle this. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating links like http://www.mydomain.com/SomeIDValue
you'll need to use IIS to redirect 404's to a CF template and have it parse the URL called to action. Hatton On Dec 15, 2007 1:43 PM, Jason Fill [EMAIL PROTECTED] wrote: I would like to be able to set a system up so we can have urls like http://www.mydomain.com/SomeIDValue. Basically the /SomeIDValue would be like a memberID. Of course I don't want to create directories for each ID value. It would be similar to how MySpace does it, http://myspace.com/myname etc. Does anyone have any insight as to how I can make this work? Thanks in advance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recommend web design training
Amen to Sandy. She's our go-to person for CSS. I didn't know she did any training in creative design and graphics production techniques, but if she does then I'd jump on it if I were you. Funny how these topics come up right when my boss is asking me to look for a resource. We've got a client who's site MUST be 100% 508 compliant. I was asked to see if I could find someone to contract the work through. If anyone's interested, take a look at my post on the CF-Jobs list at http://www.houseoffusion.com/groups/cf-jobs/thread.cfm/threadid:4803#6077 Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Compare two tables
QoQ? On Dec 14, 2007 10:57 AM, Ian Skinner [EMAIL PROTECTED] wrote: Anybody have a creative way to compare data in two tables and find all records in table A not in table B and vice-a-versa. The data share a common key, 'License Number'. The trick -- Table A is in an MS Access Database and Table B is in a MS SQL server database. They are not aware of each other and we can not import the Access data into the SQL database at this time at least. TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
