RE: OT SQL SERVER
From http://www.sql-server-performance.com/glossary.asp : When rows are deleted from the leaf level of an index, the are not removed immediately. Instead, they are marked as invalid and are called ghost records. Periodically, SQL Server starts a special housekeeping thread that locates and removes the ghost records. -Original Message- From: John Grubb [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 06, 2001 4:11 PM To: CF-Talk Subject: OT SQL SERVER Sorry for the OT question, but I don't know where else to turn. What is a ghost record or transaction. I am watching a SQL DELETE command run in SQL profiler and it is VERY slow and I am seeing a great many SQL transactions with 'ghost' in the text of the transaction. What can I do to correct this? John Grubb ** 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can this be done with CF
Hi, it can be done with DHTML and Javascript... depending on what data you want to submit there might also be room for CF: ;-)) Regards, Chris --Original Message-- From: "Parker, Kevin" [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: January 8, 2001 1:52:59 AM GMT Subject: Can this be done with CF Hi - wondering if anyone on the list can give me some advice please. The following risk calculator was done in-house for use on our Intranet but now the business area want to make it available on the web. http://www.e-safety.sa.gov.au/cutter/riskassessmentcalculator.htm (DO NOT PRESS THE GO BUTTON) The trouble is it only runs in IE5 because it uses vml (a proprietary MS thing which I hadn't heard of apparently). I suggested that they have a look at JavaScript of Java so that it can run in other browsers but they're a bit hard pressed for time, resources and skills. Do you think it can be done with CF Kevin Parker Manager, Web Services Service and Communication WorkCover Corporation [EMAIL PROTECTED] www.workcover.com ph: +61 8 82332548 fax: +61 8 82332000 mob: 0418 800 287 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
Well this is a completely subjective view but my perception is that CF is considered quite a hot technology here in the UK. I don't know, but I believe the relative strength of CF versus ASP is stronger in the US than in Europe because a lot of people in the US started building web apps before ASP came out or was usable. By the time the UK got started, ASP was a viable option, and no-one ever got fired for buying Microsoft products, as they used to say of IBM. Allaire's reputation for quality doesn't seem to be perfect, but then neither is Microsoft's. Maybe PHP is popular in Europe because it was invented here is largely developed here. But I think decent-sized organisations here tend to steer clear of open source - Apache being something of an exception. They don't trust it. They also like standards. I think that's CF's weakest point from a marketing point of view is that it's seen as a proprietary, closed solution. I believe CF's move to Java will be a big help in this respect. I worked for one company that moved from PHP to Java because they saw Java as a standard. When they find out how complicated Java systems can be, maybe they'll be in the market for a rapid web app development tool based on the Java platform Nick -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 7:05 PM To: CF-Talk Subject: Slightly OT: CF in Europe Even though we just touched the subject in another thread i'd like to start a new one where we "air" our thoughts on the future of CF in Europe since it seems like CF is a "failure" so far over there! The reason being that i'm probably moving back to Europe soon and i would really hate to switch over to ASP/PHP. Allan Pichler Machine Dreams Inc. ** 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_Activedit alternatives??
Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
Lets put it this way. I have been doing web development work since coming out of the University of Bath (for all you Americans, it's an old Roman City in England that has Roman Bath's in it hence the name) not too many years ago. Since then I have done HTML then Perl, then CF. As far as I'm concerned the lack of penetration in CF means that there are not too many developers out there (although this is increasing). The jobs are there (if you look in the right places and are good enough) but such is the perceived value of ASP in the development market that you would find it easier to get an ASP job (and for that matter a PHP job if you have the skills). However the financial implications of this here are huge! Financially it's good to be a CF programmer in the UK - especially a good one. It's even better to be a Spectra programmer (doesn't really matter how good yet as long as you've done the course or have experience). Don't be put off that CF hasn't penetrated the market yet. I firmly believe that it could (no guarantees), but the worst thing that could happen is that the CF programmers move away from CF! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem w/Frames Netscape
See what happens if you put in a body tag after the closing /head tag. Be sure to put in a closing /body tag before /html. Don't know if this will do it or not. But Netscape is really peculiar with tables I know - if they aren't just right you will get an empty page as you are describing. Could be the missing body/body tagset. Just so you know - you don't put body tags around a frameset as they're, well, frames... The body tag goes within the noframes tag, but shouldn't ever go around a frameset Oh, and NS is very picky about start and end tags, so if you mis-spell an end tag then the page probably won't display (especially true if you don't close a /td, /tr or /table) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: deleting session variables
We do have one reason for not using session vars. Clustering. It takes out the need to worry about the variables being held in memory. Paul -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 07, 2001 7:57 AM To: CF-Talk Subject: RE: deleting session variables On first impression using client and session in the same app could be viable if; 1. client requires accessing client storage while session "stays within" the CFAS memory space. 2. if there are vars that need to persist after a session and that are useful to have readily available for a next session 3. assuming session is faster than client {1] On second impression the question needs to be answered whether once client are read if the values also reside in the CAFS memory space - if so, for how long, and how granular is the rentention - i.e. assuming storage is in a db, does one read of any client's vars cause all client's vars to persist in memory or is the clientmanagement selective to retrieving just the particular client vars relative to that client's current session/http request? If every reference to a client var causes a db read or write, then I would say that the only reason to mix client and session is to initialize a client session with client vars, but run the session with session vars. I doubt that client vars are kept in memory for a defined timeout period (or any other undocumented timeout period other than possibly applicationtimeout) like session vars so each reference to a client var will cause a db write or read. That has to mean session vars, once set, are faster. I can see an app organized so that upon logIn client vars in storage are used to intialize the current session, then these values are moved into a session layer for speed with any subsequent client value assignments done only for the purpose of preserving values that need to persist past the end of the current session. I would appreciate any clarification of any of this thinking. (above is not meant to cover clustering issues and assumes no design inhibitions due to ram constraints) Client variables are kept in memory for the duration of the page request. They're retrieved from the repository for every subsequent page request (except when they're stored in cookies - there's no retrieval required then, since the browser simply returns them to the server). As for using Client variables for initialization of values, I'd argue that you'd be better off retrieving values from a normalized database structure (where they usually are anyway for most applications) to populate Session variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
Well this is a completely subjective view but my perception is that CF is considered quite a hot technology here in the UK. I don't know, but I believe the relative strength of CF versus ASP is stronger in the US than in Europe because a lot of people in the US started building web apps before ASP came out or was usable. The timing is certainly one contribution, but there are a lot more "cowboys" and "entpreneurs" in the USA who don't insist on buying only "safe" products. In Europe, the entire culture, across countries, is a bureaucratic, standardized, politicized mentality, seeking at all costs (extremely high, eg, the EC machinery of fraud and waster) to avoid the tiniest risk or non-compliance, and if the product is not 100% "safe" (ie, it's not an MS product for an MS strategic platform), the product, eg CF, is seen as too risky. Is this a conscious orientation? No of course not. It's like asking fish is they are conscious if water. Len http://BIND8NT.MEIway.com : Binary for ISC BIND 8.2.3 T9B for NT4 W2K http://IMGate.MEIway.com : Build free, hi-perf, anti-spam mail gateways ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
I would agree with Paul here. Financially, CF is extremely lucrative in the UK with rates around 30% higher than ASP. The reasons are quite simply that ASP is more popular, but anybody that used to do VB now does ASP, so the market may be bigger, but so is the recruitment base. This has made ASP consultants cheaper to acquire. This is also a reason why people use ASP. Europe has been very MS orientated. If you are already developing using Visual Studio, you business might as well continue down that development path. What it doesn't recognise is that CF is inherently faster to develop for (so I have found) and provides a lot of functionality that you have to write/purchase yourself for ASP. Then again, try persuading business people to shell out for Spectra. Not easy...they cannot see the application development benefits. One thing though...there is a severe lack of GOOD CF developers in the UK. It's amazing the number of people that attempt to blag it. If I interview, I use a simple questionaire that I walk through with the potential...sometimes it really is quite embarrassing. Adam -Original Message- From: Paul Johnston [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:00 AM To: CF-Talk Subject:RE: Slightly OT: CF in Europe Lets put it this way. I have been doing web development work since coming out of the University of Bath (for all you Americans, it's an old Roman City in England that has Roman Bath's in it hence the name) not too many years ago. Since then I have done HTML then Perl, then CF. As far as I'm concerned the lack of penetration in CF means that there are not too many developers out there (although this is increasing). The jobs are there (if you look in the right places and are good enough) but such is the perceived value of ASP in the development market that you would find it easier to get an ASP job (and for that matter a PHP job if you have the skills). However the financial implications of this here are huge! Financially it's good to be a CF programmer in the UK - especially a good one. It's even better to be a Spectra programmer (doesn't really matter how good yet as long as you've done the course or have experience). Don't be put off that CF hasn't penetrated the market yet. I firmly believe that it could (no guarantees), but the worst thing that could happen is that the CF programmers move away from CF! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
One thing though...there is a severe lack of GOOD CF developers in the UK. It's amazing the number of people that attempt to blag it. If I interview, I use a simple questionaire that I walk through with the potential...sometimes it really is quite embarrassing. I have to agree with this. There are lots and lots and lots of developers who try to blag it. I have come across many of them and worked for some. I have worked with developers who have come from HTML (and maybe a little Javascript), and think that doing the Allaire FastTrack to ColdFusion course (ie not the advanced course) means know ColdFusion back to front. WRONG!!! They also don't know anything about mailing lists and the community of developers which in the Unix/Linux (esp. OpenSource) world is understood and used to it's full potential. It really does amaze me sometimes how incredibly naive some people are! IMHO the most important thing is to know why you do something and what is happening in the background (something a *nix person would have a massive headstart on). An example would be the CFHTTP tag. Not understanding HTTP and it's little intricacies can catch out some normal programmers, but as CF is such an abstracted language (ie it simplifies everything) - sometimes to abstracted - some programmers can get caught out. Works well most of the time, but can be a right (insert favourite expletive here) to debug if you don't understand what's actually going on. Paul PS A potential developer questionnaire like that could well catch out a lot of people. PPS Most *nix people love to do everything from the ground up. I don't advocate this but I do think it is useful to be able to understand why things are done in certain ways. If it's already built, use that and modify it. Programmers who are keen to build programmes from the ground up all the time waste huge amounts of time (IMHO) however, it can be very useful in the long run. Adam -Original Message- From: Paul Johnston [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:00 AM To: CF-Talk Subject:RE: Slightly OT: CF in Europe Lets put it this way. I have been doing web development work since coming out of the University of Bath (for all you Americans, it's an old Roman City in England that has Roman Bath's in it hence the name) not too many years ago. Since then I have done HTML then Perl, then CF. As far as I'm concerned the lack of penetration in CF means that there are not too many developers out there (although this is increasing). The jobs are there (if you look in the right places and are good enough) but such is the perceived value of ASP in the development market that you would find it easier to get an ASP job (and for that matter a PHP job if you have the skills). However the financial implications of this here are huge! Financially it's good to be a CF programmer in the UK - especially a good one. It's even better to be a Spectra programmer (doesn't really matter how good yet as long as you've done the course or have experience). Don't be put off that CF hasn't penetrated the market yet. I firmly believe that it could (no guarantees), but the worst thing that could happen is that the CF programmers move away from CF! Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Activedit alternatives??
I've been converted to ezEdit. Free. Good. Displays a textarea if the browser doesn't support what it needs. Michel Vuijlsteke -Original Message- From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:58 AM To: CF-Talk Subject: CF_Activedit alternatives?? Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Learning Javascript Books,
Any recommendations, Please Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Time Management / Billing applications / time sheets
Hi all, Does anyone know any CF based applications for project management / Cleien billing?? Thanks and a happy new year to all. D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Learning Javascript Books,
JavaScript Bible by Danny Goodman consists of both a tutorial and an object and language reference. A little over a thousand pages + example scripts on CD-ROM. It's pretty extensive, and easy to understand. Check out the reviews at amazon.com, ISBN 0-7645-3188-3. Marianne Daye Programmer/Analyst Information Delivery systems (IDS) http://ids.rti.org -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:37 AM To: CF-Talk Subject: OT: Learning Javascript Books, Any recommendations, Please Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Learning Javascript Books,
If you are truly just learning Javascript, a great starting book is "JavaScript For The World Wide Web 3rd Edition Visual Quickstart Guide" by Tom Negrino and Dori Smith (Peachpit Press). We've had pretty good luck with the Visual Quickstart Guides as they teach one thing at a time, fairly concisely, and step-by-step. For a reference book, I'd recommend "Javascript, The Definitive Guide" by David Flanagan (O'Reilly). Also, for a good reference, you might check out http://devedge.netscape.com/docs/manuals/js/client/jsref/index.htm. Regards, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
url string
Hi, Just wondering if there was a way to reference the entire url string instead of just a certain named variable. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: url string
#CGI.QUERY_STRING# --- Ben -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:16 AM To: CF-Talk Subject: url string Hi, Just wondering if there was a way to reference the entire url string instead of just a certain named variable. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Easy CFLOOP Question
is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easy CFLOOP Question
Kevin, You can use cfoutput query and then refer to the currentrow attribute. John Stanley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easy CFLOOP Question
First thing that comes to my mind is a loop counter: cfset counter=1 cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif cfset counter = counter + 1 /cfloop Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 8:45 AM To: CF-Talk Subject: Easy CFLOOP Question is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easy CFLOOP Question
Since you are looping over a query, I believe that you can use the queryname.currentrow variable. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 8:45 AM To: CF-Talk Subject: Easy CFLOOP Question is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Easy CFLOOP Question
queryName.recordCount Check on line documentation (look at cfquery) for more information. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 8:44 AM Subject: Easy CFLOOP Question is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Easy CFLOOP Question
cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfoutput#test.currentrow#/cfoutput /cfloop From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Easy CFLOOP Question Date: Mon, 08 Jan 2001 08:44:48 EST is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easy CFLOOP Question
rows.currentrow (assuming the rows is the name of your query) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 8:45 AM To: CF-Talk Subject: Easy CFLOOP Question is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Billing Accounting Inventory Management
Depends on the price point. If you're truly talking Peach Tree or Quickbooks, no. If price is not the main concern, you might check out Sage Software's Acuity. It's based on COM Component architecture with a SQL Server 7 backend. That might be suitable for integration but the cost is high. Regards, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Easy CFLOOP Question
Yes, use currentRow. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 8:45 AM To: CF-Talk Subject: Easy CFLOOP Question is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL TYPE=HTML
I know it's the default but is there another option for "TYPE=" in CFMAIL specifying plain text (instead of HTML)? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: url string
Thanks Ben. I discovered it shortly after posting the message, I didn't even bother to think about server variables! Doh! Thanks again, Jay At 08:42 AM 1/8/2001 -0500, you wrote: #CGI.QUERY_STRING# --- Ben -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:16 AM To: CF-Talk Subject: url string Hi, Just wondering if there was a way to reference the entire url string instead of just a certain named variable. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Killing Session Vars
It seems that there is a command that will kill all existing session variables on a server without naming them individually, similar to the ClearStruct function. Can someone tell me what that is? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Easy CFLOOP Question
Sorry, too early in the morning. The correct answer is: queryName.currentRow Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Marius Milosav" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 9:00 AM Subject: Re: Easy CFLOOP Question queryName.recordCount Check on line documentation (look at cfquery) for more information. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 8:44 AM Subject: Easy CFLOOP Question is there a way to find out what row i am on in a cfloop? Like inside my loop, call a condition like this cfloop query="test" startrow="1" endrow="#rows.RecordCount#" cfif cfloop.row EQ 1 We are on row 1 cfelse cfloop.row GT 1 We are not on row 1 /cfif /cfloop Is there a way to do this? Some variable i am overlooking? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using .xls datasource
Can someone point me in the right direction to find information on using an Excel file as a CF datasource? I've got a highly formatted Excel spreadsheet that my client would like to be able to add/update/delete lines through his browser. Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: url string
try the CGI variables -Original Message- From: Jay Brushett [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:16 AM To: CF-Talk Subject: url string Hi, Just wondering if there was a way to reference the entire url string instead of just a certain named variable. TIA, Jay Strategy ~ Creativity ~ Technology Jay Brushett [EMAIL PROTECTED] Developer ZeddComm Inc. 2nd Floor, The Tower | 100 Signal Hill Road St. John's, Newfoundland | Canada A1A 1B3 Main: 709.570.5669 | Fax: 709.739.9003 Web: www.zeddcomm.com St. John's ~ New York ~ Newport Beach ~ Ottawa ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and Siebel
Anyone had any experience with CF and Siebel? N ! --- Neil Clark Senior Web Applications Engineer ColdFusion / Spectra / XML mcb digital [Allaire Premium Partner] Tel. +44 (0)20 8941 3232 Tel. +44 (0)20 8408 8131 [Direct] http://www.mcbdigital.com --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using .xls datasource
Erika, Go to www.cfcomet.com it will have everything you need. Have fun We are doing a lot of CF/Excel at the moment Regards D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: 08 January 2001 09:56 To: CF-Talk Subject: Using .xls datasource Can someone point me in the right direction to find information on using an Excel file as a CF datasource? I've got a highly formatted Excel spreadsheet that my client would like to be able to add/update/delete lines through his browser. Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datasource question
The hostname is actually the datasource name. This is usually chosen by the hosting company so you will need to contact them and ask them what the datasource name is. You will also want to check and verify that you are using username and password. In any case when you've figured it out, your CFQUERY tag will look something like this: cfset Username="MyUsername" cfset Password="PaSsw0rD" cfset Datasource="MyDatasourceName" cfquery name="members" datasource"#Datasource#" username="#Username#" password="#Password#" /cfquery Some ColdFusion hosts will set it up in a manner that you will not need to provide the username/password in each of your CFQUERY tags. This is dependent on the ColdFusion host so you should check with them to see if this is the case. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 07, 2001 12:29 AM To: CF-Talk Subject: datasource question I am new to coldfusion and have my site internetcraftfair.com that doesn't have coldfusion on the server. The sister of my server has coldfusion and has been kind enough to set me up a temporary location so I can code some pages for possible employment. Well I have coded the page and sent it up to the sister server but I am not sure how to point it to access my database on my site's server. I have been using perl to connect to my database on my site with DBI and I make a database string that I send to the server in a variable. I have tried to form a database type of string with the CFSET functions setting the username, password, and hostname. I am not sure of the syntax of it though or if I am suppose to use my site "internetcraftfair.com" as the host or the server "topchoice.com". To access my database on my server through telenet my root folder on internetcraftfair.com is client/home/internetcraftfair and then I type in mysql to access the database and send my username and password in to access it. cfset username="name" cfset password="password" cfset hostname="???" should this be internetcraftfair.com or do I need to specify my root directory ? cfquery name="members" datasource" #hostname#,internetcraftfair,#name#,#password#" do I use commas or colons in this string? I am having a hard time accessing the temp folder on the web and hope to hear back from radiant in the morning so I can view my code on the web. I would appreciate any help on this you can suggest. Thanks-- Shelly Hill http://www.internetcraftfair.com "All our dreams can come true - if we have the courage to pursue them" -Walt Disney ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session End
Why don't my Sessions automatically time out when the browser closes? I set session vars when someone logs into my site, and if they close the browser window then open it back up and revisit the site, the vars are still active. Why is this and what can I do to change it? I use the sessions to verify login. -Pete ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript in Netscape
openwin might be a newer function (not sure). try this though; SCRIPT LANGUAGE="JAVASCRIPT" function open_window(URL) { var popup = window.open(URL, "popup_win", "TOOLBAR=NO,SCROLLBARS=YES,WIDTH=500,HEIGHT=370"); } /SCRIPT then: A HREF="javascript:open_window('userid.html')"User ID/A hack it up to get what you want, but the window.open function will get you more compatibility with older browsers. --dylan -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:19 AM To: CF-Talk Subject: Javascript in Netscape hey i had a prob i'm opening a new window with size 500,370. but for the link in there.. i wan the next page to be shown as full screen or at least can be resized... tried the codes below.. can work for IE.. but cant for netscape.. any solution? cheers han File A: function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="javascript:openwin('userid.html', 500, 370)"User ID/a userid.html : function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="register_email.cfm?action=forget"forgotten/a also tried this: A href="javascript:openwin('register_email.cfm?action=forget', 640, 480)"forgotten/a ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session End
Peter, there's a tutorial on this at www.halhelms.com that explains how to make the session expire when the browser is closed. Hal Helms == See www.ColdFusionTraining.com http://www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 9:44 AM To: CF-Talk Subject: Session End Why don't my Sessions automatically time out when the browser closes? I set session vars when someone logs into my site, and if they close the browser window then open it back up and revisit the site, the vars are still active. Why is this and what can I do to change it? I use the sessions to verify login. -Pete ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Killing Session Vars
You might want to try this, it's been working for me: CFSCRIPTStructClear(Session);/CFSCRIPT CFCOOKIE NAME="CFID" VALUE="0" EXPIRES="NOW" CFCOOKIE NAME="CFTOKEN" VALUE="0" EXPIRES="NOW" HTH, Scott Wolf Goodfriend Computer Training -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 8:58 AM To: CF-Talk Subject: Killing Session Vars It seems that there is a command that will kill all existing session variables on a server without naming them individually, similar to the ClearStruct function. Can someone tell me what that is? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Killing Session Vars
On 1/8/01, Dave Hannum penned: It seems that there is a command that will kill all existing session variables on a server without naming them individually, similar to the ClearStruct function. Can someone tell me what that is? cfset temp = structclear(session) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Search Engines Dynamic Sites - Best Course
I'm building a site that will be entirely based on database articles. What are the best methods of making this site search engine friendly so that it can be found? I'm using Fusebox technology if that makes any difference. I know this has been discussed on the list before and I am reviewing the archives. But perhaps something new has come up that would be of some help. Thanks. Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
COUNT field incorrect
BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Thanks. Mediacomm Inc Tom Harris, President phone: 888-327-3122 or 517-347-3122 fax: 517-347-3235 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange output phenomenon
Hi All, Got a really strange problem here with Paragraphformat Scenario: A user enters a list of names into a form field (textarea field in this case), which is then parsed so as to enter the names into an Access field using the Paragraphformat function in CF. i.e. user inputs: Dave1 Dave2 Dave3 Dave4 Dave5 Which becomes Dave1 pDave2 pDave3 pDave4 p Dave5 In Access field - Thus far so good However, when outputting the prior user inputs above, simply using cfoutput #query.fieldname# /cfoutput I am getting Dave Dave2 Dave Dave4 Dave5 (Notice the missing "3" and "1") I've also tried this with various different inputs, leading to an interesting result as demonstrated below INPUT: Dave12345 Dave12345 Dave101 Dave245 Dave RETURNS: Dave 245 Dave 245 Dave 0 Dave245 Dave (As you may notice, the "1" and "3" are being treated as BR tags?) System Environment: NT4 SP6, CF4.01 Enterprise, MS Access datasource Anybody ever seen this before or have any idea what's going on? Thanks in advance Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF_Activedit alternatives??
Hi Paco, Try ezEdit from www.siteobjects.com , and it's free as well. Hassan --- "Francisco Montes; Spain on Line" [EMAIL PROTECTED] wrote: Hi all! I´ve been using the CF_Activeedit custom tag for some time now but i´ll like to know about other similar tags i could use as well. I´ve found out that it doesn´t work properly with one of our Mac machines for some reason (??). Does anybody know of any other tag that also allows text edition (even if it´s only basic edition functionality)? TIA ! Paco Montes Spain on Line ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript in Netscape
heh nevermind; i didn't realize you were defining openwin as the function. still, see if the code helps. too early for me to read apparently ;). -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 6:50 AM To: CF-Talk Subject: RE: Javascript in Netscape openwin might be a newer function (not sure). try this though; SCRIPT LANGUAGE="JAVASCRIPT" function open_window(URL) { var popup = window.open(URL, "popup_win", "TOOLBAR=NO,SCROLLBARS=YES,WIDTH=500,HEIGHT=370"); } /SCRIPT then: A HREF="javascript:open_window('userid.html')"User ID/A hack it up to get what you want, but the window.open function will get you more compatibility with older browsers. --dylan -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:19 AM To: CF-Talk Subject: Javascript in Netscape hey i had a prob i'm opening a new window with size 500,370. but for the link in there.. i wan the next page to be shown as full screen or at least can be resized... tried the codes below.. can work for IE.. but cant for netscape.. any solution? cheers han File A: function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="javascript:openwin('userid.html', 500, 370)"User ID/a userid.html : function openwin(location, x, y) { para="toolbar=no,scrollbars=yes,resizeable=yes,width="+x+",height="+y; msgWindow=window.open(location, "displaywindow", para); } A href="register_email.cfm?action=forget"forgotten/a also tried this: A href="javascript:openwin('register_email.cfm?action=forget', 640, 480)"forgotten/a ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: COUNT field incorrect
Without seeing the CFQUERY tag this is just a guess, but that error usually occurs when a) you've mistyped a column name, b) missed single quotes (or used them when you should not have), c) missed commas. --- Ben -Original Message- From: Tom Harris [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 1:06 PM To: CF-Talk Subject: COUNT field incorrect BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Thanks. Mediacomm Inc Tom Harris, President phone: 888-327-3122 or 517-347-3122 fax: 517-347-3235 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: COUNT field incorrect
An example of the query that is failing, as it is being called would be helpful for debugging purposes. DC - Original Message - From: "Tom Harris" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 13:05 Subject: COUNT field incorrect BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Thanks. Mediacomm Inc Tom Harris, President phone: 888-327-3122 or 517-347-3122 fax: 517-347-3235 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL TYPE=HTML
I think it's just type="text" Regards, Howie - Original Message - From: "Aidan Whitehall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 8:57 AM Subject: CFMAIL TYPE=HTML I know it's the default but is there another option for "TYPE=" in CFMAIL specifying plain text (instead of HTML)? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CF in Europe
And what makes Java less proprietary than C++? Last I heard, Sun pulled it from the standards committee. Suggesting that Java would be opened up, was one maneuver in Sun's marketing campaign to regain market share lost to Open Source alternatives to their products: http://www.wired.com/news/topstories/0,1287,19413,00.html In fact, if the language that your application server was written in had anything to do with the "openness" of the application server, being written in C++ would make ColdFusion far more open. But, of course, the language the server is written in has little to nothing to do with the openness of the server itself. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:59 AM To: CF-Talk Subject: RE: Slightly OT: CF in Europe Well this is a completely subjective view but my perception is that CF is considered quite a hot technology here in the UK. I don't know, but I believe the relative strength of CF versus ASP is stronger in the US than in Europe because a lot of people in the US started building web apps before ASP came out or was usable. By the time the UK got started, ASP was a viable option, and no-one ever got fired for buying Microsoft products, as they used to say of IBM. Allaire's reputation for quality doesn't seem to be perfect, but then neither is Microsoft's. Maybe PHP is popular in Europe because it was invented here is largely developed here. But I think decent-sized organisations here tend to steer clear of open source - Apache being something of an exception. They don't trust it. They also like standards. I think that's CF's weakest point from a marketing point of view is that it's seen as a proprietary, closed solution. I believe CF's move to Java will be a big help in this respect. I worked for one company that moved from PHP to Java because they saw Java as a standard. When they find out how complicated Java systems can be, maybe they'll be in the market for a rapid web app development tool based on the Java platform Nick -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 7:05 PM To: CF-Talk Subject: Slightly OT: CF in Europe Even though we just touched the subject in another thread i'd like to start a new one where we "air" our thoughts on the future of CF in Europe since it seems like CF is a "failure" so far over there! The reason being that i'm probably moving back to Europe soon and i would really hate to switch over to ASP/PHP. Allan Pichler Machine Dreams Inc. ** 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Killing Session Vars
Actually, Session is a structure, so you answered your own question. However, Allaire recommends that you do not delete "all" session variables, since there are session variables used for session management. --- Billy Cravens Dave Hannum wrote: It seems that there is a command that will kill all existing session variables on a server without naming them individually, similar to the ClearStruct function. Can someone tell me what that is? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Search Engines Dynamic Sites - Best Course
What I have done in the past is generate static html templates from the database that the search engines can pick up and then put a redirect on those pages to the CF templates so when the user follows a link they get the CF page and not the page the search engine has indexed. Kevin - Original Message - From: "Paul Sinclair" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 8:57 AM Subject: Search Engines Dynamic Sites - Best Course I'm building a site that will be entirely based on database articles. What are the best methods of making this site search engine friendly so that it can be found? I'm using Fusebox technology if that makes any difference. I know this has been discussed on the list before and I am reviewing the archives. But perhaps something new has come up that would be of some help. Thanks. Paul Sinclair ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
using foo/1/foo2/2 instead of foo=1foo2=2
Hey Guys: I am running IIS 5.0/4.0 web servers and I would like to use a backslash to seperate my var names/values. Amazon uses this method and I like it because it helps discourage url hacking (at least I think so). Alos, I believe using this method you can mask the file name so there is no file extension. Thanks, Greg ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Search Engines Dynamic Sites - Best Course
The new thing is that Search Engines are apparently no including the full URL, including that after ? and There's a message in the archive documenting one search engine that does not do this. best, paul At 09:57 AM 1/8/01 -0500, you wrote: I'm building a site that will be entirely based on database articles. What are the best methods of making this site search engine friendly so that it can be found? I'm using Fusebox technology if that makes any difference. I know this has been discussed on the list before and I am reviewing the archives. But perhaps something new has come up that would be of some help. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using .xls datasource
Can someone point me in the right direction to find information on using an Excel file as a CF datasource? I've got a highly formatted Excel spreadsheet that my client would like to be able to add/update/delete lines through his browser. OK, a few of quick pointers; Table names are strange to call - [$tableName] (or maybe the other way round) Column names MUST be supplied Columns types are decided at the opening of the table - thus if Excel decides that it's a Text field, then all numeric types are ignored (and the other way round) Once ODBC gets hold of an Excel sheet, it won't let go - CF needs to be stopped and started to release the file I would suggest running it via an Access Link table, it means you can down/up load the file as you require Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: COUNT field incorrect
BlankHello -- anyone know what this error refers to? ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect It started appearing in an app we are working on, we searched the code for anything referring to "count" and there is nothing, and certainly not a field in the database named COUNT. We naturally assumed it had something to do with that particular app, then it started appearing in another one. Any ideas? (using CF 4.5 with MS Access) Without seeing the SQL, some possible ideas; Count is one of the aggrigate functions, so maybe you're trying to run a Count but not specifying properly Field name mis-spelt? Count() of a field that doesn't exist... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using foo/1/foo2/2 instead of foo=1foo2=2
I am running IIS 5.0/4.0 web servers and I would like to use a backslash to seperate my var names/values. Amazon uses this method and I like it because it helps discourage url hacking (at least I think so). Alos, I believe using this method you can mask the file name so there is no file extension. BTW, \ is backslash and / is slash As long as you're not going to use FORMs and your template is always index.cfm, then this is fine You can strip out the items after the real URL by using either CGI.Path_Info or CGI.Script_Name (depending on your server) With this it gives you the complete list after the directory Then write some looping code to build the variables - I prefer to use = in the url so that I can see which variable breaks to which (easier to read), but you can do it without easily enough using ListFirst() and ListGetAt(,2) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange output phenomenon - Nevermind
Turns out I was looking at wrong version of the output file. The correct version was parsing out the "1" and "3" characters. - doh ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: using foo/1/foo2/2 instead of foo=1foo2=2
And your question is? best, paul PS The Fusebox method allows this as an option. www.fusebox.org I use my own version. At 10:21 AM 1/8/01 -0500, you wrote: I am running IIS 5.0/4.0 web servers and I would like to use a backslash to seperate my var names/values. Amazon uses this method and I like it because it helps discourage url hacking (at least I think so). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange output phenomenon
the information shouldn't be going INTO the db with paragraph format. you should have WRAP="HARD" in your textarea control, then insert the data straight. PAaragraphForamt() is for output, not inuput. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:03 AM To: CF-Talk Subject: Strange output phenomenon Hi All, Got a really strange problem here with Paragraphformat Scenario: A user enters a list of names into a form field (textarea field in this case), which is then parsed so as to enter the names into an Access field using the Paragraphformat function in CF. i.e. user inputs: Dave1 Dave2 Dave3 Dave4 Dave5 Which becomes Dave1 pDave2 pDave3 pDave4 p Dave5 In Access field - Thus far so good However, when outputting the prior user inputs above, simply using cfoutput #query.fieldname# /cfoutput I am getting Dave Dave2 Dave Dave4 Dave5 (Notice the missing "3" and "1") I've also tried this with various different inputs, leading to an interesting result as demonstrated below INPUT: Dave12345 Dave12345 Dave101 Dave245 Dave RETURNS: Dave 245 Dave 245 Dave 0 Dave245 Dave (As you may notice, the "1" and "3" are being treated as BR tags?) System Environment: NT4 SP6, CF4.01 Enterprise, MS Access datasource Anybody ever seen this before or have any idea what's going on? Thanks in advance Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Killing Session Vars
Thanks for the responses. I am doing this on my test box. I have good reasons for doing so. I would never plan to do this in production. Dave - Original Message - From: "Billy Cravens" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 10:15 AM Subject: Re: Killing Session Vars Actually, Session is a structure, so you answered your own question. However, Allaire recommends that you do not delete "all" session variables, since there are session variables used for session management. --- Billy Cravens Dave Hannum wrote: It seems that there is a command that will kill all existing session variables on a server without naming them individually, similar to the ClearStruct function. Can someone tell me what that is? Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Bandwidth and SQL Server questions
Sorry for the OT post. You guys are my bestest resource. :) I just bumped up my server to a T-1 where I colo. This outfit has been a little less that honest with me, although I've really been happy with the performance of their network. I have over 100 sites (mostly small static sites) running on a 512K and it's performed very well. Is there a way to test if I've really got a T-1? I've got a customer who's signed a contract with a large company who is going to have about 200 employees accessing his application and just want to be sure I really have a T-1. Then at least if I start bogging down I can look at more bandwidth. On another note. I'm about ready to make the plunge into a new SQL Server box. That should break me for another year. LOL Right now I've got a firewall and the big Dell. I've got an extra Dual port NIC on the Dell. I should be OK just connecting a crossover cable right from the Dell to the SQL Server box, right? When I get enough cash for a separate mail server also, I'll get a switch, unless y'all think I'd be better off with one now. Any recommendations on a decent/cheapish 1U rack mountable switch? Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using foo/1/foo2/2 instead of foo=1foo2=2
It's not fusebox that allowes this it's FormURL2Attributes tag, and you can view the source so you can edit it to your needs. I was messing around with it before but haven't really had the need for it yet. This tag would accomplish all that you need. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:44 AM To: CF-Talk Subject: Re: using foo/1/foo2/2 instead of foo=1foo2=2 And your question is? best, paul PS The Fusebox method allows this as an option. www.fusebox.org I use my own version. At 10:21 AM 1/8/01 -0500, you wrote: I am running IIS 5.0/4.0 web servers and I would like to use a backslash to seperate my var names/values. Amazon uses this method and I like it because it helps discourage url hacking (at least I think so). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Differences between OLE DB and ODBC
Good morning all, I Created a page that accesses the same database table but with two different datasources as shown below: cfquery name="FindUsers" datasource="facilitadortestsite_ole" dbtype="OLEDB" debug SELECT * FROM TeaserUsers /cfquery cfquery name="FindUsers_odbc" datasource="facilitadortestsite" dbtype="ODBC" debug SELECT * FROM TeaserUsers /cfquery I outputted the total record count for each query in the following way: cfoutput #FindUsers.recordcount# users found under OLEbr #FindUsers_odbc.recordcount# users found under ODBCbr /cfoutput Here are my results: 5 users found under OLE 76 users found under ODBC Queries FindUsers (Records=5, Time=250ms) SQL = SELECT * FROM TeaserUsers FindUsers_odbc (Records=76, Time=31ms) SQL = SELECT * FROM TeaserUsers Why is it that OLE DB is reporting only 5 records, while ODBC is reporting ALL of them as it should be, based on the query? Any help will be greatly appreciated! Andres ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: using foo/1/foo2/2 instead of foo=1foo2=2
Well, I use a URL like: http://www.MyWebsite.com/HL/LL/LO/index.cfm/IN.526/CD.3142036/CN.53306261/HD.1000/AL.A/OR.50897.HTM which separates Variables name/value with a "." The my app_globals.cfm (or application.cfm) contains the following to parse the URL: !--- Strip ".htm/.html" from the URL --- CFIF LISTLAST(CGI_SCRIPT_NAME,".") IS "htm" CFSET CGI_SCRIPT_NAME = LEFT(CGI_SCRIPT_NAME,LEN(CGI_SCRIPT_NAME)-4) CFELSE CFIF LISTLAST(CGI_SCRIPT_NAME,".") IS "html" CFSET CGI_SCRIPT_NAME = LEFT(CGI_SCRIPT_NAME,LEN(CGI_SCRIPT_NAME)-5) /CFIF /CFIF CFSET LISTLENGTH = LISTLEN(CGI_SCRIPT_NAME,"/") CFSET LIST_INDEX = LISTCONTAINSNOCASE(CGI_SCRIPT_NAME,"index.cfm","/") CFSET LISTSTART = LIST_INDEX + 1 CFLOOP INDEX="IJK" FROM="#ListStart#" TO="#ListLength#" CFSET FUSEACTION= LISTGETAT(CGI_SCRIPT_NAME,IJK,"/") CFSWITCH EXPRESSION = #GETTOKEN(FUSEACTION,1,'.')# CFCASE VALUE="IN" CFSET VARIABLES.INIT = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="CD" CFPARAM NAME="URL.CFI" DEFAULT="#GETTOKEN(FUSEACTION,2,'.')#" /CFCASE CFCASE VALUE="CN" CFPARAM NAME="URL.CFT" DEFAULT="#GETTOKEN(FUSEACTION,2,'.')#" /CFCASE CFCASE VALUE="KW" CFSET VARIABLES.KEYWORD = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="AL" CFSET VARIABLES.ALPHA = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="SY" CFSET VARIABLES.SUBYP_ID = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="HD" CFSET VARIABLES.HDG_ID = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="OR" CFSET VARIABLES.ORG_ID = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="SC" CFSET VARIABLES.ORG_IDSC = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="LL" CFSET VARIABLES.ALPHAL = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFCASE VALUE="ST" CFSET VARIABLES.START = GETTOKEN(FUSEACTION,2,'.') /CFCASE CFDEFAULTCASE CFOUTPUTERROR!/CFOUTPUT CFABORT /CFDEFAULTCASE /CFSWITCH /CFLOOP As another poster noted: "You can strip out the items after the real URL by using either CGI.Path_Info or CGI.Script_Name (depending on your server) With this it gives you the complete list after the directory" best, paul At 10:47 AM 1/8/01 -0500, you wrote: How do you do this? - Original Message - From: "paul smith" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, January 08, 2001 10:44 AM Subject: Re: using foo/1/foo2/2 instead of foo=1foo2=2 And your question is? best, paul PS The Fusebox method allows this as an option. www.fusebox.org I use my own version. At 10:21 AM 1/8/01 -0500, you wrote: I am running IIS 5.0/4.0 web servers and I would like to use a backslash to seperate my var names/values. Amazon uses this method and I like it because it helps discourage url hacking (at least I think so). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Accessing Excel Files
Does anyone have tips on accessing excel files with cold fusion through odbc. (other than 'don't'). With the following code I only get access to one row of the spreadsheet (F2, F3, ...) Any suggestions? CFQUERY NAME="tmp" DATASOURCE="BorIMport" SELECT G9 FROM "Form 3$" /CFQUERY CFLOOP LIST="#tmp.ColumnList#" INDEX="item" CFOUTPUT#item# -- #Evaluate("tmp.#item#")#BR/CFOUTPUT /CFLOOP ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL and hair loss
I'm having problems building an HTML e-mail in one template and passing it back as a variable to the calling template to then send it. The GenerateInvoice tag builds the Invoice as a webpage, ready to send with CFMAIL and TYPE="HTML". That bit works fine. If you output #variables.Invoice# to the page, you get a page that displays as expected and that HTMLValidator says is OK. CFMODULE TEMPLATE="/customtags/GenerateInvoice.cfm" InvoiceID="#variables.InvoiceID#" Format="HTML" CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="Invoice" TYPE="HTML"#variables.Invoice#/CFMAIL Running the template produces a blank HTML e-mail which (if you do View Source in Outlook) appears to have no content. The To, From and Subject Fields are fine. If you delete TYPE="HTML" and set variable.Invoice in GenerateInvoice to any old rubbish, it works fine. Does anyone have any ideas what might be happening? GenerateInvoice is below... Thanks if you can offer any advice. GenerateInvoice.cfm CFPARAM NAME="attributes.InvoiceID" DEFAULT="" CFPARAM NAME="attributes.Format" DEFAULT="HTML" !--- Get the main invoice information --- CFQUERY DATASOURCE="#request.DataSource#" NAME="GetInvoice" SELECT Invoices.Company, Invoices.CustomerID, Invoices.Customer, Invoices.InvoiceDate FROM Invoices WHERE Invoices.InvoiceID = #attributes.InvoiceID#; /CFQUERY !--- Get the ClientUID from the database if the Invoice stored the CustomerID --- CFIF Len(GetInvoice.CustomerID) CFQUERY DATASOURCE="#request.DataSource#" NAME="GetClientUID" SELECT Customers.ClientUID FROM Customers WHERE Customers.CustomerID = #GetInvoice.CustomerID#; /CFQUERY /CFIF !--- Get the main invoice information --- CFQUERY DATASOURCE="#request.DataSource#" NAME="GetInvoiceItems" SELECT InvoiceItems.* FROM InvoiceItems WHERE InvoiceItems.InvoiceID = #attributes.InvoiceID#; /CFQUERY CFSET variables.Invoice = "" CFSET variables.TotalNet = 0 CFSET variables.TotalVAT = 0 !--- Build the invoice in the specified format --- CFSWITCH EXPRESSION="#attributes.Format#" CFCASE VALUE="plaintext" /CFCASE CFCASE VALUE="HTML" CFSET variables.Invoice = variables.Invoice "HTMLHEADTITLEInvoice/TITLE/HEADBODY BGCOLOR=""##FF""" !--- Preliminary Invoice information --- CFSET variables.Invoice = variables.Invoice "H3Invoice/H3" CFSET variables.Invoice = variables.Invoice "PBFrom/BBR" Replace(GetInvoice.Company, request.CrLf, "BR", "all") "/P" CFSET variables.Invoice = variables.Invoice "PBTo/BBR" Replace(GetInvoice.Customer, request.CrLf, "BR", "all") "/P" CFSET variables.Invoice = variables.Invoice "PBInvoice No:/B " attributes.InvoiceID "BR" CFSET variables.Invoice = variables.Invoice "BCustomer No:/B " GetClientUID.ClientUID "/P" !--- Output an HTML table with one row per Invoiceitem --- CFSET variables.Invoice = variables.Invoice "TABLETRTHPDetails/P/THTHPNet Amount/P/THTHPVAT Amount/P/TH/TR" CFLOOP QUERY="GetInvoiceItems" CFSET variables.Invoice = variables.Invoice "TRTDP" InvoiceItem !--- If there is a period applicable for this record, output it --- CFIF Len(PeriodFrom) AND Len(PeriodTo) CFSET variables.Invoice = variables.Invoice "BRFrom: " DateFormat(PeriodFrom, "dd/mm/") " To: " DateFormat(PeriodTo, "dd/mm/") /CFIF CFSET variables.Invoice = variables.Invoice "/P/TD" CFSET variables.Invoice = variables.Invoice "TDP" DecimalFormat(NetAmount) "/P/TD" CFSET variables.Invoice = variables.Invoice "TDP" DecimalFormat(VATAmount) "/P/TD/TR" CFSET variables.TotalNet = variables.TotalNet NetAmount CFSET variables.TotalVAT = variables.TotalVAT VATAmount /CFLOOP !--- Output the totals --- CFSET variables.Invoice = variables.Invoice "TRTD COLSPAN=""3""HR/TD/TR" CFSET variables.Invoice = variables.Invoice "TRTDnbsp;/TDTD ALIGN=""right""PBTotal Net/B/P/TDTDP" DecimalFormat(variables.TotalNet) "/P/TD/TR" CFSET variables.Invoice = variables.Invoice "TRTDnbsp;/TDTD ALIGN=""right""PBTotal VAT/B/P/TDTDP" DecimalFormat(variables.TotalVAT) "/P/TD/TR" CFSET variables.Invoice = variables.Invoice "TRTD COLSPAN=""3""HR/TD/TR" CFSET variables.Invoice = variables.Invoice "TRTDnbsp;/TDTD ALIGN=""right""PBInvoice Total/B/P/TDTDP" DecimalFormat(variables.TotalNet) "/P/TD/TR" CFSET variables.Invoice = variables.Invoice "TRTD COLSPAN=""3""HR/TD/TR/TABLE" CFSET variables.Invoice = variables.Invoice "/BODY/HTML" /CFCASE /CFSWITCH !--- Make the invoice available to the calling template --- CFSET caller.Invoice = variables.Invoice -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:
RE: remote server response
Jennifer, I'm finishing up a CFX tag that will do what you need. Right now what you can do is write a script that will parse through your templates extracting out http, ftp, or mailto: tags. You can dump these into a table then as a scheduled task you could cfx_http to the address to get the response code from the server, then not show the link if it returns anything other than 200 and send you an email to let you know. Jeff Sarsoun -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 3:09 PM To: CF-Talk Subject: remote server response I'm looking for ideas because I'm not sure how to go about this. I'm setting up some pages that are going to have links to external sites. I know how bad it looks to have broken links so I'd like to check the links on a schedule and remove any links that are broken. I'll still get some broken inks but it's better than using up my server resources checking links every time a page loads. At any rate, I'm not sure quite how to check the links in the way I'd like to. I'm considered trying CFHTTP method="get" ... throwonerror="yes" but I'm not sure that it will do what I want it to do. In some cases I want to make sure that the server is responding (because I don't have a specific file to point to) and in some cases I want to make sure there isn't a 404 error (because I do have a specific file to point to). This would probably work for a 404 error but frankly, I didn't understand the section of the CFML Language Reference that talked about whether a filename is required for CFHTTP. To be honest, I don't even want to get the file-- I just want to make sure it is available. I don't have access to these servers so I can't put a dummy file on the server to get to make sure the server is responding. Is there a better way to do this that I'm missing? Ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bandwidth and SQL Server questions
Bud, For a switch I highly recommend a HP Procurve 2524. http://www.hp.com/rnd/products/switches/switch2524-2512/summary.htm Tony Gruen -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 7:51 AM To: CF-Talk Subject: OT: Bandwidth and SQL Server questions Sorry for the OT post. You guys are my bestest resource. :) I just bumped up my server to a T-1 where I colo. This outfit has been a little less that honest with me, although I've really been happy with the performance of their network. I have over 100 sites (mostly small static sites) running on a 512K and it's performed very well. Is there a way to test if I've really got a T-1? I've got a customer who's signed a contract with a large company who is going to have about 200 employees accessing his application and just want to be sure I really have a T-1. Then at least if I start bogging down I can look at more bandwidth. On another note. I'm about ready to make the plunge into a new SQL Server box. That should break me for another year. LOL Right now I've got a firewall and the big Dell. I've got an extra Dual port NIC on the Dell. I should be OK just connecting a crossover cable right from the Dell to the SQL Server box, right? When I get enough cash for a separate mail server also, I'll get a switch, unless y'all think I'd be better off with one now. Any recommendations on a decent/cheapish 1U rack mountable switch? Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Learning Javascript Books,
O'Reilly's JavaScript: The Definitive Guide It's not a fun or easy read like For Dummies, etc books, but it teaches you the language from the grounds up, as opposed to the typical approach of only covering basic form validation and DHTML. Plus the reference section is excellent. -- Billy Michael wrote: Any recommendations, Please Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Downloads on the Allaire site
When I go to download files from the Allaire developers exchange, how do they do that download app? I've tried fiddling around with CFHEADER and CFCONTENT but it's not working. Can someone help me understand this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
2nd try---CFMAIL time issue
We have an issue with the sent time of mail going out through CFMAIL. A check of the CF servers and the mail servers reveal those times correct. However, this is what the header looks like. Received: from fusion-prod1.blah.com ([10.200.5.95]) by corp-exc1.blak.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id CGJBY6MY; Fri, 5 Jan 2001 09:49:48 -0500 ** This is right* Received: from 127.0.0.1 (localhost [127.0.0.1]) by fusion-prod1.blah.com (8.9.3+Sun/8.9.1) with ESMTP id JAA05563 for me mailto:[EMAIL PROTECTED] @blah.com; Fri, 5 Jan 2001 09:49:47 -0500 (EST) *This is right* X-Sybari-Space: From: test mailto:[EMAIL PROTECTED] @blah.com Message-Id: [EMAIL PROTECTED] Content-type: multipart/alternative; boundary="===---===---===---===---===_mailer" Date: Fri, 05 Jan 2001 09:49:06 + * This is wrong,(notice the correct time, but + instead of -5000) so the sent time is displayed as 5 hours off Any idea where it's getting that last time? Jeff Britts ColdFusion Engineer e-Dialog ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Learning Javascript Books,
I think Danny Goodman's JavaScript Bible is also fantastic. The thing I appreciate most is the painstaking research he did on what differences there are among browsers and versions. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 11:17 AM To: CF-Talk Subject: Re: OT: Learning Javascript Books, O'Reilly's JavaScript: The Definitive Guide It's not a fun or easy read like For Dummies, etc books, but it teaches you the language from the grounds up, as opposed to the typical approach of only covering basic form validation and DHTML. Plus the reference section is excellent. -- Billy Michael wrote: Any recommendations, Please Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Learning Javascript Books,
O'Reilly's JavaScript: The Definitive Guide It's not a fun or easy read like For Dummies, etc books, but it teaches you the language from the grounds up, as opposed to the typical approach of only covering basic form validation and DHTML. Plus the reference section is excellent. ORA books are brilliant - generally the best technical books around. We've got this one and the Sybex book, but the Sybex one is hardly opened Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: aliasing using cfmail
Could you elaborate on what you mean by 'compliant.' I ask because my test worked both with and without quotes. Is it an issue of different mail servers and clients? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] Subject: Re: aliasing using cfmail To be compliant, the "friendly name" needs to be delimited by quotes and the actual address needs to be delimited by brackets as follows: "friendly name" [EMAIL PROTECTED] HTH, Howie Hamlin - inFusion Project Manager - Original Message - From: "Rick Lamb" [EMAIL PROTECTED] Subject: aliasing using cfmail Do any of you guys know how to alias the "from" parameter as to include a display name along with the email address? EG: cfmail from="Rick [[EMAIL PROTECTED]]" /cfmail Thx! Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Learning Javascript Books,
Make sure to get the O'Reilly Javascript The definative Guide as a companion to it, and quite possibly the O'Reilly DHTML book too. The Javascript Bible is good for a lot, but the combination is much better. Just my 2 cents Heath -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 11:24 AM To: CF-Talk Subject: RE: OT: Learning Javascript Books, I think Danny Goodman's JavaScript Bible is also fantastic. The thing I appreciate most is the painstaking research he did on what differences there are among browsers and versions. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 11:17 AM To: CF-Talk Subject: Re: OT: Learning Javascript Books, O'Reilly's JavaScript: The Definitive Guide It's not a fun or easy read like For Dummies, etc books, but it teaches you the language from the grounds up, as opposed to the typical approach of only covering basic form validation and DHTML. Plus the reference section is excellent. -- Billy Michael wrote: Any recommendations, Please Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bandwidth and SQL Server questions
As a general resource: http://dir.yahoo.com/Computers_and_Internet/Communications_and_Networking/Be nchmarks/ Hopefully theres something there that would be useful. Brian -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 10:51 AM To: CF-Talk Subject: OT: Bandwidth and SQL Server questions Sorry for the OT post. You guys are my bestest resource. :) I just bumped up my server to a T-1 where I colo. This outfit has been a little less that honest with me, although I've really been happy with the performance of their network. I have over 100 sites (mostly small static sites) running on a 512K and it's performed very well. Is there a way to test if I've really got a T-1? I've got a customer who's signed a contract with a large company who is going to have about 200 employees accessing his application and just want to be sure I really have a T-1. Then at least if I start bogging down I can look at more bandwidth. On another note. I'm about ready to make the plunge into a new SQL Server box. That should break me for another year. LOL Right now I've got a firewall and the big Dell. I've got an extra Dual port NIC on the Dell. I should be OK just connecting a crossover cable right from the Dell to the SQL Server box, right? When I get enough cash for a separate mail server also, I'll get a switch, unless y'all think I'd be better off with one now. Any recommendations on a decent/cheapish 1U rack mountable switch? Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: aliasing using cfmail
By compliant I sure Howie means "compliant with the mail RFCs" , but Howie is the resident email expert :-) Check out http://www.tac.nyc.ny.us/mail/rfc-index.html Some mail server will "fix" the address though ... Justin cf-talk Mail 19 number of 2001 :-) -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 4:40 PM To: CF-Talk Subject: Re: aliasing using cfmail Could you elaborate on what you mean by 'compliant.' I ask because my test worked both with and without quotes. Is it an issue of different mail servers and clients? -- Owen - Athens County Library Services http://www.athenscounty.lib.oh.us - Original Message - From: "Howie Hamlin" [EMAIL PROTECTED] Subject: Re: aliasing using cfmail To be compliant, the "friendly name" needs to be delimited by quotes and the actual address needs to be delimited by brackets as follows: "friendly name" [EMAIL PROTECTED] HTH, Howie Hamlin - inFusion Project Manager - Original Message - From: "Rick Lamb" [EMAIL PROTECTED] Subject: aliasing using cfmail Do any of you guys know how to alias the "from" parameter as to include a display name along with the email address? EG: cfmail from="Rick [[EMAIL PROTECTED]]" /cfmail Thx! Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: aliasing using cfmail
Yes, I meant according to RFC. Regards, Howie - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 11:57 AM Subject: RE: aliasing using cfmail By compliant I sure Howie means "compliant with the mail RFCs" , but Howie is the resident email expert :-) Check out http://www.tac.nyc.ny.us/mail/rfc-index.html Some mail server will "fix" the address though ... Justin cf-talk Mail 19 number of 2001 :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bandwidth and SQL Server questions
Here is one tool: http://www.msn.zdnet.com/partners/msn/bandwidth/speedtest.htm HTH, Howie - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 10:50 AM Subject: OT: Bandwidth and SQL Server questions Sorry for the OT post. You guys are my bestest resource. :) I just bumped up my server to a T-1 where I colo. This outfit has been a little less that honest with me, although I've really been happy with the performance of their network. I have over 100 sites (mostly small static sites) running on a 512K and it's performed very well. Is there a way to test if I've really got a T-1? I've got a customer who's signed a contract with a large company who is going to have about 200 employees accessing his application and just want to be sure I really have a T-1. Then at least if I start bogging down I can look at more bandwidth. On another note. I'm about ready to make the plunge into a new SQL Server box. That should break me for another year. LOL Right now I've got a firewall and the big Dell. I've got an extra Dual port NIC on the Dell. I should be OK just connecting a crossover cable right from the Dell to the SQL Server box, right? When I get enough cash for a separate mail server also, I'll get a switch, unless y'all think I'd be better off with one now. Any recommendations on a decent/cheapish 1U rack mountable switch? Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Learning Javascript Books,
I recommend the Javascript Bible as well as the following: The Book of Javascript : A Practical Guide to Interactive Web Pages by Dave Thau, David Thau Shane Witbeck www.digitalsanctum.com -- Original Message -- From: "Hal Helms" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 08 Jan 2001 11:24:11 -0500 I think Danny Goodman's JavaScript Bible is also fantastic. The thing I appreciate most is the painstaking research he did on what differences there are among browsers and versions. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 11:17 AM To: CF-Talk Subject: Re: OT: Learning Javascript Books, O'Reilly's JavaScript: The Definitive Guide It's not a fun or easy read like For Dummies, etc books, but it teaches you the language from the grounds up, as opposed to the typical approach of only covering basic form validation and DHTML. Plus the reference section is excellent. -- Billy Michael wrote: Any recommendations, Please Thanks Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bandwidth and SQL Server .. [oops sorry]
Farhvegnugen . Sorry folks, that was meant to go direct to Bud. Steve - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 7:50 AM Subject: OT: Bandwidth and SQL Server questions Sorry for the OT post. You guys are my bestest resource. :) , I'll get a switch, unless y'all think I'd be better off with one now. Any recommendations on a decent/cheapish 1U rack mountable switch? Thanks a bunch. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bandwidth and SQL Server questions
Ive got an Intel ES410T 16 Port - brand spanking new in the retail box :-) Not to mention some pretty bad ass Fiber Gigabit Adapters PWLA8490SX, and Gigabit over copper PWLA8490T Adapters. Intel ES410T 16 Port 10/100 - $365.00 (CF Dude Discount) List is like $600+ Steve - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 7:50 AM Subject: OT: Bandwidth and SQL Server questions Sorry for the OT post. You guys are my bestest resource. :) I just bumped up my server to a T-1 where I colo. This outfit has been a little less that honest with me, although I've really been happy with the performance of their network. I have over 100 sites (mostly small static sites) running on a 512K and it's performed very well. Is there a way to test if I've really got a T-1? I've got a customer who's signed a contract with a large company who is going to have about 200 employees accessing his application and just want to be sure I really have a T-1. Then at least if I start bogging down I can look at more bandwidth. On another note. I'm about ready to make the plunge into a new SQL Server box. That should break me for another year. LOL Right now I've got a firewall and the big Dell. I've got an extra Dual port NIC on the Dell. I should be OK just connecting a crossover cable right from the Dell to the SQL Server box, right? When I get enough cash for a separate mail server also, I'll get a switch, unless y'all think I'd be better off with one now. Any recommendations on a decent/cheapish 1U rack mountable switch? Thanks a bunch. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: remote server response
Hi Jeff, If this tag is going to be made available generally may I join the queue already forming. Kind regards Gordon At 11:03 08/01/01 -0500 Jeff Sarsoun said Jennifer, I'm finishing up a CFX tag that will do what you need. Right now what you can do is write a script that will parse through your templates extracting out http, ftp, or mailto: tags. You can dump these into a table then as a scheduled task you could cfx_http to the address to get the response code from the server, then not show the link if it returns anything other than 200 and send you an email to let you know. Jeff Sarsoun -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 3:09 PM To: CF-Talk Subject: remote server response I'm looking for ideas because I'm not sure how to go about this. I'm setting up some pages that are going to have links to external sites. I know how bad it looks to have broken links so I'd like to check the links on a schedule and remove any links that are broken. I'll still get some broken inks but it's better than using up my server resources checking links every time a page loads. At any rate, I'm not sure quite how to check the links in the way I'd like to. I'm considered trying CFHTTP method="get" ... throwonerror="yes" but I'm not sure that it will do what I want it to do. In some cases I want to make sure that the server is responding (because I don't have a specific file to point to) and in some cases I want to make sure there isn't a 404 error (because I do have a specific file to point to). This would probably work for a 404 error but frankly, I didn't understand the section of the CFML Language Reference that talked about whether a filename is required for CFHTTP. To be honest, I don't even want to get the file-- I just want to make sure it is available. I don't have access to these servers so I can't put a dummy file on the server to get to make sure the server is responding. Is there a better way to do this that I'm missing? Ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Contract work??? OT
Hello all, I have been developing in ColdFusion, Sql Server, DB400(AS/400), Oracle, ASP, JavaScript, Html on NT/2000 Platforms.. Do you guys know any website/company that outsources/sub-contracts Projects/Contracts. Preferably Remote Development. Appreciate it. Sorry for the OT question. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hierarchial Display
I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Contract work??? OT
you may want to use guru.com to search for positions like this. ~Simon Simon Horwith Allaire Certified ColdFusion Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:39 PM To: CF-Talk Subject: Contract work??? OT Hello all, I have been developing in ColdFusion, Sql Server, DB400(AS/400), Oracle, ASP, JavaScript, Html on NT/2000 Platforms.. Do you guys know any website/company that outsources/sub-contracts Projects/Contracts. Preferably Remote Development. Appreciate it. Sorry for the OT question. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Learning Javascript Books,
By ORA do you mean O'Reily? If not could you pass along what one your referring to, Thank You Michael "Philip Arnold - ASP" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... O'Reilly's JavaScript: The Definitive Guide It's not a fun or easy read like For Dummies, etc books, but it teaches you the language from the grounds up, as opposed to the typical approach of only covering basic form validation and DHTML. Plus the reference section is excellent. ORA books are brilliant - generally the best technical books around. We've got this one and the Sybex book, but the Sybex one is hardly opened Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hierarchial Display
Why not get the custom tag to populate a tree structure instead of a query? Then you can write another recursive custom tag to display the data much more easily. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:41 PM To: CF-Talk Subject: Hierarchial Display I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Contract work??? OT
There is a cf-jobs mailing list @ houseoffusion, also I believe there is a JobPosting section at the http://www.acfug.org/ web site. Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:39 PM To: CF-Talk Subject: Contract work??? OT Hello all, I have been developing in ColdFusion, Sql Server, DB400(AS/400), Oracle, ASP, JavaScript, Html on NT/2000 Platforms.. Do you guys know any website/company that outsources/sub-contracts Projects/Contracts. Preferably Remote Development. Appreciate it. Sorry for the OT question. Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Contract work??? OT
I have been developing in ColdFusion, Sql Server, DB400(AS/400), Oracle, ASP, JavaScript, Html on NT/2000 Platforms.. Do you guys know any website/company that outsources/sub-contracts Projects/Contracts. Preferably Remote Development. Appreciate it. Sorry for the OT question. Have you tried posting to CF-Job? I don't know how many people look for people who post on there (we do, when we need someone), but it may help Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Learning Javascript Books,
By ORA do you mean O'Reily? If not could you pass along what one your referring to, Sorry - ORA is O'Reilly Associates Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hierarchial Display
I recently ran across a sweat application that generated an org chart. What is so sweat is that the Hierarchial data is housed in a XML doc ... and then XSL parser recursively transforms the data with embedded VML to handle the graphical framework. And it executes at the client! The only files sent from the server are the XML document which references the XSL definition. Of course this is MSXML 2.0/IE 5 client based. I can't wait until the next time I need a tree structure GUI. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: aliasing using cfmail
Some mail servers are more strict than others. Some validate only the email addresses in the protocol and some actually parse the mail headers and check those for validity. However, bottom line, if you want to make sure that you are compliant 100% of the time your address needs to be the way I mentioned before (in both the protocol and headers). What I mean by the protocol is when you use the TO and FROM parameters of CFMail. Regards, Howie - Original Message - From: "Owen Leonard" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 08, 2001 11:40 AM Subject: Re: aliasing using cfmail Could you elaborate on what you mean by 'compliant.' I ask because my test worked both with and without quotes. Is it an issue of different mail servers and clients? -- Owen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hierarchial Display
What web browsers does you support? If you use IE, you can easily build an XML based tree control to contain your information... -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:41 PM To: CF-Talk Subject: Hierarchial Display I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hierarchial Display
Cna you tell us what the name of the app is? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:07 PM To: CF-Talk Subject: Re: Hierarchial Display I recently ran across a sweat application that generated an org chart. What is so sweat is that the Hierarchial data is housed in a XML doc ... and then XSL parser recursively transforms the data with embedded VML to handle the graphical framework. And it executes at the client! The only files sent from the server are the XML document which references the XSL definition. Of course this is MSXML 2.0/IE 5 client based. I can't wait until the next time I need a tree structure GUI. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hierarchial Display
I'm pretty sure that the DC CFUG had a presentation on bitmasks and hierarchies, with some custom tags included. It should be available at www.figleaf.com and look under June 2000 CFUG. Jason Powers Fig Leaf Software 202-797-5440 -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 12:41 PM To: CF-Talk Subject: Hierarchial Display I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Visual Source Safe
Has anyone used Visual Source Safe with ColdFusion and multiple programmers? Nathan Stanford www.cfitpsplus.com Free CF e-zine Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFHEADER
It seems the following won't work, well in at least IE5.5. CFHEADER NAME="Content-Disposition" VALUE="attachment;filename=#attributes.fname#" CFCONTENT TYPE="application/pdf" FILE="#fnp#" It instead opens the page up for download instead of the file. So lets say I have peter.pdf as my attributes.fname and download.cfm is the page the above code is on. And lets say that it's called from index.cfm. Well index.htm appears in the download file box, not peter.pdf. It seems to work ok in Netscape, so I can't believe I'm the only one having this problem. I've seen similar looking code on the Allaire site, but it's still not working. Can anyone help with this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hierarchial Display
Wat do you mean by a tree structure? At 05:51 PM 1/8/01 +, you wrote: Why not get the custom tag to populate a tree structure instead of a query? Then you can write another recursive custom tag to display the data much more easily. -Original Message- From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 5:41 PM To: CF-Talk Subject: Hierarchial Display I am able to retrieve hierarchial data just fine using a nested custom tag, and this tag populates a query for me with the data. However, I'm having a real problem with trying to figure out how to display it. Here's an example of the data: 0325 - Thomas - Graf - 0645 - Robert - Nudo - 0325 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 1450 - Jerome - Horowitz - 0325 And I'd like it displayed thus: 0325 - Thomas - Graf - - 0645 - Robert - Nudo - 0325 - 1392 - Joseph - Sheble - 0325 0937 - Kimberly - Walters - 1392 0674 - Lisa - Perez - 0937 - 1450 - Jerome - Horowitz - 0325 However, there's no limit to the hierachy depth... any ideas? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Visual Source Safe
Nathan, We have multiple Developers using Visual Source Safe with Cold Fusion. are you having a problem or Question? -Rye Ininet Inc. -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Monday, January 08, 2001 1:35 PM To: CF-Talk Subject: Visual Source Safe Has anyone used Visual Source Safe with ColdFusion and multiple programmers? Nathan Stanford www.cfitpsplus.com Free CF e-zine Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists