RE: Random row from SQL
yeah - thats the one I posted - works great, takes load of CF server etc. -Original Message- From: Park, Simon [mailto:[EMAIL PROTECTED]] Sent: 13 February 2002 22:00 To: CF-Talk Subject: RE: Random row from SQL Here's a link that someone posted when I asked this question a few weeks ago. Haven't had a chance to try it out but it looks like what you want http://www.aspalliance.com/stevesmith/articles/randomselect.asp =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-== Simon Park Computer Systems Management, Inc. Ph: 703-823-4300 x119 205 South Whiting Street #201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.com -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 2:44 PM To: CF-Talk Subject: RE: Random row from SQL Yes, I know how to do this in CF - I was wondering if anyone had figured out a __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfinclude, who to pass for variables to?
hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. thanks a bunch __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can CF connect to remote Sybase database?
Create the connection through the CF administrator using a Native driver. It is just like creating and other ODBC or Native connection. Dan Rosenbaum Wachovia Securities Corporate Investment Banking [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 5:53 PM To: CF-Talk Subject: Re: Can CF connect to remote Sybase database? Is it possible for CF to connect to a live remote Sybase database so one can run queries and create reports on live data. If so, how do you go about doing it and what are the security ramifications? Thanks. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Form Data - Post
i read this thread and found it interesting. i don't know the answer and wan unable to find it. I know that at the length of the data in a GE T messgage is fixed and limited by constraints on valid URL formatting. However, post is obviously not. I couldn't find any concrete info on the POST length and I went as far as looking into the ISO for http. That leads me to believe that there isn't one. I don't see how that can really be any practical limit on a POST messag e since you can use it so send a file input stream. anyone have insight here? Jon Hall [EMAIL PROTECTED] on 02/14/2002 12:44:37 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: Form Data - Post Why not set an arbitrary maxlength on the field? jon Eric Homa wrote: Hi, Anyone know if there is a limit on the number of characters that can besubmitted from the client browser to the server using cfform meth= post? I am using a couple of memo fields along with other fields and it's w or ked for 4 months. Today the customer called and described an error mes sage that he was getting. It is an error message from my code when I check f or t he existence of a field (IsDefined) that directly follows one of the mem o fields. I'm think that he copied and pasted so much data into the form field that the browser (or the protocol) cannot handle it. Any ideas? Thanks, Eric Homa __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfinclude, who to pass for variables to?
You can't pass variables to an include page. The include page will act as if the code in that page was typed directly into the file that has the cfinclude You can set up the variables before the include page is included and those variables are available to the code in the include page. Mike - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 7:44 AM Subject: cfinclude, who to pass for variables to? hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. thanks a bunch __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how to stop ezEdit grabbing focus
You tried every focus? I just commented out the focus() on line 291 of the ezedit.htc file (version 1.0) function ezEdit_loadHTML(HTML){ element.document.body.innerHTML = HTML; //focus(); } Tried it a couple of times, when the focus() is commented out, the focus on the ezEdit field isn't set. Regards, Chris -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 6:23 PM To: CF-Talk Subject: how to stop ezEdit grabbing focus Does anyone with experience of ezEdit (the now outdated WYSIWYG text editor custom tag from www.siteobjects.com) know how to stop it grabbing focus when a page loads? There is mention of this problem on the ezEdit forum from last year. Brett posted a 'solution', and the original poster said Nope, didn't work - and there's nothing else! I've tried everything I can think of. The ezEdit element has to be halfway down a form I've done, and when the page loads it jumps down to that point. I've tried removing every 'focus();' in ezEdit.htc, but it still does it. Anyone know? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Download via cfcontent:garbage @ EOF
Howdy, I have a file that has been tar'd then gzipped. I download the file using cfheader cfcontent. it downloads fine but when I unzip it an error popup pops up saying there is garbage at the EOF. Does anyone know how to get rid of the garbage? Here is the code, this is the only line of the file, the code is all on one line but I split it up onto seperate lines for this posting. Thanks in advance! Joe [EMAIL PROTECTED] cfheader name=Content-Disposition value=attachment; filename=TheFile236.tar.gz cfcontent type=application/x-zip-compressed __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfinclude, who to pass for variables to?
Paul, just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. All you need to do is send the search form to the page that you're currently displaying, with some kind of action that says, ok, I've got a search request here, so I should include the template that gets the search results and then display the results in those small boxes. You don't need to pass anything through to the included page. Anything that is available in the template that's doing the including will be available in the included page. Regards Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Connection to a Lotus Notes Database
Well, when I create a query based on the dsn name it seems to go off to never never land and not come back, I end up re-booting my dev box. THAT's new. I haven't seen that one before. Most of the problems I had were of the 'Request Timed Out' variety, and I was able to correct them using an updated driver. I sounds to me like a memory leak. All I can say is make sure you are using the once that came with that exact relase of Domino and check the Web site for updates. Sorry I couldn't be of any more help... Mike -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 7:26 PM To: CF-Talk Subject: Re: Connection to a Lotus Notes Database Mike, Well, when I create a query based on the dsn name it seems to go off to never never land and not come back, I end up re-booting my dev box. GEEZM AN! why the hell do people think that this crap works seamlessly!. (little gripe) Ok well I remember back in my domino days that the database was a 64bit where the NT based database was 32bit, this would mean that the databases could not communicate via a ODBC connection unless their was a native ODB C driver to use right? hence the un-reliable connection, so is this even possible because if the CF server doesn't see the native driver? Ernie - Original Message - From: Haggerty, Michael A. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 12:36 PM Subject: RE: Connection to a Lotus Notes Database Ernie; What error messages are you getting? The ODBC drivers distributed with the Notes package are not known for being 'reliable', and the times I have needed to work with them have always ended with headaches. Mike -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 10:57 AM To: CF-Talk Subject: Connection to a Lotus Notes Database Can this be done and if so how? I've got the native driver to connect via ODBC however I can't manage the onnection or do a query in coldfusion 5. I also can connect and link via access database and I am able to view the data. So if anyone is doing this please help! Ernie Pena __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
You can't pass variables in a cfinclude, but you could use cfhttp, since it's on the same server it should work just as fast as a cfinclude, and you can pass variables in cfhttp. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 7:45 AM To: CF-Talk Subject: cfinclude, who to pass for variables to? hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. thanks a bunch __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Split up a credit card number? Need regex handout!
it's a space delimited list. ListLast(myCC, ) will give you the last set of digits, as an example. christopher olive, cto, vp of web development atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 5:14 PM To: CF-Talk Subject: Split up a credit card number? Need regex handout! Hello everyone, I need to take a given form field (numbers) and break it into 2 parts. Then insert one part, and cfmail the other. The number can be different lengths. For example: 3939 may get passed by a form field. I need to insert the 3939 to a DB, and cfmail the . I must admit that I'm stuck on this one, I can't even get a good working start. I can take the number and replace the first 4 digits with nothing, which will give me the second half. But then how to get the first 4 digits? Am I going about this the wrong way? Is there a better approach? Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Wednesday, February 13, 2002, at 4:58:30 PM __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OLEDB connection failing intermittently!
My CF (OLEDB) connection to MSSQL is failing intermittently, and I can't recreate the problem. I have even looped a query 10,000 times with 100% success. Every once in a while, maybe 1/1000 times, a user will generate the attached error (I'm catching the error and mailing it to myself). I'm running CF5 and MSSQL 2000, and connecting via OLEDB. I'll provide more information if necessary... Thanks, Jamie CFTry/CFCatch Variables DETAIL ERRORCODE 42000 EXTENDEDINFO MESSAGE OLEDB Error Code = 18456 Login failed for user 'myUserName'. (^ this error stinks because I lose the user's SQL) NATIVEERRORCODE 18456 SQLSTATE 42000 TAGCONTEXT TYPE DATABASE __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Download via cfcontent:garbage @ EOF
Try cfcontent type=application/x-msdownload Or cfcontent type=application/octet-stream __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Ledva, Joseph (Joe) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:36 AM To: CF-Talk Subject: Download via cfcontent:garbage @ EOF Howdy, I have a file that has been tar'd then gzipped. I download the file using cfheader cfcontent. it downloads fine but when I unzip it an error popup pops up saying there is garbage at the EOF. Does anyone know how to get rid of the garbage? Here is the code, this is the only line of the file, the code is all on one line but I split it up onto seperate lines for this posting. Thanks in advance! Joe [EMAIL PROTECTED] cfheader name=Content-Disposition value=attachment; filename=TheFile236.tar.gz cfcontent type=application/x-zip-compressed __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Download via cfcontent:garbage @ EOF
you don't need the cfheader, just use cfcontent, ie example below... cfcontent type=application/x-zip-compressed file=blah.zip deletefile=No Nat -Original Message- From: Ledva, Joseph (Joe) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:36 AM To: CF-Talk Subject: Download via cfcontent:garbage @ EOF Howdy, I have a file that has been tar'd then gzipped. I download the file using cfheader cfcontent. it downloads fine but when I unzip it an error popup pops up saying there is garbage at the EOF. Does anyone know how to get rid of the garbage? Here is the code, this is the only line of the file, the code is all on one line but I split it up onto seperate lines for this posting. Thanks in advance! Joe [EMAIL PROTECTED] cfheader name=Content-Disposition value=attachment; filename=TheFile236.tar.gz cfcontent type=application/x-zip-compressed __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Download via cfcontent:garbage @ EOF
Good suggestion, I still get the garbage tho. I'll try some other types. Joe -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:19 AM To: CF-Talk Subject: RE: Download via cfcontent:garbage @ EOF Try cfcontent type=application/x-msdownload Or cfcontent type=application/octet-stream __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Ledva, Joseph (Joe) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:36 AM To: CF-Talk Subject: Download via cfcontent:garbage @ EOF Howdy, I have a file that has been tar'd then gzipped. I download the file using cfheader cfcontent. it downloads fine but when I unzip it an error popup pops up saying there is garbage at the EOF. Does anyone know how to get rid of the garbage? Here is the code, this is the only line of the file, the code is all on one line but I split it up onto seperate lines for this posting. Thanks in advance! Joe [EMAIL PROTECTED] cfheader name=Content-Disposition value=attachment; filename=TheFile236.tar.gz cfcontent type=application/x-zip-compressed __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Saving a web page as an image
This is a probably shot in the dark, but is there a custom tag or code out there that will allow a user, at the click of a button, to capture the current web page that they are on, and save it as an image. Basically I have a client who is viewing dynamically generated graphs on a web page. Instead of having to take a screen dump, and save it as an image in some sort of graphics tool, the user wants to click a button and have that current page saved automatically as an image so that he can use it in future presentations. Is there an solution to this, or will the client have to do it the old fashioned way. Cheers, __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfinclude, who to pass for variables to?
Steve, You can't pass variables in a cfinclude, but you could use cfhttp, since it's on the same server it should work just as fast as a cfinclude, and you can pass variables in cfhttp. No man! Its definitely not just as fast! cfinclude, just includes a file direct from the server at interpreting time (i.e.. when the template is called), where you can process the contents immediately using any variables available in the calling template. cfhttp will make a http connection back to the web server, which will connect to the cf server to pick up the template, interpret it, send the results back to the web server which then sends the results back to the template with the cfhttp in it, where you'll then have to process the cfhttp results. You don't need to pass variables into the cfinclude, because any variables that are available in the calling template are available in the included template as well. Its as if the code you've just included was there directly in the page. Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Saving a web page as an image
Why not use CFGRAPH and use .jpg as the output format, they can save that file? Pete - Original Message - From: Chris Bohill [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 10:26 AM Subject: Saving a web page as an image This is a probably shot in the dark, but is there a custom tag or code out there that will allow a user, at the click of a button, to capture the current web page that they are on, and save it as an image. Basically I have a client who is viewing dynamically generated graphs on a web page. Instead of having to take a screen dump, and save it as an image in some sort of graphics tool, the user wants to click a button and have that current page saved automatically as an image so that he can use it in future presentations. Is there an solution to this, or will the client have to do it the old fashioned way. Cheers, __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Saving a web page as an image
When you press the print screen button, and puts a bitmap of the screen into your clipboard. Javascript has access to the clipboard. I'm not sure if he wants to save his files as bitmaps though, since they are rather large. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Chris Bohill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:26 AM To: CF-Talk Subject: Saving a web page as an image This is a probably shot in the dark, but is there a custom tag or code out there that will allow a user, at the click of a button, to capture the current web page that they are on, and save it as an image. Basically I have a client who is viewing dynamically generated graphs on a web page. Instead of having to take a screen dump, and save it as an image in some sort of graphics tool, the user wants to click a button and have that current page saved automatically as an image so that he can use it in future presentations. Is there an solution to this, or will the client have to do it the old fashioned way. Cheers, __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
Ok were talking milliseconds here, but yeah variables are passed to any page that you cfinclude, so it would be easier to do it that way. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:38 AM To: CF-Talk Subject: Re: cfinclude, who to pass for variables to? Steve, You can't pass variables in a cfinclude, but you could use cfhttp, since it's on the same server it should work just as fast as a cfinclude, and you can pass variables in cfhttp. No man! Its definitely not just as fast! cfinclude, just includes a file direct from the server at interpreting time (i.e.. when the template is called), where you can process the contents immediately using any variables available in the calling template. cfhttp will make a http connection back to the web server, which will connect to the cf server to pick up the template, interpret it, send the results back to the web server which then sends the results back to the template with the cfhttp in it, where you'll then have to process the cfhttp results. You don't need to pass variables into the cfinclude, because any variables that are available in the calling template are available in the included template as well. Its as if the code you've just included was there directly in the page. Regards Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
Try doing a loop over this 1000 times, the CFHTTP will open 1000 connections where as the cfinclude does one import. Nat -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:43 AM To: CF-Talk Subject: RE: cfinclude, who to pass for variables to? Ok were talking milliseconds here, but yeah variables are passed to any page that you cfinclude, so it would be easier to do it that way. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:38 AM To: CF-Talk Subject: Re: cfinclude, who to pass for variables to? Steve, You can't pass variables in a cfinclude, but you could use cfhttp, since it's on the same server it should work just as fast as a cfinclude, and you can pass variables in cfhttp. No man! Its definitely not just as fast! cfinclude, just includes a file direct from the server at interpreting time (i.e.. when the template is called), where you can process the contents immediately using any variables available in the calling template. cfhttp will make a http connection back to the web server, which will connect to the cf server to pick up the template, interpret it, send the results back to the web server which then sends the results back to the template with the cfhttp in it, where you'll then have to process the cfhttp results. You don't need to pass variables into the cfinclude, because any variables that are available in the calling template are available in the included template as well. Its as if the code you've just included was there directly in the page. Regards Stephen __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
Not only that, but CFINCLUDE includes the file out of the template cache and only checks the disk subsystem to see if it has changed (unless you are using a trusted cache) - so it is basically pulling directly from memory, about as fast as you can get I'd say. Mark -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 7:38 AM To: CF-Talk Subject: Re: cfinclude, who to pass for variables to? Steve, You can't pass variables in a cfinclude, but you could use cfhttp, since it's on the same server it should work just as fast as a cfinclude, and you can pass variables in cfhttp. No man! Its definitely not just as fast! cfinclude, just includes a file direct from the server at interpreting time (i.e.. when the template is called), where you can process the contents immediately using any variables available in the calling template. cfhttp will make a http connection back to the web server, which will connect to the cf server to pick up the template, interpret it, send the results back to the web server which then sends the results back to the template with the cfhttp in it, where you'll then have to process the cfhttp results. You don't need to pass variables into the cfinclude, because any variables that are available in the calling template are available in the included template as well. Its as if the code you've just included was there directly in the page. Regards Stephen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT (slightly) email aliases
Does anyone know how email aliases work? - sites like bigfoot.com or spamex.com where you register and are given an email address which forwards all mail to your regular account. I have a client who wants to do this but doesn't have a great deal of cash. Is it easy to do and can it be done programmatically from CF? I would want to tie these emails to a user database we already have. We're running CF5 on Win2000 server Many thanks for any help __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT (slightly) email aliases
It is built into most e-mail servers I have worked with. Remember that CF is not an e-mail server, although it can access an e-mail server. I suppose if you really wanted to, you could use CF to check e-mail using cfpop and then forward the e-mail to another e-mail address using cfmail. I suspect there is probably a better way, though. At 03:51 PM 02/14/2002 +, you wrote: Does anyone know how email aliases work? - sites like bigfoot.com or spamex.com where you register and are given an email address which forwards all mail to your regular account. I have a client who wants to do this but doesn't have a great deal of cash. Is it easy to do and can it be done programmatically from CF? I would want to tie these emails to a user database we already have. We're running CF5 on Win2000 server Many thanks for any help __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (slightly) email aliases
Just get an account with bigmailbox.com, I believe they have email forwarding. But, if you must use CF-- One way to do it would be to have a database of email address and usernames. Then using CFPOP (this is if all email with @yourdomain.com goes to one mailbox) retrieve the messages, and send them out to the user's forwarding address (from the database) That way would require CF to do all of the work, and it probably really slow, I'm sure there are quite a few better solutions. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Ben Whalley [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:52 AM To: CF-Talk Subject: OT (slightly) email aliases Does anyone know how email aliases work? - sites like bigfoot.com or spamex.com where you register and are given an email address which forwards all mail to your regular account. I have a client who wants to do this but doesn't have a great deal of cash. Is it easy to do and can it be done programmatically from CF? I would want to tie these emails to a user database we already have. We're running CF5 on Win2000 server Many thanks for any help __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT (slightly) email aliases
It's not an alias. It's a forwarded account. If you are using sendmail or qmail as your mail server software you would use a .foward file. I am not sure where CF would come in unless you want a frontend to maintain the fowarding file. On Thu, 14 Feb 2002, Ben Whalley wrote: Does anyone know how email aliases work? - sites like bigfoot.com or spamex.com where you register and are given an email address which forwar ds all mail to your regular account. I have a client who wants to do this but doesn't have a great deal of cas h. Is it easy to do and can it be done programmatically from CF? I would wan t to tie these emails to a user database we already have. We're running CF5 on Win2000 server Many thanks for any help __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT (slightly) email aliases
iMS can do this with only a few lines of code. It could integrate into your ColdFusion site seemlessly and you wouldn't need to use cfpop of cfmail. iMS is akin to a web server using ColdFusion as it is a server and ColdFusion controls the functionality. When mail is received by the iMS SMTP Server you can have your template look at the incoming recipient and send it to another address. For example: cfquery name=getaddresses datasource=iMS select forwards from emails where emailaddr is form.smtpto /cfquery cfoutputrecipients=#getaddresses.forwards#/cfoutput And, that's it - four lines of code. You can even have multiple forwarding addresses as long as you output them in a comma-delimited format. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Ben Whalley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 10:51 AM Subject: OT (slightly) email aliases Does anyone know how email aliases work? - sites like bigfoot.com or spamex.com where you register and are given an email address which forwards all mail to your regular account. I have a client who wants to do this but doesn't have a great deal of cash. Is it easy to do and can it be done programmatically from CF? I would want to tie these emails to a user database we already have. We're running CF5 on Win2000 server Many thanks for any help __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfinclude, who to pass for variables to?
Ok were talking milliseconds here, but yeah variables are passed to any page that you cfinclude, so it would be easier to do it that way. That may be true with one or two users on the server, but you try that on a live server with hundreds of concurrent users where the web server is queuing request, CF is queuing requests and your database is queuing too! You'll wind up with a deadlock and timeout on the CFHTTP! Here's how it goes... say you've got 3 users and 3 connections to CF. Those three users are all accessing the same page with the same cfhttp in it. Each of those templates calls cfhttp to another template. The web server gets the requests and puts them in the queue waiting to access to CF. 1) CF is sitting there waiting for a response from the CFHTTP, so the user is also waiting for a web page to come back. 2) The CFHTTP request is sitting in a queue waiting to get access to CF, but can't because all the connections are used up 3) Goto point 1, until CF gives up waiting for a response from CFHTTP and returns an error to the user. 4) The CFHTTP request gets onto the server, but the response has no where to go! One dead application! Stephen __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
Alright already, I get the point. Use CFINCLUDE, It's much faster when doing something like this. All your base __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:19 AM To: CF-Talk Subject: Re: cfinclude, who to pass for variables to? Ok were talking milliseconds here, but yeah variables are passed to any page that you cfinclude, so it would be easier to do it that way. That may be true with one or two users on the server, but you try that on a live server with hundreds of concurrent users where the web server is queuing request, CF is queuing requests and your database is queuing too! You'll wind up with a deadlock and timeout on the CFHTTP! Here's how it goes... say you've got 3 users and 3 connections to CF. Those three users are all accessing the same page with the same cfhttp in it. Each of those templates calls cfhttp to another template. The web server gets the requests and puts them in the queue waiting to access to CF. 1) CF is sitting there waiting for a response from the CFHTTP, so the user is also waiting for a web page to come back. 2) The CFHTTP request is sitting in a queue waiting to get access to CF, but can't because all the connections are used up 3) Goto point 1, until CF gives up waiting for a response from CFHTTP and returns an error to the user. 4) The CFHTTP request gets onto the server, but the response has no where to go! One dead application! Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MySQL Cold Fusion Question?
You can use Access as a front end to almost anything via ODBC. On the machine with Access, create an ODBC connection to your foreign database - this assumes that the database is accessible via the network. Then you can either link to or import the foreign database, depending on your needs. If the database is not accessible via the network, you are down to writing a query to generate a delimited file and sneakering it to the Access machine. At 03:13 PM 2/13/2002 -0700, you wrote: - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 2:47 PM Subject: RE: MySQL Cold Fusion Question? Would you want to convert so you can easily view table data? If so, it may be better to have Access link to mySQL tables via ODBC. Access works well to view mySQL table data. Not sure about actual conversions, though. Can you explain how to link from Access via ODBC to another database. For example, I'm working at Machine A, and the MySQL database resides on Machine B (with CF server, IIS, etc.). I've got an ODBC datasource set up on Machine B for use by CF. Where do I create the Access database? If I try creating the Access DB from machine A, and try to link via ODBC, I can only see ODBC datasources located on the local machine. On the server itself, I don't have Access installed. Thanks, Jim __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfqueryparam - order of where/and
I read an article by Ben Forta in CFDJ about using cfqueryparam I wanted to test it out, but had a question, well actually two questions. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the and clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
I personally have found that when I have a huge query it makes it faster if I do the joins that get rid of the most data first. So say I have a query like this. Select * From Accounts, Sales Where accounts.address = sales.address And salesdate = #now()# And item = 13882 I would redo the query so that it would get rid of the data it doesn't need first then do the join at the end. Otherwise it joins those tables with all the data, then gets rid of the rows you don't need. Select * From Accounts, Sales Where salesdate = #now()# And item = 13882 And accounts.address = sales.address Results may vary. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:03 PM To: CF-Talk Subject: cfqueryparam - order of where/and I read an article by Ben Forta in CFDJ about using cfqueryparam I wanted to test it out, but had a question, well actually two questions. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the and clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
Yes the order of the clauses in the where statement matter. First, you want to use indexed fields. That way, you make full use of database optimizations. The execution plan *should* figure it out, but it's still good practice to use indexed fields first regardless. Dunno about the second question. Honestly though, you should use stored procedures where possible. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:03 AM To: CF-Talk Subject: cfqueryparam - order of where/and I read an article by Ben Forta in CFDJ about using cfqueryparam I wanted to test it out, but had a question, well actually two questions. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the and clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
Actually, The where clause processes bottom up. So, if possible, for best results place your most restricting clauses LAST and filter out the greatest amount of data. Then the next where clause up from the bottom has the least amount of records possible to compare against and will perform faster. HTH, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:06 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and I personally have found that when I have a huge query it makes it faster if I do the joins that get rid of the most data first. So say I have a query like this. Select * From Accounts, Sales Where accounts.address = sales.address And salesdate = #now()# And item = 13882 I would redo the query so that it would get rid of the data it doesn't need first then do the join at the end. Otherwise it joins those tables with all the data, then gets rid of the rows you don't need. Select * From Accounts, Sales Where salesdate = #now()# And item = 13882 And accounts.address = sales.address Results may vary. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:03 PM To: CF-Talk Subject: cfqueryparam - order of where/and I read an article by Ben Forta in CFDJ about using cfqueryparam I wanted to test it out, but had a question, well actually two questions. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the and clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARCHAR (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Accessing Accounts on NT via CF
Is there a way to add/delete/modify user NT accounts via a web interface? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
Actually, The where clause processes bottom up. So, if possible, for best results place your most restricting clauses LAST and filter out the greatest amount of data. Then the next where clause up from the bottom has the least amount of records possible to compare against and will perform faster. I would be careful about making a blanket statement like that. Oracle doesn't care how you pass it in because its Explain Plan is going to map out the best way to execute the query, regardless of the order in which you pass it in. Oracle has specifically focused on this (among other things) in its last few releases to optimize performance. Hence its claims that it's the fastest DB in the world (and unbreakable). I can't speak knowledgeably about SQL Server, but I just wanted to point out that making a blanket statement can potentially be misleading to people with less experience. Regards, Dave. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Accessing Accounts on NT via CF
Have a look at http://www.intrafoundation.com/ They've got a kit that will access all this information HTH -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: 14 February 2002 17:44 To: CF-Talk Subject: Re: Accessing Accounts on NT via CF Is there a way to add/delete/modify user NT accounts via a web interface? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QuerySetCell
Im trying to change a query value using QuerySetCell, it appears to be working (no error) but when I CFOUTPUT I dont see the new result...Initially I was using it in the same CFOUTPUT block that my test used but then thought it needs to be in a different CFOUTPUT block prior, tried that didnt work. Turned CACHEDWITHIN off still nothing. This is basically what I am doing. cfoutput query=myquery cfif trim(myCol) IS QuerySetCell(myquery, myCol, 0 currentrow) /cfif /cfoutput The QuerySetCell get processed but the 0 does not get set. Any ideas on how to properly use this? Thanks,Adrian __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
I'm fairly certain that SQL Server processes top down. Oracle used t o process them bottom up. -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: February 14, 2002 10:15 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and Actually, The where clause processes bottom up. So, if possible, for best results place your most restricting clauses LAST and filter out the greatest amount of data. Then the next where clause up from the bottom has the least amount of records possible to compare against and will perform faster. HTH, t * * Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com * * -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:06 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and I personally have found that when I have a huge query it makes it fas ter if I do the joins that get rid of the most data first. So say I have a query like this. Select * From Accounts, Sales Where accounts.address = sales.address And salesdate = #now()# And item = 13882 I would redo the query so that it would get rid of the data it doesn' t need first then do the join at the end. Otherwise it joins those tabl es with all the data, then gets rid of the rows you don't need. Select * From Accounts, Sales Where salesdate = #now()# And item = 13882 And accounts.address = sales.address Results may vary. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:03 PM To: CF-Talk Subject: cfqueryparam - order of where/and I read an article by Ben Forta in CFDJ about using cfqueryparam I wanted to test it out, but had a question, well actually two question s. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the a nd clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = cfqueryparam value=## cfsqltype=CF_SQL_VA RCHAR and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARC HAR (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
Okay, Then... As a best practice(?) start by assuming that you're DB will process your where clauses from the bottom up and help the system out. If you're lucky enough to have the best stuff out there, like Oracle, which I assume atleast 85%, probably more, don't have then just code completely free of any form knowing that your DB will make up for it. If Oracle is optimizing now, then I bet MS SQL server is right on there heels and either doing it too, or have it planned in some service pack. That still leaves Access, PostgreSQL and mySQL. I bet they'd like the help of a well planned SQL statement. Cheers, t ** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ** -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:40 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and Actually, The where clause processes bottom up. So, if possible, for best results place your most restricting clauses LAST and filter out the greatest amount of data. Then the next where clause up from the bottom has the least amount of records possible to compare against and will perform faster. I would be careful about making a blanket statement like that. Oracle doesn't care how you pass it in because its Explain Plan is going to map out the best way to execute the query, regardless of the order in which you pass it in. Oracle has specifically focused on this (among other things) in its last few releases to optimize performance. Hence its claims that it's the fastest DB in the world (and unbreakable). I can't speak knowledgeably about SQL Server, but I just wanted to point out that making a blanket statement can potentially be misleading to people with less experience. Regards, Dave. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfqueryparam - order of where/and
If you use query analyzer to view the execution plan and run a number of fairly complex queries, it's pretty obvious (to me) that SQL server uses some form of logic in constructing the execution plan that does not appear to depend on the order of the where, order by or group by (though the group by always runs last because it needs the record set before grouping. Mark -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:42 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and I'm fairly certain that SQL Server processes top down. Oracle used t o process them bottom up. -Original Message- From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]] Sent: February 14, 2002 10:15 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and Actually, The where clause processes bottom up. So, if possible, for best results place your most restricting clauses LAST and filter out the greatest amount of data. Then the next where clause up from the bottom has the least amount of records possible to compare against and will perform faster. HTH, t * * Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com * * -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:06 AM To: CF-Talk Subject: RE: cfqueryparam - order of where/and I personally have found that when I have a huge query it makes it fas ter if I do the joins that get rid of the most data first. So say I have a query like this. Select * From Accounts, Sales Where accounts.address = sales.address And salesdate = #now()# And item = 13882 I would redo the query so that it would get rid of the data it doesn' t need first then do the join at the end. Otherwise it joins those tabl es with all the data, then gets rid of the rows you don't need. Select * From Accounts, Sales Where salesdate = #now()# And item = 13882 And accounts.address = sales.address Results may vary. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:03 PM To: CF-Talk Subject: cfqueryparam - order of where/and I read an article by Ben Forta in CFDJ about using cfqueryparam I wanted to test it out, but had a question, well actually two question s. First has nothing to do with CFqueryparam 1) Does where/and clauses ORDER matter? ie select * from table where id = 'xxx' and data1 = '' Verses select * from table where data1 = '' and id = 'xxx' Does one find the information quicker? (switching the where and the a nd clauses?). Which takes me to my second question. Does the following matter? select * from table where data1 = cfqueryparam value=## cfsqltype=CF_SQL_VA RCHAR and id = 'xxx' Verses select * from table where id = 'xxx' and data1 = cfqueryparam value=## cfsqltype=CF_SQL_VARC HAR (Note the where and the and clause switches placement). Does placement matter? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder _ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: QuerySetCell
Im trying to change a query value using QuerySetCell, it appears to be working (no error) but when I CFOUTPUT I dont see the new result...Initially I was using it in the same CFOUTPUT block that my test used but then thought it needs to be in a different CFOUTPUT block prior, tried that didnt work. Turned CACHEDWITHIN off still nothing. This is basically what I am doing. cfoutput query=myquery cfif trim(myCol) IS QuerySetCell(myquery, myCol, 0 currentrow) /cfif /cfoutput The QuerySetCell get processed but the 0 does not get set. Any ideas on how to properly use this? Have you tried using a CACHEDWITHIN attribute of #CreateTimeSpan(0,0,0,1)#? It sounds like you had cached the query at one point. However, from my understanding (and I could be wrong), simply removed the CACHEDWITHIN attribute doesn't un-cache the query. You have to set a timeout to one second (see above code) to force the query to refresh itself. Again, I'm not 100% sure, but it's worth a shot. Hope this helps, Dave. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
QuerySetCell: resolved
Initially I used cfset temp = QuerySetCell(myquery, myCol, 0 currentrow) in the same CFOUTPUT block, which didnt work. I then changed to QuerySetCell(myquery, myCol, 0 currentrow) whioch didnt work. I then slit to 2 blocks, didnt work. I finally changed the initial block to use cfset temp = QuerySetCell(myquery, myCol, 0 currentrow). Worked!. -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Im trying to change a query value using QuerySetCell, it appears to be working (no error) but when I CFOUTPUT I dont see the new result...Initially I was using it in the same CFOUTPUT block that my test used but then thought it needs to be in a different CFOUTPUT block prior, tried that didnt work. Turned CACHEDWITHIN off still nothing. This is basically what I am doing. cfoutput query=myquery cfif trim(myCol) IS QuerySetCell(myquery, myCol, 0 currentrow) /cfif /cfoutput The QuerySetCell get processed but the 0 does not get set. Any ideas on how to properly use this? Thanks,Adrian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
free CF hosting - is available!
There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QuerySetCell
Im trying to change a query value using QuerySetCell, it appears to be working (no error) but when I CFOUTPUT I dont see the new result...Initially I was using it in the same CFOUTPUT block that my test used but then thought it needs to be in a different CFOUTPUT block prior, tried that didnt work. Turned CACHEDWITHIN off still nothing. This is basically what I am doing. cfoutput query=myquery cfif trim(myCol) IS QuerySetCell(myquery, myCol, 0 currentrow) /cfif /cfoutput The QuerySetCell get processed but the 0 does not get set. Any ideas on how to properly use this? OK, PLEASE tell me that you haven't got currentrow in there without a comma, if so, then that's your problem Also, why has it got and around it? Since it's a set command, it should be cfset QuerySetCell(myquery, myCol, 0, currentrow) Anything with just and around it, but not cf will be sent to the browser... Try that, see how it goes Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: 14 February 2002 17:54 To: CF-Talk Subject: QuerySetCell Thanks,Adrian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: free CF hosting - is available!
OR.. for $9.95 CDN (about $5 US) you can host with WeDoHosting.com and not have a banner plastered onto your pages ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bimal Shah [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 10:05 AM Subject: free CF hosting - is available! There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: free CF hosting - is available!
I tried cfm-resources before, they have really slow servers, connection speed-wise, and there customer service is Very bad. Take a look at the forums on their page and read what people have to say about how crappy the service is ;) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:06 PM To: CF-Talk Subject: free CF hosting - is available! There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: QuerySetCell
My bad, I do have the comma, missed it in my mail example. Initially I tried it with the CFSET, but had it all in a single CFOUTPUT block, Im assuming that was the problem. Using QuerySetCell(myquery, myCol, 0, currentrow) did not error and did NOT get sent to the browser, it appeared to get processed by CF...maybe ive had too much coffee already... Adrian OK, PLEASE tell me that you haven't got currentrow in there without a comma, if so, then that's your problem Also, why has it got and around it? Since it's a set command, it should be cfset QuerySetCell(myquery, myCol, 0, currentrow) Anything with just and around it, but not cf will be sent to the browser... Try that, see how it goes Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 F: +44 (0)20 8686 7911 An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: 14 February 2002 17:54 To: CF-Talk Subject: QuerySetCell Thanks,Adrian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: free CF hosting - is available!
Many people have had experiences with CFM-Resources... good and bad. Personally I don't think CF-Talk is the right place for discussing the pro's and con's of the service. Hatton -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:20 PM To: CF-Talk Subject: RE: free CF hosting - is available! I tried cfm-resources before, they have really slow servers, connection speed-wise, and there customer service is Very bad. Take a look at the forums on their page and read what people have to say about how crappy the service is ;) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:06 PM To: CF-Talk Subject: free CF hosting - is available! There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: free CF hosting - is available!
By they way, I know your going to say what do you expect from a free service. Well I had the developers package, which was around $24 a month, and my pages would take at least 30 to 45 seconds to load. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:20 PM To: CF-Talk Subject: RE: free CF hosting - is available! I tried cfm-resources before, they have really slow servers, connection speed-wise, and there customer service is Very bad. Take a look at the forums on their page and read what people have to say about how crappy the service is ;) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:06 PM To: CF-Talk Subject: free CF hosting - is available! There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: free CF hosting - is available!
Oh come on now, if people can discuss broadband issues, bitch about open source, and discuss the post on fuckedcompany.com, I think it's certainly OK to talk about a ColdFusion related web hosting service. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:27 PM To: CF-Talk Subject: RE: free CF hosting - is available! Many people have had experiences with CFM-Resources... good and bad. Personally I don't think CF-Talk is the right place for discussing the pro's and con's of the service. Hatton -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:20 PM To: CF-Talk Subject: RE: free CF hosting - is available! I tried cfm-resources before, they have really slow servers, connection speed-wise, and there customer service is Very bad. Take a look at the forums on their page and read what people have to say about how crappy the service is ;) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:06 PM To: CF-Talk Subject: free CF hosting - is available! There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: free CF hosting - is available!
Amen, brother. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:31 PM To: CF-Talk Subject: RE: free CF hosting - is available! Oh come on now, if people can discuss broadband issues, bitch about open source, and discuss the post on fuckedcompany.com, I think it's certainly OK to talk about a ColdFusion related web hosting service. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:27 PM To: CF-Talk Subject: RE: free CF hosting - is available! Many people have had experiences with CFM-Resources... good and bad. Personally I don't think CF-Talk is the right place for discussing the pro's and con's of the service. Hatton -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:20 PM To: CF-Talk Subject: RE: free CF hosting - is available! I tried cfm-resources before, they have really slow servers, connection speed-wise, and there customer service is Very bad. Take a look at the forums on their page and read what people have to say about how crappy the service is ;) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Bimal Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:06 PM To: CF-Talk Subject: free CF hosting - is available! There is a free CF hosting company out there! They place banners at the top - so if you don't mind that you get: - 30mb space - ftp - 1 ODBC connection (Access 2000) - 1 free email addresss - 72 hour technical support http://www.cfm-resources.com/apply.cfm?signup=free Bimal Shah Senior Web developer __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
1 browser window kill client var
We just made an interesting discovery. We process multiple jobs, identified by different job numbers. We were looking into using client variables for job numbers, but if (when?) users open more than one browser window this can cause problems. If the user uses a second browser instance to go to another job, then the client vars will be overwritten by the new job number. This is because all the browser instances on a computer look the same to the CFserver - they all have the same CFID/CFTOKEN from that one set of cookies. Anybody find a way to: 1) disable opening new browser windows 2) prevent client var updating if in a different window or something like that? thanks, Chris Norloff __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 1 browser window kill client var
Why don't you just use a session variable to track if a job was created or not? User opens a browser, opens a job, gets a job number, gets a session number. User opens another browser, CF sees the session number, and either shows the same job or says you already have a job open __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:39 PM To: CF-Talk Subject: 1 browser window kill client var We just made an interesting discovery. We process multiple jobs, identified by different job numbers. We were looking into using client variables for job numbers, but if (when?) users open more than one browser window this can cause problems. If the user uses a second browser instance to go to another job, then the client vars will be overwritten by the new job number. This is because all the browser instances on a computer look the same to the CFserver - they all have the same CFID/CFTOKEN from that one set of cookies. Anybody find a way to: 1) disable opening new browser windows 2) prevent client var updating if in a different window or something like that? thanks, Chris Norloff __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 1 browser window kill client var
Use two different browser types: IE Netscape, IE Opera, Netscape Opera Kevin [EMAIL PROTECTED] 02/14/02 10:38AM We just made an interesting discovery. We process multiple jobs, identified by different job numbers. We were looking into using client variables for job numbers, but if (when?) users open more than one browser window this can cause problems. If the user uses a second browser instance to go to another job, then the client vars will be overwritten by the new job number. This is because all the browser instances on a computer look the same to the CFserver - they all have the same CFID/CFTOKEN from that one set of cookies. Anybody find a way to: 1) disable opening new browser windows 2) prevent client var updating if in a different window or something like that? thanks, Chris Norloff __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfinclude, who to pass for variables to?
hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. thanks a bunch __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: free CF hosting - is available!
I'll grant that point but will also point out that there were several calls for moving those threads to Community as well. Hatton Oh come on now, if people can discuss broadband issues, bitch about open source, and discuss the post on fuckedcompany.com, I think it's certainly OK to talk about a ColdFusion related web hosting service. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
A-Z 0-9 form validation
Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
Didn't we go over this earlier? When you cfinclude something, it has access to all variables on that page, including FORM and URL variables. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:53 PM To: CF-Talk Subject: cfinclude, who to pass for variables to? hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. thanks a bunch __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
If your using CF Server 5.0 you can use RegEx in a cfinput tag. http://www.sys-con.com/coldfusion/article.cfm?id=376 __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:04 PM To: CF-Talk Subject: A-Z 0-9 form validation Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: A-Z 0-9 form validation
can you elaborate on A-Z and 0-9? Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Adrian Cesana [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 11:04 AM Subject: A-Z 0-9 form validation Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
PS... It's on page 3 of that article :) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:11 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation If your using CF Server 5.0 you can use RegEx in a cfinput tag. http://www.sys-con.com/coldfusion/article.cfm?id=376 __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:04 PM To: CF-Talk Subject: A-Z 0-9 form validation Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
Only want to allow A-Z or 0-9 character/digits in the form input. Anything else I want to return a message back to the user to fix the input. I have tons of other server side validation happening so I want to keep it on the server side, rather than using JS. Still running 4.01 -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] can you elaborate on A-Z and 0-9? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: A-Z 0-9 form validation
And speaking of page numberswhy are all the page numbers off on the ColdFusion Developer's Journal Articles. There is always 1 less page than it says (i.e. 6 out of 7 is the last page of this article). Somebody fix it ;-) OK...I'm done Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 11:14 AM Subject: RE: A-Z 0-9 form validation PS... It's on page 3 of that article :) __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:11 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation If your using CF Server 5.0 you can use RegEx in a cfinput tag. http://www.sys-con.com/coldfusion/article.cfm?id=376 __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:04 PM To: CF-Talk Subject: A-Z 0-9 form validation Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfinclude, who to pass for variables to?
As a reminder, URL and FORM variables are available to custom tags too. Mike - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 1:59 PM Subject: RE: cfinclude, who to pass for variables to? Didn't we go over this earlier? When you cfinclude something, it has access to all variables on that page, including FORM and URL variables. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 1:53 PM To: CF-Talk Subject: cfinclude, who to pass for variables to? hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page in my form tag. but this doesn't seem to work if that page is used in an include. thanks a bunch __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . .the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
Ok, in that case in your action page you could do something like: cfif refind(A-Za-z0-9,FORM.field) EQ 0 !--- didn't match, send them back --- /cfif __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:23 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation Only want to allow A-Z or 0-9 character/digits in the form input. Anything else I want to return a message back to the user to fix the input. I have tons of other server side validation happening so I want to keep it on the server side, rather than using JS. Still running 4.01 -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] can you elaborate on A-Z and 0-9? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 1 browser window kill client var
This is why it's a very bad idea to track application state using session or client variables. A user opening two browser windows and performing different tasks in each will usually screw up your logic. You need to know what kind of information you can and cannot safely keep in the client and session scopes. You'll probably end up needing to pass your job number from one page to the next using form or url variables. Jim - Original Message - From: Chris Norloff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 11:38 AM Subject: 1 browser window kill client var We just made an interesting discovery. We process multiple jobs, identified by different job numbers. We were looking into using client variables for job numbers, but if (when?) users open more than one browser window this can cause problems. If the user uses a second browser instance to go to another job, then the client vars will be overwritten by the new job number. This is because all the browser instances on a computer look the same to the CFserver - they all have the same CFID/CFTOKEN from that one set of cookies. Anybody find a way to: 1) disable opening new browser windows 2) prevent client var updating if in a different window or something like that? thanks, Chris Norloff __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
You could use a cftransaction and group your cfquery and cfmail together. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:31 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . .the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
Since its an INSERT is seems like this should not happen, I could see this happening with an UPDATE. In any case without reviewing your code you may want to CFLOCK the INSERT EMAIL process. If its a heavy usage site I would look further into why this is happening and code around it rather than using a CFLOCK. Adrian -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:31 AM To: CF-Talk Subject: RE: A-Z 0-9 form validation Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . .the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: A-Z 0-9 form validation
Probably something more along the lines of: cfif Refind(^[A-Za-z0-9]+$, FORM.field) EQ 0 !--- didn't match, send them back --- /cfif Jim - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 12:30 PM Subject: RE: A-Z 0-9 form validation Ok, in that case in your action page you could do something like: cfif refind(A-Za-z0-9,FORM.field) EQ 0 !--- didn't match, send them back --- /cfif __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:23 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation Only want to allow A-Z or 0-9 character/digits in the form input. Anything else I want to return a message back to the user to fix the input. I have tons of other server side validation happening so I want to keep it on the server side, rather than using JS. Still running 4.01 -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] can you elaborate on A-Z and 0-9? __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 1 browser window kill client var
Two possible suggestions: Do not allow multiple jobs to be processed simultaneously. That is, do not allow that particular session to process more than one job at a time. The other would be to make arrays of all your job related variables and track them separately. - Original Message - From: Chris Norloff [EMAIL PROTECTED] We just made an interesting discovery. We process multiple jobs, identified by different job numbers. We were looking into using client variables for job numbers, but if (when?) users open more than one browser window this can cause problems. If the user uses a second browser instance to go to another job, then the client vars will be overwritten by the new job number. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, who to pass for variables to?
ok. but if the page changes then the form action would have to change? so i cant just say action = 'verityResults.cfm' if the verityResults.cfm is also in each seperate page? form name='formpage1' action = 'thispage1.cfm' method = 'post' form name='formpage2' action = 'thispage2.cfm' method = 'post' or could i just have it form name='thispageform' action = 'thispage' method = 'post' where thispage always posts to the current page the form is included in? -paul -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:31 AM To: CF-Talk Subject: RE: cfinclude, who to pass for variables to? Alright already, I get the point. Use CFINCLUDE, It's much faster when doing something like this. All your base __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:19 AM To: CF-Talk Subject: Re: cfinclude, who to pass for variables to? Ok were talking milliseconds here, but yeah variables are passed to any page that you cfinclude, so it would be easier to do it that way. That may be true with one or two users on the server, but you try that on a live server with hundreds of concurrent users where the web server is queuing request, CF is queuing requests and your database is queuing too! You'll wind up with a deadlock and timeout on the CFHTTP! Here's how it goes... say you've got 3 users and 3 connections to CF. Those three users are all accessing the same page with the same cfhttp in it. Each of those templates calls cfhttp to another template. The web server gets the requests and puts them in the queue waiting to access to CF. 1) CF is sitting there waiting for a response from the CFHTTP, so the user is also waiting for a web page to come back. 2) The CFHTTP request is sitting in a queue waiting to get access to CF, but can't because all the connections are used up 3) Goto point 1, until CF gives up waiting for a response from CFHTTP and returns an error to the user. 4) The CFHTTP request gets onto the server, but the response has no where to go! One dead application! Stephen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
At 02:32 PM 2/14/02 -0500, you wrote: You could use a cftransaction and group your cfquery and cfmail together. __ We are currently using a CFTRANSACTION wrapped around a CFINSERT and query getting back the New ID of the new record created . . .doesn't seem to hold up . . . jim steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:31 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . .the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
Use cflock type=EXCLUSIVE This will single thread the execution. Dan Rosenbaum Wachovia Securities Corporate Investment Banking [EMAIL PROTECTED] -Original Message- From: Steve Oliver [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:33 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation You could use a cftransaction and group your cfquery and cfmail together. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:31 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
Excellent!, thanks all. I need to read up on ReFind. Adrian -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Probably something more along the lines of: cfif Refind(^[A-Za-z0-9]+$, FORM.field) EQ 0 !--- didn't match, send them back --- /cfif Jim - Original Message - From: Steve Oliver [EMAIL PROTECTED] Ok, in that case in your action page you could do something like: cfif refind(A-Za-z0-9,FORM.field) EQ 0 !--- didn't match, send them back --- /cfif __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
I think you have missed the problem... If user2 gets user1's info, then where did user2's email address come from? I assume it came from the form, which means you haven't lost the form information. These problems can be tricky, so take your time and go over the thing with fine-tooth comb. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:04 AM To: CF-Talk Subject: A-Z 0-9 form validation Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: A-Z 0-9 form validation
What kind of variables are you using? I'll assuming you're not using the application scope for the email address. ;-) Are you locking your session reads and writes? Jamie On Thu, 14 Feb 2002 14:31:24 -0500, in cf-talk you wrote: Hi list . . . just a little help please . . . I have a form that collects data, inserts a new record and send out a confirmation email to the submitter . . and CC's me with form info also . It seems that when two or more people submit the form at the same time, their session or data overlap some way . . for the sake of argument, the first form data is stored and the process completes correctly . . .the second form data is lost and the second submittor receives the first submittor's info in the confirmation emails . . . any way to insure the entire process is handled exclusively and prevent any type of apparent overlapping??? thanks a million in advance . . . __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A-Z 0-9 form validation
also, how are you generating the primary key for the insert statement? If you are using SELECT MAX() then you can have issues without using CFTRANSACTION. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:25 PM To: CF-Talk Subject: RE: A-Z 0-9 form validation I think you have missed the problem... If user2 gets user1's info, then where did user2's email address come from? I assume it came from the form, which means you haven't lost the form information. These problems can be tricky, so take your time and go over the thing with fine-tooth comb. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:04 AM To: CF-Talk Subject: A-Z 0-9 form validation Anyone have a good snippet of code to do A-Z 0-9 form validation server side? Im trying to roll my own but its starting to get ugly Thanks,Adrian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
executing a dts package
Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing a dts package
maybe not the fix you were looking for...but you could execute it from CF. www.cfcomet.com has an article by Simon Horwith that steps through this method... http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297- 4E80-92CC7A8907B0A5B2 -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 3:15 PM To: CF-Talk Subject: executing a dts package Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing a dts package
You've set up an SQL Job for running the DTS package I am assuming? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 7:15 AM To: CF-Talk Subject: executing a dts package Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing a dts package
yes -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 4:11 PM To: CF-Talk Subject: RE: executing a dts package You've set up an SQL Job for running the DTS package I am assuming? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 7:15 AM To: CF-Talk Subject: executing a dts package Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing a dts package
It may be a perms problem. I think when you manualy execute it , it runs under the logged on username and when it is scheduled it runs under the mssql service account. I've had that happen with other stuff, just a thought. Good luck, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Steven Dworman [mailto:[EMAIL PROTECTED]] |Sent: Thursday, February 14, 2002 4:52 PM |To: CF-Talk |Subject: RE: executing a dts package | | |yes | |-Original Message- |From: Darryl Lyons [mailto:[EMAIL PROTECTED]] |Sent: Thursday, February 14, 2002 4:11 PM |To: CF-Talk |Subject: RE: executing a dts package | | |You've set up an SQL Job for running the DTS package I am assuming? | |-Original Message- |From: Steven Dworman [mailto:[EMAIL PROTECTED]] |Sent: Friday, 15 February 2002 7:15 AM |To: CF-Talk |Subject: executing a dts package | | |Here's the deal. We have a DTS package that needs to be |executed on a monthly basis. The problem is that SQL server 7 |can't execute it. It fails every time. If we run the package |manually it works just fine. | |Any ideas? | |Thanks, | |Steven D Dworman |- |Web Consultant |Systems Administrator | |ComSpec International - http://www.comspec-intnl.com |phone: 248.647.8841 |cell: 734.972.9676 |- |EMPOWER-XL ***Software for Higher Education*** |http://www.empower-xl.com | | | | __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Login expired vs. Not logged in
In an app I'm developing, I'm using a simple system of using session variables for access control: cfif not IsDefined(session.userid) Hey, you gotta login. cfelse .. Is it possible to detect if a user session has _expired_? cfif *expired* Your login session has expired. You must login again. cfelseif not IsDefined(session.userid) Hey, you gotta login. cfelse ... Roll my own, using cookies? Thanks, Jim __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Login expired vs. Not logged in
A cookie would probably be easiest, just set the cookie each time the page is loaded. Cookie.lastactivity. Then do something like: cfif isDefined(session.userid) AND datediff(n, cookie.lastactivity, now()) GT 5 Your session expired. cfelseif NOT defined(session.userid) Hey you gotta login. cfelse .. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 5:04 PM To: CF-Talk Subject: Login expired vs. Not logged in In an app I'm developing, I'm using a simple system of using session variables for access control: cfif not IsDefined(session.userid) Hey, you gotta login. cfelse . Is it possible to detect if a user session has _expired_? cfif *expired* Your login session has expired. You must login again. cfelseif not IsDefined(session.userid) Hey, you gotta login. cfelse ... Roll my own, using cookies? Thanks, Jim __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Login expired vs. Not logged in
don't forget to lock your session variables. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 5:04 PM Subject: Login expired vs. Not logged in In an app I'm developing, I'm using a simple system of using session variables for access control: cfif not IsDefined(session.userid) Hey, you gotta login. cfelse .. Is it possible to detect if a user session has _expired_? cfif *expired* Your login session has expired. You must login again. cfelseif not IsDefined(session.userid) Hey, you gotta login. cfelse ... Roll my own, using cookies? Thanks, Jim __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Recursive help!!!!
My mind just isn't working, I need help with some logic here if any of you would I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lnamesupvnum 44 ray Bujarski 24 I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logicI am at nerves end. Thank you! Ray __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
More on recursion
The end result I am trying for is a structure (associative array) suvPhNum = empList where empList = all direct reports and all of each direct reports reports etc... At 03:31 PM 2/14/2002 -0800, you wrote: My mind just isn't working, I need help with some logic here if any of you would I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lnamesupvnum 44 ray Bujarski 24 I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logicI am at nerves end. Thank you! Ray __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursive help!!!!
Hi Ray, I've done something like this. You can see the result at http://www.theanticool.com/pages/index.cfm. Basically you have to call a custom tag that checks for families for each child. If the child(ren) exists, then you write his info and call the tag again. If theres no children the node closes. If theres multiple children, then you write the next child after the first custom tag call and call it again. If you want to get creative, you can keep track of the depth of the tree like I did. Its pretty heavy on the server(Theres like 30 tags and 30 db calls on this page) so I'd recommend cacheing the page or perhaps writing it dynamically to a static html page. Writing it is quite the adventure- watch out for endless looping- but each page turned out not too big(no bigger than a screen) Also you have to find a way to prevent a malicious user from entering info that calls the parent thereby creating an endless loop. DRE -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 4:32 PM To: CF-Talk Subject: Recursive help My mind just isn't working, I need help with some logic here if any of you would I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lnamesupvnum 44 ray Bujarski 24 I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logicI am at nerves end. Thank you! Ray __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursive help!!!!
Try secretagents.com and look for the nested hierarchy tute for SQL. It's what I use and its incredibly powerful (e.g. one-query hierarcy display, tree walks, etc) Darryl -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 9:32 AM To: CF-Talk Subject: Recursive help My mind just isn't working, I need help with some logic here if any of you would I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lnamesupvnum 44 ray Bujarski 24 I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logicI am at nerves end. Thank you! Ray __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursive help!!!!
Thank you At 09:43 AM 2/15/2002 +1000, you wrote: Try secretagents.com and look for the nested hierarchy tute for SQL. It's what I use and its incredibly powerful (e.g. one-query hierarcy display, tree walks, etc) Darryl -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 February 2002 9:32 AM To: CF-Talk Subject: Recursive help My mind just isn't working, I need help with some logic here if any of you would I have a table that houses all employees and each is unique by employee number, there is a hierarchy of management by storing each employee's supervisors employee number in the record. For example my bosses emp num is 24, I am emp num 44. My record looks like this. empnum fname lnamesupvnum 44 ray Bujarski 24 I need to create a structure that has a hierarchy list of employees, I have people reporting to me so, my supervisor should have all my employees listed in his list of employees along with myself. Can anyone help me with this logicI am at nerves end. Thank you! Ray __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
file input value
Hi, when submitting a multi-type form with an input of type file, is there a way to reference the text value of that input before you do any file actions on it? Outputting the variable form.filefieldname will give the local tmp file where the file is being stored. I could probably do it with javascript on the form page, and put the value in a hidden field, but is there a way to do it on the server side? Adam. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange Query of Query Behavior
Hello, I am doing a query that extracts all sales info for an employee in a particular time frame. Then I am doing 2 querys of that query as seen: cfquery name=SalesCalc1 dbtype=query SELECT SalesAmount AS Sales1Sum FROM SalesQuery Where BonusDeal = 1/cfquery cfquery name=SalesCalc2 dbtype=query SELECT SalesAmount AS Sales2Sum FROM SalesQuery Where BonusDeal = 0/cfquery This is working correctly, showing 2 different (correct) values for the amounts. Sales1Sum: 10,000 Sales2Sum: 15,000 But, when I want to use the SUM function in the SQL it shows totals for both as the same total. cfquery name=SalesCalc1 dbtype=query SELECT SUM(SalesAmount) AS Sales1Sum FROM SalesQuery Where BonusDeal = 1/cfquery cfquery name=SalesCalc2 dbtype=query SELECT SUM(SalesAmount) AS Sales2Sum FROM SalesQuery Where BonusDeal = 0/cfquery Sales1Sum: 25,000 Sales2Sum: 25,000 So it appears that the Query of Query is not taking the WHERE clause into consideration.. Any Ideas on why? Is this a Bug? How should I proceed? Thanks Everyone, -Dan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: file input value
Yeah, after the file is uploaded. CFFILE.clientDirectory Directory location of the file uploaded from the client's system CFFILE.clientFile Name of the file uploaded from the client's system CFFILE.clientFileExt Extension of the uploaded file on the client's system without a period, for example, txt not .txt CFFILE.clientFileName Filename, without an extension, of the uploaded file on the client's system __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 7:05 PM To: CF-Talk Subject: file input value Hi, when submitting a multi-type form with an input of type file, is there a way to reference the text value of that input before you do any file actions on it? Outputting the variable form.filefieldname will give the local tmp file where the file is being stored. I could probably do it with javascript on the form page, and put the value in a hidden field, but is there a way to do it on the server side? Adam. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Just wanna bitch
I know sooner or later some one will complain about this thread but I just want to throw my two cents in... I'd give something away free too. Sure I might be able to sell it to a handful of people, but then what? A handful of people appreciate it and a handful of people may want to hire me to do other work. Giving it away free, let's lots and lots of people used it and puts my name in front of lots and lots of people.. Long run that will probably be much more to my liking than a handful of people.. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. Writer / Technical Writer www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: dennis baldwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 6:33 AM To: CF-Talk Subject: RE: Just wanna bitch Well versed! Now get to work! -Original Message- From: Kurt Ward [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 9:59 AM To: CF-Talk Subject: RE: Just wanna bitch Sell what to your clients?? My point is every Tom, Dick, and Harry can and/or has developed applications like message boards. Could they sell them for $50? Sure! But who's going to buy it unless it's under a well known company or some other nonesuch? It's reinventing the wheel. Providing projects as open source makes the wheel better by letting an unlimited number of developers to contribute to them. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:46 AM To: CF-Talk Subject: RE: Just wanna bitch Hey that's great - how do I sell my clients on these. oh wait... -Original Message- From: Kurt Ward [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 4:18 AM To: CF-Talk Subject: RE: Just wanna bitch Open Source The best thing to hit software development in the last decade! Open Source projects have produced some very good software. For example: Apache Web Server Tomcat Servlet/JSP app server Xerces XML parser Xindice Native XML Database Server And these are all from www.apache.org not to mention www.sourceforge.net, and many other hosts of Open Source projects. I realize you specifically are talking about end-user apps (ie. message boards), but I think it fits the same foot. Kurt Ward -- Insert Fancy Footer Here -- This space intentionally left blank ;-) -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 2:18 AM To: CF-Talk Subject: OT: Just wanna bitch I know this is not the place for this, but I just have to ask this question of the community. What is the benefit of developing a commercial grade application and then giving that application away for free? I see message boards out there where people have obviously spent hours and hours of development time and effort, just to turn around and give the thing away. Is this type of mentality not hurting the development community? I understand that a message board is not that huge of a deal, but some people are trying to make a living developing such items. Is it not more beneficial to design a product and sale it for the going rate of such an application? I am eager to hear what everyones thoughts are on this subject. I would have posted to the community list, but hardly anyone really reads it. Doug Brown __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Based CRMs
Anyone out there know of a CF based CRM tool for managing sales leads? TIA, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Strange Query of Query Behavior
that is strange. Have you tried the HAVING clause instead of WHERE? - Original Message - From: Daniel Quinones [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 6:24 PM Subject: Strange Query of Query Behavior Hello, I am doing a query that extracts all sales info for an employee in a particular time frame. Then I am doing 2 querys of that query as seen: cfquery name=SalesCalc1 dbtype=query SELECT SalesAmount AS Sales1Sum FROM SalesQuery Where BonusDeal = 1/cfquery cfquery name=SalesCalc2 dbtype=query SELECT SalesAmount AS Sales2Sum FROM SalesQuery Where BonusDeal = 0/cfquery This is working correctly, showing 2 different (correct) values for the amounts. Sales1Sum: 10,000 Sales2Sum: 15,000 But, when I want to use the SUM function in the SQL it shows totals for both as the same total. cfquery name=SalesCalc1 dbtype=query SELECT SUM(SalesAmount) AS Sales1Sum FROM SalesQuery Where BonusDeal = 1/cfquery cfquery name=SalesCalc2 dbtype=query SELECT SUM(SalesAmount) AS Sales2Sum FROM SalesQuery Where BonusDeal = 0/cfquery Sales1Sum: 25,000 Sales2Sum: 25,000 So it appears that the Query of Query is not taking the WHERE clause into consideration.. Any Ideas on why? Is this a Bug? How should I proceed? Thanks Everyone, -Dan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Based CRMs
The company I used to work for was developing one. Contact them at http://www.mcdelectric.com - Original Message - From: Duane Boudreau [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 14, 2002 9:04 PM Subject: CF Based CRMs Anyone out there know of a CF based CRM tool for managing sales leads? TIA, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange Query of Query Behavior
It would appear that you have found a bug. I've reproduced your error as well. When computing a sum on a column it is missing the where clause. I'd report it to macromedia and see what they have to say... Now, to solve your problem... What database are you using? Can you run this as a stored proceedure? Jeff Garza -Original Message- From: Daniel Quinones To: CF-Talk Sent: 2/14/02 5:24 PM Subject: Strange Query of Query Behavior Hello, I am doing a query that extracts all sales info for an employee in a particular time frame. Then I am doing 2 querys of that query as seen: cfquery name=SalesCalc1 dbtype=querySELECT SalesAmount AS Sales1Sum FROM SalesQuery Where BonusDeal= 1/cfquery cfquery name=SalesCalc2 dbtype=querySELECT SalesAmount AS Sales2Sum FROM SalesQuery Where BonusDeal= 0/cfquery This is working correctly, showing 2 different (correct) values for the amounts. Sales1Sum: 10,000 Sales2Sum: 15,000 But, when I want to use the SUM function in the SQL it shows totals for both as the same total. cfquery name=SalesCalc1 dbtype=query SELECT SUM(SalesAmount) AS Sales1Sum FROM SalesQuery Where BonusDeal = 1/cfquery cfquery name=SalesCalc2 dbtype=query SELECT SUM(SalesAmount) AS Sales2Sum FROM SalesQuery Where BonusDeal = 0/cfquery Sales1Sum: 25,000 Sales2Sum: 25,000 So it appears that the Query of Query is not taking the WHERE clause into consideration.. Any Ideas on why? Is this a Bug? How should I proceed? Thanks Everyone, -Dan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists