Re: CFHTTP weirdness - Connection Timeout
this worked for me cfhttp method=get url=http://64.119.37.62/xml; result=web cfdump var=#web# FileContent: ?xml version=1.0? FSHost ServerNameWest Coast ATC - 24HR 1/ServerName /FlightPlan /FlightPlans /FSHost On 5/18/07, Jared Smith [EMAIL PROTECTED] wrote: I'm trying to use CFHTTP to capture a simple XML file from a remote server - cfhttp url=http://64.119.37.62/xml; method=GET timeout=10 When I try to access the #cfhttp.filecontent# is shows only Connection Timeout. However, I can access the file from a browser on the server, the cfhttp.errorDetail is empty, the cfhttp.statusCode is 200, the mimeType is being picked up correctly, and if I sniff the packets I see the entire file is send to CF. And if I set the path and file attributes of CFHTTP, the XML file is saved successfully to my server. So why is #cfhttp.filecontent# broken? It only does this for some sites. With most of them, everything works fine, but with this site and others like it, CF is choking on the content somewhere. I have tried setting the character set, setting user-agent, setting the Accept-Encoding and TE headers to deflate;q=0 to solve any compression issues, and about everything else I can think of. Can anyone else try to CFHTTP that file (http://64.119.37.62/xml) and see if it works? This is a FRESH install of MX 7. Frustrated! Jared ~| 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:278560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java unzip :: verify file
Max has taken it up a notch now
You can use this class in replace of 'java.util.zip.ZipFile'
and it throws an error on init() that can be captured by ColdFusion if the
file is corrupt.
The downside though, is the zip is processed twice, once to verify it, and
then again for the normal processing. But compared to taking out jRun, I
think it is a small price to pay.
!--- start ZipFileVerifier.java ---
import java.io.File;
import java.io.FileInputStream;
import java.util.zip.ZipFile;
import java.util.zip.ZipInputStream;
public class ZipFileVerifier extends ZipFile {
private static Exception _EXCEPTION = null;
public ZipFileVerifier(String filePath) throws Exception {
super(filePath);
if( !verifyZip(filePath) )
throw _EXCEPTION;
}
private ZipFileVerifier(File file) throws Exception {
super(file);
if( !verifyZip(file) )
throw _EXCEPTION;
}
private ZipFileVerifier(File file, int mode) throws Exception {
super(file, mode);
if( !verifyZip(file) )
throw _EXCEPTION;
}
public static boolean verifyZip(String filePath) {
return verifyZip(new File(filePath));
}
public static boolean verifyZip(File file) {
try {
ZipInputStream zipin = new ZipInputStream(new FileInputStream(file)) ;
while( zipin.available() == 1 ) {
zipin.getNextEntry();
}
return true;
}
catch( Exception e ) {
_EXCEPTION = e;
}
return false;
}
public static Exception getException() {
return _EXCEPTION;
}
public static void main(String[] args) {
if( args.length 0 ) {
try {
new ZipFileVerifier(args[0]);
}
catch( Exception e ) {
System.out.println( e );
}
}
else {
System.out.println( usage: java ZipFileVerifier zipfile path );
}
}
}
!--- end ZipFileVerifier.java ---
~|
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:278561
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL on CF server
Considering CF can't use over 1.5 gb memory give or take, Per instance I believe not as a whole. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Casey Dougall To: CF-Talk Sent: Fri May 18 00:41:13 2007 Subject: Re: MySQL on CF server Considering CF can't use over 1.5 gb memory give or take, I'd say you would have plenty for other applications, I wouldn't expect your applications to run any faster then they are now. Separation is the best alternative, expecially with mail since you need to run anti virus against it. That's about the most memory intensive app you could have running on the box. We run mysql and CF and IIS on a single box without problems. How many visitors are you talking about. I think our biggest hurdle is thread allocation. Only running CF Standard is becoming troublesome when using cfdocument. That tag sucks ass, and I don't expect things to be much better in Scorpio unless same with CF7, you go with enterprise. -- Casey ~| 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:278562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does CF Framework make life easier? Which one to start?
On 5/17/07, James Wolfe [EMAIL PROTECTED] wrote: I cant speak about Frameworks in general, but I can tell you to avoid FuseBox like the plague. Oh dear... there's always one, isn't there? If all you ever coded in was fusebox, then maybe its an OK framework to work with. I didn't much care for Fusebox 3. I thought Fusebox 4 was OK, Fusebox 4.1 was an improvement. I wrote Fusebox 5 and 5.1 and I'm busy writing Fusebox 6 (the current feeling in the Fusebox community is that we might call it 5.5). I've written applications with various versions of Fusebox (in both PHP and CFML), Mach II (in both PHP and CFML), Model-Glue and no framework. I've used ColdSpring with all of the above. I've used Reactor and Transfer with ColdSpring (and Model-Glue). I've contributed code to pretty much every framework I've used so I like to think that I know the pros and cons of all those frameworks pretty well. I hear lots of good things about ColdBox but haven't had a chance to try it out yet. Frameworks are definitely a Good Thing. The only one with books available is Fusebox. Jeff Peters' new Fusebox 5.1 book (from Proton Arts) is very good, covering both Fusebox and the FLiP methodology. We hired a new developer who told us that FuseBox was the bomb and that he knew it. We gave him a specific project to code using FuseBox and to this day we regret it. The code is so difficult to read, understand and debug that any possible gain in the form of reusable code is immediately lost many times over in finding the code you intend to reuse. That's almost certainly because HE WAS A BAD DEVELOPER! Don't blame the framework for his poor code. You can write bad code with *any* framework if you are (a) a bad programmer or (b) determined enough. I've seen bad Mach II good too. I haven't seen enough Model-Glue code to see much bad code there but I bet it exists out there. Maybe the project was too large for FuseBox. Maybe the guy was incompetent (he no longer works for us). But we deeply regret allowing him to code that project in FuseBox and have not even considered using it again. Fusebox is very good at handling large projects because it supports modular development (with circuits). I'm sorry that one bad experience with one bad developer has made you avoid using a very popular, well-supported, well-documented framework that powers a large number of large (and small) websites. It's Fusebox, BTW, small 'b'. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:278563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Scorpio questions
Will Scorpio fix the problem which CF7 has when trying to swap out shipped components which updates one? In particular iText, JavaMail, Axis. Will 7 ever get Java 1.5/1.6 capabilities with an update? With JRun being EOL (as it appears) will ColdFusion ever ship with another J2EE server for free use? JBoss/Tomcat? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| 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:278564 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scorpio questions
On 5/18/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Will Scorpio fix the problem which CF7 has when trying to swap out shipped components which updates one? In particular iText, JavaMail, Axis. Since Scorpio is covered by NDA, no one can answer this (except Adobe staff, I guess). Will 7 ever get Java 1.5/1.6 capabilities with an update? I would be very surprised if CFMX7 was updated to support Java 5 or Java 6. With JRun being EOL (as it appears) will ColdFusion ever ship with another J2EE server for free use? JBoss/Tomcat? Why do you think JRun is being EOL'd? Seems like Adobe have more control over the stability and feature set if they ship CF with JRun... FWIW, Ben Forta has said that JBoss support is being added in Scorpio. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:278565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scorpio questions
Well, I say JRun is on the out due to it not been feature updated in years and a beta was canned for a new version. It's had it I think and for sure it's an easy win for Adobe to include it but it's by no way the best fit for that role IMO. JBoss support is a big wn for sure. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Sean Corfield To: CF-Talk Sent: Fri May 18 08:46:45 2007 Subject: Re: Scorpio questions On 5/18/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Will Scorpio fix the problem which CF7 has when trying to swap out shipped components which updates one? In particular iText, JavaMail, Axis. Since Scorpio is covered by NDA, no one can answer this (except Adobe staff, I guess). Will 7 ever get Java 1.5/1.6 capabilities with an update? I would be very surprised if CFMX7 was updated to support Java 5 or Java 6. With JRun being EOL (as it appears) will ColdFusion ever ship with another J2EE server for free use? JBoss/Tomcat? Why do you think JRun is being EOL'd? Seems like Adobe have more control over the stability and feature set if they ship CF with JRun... FWIW, Ben Forta has said that JBoss support is being added in Scorpio. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:278566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scorpio questions
Robertson-Ravo, Neil (RX) wrote: Will Scorpio fix the problem which CF7 has when trying to swap out shipped components which updates one? In particular iText, JavaMail, Axis. Did you report this as a bug and did you receive a bug number? Will 7 ever get Java 1.5/1.6 capabilities with an update? I would be very surprised if Adobe were to do that. With JRun being EOL (as it appears) will ColdFusion ever ship with another J2EE server for free use? JBoss/Tomcat? Ben recently announces JBoss support for Scorpio. Jochem ~| 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:278567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: User's getting other user's sessions
On Thursday 17 May 2007, James Wolfe wrote: Either way, general suggestions were to ensure that you have proper locking around any code that sets Session variables. And CFC method-local variables are var'ed. -- Tom Chiverton Helping to autoschediastically promote collaborative content on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does CF Framework make life easier? Which one to start?
On Thursday 17 May 2007, Greg Luce wrote: I have to disagree. Fusebox 3 is not the way to go. I don't do GUIs in HTML anymore, but a FB3 config file looks a lot easier to understand than the newer ones. -- Tom Chiverton Helping to heterogeneously reintermediate web-enabled content on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL on CF server
And only on certain platforms. We've got a 2.5GB instance on SPARC/Solaris that runs fine. On 5/18/07, Robertson-Ravo, Neil (RX) wrote: Considering CF can't use over 1.5 gb memory give or take, Per instance I believe not as a whole. -Original Message- From: Casey Dougall To: CF-Talk Sent: Fri May 18 00:41:13 2007 Subject: Re: MySQL on CF server Considering CF can't use over 1.5 gb memory give or take, I'd say you would have plenty for other applications -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:278570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: User's getting other user's sessions
Could it be a caching issue? On 5/17/07, robert t Flesher [EMAIL PROTECTED] wrote: All, We are having a problem which involves users that log into a system, then after logging in get their session switched to another user's session. We are running 4 cold fusion MX 7 servers behind a CISCO layer 4 switch for load balancing, but we have already verified the users are not being switched between boxes so that is not the issue. We are using J2EE sessions. Has anyone seen this type of issue before? Thanks, Rob Flesher _ Catch suspicious messages before you open themwith Windows Live Hotmail. http://imagine-windowslive.com/hotmail/?locale=en-usocid=TXT_TAGHM_migration_HM_mini_protection_0507 ~| 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:278571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does CF Framework make life easier? Which one to start?
I have no OO background. Till now I just used coldfusion tags to make my projects. It was easy and with a little help from Dreamweaver it was the easiest programming experience I ever had. recently after making 10 online catalogs for a friend I realized there might be a problem to manage all the code for all catalogs. After a little googling I saw the expression FrameWork. I had no idea what it is. Honestly right now I don't know what exactly a framework is and how it works and how I can start working with that. Your posts helped a lot but I think what I really need is an example based basic tutorial that helps me understand the meanining of a framework. Thanks Ali ~| 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:278573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression to count links
On Friday 18 May 2007, K Simanonok wrote: Tom, you may be well-intentioned, but do you realize your posts were useless? A question like Hey buddy, can you tell me where the train station is? is never intended to be taken so literally that yes is a worthwhile answer. You didn't ask 'how do I'. You asked 'is it possible'. -- Tom Chiverton Helping to vitalistically market prospective relationships on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfloop output into columns - help
Might have got the wrong end of the stick here but don't you just need colspan? cfif (currentrow mod 2 EQ 0) or (currentrow EQ recordcount) td colspan=2#getFoo.fname# #getFoo.lname#/td cfelse td#getFoo.fname# #getFoo.lname#/td td#getFoo.fname[currentrow+1]# #getFoo.lname[currentrow+1]#/td /cfif ~| 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:278574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL sum question
I have a db table that stores basic historical page view data. Each day a
task runs and inserts the date, a record of the pages viewed and a count of
how many times each was viewed. It's easy to select the most viewed pages
for a given date using:
select pname,pagehit
from tbl_log_page_count
where CONVERT(char(8), logdate, 112) =
#DateFormat(DateAdd('d',-1,now()),'mmdd')#
order by pagehit desc
What I'd like to be able to do is aggregate the data for a given date range
so if my table had (date,hits,page) :
15-5-2007 | 2 | /index.cfm
15-5-2007 | 4 | /about-us.cfm
15-5-2007 | 3 | /not-about-us.cfm
14-5-2007 | 1 | /index.cfm
14-5-2007 | 6 | /about-us.cfm
14-5-2007 | 2 | /not-about-us.cfm
I would like to be able to get this for the shown date range:
3 | /index.cfm
10 | /about-us.cfm
5 | not-about-us.cfm
I can achieve what I want by creating a new query, looping over the distinct
pagenames and summing all found hit counts in the time period but it's slow
and seems messy. The date range bit isn't a problem but I can't figure out
if it's possible to sum the pagehit column for each occurence of a page
name. The closest I've got is below but this only sums the hitcount where
the page name and hitcount match (i.e. if I have the same number of page
views for a given page on multiple dates):
select pname,sum(pagehit) as pagehit
where dates between x and y
group by pname, pagehit
order by pagehit desc, pname
Not sure if it's even possible to achieve what I want with a single query.
Any ideas?
Thanks
Gareth
~|
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:278575
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 sum question
I really should have been able to figure that out. Hopefully I'll remember next time :) Many thanks Jochem. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, May 18, 2007 12:36 PM Subject: Re: SQL sum question Gareth Hughes wrote: select pname,sum(pagehit) as pagehit where dates between x and y group by pname, pagehit order by pagehit desc, pname select pname,sum(pagehit) as pageHitCumul where dates between x and y group by pname order by sum(pagehit) desc, pname Jochem ~| 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:278578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfloop output into columns - help
Since the column(s) would be in their own tables... no -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 5:22 AM To: CF-Talk Subject: Re: cfloop output into columns - help Might have got the wrong end of the stick here but don't you just need colspan? cfif (currentrow mod 2 EQ 0) or (currentrow EQ recordcount) td colspan=2#getFoo.fname# #getFoo.lname#/td cfelse td#getFoo.fname# #getFoo.lname#/td td#getFoo.fname[currentrow+1]# #getFoo.lname[currentrow+1]#/td /cfif ~| 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:278577 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 sum question
Gareth Hughes wrote: select pname,sum(pagehit) as pagehit where dates between x and y group by pname, pagehit order by pagehit desc, pname select pname,sum(pagehit) as pageHitCumul where dates between x and y group by pname order by sum(pagehit) desc, pname Jochem ~| 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:278576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query of query - clob error
I have a nice little query of query going (brilliant little tool query of queries are). Unfortunately, it seems that if my SELECT specifies a field that's a CLOB, then I receive an error. Here's the error: Query Of Queries runtime error. Unsupported SQL type java.sql.Types.CLOB. Oddly, If I don't specify a list of fields and only do SELECT * then everything works a-okay. Whatup with that? Any help? daniel ~| 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:278580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does CF Framework make life easier? Which one to start?
The config file or the circuit file? I think there was an fbx_settings.cfm and fbx_circuits.cfm where you would do config type stuff. Are you talking about the fbx_switch.cfm vs the circuit.xml.cfm? The XML really isn't that complex. 10 minutes should be enough to familiarize with the syntax used in there. XML is just another structured language probably much simpler than HTML. Greg On 5/18/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 17 May 2007, Greg Luce wrote: I have to disagree. Fusebox 3 is not the way to go. I don't do GUIs in HTML anymore, but a FB3 config file looks a lot easier to understand than the newer ones. -- Tom Chiverton Helping to heterogeneously reintermediate web-enabled content on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Concepts of Developing Locally with CFEclipse
Hey, Rick, I was in the same situation until a few months ago: developing code on numerous production sites. I installed CF 7 and Apache on my local machine and set up virtual hosts for each of my production sites such that if I wanted to view the local version of the site, I would enter: http://local.foo.com and to view the production site, I would enter: http://www.foo.com I was able to access the production database server from my local CF server, so both the production version and development version of the application can access the same set of tables (easier than replicating the production database tables locally, but it does mean I have to be a little careful with my database transactions in development). I'm just now fleshing out my technique for assigning template path/file location variables differently depending on whether the application is running locally or on the production server. My current plan is to determine the application's location using cgi.cf_template_path during application start-up: in my case, if that variable starts with C:, I know I'm running locally. Once I know where the app is running, I can assign the location-sensitive variables appropriately. I'm also using CFEclipse as my primary IDE. The only problem is that we use WebDAV to access the production server filesystem, and for whatever reason the FTP/WebDAV plugin for Eclipse will not talk to our WebDAV server (actually, knowing our environment, it's probably the other way around). So I still use Dreamweaver for pushing changes up to the server. --Brian ~| 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:278582 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 of query - clob error
Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. HTH Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 8:07 AM To: CF-Talk Subject: query of query - clob error I have a nice little query of query going (brilliant little tool query of queries are). Unfortunately, it seems that if my SELECT specifies a field that's a CLOB, then I receive an error. Here's the error: Query Of Queries runtime error. Unsupported SQL type java.sql.Types.CLOB. Oddly, If I don't specify a list of fields and only do SELECT * then everything works a-okay. Whatup with that? Any help? daniel ~| 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:278583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does CF Framework make life easier? Which one to start?
Wikipedia definition of a software framework: http://en.wikipedia.org/wiki/Software_framework I'm sure you can find more with a bit of googling: Mark On 5/18/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: I have no OO background. Till now I just used coldfusion tags to make my projects. It was easy and with a little help from Dreamweaver it was the easiest programming experience I ever had. recently after making 10 online catalogs for a friend I realized there might be a problem to manage all the code for all catalogs. After a little googling I saw the expression FrameWork. I had no idea what it is. Honestly right now I don't know what exactly a framework is and how it works and how I can start working with that. Your posts helped a lot but I think what I really need is an example based basic tutorial that helps me understand the meanining of a framework. Thanks Ali ~| 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:278579 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 of query - clob error
Just a shot in the dark here, did you enable that setting in the cf administrator I don't have access to CFAdministrator because I'm in a shared hosting environment here where the IT of the University does all the server tasks. What setting needs to be enabled? I can do QofQ, but just not with specified CLOBS, though if I don't specify the CLOBs the fields come through fine. and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I'm not sure I understand. In this example, my CLOB is notes. If I do: SELECT meeting_name,type,note_date,type_describe - IT WORKS but SELECT meeting_name,type,note_date,type_describe,notes - IT FAILS (I added notes). but SELECT * - IT WORKS and also exports 'notes' which made it fail before. But it also exports tons of stuff the user shouldn't be able to see. Glad to hear that it might be curable. daniel ~| 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:278584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with spaces in value of a list in a URL that is delimited with + sign
I've run out of ideas in how to fix this situation: Another application that uses the plus sign as a delimiter links to my site with a variable called search. It seems ColdFusion replaces the + sign with spaces before I can get at the variable values from a URL. It's only a problem if a value in the list already had spaces, like: search=liver+diet and nutrition+eyes When I do a cfdump on the variable search, I get: liver diet and nutrition eyes Looping through the list with the delimiter + or or , displays the same as the dump. How can I make the values separated properly by a comma, like: liver,diet and nutrition,eyes Help! and Thanks. Joy ~| 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:278585 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 weirdness - Connection Timeout
On 5/18/07, AJ Mercer [EMAIL PROTECTED] wrote: this worked for me cfhttp method=get url=http://64.119.37.62/xml; result=web cfdump var=#web# Thanks. This is so frustrating. This used to work fine, but suddenly stopped a few months ago. I've even formatted, fresh reinstalled Windows, and upgraded from 6.1 to MX 7 and the problem continues - primarily with sites that provide that XML file. Other sites tend to work fine. Your exact code will execute the dump as follows for me: Charset: [empty string] ErrorDetail: [empty string] Filecontent: Connection Timeout Header: HTTP/1.1 200 OK Content-type: text/xml Pragma: no-cache Cache-Control: no-cache Mimetype: text/xml Responseheader [ Cache-Control: no-cache Content-type: text/xml Explanation: OK Http_Version: HTTP/1.1 Pragma: no-cache Status_Code: 200 Statuscode: 200 OK ] Text: YES I guess I could use CFHTTP to write the file to disk, then use CFFILE to open it, but that is WAY more overhead than I want. I'd much rather just get CFHTTP working like it's supposed to. :-( Any other ideas? ~| 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:278586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Errant Web-inf directories
Any chance you could qualify your claims that re-compiling is faster than reading from the cached .class (even if there are 20k files in the folder). Even with a small cfm/function i'd be VERY suprised if this is the case. Perhaps you could enlighten me? D What's in those other WEB-INF directories? I suspect they don't contain the entire contents of the original WEB-INF directory. Well, in one example, there are 19,195 .class files. Not as many as are in the root web-inf, no. But, a sizable amount. Is that all that's in there, compiled classes? Is that all that's in your original one? And, that's a lot of class files. You should probably disable the option to save class files in CF Administrator. In your environment, it's likely to take longer to find one file out of twenty thousand in a single directory, than to just recompile the source. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: problem with spaces in value of a list in a URL that is delimited with + sign
You could pull it from cgi.query_striung instead. That should preserve everything just as you see it. -Original Message- From: Joy Holman [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 8:48 AM To: CF-Talk Subject: problem with spaces in value of a list in a URL that is delimited with + sign I've run out of ideas in how to fix this situation: Another application that uses the plus sign as a delimiter links to my site with a variable called search. It seems ColdFusion replaces the + sign with spaces before I can get at the variable values from a URL. It's only a problem if a value in the list already had spaces, like: search=liver+diet and nutrition+eyes When I do a cfdump on the variable search, I get: liver diet and nutrition eyes Looping through the list with the delimiter + or or , displays the same as the dump. How can I make the values separated properly by a comma, like: liver,diet and nutrition,eyes Help! and Thanks. Joy ~| 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:278588 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 weirdness - Connection Timeout
that should be CF Service On 5/18/07, AJ Mercer [EMAIL PROTECTED] wrote: try running your ColdFusion servers with the same account your are logging onto the server with On 5/18/07, Jared Smith [EMAIL PROTECTED] wrote: On 5/18/07, AJ Mercer [EMAIL PROTECTED] wrote: this worked for me cfhttp method=get url=http://64.119.37.62/xml; result=web cfdump var=#web# Thanks. This is so frustrating. This used to work fine, but suddenly stopped a few months ago. I've even formatted, fresh reinstalled Windows, and upgraded from 6.1 to MX 7 and the problem continues - primarily with sites that provide that XML file. Other sites tend to work fine. Your exact code will execute the dump as follows for me: Charset: [empty string] ErrorDetail: [empty string] Filecontent: Connection Timeout Header: HTTP/1.1 200 OK Content-type: text/xml Pragma: no-cache Cache-Control: no-cache Mimetype: text/xml Responseheader [ Cache-Control: no-cache Content-type: text/xml Explanation: OK Http_Version: HTTP/1.1 Pragma: no-cache Status_Code: 200 Statuscode: 200 OK ] Text: YES I guess I could use CFHTTP to write the file to disk, then use CFFILE to open it, but that is WAY more overhead than I want. I'd much rather just get CFHTTP working like it's supposed to. :-( Any other ideas? ~| 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:278596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with spaces in value of a list in a URL that is delimited with + sign
FYI, pluses are supposed to be replaced by spaces by any app server. If someone wants to include pluses in an url parameter then they should url-encode them as %2B (the hex value for 43, the ASCII code a '+'), and spaces should be encoded as %20 or +. I'll bet you are going to find other issues with that query parameter unless the other app adopts the right policy of urlencoding all parameter values. What will happen with queries that include the special characters , ?, or %? Mark -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 9:15 AM To: CF-Talk Subject: RE: problem with spaces in value of a list in a URL that is delimited with + sign You could pull it from cgi.query_striung instead. That should preserve everything just as you see it. -Original Message- From: Joy Holman [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 8:48 AM To: CF-Talk Subject: problem with spaces in value of a list in a URL that is delimited with + sign I've run out of ideas in how to fix this situation: Another application that uses the plus sign as a delimiter links to my site with a variable called search. It seems ColdFusion replaces the + sign with spaces before I can get at the variable values from a URL. It's only a problem if a value in the list already had spaces, like: search=liver+diet and nutrition+eyes When I do a cfdump on the variable search, I get: liver diet and nutrition eyes Looping through the list with the delimiter + or or , displays the same as the dump. How can I make the values separated properly by a comma, like: liver,diet and nutrition,eyes Help! and Thanks. Joy ~| 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:278594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with spaces in value of a list in a URL that is delimited with + sign
Ah hah - the CGI.query_string! Thanks much! ~| 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:278593 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 of query - clob error
Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. Yes, I did try listing the two of them last. I also removed one, just for testing, and the last field is a CLOB and it still fails. I can ask to have a setting enabled. What setting would that be? Any other thoughts? thanks so far. ~| 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:278592 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 this be done?
Is a live chat app out of the question? ~| 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:278590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can this be done?
Hi all, I am breaking my head over something, and I hope someone can tell me if, and how, this van be done. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| 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:278589 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 Tree Traversal
Thanks James! James Holmes wrote: This is a good summary of SQL useful in this situation: http://www.oreilly.com/catalog/sqlpr/chapter/ch01.pdf On 5/18/07, Rey Bango [EMAIL PROTECTED] wrote: Guys, its been awhile since I've done tree/hierarchical SQL manipulation so I need some help. The data looks something like this: parent_member_idmember_id Level 1 2 1 1 3 2 2 4 1 3 5 1 4 6 1 4 7 2 In this scenario, I would be trying to find all downline members of a specific parent id. For example: If I wanted to see all downline members for parent_member_id 1, it would be: 2,3,4,5,6,7 If I wanted to see all downline members for parent_member_id 2, it would be: 4,6,7 If I wanted to see all downline members for parent_member_id 3, it would be: 5 If I wanted to see all downline members for parent_member_id 4, it would be: 6,7 Any guidance on this would be helpful. I've tried Googling this but to no avail. ~| 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:278591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP weirdness - Connection Timeout
try running your ColdFusion servers with the same account your are logging onto the server with On 5/18/07, Jared Smith [EMAIL PROTECTED] wrote: On 5/18/07, AJ Mercer [EMAIL PROTECTED] wrote: this worked for me cfhttp method=get url=http://64.119.37.62/xml; result=web cfdump var=#web# Thanks. This is so frustrating. This used to work fine, but suddenly stopped a few months ago. I've even formatted, fresh reinstalled Windows, and upgraded from 6.1 to MX 7 and the problem continues - primarily with sites that provide that XML file. Other sites tend to work fine. Your exact code will execute the dump as follows for me: Charset: [empty string] ErrorDetail: [empty string] Filecontent: Connection Timeout Header: HTTP/1.1 200 OK Content-type: text/xml Pragma: no-cache Cache-Control: no-cache Mimetype: text/xml Responseheader [ Cache-Control: no-cache Content-type: text/xml Explanation: OK Http_Version: HTTP/1.1 Pragma: no-cache Status_Code: 200 Statuscode: 200 OK ] Text: YES I guess I could use CFHTTP to write the file to disk, then use CFFILE to open it, but that is WAY more overhead than I want. I'd much rather just get CFHTTP working like it's supposed to. :-( Any other ideas? ~| 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:278595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT:Is this bad form?
Hi folks, Is it considered bad form for the author of an article to ask folks to digg that article http://digg.com/programming/ColdFusion_Loop_Break for him? Thanks, Chris -- http://www.cjordan.us ~| 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:278599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
The client want to use MSN as the client, so yes, for this solution it is... 2007/5/18, Will Tomlinson [EMAIL PROTECTED]: Is a live chat app out of the question? ~| 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:278600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does CF Framework make life easier? Which one to start?
On Friday 18 May 2007, Greg Luce wrote: XML is just another structured language probably much simpler than HTML. Yes, but if you are just getting started, it only makes the curve steeper. -- Tom Chiverton Helping to vitalistically network industry-wide infrastructures on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.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:278598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with spaces in value of a list in a URL that is delimited with + sign
Replace them. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 9:50 AM To: CF-Talk Subject: RE: problem with spaces in value of a list in a URL that is delimited with + sign FYI, pluses are supposed to be replaced by spaces by any app server. If someone wants to include pluses in an url parameter then they should url-encode them as %2B (the hex value for 43, the ASCII code a '+'), and spaces should be encoded as %20 or +. I'll bet you are going to find other issues with that query parameter unless the other app adopts the right policy of urlencoding all parameter values. What will happen with queries that include the special characters , ?, or %? Mark -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 9:15 AM To: CF-Talk Subject: RE: problem with spaces in value of a list in a URL that is delimited with + sign You could pull it from cgi.query_striung instead. That should preserve everything just as you see it. -Original Message- From: Joy Holman [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 8:48 AM To: CF-Talk Subject: problem with spaces in value of a list in a URL that is delimited with + sign I've run out of ideas in how to fix this situation: Another application that uses the plus sign as a delimiter links to my site with a variable called search. It seems ColdFusion replaces the + sign with spaces before I can get at the variable values from a URL. It's only a problem if a value in the list already had spaces, like: search=liver+diet and nutrition+eyes When I do a cfdump on the variable search, I get: liver diet and nutrition eyes Looping through the list with the delimiter + or or , displays the same as the dump. How can I make the values separated properly by a comma, like: liver,diet and nutrition,eyes Help! and Thanks. Joy ~| 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:278597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: RE: Is this bad form?
Probably, but it certainly goes on. IMHO, it's bad form for sites such as newspapers and blogs to have Digg This! links at the bottom of every story too. If one of their readers uses Digg regularly and likes the article, they will know what to do, without prompting. -Original Message- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: 18 May 2007 15:38 To: CF-Talk Subject: OT:Is this bad form? Hi folks, Is it considered bad form for the author of an article to ask folks to digg that article http://digg.com/programming/ColdFusion_Loop_Break for him? Thanks, Chris -- http://www.cjordan.us ~| 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:278601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Fwd: Purchasing ColdFusion
So after the nucluear meltdown of my life yesterday I was told that we are going to purchase CFMX 7 assuming that we will get the upgrades to 8 when the time comes around. Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. Money *is* an issue here. Thanks! Hatton ~| 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:278602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fwd: Purchasing ColdFusion
On Friday 18 May 2007, C. Hatton Humphrey wrote: Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. Is something up with Adobe's online shop ? -- Tom Chiverton Helping to heterogeneously seize corporate e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Purchasing ColdFusion
Bluedragon? -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 10:11 AM To: CF-Talk Subject: Fwd: Purchasing ColdFusion So after the nucluear meltdown of my life yesterday I was told that we are going to purchase CFMX 7 assuming that we will get the upgrades to 8 when the time comes around. Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. Money *is* an issue here. Thanks! Hatton ~| 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:278604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Fwd: Purchasing ColdFusion
I'm sure he's looking for a better price Tom... -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 11:28 AM To: CF-Talk Subject: Re: Fwd: Purchasing ColdFusion On Friday 18 May 2007, C. Hatton Humphrey wrote: Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. Is something up with Adobe's online shop ? -- Tom Chiverton Helping to heterogeneously seize corporate e-tailers on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278605 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 weirdness - Connection Timeout
On Friday 18 May 2007, Jared Smith wrote: However, I can access the file from a browser on the server, the cfhttp.errorDetail is empty, the cfhttp.statusCode is 200, the mimeType is being picked up correctly, and if I sniff the packets I see the entire file is send to CF. And if I set the path and file attributes of CFHTTP, the XML file is saved successfully to my server. So why is #cfhttp.filecontent# broken? Trying setting an explicit return variable to save into. -- Tom Chiverton Helping to globally integrate high-end technologies on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fwd: Purchasing ColdFusion
The price! ;) Tom Chiverton wrote: On Friday 18 May 2007, C. Hatton Humphrey wrote: Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. Is something up with Adobe's online shop ? ~| 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:278607 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Purchasing ColdFusion
Is something up with Adobe's online shop ? We contacted Adobe and they said we might be able to get a better deal through a reseller rather than directly from them. At least that's what I was told. Bluedragon? Not an option. If you feel like laughing at me view the message thread in CF-Community I posted yesterday: http://www.houseoffusion.com/groups/cf-community/thread.cfm/threadid:24170 ~| 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:278608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Purchasing ColdFusion
On 5/18/07, C. Hatton Humphrey [EMAIL PROTECTED] wrote: So after the nucluear meltdown of my life yesterday I was told that we are going to purchase CFMX 7 assuming that we will get the upgrades to 8 when the time comes around. Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. TIm Buntel blogged about this: http://www.buntel.com/blog/index.cfm?mode=entryentry=4E9B8319-4E22-1671-521856788AB5FA11 Buy CFMX 7 with a subscription for 25% off and you'll get the Scorpio update free when it ships. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:278609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fwd: Purchasing ColdFusion
On Friday 18 May 2007, Bobby Hartsfield wrote: I'm sure he's looking for a better price Tom... Well, there's Smith then. -- Tom Chiverton Helping to professionally supply back-end content on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fwd: Purchasing ColdFusion
On 5/18/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 18 May 2007, Bobby Hartsfield wrote: I'm sure he's looking for a better price Tom... Well, there's Smith then. which won't run any framework-based code :) Right now I can't even get settings to 'stick' in the Smith admin - and others are experiencing the same problem (not everyone I'm sure, but several people report that none of the 'save' buttons in the Smith admin seem to do anything). -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:278611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Purchasing ColdFusion
Not an option because? Cost? Capabilities? Perception? Bluedragon? Not an option. If you feel like laughing at me view the message thread in CF-Community I posted yesterday: http://www.houseoffusion.com/groups/cf-community/thread.cfm/threadid:24170 ~| 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:278612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Purchasing ColdFusion
Hi, Anyone know if (or when) the same deal is available in Europe? Thx --- TIm Buntel blogged about this: http://www.buntel.com/blog/index.cfm?mode=entryentry=4E9B8319-4E22-1671 -521856788AB5FA11 Buy CFMX 7 with a subscription for 25% off and you'll get the Scorpio update free when it ships. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood --- ~| 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:278613 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT: css question
I have a weird CSS question.
I'm using Aptana CSS editor,...
I have an alphabet list (literally ABCD..etc)
There's a CSS background with the same set (trying to achieve a certain
font)
I need to create a highlight when the user select's a letter,
Can I put a semi-transparent block over the background with a span?
--- css code-
#bwAlphabet{
float: left;
margin: 0 0 10px 0;
padding: 0;
}
#bwAlphabet ol{
list-style: none;
padding: 0 0 0 15px;
margin: 0 0 0 0; /*1em 0.5em;*/
float: left;
font-size:11px;
width: 574px;
height: 31px;
font-family: Arial, Helvetica, sans-serif;
background: url(../images/bw-alpha.gif) no-repeat top left;
}
#bwAlphabet ol li{
float: left;
text-indent: -9px;
margin: 0;
padding: 0;
}
#bwAlphabet ol li a{
display:block;
text-align:center;
font-weight:bold;
/*color: #03C;*/
text-decoration:none;
outline: green dotted 1px;
margin: 0;
padding: 0;
height: 31px;
}
-cf code ---
cfset lstAlphabet = A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z
div id=bwAlphabet
ol
cfloop list=#lstAlphabet# index=thisAlpha
lispana
href=#myself##xfa.browseHome#dbTab=#attributes.dbTab#startsWith=#thisAlph
a# id=bw#thisAlpha##thisAlpha#/a/span/li
/cfloop
/ol
/div
--
Scott Stewart
ColdFusion Developer
SSTWebworks
7241 Jillspring Ct.
Springfield, Va. 22152
(703) 220-2835
http://www.sstwebworks.com
~|
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:278614
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 this be done?
What about using the same application name for the whole app so when you receive the message back save it to the application scope and the users response page can check the application scope for the response. maybe an array treated as a queue or something -Randy Erik-Jan Jaquet wrote: Hi all, I am breaking my head over something, and I hope someone can tell me if, and how, this van be done. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| 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:278615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
A database solution would not be bad either because you could delete conversations that have not had any messages added within a certain time frame -Randy Erik-Jan Jaquet wrote: Hi all, I am breaking my head over something, and I hope someone can tell me if, and how, this van be done. A client wants some sort of 'Live helper' functionality on the website, where a web visitor fills in a form with a questions, that question is then delivered to an MSN account within the company. The company responds via MSN, and the response must then be shown to the user. I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? Hope you can help! Kind regards, Erik-Jan ~| 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:278616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? You can, in theory, put the response into an application or server variable in the handler from the event gateway and have JS poll a CF page that looks for a response. Heres a sample implementation. User enters in question in form on webpage. Javascript submits question via XMLHTTP post to CF page. CF Page posts question to MSN user and prefixes a UUID (or the users CFID/CFToken/JSessionID/any unique ID) to the question. For example: WebsiteMSN_User: [987124] - Do you guys sell widgets? And returns that unique as the response of the XMLHTTP request. Javascript holds that number in memory and polls a different page (getResponse.cfm?msgID=987124) every 5-10 seconds (or uses a hanging get, whatever you prefer) passing that number as a parameter to the page. MSN user responds, prefixing the same code to his response MSNUser: [987124] - we do sell widgets, click on Cogs/Widgets on the top menu bar and you will see it You would add an application variable in your msn event gateway incoming message handler that would create a variable cfset application.msnDialogue.987124 = we do sell widgets, click on Cogs/Widgets on the top menu bar and you will see it Finally, the getResponse.cfm page would look for that variable and if it found it, return it and structDelete it so you dont have too many variables sitting in memory. Its not elegant, but it will work without a DB. ~| 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:278620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Log file getting big fast
Hi, I just released a new application and its log file has millions of lines like this within a day. Do you know where it comes from and how I can stop it from logging? 18605 [jrpp-0] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection 18605 [jrpp-1] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection Thank you. Johnny ~| 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:278619 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular Expression to count links
True about the runaway loop--- it was late ;-) Here's the corrected code: cffunction name=GetLinkCount cfargument name=s type=string cfset var count = 0 cfset var foundPos = 1 cfset var nextPos = 1 cfloop condition=foundPos cfset foundPos = REFindNoCase(a\s+[^]*?href[^]+.*?/a, s, nextPos) cfif foundPos cfset nextPos = foundPos + 1 cfset count = count + 1 /cfif /cfloop cfreturn count /cffunction Regarding efficiency, I think you must have compared my code to your version that simply uses FindNoCase instead of REFindNoCase. Comparing the two versions with RegExps, my code is nearly 4 times faster. This would have to be the case because searching, copying, and replacing in strings are not simple operations, and it's best to minimize them, as above. Also, RegExps are much less efficient than a plain old Find, but correspondingly more powerful, so it's more efficient to use Find instead of REFind if you don't mind counting named anchors as links. On 5/18/07, Bobby Hartsfield [EMAIL PROTECTED] wrote: That's also a runaway loop when there are no links found ;-) -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, May 17, 2007 11:53 PM To: CF-Talk Subject: RE: Regular Expression to count links Actually... the while loop I posted is considerably faster. About 16ms faster. Maybe it's the loop or the cfscript... I dunno. ~| 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:278618 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 weirdness - Connection Timeout
Hi Jared, Have you tried setting the timeout to a higher number? -Randy Jared Smith wrote: I'm trying to use CFHTTP to capture a simple XML file from a remote server - cfhttp url=http://64.119.37.62/xml; method=GET timeout=10 When I try to access the #cfhttp.filecontent# is shows only Connection Timeout. However, I can access the file from a browser on the server, the cfhttp.errorDetail is empty, the cfhttp.statusCode is 200, the mimeType is being picked up correctly, and if I sniff the packets I see the entire file is send to CF. And if I set the path and file attributes of CFHTTP, the XML file is saved successfully to my server. So why is #cfhttp.filecontent# broken? It only does this for some sites. With most of them, everything works fine, but with this site and others like it, CF is choking on the content somewhere. I have tried setting the character set, setting user-agent, setting the Accept-Encoding and TE headers to deflate;q=0 to solve any compression issues, and about everything else I can think of. Can anyone else try to CFHTTP that file (http://64.119.37.62/xml) and see if it works? This is a FRESH install of MX 7. Frustrated! Jared ~| 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:278617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Purchasing ColdFusion
That's for Enterprise only, don't forget. :o( Chris Sean Corfield wrote: On 5/18/07, C. Hatton Humphrey [EMAIL PROTECTED] wrote: So after the nucluear meltdown of my life yesterday I was told that we are going to purchase CFMX 7 assuming that we will get the upgrades to 8 when the time comes around. Question is this - where would you recommend purchasing from? After speaking with Adobe we're looking for resellers or distributors. TIm Buntel blogged about this: http://www.buntel.com/blog/index.cfm?mode=entryentry=4E9B8319-4E22-1671-521856788AB5FA11 Buy CFMX 7 with a subscription for 25% off and you'll get the Scorpio update free when it ships. -- http://www.cjordan.us ~| 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:278621 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does CF Framework make life easier? Which one to start?
On 5/18/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: I have no OO background. Till now I just used coldfusion tags to make my projects. It was easy and with a little help from Dreamweaver it was the easiest programming experience I ever had. Then Fusebox is probably the best match for you and, I suspect, you'd find Fusebox 3, easier than Fusebox 4+. Get a copy of the Fusebox 3 book by Nat Papovich and Jeff Peters and see if it makes sense to you. http://www.amazon.com/Fusebox-Developing-Applications-Jeff-Peters/dp/0735712697 -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:278624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Errant Web-inf directories
From Brandon Purcell's blog http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1031 On 18/05/07, David Stockton [EMAIL PROTECTED] wrote: Any chance you could qualify your claims that re-compiling is faster than reading from the cached .class (even if there are 20k files in the folder). Even with a small cfm/function i'd be VERY suprised if this is the case. Perhaps you could enlighten me? D What's in those other WEB-INF directories? I suspect they don't contain the entire contents of the original WEB-INF directory. Well, in one example, there are 19,195 .class files. Not as many as are in the root web-inf, no. But, a sizable amount. Is that all that's in there, compiled classes? Is that all that's in your original one? And, that's a lot of class files. You should probably disable the option to save class files in CF Administrator. In your environment, it's likely to take longer to find one file out of twenty thousand in a single directory, than to just recompile the source. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278622 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 weirdness - Connection Timeout
Thanks for your responses. No joy yet. AJ Mercer wrote: try running your ColdFusion servers with the same account your are logging onto the server with Tried this with an administrator account and the problem remains. Tom Chiverton wrote: Trying setting an explicit return variable to save into. I'm assuming you mean cfhttp result=myvar. I've done that and then cfdumped the myvar variable. Everything looks fine (200 status code, correct mime type, full headers) except Filecontent still shows Connection Timeout. Randy Johnson wrote: Have you tried setting the timeout to a higher number? Yes. I've tried VERY high numbers and no timeout at all. I should note, that the full timeout period is used before I get anything on screen. However, when I cfhttp to a file, everything runs and the the file shows up almost instantly every time. There's something breaking between when CF gets the remote data and when it creates the Filecontent data. Jared ~| 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:278630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Log file getting big fast
Could you elaborate on the name and location of this log file? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 12:46 PM To: CF-Talk Subject: RE: Log file getting big fast I just released a new application and its log file has millions of lines like this within a day. Do you know where it comes from and how I can stop it from logging? 18605 [jrpp-0] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection 18605 [jrpp-1] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection Are you using SeeFusion? It has a JDBC wrapper option that will allow you to view SQL information at runtime. I haven't checked myself, but something like that might produce these log entries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Errant Web-inf directories
This is most interesting. I would like to run a test of some sort, but I'm not sure how I would measure it. 10,000 files is a lot for a file system, but would be small beans in a database table. I wonder if there is any kind of indexing CF could do to reduce the table scan affect of looking for the right file. I've never analyzed class file before, but I would assume the name of each file is unique given the path and filename of the unparsed CFML file it represents. You would think a request for a specific file name would only take a couple milliseconds for the OS to examine the file allocation tables and determine its existence. It would be like selecting a record from a huge table based on the primary key. But then again, I can't really claim to understand how this all works, this is just the way that would seem to make sense to me. ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 12:38 PM To: CF-Talk Subject: RE: Errant Web-inf directories Any chance you could qualify your claims that re-compiling is faster than reading from the cached .class (even if there are 20k files in the folder). Even with a small cfm/function i'd be VERY suprised if this is the case. Perhaps you could enlighten me? Other than telling you to try it for yourself and see, I can only say that this has been my experience. Obviously, the speed of the disk and other hardware, the specific filesystem being used, etc, will all affect this. In my experience, any CF server with over 10k of compiled classes is almost certainly going to be faster if you disable that option. I've seen some with many, many more files than that where the difference was obviously noticeable without any formal testing. ~| 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:278627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Log file getting big fast
I just released a new application and its log file has millions of lines like this within a day. Do you know where it comes from and how I can stop it from logging? 18605 [jrpp-0] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection 18605 [jrpp-1] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection Are you using SeeFusion? It has a JDBC wrapper option that will allow you to view SQL information at runtime. I haven't checked myself, but something like that might produce these log entries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error setting up FCKEditor
Thanks for your help Mike, I got it working but obviously I have something wrong with my path values because the only way I got it to work was to have a FCKEditor Dir in the webroot and in the /raindance directory? Thanks again. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Thursday, May 17, 2007 4:27 PM To: CF-Talk Subject: Re: Error setting up FCKEditor Yes, Paul I know exactly what is causing that error.The page not found' is referring to the blank page that FCKEditor puts in the editing area. you need to make sure the reference to that page is correct. On my instances of FCKEditor, that line is the following: fckEditor.basePath = /cfforms/scripts/fckeditor/; or in some of my sites, i have the following: fckEditor.basePath = #application.fckeditorbasepath#; The problem you have is similar to the previous problem - you just need to tinker around with the values in that line to make sure it's pointing to the folder that contains the fckeditor.cfc. (Im assuming you have kept all the files in teh same folder layout as the default installation. I wouldnt recommend you move anything about unless yoo konw what all those files do and where the path references to them are). Here's a complete FCKEditor instance from one of my sites, that you can follow: cfscript fckeditor = createObject(component, cfforms.scripts.fckeditor.fckeditor); fckEditor.instanceName = story; //the field name in the form scope fckEditor.value = '#Content.getStory()#'; //the default value in the editing window fckEditor.basePath = /cfforms/scripts/fckeditor/; //fckEditor.toolbarset = default; fckEditor.width = 80%; fckEditor.height= 400; fckEditor.create(); // create the editor. /cfscript Hope this gets you going - if not, feel free to ask more questions. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 5/18/07, Paul Henderson [EMAIL PROTECTED] wrote: Thanks Mike, I seemed to make some progress setting the basepath to /fckeditor/ and manually setting the fckeditor ro fckeditor = createObject(component, fckeditor.fckeditor); But now, I get a page cannot be displayed error in the section the editor should load into. I'm not sure what I could be doing wrong, the documentation sure makes the process seem simple enough. Any other thoughts? Thanks again. ~| 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:278623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Errant Web-inf directories
Any chance you could qualify your claims that re-compiling is faster than reading from the cached .class (even if there are 20k files in the folder). Even with a small cfm/function i'd be VERY suprised if this is the case. Perhaps you could enlighten me? Other than telling you to try it for yourself and see, I can only say that this has been my experience. Obviously, the speed of the disk and other hardware, the specific filesystem being used, etc, will all affect this. In my experience, any CF server with over 10k of compiled classes is almost certainly going to be faster if you disable that option. I've seen some with many, many more files than that where the difference was obviously noticeable without any formal testing. The problem is that all the files are in a single directory, I think. If they were separated using a hierarchy of directories, seek time would be much faster (but presumably write time would be slower, since CF would have to figure out which directory to put them in, create the directory in its absence, etc. I'm not the only one who's observed this, apparently: http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1031 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Errant Web-inf directories
10,000 files is a lot for a file system ... Not really. Ten thousand files in the same directory, however, is. And that's the problem, I think. Filesystems use directory information to find files quickly. Conceivably, CF could be changed to store class files in some sort of directory structure - instead of them all being in cfclasses, they could be in cfclasses\[something]. The problem then, though, would be that CF wouldn't have any way to find them without recursing through directories, unless the directory structure could be inferred from the request itself (perhaps mirroring the directory structure of the source code). Also, there would be a cost involved in creating these directories, presumably. Honestly, I don't know if that's a viable solution, but I do think it would solve the specific problem of how long it takes to retrieve compiled classes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Log file getting big fast
It is the Jrun4/logs/appName-out.log Is it possible to stop it from recording all together? Since it doesn't seem to produce any useful information. Johnny Could you elaborate on the name and location of this log file? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 12:46 PM To: CF-Talk Subject: RE: Log file getting big fast Are you using SeeFusion? It has a JDBC wrapper option that will allow you to view SQL information at runtime. I haven't checked myself, but something like that might produce these log entries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: css question
Is a background color not good enough?
#bwAlphabet a:hover{
background: #000;
}
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Friday, May 18, 2007 12:03 PM
To: CF-Talk
Subject: SOT: css question
I have a weird CSS question.
I'm using Aptana CSS editor,...
I have an alphabet list (literally ABCD..etc)
There's a CSS background with the same set (trying to achieve a certain
font)
I need to create a highlight when the user select's a letter,
Can I put a semi-transparent block over the background with a span?
--- css code-
#bwAlphabet{
float: left;
margin: 0 0 10px 0;
padding: 0;
}
#bwAlphabet ol{
list-style: none;
padding: 0 0 0 15px;
margin: 0 0 0 0; /*1em 0.5em;*/
float: left;
font-size:11px;
width: 574px;
height: 31px;
font-family: Arial, Helvetica, sans-serif;
background: url(../images/bw-alpha.gif) no-repeat top left;
}
#bwAlphabet ol li{
float: left;
text-indent: -9px;
margin: 0;
padding: 0;
}
#bwAlphabet ol li a{
display:block;
text-align:center;
font-weight:bold;
/*color: #03C;*/
text-decoration:none;
outline: green dotted 1px;
margin: 0;
padding: 0;
height: 31px;
}
-cf code ---
cfset lstAlphabet = A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z
div id=bwAlphabet
ol
cfloop list=#lstAlphabet# index=thisAlpha
lispana
href=#myself##xfa.browseHome#dbTab=#attributes.dbTab#startsWith=#thisAlph
a# id=bw#thisAlpha##thisAlpha#/a/span/li
/cfloop
/ol
/div
--
Scott Stewart
ColdFusion Developer
SSTWebworks
7241 Jillspring Ct.
Springfield, Va. 22152
(703) 220-2835
http://www.sstwebworks.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:278636
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 this be done?
More specifically, look at the meebo me embeddable widget: http://www.meebome.com/ On 5/18/07, chopper [EMAIL PROTECTED] wrote: Have you looked at meebo.com It allows you to embed a chat client in your webpage that connects to an MSN account. ~| 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:278635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can this be done?
Have you looked at meebo.com It allows you to embed a chat client in your webpage that connects to an MSN account. On 5/18/07, James Wolfe [EMAIL PROTECTED] wrote: I have set up an MSN Gateway, I can send messages to the MSN account and receive messages from that MSN account. But I am not able to figure out how to show the user the response, other then letting the gateway add it to the DB, and let the app pull it from the DB. But I don't want to do that, because it is a lot of data to put in the DB. Is there any other way? ~| 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:278634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Errant Web-inf directories
On 5/18/07, Dave Watts wrote: 10,000 files is a lot for a file system ... Not really. Ten thousand files in the same directory, however, is. And that's the problem, I think. Filesystems use directory information to find files quickly. Well, since our main web-inf directory has 114,254 files, I think we're probably a prime candidate for turning it off, eh? (Don't shoot me, I'm not the server admin.) (And, yes, I've been advocating for multiple CF instances. But so far, no go.) -d ~| 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:278632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Log file getting big fast
No, I am not using SeeFusion. The only difference on this application is that I unchecked all the checkboxes in the debugging settings in CF Admin and checked the enable logging for schedule tasks in logging settings. Could the enable logging for schedule tasks cause this? Johnny I just released a new application and its log file has millions of lines like this within a day. Do you know where it comes from and how I can stop it from logging? 18605 [jrpp-0] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection 18605 [jrpp-1] DEBUG coldfusion.server - macromedia.jdbc.sqlserver.SQLServerConnection Are you using SeeFusion? It has a JDBC wrapper option that will allow you to view SQL information at runtime. I haven't checked myself, but something like that might produce these log entries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278631 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Log file getting big fast
No, I am not using SeeFusion. The only difference on this application is that I unchecked all the checkboxes in the debugging settings in CF Admin and checked the enable logging for schedule tasks in logging settings. Could the enable logging for schedule tasks cause this? I wouldn't think so, but you could find out by changing it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Regular Expression to count links
That may be what I did, can't remember. But... that method worked and was 16 times faster ;-) -Original Message- From: chopper [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 12:12 PM To: CF-Talk Subject: Re: Regular Expression to count links True about the runaway loop--- it was late ;-) Here's the corrected code: cffunction name=GetLinkCount cfargument name=s type=string cfset var count = 0 cfset var foundPos = 1 cfset var nextPos = 1 cfloop condition=foundPos cfset foundPos = REFindNoCase(a\s+[^]*?href[^]+.*?/a, s, nextPos) cfif foundPos cfset nextPos = foundPos + 1 cfset count = count + 1 /cfif /cfloop cfreturn count /cffunction Regarding efficiency, I think you must have compared my code to your version that simply uses FindNoCase instead of REFindNoCase. Comparing the two versions with RegExps, my code is nearly 4 times faster. This would have to be the case because searching, copying, and replacing in strings are not simple operations, and it's best to minimize them, as above. Also, RegExps are much less efficient than a plain old Find, but correspondingly more powerful, so it's more efficient to use Find instead of REFind if you don't mind counting named anchors as links. On 5/18/07, Bobby Hartsfield [EMAIL PROTECTED] wrote: That's also a runaway loop when there are no links found ;-) -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, May 17, 2007 11:53 PM To: CF-Talk Subject: RE: Regular Expression to count links Actually... the while loop I posted is considerably faster. About 16ms faster. Maybe it's the loop or the cfscript... I dunno. ~| 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:278637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF and Zebra 2844 Label Printers
I have a client who has an app that needs to print to one of these little printers. They're most commonly used for printing the big 4x6 UPS labels, but in this case, they're using a 1x3 label. I'm able to print to it thanks to the drivers (on Windows only, of course), but the problem I'm running into is being able to control page breaks and stuff. I wanted to use CFDocument, but it won't let me make a document small enough -- it wants a minimum height of 2 inches. So now I'm working on the CF Report Builder. It let me create a 1x3 template, but it complains when I try to use it, saying the data doesn't fit on the label. I'm a newbie to this report builder app so I'm unsure if there's a way to shrink things down to fit. If anybody wants to see the cfr file, you can get it here: http://www.atvowners.com/rob/label.cfr Anybody know of a way to do this? Thanks! Rob ~| 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:278638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does CF Framework make life easier? Which one to start?
I am trying to get a sponsor from a hosting company. Once I do, I will do a series of video tutorials on frameworks. In the meantime, go to carehart.org and look up OOP and some of the framework names in the UGTV list. You will find some great video workshops there. -Aaron On 5/18/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: I have no OO background. Till now I just used coldfusion tags to make my projects. It was easy and with a little help from Dreamweaver it was the easiest programming experience I ever had. recently after making 10 online catalogs for a friend I realized there might be a problem to manage all the code for all catalogs. After a little googling I saw the expression FrameWork. I had no idea what it is. Honestly right now I don't know what exactly a framework is and how it works and how I can start working with that. Your posts helped a lot but I think what I really need is an example based basic tutorial that helps me understand the meanining of a framework. Thanks Ali ~| 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:278639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does CF Framework make life easier? Which one to start?
I should also add that around this time last year I didn't know a thing about OOP and I just started using frameworks in the last few months (just prior to the Frameworks conference). In fact, framework author Peter Bell has only been working with OOP for a little over a year now (see http://www.pbell.com/index.cfm/2007/1/1/2006--Quite-a-year). You will benefit more by learning OOP now then waiting until you've built more and more catalogs and you find that all your time is being wasted maintaining them and you never get to build your client el. -Aaron On 5/18/07, Aaron Roberson [EMAIL PROTECTED] wrote: I am trying to get a sponsor from a hosting company. Once I do, I will do a series of video tutorials on frameworks. In the meantime, go to carehart.org and look up OOP and some of the framework names in the UGTV list. You will find some great video workshops there. -Aaron On 5/18/07, Ali Majdzadeh [EMAIL PROTECTED] wrote: I have no OO background. Till now I just used coldfusion tags to make my projects. It was easy and with a little help from Dreamweaver it was the easiest programming experience I ever had. recently after making 10 online catalogs for a friend I realized there might be a problem to manage all the code for all catalogs. After a little googling I saw the expression FrameWork. I had no idea what it is. Honestly right now I don't know what exactly a framework is and how it works and how I can start working with that. Your posts helped a lot but I think what I really need is an example based basic tutorial that helps me understand the meanining of a framework. Thanks Ali ~| 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:278641 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 can I do this
On 5/18/07, Matthew Friedman [EMAIL PROTECTED] wrote: I am not sure how I can do this. What I need to do is to set up a site that when the user hits a url to a specific domain ie: www.domain.com/codeword I can parse the codeword off the url string and preforms some actions. The only thing is that the server will not have the directory www.domain.com/codeword, I only want it to run with a single directory of www.domain.com and I can reused the tool multiple times. I am running this on an IIS server. You could use the 404 custom error template to pull the codeword from the CGI.PATH_INFO and then include content accordingly. The error template is a site-wide thing though. I imagine you could probably also use ISAPI_Rewrite to rewrite the URLs to something useful. Jared Smith ~| 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:278643 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 of query - clob error
These settings are found under the advanced setting tab when you register your datasource. Not sure what the default setting is for your buffer, 64k maybe? It's been suggested to me to double that, at any rate mine is set to 128. Hope this helps. CLOB -- Enable long text retrieval (CLOB). BLOB -- Enable binary large object retrieval (BLOB). Long Text Buffer (chr) Blob Buffer(bytes) Bob -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 9:34 AM To: CF-Talk Subject: Re: query of query - clob error Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue. Yes, I did try listing the two of them last. I also removed one, just for testing, and the last field is a CLOB and it still fails. I can ask to have a setting enabled. What setting would that be? Any other thoughts? thanks so far. ~| 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:278646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF and XML help on last part - extracting child element
Ok I'm grabbing data from YouTube and got down to extracting an element below/inside the root element. Just can't figure out how to grab the view_count child element in the following XML example. See CF code after xml sample code. Any direction would be great Thank you all so very much! XML SAMPLE: ?xml version=1.0 encoding=utf-8 ? ut_response status=ok video_details authorShiftShoutOut/author titleShift shout out 18/title rating_avg4.78/rating_avg rating_count9/rating_count tagsShift shout out/tags descriptionShift shout out/description update_time1179219506/update_time view_count1293/view_count comment_count7/comment_count upload_time1175256758/upload_time length_seconds188/length_seconds recording_date / recording_location / recording_country / comment_list comment authorsoccer940/author textThis is an incredible song!/text time1175571559/time /comment comment authorwhosscruffylookin/author texti'm buying breath mints/text time1175574660/time /comment comment author34dd1227/author textamazing song... i do believe this planet is saved if we follow his plan./text time1175612508/time /comment comment authorfelicitous12/author texthaha i loved it!/text time1175616510/time /comment comment authordubulOkotus/author textExcellent. Excellent to say the least -- but next time, I want to see Julie humping back./text time1175622481/time /comment comment authorcshrewman/author textTK rocks me socks off!/text time1175650533/time /comment comment authorwillte86/author textAwesome, I love it/text time1177548178/time /comment /comment_list channel_list channelFilm Animation/channel /channel_list thumbnail_urlhttp://img.youtube.com/vi/1fRzsbUfyTk/2.jpg/thumbnail_url embed_statusok/embed_status /video_details /ut_response CF CODE: ( all inside a cfoutput queryname=rstCurVideo ) rstCurVideo.YouTube_vidID# is equal to the YouTube video ID that needs to be dynamically passed !--- IMPORT XML CODE FROM YOUTUBE --- !--- 1. Fetch XML content via HTTP, as if you were a browser --- CFHTTP METHOD=GET URL=http://www.youtube.com/api2_rest?method=youtube.videos.get_detailsdev_id=PWYt6CtKPOAvideo_id=#rstCurVideo.YouTube_vidID# !--- 2. Set XML content to string variable called MyXmlCode --- CFSET MyXmlCode = CFHTTP.FileContent !--- 3. Parse the XML into an XML Object --- !--- (very similar to a CFML Structure) --- CFSET MyXml = XmlParse(MyXmlCode) ~| 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:278645 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does CF Framework make life easier? Which one to start?
10 minutes? You take a sample app and copy/paste fuses around. That doesn't sound like much of an effort in improving your software quality. Greg On 5/18/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 18 May 2007, Greg Luce wrote: XML is just another structured language probably much simpler than HTML. Yes, but if you are just getting started, it only makes the curve steeper. -- Tom Chiverton Helping to vitalistically network industry-wide infrastructures on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:278644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How can I do this
I am not sure how I can do this. What I need to do is to set up a site that when the user hits a url to a specific domain ie: www.domain.com/codeword I can parse the codeword off the url string and preforms some actions. The only thing is that the server will not have the directory www.domain.com/codeword, I only want it to run with a single directory of www.domain.com and I can reused the tool multiple times. I am running this on an IIS server. Any help would be great. Matt ~| 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:278642 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 and XML help on last part - extracting child element
If you are under CFMX, you can use the XmlParse() function. If not, your best choice will be CF_REextract, see: http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:278649 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, exporting PDF files and Flash content
Andy, Maybe I'm misunderstanding, but it sounds like you are trying to serve the PDF from within your Flash File? I'm not as up to speed on Flex as I should be so I'm not sure how to integrate cfdocument there, but it would seem to me that you would need to use your cfdocument tag on a .cfm or a remote CFC function and then have your flash file perform an http request to get or post to the object. Alternately, you may be able to use flash remoting to perform a remote method call on the CFC that generates the report. Another option, if you want the report to be native in the Flash object is to use FlashPaper as your output type. I'm getting a server error on the URL you provide so I haven't been able to see your output to the browser. HTH, Jon On May 18, 2007, at 12:43 AM, Andy Matthews wrote: Anyone else? Am I pretty much resigned to recreating this as HTML? I have a customer who asked me to build a fairly simple reporting app using Flash. They save information to the db, then run the reports, and the data gets pulled into Flash and displayed. Now the customer is wondering if these reports can be exported as PDF. Luckily the host is running CF7. So I'm trying to save this as a PDF but it's not working. Does anyone have an idea as to what might be happening? I'm using the FlashObject code and at first I got a message saying that FO wasn't deined. Then, I changed it to use the basic object/embed code and got a jumble of PDF code. Now I get a blank screen with either method. Here's the page: http://2802designers.com/reporting/reportPDF. cfm?region=1period=2007-4-1 Anyone have ideas? ~| 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:278650 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF and XML help on last part - extracting child element
Ok I'm grabbing data from YouTube and got down to extracting an element below/inside the root element. Just can't figure out how to grab the view_count child element in the following XML example. See CF code after xml sample code. Any direction would be great Do you mean you're trying to get the value of view_count? Not sure exactly what you mean by grab element. If you have it as an xml object MyXML, you can use struct syntax: #MyXML.ut_response.video_details.view_count# Should output 1293. -- Josh ~| 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:278651 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 of query - clob error
I can retrieve CLOBs fine. I just can't Query of Query them, and then only if I specify them directly instead of a *. Do you think this'll help then? It appears to just enable CLOBs at all. These settings are found under the advanced setting tab when you register your datasource. Not sure what the default setting is for your buffer, 64k maybe? It's been suggested to me to double that, at any rate mine is set to 128. Hope this helps. CLOB-- Enable long text retrieval (CLOB). BLOB -- Enable binary large object retrieval (BLOB). Long Text Buffer (chr) Blob Buffer(bytes) Bob ~| 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:278648 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 can I do this
On 5/18/07, Matthew Friedman [EMAIL PROTECTED] wrote: I am not sure how I can do this. What I need to do is to set up a site that when the user hits a url to a specific domain ie: www.domain. com/codeword I can parse the codeword off the url string and preforms some actions. The only thing is that the server will not have the directory www. domain.com/codeword, I only want it to run with a single directory of www.domain.com and I can reused the tool multiple times. I am running this on an IIS server. We do this all the time for SEO. What you do is make a file, called items.cfm (or if not items, whatever will be displayed using this codeword) and you link to it like www.domain.com/items.cfm/codeword items.cfm is the page that will be called and you can simply get the codeword out of the cgi vars. No special 404 handler is needed. I think this may only work if you have CF installed in single server mode, but dont hold me to that. ~| 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:278647 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Fusebox 5 install problem - help, please
Sorry if this is off-topic. I wanted to install and try Fusebox 5. On my development system I've got a virtual directory configured named cf2 using IE6 running CFMX. I downloaded the FB 5.1 core files, extracted them from the archive and copied the fusebox5 directory to the root of the cf2 directory. Then I downloaded the FB5 skeleton app files, extracted them from the archive and copied the skeleton directory also to the root of the cf2 directory as per the readme.txt files (I think). I have both index.html and index.cfm files in the root of the cf2 directory and I can open both successfully in a browser at http://cf2/index.html and http://cf2/index.cfm. If I try to open http://cf2/skeleton/ I get an error: missing fusebox.xml The file fusebox.xml could not be found in the directory /ralj/cf2/skeleton/. Any idea what I'm doing wrong or how to get this working? Thanks in advance for any ideas. Stephen ~| 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:278652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Fusebox 5 install problem - help, please
Make sure your Fusebox_application_path in index.cfm points to the skeleton path. cfset FUSEBOX_APPLICATION_PATH = skeleton/ If I am reading your email message correctly. Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 5:07 PM To: CF-Talk Subject: OT: Fusebox 5 install problem - help, please Sorry if this is off-topic. I wanted to install and try Fusebox 5. On my development system I've got a virtual directory configured named cf2 using IE6 running CFMX. I downloaded the FB 5.1 core files, extracted them from the archive and copied the fusebox5 directory to the root of the cf2 directory. Then I downloaded the FB5 skeleton app files, extracted them from the archive and copied the skeleton directory also to the root of the cf2 directory as per the readme.txt files (I think). I have both index.html and index.cfm files in the root of the cf2 directory and I can open both successfully in a browser at http://cf2/index.html and http://cf2/index.cfm. If I try to open http://cf2/skeleton/ I get an error: missing fusebox.xml The file fusebox.xml could not be found in the directory /ralj/cf2/skeleton/. Any idea what I'm doing wrong or how to get this working? Thanks in advance for any ideas. Stephen ~| 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:278653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
get a list of database servers on network
Here's a good Friday question. In my internal web app, is it possible to populate a dropdown with a list of computers on the network running a SQL Server. Basically, like in SQL enterprise Manager, when you would go to register a new database with the wizard it would search somehow and give you a list of servers to choose from. How did that work? Would it just scan the subnet for hosts with port 1433 open? Is that possible with ColdFusion? Note: I am not talking about ColdFusion data sources at all here. ~Brad ~| 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:278654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fwd: Purchasing ColdFusion
What about Railo? Would this be an option? Greetings / Grüsse Gert Franz Customer Care Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List / Treten Sie unserer Mailingliste bei: deutsch: http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ Sean Corfield schrieb: On 5/18/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 18 May 2007, Bobby Hartsfield wrote: I'm sure he's looking for a better price Tom... Well, there's Smith then. which won't run any framework-based code :) Right now I can't even get settings to 'stick' in the Smith admin - and others are experiencing the same problem (not everyone I'm sure, but several people report that none of the 'save' buttons in the Smith admin seem to do anything). ~| 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:278655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: get a list of database servers on network
In CF natively? Not any way that I'm aware of, but there are a variety of other apps to use (or code) that can scan for hosts listening on a given port... On 5/18/07, Brad Wood [EMAIL PROTECTED] wrote: Here's a good Friday question. In my internal web app, is it possible to populate a dropdown with a list of computers on the network running a SQL Server. Basically, like in SQL enterprise Manager, when you would go to register a new database with the wizard it would search somehow and give you a list of servers to choose from. How did that work? Would it just scan the subnet for hosts with port 1433 open? Is that possible with ColdFusion? Note: I am not talking about ColdFusion data sources at all here. ~Brad ~| 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:278656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: get a list of database servers on network
In my internal web app, is it possible to populate a dropdown with a list of computers on the network running a SQL Server. Basically, like in SQL enterprise Manager, when you would go to register a new database with the wizard it would search somehow and give you a list of servers to choose from. How did that work? Would it just scan the subnet for hosts with port 1433 open? My understanding is that this is a bit more complicated. SQL Server has a discovery port, UDP/1434, and I think that's what is used to discover instances using TCP/IP (as opposed to Windows Networking). SQL Enterprise Manager, however, may also use DBNETLIB to discover servers listening on named pipes, which your application will not be able to do. Finally, TCP/1433 is the default port for a single default instance, but you can configure your SQL Server to listen on another port - and will have to if you're running multiple named instances: each of those requires its own port. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:278657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: get a list of database servers on network
Yeah, I was just messing around with nmap, which I use for port scanning from DOS. nmap 10.10.0.1-255 -p1433 -R -oX C:\port_scan.txt would output an XML file I could then parse with CF, but reliability would probably be suspect. ~Brad -Original Message- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 4:54 PM To: CF-Talk Subject: Re: get a list of database servers on network In CF natively? Not any way that I'm aware of, but there are a variety of other apps to use (or code) that can scan for hosts listening on a given port... On 5/18/07, Brad Wood [EMAIL PROTECTED] wrote: Here's a good Friday question. In my internal web app, is it possible to populate a dropdown with a list of computers on the network running a SQL Server. Basically, like in SQL enterprise Manager, when you would go to register a new database with the wizard it would search somehow and give you a list of servers to choose from. How did that work? Would it just scan the subnet for hosts with port 1433 open? Is that possible with ColdFusion? Note: I am not talking about ColdFusion data sources at all here. ~Brad ~| 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:278658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: get a list of database servers on network
Thanks for the insight Dave. I was thinking, to be able to access any data off a remote server without a datasource specifically set up for it, it would have to be a linked server to the one I was using anyway. I might as well just use select * from sys.servers Hmmm-- Oh well, I just wanted to see if it was possible anyway. ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 6:01 PM To: CF-Talk Subject: RE: get a list of database servers on network In my internal web app, is it possible to populate a dropdown with a list of computers on the network running a SQL Server. Basically, like in SQL enterprise Manager, when you would go to register a new database with the wizard it would search somehow and give you a list of servers to choose from. How did that work? Would it just scan the subnet for hosts with port 1433 open? My understanding is that this is a bit more complicated. SQL Server has a discovery port, UDP/1434, and I think that's what is used to discover instances using TCP/IP (as opposed to Windows Networking). SQL Enterprise Manager, however, may also use DBNETLIB to discover servers listening on named pipes, which your application will not be able to do. Finally, TCP/1433 is the default port for a single default instance, but you can configure your SQL Server to listen on another port - and will have to if you're running multiple named instances: each of those requires its own port. ~| 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:278659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
