CFFORM - Can I start using it again?
For a long time I never used the CFFORM controls because they tended to write bloated JavaScript and non-standards compliant code. I'm now upgrading to CF7, and am looking at all the new cool things with Flash forms and XForms, which all require CFFORM. So, my basic questions are, is CFFORM safe to use again? Are people using it for non-Rich/XForm code? Is the JavaScript better? etc. etc I'm curious what people's experiences with it are. Thanks, Evan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFORM - Can I start using it again?
Right, I'm not thinking about the server side validation, but more about the client-side validation that various CFFORM tags write (CFINPUT, CFSELECT, etc.) How does this JavaScript fare from a browser-compatibility and standards-compliance perspective? Is it the same old bloated code that CF used to write, or has it been dramatically improved? Thanks, Evan On 6/7/05, Calvin Ward [EMAIL PROTECTED] wrote: In particular I wouldn't rely on the serverside validation option as it requires client side code to trigger the validation, which of course defeats one purpose of true server side validation (which is not to rely on the client). - Calvin On 6/7/05 9:24 AM, Evan Lavidor [EMAIL PROTECTED] wrote: For a long time I never used the CFFORM controls because they tended to write bloated JavaScript and non-standards compliant code. I'm now upgrading to CF7, and am looking at all the new cool things with Flash forms and XForms, which all require CFFORM. So, my basic questions are, is CFFORM safe to use again? Are people using it for non-Rich/XForm code? Is the JavaScript better? etc. etc I'm curious what people's experiences with it are. Thanks, Evan ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfcontent and ssl/https issue
I have a form that resides on an SSL site.It submits to another SSL page and after inserting the data into our SQL Server db (via cfstoredproc), it does a cfcontent to display a pdf, using the following: cfset variables.pdf_to_display = Request.fileRoot \ variables.filepath \ variables.filename cfcontent type=application/pdf deletefile=no file=#variables.pdf_to_display# In Mozilla, this works great.In IE, the user just gets a blank white screen, rather than the PDF. I've seen various postings on google groups, etc. regarding this, but no solution suggested (besides modifying a setting in IE, which is really not feasible for a public Web site).Does anyone know if there is a solution, or whether this is just a known issue? I could redirect users to a non-ssl page after the form submission, but then the user gets a security prompt...I'm not sure there's a great solution here, so if anyone has any ideas I'd greatly appreciate it. Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent and ssl/https issue
Hi Barney, Thanks for the suggestion.When I do that, then the user is prompted to open or save the file (and opening doesn't work - at least from IE), as opposed to simply using the acrobat plugin to open the file in the user's browser. I'd like it to function just like linking to a PDF would. Thanks, Evan Throw a CFHEADER tag in there: cfheader name=Content-Disposition value=attachment; filename=#variables.filename# / cfcontent file=#variables.pdf_to_display# type=application/pdf deletefile=false reset=true /cfabort / Not sure if that'll solve your problem, but that's how we always do it, and haven't ever had issues. cheers, barneyb On Mon, 26 Jul 2004 13:06:35 -0400, Evan Lavidor [EMAIL PROTECTED] wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent and ssl/https issue
Thanks for the suggestion.inline produces the same effect as I was seeing originally.Namely, the PDF doesn't display.If I take the SSL out of the equation, everything works fine. If anyone has any other ideas, I'd be most grateful. Thanks, Evan try changing attachement to inline in the CFHEADER tag. cheers, barneyb On Mon, 26 Jul 2004 14:25:06 -0400, Evan Lavidor [EMAIL PROTECTED] wrote: Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent and ssl/https issue
Nope, I'm not using any cfheader or meta tags to control caching. I've actually built a simple page that includes very little content.Even hard-coding the path to the PDF rather than building it from db values, just to limit the number of unknowns. Thanks, Evan Are you using CFHEADER NAME=cache-control VALUE=no-cache, no-store, must-revalidate or similar on the site? I found I had to overide that on document downloads to overcome what I assume is a bug in IE. Once done it worked perfectly for me. Mine is setup as barneyb noted with attachment or inline in the cfheader based on user preference for download prompts or automatic inline viewing. Ken -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 4:00 PM To: CF-Talk Subject: Re: cfcontent and ssl/https issue Thanks for the suggestion.inline produces the same effect as I was seeing originally.Namely, the PDF doesn't display.If I take the SSL out of the equation, everything works fine. If anyone has any other ideas, I'd be most grateful. Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Looking for a team collaboration website package
I'm on the hunt for (for a client) an off-the-shelf team collaboration website package that I can host and make minor modifications to, if necessary. At a minimum, I'm looking for something with threaded discussion lists, document sharing, and calendaring. I know I could assemble something from pieces of other code (purchased or home-grown) but there's a desire by bosses to have this be an integrated package that we can host and maintain. Does anyone know of any good packages? Thanks very much in advance. Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking for a team collaboration website package
We have, though my understanding of Groove is that it's an installed app (am I wrong here?), and we'd prefer not to have to deal with desktop support issues and stick with a Web-based tool. This is really going to be targeted to marketing/client services types, and not to developers. Thanks, Evan Have you thought about www.groove.net? Dwayne Cole, MS in MIS, MBA Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge -- Original Message -- From: Evan Lavidor [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 26 Feb 2004 10:11:47 -0400 I'm on the hunt for (for a client) an off-the-shelf team collaboration website package that I can host and make minor modifications to, if necessary. At a minimum, I'm looking for something with threaded discussion lists, document sharing, and calendaring. I know I could assemble something from pieces of other code (purchased or home-grown) but there's a desire by bosses to have this be an integrated package that we can host and maintain. Does anyone know of any good packages? Thanks very much in advance. Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
String Format option in DataSource Setup
We recently ran into a problem (CFMX, SQL 2000, Win2K) where unicode data being passed into a cfstoredproc was not getting into the db as double-byte. This was resolved (after much hunting) by checking the String Format checkbox in the advanced datasource settings for the DSNs involved. >From the CFMX documentation, one should enable this check box if your application uses Unicode data in DBMSspecific Unicode datatypes such as National Character or nchar. I'm wondering if anyone knows what is/whether there is any significant performance decrease associated with having this option enabled.There are some people I'm working with who are thinking that it'd be valuable to have this box checked on some of our DSNs that don't currently need unicode support, but may in the not-so-near future. Does anyone have any knowledge/experience with this option? Thanks very much, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Client vars won't go into the db....?
Nope, trusted cache is not set. Thanks, Evan Hmm, nother long shot.Do you have the trusted cache set to yes?It migth be remembering an old setting? DRE -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 11:45 AM To: CF-Talk Subject: Re:Client vars won't go into the db? Yep.I'm sure that there's only one application.cfm, and that the cfapplication tag is not specifying a location with the clientstorage parameter. I also have a DSN specified as the default storage location for client vars in CF admin. Yet, I'm still seeing client vars show up under HKLM\Software\Allaire\CurrentVersion\Clients. Any ideas are much apprecaited. Thanks, Evan Are you absolutely sure you have only one application.cfm? DRE -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 9:16 AM To: CF-Talk Subject: Re:Client vars won't go into the db? ...and a as followup, client variables on our MX servers are also showing up in the registry, even though we've got the settings in CF Admin specifying the default location being a datasource. Any help is greatly appreciated. Thanks, Evan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Client vars won't go into the db....?
Yep.I'm sure that there's only one application.cfm, and that the cfapplication tag is not specifying a location with the clientstorage parameter. I also have a DSN specified as the default storage location for client vars in CF admin. Yet, I'm still seeing client vars show up underHKLM\Software\Allaire\CurrentVersion\Clients. Any ideas are much apprecaited. Thanks, Evan Are you absolutely sure you have only one application.cfm? DRE -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 9:16 AM To: CF-Talk Subject: Re:Client vars won't go into the db? ...and a as followup, client variables on our MX servers are also showing up in the registry, even though we've got the settings in CF Admin specifying the default location being a datasource. Any help is greatly appreciated. Thanks, Evan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client vars won't go into the db....?
So, while most of the CF apps/sites at my office are running on CFMX, we've still got a few servers that are running CF4.5...I know how wrong this is, and we're on the path to migrate them.However, a problem has arisen that I'm wondering if anyone has any insight to: We recently changed the client variable storage from the registry to a data source - not sure why it was ever the registry to begin with :-) We've made the updates in CF admin (set up the db, the dsn, assigned it as the default client variable store), but there's no client vars being written to the db, and new ones are being written to the registry under HKLM\Software\Allaire\CurrentVersion\Clients. Does anyone have any ideas/insights here?We've restarted CF on the servers in question, and I'm sure that none of the cfapplication tags are not specifying the registry as their storage point.They're just using the default. Many thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Client vars won't go into the db....?
...and a as followup, client variables on our MX servers are also showing up in the registry, even though we've got the settings in CF Admin specifying the default location being a datasource. Any help is greatly appreciated. Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem passing empty value to cfargument if type isn't string
I've got a function inside of a CFC.One of the arguments is defined as follows: cfargument name=promoItem type=numeric required=no If the value that I pass to it is empty () then I get an error that The argument PROMOITEM passed to function processInfo() is not of type numeric. If I change the type to string, then it works great.But I don't want it to be a string.The same behavior happens with a date (passing blank string to an argument of type=date). Any ideas?This is really strange behavior to me.As CF is typeless, shouldn't it be converting the empty string to a null number - or something like that? Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Problem passing empty value to cfargument if type isn't string
Yeah, that's what I've ended up doing.That seems silly though, because then I have to add some code to handle a default value that I don't want. If CF is typeless, and the argument isn't required, then IMHO it shouldn't throw an error if you pass it an empty var - especially since (I believe) you can't set a variable explicitly to NULL. Thanks, Evan You'll have to try something liske this: cfargument name=promoItem type=numeric required=no default=-1 --- Exciteworks -- expert hosting for less! http://exciteworks.com specializing in reseller accounts Evan Lavidor wrote: I've got a function inside of a CFC.One of the arguments is defined as follows: cfargument name=promoItem type=numeric required=no If the value that I pass to it is empty () then I get an error that The argument PROMOITEM passed to function processInfo() is not of type numeric. If I change the type to string, then it works great.But I don't want it to be a string.The same behavior happens with a date (passing blank string to an argument of type=date). Any ideas?This is really strange behavior to me.As CF is typeless, shouldn't it be converting the empty string to a null number - or something like that? Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client Variables and Uniqueness in a Load-Balanced Server Environment
(Not sure if this went through yesterday in the midst of virus-related stuff, so forgive me if this is a double-post). I should know the answer to this, but I want to make sure that I'm thinking this through correctly. I have websites running on load balanced web servers (one group running CFMX, one group running CF4.5 (which won't be around much longer - it's being migrated to MX)).I want to move the client variables to a datasource instead of the registry so that we can actually start using them if we want to. I assume that all web/CF servers should be pointing to the same db for their client variable storage (my plan was to point all MX servers to one db and all 4.5 servers to a second db).This is correct, yes? If this does happen, is there a risk that two servers will generate the same CFID and CFTOKEN values for two separate users?Should I therefore be checking the Use UUID for cftoken setting in the Settings section in the CF admin (on the MX servers)?I found the following technote (http://www.macromedia.com/support/coldfusion/ts/documents/tn18133.htm), which I assume takes care of this problem for 4.5 servers. Any help/advice here is greatly appreciated.I've done some searching on MACR's website and while I've found some documentation on the issue, I haven't found any really clear best practices described. Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client Variables Question
I should know the answer to this, but I want to make sure that I'm thinking this through correctly. I have websites running on load balanced web servers (one group running CFMX, one group running CF4.5 (which won't be around much longer - it's being migrated to MX)).I want to move the client variables to a datasource instead of the registry so that we can actually start using them if we want to. I assume that all web/CF servers should be pointing to the same db for their client variable storage (my plan was to point all MX servers to one db and all 4.5 servers to a second db).This is correct, yes? If this does happen, is there a risk that two servers will generate the same CFID and CFTOKEN values for two separate users?Should I therefore be checking the Use UUID for cftoken setting in the Settings section in the CF admin (on the MX servers)? Any help/advice here is greatly appreciated.I've done some searching on MACR's website and while I've found some documentation on the issue, I haven't found any really clear best practices described. Thanks, Evan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
About to call Macromedia Tech Support on this one...
The following is an error we see in our webserver.log quite a bit: ERROR,TID=3580,02/27/02,10:23:38,Error attempting to write location redirection to web server (Windows NT error number -2147467259 occurred) I'm personally convinced that this is related to some other problems we're having, but that's another story. I'm wondering if anyone has seen this error before/has any clue of where to start looking to resolve it. I've looked on TechNet and MS Support pages for the error number, but it appears to be one of Win2K's generic error messages that apply to many situations, none of which seem to apply to our environment. We're using Win2K Server, CF 4.5 with all patches, SQL Server 2000. Database servers and web/CF servers are separate boxes. All part of the same domain. The interesting thing to me is that this shows up in webserver.log, not application.log or server.log. Any help or thoughts on this is much appreciated. Thanks, Evan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Can CFRegistry read another computer's info?
Assuming CF has permissions to access another system, can CFRegistry read the info from another system's registry? If so, what's the syntax? Using CF 4.5, not 5.0. Thanks! Evan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get 404 referrer
The CGI variable is CGI.HTTP_REFERER (note that it's not spelled the way you want to spell it if you were spelling correctly). If you spell it the way you have below, I don't think CF will throw an error, it just returns a blank value. HTH, Evan -Original Message- From: Steven Douglas [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 9:44 AM To: CF-Talk Subject: Get 404 referrer Hello, I'm trying to capture the http referrer from a 404 page. In the cfadmin I have a page set up to handle the 404, and in the source of that page I am outputting cgi.http_referrer but it comes up blank in both ie and netscape. Is there any other way to capture the referring page, or is cf doing something weird when a 404 is encountered. Any help is appreciated. Thanks! -Steven ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom 404 Question
I have a custom 404 page that I've got set up as the default missing template handler in CF admin, and as the custom 404 in IIS. I also have a mapping set up in CF Admin named /includes In the template that is my 404 page, I'm trying to do a cfinclude in the following manner: cfinclude template=/includes/includepage.cfm figuring that since it's using a mapping it will accept it from anywhere it tries to run the page. However, the page chokes (404) on this cfinclude. If I take it out, the page runs fine. Can you not process cfinclude's on a 404? If you can, what am I doing wrong here? Thanks, Evan ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error 302 on cflocation?
I'm using RedHat Linux 7.1 and testing out CF5. I've recently done a fresh rebuild of my linux box, doing a server install without X. Pretty much everything is working without problems. Except one thing. Here's the scenario: 1. index.cfm -- login form which posts to login_verify.cfm 2. login_verify.cfm -- checks login credentials against the database and if okay cflocation's to frameset.cfm 3. frameset.cfm = content. When I fill out the form on index.cfm and post, I get the following: | HTTP/1.1 302 Found | Date: Thu, 23 Aug 2001 23:47:26 GMT | Server: Apache/1.3.19 (Unix) (Red-Hat/Linux) mod_ssl/2.8.1 OpenSSL/0.9.6 DAV/1.0.2 | PHP/4.0.4pl1 mod_perl/1.24_01 | Location: ./frameset.cfm | Connection: close | Content-Type: text/html; charset=iso-8859-1 | | Found | The document has moved a href=./frameset.cfmhere/a. | -- -- | Apache/1.3.19 Server at x.x.com Port 80 This happens in both IE and Netscape on my Win2K box. I've seen some discussion of this in the forums, but with no resolution that applies to my setup. Anyone have any ideas? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Documentation and numbers to back up best practices?
Partly out of curiousity and partly out of need, I'm wondering whether anyone has any ammunition for discussions about best practices. For example, things like: 1. lock shared variables 2. prefix variables with a scope 3. select only columns you need instead of select * 4. cfscript is faster than multiple cfset statements when there's more than 3 etc. Granted, these are not hard and fast rules (except #1), but everyone seems to accept them as the best or proper way to do things. I hear many (and I do this as well) use the phrase, according to Allaire Does anyone have any references that back things like this up? From Allaire, from personal experimentation, etc.? I'm looking for somewhat official information as opposed to I tried this once and The kind of stuff you could bring into a meeting and hand out and people would accept, you know? TIA for anything you can offer. Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with a cf_custom/cf_custom custom tag
1) Between your custom tags do the following... this is cfoutput#variables.mytest#/cfoutput Right, the original question was whether there was any way to avoid having to do this. Basically, I want the functionality that cfmail/cfmail has in being able to parse variables without cfoutput/cfoutput tags. Is this even possible? Thanks, Evan -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Saturday, 4 August 2001 6:15 AM To: CF-Talk Subject: RE: Help with a cf_custom/cf_custom custom tag I don't quite get it. Let's say I have this as the custom tag: cfif ThisTag.ExecutionMode IS END pbi#ThisTag.GeneratedContent#i/b/p cfset ThisTag.ExecutionMode = /cfif And my call to it is this: cfset variables.mytest = a test cf_mycustomtag this is #variables.mytest# /cf_mycustomtag This will give me: this is this is #variables.mytest# in bold and italic font. I want it to give me: this is a test in bold and italic font. Can I get that without having to nest it in a cfoutput or something? I'm thinking along the lines of cfmail, where it will automatically Evaluate variables inside it. Is that sort of functionality possible? Thanks, Evan -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 3:35 PM To: CF-Talk Subject: RE: Help with a cf_custom/cf_custom custom tag You don't have to. Once ThisTag.ExecutionMode is END all expressions (and tags) in the body will have been processed. You'll have access to the output via ThisTag.GeneratedContent. --- Ben -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:58 PM To: CF-Talk Subject: Help with a cf_custom/cf_custom custom tag I'm working with my first ColdFusion custom tag that's a tag pair. I've got it working mostly the way I'd like, but I've come up against something that I don't think I'm going to be able to do, but thought I'd ask anyway. Usage is going to be: cf_mycustomtag I'll have some text here which the tag will do something with. /cf_mycustomtag But what might be there is the following: cf_mycustomtag I'll have #variables.text# here which the tag will do something with. /cf_mycustomtag How can I get the tag to Evaulate the CF variables in between it. Can I? Seems like I'd first have to prefix it with the caller scope (which doesn't seem very doable even with RegEx) and then throw an Evaluate statement around it. Any ideas? Thanks, Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help with a cf_custom/cf_custom custom tag
That's what I was thinking, but am a little stuck on the regex to do that, any ideas? Thanks, Evan -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 04, 2001 1:17 PM To: CF-Talk Subject: RE: Help with a cf_custom/cf_custom custom tag Yes it is, but you would have to write the code to do this For example Search for the First # then the second # and between this do an evaluate on the variable found between them. -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Sunday, 5 August 2001 3:04 AM To: CF-Talk Subject: RE: Help with a cf_custom/cf_custom custom tag 1) Between your custom tags do the following... this is cfoutput#variables.mytest#/cfoutput Right, the original question was whether there was any way to avoid having to do this. Basically, I want the functionality that cfmail/cfmail has in being able to parse variables without cfoutput/cfoutput tags. Is this even possible? Thanks, Evan -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Saturday, 4 August 2001 6:15 AM To: CF-Talk Subject: RE: Help with a cf_custom/cf_custom custom tag I don't quite get it. Let's say I have this as the custom tag: cfif ThisTag.ExecutionMode IS END pbi#ThisTag.GeneratedContent#i/b/p cfset ThisTag.ExecutionMode = /cfif And my call to it is this: cfset variables.mytest = a test cf_mycustomtag this is #variables.mytest# /cf_mycustomtag This will give me: this is this is #variables.mytest# in bold and italic font. I want it to give me: this is a test in bold and italic font. Can I get that without having to nest it in a cfoutput or something? I'm thinking along the lines of cfmail, where it will automatically Evaluate variables inside it. Is that sort of functionality possible? Thanks, Evan -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 3:35 PM To: CF-Talk Subject: RE: Help with a cf_custom/cf_custom custom tag You don't have to. Once ThisTag.ExecutionMode is END all expressions (and tags) in the body will have been processed. You'll have access to the output via ThisTag.GeneratedContent. --- Ben -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Friday, August 03, 2001 2:58 PM To: CF-Talk Subject: Help with a cf_custom/cf_custom custom tag I'm working with my first ColdFusion custom tag that's a tag pair. I've got it working mostly the way I'd like, but I've come up against something that I don't think I'm going to be able to do, but thought I'd ask anyway. Usage is going to be: cf_mycustomtag I'll have some text here which the tag will do something with. /cf_mycustomtag But what might be there is the following: cf_mycustomtag I'll have #variables.text# here which the tag will do something with. /cf_mycustomtag How can I get the tag to Evaulate the CF variables in between it. Can I? Seems like I'd first have to prefix it with the caller scope (which doesn't seem very doable even with RegEx) and then throw an Evaluate statement around it. Any ideas? Thanks, Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: MySQL Front
Agreed. I downloaded about six or seven different ones for Win, Linux, etc. MySQL-Front was definitely the best in my book, and one of the easiest to set up. It's also updated very frequently. Evan -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 4:07 PM To: CF-Talk Subject: Re: OT: MySQL Front If you find something better let me know, but I think you have the best-of-breed already. I looked all over for some time before settling on MySQL Front. Looked around again recently and came up empty. Cheers, --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Chad Gray [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 27 Jul 2001 14:10:29 -0400 Does anyone have a favorite MySQL GUI interface for a Win 2K box? I like MySQL-Front so far, but im wondering if there is something better to maintain and connect to a MySQL database on a IRIX server. Thanks, Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Questions to ask for CF developer
I don't think that plopping down a test in necessarily a mistake, it's just how you go about it. At a company at which I used to work, we had a home grown, web-based CF/Database test that we gave to interviewees. However, we told them on the phone that part of the interview process would be this test and to expect to spend about 30 minutes on it. Over time, we developed a system where they could do part of it (some inital HR related stuff) at home before even coming in, and thus allowing them to not have to spend all day with us. So, I think it's all a matter of expectations. If they come in expecting a standard interview and then get a test, then yes, I think that could put some people off. But if you tell them up front, then I think everyone will be happy. my $.02. Thanks, Evan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 10:15 AM To: CF-Talk Subject: Re: Questions to ask for CF developer I don't like to give tests to people when I'm talking with them. And I don't like taking them when I'm interviewing. When someone plops down a test in front of me ... I ask myself is this the environment I want to work in? And I've turned down jobs because of it. And these tests show exactly what? When I'm developing I've got Studio or MSDN or the web or whatever at my disposal. Is it important to memorize every parameter of every command? Or is it better to have the skills to be able to locate the needed information. When I'm interviewing someone, I start with having the person tell me what they developed. I then probe as to how and why the developed it. I also like to get a feel for design considerations. I might ask how one has handled large query results being displayed at the client or maybe some browser compatability issues etc. It's not 1998 and the supply-side of talent may rule the day, but IMHO plopping down a test is a mistake. Bill ~~ 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: Red Worm Hack - Affected Files?
I know that there's a patch out to *prevent* the hack, but let's say you've got a box that's been hacked. How do you know whether any malicious files are present or what files to remove? Anyone seeing any changed files as a result of this, either? Thanks, Evan ~~ 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 5 Certification
Talk on this list and CFDJ from people who've asked MACR is that people will be grandfathered in to the Advanced status if you scored 80% on the 4.5 test. However, it will take time (I think I heard 6-8 weeks) before that happens. HTH, Evan -Original Message- From: Lee Moore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 12:51 PM To: CF-Talk Subject: Re: CF 5 Certification I also see that if you scored 80% or higher on the test they rate you as Advanced ColdFusion Developer. I scored over 80 yet I'm not listed as advanced. So either they haven't started listing advanced status, the people grandfathered in can't be advanced, or they haven't bothered updating the site for people grandfathered in over 80%. Anyone know the scoop? Lee Moore - Original Message - From: Scott Brady [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 11:55 AM Subject: Re: CF 5 Certification A few weeks ago, I noticed on the list of Certified Developers on Macromedia's site that it was listing people as CF 5 developers, even though they were certified last year. An e-mail to Macromedia led to a response saying that all CF 4.5 Certifications were being grandfathered in to the CF 5 Certification. Considering I just took the CF 4.5 test last week, I'm thrilled to know I won't have to shell out another $150 to take the next test. Scott - Scott Brady http://www.scottbrady.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
cfqueryparam question - [WAS: CLOBS in Oracle]
I thought cfqueryparam couldn't/shouldn't be used in INSERT statements? (I don't remember where I heard this. I think from a thread months ago on this list.) Where are people using them in their code? I use them in every SELECT statement I make, but not in INSERT, UPDATE, and DELETE. Any thoughts? -Original Message- From: Peter Stolz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 8:25 AM To: CF-Talk Subject: RE: CLOBS in Oracle Yes it does. It worked for me on CF 4.5 Solaris and CF 4.52 Win2k using native drivers and with the 'Enable retrieval of long text' checked in the CF admin. Selects work by default, here's the syntax for inserts and updates. CFQUERY NAME=name DATASOURCE=#DSN# INSERT INTO CLOB_TABLE( ID, CLOB_TEXT ) VALUES( CFQUERYPARAM VALUE=#ID# CFSQLTYPE=CF_SQL_INTEGER CFQUERYPARAM VALUE=#CLOB_TEXT# CFSQLTYPE=CF_SQL_CLOB ) /CFQUERY CFQUERY NAME=name DATASOURCE=#DSN# UPDATE CLOB_TABLE SETCLOB_TEXT = CFQUERYPARAM VALUE=#CLOB_TEXT# CFSQLTYPE=CF_SQL_CLOB WHERE ID = CFQUERYPARAM VALUE=#ID# CFSQLTYPE=CF_SQL_INTEGER /CFQUERY HTH P. -Original Message- From: Smit [mailto:Smit] Sent: Wednesday, July 18, 2001 2:25 AM To: CF-Talk Subject: CLOBS in Oracle Hi, Can you please inform me if ColdFusion supports the CLOB datatype in Oracle. If yes, what is the proper code for querying CLOB data. Also, where can I find a resource on writing queries in ColdFusion for an Oracle DB. Thanks Francois ~~ 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: Multiple Select boxes
Check out the CF_TwoSelectsRelated tag in the Developer's Exchange. It uses JavaScript, but it's pretty easy to implement. Ultimately, even if you wanted the page to reload on the select of the first select box, you'd still need JavaScript with an onSelect or onChange action. HTH, Evan -Original Message- From: Carlo van Wyk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 9:36 AM To: CF-Talk Subject: Multiple Select boxes Hi I would like to have 2 dropdown select boxes. Both the dropdown boxes' values will be from a database. If you select the first dropdown box, the second dropdown box values will be populated according to the value obtained from the first dropdown box. ie. Select Car Select Model I tried to use an example that uses javascript, but i get problems as these two select boxes will be used inside an existing form. Surely one must be able to do this in coldfusion without javascript - maybe with cflocate? Any examples or help will be appreciated. Regards, Carlo van Wyk ColdFusion Developer SOLVE Consulting [w] www.solve.co.za [c] +27 83 454 3533 [t] +27 21 447 1108 [f] +27 21 447 1128 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
RE: COUNT(*)
I've always assumed that any SQL command where you give it a specified field or fields, rather than (*) is faster. I haven't done any testing with this particular statement, though. Evan -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:38 AM To: CF-Talk Subject: OT: COUNT(*) Which is faster? COUNT(*) or COUNT(fileID) assuming fileID is a regular INT, that is also my primary key 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: UUID Woes
I use UUIDs in MS SQL as primary keys all the time. I just set the field as a varchar(35) and primary key, not null. Then I use the CreateUUID() function in CF to generate them. HTH, Evan -Original Message- From: Norman Elton [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 8:17 PM To: CF-Talk Subject: UUID Woes I'm starting to use UUIDs as primary keys, and they work great. Using Ingres, I just stored them as strings, and indexed them to be primary keys. According to the Ingres gurus, this wasn't a big deal. I was happy to see that MS SQL 2000 has native support for UUIDs. Unfortunately, their idea of a UUID is a bit different from ColdFusion: MS SQL: ---- ColdFusion: ---xxx Needless to say, SQL won't accept ColdFusion's UUIDs. Does anyone know a way to get around this and allow ColdFusion to specify UUIDs to SQL? Thanks! Norman Elton ~~ 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 some one repost the directions for security update.
Just check out http://www.allaire.com/handlers/index.cfm?id=21566method=full Evan -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 11:50 AM To: CF-Talk Subject: can some one repost the directions for security update. i cant find the email i received from mm. could some one please send me a copy of the directions for the security update to 4.5 thanks a bunch -paul Whatever you can do, or dream you can, begin it. Boldness has genius, power, and magic in it. - Goethe web developer, nbbj work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ 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: This is so messed up....
It's a hoax. Here's some more info: http://www.urbanlegends.com/ulz/bonsai.html Evan -Original Message- From: Pablo Varando [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 1:56 AM To: CF-Talk Subject: This is so messed up Read through this message and help out if you can! Pablo Varando - Original Message - From: sengwai [EMAIL PROTECTED] To: Yayoi Odani [EMAIL PROTECTED]; Tham Poh Weng [EMAIL PROTECTED]; Teoh Lay Ean [EMAIL PROTECTED]; shinobu suzuki [EMAIL PROTECTED]; sengwai [EMAIL PROTECTED]; Reiko Akiyama [EMAIL PROTECTED]; [EMAIL PROTECTED]; Pooi San Ho [EMAIL PROTECTED]; [EMAIL PROTECTED]; Pablo Varando [EMAIL PROTECTED]; Malesiana Tropicals [EMAIL PROTECTED]; Lay Eng [EMAIL PROTECTED]; Kok Woh Wong [EMAIL PROTECTED]; Ken Franks [EMAIL PROTECTED]; john rabbit [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Alan Chai [EMAIL PROTECTED]; :: oji :: [EMAIL PROTECTED] Sent: Friday, July 15, 2022 10:07 PM Subject: Fw: PLEASE HELP THIS ANIMAL!!! -Original Message- From: Ram Deo [[EMAIL PROTECTED]] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 4:02 PM Subject: please SIGN if ur an animal lover To anyone with love and respect for life: In New York there is a Japanese who sells bonsai-kittens. Sounds like fun huh? NOT! These animals are squeezed into a bottle. Their urine and faeces are removed through probes. They feed them with a kind of tube. They feed them chemicals to keep their bones soft and flexible so the kittens grow into the shape of the bottle. The animals will stay there as long as they live. They can't walk or move or wash themselves. Bonsai-kittens are becoming a fashion in New York and Asia. Please forward to everyone you know, except people who've already signed this! See this horror at http://www.bonsaikitten.com http://www.bonsaikitten.com Please sign this email in protest against these tortures. If you receive an email with over 500 names, please send a copy to: [EMAIL PROTECTED] From there this protest will be sent to USA and Mexican animal potection organizations. If you send this to your friends: Use the copy paste method in an NEW email to keep this readable 1.-Ana Check Mexico, D.F.. 2.-Manolo Alert Mexico, D.F. 3.-AlbertoHuerta Mexico,D.F. 4.-Manuel Gutierrez Mexico, D.F. 5.-Marco Zapata Madrid 6.-Teresa Morato Mexico,D.F. 7.-Ximena Goyenechea Mexico, D.F. 8.-Larissa Lara M???ico, D.F. 9.-Marina Arencibia, Venezuela 10.-Ana Maria Carvajal, Venezuela 11.-Edgard D'Angelo, Venezuela 12.-Claudia Marquez, Venezuela 13.-Derek Ludovic, Venezuela 14.-Rodolfo Placencia, Venezuela 15.-Marbella Caceres, Venezuela 16.-Maria Cristina Caceres, Venezuela 17. Ana C.Castro, venezuela 18.-Victoria Sanchez,Venezuela 19.-Maria Editha Valdeavellano, Chile 20.-Patricio Valdeavellano, Chile 21.-Reinaldo Lopez, Venezuela 22.-Paula Aedo, Chile 23.-Constanza Carrasco, Chile. 24.-Cecilia Noton, Chile 25.-Carlos Eduardo Briones Bolbaran, Chile 26.-Ximena Alejandra BrionesBolbaran, Chile 27.-Pamela Andrea Roa Alarcon, Chile 28.-Gabriela Beatriz Christiny Guajardo, Chile 29.-Magdalena Amenabar Iniguez, Chile 30.-Indra Soledad Kleinhempel Valladares, Chile 31.-Monica Marisol Moreno Muga, Chile 32.-Pilar Rebolledo,Chile 33.-Andrea Villagra, Chile 34.-Claudia Jerez, Chile 35.-Erna Zagal, Chile 36.-Andrea Munoz, Chile 37.-Jacqueline Mateluna, Chile 38.-Beatriz Crovetto, Chile 39.-Carinne Santana, Chile 40.-Ang? ?ica Benda???,Chile 41.-Isabel Olivares, Chile 42.-Max Aguilera, Chile 43.-Mar?? Jos?Molina, Chile 44.-Alejandra Fuentealba, Chile 45.-Tamara Huanquel, Chile. 46.-Paulina Garc? ?, Chile 47.-Carmen Gloria Mu?? z,Chile 48.-Mar?? Soledad Cofr? Chile 49.-Sergio Antoine, Chile 50.-Maria Jose Espinoza, Chile 51.-Alejandra Bauerle, Chile 52.-Ximena Chau, Chile 53.-Doris Rubio, Chile 54.-Heidi Acevedo, Chile 55.-Claudia Acevedo, Chile 56.-Maria Elena Vergara, Chile 57.-Sandra Soto 58.-Elizabeth Molina 59.-Paula Rios 60.-Rodrigo Gajardo 61.-Andrea Solari 62.-Paula Baranda 63.-Guillermina de la Jara 64.-Monserrat Gajardo 65.-Paola Croma 66.-Erika Leiva 67.-Luis Bravo 68.-Ximena Cruz, Chile 69.-Marcela Serey, Chile 70.-Ismael Serey, Chile 71.-Luisa Torres, Chile 72.-Luis G???ez, Chile 73.-Loreto Valenzuela, Chile 74.-Lorena Tapia, Chile 75.-Antonia Fortt,Chile 76.-Fernando A. Vivanco, Wisconsin, USA 77.-Gisela Le???, Chile 78.-Andrea Le???, Chile 79.-Lorena Calleja, Chile. 80.-Rossana Cerecera, Chile. 81.-HUGO VERA,CHILE 82.-Elena Mena,Puerto Rico 83.-Vangie Vall? ?, Puerto Rico 84.-Ana Maria Alvarez Carta??? Puerto Rico 85.-KARINNA RODR?
RE: javascript vars to cf vars?
You can if you use JS to do a form post or build a redirect URL with URL variables. Because CF is server-side and JS is client-side, by the time the JS executes, CF is already done with its work. So, you can send the JS variables to another page (I'm told some people do this with a hidden frame sometimes) and have CF read them as URL or FORM variables. HTH, Evan -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 8:02 PM To: CF-Talk Subject: javascript vars to cf vars? this might sound stupid but - is it possible to put js vars (like, screen width) into coldfusion vars? ~~ 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
Anyone know what this error means?
Getting the following error in webserver.log: ERROR,TID=2780,07/12/01,11:06:35,Error attempting to write location redirection to web server (Windows NT error number -2147467259 occurred) Anyone know what this means? What it's symtomatic of? Seen it before? I can't find any understandable documentation on it anywhere. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: HTML Question with Netscape 4 and 6
FYI, Netscape can handle inline tables with backgrounds, but you need to give any nested tables a background graphic of a transparent gif. For example: table border=0 background=myimage.jpg tr td table border=0 background=transparent.gif tr tdThis works/td /tr /table /td /tr /table It's saved me from having to chop a background graphic into a million pieces at one time or another. Thanks, Evan -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 8:42 AM To: CF-Talk Subject: RE: OT: HTML Question with Netscape 4 and 6 Fixed it yesterday, submitted it to a few lists and another list found the problem, had an extra word in my style sheet which messed up everytrhing and also found out Netscape 4.7 can not handle inline tables with a back ground so I had to split the image in half. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: I-Lin Kuo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 8:35 AM To: CF-Talk Subject: RE: OT: HTML Question with Netscape 4 and 6 I didn't have any problem viewing it with Netscape 4.7 From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:17 PM Subject: OT: HTML Question with Netscape 4 and 6 Can someone please tell me why these pages completely mess up in Netscape 4 and 6 besides the obvious fact that they are the most horrid browsers on the face of the earth. http://209.215.124.4/community/index.cfm If you have any problems on here let me know, I have a firewall on this machine. Robert Everland III ~~ 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: Important ColdFusion Security Patch Released Today
Similarly, if you download the patch for Linux the instructions only tell you to replace one file but the patch has three files in it. What are the other two for? Thanks, Evan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 12:56 PM To: CF-Talk Subject: RE: Important ColdFusion Security Patch Released Today Does anyone know: 1) exactly what files are updated (looks like all the stubs - such as iscf.dll - but I'm not sure) 2) the nature of the security problem - obviously MM is going for security-thru-obscurity and is not going to describe the exact problem, but some clue as to the possible effects, how to tell if the weakness has been taken advantage of, etc would be helpful 3) what workarounds, if any, can be used instead of applying the patch 4) If there's a way to apply the patch without a reboot (if it's just the stubs an IIS stop-start might be enough) -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 8:50 AM To: CF-Talk Subject: Important ColdFusion Security Patch Released Today During a routine internal security audit of Macromedia ColdFusion, Macromedia discovered two important security issues that affect ColdFusion Server versions 2.0 through 4.5.1 SP2. We have released a Security Bulletin about these issues and a patch for ColdFusion Server versions 3.1.1, 4.0, 4.0.1, 4.5, 4.5.1 SP1, and 4.5.1 SP2 (all editions). We are strongly encouraging customers to review the new Macromedia Product Security Bulletin (MPSB01-07) and to install the patch as quickly as possible. You can find the security bulletin and the patch in the Security Zone at: http://www.allaire.com/security ~~~ MPSB01-07: Macromedia releases patch that addresses ColdFusion security issues. Please note, the security issues DO NOT affect ColdFusion Server 5. As a Web application server vendor, the security of the systems our customers deploy is a top priority. Securing Web applications, especially those deployed on the Internet, is complex and involves a wide range of technologies and methodologies from a variety of vendors. Macromedia uses the Security Zone in order to better inform our customers about security issues that may affect them. In the Security Zone you will find Security Bulletins that explain important issues, technical briefs, and links to other resources. In addition, you can subscribe to the Security Notification Service in order to receive future Security Bulletins when they are published. We understand how important security is to our customers, and we're committed to working to provide a secure platform for your Web application development. Thank you for your time and consideration on this issue. - Security Response Team, Macromedia, Inc. P.S. As a reminder, Macromedia has set up an e-mail address that customers can use to report security issues associated with any Macromedia product; that is: [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
IsNumeric Weirdness
I asked this on CFDJList a couple of weeks ago when this list was down, and though many tried to help out, I still just don't get it, so I wanted to see if someone here could shed some light on the subject... Here's the test code: - cfset myvariable = 3D1 cfoutput p#IsNumeric('3D1')#/p p#myvariable#/p p#IsNumeric(myvariable)#/p /cfoutput This returns: Yes 3D1 Yes - WTF?!? Shouldn't I be seeing No, 3D1, No? Is it evaluating 3D1 as a binary or octal value of some kind? Why is it passing an IsNumeric test? I'm running 4.5.1SP2. Interestingly, 3A1, 3B1, 3C1, and 3F1 all fail, but 3E1 produces the same result. I understand in theory why 3E1 works, that's a form of scientific notation (3x10^1 = 30), but 3D1? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: ArraySort()
Aidan, I believe that StructSort() was introduced with 4.51sp2 (if you take a look at the function list on HOF, that's what it says), though documentation on it was particularly lacking, if I remember correctly. I'm guessing that MACR has included documentation on it in the 5.0 doc set, as you stated. In terms of compatibility, though, it should work on 4.5.1 sp2. Thanks, Evan -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 9:20 AM To: CF-Talk Subject: RE: ArraySort() Where can you find any reference to that function? Don't get me wrong... like you, I also it existed... Which is why it looks as though they introduced it in version 5 (I only searched my v4 docs before posting). Doh! Where was that rock I crawled from... ? -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: ArraySort()
As far as I know you can't use ArraySort on a 2-dimensional array. I found this to be extremely frustrating at one point and ended up working around it in some strange way. I would imagine that you could build a structure rather than an array and then use StructSort()...? HTH, Evan -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 11:27 AM To: CF-Talk Subject: ArraySort() I am having problems with ArraySort() function. Has a 2 dimensional array with one column having text and the other having integers. Here is what I am doing: cfscript ArraySort(PartnerArray, text); /cfscript And it gives me this error: The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. Any ideas? Not much documentation that I could find on ArraySort() = Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ UIN: 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: Can't perform queries in Unix
I was using MySQL on CF Linux and ran into a similar problem. I could do SELECT queries but not UPDATE or INSERT queries. Turned out to be exactly what's referenced below: permissions. Both permissions on the file itself as well as the GRANT permissions in MySQL. The database permissions I understood, but the file permissions I wasn't so clear on why that should be affected. But, hey, it worked... Evan -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 7:34 AM To: CF-Talk Subject: Re: Can't perform queries in Unix Possibly, although I can't see why that would affect it. Will give it a go. Cheers -- Will new media discussion for Berkshire -=- http://bnm.lukrative.com local classifieds -=- http://www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 Just grasping here...but how about file permissions for the user on the database file? -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 11:04 AM To: CF-Talk Subject: Re: Can't perform queries in Unix Yes. Other functions are working ok (eg Cfmail) but queries just don't. Will - Original Message - From: Bryan Lentz [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Monday, July 02, 2001 3:32 PM Subject: RE: Can't perform queries in Unix Can you ping the unix server? (assuming it is on a separate box) -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 6:50 AM To: CF-Talk Subject: Can't perform queries in Unix Hi, I'm trying to run a query - as basic as they come - to insert form data into a table. Except that the server is throwing a strange error at me: An error occurred while attempting to establish a connection to the server. The most likely cause of this problem is that the server is not currently running. Verify that the server is running and restart it if necessary. Unix error number 2 occurred: No such file or directory The form action and method have been defined, and the page definately does exist. I'm using the correct Datasource, DBtype, Username Password - what else can I do? In desperation -- Will new media discussion for Berkshire -=- http://bnm.lukrative.com local classifieds -=- http://www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 ~~ 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: is this list dead?
Ditto to everyone. Though I'm glad to see at least a few messages come through... Evan -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 11:56 AM To: CF-Talk Subject: RE: is this list dead? This is the first one i've had in over a week!!! I thought the list was Dead!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: 02 July 2001 16:53 To: CF-Talk Subject: RE: is this list dead? I'm getting posts, but not as many as we used to get. :( Erika (with a *K*) Those who love deeply never grow old; they may die of old age, but they die young. - Sir Arthur Wing Pinero - Macromedia ColdFusion 5.0 Certified Developer - Just passed!! WooHoo - -Original Message- From: Mike Sullivan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 10:57 AM To: CF-Talk Subject: is this list dead? I haven't seen a post in quite some time now. Mike ~~ 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: is this list dead?
Michael, Thank you for all your efforts. They are much appreciated. Evan P.S. - I hear bald is in this year ;-) -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 12:00 PM To: CF-Talk Subject: Re: is this list dead? If Michael is smiling, worry! I found a small article on post.office and win2k that was removed from the software.com site. We followed its suggestions and at least 2 people who weren't getting mail are getting it now. Your all in for a flood, but it'll be worth it to be back. God, the stress. I've lost more hair over this than all my kids combined. Point is, everyone should be seeing this. Life is good again. Let the muffins fly! I'm getting posts, but not as many as we used to get. :( Erika (with a *K*) Those who love deeply never grow old; they may die of old age, but they die young. - Sir Arthur Wing Pinero - Macromedia ColdFusion 5.0 Certified Developer - Just passed!! WooHoo - -Original Message- From: Mike Sullivan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 10:57 AM To: CF-Talk Subject: is this list dead? I haven't seen a post in quite some time now. Mike ~~ 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
CFX_GIFGD on Linux?
Does anyone know if there's a CFX tag with the features of CFX_GIFGD or CFX_IMAGE that runs on CF Linux? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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
IsNumeric weirdness - can someone explain this?
Here's the test code: - cfset myvariable = 3D1 cfoutput p#IsNumeric('3D1')#/p p#myvariable#/p p#IsNumeric(myvariable)#/p /cfoutput This returns: Yes 3D1 Yes - WTF?!? Shouldn't I be seeing No, 3D1, No? Is it evaluating 3D1 as a binary or hex value of some kind? Why is it passing an IsNumeric test? I'm running 4.5.1SP2. Interestingly, 3A1, 3B1, 3C1, and 3F1 all fail, but 3E1 produces the same result. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Protecting Files Served via HTTP or FTP
I could, but then I'm still transporting the file over the network from ServerB to ServerA before pushing it to the client... something I'd like to avoid. Thanks, Evan -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 6:36 PM To: CF-Talk Subject: RE: Protecting Files Served via HTTP or FTP Why not use cfftp to connect to server B -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 7:29 AM To: CF-Talk Subject: Protecting Files Served via HTTP or FTP Here's the situation: we have two servers. ServerA is a web server and CF server (4.5.1 SP2). ServerB is a web and FTP server (ideally, it would just be an FTP server, but bear with me here). A user browses to a web site on ServerA, can fill out a form to request a file, and are directed to a HTTP download on ServerB. The problem is that they can then simply see where the file is located and HTTP there on their own, tell their friends, etc. We'd like to prevent this. I know that I can use CFCONTENT to push files from a non web-browseable directory, but we'd rather not have to install CF on ServerB, and using ServerA to talk to ServerB via CFCONTENT and then push the file out to the user creates a bunch of extra network traffic I'd like to avoid. Ultimately, I'd love to push these files out via FTP, but I can't see a way of doing that without making it anonymous FTP (which would defeat the purpose) or making it non-anonymous FTP but showing the user the login credentials (which I definitely don't want to do). I know that companies have FTP downloads on their sites all the time - how does anyone else out there deal with this? TIA for any thoughts! Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Protecting Files Served via HTTP or FTP]
Any thoughts as to how? We're using an IIS FTP server. I realize that there's a custom tag suite that will allow me to manage users, but I don't want to be creating and deleting NT users that fast (we get a lot of downloads). I don't know that I have the option of installing another FTP server. Thanks, Evan -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:51 AM To: CF-Talk Subject: Re: [RE: Protecting Files Served via HTTP or FTP] give them a one time passwd to access the file Evan Lavidor [EMAIL PROTECTED] wrote: I could, but then I'm still transporting the file over the network from ServerB to ServerA before pushing it to the client... something I'd like to avoid. Thanks, Evan -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 6:36 PM To: CF-Talk Subject: RE: Protecting Files Served via HTTP or FTP Why not use cfftp to connect to server B -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 7:29 AM To: CF-Talk Subject: Protecting Files Served via HTTP or FTP Here's the situation: we have two servers. ServerA is a web server and CF server (4.5.1 SP2). ServerB is a web and FTP server (ideally, it would just be an FTP server, but bear with me here). A user browses to a web site on ServerA, can fill out a form to request a file, and are directed to a HTTP download on ServerB. The problem is that they can then simply see where the file is located and HTTP there on their own, tell their friends, etc. We'd like to prevent this. I know that I can use CFCONTENT to push files from a non web-browseable directory, but we'd rather not have to install CF on ServerB, and using ServerA to talk to ServerB via CFCONTENT and then push the file out to the user creates a bunch of extra network traffic I'd like to avoid. Ultimately, I'd love to push these files out via FTP, but I can't see a way of doing that without making it anonymous FTP (which would defeat the purpose) or making it non-anonymous FTP but showing the user the login credentials (which I definitely don't want to do). I know that companies have FTP downloads on their sites all the time - how does anyone else out there deal with this? TIA for any thoughts! Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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
Protecting Files Served via HTTP or FTP
Here's the situation: we have two servers. ServerA is a web server and CF server (4.5.1 SP2). ServerB is a web and FTP server (ideally, it would just be an FTP server, but bear with me here). A user browses to a web site on ServerA, can fill out a form to request a file, and are directed to a HTTP download on ServerB. The problem is that they can then simply see where the file is located and HTTP there on their own, tell their friends, etc. We'd like to prevent this. I know that I can use CFCONTENT to push files from a non web-browseable directory, but we'd rather not have to install CF on ServerB, and using ServerA to talk to ServerB via CFCONTENT and then push the file out to the user creates a bunch of extra network traffic I'd like to avoid. Ultimately, I'd love to push these files out via FTP, but I can't see a way of doing that without making it anonymous FTP (which would defeat the purpose) or making it non-anonymous FTP but showing the user the login credentials (which I definitely don't want to do). I know that companies have FTP downloads on their sites all the time - how does anyone else out there deal with this? TIA for any thoughts! Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Harpoon Release is Final Available
Dave, Can you point me to any documentation/info from Macromedia or Figleaf which shows this? I'm going to be starting a project with one of our Flash developers who's excited about the concept of using XML, but if it doesn't perform as well... But I'd like to have something with which to back up my claims. Thanks, Evan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:55 PM To: CF-Talk Subject: RE: Harpoon Release is Final Available Using WDDX at this time, regrettably, is NOT a best practice. Is this because of some problem with Flash? Yes. The current version of Flash doesn't handle XML as efficiently as raw string data. 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: blank cfm page in Netscape
Looks like you don't have a /body or a /html tag. Netscape will often not display a page if these are missing. HTH, Evan -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 4:41 PM To: CF-Talk Subject: blank cfm page in Netscape I have a search page using Cold Fusion's Verity engine. In IE the page displays fine. In Netscape 4.04 it displays a blank page. I had this happen once before with form fields, but forgot how I licked it. Is this a Netscape problem? Any ideas? Thanks. Robert Orlini HWW FYI---Here is the page source when it displays blank... HTML HEAD TITLESEARCH/title /head body bgcolor=#FF background=images/newhome/bg.gif topmargin=0 leftmargin=0 rightmargin=0 marginwidth=0 marginheight=0 link=#00 vlink=#00 alink=#3D5F9C div align=center table border=0 cellpadding=0 cellspacing=0 width=100% center tr td background=images/newhome/bg_nav.gif height=41 width=100% div align=center table border=0 cellpadding=0 cellspacing=0 width=663 height=41 tr td background=images/newhome/bg_nav.gifmap name=FPMap0 area href=default.cfm shape=rect coords=8, 1, 138, 40 area href=default.cfm shape=rect coords=609, 17, 662, 40/mapimg border=0 src=images/newhome/top_nav.gif usemap=#FPMap0 width=662 height=41/td /tr /table /div /td /tr /centertrtd width=100% div align=center table border=0 cellpadding=0 cellspacing=0 width=663 height=20 tr center td width=663 valign=middle height=30 p align=right /td /center /tr /table /div /td /tr tr td width=100% div align=center FORM METHOD=post ACTION=SEARCH2.CFM p align=left font face=Arial size=2 INPUT NAME=searchstring SIZE=25 input type=image border=0 src=http://www.hwwilson.com/images/botbuttons/bsearch2.gif; alt=Click To Search HW Wilson name=I1 Value=search width=74 height=18 /font /form ~~ 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: Harpoon Release is Final Available
I seem to remember that in some of the early betas for Harpoon there was an actionscript file for reading WDDX packets in Flash. Did this disappear? Or did it simply become subsumed into some of the FLA's. If the latter is true, could someone point me to the right place to find it? If it's gone, is there a reason? Thanks, Evan -Original Message- From: Sam Coe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 10:29 AM To: CF-Talk Subject: Harpoon Release is Final Available We are happy to announce the availability of The Macromedia Flash Component Kit for ColdFusion. The kit, first announced in November 2000 under the code name 'Harpoon', is now available for download from the ColdFusion Developers Exchange. The Macromedia Flash Component Kit for ColdFusion is a resource for ColdFusion developers to quickly and easily add Macromedia Flash elements to their Web applications. ColdFusion developers can immediately take advantage of the design and delivery benefits of Macromedia Flash and Macromedia Flash Player without learning a new authoring product. For more advanced developers, the Component Kit provides guidelines and documentation for creating and customizing new Macromedia Flash components for ColdFusion that can be shared with other developers. The Component Kit includes 4 prebuilt Macromedia Flash sample components, guidelines detailing how to use and customize components and ColdFusion custom tags that control the behavior of those components. The four Macromedia Flash sample components included with the kit are: *Calendar *Calculator *Horizontal Menu *Cascading Menu (for Microsoft Internet Explorer) The Component Kit is available for free download from the Allaire Developers Exchange for the Windows and UNIX platforms. To access the components, type Macromedia Flash into the Developers Exchange Search window (http://devex.allaire.com/developer/gallery/index.cfm) or visit the following page to link directly to the kit: http://www.allaire.com/handlers/index.cfm?ID=20983 The FAQ and license agreements are also available on this page. Best, -Sam ~~ 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 Studio and UltraDev Merging!
It doesn't sound like they're merging them into one product, more like they're selling them in a package, sort of like they sell Fireworks, Flash, and Dreamweaver (I think those are the three) in a package. Evan -Original Message- From: Nathan Stanford [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 11:29 AM To: CF-Talk Subject: CF Studio and UltraDev Merging! Read This: http://www.allaire.com/products/ColdFusion/productinformation/tools.cfm Nathan Stanford Senior Programmer/Analyst [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: question using IIf
I recently picked up a copy of Ben Forta's Certified CF Study Guide. One of the last chapters is about speed and optimization, and it states that IIF(), DE() and Evaluate() are all very slow functions, and while they have their time and place, can and perhaps should often be avoided (Ben, please forgive me if I'm misquoting you, I don't have the book in front of me!). Evan -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 12:55 PM To: CF-Talk Subject: question using IIf I've been told that we should never use IIF and i just took that on blind faith. I've seen everyone using it for their changing table row background colors though so now i'm wondering if i've been told something in error. can anyone shed any light on this? thanks in advance. david tr bgcolor=#iif(qName.CurrentRow MOD 2, DE('ff'), DE('e8e8e8'))# ~~ 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
NumberFormat woes
I feel a little silly about not being able to figure this out... I'm using CF 4.5.1 SP2. I have a list of numbers: 7, 10, 203, 8, 26, etc. I want the single digit numbers to display as two digits (07, 08, etc.). All other numbers should just display as they are (10, 203, 26, etc.). I've tried NumberFormat(mynumber, 00), but then I get an error if there's a three digit number. I've tried NumberFormat(mynumber, 999), but that doesn't display the single digits as two digits. I've tried NumberFormat(mynumber, 900), but that displays the single digits with two leading zeros. I've tried other, similar combinations as well - all with no success. Any ideas? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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 a cflocation effect take place without a cflocation tag?
Could be: 1. a JavaScript redirect 2. a Meta refresh 3. a cferror tag that's catching an error and sending to an error template 4. a site wide error handler in the CF admin that's sending to an error template 5. ... I'm sure there's other stuff but that's four off the top of my head. HTH, Evan -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 29, 2001 3:47 PM To: CF-Talk Subject: Can a cflocation effect take place without a cflocation tag? Hi, Can a cflocation effect take place without a cflocation tag? I've been asked to proofread some problemmatic code which is inexplicably sending users to an error page. However, before I begin to work out why this is happening, I need to work out how it is happening, since I can't find a cflocation tag either within an else or elseif clause, or elsewhere. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ 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 server certification
My understanding of the CF server licenses (professional or enterprise) is that it is a *per computer* license. So, if you want to install CF on multiple machines, you need to buy multiple copies. HTH, Evan -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 5:39 AM To: CF-Talk Subject: cf server certification Does anybody know how the cf server professional is certified? i.e. per installation on computer or if a company buys it, it can be installed any number of types? thanks! = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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_Buster from Centrasoft - Realistic?
Has anyone who's taken the ColdFusion certification exam looked at the demo for CF_Buster from centrasoft.com? I'm wondering how realistic it is as compared to the real test... Thanks for the insight. Evan ~~ 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 Returns
Just a guess, but you might want to go with DISTINCT as well as some parentheses near your LIKE statments. Something along the lines of... WHERE Products.ItemID = ProdPics.PicID AND (Description LIKE '%#form.keyword#%' OR ItemName LIKE '%#form.keyword#%') AND ItemID 1 ORDER BY ItemName otherwise that OR might be throwing some wrenches in there... HTH, Evan -Original Message- From: Alan Koenig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 2:21 PM To: CF-Talk Subject: Re: SQL Returns That did not help, now I am getting 14 returns for each record. Now I am in confusion. Is there another way for me to return just one record. Do I need to refine my where clause? TIA - Original Message - From: "Bob Silverberg" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 7:24 AM Subject: RE: SQL Returns Well, one way it to use the DISTINCT keyword. Change your statement from: SELECT Products.ItemID, etc. to SELECT DISTINCT Products.ItemID, etc. but I'm not sure if that will give you what you want. Give it a try and see what the result set looks like. Bob -Original Message- From: Alan Koenig [mailto:[EMAIL PROTECTED]] Sent: April 12, 2001 12:58 PM To: CF-Talk Subject: SQL Returns I would like to refine my sql searches down. From the following sql statement I am recieving up to 12 returns of the same record. How can I make this so that there is only 1 return for each record? cfquery datasource="#datasource#" name="prodpage" SELECT Products.ItemID, Products.SKU, Products.ItemName, Products.CategoryID, Products.SubCatID, Products.S_Description, Products.Description, Products.Price, Products.Weight, Products.A1, Products.A1Vals, Products.A2, Products.A2Vals, Products.Units, Products.Layout, Products.Key_Word, ProdPics.PicID, ProdPics.ItemPic, ProdPics.ItemPicLB, ProdPics.ItemPicF, ProdPics.ItemPicB FROMProducts, ProdPics WHERE Products.ItemID = ProdPics.PicID AND Description LIKE '%#form.keyword#%' ORItemName LIKE '%#form.keyword#%' AND ItemID 1 ORDER BY ItemName /cfquery TIA ~~ 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: pull numbers from a string...
The Val() function will give you the first number that appears in the string, so: Val("The width of the box is 54") = 54 but Val("I have 124 boxes of width 54") = 124 HTH, Evan -Original Message- From: Ethan Rosch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 2:26 PM To: CF-Talk Subject: pull numbers from a string... Hi all.. is there a funcion that wil strip everything out of a string except numbers? ie. The width of the box is 54" and I want to set CFSET Width = 54 something like CFSET Width = NumberStrip("The Width of the box is 54") #width# = 54 thanks in advance, ethan ~~ 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
Cookie problem: Expires, IsDefined, etc....
I'm using CFCOOKIE to set a non-expiring cookie on my users' machines. My code in my application.cfm file is as follows: cfif Not IsDefined("COOKIE.tid") cfset TEMP_ID = CreateUUID() CFCOOKIE NAME="tid" VALUE="#TEMP_ID#" EXPIRES="never" /cfif On a subsequent pages (not the first page where the cookie is set) I'm doing the following: cfif IsDefined("COOKIE.tid") cfset variables.uid = COOKIE.tid cfelse cfset variables.uid = CGI.REMOTE_ADDR /cfif so that if they have cookies disabled that I can use their IP instead. However (and here's the problem), even on a browser with cookies disabled that's never been to this site (and I've checked the cookies on the machine to make sure) I'm still getting a page-based cookie set (i.e. one that changes with every reload of the page). How can I check if the cookie is defined or not if every time CF thinks it is? I thought that if users had cookies disabled cfcookie simply wouldn't do anything. Why is it setting this temporary value? I am specifying an EXPIRES attribute, so I know it's not that... Thanks for any insight. Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Oddness with cfqueryparam
Do you see anything below that? I get the following when I use cfqueryparam | SELECT P.PID2 | FROM PAGE_LANGUAGE_XREF P | WHERE P.PID1 = ? | | Query Parameter Value(s) - | Parameter #1 = 24 and the query resolves fine. I'm using SQL Server 7. Thanks, Evan -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 8:55 AM To: CF-Talk Subject: Oddness with cfqueryparam cfqueryparam doesnt seem to be doing as expected: cfquery name="contacts" datasource="Contacts" SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%cfqueryparam value="form.what"%' ORDER BY LastName ASC /cfquery Debugging shows Form Fields:/B FIELDNAMES=WHAT WHAT=ch and the query as SQL = SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%?%' ORDER BY LastName ASC What gives ? Shouldnt cfqueryparam sanatise the string (for " and ; etc.) ? Regards, Thomas Chiverton, Intranet Architect and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ 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
Dynamic values inside of dynamic text
I've got a field in the database that stores information being displayed on a page which has CF variables in it. So then I do: cfquery name="getinfo" select p.text from pages p where id = #id# /cfquery cfoutput#getinfo.text#/cfoutput Except, the CF variables inside of the field "text" aren't parsed, they're just displayed as #variable#. Even if I wrap them in cfoutput's in the info stored in the db. I hope I'm being clear. I certainly feel like I'm talking in circles. Any ideas? I suppose I could do a Replace() on the var once I extract it, but it doesn't seem like I should have to... Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Line Breaks
I know this sounds basic, but... It's not an HTML email,is it? If it is, carraige returns won't mean a thing, you'll need br and p tags. Evan -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:55 PM To: CF-Talk Subject: RE: Line Breaks that's odd. would have been my answer before today, but i had a template that WOULD NOT put in CRs for me. wierd. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:22 PM To: CF-Talk Subject: RE: Line Breaks CFmail works just like pre.line breaks, tabs, etc will appear in the email as you type them * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:18 PM To: CF-Talk Subject: Line Breaks How do you make line breaks within a cfmail? Everything seems to just run together. Rich ~~ 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: Saving a file to a local drive
Check out CFCONTENT. You can output the query to a CSV or Excel file or something like that (assuming you're talking about tabular data). Check out this tag in the gallery for an idea: http://devex.allaire.com/developer/gallery/info.cfm?ID=BFD29A2C-2B0C-11D4-AA 9700508B94F380method=Full Evan -Original Message- From: Francis, Jennifer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 6:28 PM To: CF-Talk Subject: Saving a file to a local drive Is this even possible? Once a query is run, and the page is displayed to the user, is there a way for the user to save the results to his or her local drive? I've looked into CFFILE, but it looks like that saves to the server. Jennifer Francis ATT Wireless Services Training Development Design Team * [EMAIL PROTECTED] * (714) 695-4762 ~~ 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: cfwddx action=wddx2cfml question
Yep. I also ran an IsQuery and IsStruct functions on it. Turns out one of them is a query and one of them is a structure. Thanks! Evan -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 12:47 PM To: CF-Talk Subject: RE: cfwddx action="wddx2cfml" question Col2 might not contain a query. download one of the following tools from the taggallery: cf_dump cf_objectdump Then, select the wddx packets from the db as you have and use these tools to examine the columns. These tools will let you visually see what information is in the columns and will tell you the datatype of the information. Col2 might hold a serialized array, or structure rather than a query. Besides, I think every developer should be using these tools it makes life SO MUCH EASIER! |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Sunday, April 01, 2001 12:36 AM |To: CF-Talk |Subject: cfwddx action="wddx2cfml" question | | |I have a table of data that was populated by an app not built |by me (so I'm |starting off at a disadvantage in terms of not knowing |everything about it - |I'm getting more info to help clear that up). | |In two of the columns in the table (SQL Server 7), the data |has been stored |as WDDX packets. | |So, I'm doing the following to get at them and have a look at |the data in a |more usable and understandable form: | || cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" |name="getpacket" |maxrows="1" ||SELECT T.Col1, T.Col2 ||FROM OldDataTable T || /cfquery || || cfwddx action="WDDX2CFML" input="#getpacket.col1" |output="col1query" || cfwddx action="WDDX2CFML" input="#getpacket.col2#" |output="col2query" || || cfoutput ||#col1query.recordcount#br ||#col1query.columnlist#br ||br ||#col2query.recordcount#br ||#col2query.columnlist#br || /cfoutput | |All pretty straightforward, right? | |Both of the cfwddx tags execute fine and I see the recordcount and |columnlist from col1query. However, when it gets to the |col2query outputs, |I get the following: | || Error Diagnostic Information || An error occurred while evaluating the expression: || #col2query.recordcount# || || Error near line 26, column 2. || |--- |--- |-- || Error resolving parameter COL2QUERY.RECORDCOUNT || || The object RECORDCOUNT is not present in the scope named |COL2QUERY. It is |likely that you || have misspelled the name of the object you are trying to access. | | |Now, if it was an invalid packet (which it doesn't look like |when I just |output it to the screen), it would fail the cfwddx call, |right? Since it |passes it, why can't I access it like a query? | |Col1query works just fine. Gives me a recordcount, a |columnlist, I can loop |over records, etc. etc. etc. | | |Thanks in advance for any insight anyone can offer. | |Let's not even discuss the fact that I'm working on this at |12:35 on April |Fools Day ;-) | | |Evan | | | ~~ 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
cfwddx action=wddx2cfml question
I have a table of data that was populated by an app not built by me (so I'm starting off at a disadvantage in terms of not knowing everything about it - I'm getting more info to help clear that up). In two of the columns in the table (SQL Server 7), the data has been stored as WDDX packets. So, I'm doing the following to get at them and have a look at the data in a more usable and understandable form: | cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" name="getpacket" maxrows="1" | SELECT T.Col1, T.Col2 | FROM OldDataTable T | /cfquery | | cfwddx action="WDDX2CFML" input="#getpacket.col1" output="col1query" | cfwddx action="WDDX2CFML" input="#getpacket.col2#" output="col2query" | | cfoutput | #col1query.recordcount#br | #col1query.columnlist#br | br | #col2query.recordcount#br | #col2query.columnlist#br | /cfoutput All pretty straightforward, right? Both of the cfwddx tags execute fine and I see the recordcount and columnlist from col1query. However, when it gets to the col2query outputs, I get the following: | Error Diagnostic Information | An error occurred while evaluating the expression: | #col2query.recordcount# | | Error near line 26, column 2. | -- -- | Error resolving parameter COL2QUERY.RECORDCOUNT | | The object RECORDCOUNT is not present in the scope named COL2QUERY. It is likely that you | have misspelled the name of the object you are trying to access. Now, if it was an invalid packet (which it doesn't look like when I just output it to the screen), it would fail the cfwddx call, right? Since it passes it, why can't I access it like a query? Col1query works just fine. Gives me a recordcount, a columnlist, I can loop over records, etc. etc. etc. Thanks in advance for any insight anyone can offer. Let's not even discuss the fact that I'm working on this at 12:35 on April Fools Day ;-) Evan ~~ 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
Partly OT: Automating the switchover of a web site
I'm working on an existing web site that's being completely redesigned - UI, Structure, etc. etc. So, I've got the existing site and the new site in two directory trees and am close to being done with the new one. My client wants to automate the switchover of the new site such that it happens at midnight on 1 April. I'm using an NT 4 Server with IIS 4 and CF 4.5.1. Currently I'm thinking that the best bet would be to schedule a windows AT command which perhaps changed the home directory of the web site. But, I can't find this value in the registry (which would seem to be the most direct place to change it). Any ideas? Anyone dealt with this issue before? I'd prefer not to be manually swapping stuff, though I could. And the less said about this all happening on april fool's day, the better. ;-) Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: navigation of records, ie first last next previous
There's a great custom tag for this in the tag gallery - called cf_prior_next. It's at: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347445-2830-11D4-AA 9700508B94F380method=Full HTH, Evan -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:03 PM To: CF-Talk Subject: navigation of records, ie first last next previous Having a problem figuring this out on record's, I would appreciate anything that anybody has on the proper way of doing the codeing for record selection, like in the subject line, first record, last record, and so on and so forth TIA Mike ~~ 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: Parsing Street Address
As a start, if you did a Val() statement on either of your examples, it would return the street number (4853). Val() returns the first number in a string. You could then trim the original string based on the length of whatever was returned by the Val(). That's not going to account for people entering something like "One Flower Blossom Avenue". I don't see how you can handle that with functions or regex. The most accurate way is probably going to be making the form fields stricter (one field for number, one for street, etc.). I know you said you'd rather not do that, but if you want to be able to handle the data this way, it's probably your best way to ensure accurate data. HTH, Evan -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 10:52 PM To: CF-Talk Subject: Parsing Street Address Hi Everyone, I am wondering if anyone has any code or any ideas about the most efficient way to handle this: I need to parse the street address from people's accounts such that I can parse out the Street Name and Street Number separately (and disregard things like suite and apartment number) and assign each to a variable. In other words, say I was given an address like: 4853 Flower Blossom Avenue Or 4853 Flower Blossom Avenue Apartment 1222 I need to get the street number (4853) and then just the street name (Flower Blossom Avenue) and pop them into a variable. Would this best be done with Regular Expressions? Does anyone have any example code? I could force people to enter their street addresses in a strict manner to make this easy, but I'd rather not do that. Thanks, Eron ~~ 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: CF5.0 Beta with Allaire Spectra - Advanced Security???
According to the release notes this beta doesn't support Advanced security and I believe that they say it therefore can't be used with Spectra in this release. You can check out the release notes at the beta site. Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- -Original Message- From: JoshMEagle [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 1:14 PM To: CF-Talk Subject: CF5.0 Beta with Allaire Spectra - Advanced Security??? This may not be the place for questions regarding CF5.0 BETA, but I'm running it here on a development box and just decided to install Spectra on the box too and see how they work together Spectra requires advanced security from CFServer, but I can't find that option in 5.0 . anyone know where this is or am I just blind this AM? Thanks! Joshua Miller Web Development Eagle Technologies Group, Inc. Business Solutions for the Next Generation www.eagletgi.com [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: Returning a variable with a custom tag
Martin, Looks like your code got clipped, but from what you're saying, here's my $.02: If your custom tag is setting a variable named "caller.output", then your calling template needs to reference that variable simply as #output#, not #caller.output#. If you want to scope it, you can set it in the custom tag as "caller.variables.output" and then reference it as #variables.output#. If that's not the problem, try reposting your code. Evan -Original Message- From: Martin P. Cadirola [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 2:32 PM To: CF-Talk Subject: Returning a variable with a custom tag Hello folks, I've been working on this one for too long and I thought of asking the experts on the forum. I'm using CF 4.0.1. Please see the code below. When I run the calling template I immediately get an error saying: "Error resolving parameter OUTPUT..." I'm calling the custom tag using the cfmodule tag. I used the debugger and verified that the return variable (called "caller.output") gets set within the custom tag. When returning to the calling template caller.output is gone (and therefore the error triggers). The variable type is a list but I don't think it makes a difference as far as passing a variable back to the calling template. I really appreciate your suggestions and comments. Cheers, Martin Calling Template ~~ 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: Passing values to Flash
Kinley, Are you still dealing with this issue? If so, let me know. I've just dealt with a very similar project. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- -Original Message- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 10:58 PM To: CF-Talk Subject: Passing values to Flash I am rephrasing my previous email on this subject. I have successfully integrated a flash clip within a fusebox infrastructure. Whether it is correct, I do not know. Anyway, I also was able to set a GET URL on the last frame of the flash. What I need to know: Is it possible to pass multiple values to flash from either CF or HTML? Is there a way to pass or set values to variables within a flash clip for example if I set the GET URL as www.blabblah.com/index.cfm?fuseaction=loginloginID=#LoginID#pass word=#pass word#. hoping you will know...the books that I have purchase only made reference to reading external text files from within a flash clip. thanks - Kinley ~~ 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) IIS Web Logs, how to parse and calculate unique visitors
We use WebTrends to parse our logs and run pretty reports. I think it was a "why reinvent the wheel" issue. Regarding unique visitors, most off-the-shelf programs I've seen will recommend that you track users by cookie, not by IP. That gives you a much more accurate count of unique visitors, and avoids the AOL, NAT, Proxy problems. Evan -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:54 PM To: CF-Talk Subject: (OT) IIS Web Logs, how to parse and calculate unique visitors (OT) IIS Web Logs, how to parse and calculate unique visitors Has anyone created a web log analyzer? How do you determine unique visitors over a period of time? Given things like AOL rotating IP client addresses, and proxy servers? Curious. Eric ~~ 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
what happens when you don't scope a variable?
I've recently been looking at someone else's code that's been handed to me, and came across the following question... In my templates, I've got my constants set as Request variables (Request.DSN, for example) in application.cfm and I reference them that way. I used to have a bunch of application variables (e.g. application.dsn) but changed this to prevent the need for locking these values. However, the code I was looking at had a bunch of unscoped variables in application.cfm (cfset DSN = "datasourcename"). So, to finally get to the question: if that's done, is the variable automatically treated as an application scoped variable, since it's set in application.cfm? Or, is the var only an application variable if it is scoped as such, and, since it isn't scoped, it's treated as a local variable (of the variables. scope but without the scope)? If the latter is true, then no problem. However, if the former is true, then there are some definite locking issues with the code I'm looking at. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Here you have, ;o)
Yep. It's a virus. I just got word on it from my network admin. Apparently, it attaches a .vbs file disguised as a jpg (filename.jpg.vbs). Thank goodness the listserv filters out attachments. Thanks Michael! Evan -Original Message- From: Edward Chanter [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 12:29 PM To: CF-Talk Subject: RE: Here you have, ;o) Is this some kind of virus??? Or is everyone just being weird? -Original Message- From: Brandon Behrens [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 5:19 PM To: CF-Talk Subject: Here you have, ;o) Hi: Check 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
select from/insert into from different dsn's
I'd like to copy some data from one table to another. The tables are in separate datasources. If they were in the same DSN, I'd do: INSERT INTO TABLEB ( SELECT * FROM TABLE A WHERE COLUMN = 'CONDITION' ) Since they're in separate DSN's, is there any way I can do this without doing one query, and looping over it with an insert? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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
CFAdmin - Missing Template Handler - Format?
I want to use the "Missing Template Handler" in CFAdmin to have a custom 404 page for CF pages. What format do I put the file in in this box? Absolute path (http://...), relative path (relative to what)? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: Is there a way to run a server side executable through CF?
Take a look at CFEXECUTE. It does just this. Evan -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 3:35 PM To: CF-Talk Subject: Is there a way to run a server side executable through CF? We have created several scripts written for NT Server that perform various server side tasks. What we want to do is execute these scripts using the CF scheduler. Is there a way to run a server side executable through 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: Syntax error....
If any of those columns are set up as INT, then the quotes around the values aren't necessary and will cause the query to fail. Evan -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 5:05 PM To: CF-Talk Subject: Syntax error Can anyone tell me what is wrong with this insert statement? Ive been looking at this for about an hour now and cant figure it out I get the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, Time, Points, AdjPoints, Money) VALUES '1', '2', '7', '1', '0', '50', '125', '5000')" Data Source = "??" !-- cfquery name="PutResults" datasource="?" dbtype="ODBC" INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, Time, Points, AdjPoints, Money) VALUES ( '#RodeoID#', '#EventID#', '#ContestantID#', '#Place#', '#Time#', '#Points#', '#AdjPoints#', '#Money#') /cfquery -- Thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.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
Custom 404 Error Page
I know this has been covered before, and I've searched the archives, but can't seem to make what I need to work... I want to have a custom 404 error page for my CF-based (4.5.1) site. It's running on NT and I've set up a custom error page in IIS. This works great if you request a .html page that doesn't exist (i.e. http://www.mysite.com/notarealpage.html). However, when I request a .cfm page that doesn't exist (i.e. http://www.mysite.com/notarealpage.cfm) then I get a CF 404 error page. I have: cferror type="REQUEST" template="/root/html/404.cfm" in my application.cfm and a mapping to /root in CF Administrator. What am I doing wrong? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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
Best Practice for a persistent variable
A what would/what do you do question: We are developing a site that's got some flash elements. For the non-flash people, there will be html elements that swap into those places. I'd *like* to do a flash detect and then set a variable based on the results and then do something like if flash IS 'yes' insert flash header else insert html header But, I'm concerned about what variables I can use. Here's my thinking. 1. Session variables expire, so I don't want to use those. Since I don't want to have to push a user back to a flash detect again. 2. Cookies are probably my best bet. Then I wouldn't even need to use the flash detect if they come back again. But what if someone has cookies disabled? 3. Client variables have the same problem, right? If a user has cookies disabled, client vars won't get set. 4. CFID and CFTOKEN lend themselves to the same problem, right? So, here I am wondering what I can do. If I'm wrong on #3 or #4, then I'm okay, I suppose. I could also pass an id in the url from page to page, but I'd prefer not to if I can avoid it. Any advice or thoughts is greatly appreciated. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: (no subject)
Looks like your problem is an HTML one, not a CF one. Where you have: LIA HREF="empdtl1.cfm?EmployeeID=#EmployeeID# It should be: LIA HREF="empdtl1.cfm?EmployeeID=#EmployeeID#" Note the final quotation mark before the . Otherwise, it's still looking at the href contents. Evan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 10:23 PM To: CF-Talk Subject: (no subject) Hi all, I'm still in chptr 11 of Ben Forta's CF Web Construction kit book. The problem I'm getting is a 2-fold problem. What follows is the code: CFQUERY DATASOURCE="A2Z" NAME="EMPLOYEES" SELECT EmployeeID, FirstName, LastName, PhoneExtension FROM Employees ORDER BY LastName, FirstName /CFQUERY HEAD TITLEEmployee List/title /head Employees UL CFOUTPUT QUERY="Employees" LIA HREF="empdtl1.cfm?EmployeeID=#EmployeeID# #LastName#, #FirstName#/a - Ext. #PhoneExtension# /cfoutput /ul == This code outputs an employee database that renders every displayed record as a hyperlink. There are two problems with the result: 1. The output is only 1/2 the database. The query selects every even numbered record. 2. Next, when I click on a link, I get an error that states that the system attempted to retrieve the previous, odd numbered, record. The error info is: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'EmployeeID = 7Black, Kim - Ext. 4565 A HREF='. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:42). /BI get this error when I click on William Brown, the 2nd record in the Employees table of A2Z.mdb. This error refers to the 1st record in the table. This newbie would appreciate any help. Steve Carmeli 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
RE: faster count
You could turn this into a GROUP BY query cfquery name="Getastindex" datasource="wweb" SELECT COUNT(ast) AS ast_count, ast FROM wweb GROUP BY ast ORDER BY ast /cfquery Then, your results set would be something like: ast ast_count - ASTAI 50 ASTft 29 ASTindex35 Should work... Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 4:53 PM To: CF-Talk Subject: faster count Hello, I have an Access table that I need to get a count for a specific value in each column. The coding below does the trick (on one column), but is too slow since I have numerous columns. I'm kinda a newbie on this so I was wondering is there away to make the count quicker by combining some of the coding? Thanks in advance. Robert O. HWWADMIN cfquery name="Getastindex" datasource="wweb" Select Count(ast) AS ast_count FROM wweb Where ast like 'ASTindex' /cfquery cfquery name="Getastai" datasource="wweb" Select Count(ast) AS astai_count FROM wweb Where ast like 'ASTAI' /cfquery cfquery name="Getastft" datasource="wweb" Select Count(ast) AS astft_count FROM wweb Where ast like 'ASTft' /cfquery ~~ 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: String to Int
Is CFQueryParam something that can/should be used on INSERT and UPDATE statements also? Would it improve performance there? Or is it just for SELECTs? Thanks, Evan -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 9:20 AM To: CF-Talk Subject: RE: String to Int I don't know that I'd make that a blanket recommendation. If you use CFQUERYPARAM to make a prepared statement, you can't use CACHEDWITHIN/CACHEDAFTER with your CFQUERY tags. You'll want to determine which is more appropriate in a given case. In any case, you'll get better performance using stored procedures with SQL Server than you will with CFQUERYPARAM; Oracle, on the other hand, gets more out of prepared statements and less out of SPs than SQL Server does. True, but using CFQueryParam is a lot more secure than using just Val() How so? If your concern is that the value passed may not be numeric, both will do the same thing. The only difference is that CFQUERYPARAM may also improve database processing performance. 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
BrowserHawk Extended Properties - ASP and COM?
I've just got the new copy of cyScape's BrowserHawk. I assume there's a few users of it out there since I've seen people recommend it on this list. I want to take advantage of some of the "Extended Properties" (detection of cookies, javascript enabled, plugins, etc.) which are not available through their CF custom tag, but are through ASP pages. Question is, can I call the ASP pages or the functions in them through a COM object? That way, I can avoid having to send to an ASP and redirect to CF, etc. etc. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: FW: SQL Server Licensing Woes
Yep. They're an Australian company, and so the prices quoted are in AU$. Very roughly, it's about 1 US$ to 2 AU$. Evan -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 9:02 AM To: CF-Talk Subject: Re: FW: SQL Server Licensing Woes On 1/30/01, Parker, Kevin penned: I checked with a friend of mine in MS (yes MS staff have fiends :-) - hope this helps Evan. I went to the link you're friend provided and saw nothing on SQL Server 7. However, I noticed their price for SQL Server 2000 Standard w/ 1 Processor license is $8,148.00. At CDW, the same SQL Server 2000 w/ 1 Processor license is $4,687.36. Am I missing something? http://www.cdw.com/shop/products/default.asp?EDC=233830 -- 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: CFLocks??? overlapping..
You could do this... cflock scope="session" timeout="30" type="readonly" cfset variables.userid = session.userid /cflock cflock scope="application" timeout="30" type="exclusive" cfset application.usersloggedin["#variables.userid#"] = VALUE /cflock Evan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 2:24 PM To: CF-Talk Subject: CFLocks??? overlapping.. Hi All, Can someone please help me with Cflocking this session and application variable CFSET APPLICATION.USERSLOGGEDIN["#Session.Userid#"]=SESSION I am adding the Current Session user structure to the application structure to keep track of the users in the app. if i turn off full checking on locks in cf admin, this works fine. Appretiate all help 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
WOT: SQL Server Licensing Woes
As many others have done, I'm turning to the group in the hopes that someone out there has an idea I haven't thought of. I apologize for the OT post. I'm deploying a new website for a client and we're planning on running MS SQL Server 7 as the back end. Since SQL Server 2000 has come out, no one is selling 7.0 any more (or, they're selling their final inventory). I've located a copy of the software, but I'm trying to be legal and order the Internet Connector licenses. Unfortunately, I can only locate one. I've called MS, and they won't sell them anymore (so, if you've got a copy of SQL Server 7 that you now want to connect to the Internet, you have to order SQL Server 2000 all over again - nice, eh?). Does anyone have any ideas on where I might locate a copy of the Internet Connector license? Any good resources for software online or offline? Especially those that sell "last year's version"? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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 Server Licensing Woes
Right. I could do that. But then I'd be paying roughly $4000 more than the cost of licensing SQL Server 7 directly, because of the new licensing model. Something I (and more importantly my client) would like to avoid. Evan -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 6:45 PM To: CF-Talk Subject: RE: SQL Server Licensing Woes This isn't a perfect solution but, in certain cases, it is possible to buy licenses for the newer product and then downgrade. In other words, buy SQL 2000 licenses but use them for SQL 7.0. Licenses are especially hard to deal with because it's just a piece of paper and resellers don't typically keep a lot of unsold licenses laying around. Things like this are a perfect example of why everyone should, in my opinion, emphatically protest/stop the continuation of UCITA (Uniform Computer Information Transactions Act). In the UCITA world MS could not only stop selling SQL 7 licenses but, could retract previously acquired licenses, forcing you to buy new licenses or be in violation. Not only that, it would allow a company to imbed code into its products that would allow them to remotely disable the software if you decided you didn't want the new licenses. Steve -Original Message- From: Evan Lavidor [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 6:04 PM To: CF-Talk Subject: WOT: SQL Server Licensing Woes As many others have done, I'm turning to the group in the hopes that someone out there has an idea I haven't thought of. I apologize for the OT post. I'm deploying a new website for a client and we're planning on running MS SQL Server 7 as the back end. Since SQL Server 2000 has come out, no one is selling 7.0 any more (or, they're selling their final inventory). I've located a copy of the software, but I'm trying to be legal and order the Internet Connector licenses. Unfortunately, I can only locate one. I've called MS, and they won't sell them anymore (so, if you've got a copy of SQL Server 7 that you now want to connect to the Internet, you have to order SQL Server 2000 all over again - nice, eh?). Does anyone have any ideas on where I might locate a copy of the Internet Connector license? Any good resources for software online or offline? Especially those that sell "last year's version"? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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 Server Licensing Woes
Robert, Thank you *so* much for sending this link. This makes my life so much easier. Evan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 7:48 PM To: CF-Talk Subject: Re: SQL Server Licensing Woes Actually if you are using a WebServer to connect to the SQL Server you do not need an Internet Connector License. Internet Connector Licenses are for users from the internet connecting directly to the SQL Server as in many Win32 apps that were developed. Attached is the link to this information. I was advised of this by the Microsoft Licensing Center. You would need a CAL for every WebServer that will connect to the SQL Server and any other device from the internet that would be accessing the resources of the SQL Server. http://www.microsoft.com/SQL/productinfo/70pricing.htm Thanks, Robert - Original Message - From: "Evan Lavidor" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 29, 2001 6:04 PM Subject: WOT: SQL Server Licensing Woes As many others have done, I'm turning to the group in the hopes that someone out there has an idea I haven't thought of. I apologize for the OT post. I'm deploying a new website for a client and we're planning on running MS SQL Server 7 as the back end. Since SQL Server 2000 has come out, no one is selling 7.0 any more (or, they're selling their final inventory). I've located a copy of the software, but I'm trying to be legal and order the Internet Connector licenses. Unfortunately, I can only locate one. I've called MS, and they won't sell them anymore (so, if you've got a copy of SQL Server 7 that you now want to connect to the Internet, you have to order SQL Server 2000 all over again - nice, eh?). Does anyone have any ideas on where I might locate a copy of the Internet Connector license? Any good resources for software online or offline? Especially those that sell "last year's version"? Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: CFSCRIPT performance
I've done multiple else if() statements within cfscript many times. No problems at all. Evan -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 27, 2001 12:26 PM To: CF-Talk Subject: RE: CFSCRIPT performance There is too an else if. Just do else if(). Use it all over the place. Never had a problem. How come the docs say you can only do else and place the if inside the else... I've done else if() before - as it's actually else { if() } I'll have to check with multiple else if()s 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: URGENT: Case Question
Take a look at the COMPARE() function. It does a case sensitive comparison of two text strings. Evan -Original Message- From: Javed Mushtaq [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 2:18 PM To: CF-Talk Subject: URGENT: Case Question Hi all, Please could you tell me how i could verify if a password being posted from another page has the exact same case as the password in the database. Eg password: Orange But if enter orangE it evaluates to being true. Please could you tell me how to determine if the password matches the entry in every way. Yours hopefully ~~ 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: Structures
But you can set a variable scoped structure: cfset variables.stName = StructNew() Evan -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 2:00 PM To: CF-Talk Subject: RE: Structures No. I have tried many times. I wish it were. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 11:26 To: CF-Talk Subject: Structures Can the variable scope can be accessed as a structure? Thx, Duane ~~ 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
Sorting a query created from QueryNew()
Once I've created a dynamic query using QueryNew() that has four columns and many rows and populated it will all the data using QueryAddRow() and QuerySetCell(), is there any way to sort it (CF 4.5.1)? I don't see a QuerySort() function anywhere... Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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
NEWS: Allaire and Macromedia to Merge
http://biz.yahoo.com/prnews/010116/ca_macrome_3.html I guess we know why ALLR was on the rise recently... Who knows what this means for things like UltraDev, Generator, etc. Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ 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: image root resolving
In that case I'll often set Request.urlroot or Request.imageroot in my application.cfm file and then call images with img src="#request.urlroot#/images/blah.gif" or img src="#request.imageroot#/blah.gif" inside a cfoutput. Take care, Evan -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 11:43 AM To: CF-Talk Subject: Re: image root resolving Assuming your webroot is pointing at c:\inetpub\wwwroot\ (IE http://www.yoursite.com/index.cfm is really c:\inetpub\wwwroot\index.cfm), then you don't need to do anything to do what you want. What if this isn't the case and the site begins in a sub directory? --=@ greg @=-- - Original Message - From: "Zachary Bedell" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 10:42 AM Subject: RE: image root resolving -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Assuming your webroot is pointing at c:\inetpub\wwwroot\ (IE http://www.yoursite.com/index.cfm is really c:\inetpub\wwwroot\index.cfm), then you don't need to do anything to do what you want. /images will be /images no matter what. Now... images without the slash will get you a relative path, but /images (with the leading slash) will always get files from c:\inetpub\wwwroot\images\. Best regards, Zac Bedell -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 10:35 AM To: CF-Talk Subject: image root resolving Hey Guys: I was wondering if there is a way to insert the server path (e.g. c:\inetpub\wwwroot\images) to just be /images. I need it to be able to resolve the image path even if its deep into a directory stucture such as the user is in /blocks/category/index.cfm, the images will resolve up to the /images folder. Understand?? I'm not good at explaining. --=@ 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: LOCKING revisited...
Are you saying that if I do the following: cflock scope="application" timeout="30" type="readonly" cfset variables.myvariable = application.myvariable /cflock and then later on down the page I do the following: cfif variables.myvariable GT 10 do something /cfif then I haven't solved the locking "issue"? I thought that by setting my application variables to local variables within a lock, I could now reference the local variables with abandon and not have to worry about locking any more. Is this not the case?!? Thanks, Evan -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 20, 2000 10:21 AM To: CF-Talk Subject: RE: LOCKING revisited... No offense, but that is nonsense. My Cold Fusion server is still multi-threaded and multi-processed. It is still handling every incoming request at the same time. The only time it will act "single threaded" is when two requests attempt to read an Application scope variable at the same time. And guess what? That is exactly the same thing that will happen if you DONT use automatic read locking, but properly use CFLOCK around your Application variables. Automatic read locking doesn't lock the entire page request, (which would be single threading the entire server). It locks read access around those variables that need it. This is not just an academic issue for me. I have a site running with 10-100 reads from an Application structure on every page. To make the code more readable, I am using automatic read locking for Application scope variables instead of CFLOCK#Application.myvar#/CFLOCK tens or hundreds of times on each page. On a related note, if I have automatic read locking enabled for Application scope and I assign a local Variable to an Application variable, it will essentially make a copy to the pointer. Is CF smart enough then to automatically lock accesses to this local Variables, which is pointing into Application space? !--- automatic read locking is ON for Application variables --- cfset myvar = Application.bigvar cfoutput #myvar# /cfoutput !--- === IS THIS AUTOMATICALLY LOCKED?? --- At 02:13 PM 12/19/00 -0700, Richard Kern wrote: It was expressed before that turning this on via the server will essentially drop your application to single thread mode, slowing down all responses from the system. Remember that CF is server side so doing this is like knocking on the door and opening it for each request and then closing it before anyone else enters, no matter how many people are queued at the door. Richard Kern -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 1:16 PM To: CF-Talk Subject: LOCKING revisited... Ok, given that we all agree: ** Access to shared variables should *ALWAYS* be locked ** Then why on Earth shouldn't I just turn on Automatic Read Locking for Application (and Session et al if I use them) scope and only worry about write locking in my code? Why doesn't everyone do that, with the rare exception of some code that has unusual locking needs. I've heard the argument that automatic read locking is a slight performance hit. It couldn't be more of a hit than parsing cflock /cflock around every access and still doing the read lock anyway! - -- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803rid=972879910type=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: cflock vs. cftransaction
CFLOCK doesn't provide the same effect as cftransaction. In MySQL you can lock your tables, though. It's a little cumbersome. It basically means that MySQl is only handling one request at a time... Here's some code that Tage Widsell posted to this listserv earlier this month: cfquery datasource="your_datasource" name="lockThreads" LOCK TABLES yourTableName WRITE /cfquery cfquery datasource="your_datasource" INSERT INTO yourTable (yourFields) VALUES (yourValues) /cfquery cfquery datasource="your_datasource" name="lastMID" SELECT LAST_INSERT_ID() AS msgID FROM yourTable /cfquery cfquery datasource="pheads_User" name="unlockThreads" UNLOCK TABLES /cfquery HTH, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 12:41 PM To: CF-Talk Subject: cflock vs. cftransaction Hi all. When advancing the ID in a database by pulling up the max(id) as maxid then cfset newid = query.maxid + 1 and inserting the new record, I've always used cftransaction around the queries. This gives an error in MySQL that transactions aren't supported. Will using cflock do the same thing? cflock name="cust#attributes.dsn#" timeout = "10" queries here /cflock Thanks. -- 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