CFERROR - anything else?
Hello all, Got a CFERROR/troubleshooting question for you. Besides using the CFERROR tag in conjunction with an error.cfm containing #Error.diagnostics# #Error.MailTo# #Error.DateTime##Error.Browser# #Error.GeneratedContent# #Error.RemoteAddress# #Error.HTTPReferer# #Error.Template# #Error.QueryString# Are there any other ways of capturing CFserver errors, and formatting them the way you want? E ~~ 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
Format(GetTicketCount)
Hello, I'm using GetTickCount to monitor page execution times and I'm having a problem formatting the returned number. I'm assuming this number is in milliseconds. I can't seem to figure out how to do this using TimeFormat(), LSParseDateTime(), or DateTimeFormat(). E ~~ 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: Need help interpreting error message.
The only thing that I can think of is that might only
have to create the struct if you if statement is false...
cfset DynaTextMode = ""
cfif IsDefined("session.user.DynaTextMode")
cfif session.user.DynaTextMode EQ "Edit"
cfset DynaTextMode = "Edit"
/cfif
cfelse
cfset session.user = structNew()
/cfif
cfset session.user.systemid = sys.systemID
cfset session.user.userid = ucase(variables.userid)
cfset session.user.preferences = u2.preferences
a series of these cfsets
also...you might want to look at using cfscript as it
will speed things up a little.
Tom
-Original Message-
From: Lon Lentz [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 10:45 AM
To: CF-Talk
Subject: RE: Need help interpreting error message.
Here's a little of the code before and after the error causing line.
cfset DynaTextMode = ""
cfif IsDefined("session.user.DynaTextMode")
cfif session.user.DynaTextMode EQ "Edit"
cfset DynaTextMode = "Edit"
/cfif
/cfif
cfset session.user = structNew()
cfset session.user.systemid = sys.systemID
cfset session.user.userid = ucase(variables.userid)
cfset session.user.preferences = u2.preferences
a series of these cfsets
Lon Lentz
Applications Developer CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210
-Original Message-
From: Thomas Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 11:05 PM
To: CF-Talk
Subject: RE: Need help interpreting error message.
can you send the code surrounding this as well???
~~
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: Syndicated Content
iSyndicate.com. Both free and for-fee content, on a huge variety of topics. Kevin [EMAIL PROTECTED] 12/07/00 12:50PM It is going to be for a localized entertainment portal. Right now what we are looking for is movie show and entertainment news. At 10:51 AM 12/7/2000 -0600, you wrote: some good experience. What is the content for? I may be able to help. Eric From: Nick McClure [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: OT: Syndicated Content Date: Thu, 07 Dec 2000 10:12:45 -0500 I am trying to find some Syndicated Content that also includes movie times. Anybody out there had any experiences(good or bad) with any companies on trying to import content via CF. -- Nick McClure[EMAIL PROTECTED] Technical Director 859.245.9656 squareFish Mediawww.squareFish.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: [RE: CF java object]
how would I use cfobject then? Bryan Love [EMAIL PROTECTED] wrote: Calling a Java class is done using HTML and thus the location of the CF machine is completely irrelevent. You can call Java classes from anywhere. Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:33 AM To: CF-Talk Subject: CF java object can I call a java object on a remote machine? or does the object have to be on the same machine as CF? ~~ 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: Renaming a CF Server (NT/Win2K)
I did that once in my life and will never try it again! NEVER rename the server. Nothing will ever work again and you have to reinstall everything (That was on Windows NT 4.. maybe windows2K is better..?) I would approach it differently... Just build it offline. Don't connect it to the network. Name it the same as the other server, and use the same IP address as the other server. .. Use an old backup to get the directory structure, so you can set permissions, and set up the web server.. (if you don't have a tape drive on the new server, burn a CD with the old data, transfer it to the new server on CD, but don't forget to remove the read-only attribute) Then, late at night when nobody is around Shut down the web server on the old one. Copy the data files to a third server on the network, unplug the old server from the network, plug in the new one, then copy the files back to the new server, and voila! Al Musella, DPM Musella Foundation At 01:25 PM 12/8/2000 -0500, you wrote: I need to replace my aging NT 4.0 / CF 4.0.1 Pro server with new hardware, Win2K Adv. Server, and CF 4.5.1. At Verizon, we can only perform this kind of change during the late night hours. So, to save time at night, I'd like to build the new server during the day, migrate the content, and then just swap the hardware that night. No problem there. However, to maintain compliance with our company's server naming standards, I need to rename the new server once it's online so it will have the same name as the old server. Has anyone done this before? If so, has anyone run into any problems or quirks? Forewarned is forearmed... Thanks, Eric A. Laney Systems Engineer Verizon IT "It is easy to be blinded to the essential uselessness of computers by the sense of accomplishment you get from getting them to work at all." - Douglas Adams ~~ 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:SQL Server uninstall
Most DTS tasks require the full version, not the desktop version. The full version won't run on windows 2K pro.Are you running W2kPro? If not, try installing the SQL server SP2. If that doesn't work, try service pack 3 beta. I don't think you can completely uninstall sql server... the only way to get rid of it absolutely completely would be to reinstall windows. Al At 03:01 PM 12/8/2000 -0500, Robert M. Saxon, Jr. wrote: Does anyone know where I can find complete uninstall instructions for the desktop version of SQL Server 7? I have DLL errors that are preventing me from performing any DTS task. After using the uninstall program and reinstalling SQL Server, the problems persist. Rob ~~ 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: cfgrid not working
Am having a problem with CFGRID displaying in browsers. Anyone have any ideas as to what might be causing that? Thanks in advance. ~~ 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: Complex expressions w/ cfswitch
No, you can't do that. Complex expressions aren't allowed in cfcase. You'd
have to create a series of if/then statements.
Hal Helms
== See www.ColdFusionTraining.com for info on "Best Practices with
ColdFusion Fusebox" training, Jan 22-25 ==
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 4:31 PM
To: CF-Talk
Subject: Complex expressions w/ cfswitch
Howdy all.
OK, easy enough to do a simple expression using cfswitch.
cfswitch expression="#action#"
cfcase value = "someaction"
Some Code
/cfcase
cfcase value = "someotheraction"
Some Other Code
/cfcase
cfdefaultcase
Default Code
/cfdefaultcase
/cfswitch
Which is basically if action is "this" do this, if action is "that"
do that. What about doing a more complex expression. Like if action
is "this" and isdefined('that')? Is there a way to use complex
expressions with cfswitch? Examples?
Thanks! :-D
--
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: Big companies using CF
I need to second Larry on this one. We built a site here at Ford that is probably THE most high-profile site on the corporate intranet. This site gets over 30,000 user sessions and 1.2+ million hits a day on average. It runs on NT 4/IIS 4/CF 4.5.1/SQL Server 7. Chris Chris Poterala TEKgroup [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Larry C. Lyons [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 4:52 PM To: CF-Talk Subject: Re: Big companies using CF Benjamin Fitts wrote: Internal sites and extranets don't get a lot of traffic. Victoria's Secret and AutoByTel don't get a lot of traffic? I don't know how you define a lot of traffic but damn I'd love to get their "not a lot of traffic." ~~ 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: mac address
Anyone know of a way to grab a client machines mac address? Am looking for a way to do it with Cold Fusion, scripting, ActiveX, or Java. Any tips or suggestions would be greatly appreciated. Wanting to use the mac address for security verification. From; http://www.sans.org/newlook/resources/IDFAQ/mac_address.htm quote Can I use the MAC address of an Ethernet packet to trace an attacker? If the attack originated from a system that has a direct connection to your system with no gateway in between, then you can use the MAC address. But, if a gateway is in the path, then the gateway replaces the MAC address of the sender with its own address. As a result, you can trace the attack to the gateway only. If the gateway has extensive logging enabled, you might consider searching the log file for more information. /quote From the above and given that CAFS works at the OSI application level and that MAC is below that level I would conclude that you are unlikely to accomplish your goal. Gateways are going to be in the transit path of most http sessions CFAS participates in and CFAS is not generically capable of sniffing packets. If a gateway is not a concern than I might suggest one of the Seller tags as a possibility. You'll have to have a tool running that can generate a file of packet data that CFAS can reference - with the caveat that gateway translation will probably make the data unavailable. That's all server side. Client side; http://www.cyberport.com/~tangent/programming/winsock/advanced.html at question 4.7 there seems to be a decent overview of what you will need to deal with via client side Java/Activex - if at all possible. It still doesn't look possible, certainly it will not be a trivial task. The SNMP API, NETBIOS API and RPC/OLE API discussed are in the context of winsock - any solution developed from this will have to be one of a set of solutions encompassing several client OSs. Looks like a good few months worth of research and a fascinating (well, at least an educational) project. Good luck - we'll all be awaiting the cfx tag from you. :) Pan p.s. on an intranet or vpn or extranet the effort will be less as the parameters of the task *should* be under your control - i.e. everyone same OS, same browser, direct access to servers and routers, deliberate non-inclusion of a gateway, etc. ~~ 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: Removing dupes from list
Scott, if you go to the Allaire tag gallery and search for "duplicate", you'll see a couple of custom tags. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 5:17 PM To: CF-Talk Subject: Removing dupes from list If i have a list like: 2,10,3,1,2,9,9,2 what is the easiest way to parse out the dupes to make the list: 2,10,3,1,9 ?? Thanks, Scott ~~ 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: Removing dupes from list
try some of these: http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=duplic ate -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 2:17 PM To: CF-Talk Subject: Removing dupes from list If i have a list like: 2,10,3,1,2,9,9,2 what is the easiest way to parse out the dupes to make the list: 2,10,3,1,9 ?? Thanks, Scott ~~ 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: Removing dupes from list
If i have a list like: 2,10,3,1,2,9,9,2 what is the easiest way to parse out the dupes to make the list: 2,10,3,1,9 May not be the easiest, but ... cfset originalList="2,10,3,1,2,9,9,2" cfset tmpList="" cfloop index="item" list=originalList cfif(NOT ListFindNocase(tmpList,item) cfset tmp=ListAppend(tmpList,item) /cfif /cfloop OR, You could use ListValueCountNoCase(), but you'll end up spending more processing time as you'll have to reloop every time you find a return 1 and do a ListDeleteAt() for the 2nd+ occurrences. Or, You could build a structure and use StructKeyExists(), . etc. In short there area lot of way to code what you want to do ... "easiest" is up to you, but the first method I outlined should be reasonably quick and simple - it does operate in linear time so there might be a faster method. Pan ~~ 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/JRun Studio
Has a JRun Studio install hosed anyone else's CF Studio? ~~ 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
CFLOOP output Question
Ok, what I want to do is output a query to two tables side by side. Now i tried this but it doesn't quite work well. Any suggestions? cfquery datasource="data" name="information" SELECT * FROM Table /cfquery cfset firstrow = #information.RecordCount# / 2 cfset secondrow = (#information.RecordCount# / 2) + 1 cfloop query="information" startrow="1" endrow="#FirstRow#" output table /cfloop cfloop query="information" startrow="#SecondRow#" endrow="#information.RecordCount#" output table /cfloop 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
Session Variables over Clustered Servers
Server Admin stuff isn't my thing, so bear with me. I was under the impression that session variables were stored in RAM on the server. Is it possible for a session variable to persist moving from one server in a cluster to another? -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ 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: The most mature product in this roundup
That's what ZDNet said about CFStudio 4.5 in a review of their top 7 Web Development Tools: See it here: http://www.zdnet.com/devhead/stories/articles/0,4413,2660115,00.html 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: mac address
I don't know if there is a custom tag that will do this but, you could use CFEXECUTE with either 'nbtstat' or, if you have the NT Resource Kit, 'getmac'. 'nbtstat' returns a lot more information than just the MAC, which means you'd have to parse the information, but 'getmac' returns only the MAC(s) given the IP address, NetBios name, or host name. You could optionally create a COM wrapper for it. Of course, Java, VB, and probably WSH, have the capability to do this too, I just don't have code on hand. Are nbstat and getmac for the lan or can you use them to get client MAC across a http session outside the local lan? I think the orig poster was asking how to use MAC as a security check for any client accessing a page ... I assumed in my previous answer that meant including clients not on the lan the server running CFAS is on. ??? Pan ~~ 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: mac address
I don't know if there is a custom tag that will do this but, you could use CFEXECUTE with either 'nbtstat' or, if you have the NT Resource Kit, 'getmac'. 'nbtstat' returns a lot more information than just the MAC, which means you'd have to parse the information, but 'getmac' returns only the MAC(s) given the IP address, NetBios name, or host name. You could optionally create a COM wrapper for it. Of course, Java, VB, and probably WSH, have the capability to do this too, I just don't have code on hand. Oookay... In the cfx_networktopology source (which I released a couple days back) there is a function called LANsNT. It uses netbios calls to query for all network adapters. If you program, that would be a _starting_ point if we're talking about a local lan. I... don't think there is anyway to directly query above you lan however. Unless you want to write a service dcom for each network that you can query. :) (There's probably some easier way then this, some half documented ms api somewhere but nothing I'd risk network security with comes mind at the moment.) Beyond this tends to be out of my area of experience --min ~~ 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
Small companies using CF..=)
Who says only the big guys can host major cf driven traffic? http://www.fanfiction.net is a pure 100% cf site pushing out 18+million cf page views per month (more accurate than just hits which can be 2x the number of actual page views) on only 2 round-robined dual-pentium3 800 servers with cheap run-of-the-mill IDE hard drives running W2K and SQL 2000. It's time for the "little" guys to claim our rights to the cf traffic turf and I would like to see what the total of us "little" guys compared to the giants to be honest. =) I see the big company representing for good overall publicity but have to say that it's really the little guys that technically demonstrate that cf aren't all that slow as many claims by squeezing the last bit of juice out of the codes. Large companies can always pop another node into their cf-cluster but most medium and small places can't. Xing ~~ 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 Grid problems
Having big problems getting CF Grid to display. Anyone have any ideas on what the problem might be? Thanks, Pardee. ~~ 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: Small companies using CF..=)
Who says only the big guys can host major cf driven traffic? http://www.fanfiction.net is a pure 100% cf site pushing out 18+million cf danke mortal creature, Very cool link. :) --min ~~ 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: CFGRID problem
Having big problems getting CF Grid info to display in a browser. Anyone have any ideas on what the problem might be? Thanks. ~~ 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: mac address
NBTSTAT.exe can be used to get the mac address over the internet. Problem with CFEXECUTE is that it is slow, and there is no good way to get data out of it to mess with that I know of. From looking at everything I have seen so far we may end up going for a more conventional method of authentication. There seems to be no sure fire way to get the mac address in an uncontrolled environment like the internet. Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 Date: Fri, 08 Dec 2000 23:09:52 -0800 From: "pan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: mac address Message-ID: 03ac01c061af$086ff560$894aabcd@cat I don't know if there is a custom tag that will do this but, you could use CFEXECUTE with either 'nbtstat' or, if you have the NT Resource Kit, 'getmac'. 'nbtstat' returns a lot more information than just the MAC, which means you'd have to parse the information, but 'getmac' returns only the MAC(s) given the IP address, NetBios name, or host name. You could optionally create a COM wrapper for it. Of course, Java, VB, and probably WSH, have the capability to do this too, I just don't have code on hand. Are nbstat and getmac for the lan or can you use them to get client MAC across a http session outside the local lan? I think the orig poster was asking how to use MAC as a security check for any client accessing a page ... I assumed in my previous answer that meant including clients not on the lan the server running CFAS is on. ??? Pan ~~ 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
http://www.forumspot.org
Hello! I downloaded the subject Forum ver 3.11 but haven't been able to Restore the Forum30SQL.bak (Complete SQL backup database). The error message says I need to consider using the "WITH MOVE" option, which I cannot find on EM. Any suggestions? best, 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: PL/SQL
Sorry can't help you there. Jeff Britts wrote: Basically, we're working on a tool to generate the pl/sql script on the fly so we cant use a stored proc. Any ideas? -Original Message- From: C Frederic Valone [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:54 AM To: CF-Talk Subject: Re: PL/SQL We use cf and pl/sql stored procs extensively. What exactly are you trying to do? Jeff Britts wrote: Anyone have any luck running PL/SQL through ColdFusion? The simple stuff seems to work ok, but if you throw it something complex it chokes. 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: http://www.forumspot.org
- Original Message - From: "paul smith" [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 1:39 PM I downloaded the subject Forum ver 3.11 but haven't been able to Restore the Forum30SQL.bak (Complete SQL backup database). The error message says I need to consider using the "WITH MOVE" option, which I cannot find on EM. When an SQL database is backed up, it also stores the realtive paths to the datafiles on the server from which it was originally backed up. If the datafiles on your server, i.e. the one to which you are restoring the database, are located in a different directory location, i.e. path, then you will need to edit the path to reflect that: In "Restore Database" select "Options", and then in the "Restore as" fields, enter the path to the datafiles on your server for the "mdf" and "ldf" files. The restore should then proceed normally. Adrian Cooper. ~~ 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 Variables over Clustered Servers
I was under the impression that session variables were stored in RAM on the server. Is it possible for a session variable to persist moving from one server in a cluster to another? Your impression is correct. Session variables are specific to a single physical server, and will not persist across servers within a cluster. However, you can use session variables within a clustered application, as long as the cluster is using session-aware load balancing, which directs a user's initial request to a server, and all subsequent requests from that user to the same server. 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: http://www.forumspot.org
Thanks! Worked like a charm. I hadn't noticed the location was wrong in my previous Restore attempts. bet, paul At 01:58 PM 12/9/00 +, you wrote: - Original Message - From: "paul smith" [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 1:39 PM I downloaded the subject Forum ver 3.11 but haven't been able to Restore the Forum30SQL.bak (Complete SQL backup database). The error message says I need to consider using the "WITH MOVE" option, which I cannot find on EM. When an SQL database is backed up, it also stores the realtive paths to the datafiles on the server from which it was originally backed up. If the datafiles on your server, i.e. the one to which you are restoring the database, are located in a different directory location, i.e. path, then you will need to edit the path to reflect that: In "Restore Database" select "Options", and then in the "Restore as" fields, enter the path to the datafiles on your server for the "mdf" and "ldf" files. The restore should then proceed normally. Adrian Cooper. ~~ 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: SQL Union
I want to use the UNION operator to combine two SELECT statements. My problem is that one of the SELECTs draws data that has one less column than the other, because the table used in the second is missing one of the columns found in the first. I'm trying to work out a way to create a dummy boolean column in the second query and populate it with the value of 0, so the UNION operator works. Something like SELECT Column1, Column 2, Column3 FROM Table1 UNION SELECT Column1, Column2, 0 as Column3 FROM Table2 This doesn't work. What will? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net ~~ 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: SQL Union
Try: SELECT Column1, Column 2, Column3 FROM Table1 UNION SELECT Column1, Column2, 'MissingColumn' FROM Table2 you can replace MissingColumn with any other string that you can then use to determine where the information is coming from. 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: "Gene Kraybill" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 1:58 PM Subject: OT: SQL Union I want to use the UNION operator to combine two SELECT statements. My problem is that one of the SELECTs draws data that has one less column than the other, because the table used in the second is missing one of the columns found in the first. I'm trying to work out a way to create a dummy boolean column in the second query and populate it with the value of 0, so the UNION operator works. Something like SELECT Column1, Column 2, Column3 FROM Table1 UNION SELECT Column1, Column2, 0 as Column3 FROM Table2 This doesn't work. What will? Gene Kraybill - Gene Kraybill LPW Associates LLC www.lpw.net ~~ 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: http://www.forumspot.org
Just FYI, the download area of Forumspot.org seems to be off-line at around 11.15a EST on Saturday. - Steve ~~ 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: What are the recognized CF variable scopes?
Thanks! Wow! That sure was an obscure reference! The request scope is mentioned only in passing. But the reference helps. Thanks, again. -- Tim Dempsey - Original Message - From: "pan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, December 06, 2000 1:02 PM Subject: Re: What are the recognized CF variable scopes? 1.) What is the Request scope? /CFDOCS/Developing_Web_Applications_with_ColdFusion/07_Reusing_Code/dwa07_07 ..htm ~~ 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: Small companies using CF..=)
Who says only the big guys can host major cf driven traffic? http://www.fanfiction.net is a pure 100% cf site pushing out 18+million cf page views per month Cool. (more accurate than just hits which can be 2x the number of actual page views) Just as a point of reference : Hits are on average 10x the number of page impressions, given that every graphic, bit of html, external JS or Style generates a hit in the web server logs. on only 2 round-robined dual-pentium3 800 servers with cheap run-of-the-mill IDE hard drives running W2K and SQL 2000. See you don't need a server farm of 10's of servers to run a big site, if you write the code and database well. ;o) Regards Stephen ~~ 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: Small companies using CF..=)
As I recall from the recent CF_Scale, AutoByTel has "only" a dozen servers. best, paul At 04:40 PM 12/9/00 +, you wrote: See you don't need a server farm of 10's of servers to run a big site, if you write the code and database well. ;o) ~~ 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
Wither Forumspot.org Admin?
Listers: I've set up the new Forums from www.forumspot.org, but I cannot get the login dialog or form even though the login page: http://www.MyRootHere.com/Forums311/admin/index.cfm?cfapp=1 comes up. Any suggestions? best, 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: Which message-board to get
Yup. There are a lot more ASP boards: Check www.aspcode.net under Message Boards. At 05:09 PM 12/09/00 +, W Luke wrote: - Original Message - From: ""Dennis Powers"" [EMAIL PROTECTED] Newsgroups: dotcom.lists.cftalk Sent: Friday, December 08, 2000 5:44 AM Subject: RE: Which message-board to get For a CF BBS, check out "Forums". It is now an open-Source project. http://www.forumspot.org/ Very nice - could be good. Is it me, or are ASP boards more in abundance than CF ones? Will ~~ 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 Variables over Clustered Servers?-WDDX?
Is session-aware LB a function of CF Enterprise and Cluster Cats or is this somethimg that can be implemented using WDDX? What I am unsure of is the nature of establishing the session initially in a clustered environment. For example user1 hits server1 in the cluster and then a session is established. For the second page request the LB sends user1 to server4. User1's session established on server1 is authenticated by 1) CF Enterprise? 2) Clsuter Cats? 3) both in concert with each other? Also, upon closing the browser how does each server know when the browser has been shut down so the session variables are deleted? If the browser is closed while user1 is on server4 how will server1 know this? Finally is there a primary server that sets all the session variables or can any server set them? What would one need to do to in either case? Thanks James McCullough -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 09, 2000 6:42 AM To: CF-Talk Subject: RE: Session Variables over Clustered Servers I was under the impression that session variables were stored in RAM on the server. Is it possible for a session variable to persist moving from one server in a cluster to another? Your impression is correct. Session variables are specific to a single physical server, and will not persist across servers within a cluster. However, you can use session variables within a clustered application, as long as the cluster is using session-aware load balancing, which directs a user's initial request to a server, and all subsequent requests from that user to the same server. 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: BULK INSERT - Access or ODBC incompatibility?
Hi! Thanks for all the help!! I don't quite understand how you did this. Did you create a custom tag, or did you just map an administrator's password? If you used a custom tag, how did you pass the local file? TIA, _ Michael Gagnon - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 4:10 PM Subject: Re: BULK INSERT - Access or ODBC incompatibility? Here are some issues I ran into recently: 1. BULK INSERT has to run under a sysadmin account. For my user, I setup a CFAS mapping to a template my user could not access. The CFQUERY in THAT template had the BULK INSERT in it and have sysadmin access. 2. If you CFINCLUDE something like the following: cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#" PASSWORD="#pass#" BULK INSERT jobsINITIAL FROM '#File.ServerDirectory#\#FILE.ServerFile#' WITH ( FIELDTERMINATOR='|', ROWTERMINATOR=' ' ) /cfquery it will fail You need to change ROWTERMINATOR=' ' to ROWTERMINATOR='#chr(13)##chr(10)#' HTH best, paul PS 3. You cannot have a Identity column in the table you're inserting to. And the number and kind of columns in the table must exactly match that in the CSV file. (I think BCP can work-around these - but I don't know its use) At 12:23 PM 12/8/00 -0400, you wrote: Hi! I am using the SQL7's "BULK INSERT", but I get the following error: ~~ 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: Cfloop Output Question
Put the two tables inside a one row two cell table. tabletrtd...output for first table.../td td..output for second table.../td/tr/table Chris --- Christopher P. Maher mailto:[EMAIL PROTECTED] Maher Associates, Inc. Actuarial and Computer Consulting http://www.maherassociates.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 7:28 PM To: CF-Talk Subject: Cfloop Output Question Ok, what I want to do is output a query to two tables side by side. Now i tried this but it doesn't quite work well. Any suggestions? cfquery datasource="data" name="information" SELECT * FROM Table /cfquery cfset firstrow = #information.RecordCount# / 2 cfset secondrow = (#information.RecordCount# / 2) + 1 cfloop query="information" startrow="1" endrow="#FirstRow#" output table /cfloop cfloop query="information" startrow="#SecondRow#" endrow="#information.RecordCount#" output table /cfloop 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
Structured Exception Handling
Now that we've covered the Request Scope. What exactly is Structured Exception Handling? It's listed in the docs as 'new in CF 4.5' but I cannot find any other information about it. Since I have limited experience with error handling in version 4.0 and no experience with any versions prior to that, I'm not sure they are referring to. From the docs: /CFDOCS/Using_ColdFusion_Studio/00_Welcome_to_ColdFusion_Studio/preface5.htm Structured Exception Handling -- Exception handling now offers hierarchical exception handling that supports both greater customization and greater access to internal exceptions. Are they referring to a new use of the CFTHROW/CFCATCH/CFTRY tags? Are any of the previous tags new to version 4.5? -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~ 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: Structured Exception Handling
The new "Structured" exception handling allows you to set up a "global" error handler (in your Application.cfm file) that is triggered for "errors and/or exceptions". You can specify an error template that will have access to all the CF tags/functions in addition to the "standard" error messages that will be triggered by both "regular" errors, and/or errors "caught" by CFTRY/CFCATCH. umm... maybe my (8 page) explanation at chfub is better? http://cfhub.com/advanced/error_handling/ What exactly is Structured Exception Handling? It's listed in the docs as 'new in CF 4.5' but I cannot find any other information about it. ~~ 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
how to teach arrays and structures
Hi, I need some good examples and explanations on how to teach coldfusion arrays and structures. maybe some drawings or illustrations. Please send any examples to [EMAIL PROTECTED] Thanks Martin -- Martin Orth - CFSOLUTIONS Oberblissenbach 30 - 51515 Kuerten Tel. 02207 700650 - [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
how to teach nested custom tags
Hi, I need some good examples and explanations on how to teach nested custom tags. Maybe some drawings or illustrations. Please send any examples to [EMAIL PROTECTED] Thanks Martin -- Martin Orth - CFSOLUTIONS Oberblissenbach 30 - 51515 Kuerten Tel. 02207 700650 - [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: Structured Exception Handling
Cool site, I didn't know of the cfhub site. Thanks. Although, I'm curious what is different in those pages than something I would have been able to implement in CF 4.0. Did the CFERROR tag not exist in previous versions? What makes error handling 'structured' vs 'unstructured'? Or am I just being way too anal about terminology? Joseph Thompson wrote: The new "Structured" exception handling allows you to set up a "global" error handler (in your Application.cfm file) that is triggered for "errors and/or exceptions". You can specify an error template that will have access to all the CF tags/functions in addition to the "standard" error messages that will be triggered by both "regular" errors, and/or errors "caught" by CFTRY/CFCATCH. umm... maybe my (8 page) explanation at chfub is better? http://cfhub.com/advanced/error_handling/ What exactly is Structured Exception Handling? It's listed in the docs as 'new in CF 4.5' but I cannot find any other information about it. ~~ 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: Cfloop Output Question
Well my question was how can i split up the query so it will output the data dynamically. kev ~~ 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: Structured Exception Handling
Now the CFERROR tag allows you to specify a template that can actually "Run" Cold Fusion tags and functions. This is not the case for the 4.0 version of the tag. In previous versions you are limited to these "variables" Standard CFERROR variables: Error.Diagnostics Error.MailTo Error.DateTime Error.Browser Error.RemoteAddress Error.HTTPReferer Error.Template Error.QueryString I guess what makes it "Structured" is the fact that you can specify the "exception" you want to handle? Cool site, I didn't know of the cfhub site. Thanks. Although, I'm curious what is different in those pages than something I would have been able to implement in CF 4.0. Did the CFERROR tag not exist in previous versions? What makes error handling 'structured' vs 'unstructured'? Or am I just being way too anal about terminology? Joseph Thompson wrote: The new "Structured" exception handling allows you to set up a "global" error handler (in your Application.cfm file) that is triggered for "errors and/or exceptions". You can specify an error template that will have access to all the CF tags/functions in addition to the "standard" error messages that will be triggered by both "regular" errors, and/or errors "caught" by CFTRY/CFCATCH. umm... maybe my (8 page) explanation at chfub is better? http://cfhub.com/advanced/error_handling/ What exactly is Structured Exception Handling? It's listed in the docs as 'new in CF 4.5' but I cannot find any other information about it. ~~ 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
Access ODBC error
Hello everyone i am using the free CF hosting at CFresources, so i'm accessing the thing through an FTP account. Presumabley the ODBC datasource has been set for me. Yet when i run a simple insert or select * i get this error - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'SOFTWARE\ODBC\ODBC.INI\MYDB'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:58). -- This leads me to think it has not been specified correctly in the datasource, which might be difficult because they are a bit hard to get a hold of by email, guess it gets kind of busy over there. Any one shed some light on this for me? Thanx in advance War-Ape ~~ 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
test: do not respond
test ~~ 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
Rather OT: virus question (Snow White)
I have recieved a virus, twice now, in my work E-mail. I don't use that work E-mail for much of anything, except these CF lists and a few other contacts. Anything business related is usually handled through 'support'. I was wondering if anyone else here had recieved it. It's some stupid thing about Snow White and the REAL story behind the Seven Dwarves. The headers are *completely* forged, so it's tough to figure out where it is coming from. If anyone else on this list recieved it, then it would help me greatly if you could send me any info., and could tell me where someone got my work address to send it to, otherwise, sorry for the OT post. Todd Ashworth ~~ 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: Rather OT: virus question (Snow White)
As you may have notices, the list(s) do not allow attachments, HTML or anything else other than plain text. In the past, we've had .exe attachments sent to the list that were disabled down to text, HTML viruses rendered useless and more. In the last week or two, a new system was put into place that TOTALLY removes all of this 'garbage' and only shows plain text no matter what the original sender posted. Basically, you can't get a virus from the list. Besides all that, I've never seen a post like that. I have recieved a virus, twice now, in my work E-mail. I don't use that work E-mail for much of anything, except these CF lists and a few other contacts. Anything business related is usually handled through 'support'. I was wondering if anyone else here had recieved it. It's some stupid thing about Snow White and the REAL story behind the Seven Dwarves. The headers are *completely* forged, so it's tough to figure out where it is coming from. If anyone else on this list recieved it, then it would help me greatly if you could send me any info., and could tell me where someone got my work address to send it to, otherwise, sorry for the OT post. Todd Ashworth ~~ 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: CFX versus CF tag
A quick definition would be: A cfx tag points to a .dll file (usually compiled from a C++ program) A CF tag ponts to a "plain old .cfm" file that just happens to live in the CFUSION/CustomTags/ folder (or any subdirectory below that) I have a "skookum" custom tag definition here as well. http://cfhub.com/advanced/customtags/ If you get a chance to talk to Mr. Sellers, or visit his page, you may learn more about CFX tags.] http://www.intrafoundation.com/freeware.html Good Day, Does anyone know the difference between the CFX and CF when referring to a custom Tag? Is there a difference and what it is? Thanks for any help, Robert ~~ 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: How can I use CF to push data into a statistical package or an Ex cel spreadsheet?
Rick,
Thanks for the attached.
I've had some time now to study this code and I have a few questions, if you
don't mind.
1.) What is the included template "_ext2attr.cfm"? Is it possible to get a
copy of it as well? Or do I need it?
2.) How do you invoke this custom tag of yours? I see the following:
CFSET CellName="vr#Row#c#Col#" which is soon followed by
CFSET Range.Value=Attributes[CellName]
Does that mean that there are arguments to your custom tag like
vr1c1="xxx" vr1c2="yyy"
etc. etc. for each data point that should be included in the
doughnut chart?
Or is this what the ext2attr.cfm template is all about?
I hope you don't mind my asking you these questions and that they are not
too much of an imposition. But the answers would sure help.
Thanks in advance,
-- Tim Dempsey
- Original Message -
From: "Rick Osborne [Mojo]" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, December 04, 2000 8:17 PM
Subject: RE: How can I use CF to push data into a statistical package or an
Ex cel spreadsheet?
Tim Dempsey asked:
How do I take that data and get it into Excel on the client's machine?
We had to do something like this last month (with Doughnut charts instead
of
Pie charts, but it's close enough). I never could get it to work 100% in
CF, as Excel wouldn't honor my Quit() command and would just stay open,
leaving lots of little zombies all over the place. However, on a whim I
translated it into Perl and got it to work that way. (And, oddly enough,
the Perl version is *much* easier on the eyes, for once.)
Anyway, I apologize for the minimal documentation, but this was really
just
a quick hack for me. YMMV and all that. If you ever figure out the
Quit()
problem, let me know. I'd love to know what I'm doing wrong. Also, if
you
want the (working) Perl version, let me know and I'll send it via separate
channels (as I figured I'd get flamed 'til the end of time if I posted
Perl
to this list). It's much smarter and does things like palette conversion
(so that you aren't stuck with Excel's default colors), and other neat-o
tricks.
-R
CFSETTING ENABLECFOUTPUTONLY="YES" SHOWDEBUGOUTPUT="No"
!---
graph/doughnut.cfm
---
!---
Constants
---
CFSET xlWorksheet=-4167
CFINCLUDE TEMPLATE="../../include/_ext2attr.cfm"
CFPARAM NAME="Attributes.Height" DEFAULT="200"
CFPARAM NAME="Attributes.Width" DEFAULT="200"
CFPARAM NAME="Attributes.Rows" DEFAULT="0"
CFPARAM NAME="Attributes.Cols" DEFAULT="0"
CFPARAM NAME="Attributes.Title" DEFAULT=""
CFPARAM NAME="Attributes.Legend" DEFAULT="0"
CFPARAM NAME="Attributes.Type" DEFAULT="gif"
CFSET Attributes.Height=Attributes.Height*0.74999
CFSET Attributes.Width=Attributes.Width*0.74999
CFSET FileName=""
CFTRY
CFTRY
CFOBJECT ACTION="CONNECT" TYPE="COM" CLASS="Excel.Application"
NAME="App"
CFCATCH
CFOBJECT ACTION="CREATE" TYPE="COM" CLASS="Excel.Application"
NAME="App"
/CFCATCH
/CFTRY
CFSET Workbooks=App.Workbooks
CFSET Workbook=Workbooks.Add(xlWorksheet)
CFLOOP COLLECTION="#Workbook.WorkSheets#" ITEM="Sheet"
CFLOOP FROM="1" TO="#Attributes.Rows#" INDEX="Row"
CFLOOP FROM="1" TO="#Attributes.Cols#" INDEX="Col"
CFSET ColLetter=Chr(Col + Asc('A') - 1)
CFSET CellName="vr#Row#c#Col#"
CFIF StructKeyExists(Attributes,CellName)
CFSET Range=Sheet.Range("#ColLetter##Row#")
CFSET Range.Value=Attributes[CellName]
/CFIF
/CFLOOP
/CFLOOP
CFSET ColLetter=Chr(Attributes.Cols + Asc('A') - 1)
CFSET SourceRange=Sheet.Range("A1:#ColLetter##Attributes.Rows#")
CFSET ChartObjects=Sheet.ChartObjects()
CFSET Chart=ChartObjects.Add(0,0,Attributes.Width,Attributes.Height)
CFSET Donut=Chart.Chart
CFSET Donut.ChartWizard(SourceRange, -4120, 1, 2, 1, 0)
CFSET Series=0
CFLOOP FROM="1" TO="#DecrementValue(Attributes.Cols)#"
INDEX="Series"
CFSET Ser=Donut.SeriesCollection(Series)
CFSET Ser.HasDataLabels=0
CFLOOP FROM="1" TO="#Attributes.Rows#" INDEX="Row"
CFSET Cellname="c_#Series#_#Row#"
CFIF StructKeyExists(Attributes,CellName)
CFSET CellColor=Attributes[CellName]
CFOUTPUTPResetting color #CellColor#/P/CFOUTPUT
CFIF Left(CellColor,1) IS "##"
CFSET CellColor=InputBaseN(Mid(CellColor,6,2)
Mid(CellColor,4,2) Mid(CellColor,2,2),16)
/CFIF
CFSET Point=Ser.Points(Row)
CFSET Interior=Point.Interior
CFSET Interior.Color=CellColor
/CFIF
/CFLOOP
/CFLOOP
CFIF Attributes.Title IS ""
CFSET Donut.HasTitle=0
CFSET PlotArea=Donut.PlotArea
CFSET PlotArea.Top=0
CFSET PlotArea.Left=0
CFSET PlotArea.Height=Attributes.Height-8
CFSET PlotArea.Width=Attributes.Width-8
CFELSE
CFSET Donut.HasTitle=1
CFSET ChartTitle=Donut.ChartTitle
Re: Rather OT: virus question (Snow White)
I know this .. but I was more concerned with where my E-mail address was obtained to send it to me. I'm not blaming the lists, but considering how I haven't even gotten a single piece of spam on this address since I've had it (2 years) .. it makes me wonder. I just figured I would look to a place where I have more exposure than anywhere else, first. Todd Ashworth - Original Message - From: "Michael Dinowitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 6:59 PM Subject: Re: Rather OT: virus question (Snow White) As you may have notices, the list(s) do not allow attachments, HTML or anything else other than plain text. In the past, we've had .exe attachments sent to the list that were disabled down to text, HTML viruses rendered useless and more. In the last week or two, a new system was put into place that TOTALLY removes all of this 'garbage' and only shows plain text no matter what the original sender posted. Basically, you can't get a virus from the list. Besides all that, I've never seen a post like that. ~~ 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: CFGRID applet not loading in browser
Sometimes (usually?) you need to physically copy the CFIDE/Classes folder from your CFUSION directory into your webroot. Worst case... you may need to unzip them too : ) If you have an FTP Server, I can upload the unzipped folder to your server. (5 MB) I say unzipped because untill I unzipped it I couldn't get netscape to recognize the "java" class files?? email me off-list with a user/pass/port for your server and I'll send them up for you. Hi, am having problems with CFGRID tables showing up in a browser. Apparently the java class files are not loading. Anyone know what might be causing the problem? Thanks. ~~ 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: Rather OT: virus question (Snow White)
I'm sorry if I misled you. They were TO her business email address rather than from. You're right - the headers are forged. But the address they came to is her personal correspondence address. So someone she corresponds directly with has the virus. It seems to be one that sends itself from the address book of the infected parties. Dave - Original Message - From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 8:55 PM Subject: Re: Rather OT: virus question (Snow White) How do you know it came from her E-mail address? All of my headers have been so forged that it's been impossible to tell where the mail came from. All I get, besides my own mail server's info, is that the mail came from "Laptop". Todd Ashworth - Original Message - From: "David Hannum" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 7:15 PM Subject: Re: Rather OT: virus question (Snow White) Yea, I've gotten the virus post you speak of, but not at my list email addy. It's been coming from my wife's business email address. Lots of her customers have her in their address books. It contains an executable called "Joke.exe". Peter Norton take care of it for me. Dave - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 6:59 PM Subject: Re: Rather OT: virus question (Snow White) As you may have notices, the list(s) do not allow attachments, HTML or anything else other than plain text. In the past, we've had .exe attachments sent to the list that were disabled down to text, HTML viruses rendered useless and more. In the last week or two, a new system was put into place that TOTALLY removes all of this 'garbage' and only shows plain text no matter what the original sender posted. Basically, you can't get a virus from the list. Besides all that, I've never seen a post like that. I have recieved a virus, twice now, in my work E-mail. I don't use that work E-mail for much of anything, except these CF lists and a few other contacts. Anything business related is usually handled through 'support'. I was wondering if anyone else here had recieved it. It's some stupid thing about Snow White and the REAL story behind the Seven Dwarves. The headers are *completely* forged, so it's tough to figure out where it is coming from. If anyone else on this list recieved it, then it would help me greatly if you could send me any info., and could tell me where someone got my work address to send it to, otherwise, sorry for the OT post. Todd Ashworth ~~ 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 EJB mailing list
Hi all, I just started a mailing list for CF/EJB people. To join, send a blank msg. to: [EMAIL PROTECTED] See you there, laszlo ~~ 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 EJB mailing list
Not me man. Beans give me gas! - Original Message - From: Laszlo Nadai [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 11:31 PM Subject: CF EJB mailing list Hi all, I just started a mailing list for CF/EJB people. To join, send a blank msg. to: [EMAIL PROTECTED] See you there, laszlo ~~ 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
Find() vs REFind()
What's the difference between Find() and REFind()? Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ 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: Find() vs REFind()
REFind uses Regular Expressions to do the search and is more powerful while Find does a simply character search. According to my article REFind is slightly slower, but only by like .03 milliseconds. Nothing to ever worry about. :) http://www.fusionauthority.com/alert/index.cfm?alertid=4#Tech2 What's the difference between Find() and REFind()? Bernd VanSkiver [EMAIL PROTECTED] ICQ #: 916324 ~~ 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 EJB mailing list
No, EJB's are not beans :-) laszlo David Hannum wrote: Not me man. Beans give me gas! - Original Message - From: Laszlo Nadai [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 11:31 PM Subject: CF EJB mailing list Hi all, I just started a mailing list for CF/EJB people. To join, send a blank msg. to: [EMAIL PROTECTED] See you there, laszlo ~~ 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
short circuiting in cf4.x+
Question. cf4.x does support conditional short circuiting, correct?
ie,
CFIF IsDefined("Cookie.toggleURL") AND Cookie.toggleURL IS false
should evaluate the first part, and then only evaluate the later half if
the first is logically true.
I'm getting some random reports that make me wonder if this is broken in
some version of cf. Hrmm...
--min
~~
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: short circuiting in cf4.x+
Works fine in 4.01. What's a "random report"?
- Original Message -
From: "lsellers" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, December 09, 2000 10:41 PM
Subject: short circuiting in cf4.x+
Question. cf4.x does support conditional short circuiting, correct?
ie,
CFIF IsDefined("Cookie.toggleURL") AND Cookie.toggleURL IS false
should evaluate the first part, and then only evaluate the later half
if
the first is logically true.
I'm getting some random reports that make me wonder if this is broken in
some version of cf. Hrmm...
--min
~~
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 trickery .. it's too smart for me!
I'm having a problem sending emails from a page.I can send one page, and sometimes I can send two, but not always. Here's the setup... User fills out a form and I want to send myself an advice to act on, and send the user a confirmation email. If I type the addresses in both CFMAIL tags to be [EMAIL PROTECTED] all's well and good and I get both emails arrive here. If I put any other email address in the second email that email fails. If I cut the CFMail tag from the working CFMAIL and paste it into the non-working one, it now works. Good. Then I change nothing but the email address and it stops working again. I've tried this address as a variable, and as just typing an email address into the template. If they're both the same addresses, fine, if they're different no. Here's the relevant bits of the action page: !--- Set up the connections for the email --- !--- Trim the spaces out of the user's email address from the form --- cfset destination = "#trim(currentemail)#" !--- Send email to applicant --- cfmail to="#destination#" from="[EMAIL PROTECTED]" subject="Subject of the form" server="server ip address" Thanks for filling out the form We will be evaluating your request in the next 24-48 hours and will send you an email to confirm the outcome yada yada yada .. What you filled out was: Name: #YourName# Your Email Address: #destination# Variables from the form: #connection# #connection2# /cfmail !--- Send email to webmaster --- cfinclude template="webmasteremail.cfm" cfmail to="[EMAIL PROTECTED]" from="[EMAIL PROTECTED]" subject="Subject of the form" server="server ip address" #YourName# came to the site and filled out the request form. Please respond as soon as possible. The details are as follows: Name: #YourName# User's Email Address: #destination# Variables from the form: #connection# #connection2# /cfmail !--- Show thanks page. --- !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titlePage title/title /head body Thanks for being a nice guy. /body /html I have been looking at this damn thing so long I can't see the wood for the trees any more. Anyone see what I've got wrong? Mike Kear [EMAIL PROTECTED] www.afp.zip.com.au Windsor, NSW, Australia AFP Web Development AFP Electronic Forms AFP Models ~~ 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: short circuiting in cf4.x+
Short circuited boolean evaluation was introduced in CF 4.01.
Question. cf4.x does support conditional short circuiting, correct?
ie,
CFIF IsDefined("Cookie.toggleURL") AND Cookie.toggleURL IS false
should evaluate the first part, and then only evaluate the later half
if
the first is logically true.
I'm getting some random reports that make me wonder if this is broken in
some version of cf. Hrmm...
--min
~~
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: BULK INSERT - Access or ODBC incompatibility?
Michael: If you have access to the machine and are a sysadmin there's no problem. You don't need to go to the trouble below. However, assuming you are using an ISP, THEY can create a CFAS mapping for you, I'll call it "CFmapping", that points to a location that cannot be seen by their web server, or by you if you have FTP access. Then they can put the CF template there (like the one below, I'll call it "qry_BulkInsert.cfm") with the CFQUERY set with a sysadmin account and know you won't be able to see the template, the directory structure, account name, or password. YOU can then CFINCLUDE that template in YOUR application: CFINCLUDE TEMPLATE="/CFmapping/qry_BulkInsert.cfm" and you're home free. best, paul At 02:44 PM 12/9/00 -0400, you wrote: Hi! Thanks for all the help!! I don't quite understand how you did this. Did you create a custom tag, or did you just map an administrator's password? If you used a custom tag, how did you pass the local file? TIA, _ Michael Gagnon - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 08, 2000 4:10 PM Subject: Re: BULK INSERT - Access or ODBC incompatibility? Here are some issues I ran into recently: 1. BULK INSERT has to run under a sysadmin account. For my user, I setup a CFAS mapping to a template my user could not access. The CFQUERY in THAT template had the BULK INSERT in it and have sysadmin access. 2. If you CFINCLUDE something like the following: cfquery name="InsertInitial" DATASOURCE="#DSN#" USERNAME="#user#" PASSWORD="#pass#" BULK INSERT jobsINITIAL FROM '#File.ServerDirectory#\#FILE.ServerFile#' WITH ( FIELDTERMINATOR='|', ROWTERMINATOR=' ' ) /cfquery it will fail You need to change ROWTERMINATOR=' ' to ROWTERMINATOR='#chr(13)##chr(10)#' HTH best, paul PS 3. You cannot have a Identity column in the table you're inserting to. And the number and kind of columns in the table must exactly match that in the CSV file. (I think BCP can work-around these - but I don't know its use) ~~ 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: Rather OT: virus question (Snow White)
Yea, I've gotten the virus post you speak of, but not at my list email addy. It's been coming from my wife's business email address. Lots of her customers have her in their address books. It contains an executable called "Joke.exe". Peter Norton take care of it for me. Dave - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 09, 2000 6:59 PM Subject: Re: Rather OT: virus question (Snow White) As you may have notices, the list(s) do not allow attachments, HTML or anything else other than plain text. In the past, we've had .exe attachments sent to the list that were disabled down to text, HTML viruses rendered useless and more. In the last week or two, a new system was put into place that TOTALLY removes all of this 'garbage' and only shows plain text no matter what the original sender posted. Basically, you can't get a virus from the list. Besides all that, I've never seen a post like that. I have recieved a virus, twice now, in my work E-mail. I don't use that work E-mail for much of anything, except these CF lists and a few other contacts. Anything business related is usually handled through 'support'. I was wondering if anyone else here had recieved it. It's some stupid thing about Snow White and the REAL story behind the Seven Dwarves. The headers are *completely* forged, so it's tough to figure out where it is coming from. If anyone else on this list recieved it, then it would help me greatly if you could send me any info., and could tell me where someone got my work address to send it to, otherwise, sorry for the OT post. Todd Ashworth ~~ 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
