Re: Joining two different databases?
I have a question.. Even if you can join on those two databases using fully qualified paths, how do u create a dsn that you will have to use to execute teh query? what does it use for the db? will it work just if you point the dsn to either of the databases and use full paths? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cflogin and load balancing
On 3/26/06, Adam Churvis [EMAIL PROTECTED] wrote: And one more thing... SSL really doesn't matter because you're not going to use it everywhere on your site, only in some places, so everywhere else that doesn't use SSL is still exposed. The whole application will use HTTPS. Regards. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: reg ex for url extraction..
Thank you very much. cheers :) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cflogin and load balancing
On 3/26/06, Adam Churvis [EMAIL PROTECTED] wrote: It doesn't work that way. Since your CFLOGINUSER call is inside a CFLOGIN call, that CFLOGIN call *won't* run when the second server sees your authentication cookie because CFLOGIN only runs when you are *not* authenticated. Actually, according to my testing (ColdFusion 6.1 with the Updater), when the second server sees the cflogin cookie, it will automatically run the cflogin/cfloginuser code and authenticate/authorize the user. Can anyone verify this with ColdFusion MX 7? Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236233 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Joining two different databases?
On 3/27/06, Srinivasa Teja Palla [EMAIL PROTECTED] wrote: I have a question.. Even if you can join on those two databases using fully qualified paths, how do u create a dsn that you will have to use to execute teh query? what does it use for the db? will it work just if you point the dsn to either of the databases and use full paths? As long as the user you used to create or use the DSN has rights to both db's, just pointing it to either one and using the fully qualified paths should work. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Joining two different databases?
This is how I did it: SELECT db1t1.listing_id, db1t1.listing_mlsnumber,db1t1.listing_type, db2t2.pLisPric FROM db1.table1 db1t1 INNER JOIN db2.t2 db2t2 ON db2t2.pMlsNum = db1t1.listing_mlsnumber !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Srinivasa Teja Palla [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 6:53 AM To: CF-Talk Subject: Re: Joining two different databases? I have a question.. Even if you can join on those two databases using fully qualified paths, how do u create a dsn that you will have to use to execute teh query? what does it use for the db? will it work just if you point the dsn to either of the databases and use full paths? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFX tag error
Hi, there. I am creating my first Java CFX tag, and I am getting the following error: PullNTID (Unsupported major.minor version 49.0) null The error occurred on line 1. (PullNTID is the name of the class.) Any thoughts? TIA, Matthieu ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Can I see line feed vs. carriage return?
What is a text editor I can use to turn on a feature that will let me see the difference between a CR and LF? Thanks! Jon This electronic message transmission contains information from Collegiate Funding Services, LLC or its subsidiaries or affiliates that may be confidential or privileged. The information is intended to be for the use of only the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this electronic transmission in error, please notify the sender by reply e-mail @cfsloans.com immediately and delete this e-mail and any attachments from your system and any copies you may have made, electronic or otherwise. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Version control - how to?
Subversion is the most useful software tool I've used in the last 3 years I've found that it works *very* well with my coldfusion web projects... Jon -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 8:25 AM To: CF-Talk Subject: Re: Version control - how to? SVN also plugs directly into Eclipse in addition to the Windows File Explorer integration. On 3/27/06, Kevin Roche [EMAIL PROTECTED] wrote: We use WinCVS and are very happy with it. CVS also has the ability to link directly with Eclipse. Kevin Roche -- Original Message -- From: Michel Deloux [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Sun, 26 Mar 2006 14:08:34 -0300 Does anybody have any suggestions for somebody who's never used any source control? We use DW8 as our primary IDE, CF 6.1 in dev/prod server. Subversion is a good application? Works in WindowsXP and CF/IIS(without Apache) with application server? Any example with this settings? Cheers MD ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
DB Pagination Question
Hi All, I am wondering what the best way to handle the following situation is. I have a database with approx 100,000 records. Users can search on these records with multiple criteria. Some result sets can contain 10,000 records or more. Also, there is a possibility of sorting the results. Using CF SQL server, what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? TIA. - jim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can I see line feed vs. carriage return?
Doesn't MS Word to that with the little paragraph symbol button? I know it differentiates between returns and paragraph breaks... ~Brad -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 9:36 AM To: CF-Talk Subject: Can I see line feed vs. carriage return? What is a text editor I can use to turn on a feature that will let me see the difference between a CR and LF? Thanks! Jon This electronic message transmission contains information from Collegiate Funding Services, LLC or its subsidiaries or affiliates that may be confidential or privileged. The information is intended to be for the use of only the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this electronic transmission in error, please notify the sender by reply e-mail @cfsloans.com immediately and delete this e-mail and any attachments from your system and any copies you may have made, electronic or otherwise. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can I see line feed vs. carriage return?
binhex32 (in hex mode) On 3/27/06, Brad Wood [EMAIL PROTECTED] wrote: Doesn't MS Word to that with the little paragraph symbol button? I know it differentiates between returns and paragraph breaks... ~Brad -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 9:36 AM To: CF-Talk Subject: Can I see line feed vs. carriage return? What is a text editor I can use to turn on a feature that will let me see the difference between a CR and LF? Thanks! Jon This electronic message transmission contains information from Collegiate Funding Services, LLC or its subsidiaries or affiliates that may be confidential or privileged. The information is intended to be for the use of only the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this electronic transmission in error, please notify the sender by reply e-mail @cfsloans.com immediately and delete this e-mail and any attachments from your system and any copies you may have made, electronic or otherwise. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFFTP Connection Error
Out of the blue a week ago, a page that I have been using for years started giving me this error message. Invalid connection specified. The connection attribute you specified, getFileNames, is invalid or does not exist Nothing has change in the code. It will grab one file and then throw the error. Is it possible that the connection is timing out? CFFTP ACTION=Open SERVER = #serverIP# USERNAME = #serverUser# PASSWORD = #serverPass# STOPONERROR = Yes CONNECTION = FileName CFFTP action=changedir directory=idx CONNECTION = FileName !--- there is a loop here to gather files --- CFFTP ACTION=GetFile LOCALFILE = #sitePath#\temp\pics-residential-#imageFile#.tar REMOTEFILE = pics-residential-#imageFile#.tar PASSIVE = yes STOPONERROR = No TRANSFERMODE = Binary CONNECTION = FileName !--- end loop --- Thanks for any help, Doug ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFTP Connection Error
The connection value actually returns an object with the name you specify. You have called it 'filename' and I'm guessing that you also have a query called 'getFileNames' with a column of filename. I think the two variables are then getting confused - I would just rename the connection to something more meaningful like 'myConnection'. HTH On 3/27/06, Doug Bedient [EMAIL PROTECTED] wrote: Out of the blue a week ago, a page that I have been using for years started giving me this error message. Invalid connection specified. The connection attribute you specified, getFileNames, is invalid or does not exist Nothing has change in the code. It will grab one file and then throw the error. Is it possible that the connection is timing out? CFFTP ACTION=Open SERVER = #serverIP# USERNAME = #serverUser# PASSWORD = #serverPass# STOPONERROR = Yes CONNECTION = FileName CFFTP action=changedir directory=idx CONNECTION = FileName !--- there is a loop here to gather files --- CFFTP ACTION=GetFile LOCALFILE = #sitePath#\temp\pics-residential-#imageFile#.tar REMOTEFILE = pics-residential-#imageFile#.tar PASSIVE = yes STOPONERROR = No TRANSFERMODE = Binary CONNECTION = FileName !--- end loop --- Thanks for any help, Doug ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Invalid object name
I assume SQL Server's Invalid object name error is typically a result of a missing table or mistyped table name. But I'm seeing it at a rather odd time. When I run a certain query as part of a CFC function, I receive the error Invalid object name 'dbo.tecSOLine'. But if I pull the offending query out of the CFC and run it independently, it works as expected. CF seems to know the table exists, otherwise it wouldn't work in any situation, which leaves me puzzled. Are there other common causes of invalid object name errors that any of you have run across? Thanks, paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can I see line feed vs. carriage return?
MS Word will do it. -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 9:36 AM To: CF-Talk Subject: Can I see line feed vs. carriage return? What is a text editor I can use to turn on a feature that will let me see the difference between a CR and LF? Thanks! Jon ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Pagination Question
Are you using SQL Server 2005? Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Jim Curran To: CF-Talk Sent: Monday, March 27, 2006 10:45 AM Subject: DB Pagination Question Hi All, I am wondering what the best way to handle the following situation is. I have a database with approx 100,000 records. Users can search on these records with multiple criteria. Some result sets can contain 10,000 records or more. Also, there is a possibility of sorting the results. Using CF SQL server, what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? TIA. - jim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can I see line feed vs. carriage return?
-Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 11:05 AM To: CF-Talk Subject: Re: Can I see line feed vs. carriage return? binhex32 (in hex mode) On 3/27/06, Brad Wood [EMAIL PROTECTED] wrote: Doesn't MS Word to that with the little paragraph symbol button? I know it differentiates between returns and paragraph breaks... I'm not sure if it distinguishes between CR and LF (but I thought it did) but Studio/Homesite has a Show Hidden Characters option (under, surprisingly enough, the Options menu). Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFUNITED-06 Edu Student discount
Students qualify for a special student 60% discount on CFUNITED. This is ONLY for full time students at a recognized college, university or high school. Email liz (at) teratech.com if you want a code. Come to the premier ColdFusion conference of 2006 in Washington DC area 6/28-7/1/06 (Four whole days!). Check it out at http://www.cfunited.com/ * Speakers include top names like Simon Horwith, Charlie Arehart, Hal Helms, Michael Dinowitz, Ray Camden, Ben Forta and many more respected CF authors and presenters. * Great tracks: * Bootcamp - Basic ColdFusion and Flash topics * Advanced - Advanced ColdFusion topics * Manager/Empowered - Fusebox and Project management topics * Flex/RIA - Flash, Flex and other technologies integrated with CF topics * Accessibility / usability - section 508, CSS and disabled access * Deployment/Platform - tuning, install issues, OS, picking a database * Included in your full conference registration is the following: * Attendence for 4 days (6/28/2006-7/1/2006) * Keynote and General Sessions * All conference sessions including repeat sessions on Saturday * Entrance to Expo Area * Networking Events * Badge and Badge holder with bar scan code * Free Lunch for each show day (Dinner is not included) * Access to all presentations after the event, including all the recordings. * Promotional bag with materials including show guide, CD, coupons, etc. * Opportunity to participate in all raffle drawings * Can't stay 4 days Wed - Sat? Optional 3-day and Saturday only packages available too. Saturday will consist of repeats the most popular sessions from the week - something many attendees asked for last year! The timely bird price of $749 for CFUNITED-05 ends 3/31/06. Plus as a Student you get a 60% discount off this! That is $299.60 for four days, $259.60 for three or $119.60 for Saturday only. Email liz (at) teratech.com if you want a code. Students save upto $750 by registering now! Price expires4-day 3-day Saturday-only Early Bird 01/31/2006 $649$549$249 Timely Bird 03/31/2006 $749$649$299 Regular 06/16/2006 $849$749$349 Late 06/28/2006 $949$849$399 Door 06/29/2006 $1049 $949$449 Register today at http://www.cfunited.com/ -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) TeraTech voted Best Consulting Service by CFDJ readers! CF/ASP Web, VB, Math, Access programming tools and consulting 405 E Gude Dr Ste 207, Rockville MD 20850 USA Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED], or call us for more information; in the USA at 1-800-447-9120, +1-301-424-3903 International, Fax 301-762-8185 Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Pagination Question
No, MSSQL 2000 -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 1:14 PM To: CF-Talk Subject: Re: DB Pagination Question Are you using SQL Server 2005? Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Jim Curran To: CF-Talk Sent: Monday, March 27, 2006 10:45 AM Subject: DB Pagination Question Hi All, I am wondering what the best way to handle the following situation is. I have a database with approx 100,000 records. Users can search on these records with multiple criteria. Some result sets can contain 10,000 records or more. Also, there is a possibility of sorting the results. Using CF SQL server, what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? TIA. - jim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
suddenly getting high execution time on coldfusion page after increasing internet connection speed.
Hi all, i have a weird problem with a page that has an execution time of 46031 milliseconds. There is only one file that is causing the problem. If i comment out the cfinclude tag that includes the file, the page loads fine naturally. However, if I erase the contents of the file so that it is blank, it still takes a long time to process that file. Should it do that? If not, I'm at a loss as to where to go from here on solving the high execution time. Some information about the file, it contains one cfquery that debugging reports takes 0 ms for the time, and one cfif statement that checks to see if the recordcount of the query is greater than 0. If it is, it displays some html. If not, it does nothing. Thanks in advance for any and all suggestions on this mysterious problem. Charles Cruise Vice President / Network Operations Web Site Management, Inc. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Pagination Question
Jim Curran wrote: what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? Unfortunately, I believe those are your only two options. You either cache the query into resident memory (memory hog) or you run the query at each request. You can do little things like adding the MaxRows attribute to your query (which will lessen the amount of memory used per query), or using views instead of joins (to improve query speed), but I know of no other way to accomplish what you're trying to do then with query caching or a query on every page. HTH! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFTP Connection Error
Sorry. I had actually changed the name to see if it didn't like my connection name fileName with the error I posted. All the connection names are the same. I added a timeout of 500 to the connection and it did not help. The connection value actually returns an object with the name you specify. You have called it 'filename' and I'm guessing that you also have a query called 'getFileNames' with a column of filename. I think the two variables are then getting confused - I would just rename the connection to something more meaningful like 'myConnection'. HTH On 3/27/06, Doug Bedient [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: suddenly getting high execution time on coldfusion page after increasing internet connection speed.
Charles Cruise wrote: Hi all, i have a weird problem with a page that has an execution time of 46031 milliseconds. There is only one file that is causing the problem. If i comment out the cfinclude tag that includes the file, the page loads fine naturally. However, if I erase the contents of the file so that it is blank, it still takes a long time to process that file. Should it do that? If not, I'm at a loss as to where to go from here on solving the high execution time. Some information about the file, it contains one cfquery that debugging reports takes 0 ms for the time, and one cfif statement that checks to see if the recordcount of the query is greater than 0. If it is, it displays some html. If not, it does nothing. Thanks in advance for any and all suggestions on this mysterious problem. Charles Cruise Vice President / Network Operations Web Site Management, Inc. This sounds more like a problem with the processing engine then with your code. What happens to your memory usage when you run that page? Is it spiking? Have you restarted your instance of CF Server? Did it help? Is there anything that could give a clue as to what's happening in the logs? Both CFServer and apache logs? (IE: Segmentation faults of any kind?) HTH! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Hosting w/access above root folder
I'm currently a CrystalTech customer. For $27/month I get 1GB of disk space and 100GB of bandwidth to name a few. The only thing thats missing is access to a folder above my webroot so I can store docs outside of my site for security. This way I can retrieve them with cfcontent and keep the docs from url access. Does anyone know of a CFhost provider that has access to folder above the clients webroot and offer cfdirectory and cffile along with high storage and bandwidth? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Pagination Question
I believe this was talked about a couple of months back and some people suggested using a method of selecting not only max rows but to find do a hack to get the start row by using the IN keyword to somehow filter out the ones for the pages you're already past. That would do it on the DB side instead of passing the whole dataset to CF and then using the startrow and maxrows attributes of CF. May want to search the archives. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 1:49 PM To: CF-Talk Subject: Re: DB Pagination Question Jim Curran wrote: what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? Unfortunately, I believe those are your only two options. You either cache the query into resident memory (memory hog) or you run the query at each request. You can do little things like adding the MaxRows attribute to your query (which will lessen the amount of memory used per query), or using views instead of joins (to improve query speed), but I know of no other way to accomplish what you're trying to do then with query caching or a query on every page. HTH! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: suddenly getting high execution time on coldfusion page after increasing internet connection speed.
Jordan Michaels wrote: Charles Cruise wrote: Hi all, i have a weird problem with a page that has an execution time of 46031 milliseconds. There is only one file that is causing the problem. If i comment out the cfinclude tag that includes the file, the page loads fine naturally. However, if I erase the contents of the file so that it is blank, it still takes a long time to process that file. Should it do that? If not, I'm at a loss as to where to go from here on solving the high execution time. Some information about the file, it contains one cfquery that debugging reports takes 0 ms for the time, and one cfif statement that checks to see if the recordcount of the query is greater than 0. If it is, it displays some html. If not, it does nothing. Thanks in advance for any and all suggestions on this mysterious problem. Charles Cruise Vice President / Network Operations Web Site Management, Inc. This sounds more like a problem with the processing engine then with your code. What happens to your memory usage when you run that page? Is it spiking? Have you restarted your instance of CF Server? Did it help? Is there anything that could give a clue as to what's happening in the logs? Both CFServer and apache logs? (IE: Segmentation faults of any kind?) HTH! Memory usage just seems to slowly go up while the page loading. CPU usage just seems to stay steady. I restarted my instance of CF 5 Server and still does the same thing. In the application log for CF 5 server, I'm seeing ODBC Error Code = 01000 (General warning)P [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).PP SQL = which i haven't seen before in the logs. In the IIS server logs, there doesn't seem to be any errors standing out when I run the page. Thanks again, Charles Cruise Vice President / Network Operations Web Site Management, Inc. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
I'm a big fan of Dantor.com. I know for a fact you have access above your web root. as for the space and bandwidth, they have different packages, most of them below the $27 you're spending now. I've been using them for projects for about 6 years...stable, responsive, nicely priced. And as contradictory as it may sound, i'm not affiliated with them in any way other than as a customer. ;) Doug :0) I'm currently a CrystalTech customer. For $27/month I get 1GB of disk space and 100GB of bandwidth to name a few. The only thing thats missing is access to a folder above my webroot so I can store docs outside of my site for security. This way I can retrieve them with cfcontent and keep the docs from url access. Does anyone know of a CFhost provider that has access to folder above the clients webroot and offer cfdirectory and cffile along with high storage and bandwidth? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
Oh, and they've always proven themselves to be very good about keeping up with version updates. They are using MX7 and sql 2005. I'm a big fan of Dantor.com. I know for a fact you have access above your web root. as for the space and bandwidth, they have different packages, most of them below the $27 you're spending now. I've been using them for projects for about 6 years...stable, responsive, nicely priced. And as contradictory as it may sound, i'm not affiliated with them in any way other than as a customer. ;) Doug :0) I'm currently a CrystalTech customer. For $27/month I get 1GB of disk space and 100GB of bandwidth to name a few. The only thing thats missing is access to a folder above my webroot so I can store docs outside of my site for security. This way I can retrieve them with cfcontent and keep the docs from url access. Does anyone know of a CFhost provider that has access to folder above the clients webroot and offer cfdirectory and cffile along with high storage and bandwidth? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Hosting w/access above root folder
Does anyone know of a CFhost provider that has access to folder above the clients webroot and offer cfdirectory and cffile along with high storage and bandwidth? I have a site with CFDynamics and they have all you request, with their 49.95/month plan. Their less expensive plans do restrict cffile and cfdirectory. But you can get 15% off by paying for a year. http://www.cfdynamics.com/sharedhosting/sharedhosting_comparison.cfm -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFTP Connection Error
Doug, maybe you've already done this little check, but can you use the same ftp settings outside of cfftp (like in Leech or some other ftp utility) and successfully make the connection? Sorry. I had actually changed the name to see if it didn't like my connection name fileName with the error I posted. All the connection names are the same. I added a timeout of 500 to the connection and it did not help. The connection value actually returns an object with the name you specify. You have called it 'filename' and I'm guessing that you also have a query called 'getFileNames' with a column of filename. I think the two variables are then getting confused - I would just rename the connection to something more meaningful like 'myConnection'. HTH On 3/27/06, Doug Bedient [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
I can do that for you. My standard packages dont cater for that big a site but that doesnt mean i couldnt do it. I can configure a package for you however you like . And I think its almost essential ot have access to a level above the web root, for teh very purpose you're talking about. And we have full sandbox security so you can have cffile and cfdirectory turned on. (they're off by default but I turn them on for most of my own sites) Have a look at my packages at http://afpwebworks.com but ignore the disk space, bandwidth and pricing - if you're interested we'll work out something specific for you that meets your needs. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/28/06, j s [EMAIL PROTECTED] wrote: I'm currently a CrystalTech customer. For $27/month I get 1GB of disk space and 100GB of bandwidth to name a few. The only thing thats missing is access to a folder above my webroot so I can store docs outside of my site for security. This way I can retrieve them with cfcontent and keep the docs from url access. Does anyone know of a CFhost provider that has access to folder above the clients webroot and offer cfdirectory and cffile along with high storage and bandwidth? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Invalid object name
I assume SQL Server's Invalid object name error is typically a result of a missing table or mistyped table name. But I'm seeing it at a rather odd time. When I run a certain query as part of a CFC function, I receive the error Invalid object name 'dbo.tecSOLine'. But if I pull the offending query out of the CFC and run it independently, it works as expected. CF seems to know the table exists, otherwise it wouldn't work in any situation, which leaves me puzzled. Are there other common causes of invalid object name errors that any of you have run across? I've seen it throw that error on a view that contains reference to a deleted table, but that doesn't sound like what you're experiencing. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Two Servers not serving pages.. Always have before.
This morning, my site just... stopped... I restarted all cf services, on both Load-balanced web servers.. That didn't help... I restarted the servers themselves, and that still didn't help, though it turns out html pages work fine, just not cfm.. php pages also work fine. My hosting guys are working fast, but they're stumped, and so am I. One of them noticed that k2server was running and I pointed out its a cf program... but after some research.. http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19518 it turns out that xp's sp2 can cause similar behavior.. I've got them looking into. Anyway, hopefully that's the answer, but I'm hoping other people have seen this issue before and have some idea of what is going on... None of the services are remotely near spiked... I don't think even 30% of resources are being used. Anything is helpful... Any thoughts? Anyone had trouble out of k2server in this regard? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Invalid object name
What if the problem isnt the table name but the owner name? I've had similar issues, and replaced SELECT * from dbo.tecSOLine with SELECT * from tecSOLine IF that works where the other doesnt, then you probably need to either change your query code, or change the object owner. Look in Books Online for how to do it for your database, but in SQLServer2000 there's a SP you use as follows: exec sp_changeobjectowner 'dbo.secSQLine', 'otherlogin' Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/28/06, S. Isaac Dealey [EMAIL PROTECTED] wrote: I assume SQL Server's Invalid object name error is typically a result of a missing table or mistyped table name. But I'm seeing it at a rather odd time. When I run a certain query as part of a CFC function, I receive the error Invalid object name 'dbo.tecSOLine'. But if I pull the offending query out of the CFC and run it independently, it works as expected. CF seems to know the table exists, otherwise it wouldn't work in any situation, which leaves me puzzled. Are there other common causes of invalid object name errors that any of you have run across? I've seen it throw that error on a view that contains reference to a deleted table, but that doesn't sound like what you're experiencing. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DB Pagination Question
That's too bad. With SQL Server 2005 you can do this: With Books AS (select isbn, title, ROW_NUMBER() OVER(order by Title) as RowNumber from book) select * from Books where RowNumber between 2 and 14 and then just use a simple calculation for the starting and ending row numbers of the page you want to retrieve. This is how we perform efficient custom pagination for ASP.NET 2.0 GridView controls that use object data sources. The equivalent SQL Server 2000 techniques I've seen all populate temporary tables with the *entire* contents of the target table, then select only those needed from the temp table. Try *that* under load! Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Jim Curran To: CF-Talk Sent: Monday, March 27, 2006 1:27 PM Subject: RE: DB Pagination Question No, MSSQL 2000 -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 1:14 PM To: CF-Talk Subject: Re: DB Pagination Question Are you using SQL Server 2005? Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Jim Curran To: CF-Talk Sent: Monday, March 27, 2006 10:45 AM Subject: DB Pagination Question Hi All, I am wondering what the best way to handle the following situation is. I have a database with approx 100,000 records. Users can search on these records with multiple criteria. Some result sets can contain 10,000 records or more. Also, there is a possibility of sorting the results. Using CF SQL server, what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? TIA. - jim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
charset
I am getting the  character appearing when I am outputting data from a mysql database (where carriage returns should be located), I take it this is something to do with the charset for my website. The data that is stored in the database is entered through fckeditor, is this problem caused through fckeditor entering the information in a particular fashion or is this something to do with the outputting of the content. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: reg ex for url extraction..
You can just search the archives for your name and/or email address: http://www.houseoffusion.com/cf_lists/threads.cfm/4 -Original Message- From: Srinivasa Teja Palla [mailto:[EMAIL PROTECTED] Sent: Saturday, March 25, 2006 1:28 PM To: CF-Talk Subject: reg ex for url extraction.. I have a html page from which I have to extract all the links.. Just being lazy, can anyone plz give me a working regex that I can use with refind() or such? I basically need everything from a to /a, all occurances. Also, off topic, is there a place where I can go look at all my posts till now on house of fusion? I don't seem to find it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
More Sorce Control
Hello all, We are currently working on implementing a new source control system and are turning to SVN as our original VSS system was not meeting out needs. We have the development side worked out, but our problem comes when we start to consider QA. The way our codebase and development works is that we have continuous development and QA. We don't have any specific type release. We generally have more of a tag release type of promotion, where sets of pages / objects get promoted daily. While one tag is being QA'd, someone else might create another tag that uses some of the same files. To exemplify our problem consider the following example: Developer A creates a tag set with the following files: - FileA.cfm - FileB.cfm - FileC.cfm Developer A then sends his tag to QA, and QA starts testing this tag. Developer B creates a tag set with the following files: - FileC.cfm - FileD.cfm - FileE.cfm Developer B finishes their changes and merges their changes back to the trunk. Then sends his/her task to QA. At this point QA finds a problem with Developer A's tag set and pushes it back to the developer to fix. In this scenario, Developer B has finished their work on the tag set, but it has inherent problems because of the problem with developer A's work. When developer A returns to fix their problems, the code has changed and now contains developer B's code, which has not passed QA, so you cannot promote one without the other being included. Am I over thinking this problem? I can't seem to see a way to allow this type of incremental release structure without opening a can of worms once code starts to get to QA. Has anyone else run into this type of problem before? Rich Kroll Application Developer SITE Manageware, Inc. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFTP Connection Error
h... does getFileNames mean something in your code? I still suspect that could be the key to the error. but on the other hand could be a change on the ftp server you are connecting to as Doug suggests. On 3/27/06, Doug Bedient [EMAIL PROTECTED] wrote: Sorry. I had actually changed the name to see if it didn't like my connection name fileName with the error I posted. All the connection names are the same. I added a timeout of 500 to the connection and it did not help. The connection value actually returns an object with the name you specify. You have called it 'filename' and I'm guessing that you also have a query called 'getFileNames' with a column of filename. I think the two variables are then getting confused - I would just rename the connection to something more meaningful like 'myConnection'. HTH On 3/27/06, Doug Bedient [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
The only thing thats missing is access to a folder above my webroot so I can store docs outside of my site for security. The is a way to get around this problem: - store your docs in a special directory, but change the name to whatever.cfm - save the true name and type in your database. - put a file Application.cfm in the same directory that just contain CFABORT - make a tamplate to download the document with something like: cfheader name=Content-Disposition value=attachment; filename=#trueFileName# CFCONTENT TYPE=application/octet-stream FILE=#pathDoc##localName# where trueFileName is the original file name of the document, pathDoc is the path where documents are stored as CFM files, and localName is the actual name of the file. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB Pagination Question
You can do it with w/pure SQL server, but it can be pretty expensive depending on the query. The idea is to do: select top 10 * from ( select top 40 * from table order by tableId asc ) order by tableId desc You have to match up the where clauses exactly. The idea is the virtual table grabs the current page number and add one then multiply by the number of records to display (records*(page+1) = 10*(3+1).) This would pull out the top 40 records. You then order by descending grabbing out just the number of items on the page. This will grab out records 31-40. Hope this helps! -Dan -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 2:52 PM To: CF-Talk Subject: Re: DB Pagination Question That's too bad. With SQL Server 2005 you can do this: With Books AS (select isbn, title, ROW_NUMBER() OVER(order by Title) as RowNumber from book) select * from Books where RowNumber between 2 and 14 and then just use a simple calculation for the starting and ending row numbers of the page you want to retrieve. This is how we perform efficient custom pagination for ASP.NET 2.0 GridView controls that use object data sources. The equivalent SQL Server 2000 techniques I've seen all populate temporary tables with the *entire* contents of the target table, then select only those needed from the temp table. Try *that* under load! Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Jim Curran To: CF-Talk Sent: Monday, March 27, 2006 1:27 PM Subject: RE: DB Pagination Question No, MSSQL 2000 -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 1:14 PM To: CF-Talk Subject: Re: DB Pagination Question Are you using SQL Server 2005? Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com - Original Message - From: Jim Curran To: CF-Talk Sent: Monday, March 27, 2006 10:45 AM Subject: DB Pagination Question Hi All, I am wondering what the best way to handle the following situation is. I have a database with approx 100,000 records. Users can search on these records with multiple criteria. Some result sets can contain 10,000 records or more. Also, there is a possibility of sorting the results. Using CF SQL server, what is the most efficient way to paginate through the results, without hogging memory or re-running the entire query for each page view? TIA. - jim ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: More Sorce Control
Hi Rich, You need to consider using branches. These let you isolate a set of changes from the trunk. A branch can be developed and tested and QA'd separately then when signed off can be merged back to the trunk. At this point it does need retesting because of an subsequent changes. Small issues can be fixed on the trunk. You then tag the trunk at a stable point for a release of one or more merged changes. This way different changes can be merged only when they are ready and until then stay on their branch. This is how we work and our pattern of releases sounds similar to you. There are other patterns for using branches that suit other development modes. BTW Eclipse makes the merges nice and easy! On 3/27/06, Rich Kroll [EMAIL PROTECTED] wrote: Hello all, We are currently working on implementing a new source control system and are turning to SVN as our original VSS system was not meeting out needs. We -- Mike T Blog http://www.socialpoints.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Hosting w/access above root folder
Claude has a good solution there, but you could also have them create a secure directory that only you and the CF user has access to. Throw in an .htaccess file (or it's equivalent in the windows world if that's what you're on), so spiders don't try to index it. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 1:10 PM To: CF-Talk Subject: Re: CF Hosting w/access above root folder The only thing thats missing is access to a folder above my webroot so I can store docs outside of my site for security. The is a way to get around this problem: - store your docs in a special directory, but change the name to whatever.cfm - save the true name and type in your database. - put a file Application.cfm in the same directory that just contain CFABORT - make a tamplate to download the document with something like: cfheader name=Content-Disposition value=attachment; filename=#trueFileName# CFCONTENT TYPE=application/octet-stream FILE=#pathDoc##localName# where trueFileName is the original file name of the document, pathDoc is the path where documents are stored as CFM files, and localName is the actual name of the file. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: reg ex for url extraction..
I meant to remove the email address suggestion, but forgot. HOF doesn't list the email address in the archives (thankfully). -Original Message- From: Munson, Jacob Sent: Monday, March 27, 2006 1:00 PM You can just search the archives for your name and/or email address: http://www.houseoffusion.com/cf_lists/threads.cfm/4 -Original Message- From: Srinivasa Teja Palla Subject: reg ex for url extraction.. Also, off topic, is there a place where I can go look at all my posts till now on house of fusion? I don't seem to find it. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Invalid object name
Good catch, Mike. I knew that too and either it didn't occur to me or I forgot to mention it... I think it falls into the category of things that I sort of assume have already been checked. What if the problem isnt the table name but the owner name? I've had similar issues, and replaced SELECT * from dbo.tecSOLine with SELECT * from tecSOLine IF that works where the other doesnt, then you probably need to either change your query code, or change the object owner. Look in Books Online for how to do it for your database, but in SQLServer2000 there's a SP you use as follows: exec sp_changeobjectowner 'dbo.secSQLine', 'otherlogin' Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/28/06, S. Isaac Dealey [EMAIL PROTECTED] wrote: I assume SQL Server's Invalid object name error is typically a result of a missing table or mistyped table name. But I'm seeing it at a rather odd time. When I run a certain query as part of a CFC function, I receive the error Invalid object name 'dbo.tecSOLine'. But if I pull the offending query out of the CFC and run it independently, it works as expected. CF seems to know the table exists, otherwise it wouldn't work in any situation, which leaves me puzzled. Are there other common causes of invalid object name errors that any of you have run across? I've seen it throw that error on a view that contains reference to a deleted table, but that doesn't sound like what you're experiencing. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? ~~ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Invalid object name
If only! The solution may well be something as simple, but unfortunately that's not it... -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 2:05 PM To: CF-Talk Subject: Re: Invalid object name this is probably way to obvious but is the datasource the same in the cfc ... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Security image based on string
Search the House of Fusion for captcha. Tons of stuff there. M!ke -Original Message- From: Mike Garner [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 3:51 PM To: CF-Talk Subject: Security image based on string Anyone know of any CF code out there that will allow me to create a custom image based on a text string passed in? I was investigating the Java image classes, but thought I'd check first before playing too much. I'm trying to create a dynamic security image to prevent scripting - user has to type in word displayed in security image to continue... thanks for the help MG ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Import CSV file
test
Hello all!
This is probably easy stuff for most.
How do I handle null values in the source csv file when importing into db.
The following lines of code work only when there is no null value in the
source file.
Also how do I handle commas that are in the data itself.
Is there a custom tag or cf based utility that does all that which I can
execute from a cf template?
Codes that work only when the source file has no null fields or commas:
!--- get and read the CSV file ---
cffile action=read file=Somefile.csv variable=csvfile
!--- loop through the CSV file on line breaks and insert into
database ---
cfloop index=index list=#csvfile# delimiters=#chr(10)##chr(13)#
cfquery name=importcsv datasource=somedatasource
INSERT INTO Table1
(modelno,details,dealerpartno,rrp,costprice,brand,subcategory)
VALUES
('#listgetAt('#index#',1, ',')#',
'#listgetAt('#index#',2, ',')#',
'#listgetAt('#index#',3, ',')#',
'#listgetAt('#index#',4, ',')#',
'#listgetAt('#index#',5, ',')#',
'#listgetAt('#index#',6, ',')#',
'#listgetAt('#index#',7)#'
)
/cfquery
/cfloop
Mush appreciate any help.
Thanks heaps.
Ben.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236283
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Security image based on string
I second that. There are a number of functions out there, some free and some not. A search for captcha will wrangle you some good results. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 3:53 PM Search the House of Fusion for captcha. Tons of stuff there. -Original Message- From: Mike Garner [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 3:51 PM Anyone know of any CF code out there that will allow me to create a custom image based on a text string passed in? I was investigating the Java image classes, but thought I'd check first before playing too much. I'm trying to create a dynamic security image to prevent scripting - user has to type in word displayed in security image to continue... This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
You're serious about this? are you sure you didn't just setup your default
dreamweaver site to show from www/
I took a look at the hosting plan and of course there is nothing there about
this except the following. They allow you to host unlimited Microsoft Access
Databases on your site. Are they really saying you need to host those in
your www directory? javascript:BringUpWindow('popups/access.htm')
You've got to be missing something... I went though a period where I was
changing hosting companies like socks and I've never seen that. Especially
since I've seen people post crystaltech from time to time.
On 3/27/06, j s [EMAIL PROTECTED] wrote:
I'm currently a CrystalTech customer. For $27/month I get 1GB of disk
space and 100GB of bandwidth to name a few. The only thing thats missing is
access to a folder above my webroot so I can store docs outside of my site
for security. This way I can retrieve them with cfcontent and keep the docs
from url access.
--
Casey Dougall
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236285
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Hosting w/access above root folder
I have been around and around fighting for a potential client on this
Issue and they are dead set there is no directory access outside the
root web folder.
-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 6:57 PM
To: CF-Talk
Subject: Re: CF Hosting w/access above root folder
You're serious about this? are you sure you didn't just setup your default
dreamweaver site to show from www/ I took a look at the hosting plan and of
course there is nothing there about this except the following. They allow
you to host unlimited Microsoft Access Databases on your site. Are they
really saying you need to host those in your www directory?
javascript:BringUpWindow('popups/access.htm')
You've got to be missing something... I went though a period where I was
changing hosting companies like socks and I've never seen that. Especially
since I've seen people post crystaltech from time to time.
On 3/27/06, j s [EMAIL PROTECTED] wrote:
I'm currently a CrystalTech customer. For $27/month I get 1GB of
disk space and 100GB of bandwidth to name a few. The only thing
thats missing is access to a folder above my webroot so I can store
docs outside of my site for security. This way I can retrieve them
with cfcontent and keep the docs from url access.
--
Casey Dougall
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236286
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cflogin and load balancing
I've been wondering why the CF team has not switched over to using J2EE security. A rewrite of cflogin code that can use JAAS would be just swell and allow integration with non CF J2EE products without messing with web.xml files and such, eh? DK On 3/27/06, wolf2k5 [EMAIL PROTECTED] wrote: On 3/26/06, Adam Churvis [EMAIL PROTECTED] wrote: It doesn't work that way. Since your CFLOGINUSER call is inside a CFLOGIN call, that CFLOGIN call *won't* run when the second server sees your authentication cookie because CFLOGIN only runs when you are *not* authenticated. Actually, according to my testing (ColdFusion 6.1 with the Updater), when the second server sees the cflogin cookie, it will automatically run the cflogin/cfloginuser code and authenticate/authorize the user. Can anyone verify this with ColdFusion MX 7? Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
HostMySite provides access to the account root, serving web content from a folder under that. For your $27.95 you could get 4GB of space and 60GB of bandwidth. http://www.hostmysite.com/hosting/builder/ On 3/28/06, Coldfusion [EMAIL PROTECTED] wrote: I have been around and around fighting for a potential client on this Issue and they are dead set there is no directory access outside the root web folder. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Hosting w/access above root folder
http://www.fusionlink.com/ ck'em out On 3/27/06, James Holmes [EMAIL PROTECTED] wrote: HostMySite provides access to the account root, serving web content from a folder under that. For your $27.95 you could get 4GB of space and 60GB of bandwidth. http://www.hostmysite.com/hosting/builder/ On 3/28/06, Coldfusion [EMAIL PROTECTED] wrote: I have been around and around fighting for a potential client on this Issue and they are dead set there is no directory access outside the root web folder. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfm vs. php?
will admit upfront: i haven't a clue about CF. which is why i'm here. i'm trying to design an application where: user fills out some forms (submits) then their input is gathered + spit back out in a flash movie i've seen this accomplished in both .php and .cfm but don't know what the difference is between the two or the PROS/CONS of each. can someone help me figure it out?? many many thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
where to start Ajax or Flex?
I don't know a lick of Java and have played with Flash Remoting and AS 2. I can see the future in either Ajax of Flex. I'm sorta leaning towards Ajax cause from my understanding its cheaper, now, and I think it can be deployed on any hosting services. Also correct me if I'm wrong but Flex since it uses Flash Player the stage can't be set dynamicaly. If I build a dynamic form or page or menu system that varies in size I would have to plan out the stage size ahead of time. Thats not dynamic. I hope I'm wrong on this. I haven't see or notice much talk about CF and Ajax. Can someone point me in the right direction on how to get started and their experience with either of the two. Also how limited is Backbase for CF or CFAjax? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfm vs. php?
thanks eric - this helps. while i now clearly see the CF light...there's gotta be a darkside lurking somewhere. yeah? maybe just a little bitty one? scenario: i'm a designer trying to steer our team in a good direction but i stop at HTML. to me, the applications i've seen done in PHP aren't as elegant (?) as similar ones in CFM. (PHP has that e-commerce aftertaste) so i can feel realatively OK making a recommendation based on an internet forum exchange :) --- if CF is so perfect, why aren't more people using it? i understand why coders must love it, but are users as happy? it is buggy? slow? thanks so much best, amanda On 3/27/06, Eric Roberts [EMAIL PROTECTED] wrote: I would say mostly the coding time. CF is close to what I would call a rapid application development tool for the web. I also find it to be close to an OOP approach to programming than PHP. The code itself is less intensive (though just as powerful) that PHP. It cost more, but so does any quality tool. I am not an expert in PHP, but if it is anything like ASP, you would have to spend (either in actual dollars or in programming time) the same amount that CF costs to get it to the same functional level as CF is out of the box. The extensibility of CF is amazing. Ben Forta, who is the CF Product Evangelist and General God of CF, put it best, CF is as extensible as your programmers. If you can write it in a language that produces a dll, you can make it into a CF custom tag. You also have the advantage for your app, of real tight integration with flash and other macromedia and soon...adobe technologies. The language itself, since it is tag based is real easy to learn. It's outward similarity to HTML gives it a familiar feel that makes learning a snap. Or those that can afford it, Fast Track to CF, which is a 3 day course, will take someone with no knowledge of CF and in 3 days give them the ability to write complex web apps with it. I consider that a big huge mark on the pro side hehehe. I am a bit biased though ;-) Eric -Original Message- From: amanda bradshaw [mailto:[EMAIL PROTECTED] Sent: Monday, 27 March 2006 21:14 To: CF-Talk Subject: cfm vs. php? will admit upfront: i haven't a clue about CF. which is why i'm here. i'm trying to design an application where: user fills out some forms (submits) then their input is gathered + spit back out in a flash movie i've seen this accomplished in both .php and .cfm but don't know what the difference is between the two or the PROS/CONS of each. can someone help me figure it out?? many many thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfm vs. php?
I think its a question of money. PHP is free, and most hosting services offer it. thanks eric - this helps. while i now clearly see the CF light...there's gotta be a darkside lurking somewhere. yeah? maybe just a little bitty one? scenario: i'm a designer trying to steer our team in a good direction but i stop at HTML. to me, the applications i've seen done in PHP aren't as elegant (?) as similar ones in CFM. (PHP has that e-commerce aftertaste) so i can feel realatively OK making a recommendation based on an internet forum exchange :) --- if CF is so perfect, why aren't more people using it? i understand why coders must love it, but are users as happy? it is buggy? slow? thanks so much best, amanda On 3/27/06, Eric Roberts [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfm vs. php?
Exactly. To quote Heinlein, The answer to any question that begins with 'Why don't they' is invariably 'Money'. On 3/28/06, j s [EMAIL PROTECTED] wrote: I think its a question of money. PHP is free, and most hosting services offer it. thanks eric - this helps. while i now clearly see the CF light...there's gotta be a darkside lurking somewhere. yeah? maybe just a little bitty one? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: where to start Ajax or Flex?
I've been very happy with CFAJAX - it offes a good feature set and it can be deployed without mappings or any other admin changes. AjaxCFC is similar in some ways, and there are other options like JSMX and Neuromancer. In general I've found AJAX techniques to be relatively easy to use (via CFAJAX), providing a user interface with which the user is familiar (html). My Fusion Authority article on CF and AJAX may also assist: http://www.fusionauthority.com/Techniques/4593-Using-AJAX-with-ColdFusion-Part-I On 3/28/06, j s [EMAIL PROTECTED] wrote: I don't know a lick of Java and have played with Flash Remoting and AS 2. I can see the future in either Ajax of Flex. I'm sorta leaning towards Ajax cause from my understanding its cheaper, now, and I think it can be deployed on any hosting services. Also correct me if I'm wrong but Flex since it uses Flash Player the stage can't be set dynamicaly. If I build a dynamic form or page or menu system that varies in size I would have to plan out the stage size ahead of time. Thats not dynamic. I hope I'm wrong on this. I haven't see or notice much talk about CF and Ajax. Can someone point me in the right direction on how to get started and their experience with either of the two. Also how limited is Backbase for CF or CFAjax? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfm vs. php?
-Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 28, 2006 12:38 AM To: CF-Talk Subject: Re: cfm vs. php? Exactly. To quote Heinlein, The answer to any question that begins with 'Why don't they' is invariably 'Money'. And this works on both sides of the spectrum. I've been told more than once in my company that CF isn't expensive enough to be an enterprise-capable product. They'd rather spend $70,000 on WebSphere. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfm vs. php?
Hey, they can buy Websphere and then deploy CF Enterprise in it - that makes it even more expensive so it has to be even better! On 3/28/06, Jim Davis [EMAIL PROTECTED] wrote: -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 28, 2006 12:38 AM To: CF-Talk Subject: Re: cfm vs. php? Exactly. To quote Heinlein, The answer to any question that begins with 'Why don't they' is invariably 'Money'. And this works on both sides of the spectrum. I've been told more than once in my company that CF isn't expensive enough to be an enterprise-capable product. They'd rather spend $70,000 on WebSphere. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: where to start Ajax or Flex?
-Original Message- From: j s [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 11:21 PM To: CF-Talk Subject: where to start Ajax or Flex? I haven't see or notice much talk about CF and Ajax. Can someone point me in the right direction on how to get started and their experience with either of the two. Also how limited is Backbase for CF or CFAjax? I'm sorry: I've no idea what you mean by backbase. ;^) There are no less than three major ColdFusion+AJAX projects. And with that I'm sure I'm missing some. http://www.robgonda.com/blog/projects/ajaxcfc/ http://www.indiankey.com/cfajax/ http://www.lalabird.com/ There are countless mini projects focusing on constrained aspects, interface widgets, etc. For just plain data passing from CF to JavaScript I like (go figure!) my own implementation here: http://www.depressedpress.com/Content/Development/YODEL/Index.cfm Using the handler registration capability you can create very complexdata profiles very easily. I've used it successfully with highly complex AJAX applications with no problem. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Reg Expression to revome (most) punctuation
I know this will be simple for some .. but it isn't for me .. I have tried to find something for this. I need to remove all punctuation except for spaces between words. I only want alpha and numeric (plus spaces) left. Example: Str = I don't remember, if it was 12 or 12'? Result = I dont remember if it was 12 or 12 I have tried a few things and I can remove EVERYTHING, but can't get it to leave just the spaces. THANKS Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: where to start Ajax or Flex?
Backbase: http://www.backbase.com/ It's a server-side engine thing that requires J2EE or .NET, rather than directly supporting CF in the way that CFAJAX and ajaxCFC (etc) do. All in all it looks like a pain, but I haven't tried it so I can't have an opinion. BTW, I mentioned YODEL in the FA article :-) On 3/28/06, Jim Davis [EMAIL PROTECTED] wrote: -Original Message- From: j s [mailto:[EMAIL PROTECTED] Sent: Monday, March 27, 2006 11:21 PM To: CF-Talk Subject: where to start Ajax or Flex? I haven't see or notice much talk about CF and Ajax. Can someone point me in the right direction on how to get started and their experience with either of the two. Also how limited is Backbase for CF or CFAjax? I'm sorry: I've no idea what you mean by backbase. ;^) There are no less than three major ColdFusion+AJAX projects. And with that I'm sure I'm missing some. http://www.robgonda.com/blog/projects/ajaxcfc/ http://www.indiankey.com/cfajax/ http://www.lalabird.com/ There are countless mini projects focusing on constrained aspects, interface widgets, etc. For just plain data passing from CF to JavaScript I like (go figure!) my own implementation here: http://www.depressedpress.com/Content/Development/YODEL/Index.cfm Using the handler registration capability you can create very complexdata profiles very easily. I've used it successfully with highly complex AJAX applications with no problem. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Reg Expression to revome (most) punctuation
rereplacenocase(string, '[a-z0-9 ]+', '', 'all') This will remove every occurences of a character that is NOT within the range of A-Z (both cases), 0-9 or a space. This will include ANY non-number/letter character so if there is something you want to keep, it has to be included within the brackets. I know this will be simple for some .. but it isn't for me .. I have tried to find something for this. I need to remove all punctuation except for spaces between words. I only want alpha and numeric (plus spaces) left. Example: Str = I don't remember, if it was 12 or 12'? Result = I dont remember if it was 12 or 12 I have tried a few things and I can remove EVERYTHING, but can't get it to leave just the spaces. THANKS Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
