RE: Hacking Client Variables?
Depending on how your application works, someone could go CFID/CFTOKEN searching trying to find a still active session and try to hijack that session. I've seen it done by accident. Moving your client variables to a 36bit UUID helps with this and what I've done is created a timeoutvariable just in the case the user doesn't log out (and the client variable leaves him logged in) I note the date/time of his last visit and if its greater than 15 minutes of no activity (or whatever acceptable value for you) it clears the variables and requests re-authentication. -Original Message- From: Ben Schwemlein [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2003 8:45 PM To: CF-Talk Subject: Hacking Client Variables? Can anyone suggest a way to hack a query that has WHERE userid = '#CLIENT.userid#' in CF 5 and/or MX? Another developer has an application that has sensitive customer information that is encrypted at the database level, but not at the ColdFusion level. I think this is not secure, but I want some evidence before I make an objection. Any suggestions would help. Our client variables are contained in the Database, and the client IDs are sequential. If there is some way to externally hack and set the client variable, then a Hacker could get all customer info. Thanks, Ben ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql2k vs mySQL vs postgresql (for win2k)
dan martin wrote: I am currently using ms access with a growing 20mb database that I need to upgrade. My initial plan was to migrate over to SQL 2000 because that seems to be the most painless (except for price). I am wondering if it would make more sense to migrate to an open source db: mySQL or postgresql. I am running win2k with cf5 and would like to keep the db on the same server. Does anyone have experience or comparison information between the 3 choices running on win2k? How much work is it to port access to mysql or postgresql? Access to PostgreSQL is very little work. Make sure you read the chapter on datatypes and you are set to go. After you have converted your data you need to look over your queries. PostgreSQL supports more join/subquery constructs as Access, so that is no problem. But you might need to rewrite some of your queries because functions like Year() and DatePart() are not present in PostgreSQL, PostgreSQL uses the standard Extract() for that (writing your own Year() and DatePart() functions is trivial). With MySQL data conversion is similar, but rewriting your queries is a little bit the other way around. Subqueries are not supported so you would need to rewrite them, but there are more functions that behave the same betweeen Access and MySQL. But don't forget that query syntax between Access and MS SQL Server requires some changes too. Are there obvious benefits performance or feature wise between the choices? Featurewise MS SQL Server has advantages over PostgreSQL, which in turn has many advantages over MySQL. I don't think performance matters much for such a small database, except in some rare scenario's. For example, if you disable connection pooling, PostgreSQL will take a much heavier performance hit (it uses one process for each connection). Or if you have some extremely long running requests MS SQL Server will only have limited CALs left to serve other requests. The biggest disadvantage of PostgreSQL, and the one reason I not outright recommending it, is that all the native versions for Windows are still in Beta. You can run a Cygwin version, but it has implications for performance and there might be compatibilities issues if you run other Cygwin applications. I am happily running the beta for a few months now, but that is development only. BTW, one database you didn't mention was Firebird. I hear it is almost as capable as PostgreSQL and it does have a native Windows version. Unfortunately, I have spent too little time working with it to say more. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql2k vs mySQL vs postgresql (for win2k)
Hello! mysql has a very good performance but if you need certain features like views or subselect this database is out of the game. Postgresql fullfills almost all standard criterias for a real database engine but it is a little bit more complex. Running Postgresql on Windows isn't that funny. Some more hints: http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html http://www.google.com/search?q=mysql+versus+postgresql Best regards, Peter Orginale Nachricht Von: dan martin [EMAIL PROTECTED] Betreff: sql2k vs mySQL vs postgresql (for win2k) Datum/Zeit: Montag, 10. März 2003 03:39:36 Hi, I am currently using ms access with a growing 20mb database that I need to upgrade. My initial plan was to migrate over to SQL 2000 because that seems to be the most painless (except for price). I am wondering if it would make more sense to migrate to an open source db: mySQL or postgresql. I am running win2k with cf5 and would like to keep the db on the same server. Does anyone have experience or comparison information between the 3 choices running on win2k? How much work is it to port access to mysql or postgresql? For sql2k the upgrade tool does most of the work for you. Are there obvious benefits performance or feature wise between the choices? Any info would be appreciated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql2k vs mySQL vs postgresql (for win2k)
BTW, one database you didn't mention was Firebird. I hear it is almost as capable as PostgreSQL and it does have a native Windows version. firebird's not quite as standard as postgreSQL (it offers many ANSI SQL-92 features), has some syntax differences from sql server/access. it has some nice features like UDFs, identity-like values before INSERTs, 64 bit IO, both odbc jdbc drivers (and for those you into this sort of thing there's a .NET provider in beta now), and of course transactions, sub queries, stored procedures, etc.. its got a fairly active user community. firebird's unicode support is kind of iffy which to me is important. Unfortunately, I have spent too little time working with it to say more. i've played around with it a bit but never in production. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Restrict IP range for machines that use RDS
With ColdFusion MX is there a way to restrict the IP range of the machines that are able to use RDS? Under 5.0, I moved ide.cfm from where it was installed to where CF Studio looked for it at cfide/main/ide.cfm and then restricted access to that file in IIS. It looks like the only thing you can do under CFMX is turn off RDS altogether. Is that right? -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql2k vs mySQL vs postgresql (for win2k)
Peter Mayer wrote: Hello! mysql has a very good performance but if you need certain features like views or subselect this database is out of the game. Postgresql fullfills almost all standard criterias for a real database engine but it is a little bit more complex. Running Postgresql on Windows isn't that funny. Some more hints: http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html Last modified: 14 May 2001. And even then it claimed to be outdated already. http://www.geocities.com/mailsoftware42/db/dbs.html is more up to date. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple browser/platform screenshots
Can anyone remind me of the URL of the web site that lets you see how a web page looks in multiple browser / versions / platforms? For the archives, it looks like http://www.browsercam.com/ will do the job. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
error
Can anyone help me diagnose this... I am receiving this error from an app that I have hosted. and the server admins and tech support people can not resolve it. access denied (java.io.FilePermission C:\CFusionMX\wwwroot\WEB-INF\cfclasses\cfindex2ecfm1831581047.class read) ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem. When they check for the class file mentioned above, it does not exist in the cfclasses folder.. any ideas? Michael T. Tangorre MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 There are two types of programmers in the world, those who know pointers in C++ and those who don't. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
flash integrated website creation system
Hi list, we have a website-creation system (based on CF) with which some people can create based on layout templates generate their own websites. This is working pretty nice. No the customer want to integrate Flash (Flash-Intro-Functions) to the websites. Is there a way we can provide a Flash-module where the customer can build his own flash intro via a web-interface ??? Thanks for ideas. Uwe SD Solutions Fon: 08122-903791 Fax: 08122-903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Restrict IP range for machines that use RDS
On Monday 10 Mar 2003 10:34 am, Aidan Whitehall wrote: With ColdFusion MX is there a way to restrict the IP range of the machines that are able to use RDS? This is one reason we proxy the CF requests through Apache, we can just use the normal apache allow/deny directives. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Tag Reference PDF
I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Thanks!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Restrict IP range for machines that use RDS
This is one reason we proxy the CF requests through Apache, we can just use the normal apache allow/deny directives. I'm not sure what you mean by proxy the CF requests. Do you have IIS and Apache on the same machine, with Apache being the default web server and handing off all requests for .cfm files to IIS? And I just tried adding /main/cfide.cfm and setting the permissions on that in IIS. Didn't work. Isn't there a setting in IIS that says Check that this file exists, before it calls CFMX? Maybe enabling that as well might work. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Tag Reference PDF
- Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): http://www.cfconf.org/cfconf-99/TeraTechCFtagPoster.pdf Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Restrict IP range for machines that use RDS
On Monday 10 Mar 2003 13:17 pm, Aidan Whitehall wrote: I'm not sure what you mean by proxy the CF requests. Do you have IIS We use the weblogic module, and set it as the handler for the '/' location. and Apache on the same machine, with Apache being the default web server and handing off all requests for .cfm files to IIS? We don't use IIS. I guess in your set-up (assuming IIS can't do proxying) you could run your CF server (use the JRun it ships with ?), on port X, and install apache on port 80, proxying all request with mod_proxy or something to port X. And I just tried adding /main/cfide.cfm and setting the permissions on that in IIS. Didn't work. It won't for anonymous connections. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Tag Reference PDF
On Monday 10 Mar 2003 13:34 pm, Dave Carabetta wrote: printed out to place on my wall Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): I got a nice A3 one in the box... -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
strip quotes
Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Tag Reference PDF
If it is in a file format, can you share that with us? Thanks! [EMAIL PROTECTED] 03/10/03 08:57AM On Monday 10 Mar 2003 13:34 pm, Dave Carabetta wrote: printed out to place on my wall Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): I got a nice A3 one in the box... -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: strip quotes
you can use the replace function or the right function, probably some others too. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:59 AM To: CF-Talk Subject: strip quotes Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: strip quotes
replace(string,,,ALL) At 08:59 AM 3/10/2003 -0500, you wrote: Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: strip quotes
If you know that the only double-quote will be that last character, you can do: #replace(myString, , , all)# (i think that should work...escaping double quotes inside of double quotes always fries my brain). You can also use a conditional to check to see if the last character is a double-quote...and if so, remove that character: cfif right(myString, len(myString) IS cfset myString = right(myString, len(myString)-1) /cfif (same caveat applies re: escaping the quote :) hth, charlie -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:59 AM To: CF-Talk Subject: strip quotes Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Tag Reference PDF
On Monday 10 Mar 2003 14:08 pm, Randell B Adkins wrote: I got a nice A3 one in the box... If it is in a file format, can you share that with us? I guess it might be on the CD, which I don't have to hand. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: strip quotes
rTrim removes spaces. If you want to remove one char from the end, you can use left. cfset newStr = left(oldStr,len(oldStr)-1) This says, basically, take N characters from the left where N is the length minus one. You could also use a regex to replace a single quote at the end. This code shows how the regex will remove the quote at the end, but won't do anything if the quote isn't there... cfset str = Foo moo cfset str2 = Ray cfset str = reReplace(str,$,) cfset str2 = reReplace(str2,$,) cfoutput#str# - #str2#/cfoutput === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:59 AM To: CF-Talk Subject: strip quotes Hello, I know this is an easy one, but I don't use CF all the time so it escapes me. How do I strip quotes from a string? It appears towards the end; ie: TID=227 Do I use rtrim? Thanks. Robert Orlini HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP -- CFMX Very High Queued Requests/Hanging
Jeremy, Drop me an email at [EMAIL PROTECTED] What is the URL of the forums posting? Have you taken a thread dump when the server hangs? Are there any errors in /runtime/logs? Thanks Brandon Purcell Sr Product Support Engineer Macromedia [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
strip quotes
Thanks all for the speedy assistance! Robert Orlini HWW ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Restrict IP range for machines that use RDS
We don't use IIS. I guess in your set-up (assuming IIS can't do proxying) you could run your CF server (use the JRun it ships with ?), on port X, and install apache on port 80, proxying all request with mod_proxy or something to port X. OK. Well, for what I'm after, disabling RDS and using A N Other method is probably going to be a lot less work. Thanks for the suggestion anyway. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Tag Reference PDF
There is a slightly newer poster that I found on TeraTech's website -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk Subject: Re: CF Tag Reference PDF - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): http://www.cfconf.org/cfconf-99/TeraTechCFtagPoster.pdf Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Restrict IP range for machines that use RDS
On Monday 10 Mar 2003 14:20 pm, Aidan Whitehall wrote: disabling RDS and using A N Other method Best practice is to do this for live sites anyway. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: flash integrated website creation system
Uwe, this is not exactly a direct answer but have you looked at how Fusebox 3.0 is used regarding the layouts schema and how that might help in your case? Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper Web Application Specialists -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 4:48 AM To: CF-Talk Subject: flash integrated website creation system Hi list, we have a website-creation system (based on CF) with which some people can create based on layout templates generate their own websites. This is working pretty nice. No the customer want to integrate Flash (Flash-Intro-Functions) to the websites. Is there a way we can provide a Flash-module where the customer can build his own flash intro via a web-interface ??? Thanks for ideas. Uwe SD Solutions Fon: 08122-903791 Fax: 08122-903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Tag Reference PDF
Dangit. Outlook closed on me before I could paste in the link. http://www.cfconf.com/cfun2k/tagposter.pdf It's dated 2000, so it probably is not much newer then 4.5 -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk Subject: Re: CF Tag Reference PDF - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): http://www.cfconf.org/cfconf-99/TeraTechCFtagPoster.pdf Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Tag Reference PDF
where? -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 14:39 To: CF-Talk Subject: RE: CF Tag Reference PDF There is a slightly newer poster that I found on TeraTech's website -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:35 AM To: CF-Talk Subject: Re: CF Tag Reference PDF - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 08:09 AM Subject: CF Tag Reference PDF I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Well, this is where I think you saw it, but, as you will see, the PDF is pretty out-of-date (unless I missed a newer version somewhere): http://www.cfconf.org/cfconf-99/TeraTechCFtagPoster.pdf Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Tag Reference PDF
I don't know how these would look printed out, but you might give them a try: http://download.macromedia.com/pub/coldfusion/documentation/ cfmx_cfml_reference.pdf http://download.macromedia.com/pub/coldfusion/documentation/ cfml_quick_ref.pdf Christian On Monday, March 10, 2003, at 08:09 AM, Randell B Adkins wrote: I found a website awhile back that had a PDF file that showed the CF Function and Tag References. I wanted to have it printed out to place on my wall here in the office. Does anyone recall a website that has that or have the files? Thanks!! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SQL Error with Syntax
OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after CF processes the variables that makes it a query. (WHERE weight = apos;30apos;) Is just what is outputted in the error, it is actually ('30') !--- Dynamic Query --- SELECT zone#getzone.service# AS ship_value FROM #variables.service_table# WHERE weight = '#attributes.weight#' ORDER BY weight desc !--- Above output --- SELECT zone202 AS ship_value FROM 2da WHERE weight = apos;30apos; ORDER BY weight desc !--- PRODUCES This Error --- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '2'. 181 : WHERE weight = '#attributes.weight#' 182 : ORDER BY weight desc 183 : /cfquery 184 : cfset variables.process = Yes 185 : cfset variables.ups_rate = getrate.ship_value VENDORERRORCODE 170 SQLSTATE HY000 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Error with Syntax
If the weight field is number then it should be weight = 30 and not weight = '30' [EMAIL PROTECTED] 03/10/03 09:58AM OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after CF processes the variables that makes it a query. (WHERE weight = apos;30apos;) Is just what is outputted in the error, it is actually ('30') !--- Dynamic Query --- SELECT zone#getzone.service# AS ship_value FROM #variables.service_table# WHERE weight = '#attributes.weight#' ORDER BY weight desc !--- Above output --- SELECT zone202 AS ship_value FROM 2da WHERE weight = apos;30apos; ORDER BY weight desc !--- PRODUCES This Error --- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '2'. 181 : WHERE weight = '#attributes.weight#' 182 : ORDER BY weight desc 183 : /cfquery 184 : cfset variables.process = Yes 185 : cfset variables.ups_rate = getrate.ship_value VENDORERRORCODE 170 SQLSTATE HY000 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: QA / Testing - Use Case Scenarios?
Hello all, Hoping to get some opinions etc here. I am trying to rationalize to the powers that be that some form of Use Case Scenarios would greatly improves quality of work. Does anyone out there have any good examples / definitions of solid testing plans / use case scenarios? I realize that for each project this can change, but I am really interested in finding some good documentation or some type of testing / use case methodology. I thought I remember that testing / qa was part of FLiP but I cannot seem to find much out there about FLiP, can anyone point me towards that as well? Thanks all, All help is much appreciated. -chris.alvarado ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: window.close question?
I used to think that the situation you want to happen was impossible until I found this link: http://aspalliance.com/peterbrunone/impossible.asp Matt Small -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED] Sent: Sunday, March 09, 2003 1:09 PM To: CF-Talk Subject: Re: window.close question? On 3/7/03 10:30 AM, James Blaha [EMAIL PROTECTED] wrote: Hello All: JavaScript Question I need to have JavaScript code work for Netscape 4.7 to open a child window and close the parent and bypass the confirm message. [snip] You should not be able to do this unless you are in a secure, signed, scripting environment. Period. What you are asking invades the user's privacy. When you close the parent, you lose all their page history information -- this is why the confirmation message appears. The confirmation message will always appear if you programmatically try to close a window that the user opened. I am a bit shocked that the code you give doesn't launch a confirmation message in IE and Netscape 6-7. You must have your user privacy settings lower in those browsers. Can someone please send me an example? This code works in IE and Netscape 6-7 but not Netscape 4.7 !--- SCRIPT LANGUAGE = JavaScript { newwin=window.open(Login.cfm,_blank,... ) firstwindow = window.self; firstwindow.opener = window.self; firstwindow.close(); newwin.focus() } /SCRIPT --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Error with Syntax
I'm not sure if SQL Server has issues with having an integer as the first character of a table name, but I suspect that is where the problem is. It's generally a good idea to not start any variable, table or column names with an integer, lest you run into weird issues. I would try wrapping the table name in brackets such as [2da] and see if that works. -Justin Scott - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:58 AM Subject: OT: SQL Error with Syntax OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after CF processes the variables that makes it a query. (WHERE weight = apos;30apos;) Is just what is outputted in the error, it is actually ('30') !--- Dynamic Query --- SELECT zone#getzone.service# AS ship_value FROM #variables.service_table# WHERE weight = '#attributes.weight#' ORDER BY weight desc !--- Above output --- SELECT zone202 AS ship_value FROM 2da WHERE weight = apos;30apos; ORDER BY weight desc !--- PRODUCES This Error --- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '2'. 181 : WHERE weight = '#attributes.weight#' 182 : ORDER BY weight desc 183 : /cfquery 184 : cfset variables.process = Yes 185 : cfset variables.ups_rate = getrate.ship_value VENDORERRORCODE 170 SQLSTATE HY000 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: flash integrated website creation system
Uwe, look into the XML source capabilities of Flash. If you're just looking for something like a standard image with some dynamically defined text over it, that is quite possible. Have the text module in Flash look for some variable text passed to it from an outside source like XML. -Kevin -Original Message- From: Uwe Degenhardt [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 6:48 AM To: CF-Talk Subject: flash integrated website creation system Hi list, we have a website-creation system (based on CF) with which some people can create based on layout templates generate their own websites. This is working pretty nice. No the customer want to integrate Flash (Flash-Intro-Functions) to the websites. Is there a way we can provide a Flash-module where the customer can build his own flash intro via a web-interface ??? Thanks for ideas. Uwe SD Solutions Fon: 08122-903791 Fax: 08122-903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Error with Syntax
Quoting integers in SQL Server is valid, and can help protect against some hack attempts. -Justin Scott - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:00 AM Subject: Re: OT: SQL Error with Syntax If the weight field is number then it should be weight = 30 and not weight = '30' [EMAIL PROTECTED] 03/10/03 09:58AM OK, I cannot see where this SYNTAX error is can anyone else see the possible problem? Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF after CF processes the variables that makes it a query. (WHERE weight = apos;30apos;) Is just what is outputted in the error, it is actually ('30') !--- Dynamic Query --- SELECT zone#getzone.service# AS ship_value FROM #variables.service_table# WHERE weight = '#attributes.weight#' ORDER BY weight desc !--- Above output --- SELECT zone202 AS ship_value FROM 2da WHERE weight = apos;30apos; ORDER BY weight desc !--- PRODUCES This Error --- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near '2'. 181 : WHERE weight = '#attributes.weight#' 182 : ORDER BY weight desc 183 : /cfquery 184 : cfset variables.process = Yes 185 : cfset variables.ups_rate = getrate.ship_value VENDORERRORCODE 170 SQLSTATE HY000 Paul Giesenhagen QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Foxpro databases: does CF use indexes?
Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? How could I tell? How could I *prove to management* that it indeed is using them? If not, can I explicitly use them? How? Thanks in advance for your help... Ed Gordon --- Old so Soon, Smart so Late, When I'm Learning, ... Life is Great! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Broken Actionscript Dictionary Links
Macromedians, The ActionScript dictionary online is really screwed-up in places. For example: http://www.macromedia.com/support/flash/action_scripts/actionscript_dict ionary/actionscript_dictionary241.html Click on the setSelectedIndex() function for more information, it takes you to the POP() function. There are several instaces in the dictionary of broken/incorrect links. They were probably correct before the MX version, but now they're broken. Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Broken Actionscript Dictionary Links
Thanks. I've passed along the info to the appropriate person. Deb -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:30 AM To: CF-Talk Subject: OT: Broken Actionscript Dictionary Links Macromedians, The ActionScript dictionary online is really screwed-up in places. For example: http://www.macromedia.com/support/flash/action_scripts/actionscript_dict ionary/actionscript_dictionary241.html Click on the setSelectedIndex() function for more information, it takes you to the POP() function. There are several instaces in the dictionary of broken/incorrect links. They were probably correct before the MX version, but now they're broken. Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Foxpro databases: does CF use indexes?
Ed Gordon wrote: Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? That is not up to CF to decide but to the database drivers (Foxpro is a filebased desktop db, right?). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Subject: MM will OWN my Devex Submissions?
I think you're right to be concerned. I remember when Apple did this with their online iDisk accounts and Yahoo with their Geocities accounts. In all these cases we can guess that the intent is that they just need to have the right to copy and redistribute the material which is the purpose of the DevEx. But the problems arise with the phrases perpetual, irrevocable, and modify. I'll leave create derivative works up to the jury here though in my opinion it's pretty significant. A basic tenet of copyright law is that the creator is granted automatic copyright. The submission requirements you pointed out appear to do more than just grant a limited right to copy to Macromedia for the purposes of operating the DevEx. It appears that agreeing to them constitutes a complete signing over of copyright ownership to Macromedia. That means they can call it their own and resell it at a profit without recompensing you. They can even integrate it into their own products without recompense. The question is how much of that is the purpose of the DevEx? We all use it to help our own projects, and MM shouldn't be any different. However, it seems to me that MM is in a somewhat unique position by having the ability to integrate submissions into products like Dreamweaver. Is there a difference though between keeping the code and ownership intact and bundling it or the alternative of taking the code concepts and creating a derivative work they call their own and make a profit on? The community persuaded Apple to change their policy. It's up to the community to make Macromedia change theirs. I'm not a lawyer, but I suspect a lawyer would tell you to run, not walk, away from the DevEx based on the current terms. -Kevin -Original Message- From: Tom Sammons [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 4:38 PM To: CF-Talk Subject: Subject: MM will OWN my Devex Submissions? Jeez, I wasn't going to post anything regarding all the MM site changes because there was so much traffic here about it, but I logged into the CF DevEx and found that a few of my submissions were missing. So, I went a step further to see what the new submission areas looked like, and there was the following in the submission agreement: (d) Commercial Submission Only: With respect to the Commercial Submission only, You hereby grant Macromedia a perpetual, irrevocable, royalty-free and worldwide license to use, test, copy, modify, create derivative works of, publicly display, publicly perform or demonstrate the Submission, and/or place a link to a website in connection with such Submission. Non-commercial Submission was very similar, if not the same (my eyes bugged out, I can't remember now 8-). I don't remember this before, but this sounds strikingly like the stuff that MS pulled when they were pushing a centralized storage product/service. Am I reading it wrong, or doesn't this say that I would be giving them licensed ownership (create derivative works of) whatever product or tag I might submit? Please, please correct me and tell me I am reading it wrong. Tom ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Subject: MM will OWN my Devex Submissions?
Shouldn't this stuff be posted on macromedia 'list' at houseoffusion.com? I believe that's why that list exists...? This isn't code related (distribution of code, yes, code related, no). Just curious, ~Todd At 09:52 AM 3/10/2003 -0600, you wrote: I think you're right to be concerned. I remember when Apple did this with their online iDisk accounts and Yahoo with their Geocities accounts. In all these cases we can guess that the intent is that they just need to have the right to copy and redistribute the material which is the purpose of the DevEx. But the problems arise with the phrases perpetual, irrevocable, and modify. I'll leave create derivative works up to the jury here though in my opinion it's pretty significant. A basic tenet of copyright law is that the creator is granted automatic copyright. The submission requirements you pointed out appear to do more than just grant a limited right to copy to Macromedia for the purposes of operating the DevEx. It appears that agreeing to them constitutes a complete signing over of copyright ownership to Macromedia. That means they can call it their own and resell it at a profit without recompensing you. They can even integrate it into their own products without recompense. The question is how much of that is the purpose of the DevEx? We all use it to help our own projects, and MM shouldn't be any different. However, it seems to me that MM is in a somewhat unique position by having the ability to integrate submissions into products like Dreamweaver. Is there a difference though between keeping the code and ownership intact and bundling it or the alternative of taking the code concepts and creating a derivative work they call their own and make a profit on? The community persuaded Apple to change their policy. It's up to the community to make Macromedia change theirs. I'm not a lawyer, but I suspect a lawyer would tell you to run, not walk, away from the DevEx based on the current terms. -Kevin -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: address validation software/systems
Way back when, I integrated one for superletter.com with a company by the name of First Logic. It worked using a COM object, which takes your input and send an XML packet, which you receive back. Worked pretty nicely as I remember, and was fairly easy to integrate. http://www.firstlogic.com/home.asp Dan -Original Message- From: Andres [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:36 PM To: CF-Talk Subject: address validation software/systems Hello all Has anyone ever implemented any address verification and standardization systems in ColdFusion sites? If so, what software did you use? I cannot implement the USPS API tools because we do not ship many of our orders with USPS. I've looked at QAS QuickAddress systems but i am having a problem implementing their COM object. (it requires and returns complex data types such as arrays and i have not been able to get that work with CF) Any suggestions and experiences with other products/services will be much appreciated! Thank you. Andres ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Linux JDBCPool Timeout
Just wondering if anyone has had this problem. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Subject: MM will OWN my Devex Submissions?
If people are concerned about it, then it should be discussed everywhere. If they would rather ignore it, then it should be taken to some rarely traveled list that nobody is on. I've said my piece. -Kevin -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:56 AM To: CF-Talk Subject: RE: Subject: MM will OWN my Devex Submissions? Shouldn't this stuff be posted on macromedia 'list' at houseoffusion.com? I believe that's why that list exists...? This isn't code related (distribution of code, yes, code related, no). Just curious, ~Todd At 09:52 AM 3/10/2003 -0600, you wrote: I think you're right to be concerned. I remember when Apple did this with their online iDisk accounts and Yahoo with their Geocities accounts. In all these cases we can guess that the intent is that they just need to have the right to copy and redistribute the material which is the purpose of the DevEx. But the problems arise with the phrases perpetual, irrevocable, and modify. I'll leave create derivative works up to the jury here though in my opinion it's pretty significant. A basic tenet of copyright law is that the creator is granted automatic copyright. The submission requirements you pointed out appear to do more than just grant a limited right to copy to Macromedia for the purposes of operating the DevEx. It appears that agreeing to them constitutes a complete signing over of copyright ownership to Macromedia. That means they can call it their own and resell it at a profit without recompensing you. They can even integrate it into their own products without recompense. The question is how much of that is the purpose of the DevEx? We all use it to help our own projects, and MM shouldn't be any different. However, it seems to me that MM is in a somewhat unique position by having the ability to integrate submissions into products like Dreamweaver. Is there a difference though between keeping the code and ownership intact and bundling it or the alternative of taking the code concepts and creating a derivative work they call their own and make a profit on? The community persuaded Apple to change their policy. It's up to the community to make Macromedia change theirs. I'm not a lawyer, but I suspect a lawyer would tell you to run, not walk, away from the DevEx based on the current terms. -Kevin -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Subject: MM will OWN my Devex Submissions?
Right, but putting it on the Macromedia list would actually get this in front of MORE Macromedians and actually request feedback from them. I'm not disagreeing with your statements at all in your previous emails and support you and others in getting this clarified with MM. I don't have anything up on Devex to care about tho and I have, in the past, gotten answers out of folks by posting on the Macromedia list... hell, better yet... track down JD (http://markme.com/jd/) and put the question to him directly. I'm sure he'll hunt down something. ~Todd At 10:30 AM 3/10/2003 -0600, you wrote: If people are concerned about it, then it should be discussed everywhere. If they would rather ignore it, then it should be taken to some rarely traveled list that nobody is on. I've said my piece. -Kevin -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ -- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Remove_ALL_connectors.bat?
When you run Remove_ALL_connectors.bat, is it working correctly if it removes *all* ISAPI filters in the Master Web Site in IIS and not just the JRun Connector Filter? I'd interpreted the ALL in the filename to mean the JRun Connector filter for all web sites, not all ISAPI filters for all web sites. When I ran it yesterday whilst uninstalling Updater 2, it removed *all* ISAPI filters that had been set up in the Master Web Site Properties (sspifilt, Compression, md5filt, JRun Connector and, perhaps worse of all, URLScan). -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Foxpro databases: does CF use indexes?
Foxpro is independent of CF. When you submit you cfquery all data gathering is passed off to Foxpro. From there Foxpro will proceed just like it was a Foxpro request, and will use any index it can. I assume that your management has upgraded to Visual FP if they are so concerned about the speed. -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:22 AM To: CF-Talk Subject: Foxpro databases: does CF use indexes? Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? How could I tell? How could I *prove to management* that it indeed is using them? If not, can I explicitly use them? How? Thanks in advance for your help... Ed Gordon --- Old so Soon, Smart so Late, When I'm Learning, ... Life is Great! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remove_ALL_connectors.bat?
When you run Remove_ALL_connectors.bat, is it working correctly if it removes *all* ISAPI filters in the Master Web Site in IIS and not just the JRun Connector Filter? I'd interpreted the ALL in the filename to mean the JRun Connector filter for all web sites, not all ISAPI filters for all web sites. When I ran it yesterday whilst uninstalling Updater 2, it removed *all* ISAPI filters that had been set up in the Master Web Site Properties (sspifilt, Compression, md5filt, JRun Connector and, perhaps worse of all, URLScan). No, that sounds like a bug if it really did that. It should only remove JRun connectors, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Extracting Dates From DB
I have two date questions that I need some help with. First question: I need to extract a records where the member id and current date match. The date is in the SQL DB as a datetime field. I tried using the date format function in the query but could not get it to work. Second question: I am going to need to extract records from the DB where the member id and month and year are the current month and year. Can anyone suggest solutions to these problems. TIA DDINC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Extracting Dates From DB
all kinds of suggestions, why don't you send over some code you are currently trying, and then im sure we can fix 'er right up. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Double Down, Inc. [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:53 AM To: CF-Talk Subject: Extracting Dates From DB I have two date questions that I need some help with. First question: I need to extract a records where the member id and current date match. The date is in the SQL DB as a datetime field. I tried using the date format function in the query but could not get it to work. Second question: I am going to need to extract records from the DB where the member id and month and year are the current month and year. Can anyone suggest solutions to these problems. TIA DDINC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Anyone seen this or know what it means?
A user got this message after completing one of the forms in our application. W2k server/CFMX/SQL Server 200. I did notice they were using a MAC for what it's worth. I pasted the SQL displayed in the error msg directly into the SQL Server and it executed without a problem. Any clues? tia Julian [MERANT][SequeLink JDBC Driver]Statement did not generate a result set. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Subject: MM will OWN my Devex Submissions?
My take on the non-commercial side of the agreement is that MM or anyone else can do what they want with a non-commercial submission. My licensing terms are pretty broad: Use and distribute freely. No warranties express or implied. If I upload freebie code it really is alright with me if someone uses it. It would be the decent thing to do to acknowledge the original author - although I am not so naïve as to believe everyone does that. Still, an up-front statement that we aren't going to do the decent thing is effectively a slap at the developer who is doing the upload. The current wording may functionally get the job done but frankly it shows no class and an unambiguously aggressive intent in a resource whose central tenet is sharing and community assistance. Things like this generally happen when legal gets to do things without sufficient oversight. On the commercial side, if the right to distribute etc. only applies to works I *upload*, then this does not affect me as you cannot download something from the devex that I'm selling. This is implied in the final paragraph of the agreement but not expressly stated. This should be clarified promptly. Its a distraction nobody on either side of the fence needs. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:53 AM To: CF-Talk Subject: RE: Subject: MM will OWN my Devex Submissions? I think you're right to be concerned. I remember when Apple did this with their online iDisk accounts and Yahoo with their Geocities accounts. In all these cases we can guess that the intent is that they just need to have the right to copy and redistribute the material which is the purpose of the DevEx. But the problems arise with the phrases perpetual, irrevocable, and modify. I'll leave create derivative works up to the jury here though in my opinion it's pretty significant. A basic tenet of copyright law is that the creator is granted automatic copyright. The submission requirements you pointed out appear to do more than just grant a limited right to copy to Macromedia for the purposes of operating the DevEx. It appears that agreeing to them constitutes a complete signing over of copyright ownership to Macromedia. That means they can call it their own and resell it at a profit without recompensing you. They can even integrate it into their own products without recompense. The question is how much of that is the purpose of the DevEx? We all use it to help our own projects, and MM shouldn't be any different. However, it seems to me that MM is in a somewhat unique position by having the ability to integrate submissions into products like Dreamweaver. Is there a difference though between keeping the code and ownership intact and bundling it or the alternative of taking the code concepts and creating a derivative work they call their own and make a profit on? The community persuaded Apple to change their policy. It's up to the community to make Macromedia change theirs. I'm not a lawyer, but I suspect a lawyer would tell you to run, not walk, away from the DevEx based on the current terms. -Kevin -Original Message- From: Tom Sammons [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 4:38 PM To: CF-Talk Subject: Subject: MM will OWN my Devex Submissions? Jeez, I wasn't going to post anything regarding all the MM site changes because there was so much traffic here about it, but I logged into the CF DevEx and found that a few of my submissions were missing. So, I went a step further to see what the new submission areas looked like, and there was the following in the submission agreement: (d) Commercial Submission Only: With respect to the Commercial Submission only, You hereby grant Macromedia a perpetual, irrevocable, royalty-free and worldwide license to use, test, copy, modify, create derivative works of, publicly display, publicly perform or demonstrate the Submission, and/or place a link to a website in connection with such Submission. Non-commercial Submission was very similar, if not the same (my eyes bugged out, I can't remember now 8-). I don't remember this before, but this sounds strikingly like the stuff that MS pulled when they were pushing a centralized storage product/service. Am I reading it wrong, or doesn't this say that I would be giving them licensed ownership (create derivative works of) whatever product or tag I might submit? Please, please correct me and tell me I am reading it wrong. Tom ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
RE: Anyone seen this or know what it means?
Have you trimmed all your inputs from browser? Mac maybe adding in that extra CR/LF? -Original Message- From: Julian McNamara [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:04 To: CF-Talk Subject: Anyone seen this or know what it means? A user got this message after completing one of the forms in our application. W2k server/CFMX/SQL Server 200. I did notice they were using a MAC for what it's worth. I pasted the SQL displayed in the error msg directly into the SQL Server and it executed without a problem. Any clues? tia Julian [MERANT][SequeLink JDBC Driver]Statement did not generate a result set. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Server and MS Exchange
I am having a problem getting the MS Exchange 5.5 server to allow the CF Server to send mail. The only way I have gotten it to work is by setting up Exchange as an open relay which is a serious security problems. The machines are both on the same net. Any ideas? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Server and MS Exchange
Just allow the IP of the cf server to relay? -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:10 To: CF-Talk Subject: CF Server and MS Exchange I am having a problem getting the MS Exchange 5.5 server to allow the CF Server to send mail. The only way I have gotten it to work is by setting up Exchange as an open relay which is a serious security problems. The machines are both on the same net. Any ideas? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remove_ALL_connectors.bat?
No, that sounds like a bug if it really did that. It should only remove JRun connectors, I think. Yeah, me too, but I wanted to double-check what the intended operation was. Anticipating the uninstallation being less-than-straightforward, I went through every web site, including the Master, and made a note of the default documents, script mappings and ISAPI filters in them, so they could be recreated manually if it all went pear shaped. After running the Remote_ALL_connectors, all ISAPI filters had been removed from the Master (All) web site. I've also run this file in the past (just before Christmas) and wondered why, when I checked the logs a few weeks later, the Master Web Site was getting requests for ../../cmd.exe and all the stuff you see without URLScan installed. Thing was, it *had* been installed, months before. I checked the ISAPI filters on the Master Web Site and they'd all gone, including URLScan. I put URLScan straight back on and reconfigured it. At the time I wasn't sure what had caused it, but having gone through this installation one step at a time and having seen the same results after running that batch file, I'm 99.9% certain that's the cause. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
sql2k vs mySQL vs postgresql (for win2k)
Thanks very much for the information. It looks like it is definitely worth more investigation. Both alternatives to sql2k look very promising for my purposes. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loading of allaire.controls2.CFTreeApplet.class fails
I've already Patch the Coldfusion System, thats. Thanks for that tip, Neil. The Problem was, that the permissions of the CFJava2.jar-file arent right! Setting this correct, leads thereto that the CFTree Applet run super-duper ;) Benjamin Petz On Wed, 5 Feb 2003 12:53:12 - Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Yes, check out : http://www.macromedia.com/v1/Handlers/index.cfm?ID=20371Method=Full#50 I think its the one which resolves the way an applet loads when it has a JRE greater than 1.3.x -- rotor°Mediengruppe Wissinger Hoefe - Pfuelstr. 5 - 10997 Berlin fon (030) 61 79 190 - fax (030) 61 79 1999 360°communication - http://www.rotor-medien.de ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Restrict IP range for machines that use RDS
Best practice is to do this for live sites anyway. Well (and this is déjà vu, having just had this conversation recently on the CF-Developer list), it *is* damned handy for very minor changes (simple text edits, global variable value alterations, etc) and when your offline copy is half-way through a big development update. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Server and MS Exchange
Tried that and I can't get it to work. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:17 AM To: CF-Talk Subject: RE: CF Server and MS Exchange Just allow the IP of the cf server to relay? -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:10 To: CF-Talk Subject: CF Server and MS Exchange I am having a problem getting the MS Exchange 5.5 server to allow the CF Server to send mail. The only way I have gotten it to work is by setting up Exchange as an open relay which is a serious security problems. The machines are both on the same net. Any ideas? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remove_ALL_connectors.bat?
Anticipating the uninstallation being less-than- straightforward, I went through every web site, including the Master, and made a note of the default documents, script mappings and ISAPI filters in them, so they could be recreated manually if it all went pear shaped. In the future, you can simply back up the IIS metabase. You can do this right within the IIS management console. I would recommend that you do this before making any significant changes, and do it after you've set it up the way you like it, also. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Server and MS Exchange
Hmm ok, that's how I've got it working here, but then it's exchange2k. I have no experience with 5.5, sorry. -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:23 To: CF-Talk Subject: RE: CF Server and MS Exchange Tried that and I can't get it to work. -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:17 AM To: CF-Talk Subject: RE: CF Server and MS Exchange Just allow the IP of the cf server to relay? -Original Message- From: Luis Lebron [mailto:[EMAIL PROTECTED] Sent: 10 March 2003 17:10 To: CF-Talk Subject: CF Server and MS Exchange I am having a problem getting the MS Exchange 5.5 server to allow the CF Server to send mail. The only way I have gotten it to work is by setting up Exchange as an open relay which is a serious security problems. The machines are both on the same net. Any ideas? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Foxpro databases: does CF use indexes?
My memory of using VFP databases with CF was not a good one and seem to remember running into the same issues. I then turned to getting the data into SQL. I realize that may not be an option for you. You might want to check some ASP forums and see if that have any threads on using these databases. Theoretically it is the same, ODBC passing the query along to the DB. I also seem to remember queries doing a number on the server resources. Dan -Original Message- From: Jack Ince [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:38 AM To: CF-Talk Subject: RE: Foxpro databases: does CF use indexes? Foxpro is independent of CF. When you submit you cfquery all data gathering is passed off to Foxpro. From there Foxpro will proceed just like it was a Foxpro request, and will use any index it can. I assume that your management has upgraded to Visual FP if they are so concerned about the speed. -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 7:22 AM To: CF-Talk Subject: Foxpro databases: does CF use indexes? Management here has seen time-to-production decimated since I introduced Cold Fusion. Yet, doubt remains about it's efficiency reading the legacy Foxpro databases. If I have CF read some Foxpro database files (.dbf), will it use the database index files (.cdx) automatically? How could I tell? How could I *prove to management* that it indeed is using them? If not, can I explicitly use them? How? Thanks in advance for your help... Ed Gordon --- Old so Soon, Smart so Late, When I'm Learning, ... Life is Great! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyone seen this or know what it means?
A user got this message after completing one of the forms in our application. W2k server/CFMX/SQL Server 200. I did notice they were using a MAC for what it's worth. I pasted the SQL displayed in the error msg directly into the SQL Server and it executed without a problem. Any clues? [MERANT][SequeLink JDBC Driver]Statement did not generate a result set. I don't have any idea why you received this error message, but have you tried using the SQL Server JDBC driver instead? The error message indicates that you're using the ODBC Socket, which probably won't work as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP PLEASE!!!!
I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMAIL and us-ascii/utf-8 charsets
I've finally got a multipart email working with CFMAIL under CFMX -- with many thanks to Bob Everland and his CF_EmailEveryone tag. However, I've run into a slight problem with character sets. Because of copying/pasting text (from various origins) into a form to build a newsletter, occasionally the newsletter comes out with a strange symbol in place of an m-dash, apostrophe, etc. I know this can be solved on a website by going to a UTF-8 charset, but are there any problems with using UTF-8 in email? All of the examples of multipart email solutions I have seen use a charset of 'us-ascii' and content-transfer-encoding of 7bit...is there any reason to not use UTF-8? Best regards, David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Restrict IP range for machines that use RDS
Enter version control. Then it's a snap to get the current production version to make edits to. Or you could just FTP the current version down from production, edit it, and then replace, but that's not nearly as handy. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 9:22 AM To: CF-Talk Subject: RE: Restrict IP range for machines that use RDS Best practice is to do this for live sites anyway. Well (and this is déjà vu, having just had this conversation recently on the CF-Developer list), it *is* damned handy for very minor changes (simple text edits, global variable value alterations, etc) and when your offline copy is half-way through a big development update. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!!
I don't know the exact fix, but I can tell you a little more about what Access is saying. I have seen this wonderful error before within Access while designing forms. Generally, it only comes up when you have built a form control containing a dot or a bracket in the name, which makes Access choke. How does the update statement work if you remove the email line? M -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF5.0 And CFMX date formats
Hi , This problems has not yet solved.. really appreciate if u have any ideas.. I have written following code to display date.. cfquery name=getDate datasource=DSN_Test select D_DATE from employee /cfquery cfoutput query=getDate #D_DATE# /cfoutput but in CFMX environment it shows : 2003-04-30 00:00:00.0 (milli seconds format.. Its java locale standard date format. Default format.) In CF5.0 Environment it shows : 04/30/2003 00:00:00 (normal format) So here my question is that can we change this default milliseconds format to normal format in CFMX environment with out writing the code.. I know that we can write the code to convert one format to another..but we have a lot of places in another files.. so is there any file where we can change default format to normal format in globally.. it should reflect in all cfm pages too.. Thanks in Advance.. Best regards Ramesh ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
changing MX stand alone server root
Where do I change the web root for the MX stand alone server? Also, what would be the best solution for be able to point between different roots as needed? This is for a local install, and I often need to change as I work on different sites. Is it possible to use multiple port mappings like the 8500, with each pointing to a different site? Thanks, Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dreamweaver changing code on me
I've been gradually moving to DreamweaverMX as my web IDE... just because. Today I was writing (hand coding) a form in code-view. I saved it to my web server and tried running it - didn't work correctly. Looked at the HTML source... WTF - what's all this garbage in here? I opened the file up in CFstudio and it appears that dreamweaver took the liberty of putting it's own tags in there. This is really bad for me... how do I set dreamweaver to save ONLY the code I've written in code view. I need to turn off its proprietary mark-up. Here's what it converted a simple xfa variable into: MM:BeginLock translatorClass=MM_COLDFUSION type=DynData depFiles= orig=%23xfa.pageDescription%23 MM_DYNAMIC_CONTENT SOURCE=xfa.pageDescription DYNAMICDATA=1MM:DECORATION HILITECOLOR=Dyn Untranslated Color{xfa.pageDescription}/MM:DECORATION/MM_DYNAMIC_CONTENTMM:EndLock Help!! Adam. ps... the buttons in my toolbars are all greyed out... CFMLBasic, CFMLflow, CFMLAdvanced, etc. Is there a reason for this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!!
IF you're using SQLServer, it's very finicky about double and single quotes. Double quotes in your values means for SQL to set the values equal to the column name .. e.g. set the column LastName equal to the column 11. But of course you don't have a column called 11. However single quotes tell SQL to set the column equal to the value 11. Therefore, I think your problem is solved if you change your code to: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = '#form.lname#', FirstName = '#form.fname#', Building = '#form.bldg#', DeptCode = '#form.dept#', Job = '#form.job#', Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = '#form.email#', GroupCode = #form.group#, FTE = '#form.fte#', SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery And you had better check the other case too - where you have no quotes at all. They should be single quotes too I think. Not sure why the error message is so vague. Probably because SQL doesn't give ColdFusion back much to work with, but it is very obtuse and would be far better if it told you more about what it was complaining about. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 5:08 AM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!!
You've got to replace your double quotes with single quotes around the text values, otherwise SQL thinks you're trying to update a column. Old: SET LastName = #form.lname#, New: SET LastName = '#form.lname#', Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP PLEASE!!!! - SOLVED
Thanks everyone for the help! Scott -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:32 PM To: CF-Talk Subject: RE: HELP PLEASE IF you're using SQLServer, it's very finicky about double and single quotes. Double quotes in your values means for SQL to set the values equal to the column name .. e.g. set the column LastName equal to the column 11. But of course you don't have a column called 11. However single quotes tell SQL to set the column equal to the value 11. Therefore, I think your problem is solved if you change your code to: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = '#form.lname#', FirstName = '#form.fname#', Building = '#form.bldg#', DeptCode = '#form.dept#', Job = '#form.job#', Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = '#form.email#', GroupCode = #form.group#, FTE = '#form.fte#', SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery And you had better check the other case too - where you have no quotes at all. They should be single quotes too I think. Not sure why the error message is so vague. Probably because SQL doesn't give ColdFusion back much to work with, but it is very obtuse and would be far better if it told you more about what it was complaining about. Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 2003 5:08 AM To: CF-Talk Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HELP PLEASE!!!!
Perhaps try using single quotes instead of double quotes around the values. -Justin Scott - Original Message - From: Scott Wilhelm [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM Subject: HELP PLEASE I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = UPDATE Staff SET LastName = 11, FirstName = 21, Building = West Side Elementary, DeptCode = 09, Job = 3, Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = [EMAIL PROTECTED], GroupCode = 4, FTE = .50, SupevisorID = 25 WHERE ID = 1137 Data Source = SLL_STAFF The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=updateid=1137 With this code: cfquery name=InsertStaff datasource=SLL_Staff dbtype=ODBC UPDATE Staff SET LastName = #form.lname#, FirstName = #form.fname#, Building = #form.bldg#, DeptCode = #form.dept#, Job = #form.job#, Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = #form.email#, GroupCode = #form.group#, FTE = #form.fte#, SupevisorID = #form.sup# WHERE ID = #URL.id# /cfquery Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org http://www.sllboces.org/ [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: changing MX stand alone server root
Where do I change the web root for the MX stand alone server? All configuration options for it are here: http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_ webserver/ Also, what would be the best solution for be able to point between different roots as needed? This is for a local install, and I often need to change as I work on different sites. Is it possible to use multiple port mappings like the 8500, with each pointing to a different site? I don't think you can configure the JRun web server to support multiple virtual servers, which would really be your best solution. I'd recommend that you set up a real web server, like Apache or IIS, for this. Either will do. You can configure as many virtual server as you want, when you do that. On my laptop, for instance, I set up new virtual servers whenever I feel the need, and they all listen on the same IP and port, and I use host-header names to differentiate between them. I add entries into my HOSTS file to make that work. However, if you just want to make do with the JRun web server, you could simply keep multiple copies of the configuration file, and switch back and forth as desired. Oh, and where it says under the above article that you can't change the interface attribute, I've found that it works fine if you specify an IP address for the attribute value. I did that on my machine to bind the JRun web server to 127.0.0.1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Changing from HTTPS to HTTP for normal pages
What's the best way to setup the page links so that when you go to a secure page via https and then go to a non-secure page the links use http? Do I need to hard code the full url? Thanks, Issac ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
changing MX stand alone server root
Thanks Dave! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver changing code on me
I was experiencing a known bug in the original version of DreamweaverMX. I installed the latest updater - so-far-so-good. My buttons in the toolbars are still all grayed out. Any idea on that one? Adam. -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 12:29 PM To: CF-Talk Subject: Dreamweaver changing code on me I've been gradually moving to DreamweaverMX as my web IDE... just because. Today I was writing (hand coding) a form in code-view. I saved it to my web server and tried running it - didn't work correctly. Looked at the HTML source... WTF - what's all this garbage in here? I opened the file up in CFstudio and it appears that dreamweaver took the liberty of putting it's own tags in there. This is really bad for me... how do I set dreamweaver to save ONLY the code I've written in code view. I need to turn off its proprietary mark-up. Here's what it converted a simple xfa variable into: MM:BeginLock translatorClass=MM_COLDFUSION type=DynData depFiles= orig=%23xfa.pageDescription%23 MM_DYNAMIC_CONTENT SOURCE=xfa.pageDescription DYNAMICDATA=1MM:DECORATION HILITECOLOR=Dyn Untranslated Color{xfa.pageDescription}/MM:DECORATION/MM_DYNAMIC_CONTE NTMM:EndLock Help!! Adam. ps... the buttons in my toolbars are all greyed out... CFMLBasic, CFMLflow, CFMLAdvanced, etc. Is there a reason for this? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inserting date/time stamp
Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
You could always use an application variable. I'm not sure what that has to do with a date/time object. Just out of curiosity, if this is going to a database, can't you just create a unique self-incrementing field and use that? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:14 PM : To: CF-Talk : Subject: Inserting date/time stamp : : : Hi, : : I have a form that I want to insert the date and time when the : form is opened. This will also be saved to a database when saved. : : Whats the best way of also creating a automatic reference no : which increments when a new form is opened? : : Any ideas... : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 5 location of undelivered mail folder
Hello All, Is there a way to change the location of the undelivered mail folder in CF 5? I'd really to place it on another drive (instead of the boot drive of my webserver). TIA, David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Changing from HTTPS to HTTP for normal pages
- Original Message - From: Issac Rosa [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:59 AM Subject: Changing from HTTPS to HTTP for normal pages What's the best way to setup the page links so that when you go to a secure page via https and then go to a non-secure page the links use http? Do I need to hard code the full url? If you mean including the protocol, yes. Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? I want the date and time the form was opened/created. For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). Thanks === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MX Error
I am receiving this error on a CFMX site. You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members The section of code that it does not like is this piece that is wrapped inside a cfscript tag: if (UserType.RecordCount NEQ 0) { Request.UserType = #UserType#; } else { Request.UserType = Clinical; } I am not sure what the deal is. TIA, Bruce ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inserting date/time stamp
Why not just have a date/time field in your DB that gets autofilled with the server time when you add the form data record when the user submits the form? At 02:13 PM 3/10/2003 -0500, you wrote: Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. I want something like: Monday, March 10, 2003 at 2:26pm On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Special Characters driving me nuts
Greetings, I've been fighting with user-input and special characters for days now, I'm starting to get really frustrated. Here's the scenario: 1. User enters data into a textarea field. This will usually contain several special characters (?/{}[]|\[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]*, *,?/{}[]|\-_+)(^) 2. I use URLEncodedFormat before sticking the data in my database table, so I'm storing encoded data 3. I use URLDecode when retrieving the data into an HTML page to show the data entered. Here's the problem: Data that begins with a special character doesn't display. Data that is surrounded by marks doesn't display For example: This line won't display in HTML This line $ will display in HTML This line will not display in HTML $This line will not display in HTML If I use HTMLEditFormat() I still can't see the items surrounded by marks and it also displays the URLEncodedFormat information so space = %20 on screen in the HTML page. How do I overcome this issue? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
On Mon, 10 Mar 2003 14:23:36 -0500, Ben Doom wrote: You could always use an application variable. I'm not sure what that has to do with a date/time object. Just out of curiosity, if this is going to a database, can't you just create a unique self-incrementing field and use that? How? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:14 PM : To: CF-Talk : Subject: Inserting date/time stamp : : : Hi, : : I have a form that I want to insert the date and time when the : form is opened. This will also be saved to a database when saved. : : Whats the best way of also creating a automatic reference no : which increments when a new form is opened? : : Any ideas... : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sort XML without XSLT?
I am successfully displaying data on the web site, however, in some cases I can not use XSLT because of some formatting limitations (actually client peculiarities). My page looks like this so far: table cellspacing=0 cellpadding=0 width=100% cfloop index=i from=1 to=#getcontent.recordcount# cfif findnocase(live,list) AND live eq yes OR url.status eq live tr td valign=top width=75#DateFormat(XmlUnFormat(GetContent.XmlFeed[i].contentdata.XmlChildren[i].date.XmlText), ' DD, ')#/td td valign=topa href=/index.cfm/page/#getcontent.label#.htm#Ucase(XmlUnFormat(GetContent.XmlFeed[i].contentdata.XmlChildren[i].common.label.XmlText))#/abrnbsp;br/td /tr /cfif /cfloop /table It is working dandy, however, is there anyway I can sort this stuff (alpha, date, etc?) Regards, Michael J. Sammut F O U R E Y E S P R O D U C T I O N S think | plan | create :: web site design development :: NYC E. [EMAIL PROTECTED] | T: 718.254.9557 ext. 101 | F: 718.254.0399 W. http://www.foureyes.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
see inline -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:27 PM To: CF-Talk Subject: RE: Inserting date/time stamp HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. Beeter talk to Mr. Wells, he might agree with you! LOL! I want something like: Monday, March 10, 2003 at 2:26pm look at the DateFormat function Doug On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
Check your DateFormat() and TimeFormat() functions. It's there, check the help files. ~Todd At 02:26 PM 3/10/2003 -0500, you wrote: HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. I want something like: Monday, March 10, 2003 at 2:26pm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
You need to format it. #DayOfWeekAsString(Now())#, #DateFormat(Now(), d, )# at #TimeFormat(Now(),h:mmtt)# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:27 PM To: CF-Talk Subject: RE: Inserting date/time stamp HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. I want something like: Monday, March 10, 2003 at 2:26pm On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inserting date/time stamp
dateformat() and timeformat() should take care of display issues nicely for you. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:27 PM : To: CF-Talk : Subject: RE: Inserting date/time stamp : : : HmmmI also want the date and time displayed on my form. I did : a cfoutput#now()#/cfoutput but I don't like the results. : : I want something like: : : Monday, March 10, 2003 at 2:26pm : : : : On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: : : Do you want to know the time when the form was 'opened' (viewed you : mean) or actually saved? For example, I may hit your form at 12:01 PM, : and it may take me 5 minutes to fill it out. So would you want 12:01 PM : stored, or 12:06 PM, the time when the form was actually submitted? If : you want the first time, simply eded this in the form: : : input type=hidden name=theTime value=#now()# : : and store form.theTime in your db. If you want the time submitted, just : passed now() to your database (or whatever function your db uses to : represent the current time). : : === : Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc : Member of Team Macromedia : : Email: [EMAIL PROTECTED] : Blog : www.camdenfamily.com/morpheus/blog : Yahoo IM : morpheus : : My ally is the Force, and a powerful ally it is. - Yoda : : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 1:14 PM : To: CF-Talk : Subject: Inserting date/time stamp : : : Hi, : : I have a form that I want to insert the date and time when : the form is opened. This will also be saved to a database when saved. : : Whats the best way of also creating a automatic reference : no which increments when a new form is opened? : : Any ideas... : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MX Error
Isn't usertype the name of your query record set? Here you are setting request.usertype equal to your entire record set (or you would be if you went without the quotes and hashes. Request.UserType = #UserType#; Perhaps you want... Request.UserType = UserType.usertype[1]; Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:25 AM Subject: MX Error I am receiving this error on a CFMX site. You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members The section of code that it does not like is this piece that is wrapped inside a cfscript tag: if (UserType.RecordCount NEQ 0) { Request.UserType = #UserType#; } else { Request.UserType = Clinical; } I am not sure what the deal is. TIA, Bruce ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Special Characters driving me nuts
common PITA... I usually do a Replace(stringname, '', quot;) and a Replace(string, ', rsquo) assuming the and ' are stored in the DB as and ' respectively. Note for dumping data like this into JavaScript, escape them. Doug -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:27 PM To: CF-Talk Subject: Special Characters driving me nuts Greetings, I've been fighting with user-input and special characters for days now, I'm starting to get really frustrated. Here's the scenario: 1. User enters data into a textarea field. This will usually contain several special characters (?/{}[]|\[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]*, *,?/{}[]|\-_+)(^) 2. I use URLEncodedFormat before sticking the data in my database table, so I'm storing encoded data 3. I use URLDecode when retrieving the data into an HTML page to show the data entered. Here's the problem: Data that begins with a special character doesn't display. Data that is surrounded by marks doesn't display For example: This line won't display in HTML This line $ will display in HTML This line will not display in HTML $This line will not display in HTML If I use HTMLEditFormat() I still can't see the items surrounded by marks and it also displays the URLEncodedFormat information so space = %20 on screen in the HTML page. How do I overcome this issue? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net http://www.garrisonenterprises.net/ [EMAIL PROTECTED] (704) 569-9044 ext. 254 *** * * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] *** * * ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4