RE: ColdFusion license agreement
You know what? I hadn't tried setting up a new datasource since I installed it. You're right, it doesn't work. (NT4.0 here) IO Error on server communication hmm... need to have a look around... Nick -Original Message- From: Freddy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 12:20 AM To: CF-Talk Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Message Board Threads confusion
Hi - you need to get your head around topics, threads and posts matey Topics are the top level - e.g. ColdFusion. Threads are the conversations - e.g. Writing a message board in ColdFusion Posts are the messages based around the thread - e.g. Message Board Thread confusion If you ID the topic - e.g. T1 Then ID the Thread - e.g. TH1 Then ID the Posts - e.g. P1 You can create a unique key for each post - e.g. T1Th1P1 Then you can create an mapping to each post - e.g. T1Th1P2 - is in the same topic and thread as T1Th1P1 So, in answer to your question - each person who responds to TH1 IS in the same thread, but there subject posts should be grouped by P1, P2, P3, etc... I think!!! :) J -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 23:36 To: CF-Talk Subject: Message Board Threads confusion hey guys i wanna build a message board, but am having difficulty with the concept of threads. Let's say there is a message, and 10 people respond to that same message. Are those ten people in the same thread? or not? But let's say that person B replied a message From person A, then person C replied to person B, then D to C, and so on. Is that considered a thread? What if person X Y and J responding individually to person C's message. does that mean A,C,B,X,Y, and J are all in the same thread? confusing!!! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER Usage Question
It's a small record set. As long as the queries are designed properly and it's indexed you'll be fine with a shared SQL Server - unless you mean *really* intensive. The size of the database isn't really as significant as the number of concurrent accesses. Nick -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:56 PM To: CF-Talk Subject: SQL SERVER Usage Question I have a client who's new site will have a 20,000 record song catalog. The site is search intensive. Is this a small record set? Should I consider a dedicated SQl Server or can I use a shared SQL server without a huge impact on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual 550 processor with RAID 1. Thanks for the advise, I realize the question is a little vague. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Repeated emails - OT thread
I seem to be getting Billy Cravens message repeatedly about OT posts, I've got about ten so faris there something going on here?! Kath Katherine Maltby Web Production Director -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
Is there a possible and simple way to do this - or is it a nightmare to do? Will As far as I can remember, this is not possible to do. Oh sure, you can create a pop-up that turns off arrows and toolbars and things like that, but even then the context (right-click) menu has a Back command. Also, to add another wrench, the backspace key is aliased to the back command with some browsers. Whenever I've had clients ask for this functionality it seems there is some form of confusion in the use of the application. You might try figuring out *why* they want to disable the back button and fix that problem. HTH Hatton Humphrey ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
XML via HTTP, and PROXY Server?
Hi, I am using the following to open an HTTP session so that I can send/recieve XML to a server on the Internet. I am on a company LAN, and I have to use Proxy settings in browser to get out to the internet. How do tell the following code to use a Proxy setting when making a connection? cfscript xmlHttp.open(POST, http://server/mycgi.cgi;, false, username, password); xmlHttp.send(xmlDoc); res = xmlHttp.responseText; /cfscript Other Info: WinNT Server 4.0, CF 4.5 Thanks, Carl ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: help with moving from access to sql server
thats certainly possible... but is it a good idea?? I'd have thought the overhead concerned with storing 4bits (tinyint) rather than 1 bit for each boolean field would be less than running the convert/cast function against each value returned by the query... I may be wrong though - have not run any empirical tests - and would be interested to hear others thoughts/knowledge... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 19:36 To: CF-Talk Subject: RE: help with moving from access to sql server Can't you just use a Convert statement in your SELECT and GROUP BY clause for the Bit fields? For example SELECT sum(line.total) as OrderTotal, Convert(Char(1), order.Sent) as Shipped, order.ShipDate, order.ordernum from line, order where line.order_id = order.order_id AND order.sent = 1 AND order.customer_id = #customerid# group by Convert(Char(1), order.Sent), order.ShipDate, order.ordernum I've done this several times on SQL Server platforms and it works with no problem. Hatton Humphrey -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 1:36 PM To: CF-Talk Subject: RE: help with moving from access to sql server BIT is the correct type to use for a boolean value, but you must think about it first since BIT typed columns cannot be included in a GROUP BY clauses. TINYINT is the one to use for boolean values if you need to group by a column. Bryan Love ACP Internet Application Developer Telecommunication Systems Inc. [EMAIL PROTECTED] -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 7:41 AM To: CF-Talk Subject: help with moving from access to sql server Could anybody help me with the following error regarding datatypes that I am getting having just moved my database from Access to SQL Server 7. I am receiving the following error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot group by a bit column. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (21:1) to (21:53). I realise that this is caused by trying to group according to the bit datatype. However when I remove the grouping for this it gives an error saying that I need to group. This is the query I am using. Can anybody suggest a way of getting around this. cfquery name=gethdrs datasource=#Variables.DSN# SELECT DISTINCT Programme_Hdr.Business_Unit, Programme_Hdr.Programme_Name, Programme_Hdr.Region, Programme_Hdr.Programme_ID, Programme_Details.Year, Programme_Details.Quarter, Programme_Details.Quarter_ID, Programme_Details.Locked, Programme_details.Prog_Status, Programme_Details.ILX, Programme_Details.Executive, Programme_Details.BSS, Programme_Details.Prog_result FROM Programme_Hdr, Programme_Details, Business_Units2 WHERE Programme_Hdr.Programme_ID Programme_Details.Programme_ID cfif form.Programme_Name NEQ ALL AND Programme_Name = '#Form.Programme_Name#' /cfif cfif form.year NEQ ALL AND Programme_Details.Year = '#Form.Year#' /cfif cfif form.quarter NEQ ALL AND Programme_Details.Quarter = '#Form.Quarter#' /cfif cfif form.Business_unit NEQ ALL AND Programme_Hdr.Business_Unit = '#form.Business_Unit#' /CFIF cfif listcontains(session.access,'5') AND NOT listcontains(session.access,'1') AND NOT listcontains(session.access,'4') AND Programme_Details.Executive = 1 OR (PROGRAMME_DETAILS.ILX=1 AND PROG_Status IN('CURRENT,COMPLETED')) /cfif cfif listcontains(session.access,'3') AND NOT listcontains(session.access,'1') AND NOT listcontains(session.access,'4') AND (PROGRAMME_DETAILS.BSS=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND Programme_Details.BSS = 0)) /cfif cfif listcontains(session.access,'2') AND NOT listcontains(session.access,'1') AND NOT listcontains(session.access,'4') AND (PROGRAMME_DETAILS.ILX=1 OR (Programme_Hdr.Business_unit '#session.b_unit#' AND Programme_Details.ILX = 0)) /cfif cfif NOT listcontains(session.access, '1') AND NOT listcontains(session.access, '2') AND NOT listcontains(session.access, '5') AND Business_Units2.bss_Name = '#session.bss#' AND Programme_Hdr.Business_Unit = Business_Units2.bu_name /cfif cfif listcontains(session.access, '4') AND NOT listcontains(session.access, '5') AND Programme_Hdr.Business_Unit = '#session.b_unit#' /cfif AND Programme_Details.archived = 0 Group By Programme_Details.Quarter_ID, Programme_Hdr.Business_Unit, Programme_Hdr.Programme_Name, Programme_Hdr.Region, Programme_Hdr.Programme_ID, Programme_Details.Year, Programme_Details.Quarter, Programme_Details.Locked, Programme_Details.Prog_Status, Programme_Details.ILX, Programme_Details.BSS, Programme_Details.Executive, Programme_Details.Prog_result cfif not parameterexists(url.orderby)
RE: Disabling back button
I remember some time ago seeing a script (I think it was at www.javascript.com ) that replaced the history of the back button with the current page. This essentialy disables the back button. And if my memory serves me correctly, it was just a little snippet of code. Mark -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:51 PM To: CF-Talk Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Community?
I don't know where you're located at but I assume most of the people that post are within the U.S. And judging from the time of your post, it's safe to say that most people are sleeping at 3:30AM :-) Yesterday seemed to be a slow day, but generally, there are quite a few posts there. Mark -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:06 PM To: CF-Talk Subject: OT: CF-Community? I just subscribed to CF-Community, thinking that I would ask a question over there because of the rash of OT postings here lately, and I haven't seen a single message thread come in yet. Is CF-Community up, or does it not have as much traffic as I was led to believe? Thanks! Hatton Humphrey ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER Usage Question
20K is small. We have one SQL Server (2k) with about 10 extranet apps on it. One of our apps in particular is associated with hundreds of thousands of records (about 500,000) - That's still small. I think as long as you have done proper maintenance (indexing, relational, etc.) you should be fine. Mark -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 2:56 PM To: CF-Talk Subject: SQL SERVER Usage Question I have a client who's new site will have a 20,000 record song catalog. The site is search intensive. Is this a small record set? Should I consider a dedicated SQl Server or can I use a shared SQL server without a huge impact on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual 550 processor with RAID 1. Thanks for the advise, I realize the question is a little vague. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Browser client for upload files?
I use something like this: form name=uploadform action=index.cfm enctype=multipart/form-data method=post table tr tdinput type=File name=filename size=60 value=/td tdinput type=submit value=Submit/td /tr /table /form Mark -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 12:49 PM To: CF-Talk Subject: Browser client for upload files? Alright, the client needs to upload a PDF file. How do I let the user browse their machine for the file to upload? I'd like to use CFTREE, right? I'm fuddled. Willy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Certification
Anyone with any advice for the CF Certified Developer exam? Thanks in Advance Jerry Staple Web Application Developer http://www.biznetprojects.co.uk/complogo.gif Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] W http://www.biznet-solutions.com/ biznet-solutions.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Training Recommendations
About a year and a half ago, I took the official Microsoft course, Implementing a Database With SQL Server 7.0 and found that course to be very helpful. The course covers everything you mentioned below. You'll have to check around your area to see if there are any Microsoft training sites near you. I can't remember how much it cost, but it was about 3 or 4 days long. I know Oracle has some courses as well. Mark -Original Message- From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 6:04 PM To: CF-Talk Subject: SOT: Training Recommendations Hi All - I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Message Board Threads confusion
If you take the message structure as a tree, a thread is the path from one message to one of its parents (father,grand father etc). Taken the other way, its all the childen (and their children) of a specifc post. Weather you allow subject changes to mean a new thread starts or not is a design question :-) ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Browser client for upload files?
You have to set up two things. First you need a form page that has two things: 1. The form tag needs to have method=post and enctype=multipart/form-data. This tells the browser to send the file back to the server correctly. 2. In your form you need an input type=file... tag. This tag will put in a text box and a browse button that will let your visitor select the file. On your action page you'll need to make use of the cffile tag to copy the uploaded file into a destination directory. If you've never done this before, there are some good examples in the various Forta books. I have the CF Web App Construction Kit 4.0 and it's chapter 28 (Working with Files and Directories) for me. Good luck! Hatton Humphrey -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 12:49 PM To: CF-Talk Subject: Browser client for upload files? Alright, the client needs to upload a PDF file. How do I let the user browse their machine for the file to upload? I'd like to use CFTREE, right? I'm fuddled. Willy ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-Community?
Someone posted to ask if anyone was there and the machine crashed. I have to change the secret crash password now. :) I just subscribed to CF-Community, thinking that I would ask a question over there because of the rash of OT postings here lately, and I haven't seen a single message thread come in yet. Is CF-Community up, or does it not have as much traffic as I was led to believe? Thanks! Hatton Humphrey ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfquery Question
I'm probably being a dunce here but does anyone know a sql query that will list out all the tables in a particular sql7 database...? Thanks in advance... -= Ed ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL SERVER Usage Question
At 11:56 AM 09/05/2001 -0700, you wrote: I have a client who's new site will have a 20,000 record song catalog. One of the sites I work on has a song search catalog that is twice that size. ( www.karaokewh.com ) I think the db is SQL Server 2000, however we have never had any problems searching against it. ( click the song search link from the left navigation bar ) The site is search intensive. Is this a small record set? Should I consider a dedicated SQl Server or can I use a shared SQL server without a huge impact on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual 550 processor with RAID 1. I think it all comes down to your data structure and the queries. You should be fine on a shared SQL Server as long as that server is not overloaded already, and as long as you develop smart. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- I'm looking for a room-mate in the Hartford CT area, starting in September -- http://www.instantcoldfusion.com | My Book: Instant ColdFusion 5.0 -- My Band: Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- My company: DotComIt, LLC database driven web data using ColdFusion -- I tried all my tricks, I tried to steal a kiss... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Browser client for upload files?
on submitting page... (make sure to include the enctype) FORM ACTION=action.cfm METHOD=Post name=product ENCTYPE=multipart/form-data input type=file name=image /form on the action page cfset path=GetDirectoryFromPath(GetTemplatePath()) cfset path=path 'pdfs\' CFFILE ACTION=Upload FILEFIELD=Form.image DESTINATION=#path# NAMECONFLICT=MakeUnique -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 11:49 AM To: CF-Talk Subject: Browser client for upload files? Alright, the client needs to upload a PDF file. How do I let the user browse their machine for the file to upload? I'd like to use CFTREE, right? I'm fuddled. Willy ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Excel as a datasource .... ?
try caching the tables so the time to pull off the queries goes down dramatically. -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:15 AM To: CF-Talk Subject: RE: Excel as a datasource ? I agree. Down the road it's going to be a nightmare especially if you have server issues now. Sure for a month or two it would be ok but as that excel file gets bigger and bigger you will run into trouble. Excel and Access are just not meant for high traffic web sites. We don't charge people more to use access but we make them keep the file below 20MB in size and we do not allow Excel datasources. There is a small memory leak in Access that can cause long term problems. I've never used Excel myself as a datasource but I can only assume you would get the same results. IMHO, Access and Excel are good for desktop apps only. I mean, I could eat of off a frisbee instead of a plate and it would work but that doesn't mean I should do it. Just my $0.02 Dan Phillips CFXHosting.com -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:04 AM To: CF-Talk Subject: Re: Excel as a datasource ? excel as a datasource would make maintainability, scalability, and enhancements alot harder and in the long run cost more. Actually, at one place I worked at we charged more if the client wanted to use Access over SQLServer (I assume excel as a datasource would cost even more). On Wed, 5 Sep 2001, Mike Kear wrote: I have a client who's complaining that the time spent generating a small app using SQL is costing too much and wants to use excel spreadsheets instead. What's your experience using excel as a datasource? Just to clarify what the projects do, they don't write to the datasource, just look up and filter the data customising tables for the user's needs. The volumes aren't great - between a few hundred page views a month to 5000 or so. IS there likely to be implications for the usage of RAM and resources on the server? The System Admin is already complaining that he has to restart the server too often and when the processor usage gets to 100% he panics and complains. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: putting values from an array into cfgraph? - double post
Thanks Don -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 15:49 To: CF-Talk Subject: Re: putting values from an array into cfgraph? - double post piping up I posted this link some time ago http://www.vawter.com/display_popular.cfm but it pulls results from a query not an array. Using the cfgraphdata tag is the way to go for an array. Ben Forta has an article on this in the July CFDJ /piping up HTH Don Don Vawter www.cyberroomies.com [EMAIL PROTECTED] - Original Message - From: Ann Harrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 5:34 AM Subject: RE: putting values from an array into cfgraph? - double post I saw a guy doing something similar counting .gifs viewed but don't remember the link. Perhaps he will pipe up later in the day. Ann -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 5:50 AM To: CF-Talk Subject: putting values from an array into cfgraph? - double post Hi guys I have a two dimensional array that holds the name of a file, and the number of times it has been downloaded: [A test file][2] [Another test file][11] and so on. What I want to do is take the values from this array, and place them into a bar chart using cfgraph. Is this possible, and can anyone indicate how I might go about doing this? Cheers Will Swain ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK and Session variables
IMHO, I think session, application, server variables should be banished to the depths of hell. I recently wrote an application using just the client, variables, request and caller scopes. Gawd, talk about making life easier! Other than not allowing complex data types in client variables, I would say the pros of client vars far outweighs the cons. --- Tilbrook, Peter [EMAIL PROTECTED] wrote: CFLOCK is very important. ColdFusion is a multi-threaded application. Not locking writes to these variables could result in variable (memory) corruption. You should get into the habit of using CFLock even when simply outputting a applicatio, session variable. Ben Forta's excellent CF5WACK book - http://www.forta.com/books/0789725843/ explains locking in fine detail. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 2:45 To: CF-Talk Subject: CFLOCK and Session variables A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Checking for NULL
cfif trim(qQuery.field) eq blah /cfif Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:48 AM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? cfif qQuery.field is NULL ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Excel as a datasource .... ?
I agree with Dan, look at this; http://allaire.com/Handlers/index.cfm?ID=1540Method=Full http://support.microsoft.com/support/kb/articles/q174/4/96.asp CFGirl From: Dan Phillips [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Excel as a datasource ? Date: Wed, 05 Sep 2001 11:15:13 -0400 I agree. Down the road it's going to be a nightmare especially if you have server issues now. Sure for a month or two it would be ok but as that excel file gets bigger and bigger you will run into trouble. Excel and Access are just not meant for high traffic web sites. We don't charge people more to use access but we make them keep the file below 20MB in size and we do not allow Excel datasources. There is a small memory leak in Access that can cause long term problems. I've never used Excel myself as a datasource but I can only assume you would get the same results. IMHO, Access and Excel are good for desktop apps only. I mean, I could eat of off a frisbee instead of a plate and it would work but that doesn't mean I should do it. Just my $0.02 Dan Phillips CFXHosting.com -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:04 AM To: CF-Talk Subject: Re: Excel as a datasource ? excel as a datasource would make maintainability, scalability, and enhancements alot harder and in the long run cost more. Actually, at one place I worked at we charged more if the client wanted to use Access over SQLServer (I assume excel as a datasource would cost even more). On Wed, 5 Sep 2001, Mike Kear wrote: I have a client who's complaining that the time spent generating a small app using SQL is costing too much and wants to use excel spreadsheets instead. What's your experience using excel as a datasource? Just to clarify what the projects do, they don't write to the datasource, just look up and filter the data customising tables for the user's needs. The volumes aren't great - between a few hundred page views a month to 5000 or so. IS there likely to be implications for the usage of RAM and resources on the server? The System Admin is already complaining that he has to restart the server too often and when the processor usage gets to 100% he panics and complains. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RDS Disabling?!
I have people trying to RDS into servers when the service is disabled. It looks like it is causing problems on my server as sessions aren't lasting but 20 seconds. I think the server is restarting thus killing the sessions. Is there a way to block RDS requests? This looks like a brute force DOS. Neil ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slightly OT, MSword--wddx--cf
I have developed a way of loading files from MS Word 2000 with one click directly into a CF website. For more info see http://www.flymicro.com/cf/directload If you know about VBA, or perhaps know someone (or somewhere) who could help me then please read further. Otherwise delete! DirectLoad works excellently with the body text, but I am having trouble with associated images. My problem is a VBA one, not CF, and involves reading whole binary files (eg .jpg or .gif) into a variable which can then be serialized and sent to the server. As far as I can see, (my documentation is not very enlightening in this area) this is supposed to be the VBA code, but it doesn't work Dim imgbinary 'open the file Open C:\mydocs\img1.jpg For Binary As #1 'read the file into the var imgbinary Get #1, , imgbinary 'load the var into the structure mystruct I created earlier, 'mystruct contains all the data which is serialized 'sent to the server so it works OK in principle mystruct.setprop theimgfile, imgbinary 'tidy up Close #1 The error is on the Get.. line: 458, Variable uses an automation type not available in visual basic Anyone any ideas?? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPop problems!
1) In CF 3.1 there used to be a problem with deleting email No.1 (especially if it had an attachment). I don't know if this has been fixed in more recent versions of CF, but in any case I always pre-load the mailbox with a dummy No. 1 and then manipulate all mails from no 2 onwards. 2) There is no need to loop through deletes in this way... CFPOP accepts a list of index numbers to delete. Tony Hicks wrote: Allaire had a demo site that shipped with 4.5 called Crazycab it was a way to check emails from their site.. it was even on crazycab.com for a while.. Here's what I noticed.. on my computer and my host's server it would check every email address I had accept for my host's*.. And on an old host and a few friend's machines, it worked with all pop accounts.. I never did find the solution. * It worked on every machine if there were no messages in the email box I was checking and only errored if there was an email message... Thanks Tony Hicks -- Search the Holy Bible: http://www.bibleclicks.com - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 2:05 PM Subject: CFPop problems! I have a program, it will getall from a pop server and then loop through the query that is returned. I will then at the end of each iteration within the loop delete messagenumber 1 since this always the first message. I continue to get no such message errors. Sometimes it works perfectly, but other times it doesn't. I don't like CFPOP since it seems to be sketchy. If you have any other suggestions please let me know. With Imail I can write a bat that writes a file and then have the server pole the directory and parse the file and then delete it but that seems more cumbersome (not for me, I could write it :) ) but for the server? Any insight? Thanks, Neil ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFPop problems!
Allaire had a demo site that shipped with 4.5 called Crazycab it was a way to check emails from their site.. it was even on crazycab.com for a while.. Here's what I noticed.. on my computer and my host's server it would check every email address I had accept for my host's*.. And on an old host and a few friend's machines, it worked with all pop accounts.. I never did find the solution. * It worked on every machine if there were no messages in the email box I was checking and only errored if there was an email message... Thanks Tony Hicks -- Search the Holy Bible: http://www.bibleclicks.com - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 2:05 PM Subject: CFPop problems! I have a program, it will getall from a pop server and then loop through the query that is returned. I will then at the end of each iteration within the loop delete messagenumber 1 since this always the first message. I continue to get no such message errors. Sometimes it works perfectly, but other times it doesn't. I don't like CFPOP since it seems to be sketchy. If you have any other suggestions please let me know. With Imail I can write a bat that writes a file and then have the server pole the directory and parse the file and then delete it but that seems more cumbersome (not for me, I could write it :) ) but for the server? Any insight? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK and Session variables
2 reasons: 1/ if the user has multiple windows open 2/ If the user hits stop before a page finishes executing and executes another page.. Locking when reading prevents a variable being written when it is being read and visa versa -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 17:45 To: CF-Talk Subject: CFLOCK and Session variables A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Training Recommendations
Hi Jay, I took a class called Implementing a Database on MS SQL 7.0 with Productivity Point Intl (www.propoint.com). It covered everything you're looking for, and you get to keep the lesson binder. It does not related back to ColdFusion, but I think it's important to learn the ins and outs of SQL and Enterprise Manager apart from ColdFusion as well, since it's usually most efficient to do as much of the database work as possible via views and stored procedures rather than in the ColdFusion code. Marianne Daye Programmer/Analyst Information Delivery Systems (IDS) http://ids.rti.org (919) 541-8031 -Original Message- From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 6:04 PM To: CF-Talk Subject: SOT: Training Recommendations Hi All - I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and MS Word Docs
Apart from using Dreamweaver 4's Clean up word document feature not sure. On a previous project (http://tradewatch.dfat.gov.au) I used a CFX tag called CFX_Doc2HTML with moderate success. It is impossible to find the tag or the tags author now however. I imagine a similar CFX could perhaps engage the DREAMWEAVER.EXE or whatever do the same thing. A bit beyond my budget or expertise however. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 September 2001 1:45 To: CF-Talk Subject: CF and MS Word Docs Hi all, Does anyone know of a way to save a documtn in word to HTML format without all the ridiculous XML formatting!!! When I include the saved html doc in my cf application the formatting looks horrible. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Repeated emails - OT thread
Legend! Have you given any consideration to selling the code you use (or is it dependant on third party software, eg: iMS?). There was a machine problem that I've since fixed. One of the results will be a repeat post or two to a few people. On the plus side, I just rewrote the 'cleaner' and bridge portion of the list software for more speed and cleaner operation. ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
As far as I can remember, this is not possible to do. Oh sure, you can create a pop-up that turns off arrows and toolbars and things like that, but even then the context (right-click) menu has a Back command. Also, to add another wrench, the backspace key is aliased to the back command with some browsers. Whenever I've had clients ask for this functionality it seems there is some form of confusion in the use of the application. You might try figuring out *why* they want to disable the back button and fix that problem. Hatton, the right click is certainly possible. I can provide the code if required. I also am interested in disabling the back button so if anyone has any ideas let them flow. Cheers! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
NSOT: Att Master Dinowitz
Michael, are we all receiving copies of messages over and over again? It appears that I am at the moment. Cheers! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Certification
By Ben Forta's (et al) excellent book - Certified Allaire ColdFusion Developer Study Guide. A thin tome for $100 (AUD) but still a handy reference. Check out http://www.forta.com for details and even try the test out for yourself. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 22:33 To: CF-Talk Subject: CF Certification Anyone with any advice for the CF Certified Developer exam? Thanks in Advance Jerry Staple Web Application Developer http://www.biznetprojects.co.uk/complogo.gif Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] W http://www.biznet-solutions.com/ biznet-solutions.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQUERY dynamic connection using OLE DB
I can see that CF 5.0 CFQUERY attribute ConnectString supports ODBC connection strings, but it does not seem to work with OLEDB. Is there a trick to making it work, or is this a design stuff up? If you have made it go using MS Access and or SQL server, please post a sample of your code! - PWM Hell, there are no rules here - we're trying to accomplish something! Thomas A. Edison ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Certification
I found that the stufy guide book is very very helpful! Used the study guide book along with the CF 5.0 book and go through the study guide book until you understand it from front to back and back to front...and yur set :-) -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 8:33 AM To: CF-Talk Subject: CF Certification Anyone with any advice for the CF Certified Developer exam? Thanks in Advance Jerry Staple Web Application Developer http://www.biznetprojects.co.uk/complogo.gif Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] W http://www.biznet-solutions.com/ biznet-solutions.com ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Username/password attribs on CFQUERY
Has anyone got any thoughts on what the implications are for using username/password attribs in the CFQUERY tag. Obviously on a shared environment do not want to be placing a username/password on the actual datasource.. Any other ways of securing datasources? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFLOCK and Session variables
A user with 2 browser windows open both on your site, or if your site has frames would be 2 situations where there could be a session var conflict. - Ben Gonzo Rock [EMAIL PROTECTED] 09/05/01 12:45PM A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Print PDF to Network Printer
I think you can do some things with acrobat using com objects. Take a look at www.cfcomet.com they have an acrobat section. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: 31 July 2001 22:42 To: CF-Talk Subject: Print PDF to Network Printer Trying to: * query database * create adobe FDF file * feed FDF file to pre-constructed PDF form * print resulting form (with field data inserted) to network printer (NOT browser). I have seem to have most of the components, but not the one that will print the resulting form. There used to be a tag available (CFX_CRWTOPDF) that might do this, but it is no longer available. Anyone know of a tag that will do the printing? TNX. Richard Colman ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
simple array help - newbie
Hello, I am trying to build an array and cannot get around this error message: The element at position 2 in dimension 1 of object aggdata.AggHours cannot be found. The object has elements in positions 1 through 1. Please, modify the index expression. This is my code for populating the array: cfset Suparray = Arraynew(2) cfloop query=QRYdetail cfset Suparray[CurrentRow][1] = QRYdetail.efirst[CurrentRow] cfset Suparray[CurrentRow][2] = QRYdetail.vSSN[CurrentRow] cfset Suparray[CurrentRow][3] = QRYdetail.TrainDate[Currentrow] cfset Suparray[CurrentRow][4] = QRYdetail.Site[CurrentRow] cfset NADAPSuparray[CurrentRow][5] = QRYdetail.units[CurrentRow] cfset Suparray[CurrentRow][6] = QRYdetail.sFirst[CurrentRow] cfquery name=aggdata datasource=#request.DB# Select ISNULL(Sum(nc.nNumHrs), 0) as AggHours From HospitalLog nc Where cHospitalCodeID =498 and nc.iEmpID = '#QRYnc.iEmpID#' and nc.dDate= '#variables.Fiscal#' and nc.dDate = '#QRYnc.TrainDate#' Group by nc.iEmpID, nc.dDate Order By nc.iEmpID, nc.dDate /cfquery cfset Suparray[CurrentRow][7] = aggdata.AggHours[CurrentRow] /cfloop I am thinking it may have to do with the fact that each iEmpID appears in the HospitalLog table more than once or maybe it has nothing to do with thatam new to arrays and am at a loss as to how to fix this Any ideas? Thanks again for your help!!! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion license agreement
Works here fine, never did anything to it but a normal install first time. I assume you mean through CF Admin? Regards, Andrew Scott -Original Message- From: Freddy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 9:20 AM To: CF-Talk Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with re-direct to other site.
All, We are in the process of trying to bring a website currently hosted externally in-house. As part of the process, I removed all hard-coded references to the URL in the code and set up a web server. Instead of using the DNS, I am testing using IP:port. In my development environment, it appears that any reference to the root directory of the web goes to production. For example, a link that references /index.htm will not go to http://1.1.1.1:80/index.htm. Instead, it will go to http://www.production-site.com/index.htm. This makes it impossible to test. I took a quick look at the both the Netscape and the Cold Fusion administration applications, but don't see any settings that would control the root being something other than the server itself. Does anyone have an idea where to look? I already reviewed all of the code, and there are no references to the other address in the code. HELP!!! Thanks in advance, - Steven Monaghan Oracle DBA MSC Industrial Direct Co., Inc. Melville, NY [EMAIL PROTECTED] http://www.mscdirect.com - This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
There is really no way to directly disable the back button. There are workarounds though that can be implemented. Some methods are better than others because some methods can be defeated by backing via right clicking. The better way is to submit your form through a pop-up window. Pop-ups are not added to the history. Lonny Eckert Mi Services Group [EMAIL PROTECTED] (610) 230-2500 x147 -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:51 PM To: CF-Talk Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OLE-DB Client Storage Problem
Well, according to the Advanced ColdFusion Administration documentation for CF 5, the problem with OLE DB is probably related to my Win98 development environment. Apparently, OLE DB is only available on Win NT/2000. (Oddly enough, I didn't notice a problem until I tried using it for client variable storage.) Seems CFGRAPH isn't supported in Win98 either. Time to add to my Reasons to Upgrade to Win2K list. (I see ya chuckling, Bill...) - Original Message - From: Matt Robertson To: CF-Talk Sent: Wednesday, September 05, 2001 6:29 PM Subject: RE: OLE-DB Client Storage Problem Back when I was messing with Access, I tried and eventually gave up trying to use OLEDB-connected client var storage. Access ODBC is still better than the registry, I think. As for sites, depending on your file spec OLEDB either works fine or not at all. I still have one site running on an Access OLEDB connection. One of these days I'll move it to mySQL/Win, which I think is the best replacement for Access you can get without springing for a real rdbms. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- from: Jay Sudowski - Handy Networks LLC I don't believe that many folks use OLEDB at all. I tried setting up an OLEDB DSN for my client variables to SQL Server, and that process failed. From: Dina Hess [mailto:[EMAIL PROTECTED]] Is there anyone on this list who actually uses MS Access (or any other db for that matter) as an OLEDB datasource? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Exchange Servers
Is it not possible then to use COM to interact with exchange server?? I thought some of the examples on cfcomet might help?? -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 16:22 To: CF-Talk Subject: RE: CF and Exchange Servers CFComet is an excellent resource. However, I don't know that it's what he wants, since it's unlikely that they're running Outlook on the server. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:40 AM To: CF-Talk Subject: RE: CF and Exchange Servers Hi Mike, I haven't done anything with Exchange, but have a look at www.cfcomet.com which has a lot of useful info on using COM with CF. I know for example that it is possible to make entries Outlook tasks etc. Hope thats some help Cheers Will -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 15:32 To: CF-Talk Subject: CF and Exchange Servers HI everyone. I am an intermediate CF developer in college. At work (school web team) I was asked to look into setting up an intranet, but the uppers want to pull stuff from an exhcange server (schedules, appointments, calendar info) for use in the intranet. Is there anyway to use CF to pull Data from an exchange server and possibly update it and send it back to the server ... all using CF. I would appreciate any insight anyone could offer. Thanks everyone. Mike Tangorre --Alfred University Student-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Exchange Servers
Study... Ben Forta also has a book on the subject - http://www.forta.com/books/0789725657/ Mark -Original Message- From: Josh Remus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:36 AM To: CF-Talk Subject: RE: CF and Exchange Servers I've done things with pulling items (calendars, appointments, etc.) from Outlook, it may very well be possible from Exchange directly, though I haven't tried that. I used COM objects to pull change this stuff. Check out www.cfcomet.com and look under Outlook for that info. Perhaps someone else might be able to provide more information on Exchange in particular (we don't run exchange)... Josh -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:32 AM To: CF-Talk Subject: CF and Exchange Servers HI everyone. I am an intermediate CF developer in college. At work (school web team) I was asked to look into setting up an intranet, but the uppers want to pull stuff from an exhcange server (schedules, appointments, calendar info) for use in the intranet. Is there anyway to use CF to pull Data from an exchange server and possibly update it and send it back to the server ... all using CF. I would appreciate any insight anyone could offer. Thanks everyone. Mike Tangorre --Alfred University Student-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Tracking #: D066E37453A1D511A0E100105A0C39A4DBB7BE9C ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sending string to lpt1 on client
I remember some posts a while back about talking to devices on the client side. Someone wrote something that could be used with CF, I think it was to communicate with a scale. Anyone remember anything about this? I need to send a print string to the client LPT1 port...any recommendations? Thanks,Adrian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Message Board Threads confusion
You can either have a single-dimensioned thread (like a mailing list) or you could go infinite with your threading. Best way to manage it is in your database. Something like: Messages table -- msgText Parentid Msgid Here's some sample data: |msgID|msgText|Parentid| |-|---|| |1|test1 |0 | |-|---|| |2|test2 |1 | |-|---|| |3|test3 |2 | |-|---|| Test1 is a top level message (no parent), test2 is a reply to test1, and test3 is a reply to test2 --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 5:36 PM To: CF-Talk Subject: Message Board Threads confusion hey guys i wanna build a message board, but am having difficulty with the concept of threads. Let's say there is a message, and 10 people respond to that same message. Are those ten people in the same thread? or not? But let's say that person B replied a message From person A, then person C replied to person B, then D to C, and so on. Is that considered a thread? What if person X Y and J responding individually to person C's message. does that mean A,C,B,X,Y, and J are all in the same thread? confusing!!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calling CFCONTENT generates 2 hits?
Wow. This took almost a day to deliver! BTW, I use a personal SMTP server running in my sys tray, ArgoSoft... so there is no problem as far as relaying messages, etc. - Original Message - From: stas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 4:30 PM Subject: Re: Calling CFCONTENT generates 2 hits? Thank you. I had to put in a crude work around by moving my INSERT query to the CFCONTENT page in question and ignoring this page in my main logging module. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Training Recommendations
Bit of a misnomer: what you need has nothing to do with ColdFusion - you need advanced database training. Maybe that'll help your search. I know you want it to relate back to ColdFusion. However, change your mindset a bit - your database is separate tier, not part of ColdFusion. As such, look for dedicated database training. About the only thing that will vary by language is calling stored procedures - and that's 15 minutes and a reference on your own. Besides, there's far more database than using databases with ColdFusion training out there. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 5:04 PM To: CF-Talk Subject: SOT: Training Recommendations Hi All - I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Community?
That's what you get for using Pink Floyd lyricks. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 7:59 AM To: CF-Talk Subject: Re: CF-Community? Someone posted to ask if anyone was there and the machine crashed. I have to change the secret crash password now. :) I just subscribed to CF-Community, thinking that I would ask a question over there because of the rash of OT postings here lately, and I haven't seen a single message thread come in yet. Is CF-Community up, or does it not have as much traffic as I was led to believe? Thanks! Hatton Humphrey ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Repeating Messages
Is it just me or am I seeing a lot of repeated messages from the list? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DateDiff Problems
Has anyone run into strange problems with DateDiff function? Im getting some strange problems where only a 3 hour difference reports as 3 million minutes. 99% of the time DateDiff works, but every once and while it messes up and reports a very large number of minutes. CF 4.5.1 SP2 on Win2K MySQL server ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: .biz domains ... what are the issues?
The same could be said about any TLD. And misspellings. It's cheap, why not? However, make sure your client's aware of the process for registering BIZ (and other new TLD's) There's a whole crop of companies advertising these domains; however, paying them doesn't guarantee the domain. It only means that you get a chance at the domain once it truly opens up. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 1:14 AM To: CF-Talk Subject: OT: .biz domains ... what are the issues? Sorry if this is off-topic, but I'm interested in the views of this group who know a lot about commercial sites I have been asked by a small but international client for my view on the new .biz domain names, and to my shame I hadn't really thought about it much. So I've tried to think through all the issues involved, and would appreciate the views of this list on the matter. What do you think needs to be considered about pre-registering .biz or shop or whatever domains? Here's what I've listed so far . (1) .biz domains are global, so when you've got a name you've got it worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't. (2) If you don't pre-register your name in the .biz domain, someone else can end up taking your name. This might or might not be a problem depending on how important the .biz domains become. Do you guys think that these new domains will ultimately be as important as the .com domains? (3) If you don't pre-register your name you could find your own domain owned by an opportunist who will hold your name to ransom until you buy it from him at whatever price he wants. (4) If you have high traffic, someone else could use your name in one of these new tlds and use it to drive traffic to their site, parasitically. So you could end up with your customers being directed to a porn site or anything. And all at your cost. (4) Compared to the potential cost of having your name held to ransom or used by a competitor or even a porn site the cost of the new domains are chickenfeed. Is there anything else that needs to be taken into consideration? Cheers Mike Kear, Windsor, NSW, Australia AFP Webworks. www.afpwebworks.com ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity
Does verity index more then just the content of a word or PDF (whatever file it may be). For example, in Word you can specify properties for the document by going to File then Properties. Will verity index those properties along with the content. I would like to be able to search for word docs that have specific properties in them. Thanks for all of your help. Darren Labrum INFOVISION, INC. http://www.infovisioninc.com/ [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 2nd request: RE: CFGRAPH Formatting
The graph has to be square, if you try setting values that would make it none-square, the layout goes all odd. Increase the width/height. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: 04 September 2001 20:00 To: CF-Talk Subject: RE: 2nd request: RE: CFGRAPH Formatting Bruce, Thanks, but tried that. All that does is make the bars wider, even to the point where they overlap. The labels stay as crunched up as ever. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Bruce Sorge [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 10:19 AM To: CF-Talk Subject:Re: 2nd request: RE: CFGRAPH Formatting To separate the bars, you would want to use the BarSpacing attribute. Once you set the spacing, the labels should follow. Bruce - Original Message - From: Owens, Howard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 11:29 AM Subject: 2nd request: RE: CFGRAPH Formatting Any help please ... Trying to use CFGraph for the first time ... pretty cool, but I'm struggling with figuring out how to format things the way I want. Specifically, in my bar graph, all of my lables are overlapping. The bars are too close together. How do I get some separation there. What is the attribute? I've tried everything I can think of and nothing seems to change the spacing (in typography, we'd say leading). ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
Take a look here... http://www.halhelms.com/index.cfm?fuseaction=newsletters.mar2001 Cheers | Noel. Is there a possible and simple way to do this - or is it a nightmare to do? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
I have only found one way to do this with a modicum of simplicity. Basically its javascript. You have to open a new window and remove the standard toolbars from the window and include a code to remove right click. Then on unload of the page that opened the new window commit a self.close. I have also heard rumors that there is an easier way to do this using history=no but I have never taken the time to research its validity. Bryan Langford Analyst National Customer Operations Enterprise Services Strategic Planning Training Development and Design Team. Â -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 12:51 PM To: CF-Talk Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Training Recommendations
I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? I've got a couple of suggestions. First, Macromedia now offers an introductory SQL course called, appropriately enough, Fast Track to SQL. The course doesn't specifically have much to do with ColdFusion, but everything within the course is relevant to building CF applications. Fortunately, there's not all that much you do differently within a CF app when it comes to database design and SQL. As for the course itself, it was created by Fig Leaf Software for Macromedia. I think that it does a good job of covering the basics of SQL, and have taught the class a few times and been satisfied with the basic course materials. http://www.allaire.com/handlers/index.cfm?ID=20695method=full Second, if you want something beyond SQL, I know that Adam Churvis offers a CF class which covers SQL Server and Oracle as well. I don't know the details, but I've heard good things about his classes, and I think highly of him and his skills myself. However, this is an advanced class, so you might want to learn basic SQL stuff (things like ANSI-92 explicit JOIN syntax) first. http://www.coldfusiontraining.com/ Finally, no matter what decision you come to about taking courses, I strongly recommend that you learn as much SQL and database design theory as you can - frankly, it's more important than knowing CF, even for CF developers, in my opinion! It's essential that you learn as much as you can about this topic, if you want to be a competent database application developer. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion license agreement
Check to see if RDS is running If not, start it then try again. Dave - Original Message - From: Freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 7:20 PM Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disabling back button
check the archives. there has been extensive discussion on this and i believe a solution. :) W Luke [EMAIL PROTECTED] on 09/05/2001 02:51:08 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfquery Question
There is a SqL Server stored procedure that will describe a database for you. Off the top of my head, I can't remember the name of it but you can find it in books on line. If I can remember the name, I'll pass it along. Mark -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 8:10 AM To: CF-Talk Subject: cfquery Question I'm probably being a dunce here but does anyone know a sql query that will list out all the tables in a particular sql7 database...? Thanks in advance... -= Ed ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFHTTP to a new window.
Grab the cfhttp.filecontent, save it somewhere (persistent state variable, or into a database), then open a new window using JS (window.open()) and in that file, grab what you saved. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 11:26 PM To: CF-Talk Subject: CFHTTP to a new window. Can you run a CFHTTP that will send the file content to a new window? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Repeated emails - OT thread
There was a machine problem that I've since fixed. One of the results will be a repeat post or two to a few people. On the plus side, I just rewrote the 'cleaner' and bridge portion of the list software for more speed and cleaner operation. At 04:44 AM 9/6/01, you wrote: I seem to be getting Billy Cravens message repeatedly about OT posts, I've got about ten so faris there something going on here?! Kath Katherine Maltby Web Production Director -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
Is there a possible and simple way to do this - or is it a nightmare to do? You can do this, but it's almost always a bad idea - people expect the back button to be there, and to work a specific way. The way I typically see this done is by spawning a new browser window with no buttons at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Message Board Threads confusion
hey guys i wanna build a message board, but am having difficulty with the concept of threads. Let's say there is a message, and 10 people respond to that same message. Are those ten people in the same thread? or not? But let's say that person B replied a message From person A, then person C replied to person B, then D to C, and so on. Is that considered a thread? What if person X Y and J responding individually to person C's message. does that mean A,C,B,X,Y, and J are all in the same thread? confusing!!! A Thread on a message board is generally considered as one post, and all the responses to that post (As I understand it). I would think something along the lines of... 100 (Message number, first post in a thread) 100.1 - First reply 100.2 - Second Reply 100.2.1 - First reply to second reply 100.2.1.1 - Next sub reply 100.2.2 - Second reply to second reply 100.3 - Third reply Maybe something like that? John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Disabling back button
Hello Mak, on the preceding page you can put in history.forward() and problem solved. -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Thursday, September 06, 2001, 3:35:49 AM, you wrote: MWL is a nightmare! MWL - Original Message - MWL From: W Luke [EMAIL PROTECTED] MWL To: CF-Talk [EMAIL PROTECTED] MWL Sent: Thursday, September 06, 2001 3:51 AM MWL Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to MWL do? Will MWL ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFLOCK and Session variables
A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? Because users can open multiple browser windows in the same session or if you have a framed environment the session scope really is shared. 2. Why would one need to use cflock when READING any shared variables? Because someone else may be WRITING at same time. Don Vawter www.cyberroomies.com [EMAIL PROTECTED] - Original Message - From: Gonzo Rock [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 10:45 AM Subject: CFLOCK and Session variables My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: .biz domains ... what are the issues?
(1) .biz domains are global, so when you've got a name you've got it worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't. Coke will own coke.biz and coke.shop just the same. If you register it, they'll sue your butt. So the same scramble will ensue with the .biz and shop names as with the dot-coms. Many of the speculators are not renewing the .com names they own. Keep checking whois and you'll see that many decent names are lapsing. NSI is making them available much more quickly now than before. I don't know how the other registrars are handling them. But back to the .biz and .shop. With the .biz and .shop, folks will now have to remember, was that blah.com or blah.biz or blah.shop? Better buy them all. (2) If you don't pre-register your name in the .biz domain, someone else can end up taking your name. This might or might not be a problem depending on how important the .biz domains become. Do you guys think that these new domains will ultimately be as important as the .com domains? What a scam! - Even if you pre-register you're not guaranteed anything. Many of the pre-register companies state right on their sites that they don't guarantee you will get your name. They don't even guarantee they'll go after it. Plus they won't refund your money if you don't get it. Pre-registration is a scam! (3) If you don't pre-register your name you could find your own domain owned by an opportunist who will hold your name to ransom until you buy it from him at whatever price he wants. Dittos from #2 above (4) If you have high traffic, someone else could use your name in one of these new tlds and use it to drive traffic to their site, parasitically. So you could end up with your customers being directed to a porn site or anything. And all at your cost. Dittos #1 above (4) Compared to the potential cost of having your name held to ransom or used by a competitor or even a porn site the cost of the new domains are chickenfeed. Yea - but it's still first come first server for the common joe. Unless you're a big corp that can afford lawyers to prove trademark infringment, you just need to be there when the door opens! FWIW and IMHO and all that stuff, Dave ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and MS Word Docs
Hi all, Does anyone know of a way to save a documtn in word to HTML format without all the ridiculous XML formatting!!! When I include the saved html doc in my cf application the formatting looks horrible. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DateDiff problems
My email didnt seem to hit the list. Sorry if this is a re-post. Im doing a CF DateDiff function on two ODBC compliant date times and every once and a while i get very strange results. I found this one in the MySQL database: Clockin: 2001-09-04 12:06:08 Clockout: 2001-09-04 15:19:51 TotalTime: 353173193 minutes Anyone had any trouble with CF's DateDiff function? 353Million minutes is not the right answer... :) ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP to a new window.
No, Not directly... all control of windows is on the client side. What who can do is this: 1. Specify a new window as the target of the link or form, in the page that calls the template that contains the cfhttp... this is before the fact targeting. OR 2. Specify a hidden frame as the target of the link or form. This way, your cf template can send an unseen stub page to the hidden frame. The stub page can contain JavaScript to open another window and write the desired content from a variable in the stub, or just provide a URL. The URL could be the same cf template that now responds with the desired page instead of the stub. (Assume the cfhttp is deferred until this second call or that the cfhttp results were stored in a session variable). It is a little convoluted, but it actually works quite well... this is after the fact targeting. JavaScript has the ability to access any data in any form in any window or frame (that it knows about). It can also rewrite the entire content of any of these. You actually can get quite sophisticated and get some nice effects. For example you submit a form in one frame that targets a hidden frame... the original form remains in place, instead of making the user stare at a blank screen. The template called by the form performs validation and returns the results to the hidden frame, along with an onLoad JavaScript routine. The onload routine can open a popup window or an alert dialog that denotes that the form was validated or which fields were incorrect. Another approach is that the onLoad JavaScript can manipulate DHTML constructs in the originating frame... say, changing the content of a little status layer and then making it visible. HTH Dick At 12:25 AM -0400 9/6/01, Neil H. wrote: Can you run a CFHTTP that will send the file content to a new window? Thanks, ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFHTTP
If I understand you correctly, you will get returned exactly hat you want, Go to the site where you want to post, with your browser. Manually post the form The page that gets returned is what you would get when doing the equivalent with cfhttp. The exception to this is when the page served, as a result, of the post does a client-side redirect with a metatag refresh, JavaScript onLoad, etc. In this case you will need to handle this by: receiving the page with the client-side redirect in CFHTTP.FileContent (the result of the post) Parsing the page (CFHTTP.FileContent) to determine the URL that is the target pf the client-side redirect Issuing a second cfhttp request for the target URL Processing the page (CFHTTP.FileContent) returned from this, second, cfhttp request as desired. HTH Dick At 10:46 AM -0500 9/5/01, ChristianWatt wrote: I am trying to make an internal page that will send an alphanumeric page through our providers website. The problem is that the info is posted to a CGI script that processes the request then redirects to another page that gives the confirmation num of the page sent and that it was successful. Is there any way that I can post to the CGI script, but return the info off the second page? Christian ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Mimic clicking on the Reply button of an email
Does anyone know how I can make a text link that would mimic clicking the Reply button, so that I can include a subject for the return email automatically? TIA Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disabling back button
Try putting the following javascript on your page... may do what you need. script window.history.go(1); /script -Nelson - Original Message - From: Mak Wing Lok [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 3:35 AM Subject: Re: Disabling back button is a nightmare! - Original Message - From: W Luke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 3:51 AM Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Disabling back button
I think this was it: script language=JavaScript type=text/javascript window.history.forward(); /script Rick -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 7:58 AM To: CF-Talk Subject: RE: Disabling back button I remember some time ago seeing a script (I think it was at www.javascript.com ) that replaced the history of the back button with the current page. This essentialy disables the back button. And if my memory serves me correctly, it was just a little snippet of code. Mark -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:51 PM To: CF-Talk Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: .biz domains ... what are the issues?
Mike Kear wrote: What do you think needs to be considered about pre-registering .biz or .shop or whatever domains? It is no guarantee whatsoever that you get the domain. Here's what I've listed so far . (1) .biz domains are global, so when you've got a name you've got it worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't. All domains are global in the sense that if you type www.zip.com.au you will end up on the same server regardless as where you typed it. Some domains (not .com!!!) just have additional rules to register them, like living in a certain locality. But I have my .nl worldwide ;) (2) If you don't pre-register your name in the .biz domain, someone else can end up taking your name. This might or might not be a problem depending on how important the .biz domains become. Do you guys think that these new domains will ultimately be as important as the .com domains? If you do pre-register your name in the .biz domain, someone else can end up taking your name anyway. BTW, if somebody takes it away it isn't your name, it is his name. No, .biz and other new TLDs will not become as important. ICANN has stated that from now on new TLDs will be added on a regular basis, so I expect the new registrations will be spread over more and more domains. (3) If you don't pre-register your name you could find your own domain owned by an opportunist who will hold your name to ransom until you buy it from him at whatever price he wants. If you do pre-register your name you could find your own domain owned by an opportunist who will hold your name to ransom until you buy it from him at whatever price he wants anyway. Do you know why? Because it is not your own but his own ;) I would say, get one good domain and stick with it. Additional TLDs will mean that it will be: - a large financial burden to get your name registered in all domains - increasingly less important to have a certain domain With the last I mean that in the not so far future the amount of possible domains for company X which does car repairs (x.com, x.biz, x.info, x.com.ccTLD, x.car, x.shop, x.repair etc.) is so huge that people will stop trying to find a place by simply typing it in the address bar. Getting quality links and pushing your bookmark to the user is going to be the issue. Just look at how it works with phonenumbers: it used to be that you could be reached if people knew your number. Nowadays, with everybody calling mobile, people can only reach you if you are in memory or under a speeddial. Users are getting more stupid/lazy, they just want to click somewhere to go to your site instead of type it in the address bar, and if you click somewhere it doesn't matter where the link goes. Just my opinion. Jochem ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
automatically generated new site within a forum
Hi @all, i'm trying to set up a forum with CFML. I have the problem, that i don't know, how i can make CF to generate a new site after i.e.: 10 postings... I wnt CF to generate a new site and a link to this new site after every i.e. 10th post. How can i do that? greez cybergnom ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
flash uitoolkit
I'm getting this message when trying to use the calendar control: Template file not found. HTTP/1.0 404 Object Not Found Note: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred while processing an element with a general identifier of (CFINCLUDE), occupying document position (66:1) to (66:81) in the template file C:\CFUSION\CustomTags\componentkittags\uicalendar.cfm Cheers Will Swain ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPop problems!
I have a program, it will getall from a pop server and then loop through the query that is returned. I will then at the end of each iteration within the loop delete messagenumber 1 since this always the first message. I continue to get no such message errors. Sometimes it works perfectly, but other times it doesn't. I don't like CFPOP since it seems to be sketchy. If you have any other suggestions please let me know. With Imail I can write a bat that writes a file and then have the server pole the directory and parse the file and then delete it but that seems more cumbersome (not for me, I could write it :) ) but for the server? Any insight? Thanks, Neil ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RDS Disabling?!
I have people trying to RDS into servers when the service is disabled. It looks like it is causing problems on my server as sessions aren't lasting but 20 seconds. I think the server is restarting thus killing the sessions. Is there a way to block RDS requests? This looks like a brute force DOS. You have a couple of options. 1. If you have control over the gateway, and you can do content filtering at the gateway, simply filter out requests to /CFIDE/Main/ide.cfm. Or, you can do this on the server itself using various host firewall products. 2. You can prevent all RDS requests by setting permissions on {webroot}\CFIDE\Main\ide.cfm so that the web service (or anonymous user in IIS) can't read or execute the file. If you're using IIS, you'll also need to enable the Check that file exists box in the ISAPI extension information for .cfm. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
heading on every page?
Hello, I have a CF report that is about 15 pages long.how do I get the headings to print on every page? Thanks again! ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
java applets for downloading files
Hi, I've heard people talk about using java applets to download files. Can any of you recommend one? Cheers Will Swain ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
HTTP 500 Errors
Recently, after a new install of Win 2K, patches etc. And Cold Fusion 5.0, I've been getting the odd Http 500 Server Error Message from IIS 5.0. And sometimes after 1 reload it goes away. Other times I can reload till I'm blue in the face, I have to restart the website that's affected. The weird thing is that other sites running Cold Fusion are not affected. And it appears to affect sites randomly. All the sites in question are connected to an SQL 2000 Server. Any ideas? ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling CFCONTENT generates 2 hits?
Yes, security is the only thing that is stopping me from simply linking to files. -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] I've seen this happening with my apps that use cfcontent. I don't know if it's been consistent since I haven't been paying attention to it. I will also say that I've been having nothing but problems with cfcontent using cf5. My browser keeps locking up every now and then - and it's not even consistent. Sometimes I'm able to view 10 or more pdf's before locking up and other times I lock up on 3 or 4. I've reverted back to using cflocation to the pdf. I'm using frames on the particular page, so the path is hidden. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can This be done?
I have a page where I display info on 16 players (I'm running a fantasy football league and trying to have everything automated) This info comes from a DB. The info is displayed like this in an html table. TR BGCOLOR=#7DEDF7 TD class=constant align=center4/TD TD class=constant align=centerQB/TD TD class=constant align=center Kurt Warner/TD TD class=constant align=centerSTL/TD TD class=constant align=centerinput type=checkbox name=player value=2 input type=hidden name=postion value=1 input type=hidden name=team value=1 input type=hidden name=week value=4 /TD /TR now there is 16 of these. I need to insert only the ones are checked which will be 8 players. How can I insert these into my DB, I keep getting a numeric value out of range error message so I'm guessing it's trying to grab all the form values in my page and insert them into one line in my DB, I need to have it so Player one info will be inserted into 4 columns, then player 2 will be inserted into the next row of columns etc.. I hope I explained this ok. Thanks for any help someone may offer. Ben Densmore ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
using cfsetting enablecfoutputonly
I am toying with the idea of using cfsetting enablecfoutputonly to suppress whitespace in my site. My question is that if I use this feature to its fullest extent, (like switching cfoutput on and off between conditional statements and having the rest of the entire site encased in cfoutput tags) will I get a performance decrease that is not worth my while. Any opinions. Thanks, David Caplan 36 w 20 st | nyc 10011 | 646.485.9136 | www.fusebox.com | FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK and Session variables
You need to use CFLOCK to read and write session variables, the potential problems arise when a person browsing the web double clicks on a link, or someone sends a url out with cfid and cftoken on them. Session variables are shared, because they are accessible to all CF threads. When a person double clicks a link two requests are sent to the web server at nearly the same time, these two requests will likely be processed in different threads, that both have access to the session variable, if both try to write this causes an error. You need to use CFLOCK to read variables because if another thread is writing to a variable and a read request is sent at the same time you will get corrupted data, and possibly crash the server. There is a setting in CF administrator that does automatic read locking for you. I would have though this question would be in the FAQ (http://www.thenetprofits.co.uk/coldfusion/faq/ maybe its there I just looked quickly) I know its been answered several times in the past. +++ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: Gonzo Rock [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 12:45 PM To: CF-Talk Subject: CFLOCK and Session variables A couple of questions that I can't seem to sort out from reading the DOCS... 1. Why would one need to use cflock when WRITING session.variables ? My impression is that: Session.var is NOT shared, Client.var is NOT shared, Application.var IS shared 2. Why would one need to use cflock when READING any shared variables? thanks y'all, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Certification
I used cf_buster from centrasoft - really helped me, managed 87%: http://www.centrasoft.com/default.cfm HTH Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: 06 September 2001 13:33 To: CF-Talk Subject: CF Certification Anyone with any advice for the CF Certified Developer exam? Thanks in Advance Jerry Staple Web Application Developer http://www.biznetprojects.co.uk/complogo.gif Head Office 133-137 Lisburn Road, Belfast Northern Ireland BT9 7AG T +44 (0) 28 9022 3224 F +44 (0) 28 9022 3223 E mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] W http://www.biznet-solutions.com/ biznet-solutions.com ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Disabling back button
Thanks for everyone's replies - much appreciated Will - Original Message - From: W Luke [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Wednesday, September 05, 2001 8:51 PM Subject: Disabling back button Is there a possible and simple way to do this - or is it a nightmare to do? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DateDiff problems
The only issue I ever had w/ DateDiff was when I went over MAXINT doing a DateDiff over 80 or so years and returned it as seconds. Although in the case you describe below, I bet it's something else. Before the datediff, try parsing the dates to get the years, months, etc, and output them. I bet the years are wrong. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 3:31 PM To: CF-Talk Subject: DateDiff problems My email didnt seem to hit the list. Sorry if this is a re-post. Im doing a CF DateDiff function on two ODBC compliant date times and every once and a while i get very strange results. I found this one in the MySQL database: Clockin: 2001-09-04 12:06:08 Clockout: 2001-09-04 15:19:51 TotalTime: 353173193 minutes Anyone had any trouble with CF's DateDiff function? 353Million minutes is not the right answer... :) ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Exchange Servers
From: Josh Remus [mailto:[EMAIL PROTECTED]] I've done things with pulling items (calendars, appointments, etc.) from Outlook, it may very well be possible from Exchange directly, though I Has anyone written any tools to pull calendars from Outlook/Exchange and then work with that info and a Unix calendar manager, with the goal being to keeping two calendars in sync ? -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion license agreement
Dave, I did that long before I attempted to contact my support rep on the issue. That didn't help at all they were running already. Dave Hannum wrote: Check to see if RDS is running If not, start it then try again. Dave - Original Message - From: Freddy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 7:20 PM Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion license agreement
Was this on a win2000 apache install or IIS? I had no trouble with IIS just apache. Thanks, Frederic Andrew Scott wrote: Works here fine, never did anything to it but a normal install first time. I assume you mean through CF Admin? Regards, Andrew Scott -Original Message- From: Freddy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 September 2001 9:20 AM To: CF-Talk Subject: Re: ColdFusion license agreement what did you do to get the browse function to work for setting up datasources et al? I have installed numerous times on multiple boxes (all with win 2000 pro) and can not get the browse applets functioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic DeVoil, Nick wrote: Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here it's fine. Nick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OOps, This was meant for (CF Certification)
Yesterday was really long, sorry... Mark -Original Message- From: Mark Stewart Sent: Thursday, September 06, 2001 2:24 PM To: CF-Talk Subject: RE: CF and Exchange Servers Study... Ben Forta also has a book on the subject - http://www.forta.com/books/0789725657/ Mark -Original Message- From: Josh Remus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:36 AM To: CF-Talk Subject: RE: CF and Exchange Servers I've done things with pulling items (calendars, appointments, etc.) from Outlook, it may very well be possible from Exchange directly, though I haven't tried that. I used COM objects to pull change this stuff. Check out www.cfcomet.com and look under Outlook for that info. Perhaps someone else might be able to provide more information on Exchange in particular (we don't run exchange)... Josh -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 10:32 AM To: CF-Talk Subject: CF and Exchange Servers HI everyone. I am an intermediate CF developer in college. At work (school web team) I was asked to look into setting up an intranet, but the uppers want to pull stuff from an exhcange server (schedules, appointments, calendar info) for use in the intranet. Is there anyway to use CF to pull Data from an exchange server and possibly update it and send it back to the server ... all using CF. I would appreciate any insight anyone could offer. Thanks everyone. Mike Tangorre --Alfred University Student-- FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Tracking #: D066E37453A1D511A0E100105A0C39A4DBB7BE9C ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Training Recommendations
You might check out www.coldfusiontraining.com Adam's got several pretty intensive database classes listed. -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software -Original Message- From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 6:04 PM To: CF-Talk Subject: SOT: Training Recommendations Hi All - I'm hoping someone can recommend some ColdFusion training that focuses on a variety of topics at the database level, especially including: * Database Design Techniques * Implementing Stored Procedures * Designing and Using Triggers * Joins I started using ColdFusion on a very casual, teach-myself-as-I-go basis back when CF3 was the latest and greatest. I am very confident with my ColdFusion specific skills, but continue to find that my SQL skills (or lack of) are holding me back. I get especially confused with joins, and moment I prefer to use the old ANSI 88?? style joins. However, when I need to do any complex nested joins, I find myself relying on Access's query builder because I absolutely can't figure out how to write them by hand. I also have very little knowledge about stored procedures, triggers, indexes, etc. I've been able to gather that stored procedures and triggers can make a world of difference performance-wise, and I feel as-if I'm providing a a great disservice to my customers by not knowing how to properly evaluate when I should be using implementing stored-procedures, triggers or whatever. Overall, I want to improve my database design and SQL skills, but I want the information I learn to be delivered in a way so that it's always relating back to ColdFusion. Any suggestions? Jay Sudowski - Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com - Providing reseller and dedicated Windows 2000 web hosting solutions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER Usage Question
In SQL Server terms it is qutie a small record set. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: 05 September 2001 19:56 To: CF-Talk Subject: SQL SERVER Usage Question I have a client who's new site will have a 20,000 record song catalog. The site is search intensive. Is this a small record set? Should I consider a dedicated SQl Server or can I use a shared SQL server without a huge impact on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual 550 processor with RAID 1. Thanks for the advise, I realize the question is a little vague. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ArrayInsertAt Question
How would i Insert like 4 values into 2-dimensional array? Anyone had success with this? Like i have an array that contains 3 records with 4 items each. I want to insert a record in spot 2 with the 4 attributes. How can i do this? I'm stumped... ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: flash uitoolkit
Take a look at the documentation that comes with it. I believe they make reference to some variables that you need to change. Mark -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 5:59 AM To: CF-Talk Subject: flash uitoolkit I'm getting this message when trying to use the calendar control: Template file not found. HTTP/1.0 404 Object Not Found Note: If you wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm) does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible. The error occurred while processing an element with a general identifier of (CFINCLUDE), occupying document position (66:1) to (66:81) in the template file C:\CFUSION\CustomTags\componentkittags\uicalendar.cfm Cheers Will Swain ~~ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists