RE: Urgent: Sql 6.5 Guru Question
Follow-up... nevermind... I decided to go with the second option of using bcp to import the data into a temp table and then updating the appropriate fields in the master table. I received only one response from someone on the list, thanks for your reccomendations - I received the bcp suggestion from a few other people as well, it was easier to implement than I thought. Thanks, Ryan -Original Message- From: Ryan Hill Sent: Monday, August 07, 2000 1:53 PM To: '[EMAIL PROTECTED]' Subject: Urgent: Sql 6.5 Guru Question Hello everyone, Got a problem here that I can't seem to figure out. I have a tab-delimited text file containing 3 cols, (can_id, votes, % votes) that I need to import into a SQL 6.5 table containing these three columns (and others) that needs to be updated on a regular basis - updating existing records, not inserting new ones. My first guess would have been bcp, but as near as I can tell, this only works on data copying operations, so it won't allow me to perform an UPDATE type of action on the table I want to update. I'm used to working with SQL 7.0, which would let me save this as a DTS package, so my t-sql stored proc syntax is a little rough. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Urgent: Sql 6.5 Guru Question
Hello everyone,
Got a problem here that I can't seem to figure out. I have a tab-delimited
text file containing 3 cols, (can_id, votes, % votes) that I need to import
into a SQL 6.5 table containing these three columns (and others) that needs
to be updated on a regular basis - updating existing records, not inserting
new ones.
My first guess would have been bcp, but as near as I can tell, this only
works on data copying operations, so it won't allow me to perform an UPDATE
type of action on the table I want to update. I'm used to working with SQL
7.0, which would let me save this as a DTS package, so my t-sql stored proc
syntax is a little rough.
Here is what I've got so far, which is full of errors:
if exists (select * from sysobjects where id =
object_id('dbo.update_election_output') and sysstat 0xf = 4)
drop procedure dbo.update_election_output
GO
/***
Object: Stored Procedure dbo.update_election_output
Script Date: 8/7/00 11:15am
Last Updated On: Never!
***/
CREATE PROCEDURE update_election_output
@election_results_file varchar(255)
AS
/***
Update election results from FTP source file.
***/
CREATE TABLE #election_updates
(
textstring varchar(255) null
)
select 'Getting Election Results'
INSERT #election_updates
EXEC ('EXEC master..xp_cmdshell ''type '+@election_results_file+)
select 'Updating Election Results Table...'
UPDATE a
SET a.votes = SUBSTRING(textstring,8,15)
SET a.percent_votes = SUBSTRING(textstring,16,23)
FROM elections_output a
WHERE EXISTS
(
SELECT *
FROM #election_updates
WHERE a.can_id = SUBSTRING(textstring,1,7)
)
/***
Cleanup and Grant appropriate permissions.
***/
DROP TABLE #election_results
GO
Is this the right way to go about this? Would it be better to use bcp to
copy the data into a temp table and then write an update statement to update
the master table?
Thanks,
Ryan
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cflock - BAH!
Bud, Have you tried turing off 'enforce strict attribute validation' in CFAS on your 4.01 server? This should probably allow you to leave the scope params in each tag and while 4.5 will happily understand it, 4.01 should just ignore it. I can sympathise with the version woes, but as others have said - ranting here doesn't solve anything (except sometimes, it makes you feel better :). Allaire (like a lot of software makers that shall remain unnamed *cough* Webtrends! *cough*) just seem to make one step forward and two steps back sometimes. Hope this helps, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 15, 2000 4:01 AM To: [EMAIL PROTECTED] Subject: cflock - BAH! rant snipped Am I ranting for nothing? Does anyone know of a way to get around this? Is there a cgi variable to read the version of CF? If so, I guess I could wrap every cflock inside cfif to read the version and set the scope accordingly. -- Bud Schneehagen - Tropical Web Creations -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFEXECUTE Problems
Dave and all, I've gotten several helpful replies now but I'm still a little worried here. Its starting to sound like this isn't a very good approach to my goal. I've added some comments and thoughts inline below: Is your CF service running as localsystem? Yes, it is. I tested this on my development machine, running Win2K and CF 4.5.1. I'm using the standard security configuration (essentially, no security); this might be your problem, if you've modified your user rights and security configuration in one way or another. I've attempted testing this on several similar configurations, both my development and staging servers and am not getting successful results. I've tried including a timeout here as well with no luck. My development and staging machines are both running 4.5.1 and NT 4 SP5 (maybe 4.0 is the problem). If I add an outputfile param on the tag, the 'user /add' command produces no result (empty text file). If I issue a 'user' command, it produces an enumeration list in the file, but also the ambigous 'one or more errors' message. If I issue a different command like 'view', it enumerates all the machines on the domain and reports 'operation completed successfully'. If you're trying to manipulate users, rights, etc. you might want to take a look at ADSI, which you can use through COM. CFOBJECT isn't really good at doing this, but it's pretty easy to write wrapper objects, and call those objects to do your ADSI tasks. I've used Windows Script Components for this. Justing MacCarthy also suggested this route but this is turning into more complexity than I have time or resources for right now. I was also provided a good link to Lewis Sellers usermanager suite which appears to contain a bunch of CFX's that will do exactly what I need. On a tangent, can anyone recommend an FTP server that would integrate well with CF automation? The ultimate goal here is to automate the creation of user accounts and access rights. Currently, I'm trying to add the user to an NT domain (duh) and then I'm assigning server permissions at the file level using xcacls.exe (this works just dandy using CFEXECUTE). I've had few problems using IIS's web server for this. Could you elaborate on this a little for me? Thanks, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFEXECUTE Problems
Hey all, First time attempting to use this tag, so I would appreciate a little help here. I am attempting to use CFEXECUTE to execute a 'net user /add' command via CF and its silently failing to create the account I specify. The server service is running under the local system account. Can someone tell me where I'm going wrong? Thanks, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFEXECUTE Problems
Thanks for replying Dave, mm... nope, still not working for me. In addition to your example, I've also tried running it from a cmd.exe shell - i.e.: cfexecute name="c:\winnt\system32\cmd.exe" arguments="net user testme testme /add" /cfexecute ... still no dice. Is your CF service running as localsystem? Curiously, if I attempt the following: cfexecute name="c:\winnt\system32\net.exe" arguments="user" outputfile="foo.txt" /cfexecute The output file enumerates the user list but also adds one of NT's widely loved ambigous errors: "The operation completed with one or more errors." Of course, it doesn't tell me what those errors are, nor are they logged anywhere I could find. If I turn on event log auditing, I can see the SYSTEM logon being granted access rights to the security subsystem both to add a user and to enumerate users. However, despite appearing to execute successfully, the user is not added to the local account database. On a tangent, can anyone reccomend an FTP server that would integrate well with CF automation? The ultimate goal here is to automate the creation of user accounts and access rights. Currently, I'm trying to add the user to an NT domain (duh) and then I'm assigning server permissions at the file level using xcacls.exe (this works just dandy using CFEXECUTE). Thanks, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 8:37 PM To: [EMAIL PROTECTED] Cc: Ryan Hill Subject: RE: CFEXECUTE Problems First time attempting to use this tag, so I would appreciate a little help here. I am attempting to use CFEXECUTE to execute a 'net user /add' command via CF and its silently failing to create the account I specify. The server service is running under the local system account. You have to call net.exe; this worked for me: cfexecute name="c:\winnt\system32\net.exe" arguments="user testme testme /add" /cfexecute Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Mirroring files from one clustered server to another.
On NT, you can do it for "free" using Robocopy from the NT Resource Kit. I have batch files scheduled to run the replication job and then use blat to e-mail the log files back once a day. Although it requires a little time to setup and get it working properly, I haven't had any problems since implementation. Regards, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 05, 2000 10:08 AM To: [EMAIL PROTECTED] Subject: RE: Mirroring files from one clustered server to another. What is a good program for mirroring files to my 2nd clustered server? BTW, Mirroring is going to be built into CF 5 (Per: allaire). Teleport Pro comes to mind. http://www.tenmax.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Programmatically Editing RDS Settings?
Here's one for the Gurus: Can I programmatically manipulate and create RDS security environments (not filesystem) for Advanced Security in Enterprise? In an effort to automate some administration tasks, I would like to be able to a) create the client website structure (already done) and b) create RDS settings such that the client has access to their site through a Studio environment. Is anyone out there familiar with this issue? Tips, pointers, articles are all welcome and appreciated. Thanks in advance, Ryan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Changing default CF error for nonexistent templates
To claify this a little further: In CF 4.5, Allaire added a Missing Template Handler to let developers and/or administrators to specify a custom page for handling missing pages. Prior to this release however, 404 (missing templates) are handled and generated internally by CF server and there is no way to change this functionality. The generally accepted and widely implemented workaround for this is to have the web server intercept these requests before the file is passed on to CF for processing. This adds a reource footprint to your webserver however, since the server must now check to insure the file exists every time it is accessed before handing it off to CF. On small to moderately busy servers, you shouldn't notice any performance problems. On high traffic sites though, this does contribute to the total amount of traffic the server can handle. Another benefit of having IIS intercept these errors though, is that you can use all of your custom error pages that you've already created for regular web files. Ryan -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 6/28/00 2:35 PM Subject: Re: Changing default CF error for nonexistent templates If you're running IIS you can do it through the MMC. Are you running IIS? If so email me off list and I can walk you through it. --K Katrina Chapman Consultant Ameriquest Mortgage -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Nutscrape Problem
Robert, The CFID and CFTOKEN are passed on every page through that website to prevent the problem you just described. Without cookies, the only way for Cold Fusion to maintain session state is to pass the CFID CFTOKEN around with the user via URL's or hidden formfields. If you don't explicitly pass these variables, Cold Fusion must assume that you are a new visitor, and then assigns you new CFID CFTOKEN values. One of the goals with this site was to provide functionality to users who have cookies disabled, but still want to use the site. Many of the site's more dynamic features, like the shopping cart, and archives absolutely rely on session state to keep track of where the user is, what they're doing and what they may need to do next. Regards, Ryan -Original Message- From: Robert Everland To: '[EMAIL PROTECTED]' Sent: 6/22/00 12:44 PM Subject: RE: OT: Nutscrape Problem I saw on the tvw.org site you put cfid and cftoken at the end of the variable. For some reason when I turn off cookies and go through my site, it gets way way way screwed up and gives me different cfid and cftoken on everypage. How do I correct this problem? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Nutscrape Problem
Deanna, You're just asking for an administrative nightmare here... no reason to write ramfiles at all, let RealServer generate them for you. This is especially easy to do if you've already got the filenames stored in a database. Yes, this does transfer the marginal overhead to your RealServer from your webserver since RealServer must create and serve the .ram text file to the client - but the advantages gained in not having to manually maintain those annoying little files makes the change more than worth it. (Lessons learned from completely redesigning an restructuring an existing 9,000+ file, 46GB+, RealServer...) Some credit is also due to RealNetwork's developer and technical support departments for fully supporting my efforts of file management and automation on that project. Those guys are pretty cool! Regards, Ryan -Original Message- From: Deanna L. Schneider To: [EMAIL PROTECTED] Sent: 6/22/00 12:46 PM Subject: Re: OT: Nutscrape Problem Duane, I did something similar - writing ram files as people entered clips to a database of audio and video files. Code goes something like this: !-- --- If it's a new ramfile, write the file. -- cfif #form.new# is "yes" cffile action="write" file="w:netscape\wisconsinvote\docs\avroom\#form.ramfile#" output="#form.rtspaddress#" !-- --- If it's replacing an old file, delete the old and rewrite. -- cfelse cffile action="delete" file="w:netscape\wisconsinvote\docs\avroom\#form.ramfile#" h4Let's put something in here to give it a few milliseconds.../h4 cffile action="write" file="w:netscape\wisconsinvote\docs\avroom\#form.ramfile#" output="#form.rtspaddress#" /cfif -d -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Nutscrape Problem
Dirk, You can do this with a SMIL file: smil body video src="videossong.rm" clip-begin="10.5s" clip-end="50.7s"/ /body /smil http://www.realnetworks.com/devzone/documentation/index.html Regards, Ryan -Original Message- From: Dirk De Bock To: [EMAIL PROTECTED] Sent: 6/22/00 3:03 PM Subject: Re: OT: Nutscrape Problem so does anyone know the magic code to make the player start loading the media clip at a specific point somewhere in the file rather then at the very beginning ? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(event) CFSeattle.org -Tues.June 20: CF-powered M-Commerce
Dear fellow CF Developers, After returning from Boston last week, where I attended the CFUG Manager Conference, I have a new outlook on Allaire and its plans for ColdFusion. The next ColdFusion server will pre-compile Java and CF together, using an integrated JRun server. This will not only speed ColdFusion execution, but will allow the construction of multi-tiered applications using the best of both Java and CF. This is a huge step forward for Allaire, allowing us application developers to move towards more robust development models that can scale like never before. So what does this mean? It means that you can now invite your Java friends to our meetings. Remember, first-time visitors are FREE, and so are the food and drinks And speaking of scalability, this coming Tuesday, I will be presenting a ColdFusion commerce server, ComUnion 2.0, which is just entering beta. ComUnion is designed according to the FuseBox methodology http://www.fusebox.org/, is Spectra compatible, and compliant with the ECML 1.1 Spec http://www.ecml.org/. I will also be demonstrating ComUnion's wireless features using an ATT PocketNet WAP phone, as well as Palm VII's Web Clipping technology. I look forward to seeing you all next week! Best Regards, Shannon Topic: ComUnion 2.0b: A ColdFusion M-commerce server Date: Tuesday, June 20th at 6:30pm Program Timetable: 6:30-6:40 Refreshments and Networking 6:40-7:00 New Business, Announcements 7:00-7:40 Presentation 7:40-8:00 Open QA Location: Boeing Auditorium, in the Seafirst Executive Education Center (SEEC) on the UW main campus (directions below) To register just email [EMAIL PROTECTED] Please put RSVP in the subject line. Directions: Boeing Auditorium, in the Seafirst Executive Education Center(SEEC) on the UW main campus. From I-5 north or south, take the NE 45th St exit. Go east about a mile and a half on NE45th St to 17th Ave NE. Enter through Gate Number 2 at 17th Ave NE. After the guard post, take your first left onto Stevens Way and park in the lot on your left(N5). The SEEC is across the street to the left as you walk out of the lot. Boeing Auditorium is around the right side of the building -- Follow the signs. From 520, take the Montlake Blvd exit and follow Montlake Blvd north to entrance to UW through Gate Number 3. After the guard post, go straight to Stevens Way, turn right, and follow Stevens Way to parking lot N5 (on your right). The SEEC is across the street to the left as you walk out of the lot. Boeing Auditorium is around the right side of the building -- follow the signs. Parking on campus is $2.50. (Parking off campus is FREE!) For further info and directions, see the campus map at http://www.washington.edu/home/maps/northcentral.html. The SEEC building is in coordinate M5. If you would like to be removed from this mailing list, please reply to this message with the word 'unsubscribe' in the subject line. Shannon James Smith Phone: 1-206-343-9445 ColdFusion Users of Seattle Fax:1-206-343-9456 810 Third Avenue #320 Email: [EMAIL PROTECTED] Seattle, WA 98104 USA Http://CFSeattle.org/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: programatically changing CF ADMIN settings
Greg, This is expected behavior. Registry settings do not normally take effect until they are re-loaded by the service using them. Luckily, Allaire wrote a function that will rescan and reload registry settings without needing to restart the services. It sounds like the param you are trying to manipulate works without restarting the services if you hit Apply, so try calling the following function after you make the change and see if this works: http://www.allaire.com/handlers/index.cfm?ID=11714Method=Full CFUSION_SETTINGS_REFRESH() Refreshes some ColdFusion settings not requiring a restart Regards, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: Greg Saunders [mailto:[EMAIL PROTECTED]] Sent: Friday, June 02, 2000 4:57 AM To: [EMAIL PROTECTED] Subject: programatically changing CF ADMIN settings I'm trying to programatically change CF ADMIN settings. I'd like to be able to change ANY of the settings, but to take a specific example, say I want to set the "Site-wide Error Handler" (in 4.5). I can do this with: cfregistry action="set" branch="HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\Current Version\Server\" entry="ValidationHandler" type="String" value="c:\wwwroot\myErrorHandler.cfm" When I do this, it changes the value of the "Site-wide Error Handler" in "...CFIDE/administrator/index.cfm", but it has no effect on how CF processes errors until I either cycle the CF service, or until I open the administrator page (which already contains the NEW setting) and click APPLY. Is there a more direct way of manipulating admin settings programatically? If i must do it through the registry, how can I make the changes take effect without opening the admin page? Thanks, Gregory M. Saunders, Ph.D. Senior Design Architect Cognitive Arts Corporation (http://www.cognitivearts.com) 120 S. Riverside Plaza, Suite 1520 Chicago, IL 60606 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT: Dev. for multiple browser versions
Just thought I would mention that we have a G4 for our graphics development and have been unable to get 4.x anything to run on VPC... always crashes when you open it. At least its consistent I guess ;) Regards, Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: Nick Slay [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 3:19 PM To: [EMAIL PROTECTED] Subject: Re: Slightly OT: Dev. for multiple browser versions :^( Ahh, but I could always resort to NoteTab Pro or, in real desperation, Notepad! I guess for that matter I could always use BBEdit!! But, at the end of the day, I'll be able to code on a Mac!!! Yeeha... At 10:47 25/05/00 -0400, you wrote: Nick, While I can sympathize with your feelings, VPC will run quite slow. On your powerbook it will be similar to running CFStudio on a Pentium 166 or 200. larry -- Larry C. Lyons EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Nick Slay wrote: DOH!!! What am I talking about. I've ordered VirtualPC for this Powerbook too CF Studio will run there. HAHAHA... (sound of opening window, the whistling as the base unit hurtles towards the ground and then the smashing PC!!! 'Take that you piece of useless, unreliable junk mwahhahahah'!!) --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: benefits of Enterprise without ClusterCats?
Since I've been down this road recently, I thought I would throw this out here. Just some notes from the field, IMHO: 1.) Don't even attempt to use Cluster Cats in a production environment. a.) Poor performance under all load conditions. b.) Advanced documentation or reference? What? Where? c.) Poor support from Allaire - they don't even reccomend using it. We were going to try to run it for a new client but load testing in our staging environment completely destroyed any benefits we might have obtained. If you really need this functionality, invest in a hardware solution - yeah they're expensive, I know - but they are DEFINATELY worth it. Don't even get me started on Advanced Security and Spectra whooe! Regards, Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 3:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: benefits of Enterprise without ClusterCats? I'm moving to a clustered server using NT/IIS/SQL, but I plan on using Local Director, and NOT ClusterCats. In this case, is there any benefit to running Enterprise over Professional? I'm assume that the following features of Enterprise are tied to using ClusterCats, but I couldn't really tell: * Service-Level Failover * Dynamic Load Balancing * Automatic Server Failover You're correct. All of those features are provided by ClusterCats. You may find it useful to use ClusterCats in conjunction with LocalDirector, though. In addition, Enterprise provides native database drivers - worth it if you're using Oracle - and the Advanced Security engine, which is powerful (although very obtuse) and required for Spectra. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cold Fusion Server 4.5.1 DoS Vulnerability.
if not aware of the issue, and difficult to prosecute. Although it is true that web stress tools are widely available, any attempt to use such tools against commercial websites today would result in aggressive investigation and criminal prosecution. As evidenced by the attacks on several large commercial websites proved, even the most carefully planned attempts to cover an attacker's tracks in a denial of service (or DDoS) attack will likely still result in criminal prosecution. It is Allaire's responsibility to its customers to make its products as stable, reliable and secure as possible. In my opinion, this matter is still not being given the attention it deserves. Regards, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(event) CFSeattle.org: Sneak Preview! TripHub 2.0 - A Spectra-powered portal.
Topic: Patrick Keating of Kythe Software will present a commercial web commerce application built using Spectra, Allaire's content management engine, and ComUnion, the Market Matrix commerce platform. The presentation will cover Spectra's content object model and how this model may revolutionize commercial web design. Please invite your friends and coworkers, first time guests are free. Date: Tuesday, May 16th at 6:30pm Program Timetable: 6:30-6:45 Networking and Refreshments 6:45-7:00 Introductions and New Business 7:00-7:45 Presentation 7:45-8:00 Open QA Location: Boeing Auditorium, in the Seafirst Executive Education Center (SEEC) on the UW main campus (directions below) To register just email [EMAIL PROTECTED] Please put RSVP in the subject line. http://www.cfseattle.org Directions: Boeing Auditorium, in the Seafirst Executive Education Center(SEEC) on the UW main campus. From I-5 north or south, take the NE 45th St exit. Go east about a mile and a half on NE45th St to 17th Ave NE. Enter through Gate Number 2 at 17th Ave NE. After the guard post, take your first left onto Stevens Way and park in the lot on your left(N5). The SEEC is across the street to the left as you walk out of the lot. Boeing Auditorium is around the right side of the building -- Follow the signs. From 520, take the Montlake Blvd exit and follow Montlake Blvd north to entrance to UW through Gate Number 3. After the guard post, go straight to Stevens Way, turn right, and follow Stevens Way to parking lot N5 (on your right). The SEEC is across the street to the left as you walk out of the lot. Boeing Auditorium is around the right side of the building -- follow the signs. Parking on campus is $2.50. (Parking off campus is FREE!) For further info and directions, see the campus map at http://www.washington.edu/home/maps/northcentral.html. The SEEC building is in coordinate M5. Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spectra Caching Issues
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_000_01BFB854.A4F3F9B0 Content-Type: text/plain; charset="iso-8859-1" Update: After spending 5 hours researching this problem in Allaire Forums and my own experimentations, I think I have found the problem, possibly two bugs in the way CFCACHE operates. In Spectra, page caching is handled by CFCACHE tag, which caches pages on request and then checks the original templates timestamp to determine if CF should re-cache the template. Although CFCACHE documentation is a little vague on exactly which timestamp it checks, I think it is safe to assume that it is referencing the last modified date timestamp. All of the template files on the non-functional machine had creation dates later than their last modification dates - this normally doesn't occur EXCEPT in a clustering environment. All of the template files on the non-functional machine were populated using ROBOCOPY for NT (which works great, btw) and so all of the timestamp dates on the non-functional machine reflected creation dates later than their last modification date. CFCACHE seems to have trouble deciding which date to use in this case, and re-caches the file every time. I was able to get caching working correctly on the non-functional machine using either of the following methods: 1.) Resaving original templates so that their last modification date was AFTER their creation date. 2.) Replicating the cache files from the functional machine to the non-functional one. CF doesn't seem to care what the cache files are named or dated, so long as the cfcache.map points to the correct .tmp files. As a long-term workaround, item number 2 is what we'll be moving into production with. Although not the best solution, a more suitable one has yet to be found. For the second part of this update, I believe I have discovered a second (if not already known) bug in CFCACHE which could be summarized as follows: "CFCACHE hangs request threads after the maximum number of simultaneous threads is reached under load." This bug is fully-reproducible under the following circumstances: 1.) CFCACHE tag is specified within a template. 2.) Original template is not yet cached, i.e. no .tmp file and no cfcache.map file pointer. 3.) Load is applied to the server which exceeds the allowed number of simultaneous threads, i.e. if allowed is set to 4, applying a simultaneous load of 5 puts 4 into the running state and 1 into the queue. 4.) Cold Fusion Server will hang at this point, the 4 running threads never release and the queue never decreases. This behavior was confirmed using CFSTAT, a performance monitoring utility for CF Server. This bug really concerns me because of its relation to the caching problem above. In a load environment, say 5 simultaneous requests are made to a file that has been cached, but CF Server wants to refresh the cache with each request (bug #1) - CF Server attempts to recreate the cache file and hangs (bug #2). Our entire need for CFCACHE is centered around making Spectra scalable. The 4 spectra templates we're attempting to cache take an average of 100-200ms to display under a load of 1 user. Without caching turned on, those same templates have now grown to 18000-25000ms (18-25 seconds) under a load of only 20 users for EACH page!!! Allaire - HELP!!!!! Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -Original Message- From: Ryan Hill Sent: Saturday, May 06, 2000 8:40 PM To: Cold Fusion Discussion (CF-Talk) (E-mail) Subject: Spectra Caching Issues Good evening everyone, I need a Spectra expert to help me figure out why page caching is not working correctly in 1.01 gold between two machines. My setup is as follows: (2) Identical Hardware Machines setup for a Cluster Configuration Cluster is not currently running, machines are operating independently. NT 4.0 SP5 Dual PIII 500MHz, 384MB RAM, Ultra-Wide SCSI Drives Server Ent 4.5.1 Spectra 1.01 Gold Spectra Setup: All databases are shared via a central SQL server. Spectra page caching setup for appropriate pages. Identical CF Administrator settings. On one machine, caching is working properly as listed in the example below: 1.) Page call is made. 2.) cfcache.map is created. 3.) *.tmp files are created. 4.) Cache files do not update after creation (desired outcome). On the other machine, the following is happening: 1.) Page call is made. 2.) cfcache.map is re-created (timestamps change). 3.) *.tmp files are re-created (timestamps change). 4.) Cache files update after each request (what I'm trying to prevent). Any ideas on what I'm doing wrong? Thanks, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com --_=_NextPart_000_01BFB854.A4F3F9B0 Content-Type: application/ms-tnef Content-Trans
Spectra Caching Issues
Good evening everyone, I need a Spectra expert to help me figure out why page caching is not working correctly in 1.01 gold between two machines. My setup is as follows: (2) Identical Hardware Machines setup for a Cluster Configuration Cluster is not currently running, machines are operating independently. NT 4.0 SP5 Dual PIII 500MHz, 384MB RAM, Ultra-Wide SCSI Drives Server Ent 4.5.1 Spectra 1.01 Gold Spectra Setup: All databases are shared via a central SQL server. Spectra page caching setup for appropriate pages. Identical CF Administrator settings. On one machine, caching is working properly as listed in the example below: 1.) Page call is made. 2.) cfcache.map is created. 3.) *.tmp files are created. 4.) Cache files do not update after creation (desired outcome). On the other machine, the following is happening: 1.) Page call is made. 2.) cfcache.map is re-created (timestamps change). 3.) *.tmp files are re-created (timestamps change). 4.) Cache files update after each request (what I'm trying to prevent). Any ideas on what I'm doing wrong? Thanks, Ryan Ryan Hill, MCSE Director of Systems Integration Market Matrix, Inc. - http://www.marketmatrix.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SSL, Formfields, and IE 5
Benjamin, To answer your question, yes, the formfield is hidden. On the HTMLEditFormat - Good guess... but nice try ;) This doesn't have any effect on the behavior of IE 5 and 5.01 on NT. The duplicate form header is still being passed when posted to an SSL processing page - refresh the page and the behavior goes away. I think I'm going to attribute this one to a bug in IE 5 and/or the combination of IE 5 and IIS 4 SP 5 w/ security hotfixes. Again, this problem doesn't affect IE 4 or NS 4 on NT (at least the versions I've tested). Regards, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -Original Message- From: Benjamin Smedberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 04, 2000 7:29 AM To: [EMAIL PROTECTED] Subject: Re: SSL, Formfields, and IE 5 problem and it may be a bug in IE 5. Basically, in trying to pass a WDDX packet via SSL, IE 5 interprets the packet as another form and sends two form headers to the processor page. If you refresh the processor page, the Are you passing the WDDX in a HIDDEN form field? If so, have you HTMLEditFormat()ted the packet? If you have not, then the XML structure of the WDDX packet can destroy regular HTML. + + Benjamin Smedberg + CUA Assistant Webmaster + [EMAIL PROTECTED] - http://computing.cua.edu/as/bds/ + + He is risen, as He said! Alleluia! + -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SSL, Formfields, and IE 5
Afternoon all, Is anyone out there aware of problems posting forms to an SSL processing page? I've got a form page that accepts input, and passes some hidden variables to an SSL secure processing page which works fine in Netscape (imagine that :) but fails in IE. The formfields aren't being passed in the initial request but if I refresh the processing page, the formfields magically appear. The real kicker - if I make up a plain test form passing arbitrary values and a processor page that simply outputs the formfields and then I place those two files in the exact same directory structure, it works in SSL. The original pages also work if I call the form processor page without SSL... Anyone have any ideas? I've been pulling my hair out on this for 3 days... and it hurts! Thanks, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire KB Article 14020 Modification - Cluster Cats Load @ 100%
Yannick, My cluster machines are running SP5 because SP6 breaks some CF things in IIS, but I am running 4.5.1 on the entire cluster. Do you have to enter a user/name pass when connecting to that page in Netscape? If you do, then you don't have allow anonymous connections turned on for the site and you need to do that in order for the services to work properly. Viewing the page in your browser and accessing the page through a service account are two different entities altogether. Hope this helps, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -Original Message- From: Yannick Simon [mailto:[EMAIL PROTECTED]] Sent: Monday, May 01, 2000 10:13 AM To: [EMAIL PROTECTED] Subject: Re: Allaire KB Article 14020 Modification - Cluster Cats Load @ 100% - Original Message - From: "Ryan Hill" [EMAIL PROTECTED] To: "Cold Fusion Discussion (CF-Talk) (E-mail)" [EMAIL PROTECTED] Sent: Monday, May 01, 2000 7:00 PM Subject: Allaire KB Article 14020 Modification - Cluster Cats Load @ 100% ... Allowing anonymous access to the clustered websites fixes the error. Regards, Ryan Hill, MCSE have you got the last NT Service Pack (6.0a) and Cold Fusion Ent 4.5.1 ? i've got the same pb as you ... but i can reach /btauxdir/getsimpleload.cfm without pb with a browser ... so ? Yannick Simon -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: A CF Studio question
Hubert, I don't have 4.5 Studio on my desktop at the moment, but in 4.0.1, its under Options | Settings | HTML tab. Uncheck 'lowercase all inserted tags' and this will take care of tag completion. Regards, Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Monday, April 24, 2000 8:59 AM To: [EMAIL PROTECTED] Subject: A CF Studio question Hi, How can I configure cf studio so that when it autocompletes tags, it does so using uppercase letters? Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: (event) CFSeattle.org: Wireless ColdFusion
We've had RealNetworks come out in the past to webcast our latest visit by Ben Forta, I will forward your comments to the right people and if enough interest is generated we could probably make this a more interactive meeting. There has also been some discussion recently about SDK's being available on Nokia and other websites, but I've also heard that http://www.wapforum.org/ comes highly reccomended from folks at Allaire. Regards, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -Original Message- From: Gregory Weiss [mailto:[EMAIL PROTECTED]] Sent: Friday, April 14, 2000 11:54 AM To: '[EMAIL PROTECTED]' Subject: RE: (event) CFSeattle.org: Wireless ColdFusion Is their anyway, the notes for this discussion can be accessed, or anyway we can attend online. Also, are their any materials, sites, documenation currently available to address this very interesting topic. Thanks, Greg -Original Message- From: Ryan Hill [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 13, 2000 7:31 PM To: Cold Fusion Discussion (CF-Talk) (E-mail) Subject: (event) CFSeattle.org: Wireless ColdFusion Topic: Wireless Application Protocol (WAP) CF Ian Lurie, founder of Portent Interactive, will demonstrate a simple WAP/ColdFusion application. Anyone interested in ColdFusion and the future of the wireless Web should attend. Please invite your friends and coworkers, for 1st time guests are free. Date: Tuesday, April 18th Program Timetable: 6:30-6:40 New Business, Elections 6:40-7:20 Presentation 7:20-7:30 Open QA Location: Boeing Auditorium, in the Seafirst Executive Education Center (SEEC) on the UW main campus (directions below) To register just email [EMAIL PROTECTED] Please put RSVP in the subject line. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(event) CFSeattle.org: Wireless ColdFusion
Topic: Wireless Application Protocol (WAP) CF Ian Lurie, founder of Portent Interactive, will demonstrate a simple WAP/ColdFusion application. Anyone interested in ColdFusion and the future of the wireless Web should attend. Please invite your friends and coworkers, for 1st time guests are free. Date: Tuesday, April 18th Program Timetable: 6:30-6:40 New Business, Elections 6:40-7:20 Presentation 7:20-7:30 Open QA Location: Boeing Auditorium, in the Seafirst Executive Education Center (SEEC) on the UW main campus (directions below) To register just email [EMAIL PROTECTED] Please put RSVP in the subject line. Directions: Boeing Auditorium, in the Seafirst Executive Education Center(SEEC) on the UW main campus. From I-5 north or south, take the NE 45th St exit. Go east about a mile and a half on NE45th St to 17th Ave NE. Enter through Gate Number 2 at 17th Ave NE. After the guard post, take your first left onto Stevens Way and park in the lot on your left(N5). The SEEC is across the street to the left as you walk out of the lot. Boeing Auditorium is around the right side of the building -- Follow the signs. From 520, take the Montlake Blvd exit and follow Montlake Blvd north to entrance to UW through Gate Number 3. After the guard post, go straight to Stevens Way, turn right, and follow Stevens Way to parking lot N5 (on your right). The SEEC is across the street to the left as you walk out of the lot. Boeing Auditorium is around the right side of the building -- follow the signs. Parking on campus is $2.50. (Parking off campus is FREE!) For further info and directions, see the campus map at http://www.washington.edu/home/maps/northcentral.html. The SEEC building is in coordinate M5. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: grrr... cookies~
Jason, Basically it sounds like you aren't passing your session variables correctly. You aren't using CFCOOKIE and CFLOCATION on the same page are you? If you are, Cold Fusion doesn't support this and you'll need to re-arrange your code such that these two tags never appear on the same page. This topic has inspired a "few" debates here and elsewhere with regards to the proper way this functionality should work, but I won't go there today. ;) Hope this helps, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 06, 2000 12:12 PM To: Cf-Talk Subject: grrr... cookies~ Importance: High I have a cart setup fusebox style... when you select order it runs the main template, calls aps_globals first (containing cfapplication) - then runs the script to add the item to the cart... then cflocation to the cart contents so you can see what is in your cart... for some reason the item added vanishes. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Installing MS PWS to support Studio 4.5
George, PWS only needs only its core components, the option pack core components and transaction server core components. This is the minimum needed to install the server and there isn't really a way to change it if you want your web server to work. You can see the required optional components available if you do a custom setup when installing PWS. I run PWS on both of my personal development machines, and then IIS on my development server for staging and compatibility. PWS isn't great by any means, but its free and it works well with CF. Regards, Ryan Ryan Hill, MCSE Director, Systems Integration Market Matrix, Inc. http://www.marketmatrix.com -Original Message- From: Earl, George [mailto:[EMAIL PROTECTED]] Sent: Friday, March 31, 2000 6:05 AM To: 'Listserv, Cold Fusion' Subject: Installing MS PWS to support Studio 4.5 Where can I find good instructions for which components to include when installing MS Personal Web Server so it will work well with Studio 4.5? Option Pack 4 comes with all kinds of stuff I don't want to install unless the Studio environment needs it. Thanks. George [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
