RE: parent - child relations
Yes true. DB are a rational, rather than hierarchical data. LDAP is a closer match, and of course the file system is another. The problem with moving it to XML/other is that you can't do joins on the data. Many DB's have extensions to help with trees. It will be interesting to see what Microsoft will do in this area, as SQL server engine is going to be used to implement the new MS File system. WB It seems though, if you are need that much nested data there is probably a better solution to the problem then this type of tree model (i.e. using master - detail tables) that a database might be more optimized for (or perhaps xml might be a solution). Rob The problems with that method is path enumeratation etc. It's easy if you have an id and just want the category under x, But what if you want the nodes from root to a deeply nested node. It turns out to be a very expensive query... Thats why the Nested Tree Model is useful (see my last mail) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JBoss CFMXJ2EE was a lot of other stuff
Hi Dick, did you try to use installer to a manual install Have a look here for details title:CFMX for J2EE: Manual Installation @ http://www.corfield.org/blog/2003_01_01_archive.html Let me know how you get on as I to try this out myself. WG [EMAIL PROTECTED] -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 22:44 To: CF-Talk Subject: JBoss CFMXJ2EE was a lot of other stuff OK I have installed JBoss 3.0.4 I moved the 2 CFMXJ222 war files to the default server deploy directory CFIDE.war (renamed from rds.war) cfusion.war They seemed to deploy according to the terminal logs. I then try to access anything at http://localhost:8083/ No matter what I enter after the base URL, I get a blank screen returned -- not an error, but a blank screen. Help! TIA Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need book
There are lots of online resources for dos batch files E.G. http://directory.google.com/Top/Computers/Software/Operating_Systems/x86/DOS /Programming/Languages/Batch/?tc=1/ However dos batch files are very limited. There are a few other options out there. 1) install bash www.cygwin.com this is very rich scripting env. and lot of apps you can link together - also most of your scripts will work on linux... 2) use windows scripting host - http://www.microsoft.com/windows2000/techinfo/howitworks/management/winscrwp .asp 3) use perl - www.activestate.com 4) at least install the windows resource kit, it give you more options HTH WG -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 22:37 To: CF-Talk Subject: OT: Need book I have to write some batch files for dos that will end up being dynamically written later by ColdFusion. Could someone give me some titles for batch writing books to help me along with this? Thanks all Phillip B ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf and exchange
You chould have a look at CDO http://www.microsoft.com/exchange/techinfo/development/55/CDO.asp although COM is a little slow/crap in MX. One why around this is to create web services in .NET and use them from CF MX. Also J.J. blogged something about this recently... http://radio.weblogs.com/0113297/ Also if you want to use the exchange server using POP3, IMAP etc. Have a look at the Javamail mail stuff http://java.sun.com/products/javamail/index.html with you can use from CF MX. via cfobject or a java cfx.. Easy. WG Anyone ever use CF to read mail off an exchange server? I saw this tag, CFX_mIMAP has anyone used it or something else? tia, seth ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Email Quandry
Michael Greenberg wrote: Im just concerned with 11,000 emails going out at once that it might bring the server down. Yes it is via SMTP. If the emails are identical you could send them to yourself and BCC them to a bunch of people at the same time (I think the limit is 39). Usual overzealous spam filter warnings apply, especially since you want to send HTML email. Sending them all as single mails with cfmail shouldn't be a problem either, but I would recommend setting the spool interval to 15 seconds (after which they should be out of the spool in half an hour). If you have some mailserver on the system that has a pickup folder, you could also write the emails as files to that pickup folder. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JBoss CFMXJ2EE was a lot of other stuff
The JBoss install negated my Tomcat install There is a version of jboss that uses tomcat, the standard uses JBossWeb. I'll mess around with it at the Weekend and post anything interesting. WG ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Need book
At 04:37 PM 1/8/03 -0600, Phillip B wrote: I have to write some batch files for dos that will end up being dynamically written later by ColdFusion. Could someone give me some titles for batch writing books to help me along with this? What do you need to write? I don't think there are any books still extant on the subject, but I'd be happy to help offlist. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Crystal Reports 9 / Reporting Options for CF5/MX?
I have never user Crystal, but I can tell you that Actuate Reports work well with Cold Fusion and SQL, I speak from personal experience. Here is a link to their product :http://www.actuate.com/products/designers/erdpro/overview.asp -Original Message- From: Ben Koshy [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 5:52 PM To: CF-Talk Subject: Crystal Reports 9 / Reporting Options for CF5/MX? Does anyone know if CR9 is compatible with CF5 or CFMX? I'm new to Crystal Reports...basically we are looking for a good reporting solution for Cold Fusion/SQL 2000 and naturally went after the big name. I'd like to keep the budget under $500 USD unless there some must-have feature/product out there... :) Need to do the following typical reporting: Strong Graphing Capabilities and mainly used for generating Sale Advertising tracking reports. If any one has suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 4.01 Problem
Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 Golden Rule: He who has the gold, makes the rules! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ORDER BY Clause and parsing
Thanks to everyone who responded. I guess this is going to take a few minutes to do... Maybe I should write a cfc that does this??? For future posterity?? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 1/8/2003 11:47:33 PM In a perfect world, you use regular expressions, but you can probably get most of the work done using the replace() function in your dialect of SQL, or failing that, using the ColdFusion function. It's pretty ugly -- in MSSQL you could use a User-defined function or a view to make a table that doesn't look so nasty SELECT blahblah Replace(LEFT(title,3),the,) as cleanTitle -snip- ORDER BY cleanTitle handles the you could nest them to do something like c or if you can support something like the T-SQL CASE (using sybase or mssql) you could use CASE and the LEFT or PATINDEX index function to chop things up -- something like (off the top of my head) SELECT cleantitle= CASE title WHEN LEFT(title,3) ='the' THEN SUBSTRING(title,4,len(title)) ELSE title END or something along those lines. A UDF would be great way to implement because then you can change the underlying mechanics (say from replace to CASE to regex) without recoding SELECT cleantitle(title) as cleanedTitle ORDER BY cleanedTitle Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 6:48 PM Subject: ORDER BY Clause and parsing Good evening... I am trying to order a list of books by their Title. However, many of the books begin witht the word The or A or An. Is there an easy way to go through and say... cfset actualTitle = query.Title minus A,An, or The then the SQL... Select Title From Books Order By #ActualTitle# Would I need to go through and do a left of the string Title cfset leftVal = Left(query.Title, 3) cfif leftVal IS the cfset actualTitle = query.title - LeftVal Does this make sense??? I just dont think I'm getting it. TIA :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf and exchange
I use cfpop and cfmail with our exchange server. I haven't had any trouble with them. Luis -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 5:09 PM To: CF-Talk Subject: cf and exchange Anyone ever use CF to read mail off an exchange server? I saw this tag, CFX_mIMAP has anyone used it or something else? tia, seth This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
Look in the ODBC setting in the admin section. Click the advanced setting for the datasource and make sure the enable long text box is checked. Its somelike the above ages since I saw 4.01 !! WG -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: 09 January 2003 13:25 To: CF-Talk Subject: CF 4.01 Problem Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 Golden Rule: He who has the gold, makes the rules! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
that long text option is not an option in CF Admin 4.01 :-/ any other ideas :-) -Original Message- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:50 AM To: CF-Talk Subject: RE: CF 4.01 Problem Look in the ODBC setting in the admin section. Click the advanced setting for the datasource and make sure the enable long text box is checked. Its somelike the above ages since I saw 4.01 !! WG -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: 09 January 2003 13:25 To: CF-Talk Subject: CF 4.01 Problem Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 Golden Rule: He who has the gold, makes the rules! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
If you output the field into the page as plain text rather than into the textarea, are they all displayed? Maybe it's the textarea that is giving you the problem. Maybe try adjusting the wrap properties? And this may sound odd, but if you are retrieving the data with CFPROCPARAM, try appending an empty string to the end of the data like this: CFSTOREDPROC ... CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=v_foo CFVARNAME=MyValue /CFSTOREDPROC CFSET MyValue = MyValue I've seen a wierd 255 character bug with CFPROCPARAM (in CF5 but it could've been around for awhile) and maybe that's what you're hitting. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:25 AM To: CF-Talk Subject: CF 4.01 Problem Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 Golden Rule: He who has the gold, makes the rules! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MS SQL obdc data source timeout settings
A couple of questions regarding connection timeout settings for a MS SQL 2K obdc data source: While trying to run a backup job on the db, the job said that it was unable to go into single-user mode because of the cf connection. This was without any activity on the site, and profiler shows that the CF account was maintaining the connection. After checking the data source settings in cf administrator, I noticed that the connection timeout was set to 0 minutes for several of the data sources. So, would having the connection timeout set to 0 cause CF to maintain the connection indefinitely? What is the recommended setting for connection timeout? This is a low-to-medium traffic intranet site. Also, this is for a CF5 server. Are the recommended settings different for CF MX? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Email Quandry
I have a scheduled task that sends out 30,000+ each day. I have a field in the database Sent I SELECT the TOP 1000 WHERE Sent = 0 Then loop through them and update each to Sent = 1 Then when the RecordCount LS 1000 I update the whole table setting the Sent back to 0. Rick -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 11:47 PM To: CF-Talk Subject: Re: Email Quandry I know you mentioned that this is a freebie on your part. If this is a temporary thing then you can get a 60-day demo of iMS-SE from our web site. iMS-SE is a high-performance mail sending engine for ColdFusion that allows you to send volumes of mail without requiring an external email server. It's also about 1/4 of the price of other CFMAIL replacements and is the only one that does not require the external mail server. You can see a feature comparison of iMS-SE versus other products at the link in my sig, below. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Michael Greenberg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 12:05 AM Subject: Email Quandry Hi folks, I have an issue with an HTML email newsletter I am trying to send out. I have a database of approximately 11,000 email addresses I need to send this newsletter to. Is there a way that I can send this out to about 100 addresses at a time? I need some sort of mechanism to loop through the database grab 100 email addresses and send. I'm using CF 5 on Windows 2K. Thanks, Michael ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
not using a stored proc.. just a plain jane query. If you output the variable on the page, it is truncated.. if you do a count on the variable length, it returns 5000. odd. any other thoughts? Mike -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:14 AM To: CF-Talk Subject: RE: CF 4.01 Problem If you output the field into the page as plain text rather than into the textarea, are they all displayed? Maybe it's the textarea that is giving you the problem. Maybe try adjusting the wrap properties? And this may sound odd, but if you are retrieving the data with CFPROCPARAM, try appending an empty string to the end of the data like this: CFSTOREDPROC ... CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=v_foo CFVARNAME=MyValue /CFSTOREDPROC CFSET MyValue = MyValue I've seen a wierd 255 character bug with CFPROCPARAM (in CF5 but it could've been around for awhile) and maybe that's what you're hitting. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:25 AM To: CF-Talk Subject: CF 4.01 Problem Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 Golden Rule: He who has the gold, makes the rules! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
page load times (not just on the server)...
I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 4.01 Problem
Tangorre, Michael wrote: not using a stored proc.. just a plain jane query. If you output the variable on the page, it is truncated.. if you do a count on the variable length, it returns 5000. odd. Are you doing the count in CF or in the database? Do they return the same? If so, at what character does it truncate? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
counted both in Cf and in the DB, both return 5,000. It cuts off at 255 characters when output in the text area. ideas? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:30 AM To: CF-Talk Subject: Re: CF 4.01 Problem Tangorre, Michael wrote: not using a stored proc.. just a plain jane query. If you output the variable on the page, it is truncated.. if you do a count on the variable length, it returns 5000. odd. Are you doing the count in CF or in the database? Do they return the same? If so, at what character does it truncate? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 4.01 Problem
Tangorre, Michael wrote: counted both in Cf and in the DB, both return 5,000. It cuts off at 255 characters when output in the text area. ideas? What character is there at position 255? Use Asc() to find out if there are some 0 or 255 values. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Building and saving a query string
I ended up writing a function to strip the newlines cffunction name=StripNL returnType=string cfargument name=string type=string cfreturn replace(string, #chr(10)#, , all) /cffunction That did the trick. thanks, Luis -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 4:20 PM To: CF-Talk Subject: Re: Building and saving a query string Lots of options: 1) StripCR() CF function 2) Regex for stripping extra CR/LF/spaces 3) database functions for text processing 4) search/replace in either cf or db. I'd try StripCR as a start. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Luis Lebron [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 4:49 PM Subject: Building and saving a query string I'm using the following code to build and display a query string:\ cfsavecontent variable=myquery Select * from contacts where 1 cfif Form.company IS NOT Alland company like '%cfoutput#Form.company#/cfoutput%'/cfif cfif Form.title IS NOT Alland title like '%cfoutput#Form.title#/cfoutput%'/cfif cfif Form.city IS NOT Alland city like '%cfoutput#Form.city#/cfoutput%'/cfif cfif Form.state IS NOT Alland state like '%cfoutput#Form.state#/cfoutput%'/cfif cfif Form.country IS NOT Alland country like '%cfoutput#Form.country#/cfoutput%'/cfif cfif Form.type IS NOT Alland type_of_industry like '%cfoutput#Form.type#/cfoutput%'/cfif cfif Form.size IS NOT Alland company_size cfoutput#Form.size#/cfoutput/cfif cfif Form.department IS NOT Alland department like '%cfoutput#Form.department#/cfoutput%'/cfif cfif Form.source IS NOT Alland source_of_contact like '%cfoutput#Form.source#/cfoutput%'/cfif /cfsavecontent cfoutput#(myquery)# /cfoutput The query string builds and displays correctly. For example: Select * from contacts where 1 and company like '%Company 1%' and title like '%Title 1%' and type_of_industry like '%Manufacturing%' and company_size 250 and department like '%Training% However, when I try to save the query string in the database later it has a lot of unneeded spaces and line breaks like so: Select * from contacts where 1 and company like '%Company 1%' and title like '%Title 1%' and type_of_industry like '%Manufacturing%' and company_size 250 and department like '%Training%' Is there any way I can fix this? thanks, Luis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What does this mean?
This is the CF log entry from the scheduler. I find it a little ambiguous. Was the Verity reindex successful...or merely rescheduled? Information,scheduler-3,01/09/03,07:12:00,,[Index Instructions] Executing at Thu Jan 09 07:12:00 EST 2003 Information,scheduler-3,01/09/03,07:12:00,,[Index Instructions] Rescheduling for :Thu Jan 09 11:24:00 EST 2003 Now: Thu Jan 09 07:12:00 EST 2003 Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ORDER BY Clause and parsing
Something like this would be great for sorting book lists, song titles, DVD and video libraries... Cutter Candace Cottrell wrote: Thanks to everyone who responded. I guess this is going to take a few minutes to do... Maybe I should write a cfc that does this??? For future posterity?? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 1/8/2003 11:47:33 PM In a perfect world, you use regular expressions, but you can probably get most of the work done using the replace() function in your dialect of SQL, or failing that, using the ColdFusion function. It's pretty ugly -- in MSSQL you could use a User-defined function or a view to make a table that doesn't look so nasty SELECT blahblah Replace(LEFT(title,3),the,) as cleanTitle -snip- ORDER BY cleanTitle handles the you could nest them to do something like c or if you can support something like the T-SQL CASE (using sybase or mssql) you could use CASE and the LEFT or PATINDEX index function to chop things up -- something like (off the top of my head) SELECT cleantitle= CASE title WHEN LEFT(title,3) ='the' THEN SUBSTRING(title,4,len(title)) ELSE title END or something along those lines. A UDF would be great way to implement because then you can change the underlying mechanics (say from replace to CASE to regex) without recoding SELECT cleantitle(title) as cleanedTitle ORDER BY cleanedTitle Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 6:48 PM Subject: ORDER BY Clause and parsing Good evening... I am trying to order a list of books by their Title. However, many of the books begin witht the word The or A or An. Is there an easy way to go through and say... cfset actualTitle = query.Title minus A,An, or The then the SQL... Select Title From Books Order By #ActualTitle# Would I need to go through and do a left of the string Title cfset leftVal = Left(query.Title, 3) cfif leftVal IS the cfset actualTitle = query.title - LeftVal Does this make sense??? I just dont think I'm getting it. TIA :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: page load times (not just on the server)...
Wouldn't that completely depend upon the speed of the client's connection? (Dial-Up, Lan, DSL, Cable, etc.)... Cutter cftalk wrote: I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
From most of the old cases, there were only a couple of reasons for this behavior: 1) Old/corrupted version of MDAC You may want to verify the version and validity of your MDAC version. Check the registry key at HKEY_LOCAL_MACHINE \SOFTWARE\Microsoft\DataAccess\FullInstallVer. Also use the Component Checker from Microsoft to be sure the MDAC installation hasn't been screwed up in any way. 2) Field in SQL Server database being stored as a VARCHAR/NVARCHAR datatype. Setting it to TEXT resolved the issue. Deb -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:26 AM To: CF-Talk Subject: RE: CF 4.01 Problem not using a stored proc.. just a plain jane query. If you output the variable on the page, it is truncated.. if you do a count on the variable length, it returns 5000. odd. any other thoughts? Mike -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:14 AM To: CF-Talk Subject: RE: CF 4.01 Problem If you output the field into the page as plain text rather than into the textarea, are they all displayed? Maybe it's the textarea that is giving you the problem. Maybe try adjusting the wrap properties? And this may sound odd, but if you are retrieving the data with CFPROCPARAM, try appending an empty string to the end of the data like this: CFSTOREDPROC ... CFPROCPARAM TYPE=Out CFSQLTYPE=CF_SQL_VARCHAR DBVARNAME=v_foo CFVARNAME=MyValue /CFSTOREDPROC CFSET MyValue = MyValue I've seen a wierd 255 character bug with CFPROCPARAM (in CF5 but it could've been around for awhile) and maybe that's what you're hitting. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:25 AM To: CF-Talk Subject: CF 4.01 Problem Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 Golden Rule: He who has the gold, makes the rules! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: page load times (not just on the server)...
Yes it would...We need to see what the loading times are from different connections. We also want to see if we can improve on it. That is why I am looking for a tool. - Original Message - From: Cutter (CF_Talk) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 8:47 AM Subject: Re: page load times (not just on the server)... Wouldn't that completely depend upon the speed of the client's connection? (Dial-Up, Lan, DSL, Cable, etc.)... Cutter cftalk wrote: I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: page load times (not just on the server)...
Brian, this has nothing to do with CF but it's a nice tool - probably you already know about it... It's not browser dependent (stand alone programme) but it's connection dependent. http://www.alchemy-lab.com/products/eye/index.html HTH, Andrea - Original Message - From: cftalk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 3:54 PM Subject: Re: page load times (not just on the server)... Yes it would...We need to see what the loading times are from different connections. We also want to see if we can improve on it. That is why I am looking for a tool. - Original Message - From: Cutter (CF_Talk) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 8:47 AM Subject: Re: page load times (not just on the server)... Wouldn't that completely depend upon the speed of the client's connection? (Dial-Up, Lan, DSL, Cable, etc.)... Cutter cftalk wrote: I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Can the native Oracle drivers on MX support an encrypted connection
Just looking for a simple yes or no before I go to a meeting later today. Can the native Oracle drivers on MX support an encrypted connection? Or in other words, can the native MX drivers encrypt the communications between CF server and the Oracle server? Thanks Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Icons?
Does anyone know of a good source to get some high quality icons for one of our applications Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: page load times (not just on the server)...
If you are using CF Studio 5 (and maybe 4.x), have you looked at Document Weight on the Tools menu? Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:29 AM To: CF-Talk Subject: page load times (not just on the server)... I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Icons?
Try this http://www.idev.ch/ic/ Andrea - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 4:07 PM Subject: OT: Icons? Does anyone know of a good source to get some high quality icons for one of our applications Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UNSUBSCRIBE
UNSUBSCRIBE ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UNSUBSCRIBE
Nuts. The auto unsubscribe link at the bottom of the email isn't working. How do I unsubscribe? Thanks, Ryan -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:06 AM To: CF-Talk Subject: UNSUBSCRIBE UNSUBSCRIBE ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
not seing 0 or 255 values... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:40 AM To: CF-Talk Subject: Re: CF 4.01 Problem Tangorre, Michael wrote: counted both in Cf and in the DB, both return 5,000. It cuts off at 255 characters when output in the text area. ideas? What character is there at position 255? Use Asc() to find out if there are some 0 or 255 values. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Another Indirect Reference question
Hello all, I have another indirect reference question... I am inside an instantiated CFC. The CFC has a variable called THIS.subMenuVisibility which is an array to hold 1 of 2 words, either Visible or Invisible. I amtrying to set elements of this array by indirect reference. The code to do this is: cfdump var=#ArrayLen(THIS.Inputs)# cfdump var=#THIS.Inputs# cfloop index=InputTypeIndex from=1 to=#ArrayLen(THIS.Inputs)# cfset MenuName = THIS.subMenuVisibility.ulInputType THIS.Inputs [InputTypeIndex][1] Menu cfdump var=#MenuName# cfif NOT isDefined(#MenuName#) cfdump var=Inside #MenuName# cfset #MenuName# = Invisible cfdump var=#evaluate(MenuName) # /cfif /cfloop The results are: THIS.subMenuVisibility.ulInputTypeInputCheckBoxMenu Inside THIS.subMenuVisibility.ulInputTypeInputCheckBoxMenu Invisible THIS.subMenuVisibility.ulInputTypeInputRadioMenu Inside THIS.subMenuVisibility.ulInputTypeInputRadioMenu Invisible THIS.subMenuVisibility.ulInputTypeInputSelectMenu Inside THIS.subMenuVisibility.ulInputTypeInputSelectMenu Invisible THIS.subMenuVisibility.ulInputTypeInputTextMenu Inside THIS.subMenuVisibility.ulInputTypeInputTextMenu Invisible THIS.subMenuVisibility.ulInputTypeInputTextAreaMenu Inside THIS.subMenuVisibility.ulInputTypeInputTextAreaMenu Invisible (The cfdump of the array) struct ULAUTHORMENU Invisible ULCONTENTMENU Invisible ULFORMMENU Invisible ULINPUTMENU Invisible ULPROCESSMENU Invisible ULSTEPMENU Invisible It appears to me that I am setting a variable that is titled what I want; it just isn't an element of the array like I want. If anybody has any ideas, I would be most appreciative. Thank you in advance. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Unsubscribing
Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
Michael; Had this problem before. I imported the database from Access and the size of the field was NTEXT. Check your tables in SQL Server and make sure the text field is set to either varchar(5000) or TEXT. One of these should work. M -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:19 AM To: CF-Talk Subject: RE: CF 4.01 Problem not seing 0 or 255 values... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
send a mail to the moderator... check the website -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: 09 January 2003 15:12 To: CF-Talk Subject: Unsubscribing Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF 4.01 Problem
the field is already a text field.. -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:15 AM To: CF-Talk Subject: RE: CF 4.01 Problem Michael; Had this problem before. I imported the database from Access and the size of the field was NTEXT. Check your tables in SQL Server and make sure the text field is set to either varchar(5000) or TEXT. One of these should work. M -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:19 AM To: CF-Talk Subject: RE: CF 4.01 Problem not seing 0 or 255 values... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: page load times (not just on the server)...
Off the top of my head, here's the only way I could see doing this: Convert EVERY link to a form.(yuck) Or assign an ID to each link and write a javascript function that monitors for clicks and compares all the ids to the id of the clicked link(or some such). Use javascript to set a hidden form field to the user's current time then submit onClick for the link. On the next page, onLoad take the users current time, pop a hidden window that submits the prior time(from the form field) and the current time. Server side code to compute the difference and store in db. Take them to the link they clicked if the storage mechanism needs an interim update page. I'm sure there are a hundred ways to go about this, and I usually avoid javascript when possible so I'm not tops with the language. Just some ideas. t/ Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: cftalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:29 AM To: CF-Talk Subject: page load times (not just on the server)... I am needing to find the page load times from the CLIENT side. Does anyone have a tool or know a way to do this? Brian Yager President - North Alabama Cold Fusion Users Group http://www.nacfug.com Ground-Based Midcourse Defense JPO Contractor CSC (256)313-9397 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: BlueDragon J2EE on OSX - Working !!!
I'd ask them if they have examples of sites they know are using warez software... :-) At 03:48 PM 1/8/2003, you wrote: At 6:39 PM 1/7/3, Vince Bonfanti wrote: JRun 4 + CFMX = $900/CPU + $3400/CPU = $4300/CPU Tomcat + BlueDragon = Free + $1000/server = $1000/server Hmm... how do you respond to people who point out that they can get if for free on a warez site...? jd ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
Unfortunately, you can't. You are trapped in here with the rest of us, forever and ever and ever...hahahahahha -Original Message- From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:12 AM To: CF-Talk Subject: Unsubscribing Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF / Flash Question
check out components and data grid.
some fantastic resources working and sort with table data and recordsets
here
http://www.flash-db.com/Components/?swfID=21sComType=Custom
also check out
flashcomponents.net
good luck
jay miller
Joshua Miller wrote:
Thanks Jason, I'll check it out!
I think I'm going to add a feature request ... Wouldn't be proper for
HTML to be able to do something like this and FLASH not have the power.
One other thing that would be cool is a table object for outputting
data into table format without using HTML inside of Flash. You can
simulate data fields with movie clips, but it's unnecessarily
complicated.
I'm sure there's a feature request for Flash on Macromedia.com :)
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Jason Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 11:47 PM
To: CF-Talk
Subject: Re: CF / Flash Question
Well I bet it can be done using the GetURL or some send and Load objects
- I was just playing around with it. There 1 work around I had found -
it is here... Basically - you can use the chromeless window concept or a
frame concept
- but bottom line is your sending variables through javascript and html
to get the upload to work.
If you do it graphically well - no one would know the difference.
http://www.flashcfm.com/tutorial_search.cfm?keyword=file%20upload
http://www.flashcfm.com/tutorial_search.cfm?keyword=file%20upload
Funny thing about your code below is - you mentioned you never got a
error or a failed.. just figured I would share - you are forcing a
success=true or false on the .cfm page strings.. in flash 6 player you
don't need to do this - flash 6 player provides success true or false.
Good luck - I know I have seen this done in all falsh SOMEWHERE - I
would love to use it and modify it so will keep searching - but the
above link provides a definate working sample to make life easier.
jay miller
Christian Cantrell wrote:
I think Matt is right on this one. I don't think it can be done other
than to pop up a small browser instance and use an HTML form. Browsers
place a lot of security restrictions around file inputs (and rightfully
so), so I think you may just have to play by the browser's rules.
You can always ask for a URL, then have the server download the file,
or ask the user to paste the contents of the file into a text field if
the file is known to be all text, but these are not particularly
attractive solutions.
Sounds like a Flash feature request to me.
Christian
On Wednesday, January 8, 2003, at 05:30 PM, Joshua Miller wrote:
Actually, what I'm trying to do is simulate the FILE input field to
Upload a file against a CFML page. Strangely, I've tried and tried and
the CF page doesn't fail or error, it just doesn't upload the file.
It acts like the contentType isn't being set or as if it doesn't
recognize the fact that I'm trying to UPLOAD a file.
Again, here's the FLASH:
==
function respond(){
goToAndPlay(My Scene,1);
stop();
}
function upload(){
dtsVars = new LoadVars();
dtsVars.myfile=c:\test.txt;
dtsVars.onLoad=respond;
dtsVars.contentType=multipart/form-data;
dtsVars.sendAndLoad( http://192.168.0.2/upload.cfm;
http://192.168.0.2/upload.cfm ,dtsVars,POST);
}
upload();
stop();
Here's the CFML to process the upload:
==
cfif isdefined(myfile)
cffile action=UPLOAD filefield=myfile destination=d:\
nameconflict=MAKEUNIQUE
cfoutputstart=1myfile=#myfile#success=true/cfoutput
cfelse
cfoutputstart=1myfile=failedsuccess=false/cfoutput
/cfif
Anyone have any clues? I'm going to try Matt's idea with the chromeless
window if I can't actually use ActionScript.
Does anyone from Macromedia have a suggestion? Can you upload files to
CF from FLASH ???
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net http://www.garrisonenterprises.net
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
(704) 569-9044 ext. 254
RE: Unsubscribing
NOOO ! -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:27 AM To: CF-Talk Subject: RE: Unsubscribing Unfortunately, you can't. You are trapped in here with the rest of us, forever and ever and ever...hahahahahha -Original Message- From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:12 AM To: CF-Talk Subject: Unsubscribing Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF / Flash Question
At 10:03 PM 1/8/2003, you wrote: here is the url to the flash wish form: http://www.macromedia.com/support/email/wishform/?6213=9 as far as the table, you could achieve something similar using the DataGrid component on DRK 1. It would involve using some custom cell renderers (there is an example of this on the DRK). here is the url to the DRK: http://www.macromedia.com/software/drk/ mike chambers [EMAIL PROTECTED] There's a difference between an interactive grid and a visual only table, particularly when you talk about the need for merged cells. Implementing merged cells in the DataGrid, while extremely useful, would be complex. However, if there was a table component which provided view only, merged cells are not such a big deal. We had to create a table component for one of our projects just for this reason, and required view only (not interactive). My $0.02 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF MX cfobject
What does the COM object due? Perhaps there is a Java alternative that would work much better in CFMX. Make sure you've installed UR2. At 06:10 PM 1/8/2003, you wrote: I am having trouble getting this object to work via cold fusion. Works fine in asp. In ASP file 'Create ID3Edit object set reg-code to READONLY Set objID3 = server.CreateObject(ID3Edit.ID3Tag) In cold fusion mx file cfobject type=COM name=ObjID3 class=ID3Edit.ID3Tag action=CREATE I get: An exception occurred when instantiating a Com object. The cause of this exception was that: AutomationException: 0x800401f7 - Some error in application program. The error occurred in D:\Inetpub\wwwroot\Default\test.cfm: line 34 Any suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Icons?
http://www.glyfx.com/ Nice stuff. - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 10:07 AM Subject: OT: Icons? Does anyone know of a good source to get some high quality icons for one of our applications Thanks Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adding All to cfselect
I want to use cfselect to dynamically generate select boxes, however I also need to have an All option as part of the select. Is there any easy way to do this other than adding All to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
client mangement in MX eliminates embedded form validation
Am trying to move several sites from CF5 to MX. Most have clientmanagement enabled. For administrative sections (where I know the browser/system client uses) I use the old embedded form validation (field_required, field_date, etc) in several places. Of course use scripted server-side error handling in critical places. However, am finding that IF clientmanagement is enabled in MX, this method becomes impossible because when go back to form on browser to take care of problems, ALL fields are empty. Apparently something with clientmangement causes the page to expire. If clientmanagement is set to NO in application.cfm in MX, then the technique works as expected. (In CF5 all works as expected regardless clientmanagement setting.) Would appreciate any ideas on setting changes, work-arounds, etc. so this method can be used. I can't believe that it is MX's intention that this useful technique be useless! (It also makes it so you can't have some more formal server-side handling and expect user to be able to go back and take care of problems.) I have two pages that illustrate; one with clientmanagement enabled, the other not. Just fill in some data but leave last name blank. http://www.wingserv.com/testform.cfm has clientmanagement enabled http://www.wingserv.com/church/testform.cfm clientmanagement not enabled Appreciate any help on this as it is preventing my upgrading a number of sites to MX. E. Keith Dodd Wings of Eagles Services www.wingserv.com (I've posted variations of this problem before, with most responses recommending not to expect browser to *hold* form material. I realize the problems involved, but cannot see revising dozens of forms because of this behavior.) - [This E-mail scanned for viruses by declude AntiVirus Software] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding All to cfselect
You can just put an option value=all selectedALL/option between the cfselect and the /cfselect tags. -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:43 AM To: CF-Talk Subject: Adding All to cfselect I want to use cfselect to dynamically generate select boxes, however I also need to have an All option as part of the select. Is there any easy way to do this other than adding All to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding All to cfselect
You can manually include any options you want between the start and end tags as in: CFSELECT ... OPTION VALUE=AllAll /CFSELECT Unfortunately, these manually added options will only appear at the bottom of the list. Alternatively, you can use JavaScript to add items to the list once the code is received by the client. However, not all browsers... blah blah blah. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:43 AM To: CF-Talk Subject: Adding All to cfselect I want to use cfselect to dynamically generate select boxes, however I also need to have an All option as part of the select. Is there any easy way to do this other than adding All to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding All to cfselect
Thanks. -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:00 AM To: CF-Talk Subject: RE: Adding All to cfselect You can just put an option value=all selectedALL/option between the cfselect and the /cfselect tags. -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:43 AM To: CF-Talk Subject: Adding All to cfselect I want to use cfselect to dynamically generate select boxes, however I also need to have an All option as part of the select. Is there any easy way to do this other than adding All to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding All to cfselect
i think qforms might work for you better. Go read up on them at www.pengoworks.com the javascript API is very versatile and the container section may be able to help you out. Mike -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:55 AM To: CF-Talk Subject: RE: Adding All to cfselect Thanks. -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:00 AM To: CF-Talk Subject: RE: Adding All to cfselect You can just put an option value=all selectedALL/option between the cfselect and the /cfselect tags. -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:43 AM To: CF-Talk Subject: Adding All to cfselect I want to use cfselect to dynamically generate select boxes, however I also need to have an All option as part of the select. Is there any easy way to do this other than adding All to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF MX cfobject
David, I had the same problems when I upgraded to MX. I was using CFXid3 or something like that, and it was using a COM object. The object for one reason or the other wouldn't always load, and when it did, it wasn't reliable. Sometimes locking up my treads. So I moved everything over to a java class, and have had a lot of success. I'll send you the CFC this weekend, I need to strip it down and take out all of my internal stuff, like updating my database, and loading directories. (specific to my application) Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: David D Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 6:10 PM To: CF-Talk Subject: CF MX cfobject I am having trouble getting this object to work via cold fusion. Works fine in asp. In ASP file 'Create ID3Edit object set reg-code to READONLY Set objID3 = server.CreateObject(ID3Edit.ID3Tag) In cold fusion mx file cfobject type=COM name=ObjID3 class=ID3Edit.ID3Tag action=CREATE I get: An exception occurred when instantiating a Com object. The cause of this exception was that: AutomationException: 0x800401f7 - Some error in application program. The error occurred in D:\Inetpub\wwwroot\Default\test.cfm: line 34 Any suggestions? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adding All to cfselect
In my case I added OPTION VALUE=All selectAll to make it the default option. thanks, Luis -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:00 AM To: CF-Talk Subject: RE: Adding All to cfselect You can manually include any options you want between the start and end tags as in: CFSELECT ... OPTION VALUE=AllAll /CFSELECT Unfortunately, these manually added options will only appear at the bottom of the list. Alternatively, you can use JavaScript to add items to the list once the code is received by the client. However, not all browsers... blah blah blah. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 10:43 AM To: CF-Talk Subject: Adding All to cfselect I want to use cfselect to dynamically generate select boxes, however I also need to have an All option as part of the select. Is there any easy way to do this other than adding All to the database field? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JBoss CFMXJ2EE was a lot of other stuff
On Thursday, Jan 9, 2003, at 03:06 US/Pacific, Dick Applebaum wrote: 1) Create a copy of the Server all named CFMX1 2) Start JBoss with ..././run.sh -c CFMX1 Or just deploy CFMX into the default/deploy area... 3) Copy/rename rds.war to CFMX1/deploy as CFIDE.war (so it will deploy as CFIDE) -- you can see it hot deploy in the terminal window Yes, correct. 4) Copy cfusion to CFMX1/deploy -- you can see it hot deploy Ah, I had told the installer to use 'cfmx' as the context root originally rather than 'cfusion' - once I copied cfusion.war in as cfmx.war, it was slightly more successful. 5) try and access it with http://127.0.0.1:8080/cfusion/CFIDE/ -- this works lists the contents of CFIDE Yes, but there's not exactly much in that context root :) 6) try and access it with http://127.0.0.1:8080/cfusion/CFIDE/administrator/index.cfm -- this gives a 500 error I get this: type Exception report message Internal Server Error description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request. exception javax.servlet.ServletException: Servlet.init() for servlet CfmServlet threw exception at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.jav a:952) at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:6 58) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:214) But if I look at the log of JBoss trying to deploy cfmx.war, I see: 08:51:31,589 INFO [MainDeployer] Starting deployment of package: file:/home/jboss/server/default/deploy/cfmx.war 08:51:50,276 INFO [EmbeddedCatalinaService41] deploy, ctxPath=/cfmx, warUrl=file:/home/jboss/server/default/tmp/deploy/server/default/ deploy/cfmx.war/90.cfmx.war 08:51:50,634 INFO [Engine] WebappLoader[/cfmx]: Deploying class repositories to work directory /home/jboss/tomcat-4.1.x/work/MainEngine/localhost/cfmx 08:51:50,639 INFO [Engine] WebappLoader[/cfmx]: Deploy class files /WEB-INF/classes to /home/jboss/tomcat-4.1.x/work/MainEngine/localhost/cfmx/WEB-INF/classes 08:51:50,641 INFO [Engine] WebappLoader[/cfmx]: Deploy JAR /WEB-INF/lib/cfmx_bootstrap.jar to /home/jboss/tomcat-4.1.x/work/MainEngine/localhost/cfmx/WEB-INF/lib/ cfmx_bootstrap.jar 08:51:50,651 INFO [Engine] WebappLoader[/cfmx]: Deploy JAR /WEB-INF/lib/cfx.jar to /home/jboss/tomcat-4.1.x/work/MainEngine/localhost/cfmx/WEB-INF/lib/ cfx.jar 08:51:50,660 INFO [Engine] WebappLoader[/cfmx]: Deploy JAR /WEB-INF/lib/js.jar to /home/jboss/tomcat-4.1.x/work/MainEngine/localhost/cfmx/WEB-INF/lib/ js.jar 08:51:51,003 INFO [Engine] StandardContext[/cfmx]: WARNING: URL pattern servlet/AxisServlet must start with a / in Servlet 2.3 08:51:51,007 INFO [Engine] StandardContext[/cfmx]: WARNING: URL pattern servlet/AdminServlet must start with a / in Servlet 2.3 08:51:51,158 INFO [Engine] ContextConfig[/cfmx]: Added certificates - request attribute Valve 08:51:51,891 INFO [EmbeddedCatalinaService41] Using Java2 parent classloader delegation: true 08:51:51,893 INFO [Engine] StandardManager[/cfmx]: Seeding random number generator class java.security.SecureRandom 08:51:51,895 INFO [Engine] StandardManager[/cfmx]: Seeding of random number generator has been completed 08:51:51,898 INFO [Engine] StandardWrapper[/cfmx:default]: Loading container servlet default 08:51:51,922 ERROR [Engine] StandardContext[/cfmx]: Servlet /cfmx threw load() exception javax.servlet.ServletException: Servlet.init() for servlet FlashGateway threw exception at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.jav a:952) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:813) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.j ava:3341) In other words, the Servlet failed to initialize - so it's not surprising that subsequent operations fail. The JBoss install negated my Tomcat install It's relatively easy to have Tomcat use a port other than 8080 so that you can have both systems up at the same time: Edit tomcat/conf/server.xml and change 8080 to some other port (like 8180) around line 87 (the CoyoteConnector setup). I have the following CF installs on my TiBook, all running without conflicts: CFMX Linux port hack (port 8500) CFMX for J2EE on JRun 4 (port 8300, JRun on 8000) /cfusion context root, one instance CFMX for J2EE on Tomcat (port 8180) /cfmac context root /cfmx context root /cfusion context root all for different applications Hopefully, I'll soon have another one on JBoss (port 8080)! I also tried to install mod_rendevous on the Apache server, but it wouldn't install -- likely because the installation of the JRun connector and/or Tomcat and/or JBoss. Yes, apxs puts the
RE: Email Quandry
We're purchasing (and may have already purchased) iMS. But here's what I've done in the past: START WITH A FORM SOMETHING LIKE THIS: cfparam name=form.startrow default=1 cfparam name=form.endrow default=300 cfparam name=FORM.SUBJECT default=some subject line cfparam name=FORM.comments default= CFform action=hub.cfm?action=send_email#CLIENT.URLtoken# method=post name=frm_email table border=0 WIDTH=400 cellspacing=0 cellpadding=0 ALIGN=center class=textblack tr bgcolor=#eaeaeatd colspan=7 class=textblackbold style=font-size: 12pt;E-mail /td/tr trtd colspan=3nbsp;/td/tr tr td class=textblack colspan=3 cfoutputThere are currently #FindRecords.recordCount# records in the database/cfoutput br br Use the form below to generate an e-mail. br br For best results, only 300 e-mails should be sent out at a time. Select the start row and end row numbers. table width=100 cellpadding=4 align=left tr td class=textblackbold nowrap cfinput name=startrow required=yes message=The Start Row field is required size=4 maxlength=4 value=#form.startrow#br Start Row /td td class=textblackbold nowrap cfinput name=endrow required=yes message=The End Row field is required size=4 maxlength=4 value=#form.endrow#br End Row /td /tr /table /td /tr tr td class=textblackbold nowrap width=50 Subject: /td td colspan=2 width=350 cfinput name=SUBJECT required=yes message=The Subject field is required size=56 maxlength=128 value=#FORM.SUBJECT#/td /tr tr td class=textblackbold nowrap colspan=3 Body: br textarea cols=48 rows=8 name=commentscfoutput#FORM.comments#/cfoutput/textarea /td /tr trtd colspan=3nbsp;/td/tr tr td colspan=3 align=centerinput type=submit value=SEND class=textblackbold/td /tr /table /cfform THE SUBMISSION WILL SEND TO THE FOLLOWING QRY PAGE AND FORM IS REINCLUDED IN THE RESPONSE SO YOU CAN SEND OUT THE NEXT BATCH. cfset StartRow = #form.startrow# cfset EndRow = #form.endrow# CFSET NewBody = comments cfmodule template=../tags/wrap.cfm variable=NewBody width=80 cfloop query=FindRecords startrow=#StartRow# endrow=#EndRow# cfmail to=#FindRecords.EMAIL# from=[EMAIL PROTECTED] subject=#form.subject# #NewBody# /cfmail /cfloop cfset form.startrow=form.endrow+1 cfset form.endrow=form.endrow+300 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
Welcome to the CF-Talk List! Such a lovely List Such a lovely list (background) Plenty of room at the CF Talk List! Any time of year Any time of year (background) You can find it here You can find it here (background) Last thing I remember I was trying to unsubscribe! I had to find the link back to the place I was before Relax said the moderator.. We are programed to recieve You can subscribe any time you like But you can never leeAve! *starts guitar solo* -Gel ;-) -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] NOOO ! -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Unfortunately, you can't. You are trapped in here with the rest of us, forever and ever and ever...hahahahahha -Original Message- From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
lol | -Original Message- | From: Angel Stewart [mailto:[EMAIL PROTECTED]] | Sent: Thursday, January 09, 2003 9:58 AM | To: CF-Talk | Subject: RE: Unsubscribing | | | Welcome to the CF-Talk List! | Such a lovely List | Such a lovely list (background) | Plenty of room at the CF Talk List! | Any time of year | Any time of year (background) | You can find it here | You can find it here (background) | | Last thing I remember | I was trying to unsubscribe! | I had to find the link back to the place I was before | Relax said the moderator.. | We are programed to recieve | You can subscribe any time you like | But you can never leeAve! | | *starts guitar solo* | | -Gel | ;-) | | -Original Message- | From: Ryan Farrell [mailto:[EMAIL PROTECTED]] | | NOOOoo | oo | | ! | | -Original Message- | From: John Stanley [mailto:[EMAIL PROTECTED]] | | Unfortunately, you can't. You are trapped in here with the | rest of us, forever and ever and ever...hahahahahha | | -Original Message- | From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] | | Hey, folks! | | Since the auto unsubscribe link at the bottom of these email posts | don't work, how do I unsubscribe? | | Thanks! | | Ryan | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
Angel, (lol) wow - you have some real talent there. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 11:58 AM To: CF-Talk Subject: RE: Unsubscribing Welcome to the CF-Talk List! Such a lovely List Such a lovely list (background) Plenty of room at the CF Talk List! Any time of year Any time of year (background) You can find it here You can find it here (background) Last thing I remember I was trying to unsubscribe! I had to find the link back to the place I was before Relax said the moderator.. We are programed to recieve You can subscribe any time you like But you can never leeAve! *starts guitar solo* -Gel ;-) -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] NOOO ! -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Unfortunately, you can't. You are trapped in here with the rest of us, forever and ever and ever...hahahahahha -Original Message- From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
I used to work at a place that had Potable Fridays. That meant the company president would buy us all alcohol after lunch. Are you have a potable Thursday, Gel? At 01:58 PM 1/9/2003 -0400, you wrote: Welcome to the CF-Talk List! Such a lovely List Such a lovely list (background) Plenty of room at the CF Talk List! Any time of year Any time of year (background) You can find it here You can find it here (background) Last thing I remember I was trying to unsubscribe! I had to find the link back to the place I was before Relax said the moderator.. We are programed to recieve You can subscribe any time you like But you can never leeAve! *starts guitar solo* -Gel ;-) -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] NOOO ! -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Unfortunately, you can't. You are trapped in here with the rest of us, forever and ever and ever...hahahahahha -Original Message- From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
transactions and multiple datasources
I have a set of db inserts involving two datasources and if there is a failure in the 2nd datasource, I need to roll back the transaction on the first datasource. In a perfect world I could somehow hold up the first transaction commit until the transaction on the second datasource has completed successfully and then commit them both. However I'm not sure how to do this with cftransaction since it throws an error if multiple datasources are used. Doing the transaction in just SQL might be doable, but I would like to avoid that if at all possible, because the amount of re-engineering that would be necessary. Anyone have a suggestion? -- jon mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TSQL Equivalent to Replace
Is there a TSQL function equivalent to the CF replace function? Thanks, Duane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT
mirrors on the ceiling...pink champagne on ice...we are all prisoners here...of our own device ;-) Do you have any idea how SICK I am of hearing Hotel California? Almost as much as Paradise by the Dashboard Lights. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unsubscribing
mirrors on the ceiling...pink champagne on ice...we are all prisoners here...of our own device ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 9:58 AM Subject: RE: Unsubscribing Welcome to the CF-Talk List! Such a lovely List Such a lovely list (background) Plenty of room at the CF Talk List! Any time of year Any time of year (background) You can find it here You can find it here (background) Last thing I remember I was trying to unsubscribe! I had to find the link back to the place I was before Relax said the moderator.. We are programed to recieve You can subscribe any time you like But you can never leeAve! *starts guitar solo* -Gel ;-) -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] NOOO ! -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Unfortunately, you can't. You are trapped in here with the rest of us, forever and ever and ever...hahahahahha -Original Message- From: Ryan Farrell [SMTP:[EMAIL PROTECTED]] Hey, folks! Since the auto unsubscribe link at the bottom of these email posts don't work, how do I unsubscribe? Thanks! Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: style sheet weirdness
Hi All,
I've got a stylesheet with a bunch of text related elements in it. No matter
which text element I place first in the list of elements, it will be
ignored.
For example:
STYLE TYPE=text/css
/* TEXT */
.Normal_Text_Black
{
font-family : Verdana, Geneva, Arial;
font-size : 12px;
color : 00;
}
.Bold_Normal_Text_Black
{
font-family : Verdana, Geneva, Arial;
font-size : 12px;
font-weight : bold;
color : 00;
}
/STYLE
The Normal_Text_Black element will display as normal 12 point Times New
Roman text. If I move it down and replace it with the
Bold_Normal_Text_Black element, then all text using that element will
display as normal 12 point Times New Roman text!! This happens for ANY
elemnt I place at the top of the stylesheet.
Does anybody know what might be going on here?
Thanks
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Email Quandry
The code below will work fine for you. It will throttle down your mail send rate. As is it'll send your 11000 emails in 45 mins or so. This abomination was created when my ISP didn't want me sending more than about 600 msgs per hr on his shared server. I still use it to keep those overzealous spam filters that Jochem mentioned from catching on (AOL and Hotmail, particularly). It's very low-tech, but it works. My ReRun rate is tied to my server's cfmail spool pickup interval (15 secs), and yours should be too. Note I added an extra second in there to make sure the spool is flushed. A solution for grown-ups would be iMS, but I can't figure out a way around AOL's temporary blocking schemes that will let me shoot out mail in qty. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - - - - - - - - - - - - - Site Design and ColdFusion Developer Tools cfsilent !--- how many messages are sent per operation? --- cfset variables.RunRate=10 !--- How many seconds between attempts? --- cfset variables.ReRunRate=16 cfset variables.PerMinute=60/variables.ReRunRate cfset variables.HourRate=variables.RunRate*variables.PerMinute*60 cfparam name=url.RunType type=string default=NORMAL cfquery name=RecShow datasource=#request.SiteDSN# cachedwithin=#CreateTimeSpan(0,0,1,0)# SELECT cm_topics.ID, cm_topics.PageText, cm_topics.Title FROM cm_topics WHERE cm_topics.ID=#client.EditMarker# /cfquery cfquery datasource=#request.SiteDSN# name=GetSelf cachedwithin=#CreateTimeSpan(0,0,1,0)# SELECT cm_users.Email FROM cm_users WHERE cm_users.ProCode=#client.Producer# /cfquery cfquery datasource=#request.SiteDSN# name=MailRun cachedwithin=#CreateTimeSpan(0,0,1,0)# SELECT cm_email.EmailAddr FROM cm_email WHERE cm_email.EmailAddr IS not NULL AND cm_email.ParentID=#client.EditMarker# ORDER BY cm_email.ID ASC /cfquery cfparam name=url.ThisStart default=1 type=numeric /cfsilent cfheader name=Expires value=Sun, 06 Nov 1994 08:49:37 GMT cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate cfif ThisStart GT MailRun.RecordCount htmlheadtitleFINISHED/title/headbody bgcolor=#FF ONLOAD=history.go(1) H1font color=#008000All Done/font/H1 bfont color=#80You should close this browser window/font!/b pbDo not press your BACK button/b to leave, or you could wind up sending some email messages all over again. /body/html cfelse cfoutput query=MailRun cfset form.MessageBody=RecShow.PageText /cfoutput cfset variables.NextStart=url.ThisStart+20 cfset variables.NextDisplay=url.ThisStart+19 cfif variables.NextDisplay GT MailRun.RecordCount cfset variables.NextDisplay=MailRun.RecordCount /cfif !--- set a UUID in the url to help make sure the browser keeps the page out of the cache. --- cfset variables.UURL=UrlEncodedFormat(CreateUUID()) html cfoutput meta http-equiv=REFRESH content=#variables.ReRunRate#; URL=#CGI.SCRIPT_NAME#?ThisStart=#variables.NextStart#UURL=#variables.UU RL# /cfoutput headtitleLow Volume Mass Mailer/title/headbody bgcolor=#FF ONLOAD=history.go(1) font FACE=Georgia, Times New Roman, Times !--- this is version 1, tested over time to work fine at large volumes --- cfset variables.ContentValue=text/html; charset= chr(34) iso-8859-1Chr(34) cfmail to=#MailRun.EmailAddr# from=#GetSelf.Email# subject=#RecShow.Title# server=#Settings.EmailServer# query=MailRun maxrows=#variables.RunRate# startrow=#url.ThisStart# type=HTML #RecShow.PageText# cfmailparam name=Reply-To value=#GetSelf.Email# cfmailparam name=Message-ID value=#CreateUUID()#@#Settings.EmailServer# cfmailparam name=Content-Type value=#variables.ContentValue# cfmailparam name=Mime-Version value=1.0 /cfmail cfset variables.NumLeft=MailRun.RecordCount-(variables.NextDisplay-1) cfset variables.TimeLeft=fix(variables.NumLeft/variables.PerMinute) cfoutput H1font color=##80Sending messages/font #url.ThisStart# font color=##80thru/font #variables.NextDisplay#/H1 table border=1 cellpadding=4 cellspacing=0 bgcolor=##cc tr td align=rightSPAN class=FormBodyTotal to
Re: JBoss CFMXJ2EE was a lot of other stuff
On Thursday, January 9, 2003, at 09:39 AM, Sean A Corfield wrote: snip Anyway, I will read up more on JBoss and see if I can determine what I am doing wrong Good luck, I spent an hour reading the (huge) JBoss Getting Started PDF and couldn't figure it out :) I got similar results to you. And, yes, the Getting Started PDF is huge, and doesn't say much about deploying. I was hoping the there are some JBoss experts out there with experience deploying CFMX for J2EE or similar applications. Dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
*wry chuckle* Over here we have 'pot able' days all the time. And it doesn't mean alcohol. -Gel -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 2:37 PM To: CF-Talk Subject: RE: Unsubscribing I used to work at a place that had Potable Fridays. That meant the company president would buy us all alcohol after lunch. Are you have a potable Thursday, Gel? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unsubscribing
I appologise for not finishing up the unsubscribe portion of the link. It should be working now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TSQL Equivalent to Replace
Oops found it. Replace (doh!) Duane -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 1:40 PM To: CF-Talk Subject: TSQL Equivalent to Replace Is there a TSQL function equivalent to the CF replace function? Thanks, Duane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TSQL Equivalent to Replace
Uhhh, replace? - Original Message - From: Duane Boudreau [EMAIL PROTECTED] Date: Thursday, January 9, 2003 11:40 am Subject: TSQL Equivalent to Replace Is there a TSQL function equivalent to the CF replace function? Thanks, Duane ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UNSUBSCRIBE
Link seems to work fine for me... Maybe the internet is broken... -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 7:08 AM To: CF-Talk Subject: RE: UNSUBSCRIBE Nuts. The auto unsubscribe link at the bottom of the email isn't working. How do I unsubscribe? Thanks, Ryan -Original Message- From: Ryan Farrell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:06 AM To: CF-Talk Subject: UNSUBSCRIBE UNSUBSCRIBE ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX on J2EE for Linux Performance Brief
There's a new performance brief on DesDev for CFMX. It seems CFMX for J2EE on Linux smokes all other platforms...and is even more impressive when compared to CF5 on Linux...now I wonder what the metrics would look like on RedHat Advanced server using BEA's JRockit JVM (although not supported) !! Or better yet, CMFX for BEA running on RH AS! Another 10-25% gain? http://www.macromedia.com/desdev/mx/coldfusion/whitepapers/cfmx_jrun_per f_brief.pdf ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: style sheet weirdness
What browser? It is working fine for me on ie6 Jerry Johnson [EMAIL PROTECTED] 01/09/03 01:50PM Hi All, I've got a stylesheet with a bunch of text related elements in it. No matter which text element I place first in the list of elements, it will be ignored. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity Error
Well, I have a Verity issue. I am trying to remove a file from a verity collection and when I try this I get the following error, and due to the complete lack of documentation on CF + Varity I am stumped. Anyone want to take a stab? Error # -33 [ffdf] VdkCollectionSubmit Thanks all, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com We create websites that make you a hero. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unsubscribing
You guys cook at work sometimes? Matt -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 1:13 PM To: CF-Talk Subject: RE: Unsubscribing *wry chuckle* Over here we have 'pot able' days all the time. And it doesn't mean alcohol. -Gel -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 2:37 PM To: CF-Talk Subject: RE: Unsubscribing I used to work at a place that had Potable Fridays. That meant the company president would buy us all alcohol after lunch. Are you have a potable Thursday, Gel? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unsubscribing
Now that the issue is fixed, can we please move the OT conversation about it to CF-Community where it's already being discussed. Thanks I appologise for not finishing up the unsubscribe portion of the link. It should be working now. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: style sheet weirdness
IE 5.5 SP2 Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 11:26 AM Subject: Re: OT: style sheet weirdness What browser? It is working fine for me on ie6 Jerry Johnson [EMAIL PROTECTED] 01/09/03 01:50PM Hi All, I've got a stylesheet with a bunch of text related elements in it. No matter which text element I place first in the list of elements, it will be ignored. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
BlueDragon J2EE on OSX - Working !!!
I've read this several times, and I'm still trying to understand your point. If people steal JRun and CFMX/J2EE, then BlueDragon loses it's price advantage? If people steal BlueDragon, then they have an even greater price advantage over JRun/CFMX? There are people who will rip you off no matter what you do, as I'm sure Macromedia is well aware. Fortunately for both of us, there are enough honest people and companies that honor license agreements (most people and companies, in my opinion) that we can make a living in this business. For those people and companies, the difference between $4300/CPU and $1000/server might be significant. Besides all that, I've often felt that I'd rather have people steal my software than pay for my competitors. ;-) Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com/bluedragon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
trigger problem
Dear all Rather than looping over a list to insert multiple log rows, it occurred to me that I could have a 'dummy' column in the master table so one inserts all logs at once thus: UPDATE Mymaster SET mydummy = 4 WHERE mykey IN(5l,67,21) and then have a trigger in the 'Mymaster' table which lets SQL Server actually insert the row in the log in its own time thus: FOR UPDATE AS IF UPDATE(mydummy) INSERT INTO [dbo].[mylog] (mykey,mydummy) SELECT mykey, mydummy FROM INSERTED This works fine if there is only one value in the IN() clause but fails if there is more than one; Subquery returned more than 1 value I had slightly assumed triggers work on a row by row basis, but this would suggest they might not. I am sure there is a simple way around this. Can anyone help please? (this is CF5 by the way) -- Regards; Richard Meredith-Hardy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
submit cfform without submit button
Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit cfform without submit button
It's already the default in IE. In NN you need to look at the onKey events, should be like onKeyDown, onKeyUp, onKeyPress, something like that. Then when the event is triggered you kick of a script that does a form submit. Tim -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:07 PM To: CF-Talk Subject: submit cfform without submit button Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Hal Helms DevNotes
Has anyone used Hal Helms DevNotes on CFMX? I am having an issue that I can't figure out and wondered if it is due to the fact I have it installed on CFMX vs CF5 ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.441 / Virus Database: 247 - Release Date: 1/9/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Nested Tree DHTML
I have something like this (though not 215 seconds worth) and get around it by only running the nested queries when a change is made and it creates a hard page (which can be CFinserted as required) John Quarto-vonTivadar wrote: You mean the Joe Celko model? It's a great way to store tree data and to manipulate it but if you're hitting it every time for display then it's no wonder you have a slowdown. Really, what should be done is to store the info in the Celko model and then everytime something changes to store the newly completed tree somewhere (or in a separate table?) where it can be quickly retrieved. Changes to trees are made during upkeep etc but then displaying the tree between changes would be redundant to 'regenerate' the tree You could do the generation of the tree and then use a separate table (obviously non-normalized) which records ordered from top to bottom in the way determined by the actual tree query. You could also save it as XML at that point too. -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 3:01 PM To: CF-Talk Subject: Nested Tree DHTML I have a nested tree built with Steve Nelson's model. I'm also presenting it with the tigra tree DHTML package. It's gotten so large it takes 215 seconds to resolve even with the query cached! The package takes one long character string and parses it out into tables and such. Any ideas on how to speed this up? I had thought originally that caching the query and possibly even running it in the background as a task would make it workable, but no. Queries application.tree (Records=6917, Time=Cached Query) SQL = SELECTChild.Category_ID, Child.Category_Name, Count(Child.StartBranch) AS lvl, Child.StartBranch, Child.EndBranch FROM category_tree AS Parent, category_tree AS Child WHERE Child.StartBranch BETWEEN Parent.StartBranch AND Parent.EndBranch GROUP BY Child.StartBranch, Child.Category_ID, Child.Category_Name, Child.EndBranch ORDER BY Child.StartBranch ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit cfform without submit button
Tell your boss I think he's an idiot. That such a usability no-no. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:07 PM To: CF-Talk Subject: submit cfform without submit button Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JDBC Type2 to DB2 UDB OS/390
I successfully established a JDBC Type4 connection to DB2 UDB OS/390 using the driver supplied with CFMX. Now I'm trying to set up a JDBC Type2 connection. I added the class path for the JDBC driver files in CFMX Admin. I selected 'Other' from the Driver drop down list in the Add New Data Source box in CFMX Administrator. I entered the JDBC URL, the Driver Class, the Username and the Password following the example of other (non-CF) connections, but I keep getting a 'String index out of range: -1' JDBC error when I try to verify the connection. Can anyone confirm that I am at least on the right track with my approach? Am I correct in selecting 'Other' from the driver drop down list (since selecting DB2 Universal Database gets me the CFMX Type4 driver)? Does the 'String index out of range: -1' JDBC error raise any particular flags? Thanks! George [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit cfform without submit button
I strongly agree, I have made that point, and he didn't think it was a big deal, but we'll see what he says now that I have it working. I am sure he will change his mind. Jeremy -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:33 PM To: CF-Talk Subject: RE: submit cfform without submit button Tell your boss I think he's an idiot. That such a usability no-no. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:07 PM To: CF-Talk Subject: submit cfform without submit button Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BlueDragon J2EE on OSX - Working !!!
Besides all that, I've often felt that I'd rather have people steal my software than pay for my competitors. ;-) Even stolen software is free advertising. :) s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JDBC Type2 to DB2 UDB OS/390
I successfully established a JDBC Type4 connection to DB2 UDB OS/390 using the driver supplied with CFMX. Now I'm trying to set up a JDBC Type2 connection. I added the class path for the JDBC driver files in CFMX Admin. I selected 'Other' from the Driver drop down list in the Add New Data Source box in CFMX Administrator. I entered the JDBC URL, the Driver Class, the Username and the Password following the example of other (non-CF) connections, but I keep getting a 'String index out of range: -1' JDBC error when I try to verify the connection. I don't have anything helpful to offer, so pardon me in advance for asking, but why would you want to use a Type 2 driver if you have a working Type 4 driver? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JDBC Type2 to DB2 UDB OS/390
Earl, George wrote: I successfully established a JDBC Type4 connection to DB2 UDB OS/390 using the driver supplied with CFMX. Now I'm trying to set up a JDBC Type2 connection. I added the class path for the JDBC driver files in CFMX Admin. I selected 'Other' from the Driver drop down list in the Add New Data Source box in CFMX Administrator. I entered the JDBC URL, the Driver Class, the Username and the Password following the example of other (non-CF) connections, but I keep getting a 'String index out of range: -1' JDBC error when I try to verify the connection. Can anyone confirm that I am at least on the right track with my approach? Yes. Am I correct in selecting 'Other' from the driver drop down list (since selecting DB2 Universal Database gets me the CFMX Type4 driver)? Does the 'String index out of range: -1' JDBC error raise any particular flags? I have seen it a few times with CF MX and charset bugs, but not with JDBC. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf and exchange
Luis and webguy, I would like to stick with Cf if possible to do this. But I'm not even sure if it is at our company, do you know what service needs to be running on exchange for cfpop to work thanks, seth -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 8:37 AM To: CF-Talk Subject: RE: cf and exchange I use cfpop and cfmail with our exchange server. I haven't had any trouble with them. Luis -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 5:09 PM To: CF-Talk Subject: cf and exchange Anyone ever use CF to read mail off an exchange server? I saw this tag, CFX_mIMAP has anyone used it or something else? tia, seth This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf and exchange
I would like to stick with Cf if possible to do this. But I'm not even sure if it is at our company, do you know what service needs to be running on exchange for cfpop to work Just connect to the Exchange server with any POP3 client, and see if that works. If it does, you should be able to use CFPOP. You could even write a test CFPOP script to find out. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit cfform without submit button
So many times ... clients or bosses have asked me for things that I knew was wrong, but I've given it to them ... and then ... they don't like it. Sometimes battles are won by not fighting them. H. -Original Message- From: Jeremy Bunton [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 12:43 PM To: CF-Talk Subject: RE: submit cfform without submit button I strongly agree, I have made that point, and he didn't think it was a big deal, but we'll see what he says now that I have it working. I am sure he will change his mind. Jeremy -Original Message- From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:33 PM To: CF-Talk Subject: RE: submit cfform without submit button Tell your boss I think he's an idiot. That such a usability no-no. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 3:07 PM To: CF-Talk Subject: submit cfform without submit button Hello all, I know this isn't strictly a CF issue but I am using CF at the momeny so here we go. I have a simple form with two text fields one for username and one for password. Here is the code. cfform action=checkin.cfm method=post enctype=multipart/form-data cfinput class=copy required=yes style=width:140px; name=userjay type=text size=14 maxlength=50 message=Username is Required cfinput class=copy required=yes style=width:140px; name=passwordjay type=password size=14 maxlength=50 message=Username is Required input type=submit value=nbsp;Enternbsp; class=copy /cfform My boss wants there to NOT be a submit button showing on the screen, i.e. he just wants people to type in their username and password and then hit enter to login. How would I go about this. I thought of just hiding the submit in a div but that didn't do it. It needs to work in NN4.7 up and IE 5 up. Any help would be good. Jeremy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: style sheet weirdness
Try removing the semicolons from the last properites in each of your
classes. For instance:
.Normal_Text_Black
{
font-family: Verdana, Geneva, Arial;
font-size: 12px;
color: 00
}
(No semicolon after color.)
Christian
On Thursday, January 9, 2003, at 01:50 PM, Bryan Stevenson wrote:
Hi All,
I've got a stylesheet with a bunch of text related elements in it. No
matter
which text element I place first in the list of elements, it will be
ignored.
For example:
STYLE TYPE=text/css
/* TEXT */
.Normal_Text_Black
{
font-family : Verdana, Geneva, Arial;
font-size : 12px;
color : 00;
}
.Bold_Normal_Text_Black
{
font-family : Verdana, Geneva, Arial;
font-size : 12px;
font-weight : bold;
color : 00;
}
/STYLE
The Normal_Text_Black element will display as normal 12 point Times New
Roman text. If I move it down and replace it with the
Bold_Normal_Text_Black element, then all text using that element will
display as normal 12 point Times New Roman text!! This happens for ANY
elemnt I place at the top of the stylesheet.
Does anybody know what might be going on here?
Thanks
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
transactions and multiple datasources
According to Mastering ColdFusion 5: Within a transaction block, you can write queries to more than one database; however, you must commit or rollback the transaction to one database before writing a query to another database. Not what you want to hear I'm sure, but sounds like it can't be done the way you want. As a possible wordaround (this is just a shot in the dark and might not be possible), maybe either setting some variable on success of the first query and using a cfif to decide whether to do the second one, or using cftry/cfcatch, or a combination of the 2? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX App Server Error
Okay, this is getting really frustrating. Whenever I start my machine, the CFMX App Server service is terminating with a 'service-specific error 2'. Sometimes if I do a restart on my machine I can get it to start and work - other times, no joy. I have uninstalled CFMX and reinstalled it. I have uninstalled it, IIS, everything that touches IIS, and reinstalled it all. I still get the error. This is only happening on one box - if I load off of the same CD onto another box, it works fine. Any ideas? Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfc best practice questions
OK, I just upgraded to CFMX and I am trying to figure out the best way to handle a form. Usually, in an admin area, I have an action page that handles the add/update/delete for data in a table. This is the action page for the add update form. As an example I may have 3 pages: view records,edit/add records, action (this has all the queries and other business code). If I want to use the CFC model will I now need 4 pages? view,add/edit/action, and the cfc? Will the action page still be the action for the forms but will use the cfc for all business code and queries? Thanks in advance, BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED Re: OT: style sheet weirdness
OK...the issue was the use of underscores in the style element
names...Netscape doesn't like it (at least ver. 4.07)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 2:25 PM
Subject: Re: OT: style sheet weirdness
Well Billy Bob...that's Shaw for yaTelus ADSL for me ;-)
Does anyone know why a style sheet would be completely ignored in Netscape
4.07?
I'm using this to include the sheet:
head
titleGeneric CSS Examples/title
link href=generic_styles.css rel=stylesheet type=text/css
/head
and a style sheet snippet as follows (not wrapped in a STYLE tag):
.Normal_Text_Black
{
font-family: Verdana, Geneva, Arial;
font-size: 12px;
color: 00;
}
.Bold_Normal_Text_Black
{
font-family: Verdana, Geneva, Arial;
font-size: 12px;
font-weight: bold;
color: 00;
}
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 2:06 PM
Subject: Re: OT: style sheet weirdness
It's my webmail client. Keeps putting my email address as my name even
though I tell it to use my name.
I'm actually Billy Bob Thorton :)
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
Date: Thursday, January 9, 2003 3:08 pm
Subject: Re: OT: style sheet weirdness
Ahhhthat did the trick.thanks [EMAIL PROTECTED] whoever you are
(yer a
Canuck and that's good enough for me) ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 1:44 PM
Subject: Re: OT: style sheet weirdness
Is this a style sheet you're including via the link tag? If
so, then
you need to remove the style tags.
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
Date: Thursday, January 9, 2003 2:42 pm
Subject: Re: OT: style sheet weirdness
Nope...removing semi-colons did not help...but thanks ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Christian Cantrell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 1:21 PM
Subject: Re: OT: style sheet weirdness
Try removing the semicolons from the last properites in each
of your
classes. For instance:
.Normal_Text_Black
{
font-family: Verdana, Geneva, Arial;
font-size: 12px;
color: 00
}
(No semicolon after color.)
Christian
On Thursday, January 9, 2003, at 01:50 PM, Bryan Stevenson
wrote:
Hi All,
I've got a stylesheet with a bunch of text related
elements in
it. No
matter
which text element I place first in the list of elements, it
will be
ignored.
For example:
STYLE TYPE=text/css
/* TEXT */
.Normal_Text_Black
{
font-family : Verdana, Geneva, Arial;
font-size : 12px;
color : 00;
}
.Bold_Normal_Text_Black
{
font-family : Verdana, Geneva, Arial;
font-size : 12px;
font-weight : bold;
color : 00;
