Re: SOT: Canadian CF Hosting
On Wed, Sep 29, 2010 at 10:45 AM, Larry Lyons larrycly...@gmail.com wrote: Pardon for the slightly off topic posting, but I thought I'd try the collective wisdom of the list here. Anyhow this is a favour I'm doing for a colleague. He's looking for a Canadian web hosting firm that offer CF as part of the package. Does anyone have recommendations? Many years ago, I took a Paperthin class with someone who worked for this company: http://www.netkeepers.ca I'm not sure they do the level of hosting you are looking for, but it might be worth a shout to them to ask, and if not see who they would recommend ~| 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:337637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfreport rtf images
I have a cfreport that needs to have images in the footer. The images are working fine if I output the report in PDF or Flashpaper, but don't show up in RTF or Excel (RTF is the needed output). Things I've tried: -using URLs, file paths, and blobs from the db...same result with each -using jpeg and gif as the source image...same result This is on a Win2003 CF8 Ent box. Any ideas? Anybody use cfreport? ~| 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:322869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfreport rtf images
OK, I answered part of my own question. The RTF output has a empty box placed over the image for some reason (I mistakenly thought that was its attempt to show the image). Now to figure out how to have it not show that box. On Thu, May 28, 2009 at 9:08 AM, Jim Wright wright...@gmail.com wrote: I have a cfreport that needs to have images in the footer. The images are working fine if I output the report in PDF or Flashpaper, but don't show up in RTF or Excel (RTF is the needed output). Things I've tried: -using URLs, file paths, and blobs from the db...same result with each -using jpeg and gif as the source image...same result This is on a Win2003 CF8 Ent box. Any ideas? Anybody use cfreport? ~| 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:322876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfreport rtf images
Final answer, if anyone ever has this issue: There is a Transparency attribute that defaults to Opaque on the image object. In Flashpaper and PDF, the image shows up with that set...in RTF, it puts a box over top of it. ~| 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:322882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Help
On Tue, Sep 16, 2008 at 8:58 AM, Jeff F [EMAIL PROTECTED] wrote: I've got a table (MySQL) with about 20k records. I'd like to be able to get all fields from the table with distinct email addresses. Essentially, I'm weeding out records with duplicate email addresses. What I'm trying does not work: SELECT mytable.lastname, mytable.firstname, mytable.city, mytable.state FROM mytable WHERE mytable.email in (select distinct mytable.email) What you are doing there will return every record in the table. If you really want to eliminate any records where there are duplicate emails, you could do this: SELECT mytable.lastname, mytable.firstname, mytable.city, mytable.state, mytable.email FROM mytable GROUP BY mytable.email HAVING count(mytable.email) = 1 ~| 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:312579 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Help
On Tue, Sep 16, 2008 at 10:13 AM, Jeff F [EMAIL PROTECTED] wrote: SELECT distinct mytable.email FROM mytable I get 19588 as a recordcount. This number would include email addresses that are duplicated in the table (but only a count of 1 for each distinct address). SELECT mytable.lastname, mytable.email FROM mytable GROUP BY mytable.email HAVING count(mytable.email) = 1 I get 19162 as a recordcount. ?? This recordcount eliminates any email addresses that are duplicated in the table. Note that any email addresses that are duplicated are NOT INCLUDED in the results using this method. ~| 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:312587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trying to use cfexecute to run batch file...
On Sat, Sep 6, 2008 at 8:17 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Trying the cfexecute this way didn't work, either: cfexecute name=c:\windows\systems32\cmd.exe arguments=/c e:\adobe_site\getfiles.bat timeout=30 /cfexecute I'm guessing the context of the cfexecute is some other directory than what you actually want it to be. Change your directory in your batch file with: cd c:\adobe_site That way it can find the ftp command file. Alternatively, you can put in the full path to the ftp command file: ftp -s:c:\adobe_site\getfiles.txt and within that command file you could change your the local directory to wherever you want the files dumped: lcd c:\somedirectorywhereiwantthefiles\ ~| 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:312114 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) URL Hack Attempt Leaves Me Scractching My Head...
On Thu, Jul 24, 2008 at 10:52 AM, Claude Schneegans [EMAIL PROTECTED] wrote: It may be a silly question, but why a SELECT * will brake because an unused column was dropped? It shouldn't make a difference if the SELECT * is in a cfquery (though that is bad practice, too), but if it is in a view, it will break...such as this example(in SQL Server, at least)... CREATE TABLE tmpTest(foo int,bar int) GO CREATE VIEW tmpView AS SELECT * FROM tmpTest GO SELECT * FROM tmpView --Works correctly GO ALTER TABLE tmpTest DROP COLUMN bar GO SELECT * FROM tmpView --Throws error ~| 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:309606 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) URL Hack Attempt Leaves Me Scractching My Head...
On Thu, Jul 24, 2008 at 11:20 AM, Claude Schneegans [EMAIL PROTECTED] wrote: A very particular situation though. Perhaps, but the following demonstrates how this kind of issue can be even more problematic when the table is changed in such a way that no error is thrown by the view... CREATE TABLE tmpTest(foo1 int,bar2 int) GO INSERT INTO tmpTest VALUES(1,2) GO CREATE VIEW tmpView AS SELECT * FROM tmpTest GO SELECT * FROM tmpView --Note the column names and the associated values GO ALTER TABLE tmpTest DROP COLUMN foo1 GO ALTER TABLE tmpTest ADD foo1 int GO UPDATE tmpTest SET foo1 = 1 SELECT * FROM tmpView --Note the column names and the associated values (and no error being thrown) ~| 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:309645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Load testing software for website with AD integrated authentication
On Wed, Jul 23, 2008 at 3:18 PM, Burns, John D [EMAIL PROTECTED] wrote: Can anyone confirm this or point us toward a product that does it? This may do what you need http://www.iis.net/downloads/default.aspx?tabid=34g=6i=1466 ~| 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:309544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
On Mon, Apr 21, 2008 at 10:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. The links for embedding a youtube video and viewing the page for that video are different. If your users are putting in the URL that links to the main video page, it will not work...you will need to parse out the unique id for that video, and then use the correct URL... The main video link looks something like... http://www.youtube.com/watch?v=eBGIQ7ZuuiU; The embedding video link looks something like... http://www.youtube.com/v/eBGIQ7ZuuiU; ~| 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:303872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
On Mon, Apr 21, 2008 at 2:34 PM, Torrent Girl [EMAIL PROTECTED] wrote: Is that all of your code? If not would you mind posting it all. The code that I am using is very similar to the code you postedit just makes sure to use the correct URL. ~| 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:303924 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 - Database schema compare/sync tools for MSSQL
On Thu, Apr 3, 2008 at 11:16 AM, Gerald Guido [EMAIL PROTECTED] wrote: Does anyone know of a good tool that compares and/or syncs up Database schema's for two tables/DBs. I want to grab fresh data off of production and at the same time not have to manually update the schema for all the changes I made. SQLYog for MySQL has a great tool that will generate the SQL to compare and sync up the schema (and data FTM) for two tables/db's We are on 2005 standard. While you can't really go wrong with Red-Gate, as many people have recommended...I'd also take a look at Apex: http://www.apexsql.com/ ~| 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:303254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to write this query?
On Sun, Apr 13, 2008 at 8:27 AM, Kris Jones [EMAIL PROTECTED] wrote: How about something like: select sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks03, sa.list_price, (select top 1 sap.photo_filename from smlc_acr_photos sap where sap.photo_mls_number = sa.mls_number) as photo_filename from smlc_acr sa order by sa.list_price The only thing you may want to consider here is to include an order by on the subquery so that you get the first photo you want. If you have a unique and predictable (1,2,3) order by field, you could also do something like: SELECT sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks03, sa.list_price,p.photo_filename FROM smlc_acr sa LEFT JOIN smlc_acr_photos p ON p.photo_mls_number = sa.mls_number AND p.sortorder = 1 ORDER BY sa.list_price OR SELECT sa.street_number, sa.street_name, sa.city, sa.public_remarks_01, sa.public_remarks_02, sa.public_remarks03, sa.list_price,p.photo_filename FROM smlc_acr sa LEFT JOIN (SELECT photo_mls_number,photo_filename FROM smlc_acr_photos WHERE sortorder = 1) p ON p.photo_mls_number = sa.mls_number ORDER BY sa.list_price ~| 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:303255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Search opinion needed
On Tue, Mar 25, 2008 at 9:31 AM, Stone, Lori [EMAIL PROTECTED] wrote: We have a verity search that searches db and docs. They want to combine the results and then sort by relevance then date. I have done the combination before by just putting it in a structure. Any better ideas? You may want to look further at searching multiple collections, as Ray pointed out. If you are doing two separate cfsearches and then combining the results, I don't think that the relevancy scores would match up. ~| 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:302112 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: Some People Just Don't Know Any Better
On 2/5/08, Todd Rafferty [EMAIL PROTECTED] wrote: Too late. Looks like they've already converted ( http://www.uline.com/ ). I don't think there has been any conversion there, or any CF...looking in the wayback machine, that site has been the same ASP classic stuff since around 2002... http://web.archive.org/web/20020528223503/www.uline.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:298191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: syntax issue between Access and MS SQL
On 1/23/08, Ben Conner [EMAIL PROTECTED] wrote: SQL = SELECT Products.*, Categories.*, Manufacturers.* FROM Products, Categories, Manufacturers WHERE Products.ManufacturerID IN (Select ManufacturerID from Manufacturers WHERE Manufacturers.ManufacturerName Like '%spank%') AND Categories.CategoryID = Products.CategoryID AND Manufacturers.ManufacturerID = Products.ManufacturerID ORDER BY Products.ProductName UNION ALL SELECT Products.*, Categories.*, Manufacturers.* FROM Products, Categories, Manufacturers WHERE Products.ProductID IN (Select ProductID from Products WHERE Products.ProductName Like '%spank%' ) AND Categories.CategoryID = Products.CategoryID AND Manufacturers.ManufacturerID = Products.ManufacturerID ORDER BY Products.ProductName This query runs fine when the target database is Access. Anyone have a suggestion how to rephrase it or a syntax that works? It is the ORDER BY in the first query that is throwing the errors. Just use a single ORDER BY after all of the UNIONs, and it will order the entire set. Also, do you mean to use UNION ALL? That will result in duplicate rows if a productname and manufacturename both contain...ummm...spank. If you don't need the duplicate rows, you could rewrite this: SELECT p.*, c.*, m.* FROM Products p INNER JOIN Categories c ON p.CategoryID = c.CategoryID INNER JOIN Manufacturers m ON p.ManufacturerID = m.ManufacturerID WHERE p.ProductName LIKE '%spank%' OR m.ManufacturerName LIKE '%spank%' ORDER BY p.productname And, of course, it would be better to specify the columns that you pull back rather than use a wildcard. Do you really need all of the data from all tables? ~| 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:297114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IP Address to Country API
On 1/15/08, Coldfusion Monkey [EMAIL PROTECTED] wrote: Just wondering if you guys are aware of any negatives in using this service like updates to db, uptime,speed etc. I've had some issues with coverage and accuracy with hostip...when I was first testing it, I had a friend in New Bern, NC test the app. It didn't know where they were. But since it is a community populated database, this person just input their information, and the next query returned the correct location. Of course, that also points out that there isn't much checking on the validity of the data that is input. Right now it puts my IP as Charlotte, NC, while I am 150+ miles away in Raleigh, NC. ~| 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:296656 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 LMS Systems
On 1/6/08, Philip Hayes [EMAIL PROTECTED] wrote: Is anybody familiar with any SCORM Learning Management Systems (LMS) that are built in ColdFusion? The Webmentor LMS from Avilar seems to be built on CF. We use the hosted version, however, so I have not had a look at the insides. http://www.avilar.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:295982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql clear data
On 1/4/08, Chad Gray [EMAIL PROTECTED] wrote: Is there anyway to clear the data in a row in a database without using UPDATE table SET foo = '', Moo = '', Goo = '' WHERE ID = 1 I don't want to clear the ID just the other fields. My table has 50 fields and I don't feel like typing out all of them and setting them to blank. DELETE FROM table WHERE ID=1 INSERT INTO table(ID) VALUES(1) ~| 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:295839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql question: contains space' '
On 1/3/08, Paul Ihrig [EMAIL PROTECTED] wrote: just fond out why man this db is so messed up... 'Joe Garth ' so i would i look for NOT LIKE '% % ' OR... ltrim(rtrim(contact)) NOT LIKE '% %' ~| 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:295751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mssql pagination
On 1/2/08, Jonathon Stierman [EMAIL PROTECTED] wrote: You can see in the All Samples section that records 20-30 should be: [147, 148, 149, 150, 63, 36, 40, 382, 383, 384]. But the Total Wrapper query returns: [146, 147, 148, 149, 150, 63, 382, 383, 384, 440]. What happened to record 40? It's row #27 in the All Samples query, but it's included in the exclude Nested Subquery that should only be pulling the top 20 results. How does that happen? Since the sort order you are using (dateAdded) is not unique, it is probably using some other factor (like a clustered index or record insertion order) along with dateAdded to sort the records returned. Use something like this... SELECT TOP 10 sampleID, dateAdded FROM Samples a WHERE 0=0 AND a.sampleID NOT IN ( SELECT TOP 20 b.sampleID FROM Samples b ORDER BY b.dateAdded ASC,b.currentRow ) ORDER BY a.dateAdded ASC,a.currentRow; However, I'm guessing that the above will not scale well with a very large dataset, so something like the SP sent earlier may be a better solution. ~| 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:295747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery order by question
How do I get my numberic sort fields to take priority and come up first without maybe having TWO queries defined and two output blocks? Use something like ORDER BY COALESCE(sortORD,) ASC, #getPAGE.sortMETH# ~| 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:295112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDOCUMENT creating a PDF - ARGH!
head link rel=stylesheet type=text/css href=css/makePDF.css / /head Try an absolute path to your css file. ~| 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:295008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Filemaker Pro
It's possible, but the performance was horrible. You have to connect via a system ODBC (at least, on Win2k3 server) and FMP just wasn't up to the task of serving any sort of query except a direct dump. I'd suggest to the client that they move to a more internet-ready DB. I'll second this...though I haven't had to do anything with it since FP5. The performance was awful, and the ODBC driver that was available at that time was expensive and limited. ~| 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:294641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: ExtJS 2.0 Released
On 12/5/07, Cutter (CFRelated) [EMAIL PROTECTED] wrote: BTW, the ExtJS 2.0 framework was officially released yesterday. I had a chance to preview this prior to public beta, and I have to say that it is spectacular. I'll second this...I've got some reports using the grid grouping and rollup in the beta version, and it has been a BIG hit. ~| 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:294234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting a computer name by ip address.
On 11/5/07, Ian Skinner [EMAIL PROTECTED] wrote: Earlier this year (at a different company) I created a script that would run a windows dos command that would return a computer name and other information by IP address across a cooperate LAN. I was able to run this command with cfexecute, parse out the computer name and display it on the top of intranent web pages. This was of great benefit for the help desk to determine what computer users where calling about. For the life of me, my sleep deprived addled brain can not recall the dos command that did this! Can anybody help me out of my fuzz. nslookup ~| 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:292677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF from other document format: sever side processing
I'm tracking down my options for converting an uploaded document (variety of document formats or images) to PDF. Need to do this automatically, server side. As we're running CF8 - we can do lots of stuff to the PDF afterwards, but it's the conversion into PDF that's getting to me at the moment. What sort of options do I have? You probably want to look at something like activepdf... http://www.activepdf.com/products/serverproducts/docconverter/ ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why wouldn't the first cell alternate colors with this code?
On 9/27/07, Rick Faircloth [EMAIL PROTECTED] wrote: Assuming all other related issues with this code are correct, why wouldn't this first cell alternate colors coded like this? The background color attribute seems to be ignored. cfif get_events.recordcount mod 2 I think you meant to use get_events.currentrow. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shared Hosting vs VPS
On 9/23/07, Rick Faircloth [EMAIL PROTECTED] wrote: The choice is between shared hosting for $30 per month or a VPS for $70 per month. Rick, If you don't mind my asking, where are you getting a Win2003/CF8 VPS for $70/month? That seems pretty low to me. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
I got curious about whether you could output those gauge charts...and this code works, but it outputs the Developer Edition watermark on the output...even though the server is a licensed version of CF7 (the data and style were just straight from the example one in the webcharts builder) cfobject type=JAVA action=Create name=svr class=com.gp.api.jsp.MxServerComponent cfscript svr.getDefaultInstance(getPageContext().getServletContext()); myChart = svr.newImageSpec(); myChart.width = 400 ; myChart.height= 300 ; myChart.type = PNG ; myChart.style = dialChart dial=Dial240 inside=##C5 hand=##B699CCFF axis scaleMin=0/ dataLabels style=Value font=Arial-24/ legend equalCols=false/ elements drawShadow=true series index=0 paint color=##CCFF99/ /series series index=1 paint color=##FFCC99/ /series series index=2 paint color=##FF99CC/ /series /elements table cellSpacing=4 cellPadding=0/ paint palette=Pastel min=18/ /dialChart ; myChart.model = ?xml version=1.0 encoding=UTF-8?\nXML type=default\nCOLLow/COL\nCOLAverage/COL\nCOLHigh/COL\nROW col0=120.0 col1=220.0 col2=0.0Sample 0:/ROW\nROW col0=150.0 col1=300.0 col2=250.0Sample 1:/ROW\nROW col0=200.0 col1=400.0 col2=400.0Sample 2:/ROW\n/XML; svr.saveBytesTo(myChart,#GetDirectoryFromPath(GetBaseTemplatePath())#testimage.png); /cfscript img src=/testimage.png alt= border=0 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
A warning for anyone that might want to try the code I sent earlier. I noticed after sending it that all charts produced with cfchart on that server now had the Developer Edition watermark. Restarting CF clears it up, but as soon as I run the code that connects directly to the webcharts class, it starts again. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: charting solution for using with CF
On 9/6/07, Rob Parkhill [EMAIL PROTECTED] wrote: So how does one leverage the webcharts design app? it is a cool tool which I had no idea existed until yesterday. I played around with it quite a bit and designed a couple of charts (actually the gauges are going to get me in good with the boss :)) I have tried using them as a JSP file etc. but keep getting an error in the display. I haven't tried using any of the chart types that aren't directly supported by cfchart, although I don't see why you couldn't find a way to do it. The way I have used it is to access the style attributes that aren't supported by the cfchart tags to fine-tune a charts appearance...refer to this article... http://livedocs.macromedia.com/coldfusion/7/htmldocs/1431.htm ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: charting solution for using with CF
On 9/5/07, Peter Tanswell [EMAIL PROTECTED] wrote: Hi there I'm trying to find a good charting tool to use with CF and also with a MSSQL database to produce graphs and also dashboard style reports/graphs. Wondering what tools software people have used for doing this. CFChart can be effective, especially if you use the webcharts app to create your own styles. Look in your cf directory/charting for the webcharts.bat file, which fires off the webcharts design app. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FCK Styles
When I go to my browser to edit the page, I do not see this new attribute. Likewise if I remove a style that is already there, it still shows in the editor. From what I am reading I am changing the correct file. Is anyone else having similar issues? Try clearing your browser cache or doing a Ctrl-F5 in IE or Shift-Ctrl-R in FF. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287321 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 resize running very slow
I had done some tests recently to try to determine if I wanted to move some code over to using cfimage...here are some results. I tried to just run these tests with the defaults of each method. This was run on a shared host. Not scientific, but I don't think I will move away from Efflare quite yet for my bulk processing. The table of times is just a loop resizing the same image over and over. http://www.wrightster.com/resize/testresults.html In my testing, I also saw both cfimage and imagecfc spike up to 3 or 4 seconds (probably due to other processing on the shared host), and I did not see that with Efflare. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfimage resize running very slow
On 8/21/07, Raymond Camden [EMAIL PROTECTED] wrote: Again though Jim - you can't just look at speed - but quality of output. Remember that Adobe erred on the side of quality over speed, but lets you change the quality to speed up performance. Very true, but if I change the interpolation on cfimage to mediumPerformance, I'm still getting times in the 200-300 ms range and my subjective opinion is that the Efflare thumbnail looks much better. If I change it to highestPerformance, the times are in the 30-40ms range, but the thumbnail looks like crap. As I said, this is non-scientific and specific to my setup and images. YMMV. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286730 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 hosting
On 8/20/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: Hi: Is there any reliable Coldfusion 8 hosting server right now? I found by googling the following company but never heard of them before. http://www.bmchosting.com/features.cfm Do you know any good hosting with reasonable price which supports all cool CF8 features? HostMySite has been migrating the sites I have there to CF8 over the last couple of weeks. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286627 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: SQL Manager?
On 8/15/07, Adkins, Randy [EMAIL PROTECTED] wrote: Problem with that is, I do not run the server. It is a shared hosting server I think he as referring to using the Client Network Utility to set up a local alias. No access to the server is required. Look in your program group for EM. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286286 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 CF Studio 5
On 8/14/07, Alan Rother [EMAIL PROTECTED] wrote: You can buy Homesite 5.5 by itself from the Adobe store for $99. https://store1.adobe.com/cfusion/store/index.cfm?store=OLS-USview=ols_catcatType=PRODUCTSnr=0 Note that this is just Homesite, not Homesite+. It does not have RDS, the CF docs and I believe the CF Quickbar is different, too. If you can do without those, it works pretty well. I don't think they are selling HS+ at all. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument issues.
On 8/7/07, Raymond Camden [EMAIL PROTECTED] wrote: One of the tips I learned from Dean Harmon of Adobe was to try to make your pages complete web pages. By that he meant (if I rememeber right), use everything you would in a normal HTML page: TItle, Head, Body, etc. I'll second this recommendation...in fact, I've had the best results in making each part of the document a complete HTML page (each cfdocumentitem within a cfdocumentsection is a complete HTML document, as well as the main part of the cfdocumentsection). I've got external style sheets called using a link: link rel=stylesheet type=text/css href=css/some.css that work fine...the css is relative to the cfm page creating the cfdocument. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe Nails ColdFusion Cofin
On 8/2/07, Eric Roberts [EMAIL PROTECTED] wrote: I did look into getting RHE at one point for my dev server since that was the supported version. You cannot just download a copy of RHE without the support package. Of course, you could download the sources for RHEL and build it yourself, which is what the CentOS and White Box distros do. The license that you are paying to Redhat is really for access to the RHN and response time on any issues you have. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285218 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 Nails ColdFusion Cofin
With the price gap getting wider, maybe it's time for a third version, let's call it a Business version. That provides some of the least costly new features and provides a bridge (or stepping stone) from standard to enterprise. I think that would solve a lot of issues with this and take almost nothing for Adobe to do. It seems like they have actually done this somewhat, by allowing more of the Enterprise features to be enabled in Standard, just throttled to one request at a time. And that without a price increase to Standard. ~| 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:284972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 and CFDOCUMENT
Jim is your code working in 7 or 8? or both? 7 (with all updates...I believe that was necessary)...haven't tried it in 8. The code I'm using looks like what you were trying to do, except that I don't have a overall document header...the first page is just a different section. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 and CFDOCUMENT
Does anyone know if the horrendously broken CFRDOCUMENT tag actually works as advertised in CF 8? Big broken item for me was only 1 header/footer per document regardless of how many CFDOCUNTSECTIONS (even though docs said you could have a header and footer per section and not just for the whole doc). This meant a doc with multple sections that each required unique header and/or footer could only be built with custom display code for proper pagination (the whole flipping point of the tag IMHO...to make docs easy to create on the fly). Do you have an example of code that isn't working for you with this? I've got reports which have a single footer and 5 different cfdocumentsections, each with their own header, and it is working. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284627 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 to Retrieve One Record from Several Possible Records
,CASE WHEN A.addr_type IS NOT NULL THEN A.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NOT NULL THEN B.myAddressField WHEN A.addr_type IS NULL AND B.addr_type IS NULL THEN C.myAddressField ELSE 'No Address Found' END AS SeasonAddress rather than these CASE statements, you could use COALESCE...the myAddressField should be NULL if the addr_type is NULL COALESCE(a.myAddressField,b.myAddressField,c.myAddressField,'No Address Found') AS SeasonAddress ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282502 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Editor
2. In Home Site (a new install of HS5.5) I'm getting a warning message about every CFtag I use (not in current version) and the CF documentation no longer shows up in Home Site. Can I fix this? My guess on this is that you are running just HS and not HS+. I'm running into this as well, and as far as I can tell, HS+ is not sold anymore (I believe it used to be bundled with Dreamweaver). Which also means no more RDS in HS. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfml.exe conversion to wget
On 6/20/07, Asad Khan [EMAIL PROTECTED] wrote: Hi All: I have an existing website that was running fine on cf5, but ever since we have moved over to CFMX7, we are having issues with CFML.exe I just found out it is not supported anymore. Here is my current code that uses the cfml. I am not sure how to convert it to wget. I have downloaded wget tool, but everything shown in documentation shows it as a command lines. script language=JavaScript src=https://www.xx.com/cgi-bin/cfml?template=/cgi-scripts/SSLLPSNInt2cgi.cfmc=1259;/script this code is placed on various websites of mine. The code is to bring up a help desk which is running on the domain above. How would i convert this to using wget. Any info would be appreciated. I don't think wget comes in to it at all. It looks like your call above is the old, old way of doing things with CF, from back when it was just a CGI interface. I think what you would need to do is convert these so that you are calling the CF page directly... script language=JavaScript src=https://www.xx.com/cgi-scripts/SSLLPSNInt2cgi.cfm?c=1259; ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Based Verity Issue
Thank you for your response. I would normally agree with you however in my specific case I feel I need to use verity. I neglected to mention all the other search criteria that is involved in order to simplify the question and not cause confusion. Doing a simple price range search in SQL would be the easiest way given the information I posted. Thank you again for your response. You still may want to look at doing a combination of queries. I've got a case where I do a verity search on some text, and then do a search on other more precise criteria in the database, and combine the two using a QoQ. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: server failover/multiple instances
Any opinions/advice on this? On 6/18/07, Jim Wright [EMAIL PROTECTED] wrote: I am working towards beefing up our current environment, and wondered if I could get some opinions on server failover and using multiple instances. So I have: Production Site Training Site, duplication of the production site which is used by our training department Testing Site In addition we want to have high availability on the production sitewe don't need load balancing, mainly just failover. I'm thinking of getting two copies of Enterprise, setting one up as the production server, and the other as a failover/training/testing server, with each of those in separate instances, and putting the production and failover instances in a cluster. If I put them in a cluster, does that mean they are going to share the load 50/50, or can I make one of them still take the brunt of the traffic unless there is a failure? Is there a better way to do it? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FW: server failover/multiple instances
I would recommend keeping your testing/training environment separate from production. Your testing environment may require newly developed code which has not been migrated to production. You probably will want a separate database as well for training and testing for similar reasons. That is the idea, and they will all have their own databases. I was mainly trying to avoid setting up the extra systems for training and testing, but the more I think about it, I'll probably just use CF Standard on our VMWare server for those two. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281556 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FW: server failover/multiple instances
On 6/19/07, Brad Wood [EMAIL PROTECTED] wrote: Also, sometimes you may want to install a windows patch to your test server first and test it, THEN put it on production. And of course, in this case, test should be the exact same environment as production, meaning CF Enterprise there as well. Also, thinking about patches...how does the clustering handle CF/JRun patches? If you take down one member to update it, can you bring it back up in the cluster and then bring down the other box? Or does it depend on the update? What have people seen with past updates? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: server failover/multiple instances
I've never set up the weighted scenario, but it should be possible. http://livedocs.adobe.com/jrun/4/JRun_Administrators_Guide/clustering3.htm Thanks, Russ...that is what I was looking for. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
server failover/multiple instances
I am working towards beefing up our current environment, and wondered if I could get some opinions on server failover and using multiple instances. So I have: Production Site Training Site, duplication of the production site which is used by our training department Testing Site In addition we want to have high availability on the production sitewe don't need load balancing, mainly just failover. I'm thinking of getting two copies of Enterprise, setting one up as the production server, and the other as a failover/training/testing server, with each of those in separate instances, and putting the production and failover instances in a cluster. If I put them in a cluster, does that mean they are going to share the load 50/50, or can I make one of them still take the brunt of the traffic unless there is a failure? Is there a better way to do it? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conditional SQL
On 6/13/07, James Smith [EMAIL PROTECTED] wrote: AND ProductGroupID = CASE WHEN @productgroupid 0 THEN @productgroupid ELSE ProductGroupID END This is the simplest to read but has a drawback, it the stored ProductGroupID is null then the statement becomes AND ProductGroupID = ProductGroupID and for some reason NULL does not equal NULL so the row isn't returned, is there a workaround for this? AND COALESCE(ProductGroupID,0) = CASE WHEN @productgroupid 0 THEN @productgroupid ELSE COALESCE(ProductGroupID,0) END ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conditional SQL
On 6/13/07, Gaulin, Mark [EMAIL PROTECTED] wrote: This seems like a really complicated way of saying AND ((ProductGroupID = @productgroupid) OR (@productgroupid = 0)). Am I missing something? I think really complicated is a bit harsh...perhaps more complicated...and the previous version doesn't care what the value of @productgroupid is, unless it is greater than 0...it could be 0 or -1 or NULL and return all records...in your example it must be 0 to return all recordswhich may be fine depending on what you are expecting as inputs. The following should work the same as my previous statement AND ((@productgroupid = 0) OR (@productgroupid IS NULL) OR (ProductGroupID = @productgroupid)) And all of these examples, while fun exercises, ignore the fact that the conditional processing still may not be faster in SQL, as Jochem pointed out. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conditional SQL
I wish to move this query into MSSQL server for performance reasons, how do I go about running the conditional code? I have tried... I'm not sure you are going to get the performance benefit you are looking for. Doing the conditional processing in SQL isn't necessarily going to be faster...but you could do... DECLARE @productgroupid bigint; SET @productgroupid = 5; SELECT Title, ProductID FROM aTable WHERE Stock 0 AND ProductGroupID = CASE WHEN @productgroupid 0 THEN @productgroupid ELSE ProductGroupID END ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How many CF developers does it take to manage a site ???
On 6/11/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 11 Jun 2007, [EMAIL PROTECTED] wrote: average CF developer manage? Define 'manage'. Does that mean 'have needed development work in the last 12 months' or 'are running on the live server' ? Also define site...are you talking about separate CF installs? Different apps under the same URL? Different URL's on the same web server? Does manage mean development or administration or both? I think you'll find that for a group of developers who all manage n sites, n != n != n... ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PDF to Image
On 6/7/07, Mark Lewis [EMAIL PROTECTED] wrote: Hi, I am trying to convert the front page of a PDF doc to an image. My target server is Coldfusion 5 but if necessary Colfusion mx 7 can be used. Is it possible for this to be done, if so could I have some directions on how to do this. I believe that imagemagick will do this, and you could cfexecute that in either 5 or 7. I don't know of any of the other image manipulation tags or CFC's having that capability. http://www.imagemagick.org/script/index.php ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Access query doesn't work
On 6/1/07, Will Tomlinson [EMAIL PROTECTED] wrote: Need help figuring out why Access throws up on this query. I don't see anything wrong with it. select a.id, a.title, a.body, a.projectidfk, a.useridfk, a.posted, p.name as project, u.name as author from lh_announcements a left join lh_projects p on a.projectidfk = p.id left join lh_users u on a.useridfk = u.id where 1=1 cfif structKeyExists(arguments, projectidfk) and len(arguments.projectidfk) and (a.projectidfk in (cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.projectidfk# list=true) or a.projectidfk = '' ) /cfif order by a.posted desc [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'a.projectidfk = p.id left join lh_users u on a.useridfk = u.id'. Will, Try putting your joins in parens... (lh_announcements a left join lh_projects p on a.projectidfk = p.id) left join lh_users u on a.useridfk = u.id it seems like I've had an issue with that in Access before. -jim ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
final CF 4.5 upgrade
Sorry for the fluff message, but I'm just very happy that I got my final client (and as of last month, full time employer), off of CF 4.5 as of today. No more supporting anything earlier than 7! ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 beta ready for download...
On 5/30/07, Raymond Camden [EMAIL PROTECTED] wrote: http://ray.camdenfamily.com/index.cfm/2007/5/29/Adobe-releases-public-release-candidate-of-ColdFusion-8--AKA-Scorpio#comments Also folks - in the comments you will find a Digg/DZone url. _Please_ vote to get these stories up on the front page. Oh good, I see it made it to Digg's front page. Of course it had to compete with Microsoft getting thousands of diggs for a horizontally mounted touchscreen. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279642 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating xml formatted out from table in database
Ray Camden has a handy CFC that will help with that... http://ray.camdenfamily.com/projects/toxml/ On 5/28/07, Peter Tanswell [EMAIL PROTECTED] wrote: Hi there Just trying to figure something out. I have a form and an action page to write data to a table in the database. I am collecting a persons first and last name and email address. I want to be able to send this information to an xml formatted output so it can be used in a flash application. The first part is easy, just wondering if someone could advise on the second part getting to XML formatted output from the table in the database. Many thanks ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DataSource Help
On 5/24/07, D Suresh [EMAIL PROTECTED] wrote: The Error msg is: Connection verification failed for data source: TestDB java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect Make sure that you can reach the sql server on the correct port... from the CF server, try: telnet yoursqlserver 1433 at a command prompt...you should get a empty window if the port is open. If you don't... -is TCP/IP enabled on the sql server -is there a firewall that would be blocking port 1433 -is the SQL instance set up to listen on a port other than 1433 ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Voting only once - how to enforce ???
On 5/23/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I'm creating a voting application for a photo contest and the non-technical person running the show doesn't want voters to have to verify their email address before their vote is counted. Although this method isn't fool proof, it does create a level of effort to break the one vote rule. Does anyone have any ideas on how to ensure that voters can only vote once and not rely on cookies being enabled, deleted etc. You could store the IP, and only allow one vote from a particular IP, but that would limit people using NAT or behind a proxy to only one person voting. A cookie would be better, but not foolproof would just limit them to one vote per machine (or browser on the machine, until they clear their cookies). You could just allow all, but store the IP, and then do some post-processing on the data... 100 votes for photo 1 from the same IP within some time limit = only one of the votes counts 20 votes for various photos from the same IP within some time limit = allow all votes But I would tell your client that without using something like the email address, you really can't even get close to guaranteeing the numbers. Even with email, I would still store the IP, and do some checking to make sure that someone is not trying to spam the voting by using multiple email addresses. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Project Time Tracking Software?
On 5/22/07, Aaron Roberson [EMAIL PROTECTED] wrote: Does anyone know of a good project time management application that would be good for consulting jobs? I am thinking of something that has a stop watch you can click to start and stop and automatically calculate expenses incurred. It would be nice if it had invoicing capabilities as well. While not a full-fledged time management app, this is a nice app for time tracking http://www.slimtimer.com/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
other charting tools
I'm hitting a few roadblocks with cfchart, and wonder what other people are using that might be a bit more feature rich. Specifically, I'm looking for more formatting control, such as series value labels that may extend past the borders of a bar, specific bar width, and specific colors applied to certain series items. I've been messing around with the WebCharts3D style files and the chart design app that comes with CF, but I'm still not getting exactly what I need. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Access Query Question
Donna Martin wrote: In the newer versions, Access can be locked at the record level, and does not effect changes made to other records within the same table. *If you are using the oledb driver with the correct settings, IIRC. Of course, that doesn't prevent something else from connecting to it with the wrong settings and locking on the page level. Also, it can be set to compress on close Can this be done with a database that is only accessed through ODBC or OLEDB? I would think that this is only something that could be set in the Access application. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Opinions of Thumbnail Generation
Rey Bango wrote: I wanted to get everyone's opinion on best practices for generating thumbnails. I'm have a screen that allows users to upload pics which will later be displayed as thumbnails. When the user clicks on the thumbnail, the pics will display to its full size. Does it make more sense to generate the thumbnails at the time of upload or should that be done on the fly when the thumbnail page is displayed? Thoughts? I would do it at the time of upload. You don't want the load of creating those thumbnails on the fly, and also if there is a problem with resizing the source image, you can catch the error at that point. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hostmysite down...
Mary Jo Sminkey wrote: So there's a good chance you might even be able to correct it just by asking HMS to move you to a different server. They do run multiple datacenters, so I would check with them to make sure your shared web server and mysql server are in the same datacenter. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP not working?
Neil Middleton wrote: Can anyone think of a reason why when I CFHTTP it doesn't connect to external URL's when the sites work perfectly in a browser on the same machine? I am using WinXP / CFMX7 Dev Edition Is the browser on that machine going through a proxy server? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: file do more than one scheduled task ??
Seamus Campbell wrote: is there any way to have a scheduled task do more than one task. My situation is this: I have a shared hosting space (Windows Servers) with Crystaltech. They only allow me 5 scheduled tasks but I have more than 5 sites which each need to run a file on a regular interval. (cfschedule is turned off) At the moment I just run a file in each website (for 5 sites). Is there another way to do this? Ie can I get a scheduled task to run more than one file? Can I get a file in CF to say run this file in this directory, then this next file in this next directory, etc Each task is very long (updating a database) and is actually in a different site so can't just do one file then cflocate to the next. You could use another machine under your control, and then just schedule the tasks through the windows scheduler (or cron jobs on linux), and call the pages using something like wget. I've had good luck with this for some clients of mine that use shared hosting at HMS. The cfhttp calls that Ray talked about are an option, too...but CT may have a hard limit on process timeouts(HMS does)...and calling multiple files from one script may put you over the limit. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe takes UK price hikes to new level with CS3
Sean Corfield wrote: On 4/5/07, Tom Chiverton [EMAIL PROTECTED] wrote: I've not bought 'real' boxed software for years. Software comes in boxes? :) I think the last software I bought that wasn't just a download was Visio Professional 5.0, based on the almost complete lack of boxes in my office. Hmm, Visio 5.0... suitable for Windows 98... I guess that was a long time ago. and yet it seems like a lot of companies need to make it look like their software comes in boxes to make it seem more real or professional, even if they are download onlyand here is a tutorial http://tutorialblog.org/create-a-software-box/ ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hostmysite down...
Scott Stewart wrote: Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server. Probably just the server you are on...I just checked a few of my clients, and they are still up. They generally are monitoring pretty closely, and get CF services restarted quickly. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hostmysite down...
Russ wrote: I wonder if HMS has FusionReactor installed? I think it can really help with these type of issues. I believe they started using SeeFusion about 3 or 4 months ago. Since then, the services have seemed to restart faster when there is a problem, but I'm not sure the number of crashes has decreased overall. It could be that things have improved per number of sites, but they are cramming more sites on a server. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Syntax error in FROM clause.
sheldon turchin wrote: Installed CF7 and get error but do not get the error in CF6. cfquery name=GetMonths datasource=Master SELECT Month FROM Month WHERE MonthID = #GetStatRecords.MonthID# /cfquery Is Month reserved and cannont be used in CF7? CF would not see that as a reserved word in that context, but the DB driver you are connecting through may...try delimiting the object names... SQL Server... SELECT [Month] FROM [Month] MySQL SELECT `Month` FROM `Month` OR possibly.. SELECT Month FROM Month if quoted identifiers are allowed. Better, though, to not use common function names as database object names. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274625 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 Like
Steve Milburn wrote: T-SQL will return every record in this case. % is a placeholder for any characters, so your query would essentially tell the database where x = any pattern of characters and would return everything. if there are no NULLs in x. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274238 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 help instantating a COM object in CF7... It's my first time... :o(
Try running this at a command prompt... regsvr32 x:\path\com\bbapi.dll Then use... CreateObject(COM, BBAPI.API) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273931 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: Sitemaps
Steve LaBadie wrote: Is anyone aware of a product that can accurately count how many pages are on a web server for a specific domain? I am not looking to create a web-based sitemap but to know how many (.htm, .cfm, etc.) pages exist without having to count by hand. Maybe use a link checker like Xenu... http://home.snafu.de/tilman/xenulink.html ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273506 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 More SQL help - DRIVING ME NUTS!
Three things I noted... 1. There are a lot of duplicated columns in the result list...I removed those to make it easier to read and debug 2. It looks to me like tblevalanswerresults needs to be joined to both tblquestions and tblanswers...see below 3. When you join on tblEvaluations like you did previously, and then filter with a WHERE clause, you may get instances where you won't return some of the questions in a set because none were answered for that instructor. I moved the filtering on instructor up into the join. If this doesn't work, just do a dump of each table and post that somewhere. It will be easier to debug with the whole picture. SELECT Q.questionID,Q.questionsetID,Q.question,ARS.answersetname,A.answerID,A.answername,A.answervalue, COUNT(EAR.answerID) AS numAnswers FROM tblquestions Q INNER JOIN tblanswersets ARS USING (answerSetID) INNER JOIN tblanswers A USING (answerSetID) LEFT JOIN (tblevalanswerresults EAR INNER JOIN tblEvaluations E ON E.evalID = EAR.evalID AND E.InstructorID = '#SESSION.CollegeID#') ON A.answerID = EAR.answerID AND Q.QuestionID = EAR.QuestionID GROUP BY Q.questionID,Q.questionsetID,Q.question,ARS.answersetname,A.answerID,A.answername,A.answervalue ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I display a message if update was successful?
Dave Watts wrote: If your SQL update query doesn't return an error, that indicates your update was successful. Well...it indicates that there wasn't an error. It doesn't actually indicate that anything was updated. UPDATE sometable SET somecolumn = 'somevalue' WHERE 1=0 won't throw an error...but it also doesn't do anything. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do I display a message if update was successful?
Dave Watts wrote: Well...it indicates that there wasn't an error. It doesn't actually indicate that anything was updated. UPDATE sometable SET somecolumn = 'somevalue' WHERE 1=0 won't throw an error...but it also doesn't do anything. If you run a query that filters out all rows, it would still be successful, which is what the original poster asked. Right, I just wanted to point out that the lack of an error does not mean that anything was updated. I know you understand this, but I'm just afraid that others who are new to SQL may take your statement at face value. I've run into cases where people were running updates on a table where the record they were attempting to update did not exist. No error, but also no update. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query output - based on date range
[EMAIL PROTECTED] wrote: Ahhh, I have an events database that lists the details of an event and the date range of number days the event runs. If it's a one day event, eventdate is the same as eventdate2. I've got the events outputting over a calendar so all the events show a single listing of each event. I want to display the event in each day within the date range within a calendar. Should I be using cfloop instead? Any ideas would be so helpful. Thanks. OUTPUT CODE cfoutput query=Events tr td class=date_cell#LSDateFormat(Events.EVENTDATE,'MMM')# strong#LSDateFormat(Events.EVENTDATE,'DD')#/strong/td td class=name_loc_cell#Events.EVENTNAME#/td td class=name_loc_cell#Events.EVENTLOCATION#/td td#Events.EVENTDESCR#/td /tr /cfoutput For things like this, sometimes it can be good to have a utility table that lists the dates that you need to view...so just have a table something like... tblDates thisdate datetime populate that with every day from some way back date to some way forward date...then it makes it very easy to join against your events table and find all events within a date range and have them assigned to the correct date(s)... SELECT a.thisdate,b.eventname,b.eventlocation,b.eventdescr FROM tblDates a LEFT JOIN Events b ON a.thisdate = b.eventdate AND a.thisdate = b.eventdate2 WHERE (limit tblDates by some date range) ORDER BY a.thisdate,b.eventname Then you can just use cfoutput and group to output a calendar of events that shows all of the days in the range... cfoutput query=Events group=thisdate h1#thisdate#/h1 ul cfoutput li#eventname#BR#eventlocation#BR#eventdescr# /cfoutput /ul /cfoutput ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GotCFM.com - Need Opinion on Whether to Approve a Site
Steve Milburn wrote: In my opinion, and I would be the majority of people in this list, that would not be good for business. However, when they click on that first site on the gotcfm list...12listen.com...the one most people will probably click on...the psychic friends site...by golly, they are going to be impressed with CF. Point being that a list like this is hit or miss to send out at all, porn sites or not. In marketing CF, I may use this site to find out about good sites to bring to my client's attention, but I don't think I'll be sending any of them in to poke around on their own. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Can anyone tell me why someone would do this?
Peterson, Chris wrote: I inherited a web site that is having session management issues, and using a good amount of ram. In the application.cfm file, there is the following session code: cfapplication sessionmanagement=yes name=#Hash(GetCurrentTemplatePath())# setclientcookies=no Now, can anyone tell me why you would want, on a web site that requires users to login, to set the session name based on the template? Chris Perhaps they used the same application template for multiple applications on the same server, and this was their shortcut way of making sure that the application names didn't conflict. Or, was the application meant for shared hosting...this may have been a way to make sure there wasn't any conflict there. I doubt if that in itself is causing your session management issues, it produces a valid...though unreadable...application name. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272981 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 cfquery to select from multiple datasources
Kristin Collins wrote: I need to write an sql statement within a cfquery tag that pulls from two seperate datasources. But it's coming back with Invalid object name Below is the what I have written: cfquery datasource=#request.dsn# name=towns SELECT townid as tid, town as cityname from towns where siteID = 1 union select distinct city as cityname from compdb.dbo.commlease order by cityname /cfquery Can anyone tell me what I'm doing wrong? Does the user that you are connecting to the request.dsn with have access to the compdb database? Are the two databases on the same server or are the servers linked? You said datasources in your message, and you can't query across CF datasources (except by combining them with QoQ), but you can do something like what you are trying to in your query if the databases are on the same SQL Server or set up as a linked server, and the permissions are correct. I say something like what you are trying to do, as the UNION also has a problem...you need to have the same number of columns with compatible datatypes in each query to do a UNION. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Desk / Trouble Ticket recommendation?
Andrew Peterson wrote: Can someone recommend a good help desk/trouble ticket system? The ideal application would be cf based and open source. Thanks. While not CF based, I know quite a few people who swear by RT... http://bestpractical.com/rt ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server Syntax - Converting this CF Code
Andrew Peterson wrote:
Hi,
I'd like to see how this is done, even though it is not necessary and I like
my ColdFusion thank you very much. Can someone give me a general idea of how
this code would look in SQL Server? It takes literally 5 minutes to write in
CF; but for me to put it into a SQL Server stored procedure I'm lost. Here's
the code.
cfquery datasource=#request.dsn# name=qryLooper
SELECT RecordType FROM LHF_Line
where quarter = '#lastQuarter#'
/cfquery
cfloop query=qryLooper
cfif recordtype eq MC or recordtype eq NA
CFQUERY DATASOURCE=#request.dsn#
INSERT INTO LHF_Line...abc
/CFQUERY
cfelse
CFQUERY DATASOURCE=#request.dsn#
INSERT INTO LHF_Line...def
/CFQUERY
/cfif
/cfloop
I'm not quite sure where the ...abc and ...def data is going to come
from, but possibly something like this would work...
CREATE PROC spThisProc @qrtr varchar(50) AS
INSERT INTO LHF_Line(...abc)
SELECT ...abc FROM LHF_Line WHERE quarter = @quarter AND recordtype IN
('MC','NA')
INSERT INTO LHF_Line(...def)
SELECT ...def FROM LHF_Line WHERE quarter = @quarter AND recordtype NOT
IN ('MC','NA')
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272688
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
Ashish Gohri wrote: Something like this works - cfset a = NumberFormat(1234567,) I believe in older CF versions (5 maybe, 4.5 for sure), you had to have as many places (or more) in your mask as you had in the number it is formatting. Is this a older version of CF? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is wrong with this?
Rick Faircloth wrote: That got me closer, Jim. I tried #NumberFormat(Trim(Get_Property_Details.Sale_Price), 999)# and it did take off the decimal and rounded the number to 255900, however the 255900 was then preceded by about 4 blank spaces in the form field. Yeah...now that I think about it, that is probably one of the main reasons I still have a custom numberformat tag in use at one of my clients (last 4.5 holdout). The last thing it does is trim the output. You could just do it in the query...something like... CAST(Sale_Price AS integer) ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating HTML Content Wrapper for Email
When I was creating some HTML email templates recently, I found this article to be very valuable... http://www.sitepoint.com/article/code-html-email-newsletters ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL for Access vs MySQL
Pete wrote: Hi Hoping someone might be able to assist - its 4am and I have just been called by a client coz their system crashed. They have just moved from using an Access DB to MySQL. They have a piece of code: select * into visaudactvols from visualauditrecs I don't believe MySQL supports this use of INTO. You can use: INSERT INTO visaudactvols(somecolumn) SELECT somecolumn FROM visualauditrecs but the table will have to exist first, unlike Access, MS-SQL and PostgreSQL, which will create the table with the SELECT ... INTO statement. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: GotCFM.com - Need Opinion on Whether to Approve a Site
Rey's site is meant to evangelize CF...and one thing that will evangelize CF is some really good CF sites. If someone is going in to look at sites that use CF, I'd rather have them see a really well designed adult toy shop that has a kick-ass search engine to help you find that perfect lube than a well meaning but poorly designed site with database errors all over it. I'd like to see more featured CF sites...real showcases that demonstrate what can be done. Sending someone to the gotcfm list may or may not be a good thing, depending on which example site they click on (and not just because the content offends them). ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GotCFM.com - Need Opinion on Whether to Approve a Site
Rick Faircloth wrote: Isn't anyone else doing anything worth noting? This was exactly my point...and the conversation should go to this and how best to rate and showcase them rather than whether adult sites should be included (which is, as far as we know, still theoretical...Rey, have any been submitted?) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
HMS Down?
Is anyone else having problems with HMS sites? The two of mine that I can get to have JRun errors, and have for a while, where usually they are on top of those. And their main site is unreachable from my location. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HMS Down?
Les Mizzell wrote: Whoop - me too ... bunch of stuff down ... Calling them now... The tech that I just talked to said they were having networking problems in one of their data centers. They are in the process of replacing some equipment. So apparently no cable cut this time...but it appears not enough redundancy, also. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image manipulation
Asim Manzur wrote: What is the best tool in the market to resize/crop the uploaded images in coldfusion. The scnerio will be like the visitor will upload the image and then he/she should have resize, rotate, crop and the other smiliar kind of functionality available. I don't mind buying any commercial CFX, but like to know someone's experience. If speed is your primary qualifier, Efflare's ImageCR is hard to beat If price is, Rick Root's imageCFC does a good job. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Image manipulation
Ian Skinner wrote: Sorry. Sounds like it's time to get a new host. HMS does have ImageCR3 installed on their systems. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Converting MS Word-exported HTML to clean HTML
Dov Katz wrote: I know there's something like this in fckEditor, but I'm looking for it to be server-side. The js used to do this in FCK is in FCKEditor/editor/dialog/fck_paste.html...it is just a bunch of regex replaces...perhaps you could massage those over to some cfscript. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism
Rey Bango wrote: But, by no fault of Ben, its not all encompassing, its not up-to-date and it doesn't appear to include sites built using other technologies like Ralio, Coral or BlueDragon. Just curious if you have plans to keep yours up to date? Sites get upgraded to a new version of CF or moved to BD, or stop using CF. One possiblity might be to require the email contact field, and then send a monthly message that includes a temporary editing link for any entries associated with that email contact. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
