Re: Opening Local Files
On Mon, Aug 25, 2014 at 9:39 AM, Richard White 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 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 wrote: > 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
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 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 > wrote: > > > > > > http://hesab.net/book/asp.net/devedit_aspnet_demo/DevEditSetupGuideNET.pdf > > > > > > On Mar 27, 2014, at 10:06 AM, C. Hatton Humphrey > > 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
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: CF to groovy, awe man wth...
On Mon, Mar 17, 2014 at 9:59 AM, Dave Watts 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 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 wrote: > > 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 wrote: > > 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 > wrote: > > > > > 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: .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 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
> 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
> 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
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 wrote: > > longest. subject. ever. > :) > > On Tue, Feb 3, 2009 at 12:16 PM, Jochem van Dieten wrote: > >> >> 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
> 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: 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: 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? > > > > 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: 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 : 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
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
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: 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=Publisher&letter=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: 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=Publisher&letter=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: 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
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
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: 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
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
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
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
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: 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
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: 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
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?
> >window.opener.ColdFusion.navigate('showfiles.cfm?user=#form.userid#", > 'File'); >window.close(); > 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
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
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 - 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: window.opener.ColdFusion.navigate('showfiles.cfm?user=#form.userid#", 'File'); window.close(); 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
> 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
Re: qForms Question
Okay, made some changes to the qForms call - 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(); 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
> >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: 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(); 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
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
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: 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
Re: Feature Creep - Wants More Search Stuff ...
If you were using verity it'd be easy - 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: 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 C 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
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: 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 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: 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
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: 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
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: 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=features&product=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
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=features&product=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: 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
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
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: "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 in question, the blank option is built into the > > recordset. > > > > > > > > > > > Evaluate("ThisRecord.#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;"> > > > > > > ~| 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
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
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 in question, the blank option is built into the recordset. ~| 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: 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
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: 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: 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: 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: 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: Reading NMEA-183 Messages off Com Port w CF?
> Are there any other resources out there that I would be able to > use in conjunction with ColdFusion? Is there a Java library that > can be redistributed with a commercial app? Some thoughts on this - 1) If you are running CF8 you can broaden your search to C++ as well as .NET... CF7, it's C++ or Java. 2) If you can't find a library to communicate with the device directly, perhaps you might want to find an EXE that will pull the data from the device via command line and then use CFEXECUTE to call it. 3) If you're wanting to stream data from the unit you could use a tool like the one in #2 but have a scheduled task run it and dump the output into a text file that you could then parse with CFFILE. Sounds interesting though, I'm curious what the desired end result is. 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:294858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare two tables
Just a thought, Ian, but you might try this solution versus doing a QoQ with lists versus doing a nested loop to test for matches and see which one actually works better for you performance-wise. If you've got 40k records, that's a lot of data to be shuttling back and forth! On Dec 14, 2007 1:14 PM, Ian Skinner <[EMAIL PROTECTED]> wrote: > Aha! That is the kind of outside the box thinking for which I was > looking. Presuming that the SQL DSN user has Create permission (50/50 > chance) this could work nicely. I'll pass it on to the co-worker > dealing with this issue. He is having trouble with this HOF account, > see CF-OT post to that affect. > > Thank You > Ian > > > Adrian Lynch wrote: > > You wouldn't have to "import the Access data into the SQL database", sorry, > > you started the with the quotes ;O). You can just select the data from > > Access, loop over it and generate the SQL in insert into a temp table. > > Something like... > > > > > > QUERY THE ACCESS DATA HERE > > > > > > > > > > CREATE #temp (COLUMNS GO HERE) > > > > > > INSERT INTO #temp (COLUMNS GO HERE) VALUES (VALUES GO HERE) > > > > > > SELECT FROM THE SQL TABLE HERE > > > > > > > > Why would you do this? Well, you now have all the Access data in SQL Server > > and have available all the functions and constructs. One that might be > > interesting is CHECKSUM and BINARY_CHECKSUM which I don't think is available > > in Access. > > > > Interesting post. > > > > Adrian > > > > -Original Message- > > From: Todd [mailto:[EMAIL PROTECTED] > > Sent: 14 December 2007 17:33 > > To: CF-Talk > > Subject: Re: Compare two tables > > > > > > "we can not import the Access data into the SQL database at this time at > > least." > > > > On Dec 14, 2007 12:11 PM, Dawson, Michael <[EMAIL PROTECTED]> wrote: > > > > > >> Since everyone else mentioned QoQ, another option would be creating a > >> temp table in SQL, loading the Access records, and then doing the query. > >> > >> M!ke > >> > >> -Original Message- > >> From: Ian Skinner [mailto:[EMAIL PROTECTED] > >> Sent: Friday, December 14, 2007 9:57 AM > >> To: CF-Talk > >> Subject: Compare two tables > >> > >> 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:294832 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
Scratch that idea - I just re-read the quickdocs and QoQ doesn't support joins at all. (*grumble*) Just saw where you found a possible solution... yay! On Dec 14, 2007 1:03 PM, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > > Yeah, this is a case where it would be nice if QofQ had more > > capability. This would be simple with the ability to do an outer join > > between the tables. Luckily it only needs to be done once, or at least > > only a few times until it is determined what is out of sync between the > > old version (Access) and the new version (SQL) and it is reconciled. > > You can't do sub-selects but I'm pretty sure you can do outer joins... > > SELECT A.ID, A.LicenseNumber, B.ID, B.LicenseNumber > FROM qOne A LEFT OUTER JOIN qTwo B ON > A.LicenseNumber = B.LicenseNumber > WHERE B.ID IS NULL > > That *should* return all of the records in qOne that don't have a > match in qTwo... work with it from there for the rest ;) > > 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:294831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare two tables
> Yeah, this is a case where it would be nice if QofQ had more > capability. This would be simple with the ability to do an outer join > between the tables. Luckily it only needs to be done once, or at least > only a few times until it is determined what is out of sync between the > old version (Access) and the new version (SQL) and it is reconciled. You can't do sub-selects but I'm pretty sure you can do outer joins... SELECT A.ID, A.LicenseNumber, B.ID, B.LicenseNumber FROM qOne A LEFT OUTER JOIN qTwo B ON A.LicenseNumber = B.LicenseNumber WHERE B.ID IS NULL That *should* return all of the records in qOne that don't have a match in qTwo... work with it from there for the rest ;) 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:294827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.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
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: Well, that a bummer... cftextarea...
+1 On Dec 11, 2007 10:33 PM, Will Tomlinson <[EMAIL PROTECTED]> wrote: > Try tinymce + rick's sweet cffm. > > I had the same prob with fcked. > > > Will > First user of CF9) > > > > ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4