Referencing an array item
I have 3 arrays, which are assigned to the application scope: My custom tag receives a number (1,2 or 3), and with that I reference the correct array. I need to dynamically use this number to reference the correct array, e.g. #ArrayLen(application.SM & attributes.Num)# (The above code does not work.) Any help would be much appreciated!! Thanks in advance. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Referencing an array item
Once again, Evaluate to the rescue: #ArrayLen(Evaluate("application.SM & attributes.Num"))# OR #ArrayLen(Evaluate("application.SM#attributes.Num#"))# > I have 3 arrays, which are assigned to the application scope: > > > > > > My custom tag receives a number (1,2 or 3), and with that I reference the > correct array. I need to dynamically use this number to reference the > correct array, e.g. > > #ArrayLen(application.SM & attributes.Num)# > > (The above code does not work.) Any help would be much appreciated!! Thanks > in advance. > > Steve > > > Development Manager > Vardus Internet Solutions (SA) > > Tel: (+27) 21 670 9880 > Fax: (+27) 21 674 4549 > > Email: [EMAIL PROTECTED] > Website: www.vardus.com > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IP lookup
Hello, If I have a numeric IP address how can I look up who it is registered to? Just curious, because I'm getting some weird traffic that might be related to Poison Box. Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers & Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
Whenever possible, don't use Evaluate, it's not that fast. In this case, SM1, SM2, are keys in the application scope. It is faster, and easier to read, to just do: p.s. Don't forget the read lock! === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 8:50 AM > To: CF-Talk > Subject: Re: Referencing an array item > > > Once again, Evaluate to the rescue: > > #ArrayLen(Evaluate("application.SM & attributes.Num"))# > > OR > > #ArrayLen(Evaluate("application.SM#attributes.Num#"))# > > > I have 3 arrays, which are assigned to the application scope: > > > > > > > > > > > > My custom tag receives a number (1,2 or 3), and with that I > reference the > > correct array. I need to dynamically use this number to reference the > > correct array, e.g. > > > > #ArrayLen(application.SM & attributes.Num)# > > > > (The above code does not work.) Any help would be much > appreciated!! Thanks > > in advance. > > > > Steve > > > > > > Development Manager > > Vardus Internet Solutions (SA) > > > > Tel: (+27) 21 670 9880 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IP lookup
Check out http://www.toolsforselling.com/v1/1/iplookup.htm Its a nice little Freeware program that works just great. Dan Phillips www.cfxhosting.com -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 11:35 AM To: CF-Talk Subject: IP lookup Hello, If I have a numeric IP address how can I look up who it is registered to? Just curious, because I'm getting some weird traffic that might be related to Poison Box. Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers & Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
oops, forgot a closing ) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 11:40 AM > To: CF-Talk > Subject: RE: Referencing an array item > > > Whenever possible, don't use Evaluate, it's not that fast. In this case, > SM1, SM2, are keys in the application scope. It is faster, and easier to > read, to just do: > > > > p.s. Don't forget the read lock! > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email : [EMAIL PROTECTED] > ICQ UIN : 3679482 > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > > Sent: Monday, May 28, 2001 8:50 AM > > To: CF-Talk > > Subject: Re: Referencing an array item > > > > > > Once again, Evaluate to the rescue: > > > > #ArrayLen(Evaluate("application.SM & attributes.Num"))# > > > > OR > > > > #ArrayLen(Evaluate("application.SM#attributes.Num#"))# > > > > > I have 3 arrays, which are assigned to the application scope: > > > > > > > > > > > > > > > > > > My custom tag receives a number (1,2 or 3), and with that I > > reference the > > > correct array. I need to dynamically use this number to reference the > > > correct array, e.g. > > > > > > #ArrayLen(application.SM & attributes.Num)# > > > > > > (The above code does not work.) Any help would be much > > appreciated!! Thanks > > > in advance. > > > > > > Steve > > > > > > > > > Development Manager > > > Vardus Internet Solutions (SA) > > > > > > Tel: (+27) 21 670 9880 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IP lookup
www.samspade.org 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 - Original Message - From: "Guy McDowell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 11:34 AM Subject: IP lookup > Hello, > > If I have a numeric IP address how can I look up who it > is registered to? > Just curious, because I'm getting some weird traffic > that might be related to Poison Box. > > Yours In Conservation, > > Guy J. McDowell > Webmaster > Ontario Federation of Anglers & Hunters > (705) 748-6324 ext. 262 > www.OFAH.org > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Duplicating database row
Howdy all. Is there an easy way to duplicate a row in a database rather than querying for a record then doing an insert of a new record with identical data? Something that will work in both Access and SQL Server would be great. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Best way to limit access to a specific template from "only" the previous template?
I put the following in my Application.cfm. It makes sure that if a user is not coming from my site that it directs them to the login page. It might help along with your if statement (with modifications of course). I can't take credit for it. I found most of it from other applications, but it does work well and also solves the problem of users piggybacking onto other user's sessions via copying their favorites. http://#request.site.Root##newString#";> -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:32 AM To: CF-Talk Subject: RE: Best way to limit access to a specific template from "only" the previous template? Just as a precaution, though I'm sure many of you know this... Using "CONTAIN" when testing url strings is almost worthless - since a url like http://www.crackers.com/hackattempt/haha.html?fool=template1.cfm is completely valid... > > Unauthorized host detected! Access denied! > > > > I also augmented the header line with an back to the login > screen. > > > Unauthorized access method detected? > http://129.174.xx.xxx/ssh/index.cfm";> Please login > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicating database row
What about: INSERT INTO table1 (col1, col2, col3... ) SELECT col1, col2, col3 FROM table2 HTH, Duane Boudreau, Chief Techical Re-Director HexaInteractive, LLC http://www.hexainteractive.com 603.620.8797 -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 12:35 PM To: CF-Talk Subject: Duplicating database row Howdy all. Is there an easy way to duplicate a row in a database rather than querying for a record then doing an insert of a new record with identical data? Something that will work in both Access and SQL Server would be great. Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Dynamic loop variables (or embedded #)
There is a function called Evaluate() that is pretty useful for these tasks: #evaluate("Form.Input#loopitem#")# Also, if you are using CF 4.5x you can refer to the form fields using the "Form Structure" and do your sting concatenation at the same time: #Form['input' & loopitem]# A little more about the "Form Structure": http://cfhub.com/advanced/cfloop/collection.cfm > This is my first post so please be gentle. > > I am trying to work out what syntax will reference dynamic variables within > dynamic variables, I am generating a dynamic number of text inputs in my > form but can't work out how to reference them in the #form.name# output. I'm > sure this is easy if you know how. Please help. > > Clare > > > > > > > > > > > > #form.input#loopitem## > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
Thanks! > -Original Message- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 5:45 PM > To: CF-Talk > Subject: RE: Referencing an array item > > > oops, forgot a closing ) > > > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email : [EMAIL PROTECTED] > ICQ UIN : 3679482 > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > > Sent: Monday, May 28, 2001 11:40 AM > > To: CF-Talk > > Subject: RE: Referencing an array item > > > > > > Whenever possible, don't use Evaluate, it's not that fast. In this case, > > SM1, SM2, are keys in the application scope. It is faster, and easier to > > read, to just do: > > > > > > > > p.s. Don't forget the read lock! > > > > === > > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > > > Email : [EMAIL PROTECTED] > > ICQ UIN : 3679482 > > > > "My ally is the Force, and a powerful ally it is." - Yoda > > > > > -Original Message- > > > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, May 28, 2001 8:50 AM > > > To: CF-Talk > > > Subject: Re: Referencing an array item > > > > > > > > > Once again, Evaluate to the rescue: > > > > > > #ArrayLen(Evaluate("application.SM & attributes.Num"))# > > > > > > OR > > > > > > #ArrayLen(Evaluate("application.SM#attributes.Num#"))# > > > > > > > I have 3 arrays, which are assigned to the application scope: > > > > > > > > > > > > > > > > > > > > > > > > My custom tag receives a number (1,2 or 3), and with that I > > > reference the > > > > correct array. I need to dynamically use this number to > reference the > > > > correct array, e.g. > > > > > > > > #ArrayLen(application.SM & attributes.Num)# > > > > > > > > (The above code does not work.) Any help would be much > > > appreciated!! Thanks > > > > in advance. > > > > > > > > Steve > > > > > > > > > > > > Development Manager > > > > Vardus Internet Solutions (SA) > > > > > > > > Tel: (+27) 21 670 9880 > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Duplicating database row
Just be careful. You can't use SELECT * if you have a primary key (I know YOU didn't use select * . I added this comment for those who might fall into that trap like I did the first time) Don - Original Message - From: "Duane Boudreau" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 10:32 PM Subject: RE: Duplicating database row > What about: > > INSERT INTO table1 (col1, col2, col3... ) > SELECT col1, col2, col3 > FROM table2 > > HTH, > Duane Boudreau, > Chief Techical Re-Director > HexaInteractive, LLC > http://www.hexainteractive.com > 603.620.8797 > > > -Original Message- > From: Bud [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 12:35 PM > To: CF-Talk > Subject: Duplicating database row > > > Howdy all. Is there an easy way to duplicate a row in a database > rather than querying for a record then doing an insert of a new > record with identical data? Something that will work in both Access > and SQL Server would be great. > > Thanks, > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
ray has an excellent point. however, why not exploit the nature of arrays? if you make Application.Sm an array with three elements, each one the arrays sm1..3, then you can reference an element in SM(n) by Application.SM[n][element]. you don't have to futz with string evaluation at all. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:41 AM To: CF-Talk Subject: Referencing an array item I have 3 arrays, which are assigned to the application scope: My custom tag receives a number (1,2 or 3), and with that I reference the correct array. I need to dynamically use this number to reference the correct array, e.g. #ArrayLen(application.SM & attributes.Num)# (The above code does not work.) Any help would be much appreciated!! Thanks in advance. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Duplicating database row
Hi Bud, I believe what you could do is an INSERT with a select command embedded into it. For example: INSERT INTO (column list) VALUES (select column list from whatever where whatever condition) Of course, the syntax isn't right, but the concept should work. ---mark Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net > -Original Message- > From: Bud [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 9:35 AM > To: CF-Talk > Subject: Duplicating database row > > > Howdy all. Is there an easy way to duplicate a row in a database > rather than querying for a record then doing an insert of a new > record with identical data? Something that will work in both Access > and SQL Server would be great. > > Thanks, > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Error pages
I have just written my first web app with cold fusion and I'm wondering what standard practice is with cferror This is my first go around so I won't be using cfcatch/cftry (unless I really should) but I'm wondering how many of you have the error page e-mail you with information? If so, what information do you have it e-mail to you? Is there a way to have it capture the "original" error message, the one that appears before the pretty new page, and have that e-mailed off to the admin? Thanks for your time Jason Stevens CF-developer in training ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error pages
Since you are just starting out I would recommend you use cftry/cfcatch. It gives you so much better control. Just my opinion. - Original Message - From: "Stevens, Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 4:39 PM Subject: Error pages > I have just written my first web app with cold fusion and I'm wondering what > standard practice is with cferror > > This is my first go around so I won't be using cfcatch/cftry (unless I > really should) but I'm wondering how many of you have the error page e-mail > you with information? If so, what information do you have it e-mail to you? > Is there a way to have it capture the "original" error message, the one that > appears before the pretty new page, and have that e-mailed off to the admin? > > Thanks for your time > > Jason Stevens > CF-developer in training > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFXGraphicsserver gets new home
FYI TeraTech http://www.teratech.com/ has has acquired ownership of the rights to CFXGraphicsServer, the server side graphing and charting solution for ColdFusion. We are working on a printed manual and a new release. Please email me off list if you have any requests for this release. :-) The tool provides high-performance real-time database sources graphing and charting for Macromedia's ColdFusion under Windows. Unlike similar products, the CFXGraphicsServer is 100% server-side, requiring no additional client-side controls (eg. ActiveX or Java), making it safe for use within a corporate Intranet environment. CFXGraphicsServer returns the image to the browser in JPG or, PNG formats. GIF format is support for users with a Unisys GIF licence. CFXGraphicsServer incorporates full "Point & Click" drill-down capability to graphically present complex data at various levels of detail. The product incorporates over 30 graph types and styles for use in aesthetically demanding environments and over 100 possible graph attributes. It also includes a full VTML "Visual Inference" that speeds up development: virtually no coding is required to generate graphs! More information is available from the site at http://www.cfxgraphicsserver.com/ -- Michael Smith, TeraTech Inc VB, CF , SQL, Math programming 12221 Parklawn Dr Ste 200, Rockville MD 20852-1711 USA Voice: +1-301-881-1440 x110, 800-447-9120 Fax:301-881-3586 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFXGraphicsserver gets new home
^_^ Is it a free Add - On to CF? -Gel The Wishful Thinker...:) -Original Message- From: Michael Smith [mailto:[EMAIL PROTECTED]] More information is available from the site at http://www.cfxgraphicsserver.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS from Stored Procedure MSSQL 7.0
> Is is possible to execute a DTS package from a stored procedure? The only way I know to do this off the top of my head is to to use xp_cmdshell to call the dtsrun command-line utility. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Scheduled Task with NTLM login
> Has any one gotten a scheduled task to work when using ntlm > login? I can only execute templates which are outside of a password > protected directory. I am passing the scheduled task my > username/password but it continually fails. Since Allaire started providing their own library for HTTP client functionality, this hasn't been supported. It may have worked in CF 3 and 4.0.x on Windows because Allaire used the Microsoft libraries for HTTP client functionality. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Error pages
sure, I can do that. When your app has difficulties, do you have it mail the admin with details? -Original Message- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 3:47 PM To: CF-Talk Subject: Re: Error pages Since you are just starting out I would recommend you use cftry/cfcatch. It gives you so much better control. Just my opinion. - Original Message - From: "Stevens, Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 4:39 PM Subject: Error pages > I have just written my first web app with cold fusion and I'm wondering what > standard practice is with cferror > > This is my first go around so I won't be using cfcatch/cftry (unless I > really should) but I'm wondering how many of you have the error page e-mail > you with information? If so, what information do you have it e-mail to you? > Is there a way to have it capture the "original" error message, the one that > appears before the pretty new page, and have that e-mailed off to the admin? > > Thanks for your time > > Jason Stevens > CF-developer in training > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Executing a CF page
Hi all, Is there a way to run a Cold Fusion page not through a browser, but spawned from a browser... confused.. imagine this... I want to give my user a button to click on a web page that runs a very lengthy process, say exporting the entire database to a CSV file, but I dont want to do the processing in a browser window, because if my user closes that window halfway through, it might cancel the processing. Is there a way to get the server processing something but not relying on a browser window for it? One way I can think of is to set up a one off CFSCHEDULE command to execute a page in 5 seconds time, which then removes itself from the schedule, but that seems a little messy.. any better way? --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error pages
depends on severity. usually log it in db and page somebody if it is bad enough - Original Message - From: "Stevens, Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 7:49 PM Subject: RE: Error pages > sure, I can do that. When your app has difficulties, do you have it mail the > admin with details? > > -Original Message- > From: Don Vawter [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 3:47 PM > To: CF-Talk > Subject: Re: Error pages > > > Since you are just starting out I would recommend you use cftry/cfcatch. It > gives you so much better control. Just my opinion. > > - Original Message - > From: "Stevens, Jason" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, May 28, 2001 4:39 PM > Subject: Error pages > > > > I have just written my first web app with cold fusion and I'm wondering > what > > standard practice is with cferror > > > > This is my first go around so I won't be using cfcatch/cftry (unless I > > really should) but I'm wondering how many of you have the error page > e-mail > > you with information? If so, what information do you have it e-mail to > you? > > Is there a way to have it capture the "original" error message, the one > that > > appears before the pretty new page, and have that e-mailed off to the > admin? > > > > Thanks for your time > > > > Jason Stevens > > CF-developer in training > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Executing a CF page
Ryan, there is CFEXEC (or similarly named) that executes a dos level job of anything you want... takes the interaction off the user at that point and puts the job in a secure execution mode... just an idea -paris http://www.pubcrawler.com [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: "Ryan Sabir" <[EMAIL PROTECTED]> Date: Tue, 29 May 2001 11:51:44 +1000 Subject: Executing a CF page > > Hi all, > > Is there a way to run a Cold Fusion page not through a browser, but > spawned > from a browser... confused.. imagine this... > > I want to give my user a button to click on a web page that runs a > very > lengthy process, say exporting the entire database to a CSV file, but > I dont > want to do the processing in a browser window, because if my user > closes > that window halfway through, it might cancel the processing. Is there > a way > to get the server processing something but not relying on a browser > window > for it? > > One way I can think of is to set up a one off CFSCHEDULE command to > execute > a page in 5 seconds time, which then removes itself from the > schedule, but > that seems a little messy.. any better way? > > --- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 > http://www.newgency.com/index.cfm?referer=rysig > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using IE5 HTTP com object
I have looked on cfcomet.com and have not found an answer to this, does anyone have any example code for using IE5 http com object. I would like to do some things with it. Bob Everland ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Executing a CF page
Just a thought, but isn't there a button in the CF Administrator to run a scheduled task? Does it run it immediately in a browser, or just queue it up? I thought it just queued it up (but not sure), doing exactly what you want it to do. If so, you can decode the CF Administrator and see how they did it... At 11:51 AM 05/29/2001 +1000, you wrote: >Hi all, > >Is there a way to run a Cold Fusion page not through a browser, but spawned >from a browser... confused.. imagine this... > >I want to give my user a button to click on a web page that runs a very >lengthy process, say exporting the entire database to a CSV file, but I dont >want to do the processing in a browser window, because if my user closes >that window halfway through, it might cancel the processing. Is there a way >to get the server processing something but not relying on a browser window >for it? > >One way I can think of is to set up a one off CFSCHEDULE command to execute >a page in 5 seconds time, which then removes itself from the schedule, but >that seems a little messy.. any better way? > >--- >Ryan Sabir >Newgency Pty Ltd >2a Broughton St >Paddington 2021 >Sydney, Australia >Ph (02) 9331 2133 >Fax (02) 9331 5199 >Mobile: 0411 512 454 >http://www.newgency.com/index.cfm?referer=rysig > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS from Stored Procedure MSSQL 7.0
this might help: http://www.swynk.com/friends/green/dtsole.asp -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 6:44 PM To: CF-Talk Subject: RE: DTS from Stored Procedure MSSQL 7.0 > Is is possible to execute a DTS package from a stored procedure? The only way I know to do this off the top of my head is to to use xp_cmdshell to call the dtsrun command-line utility. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Executing a CF page
I believe CFEXECUTE will spawn the job and not wait for it to finish before returning control to the template. Which, in this case, is exactly what you want. You could then run cfml.exe at the command line to process the CF template you need run... (ie. c:\cfusion\bin\cfml.exe c:\web\longtemplate.cfm) > Is there a way to run a Cold Fusion page not through a browser, but spawned > from a browser... confused.. imagine this... > > I want to give my user a button to click on a web page that runs a very > lengthy process, say exporting the entire database to a CSV file, but I dont > want to do the processing in a browser window, because if my user closes > that window halfway through, it might cancel the processing. Is there a way > to get the server processing something but not relying on a browser window > for it? > > One way I can think of is to set up a one off CFSCHEDULE command to execute > a page in 5 seconds time, which then removes itself from the schedule, but > that seems a little messy.. any better way? > > --- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 > http://www.newgency.com/index.cfm?referer=rysig > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IE4.5 Mac form problem issue! Help.
Hello cf-talk, A mac user (HTTP_USER_AGENT = Mozilla/4.0 (compatible; MSIE 4.5; Mac_PowerPC)) This error message is caused by the second line of a page called authenticate.cfm! An error occurred while evaluating the expression: #button# is " L O G I N " I'm using this as the first few lines: SELECT * FROM guides WHERE Password = '#Form.Password#' AND Password = '#Form.Password#' AND Login = '#Form.Login#' How could something so simple cause an error? the page that leads to this has this for a form: Login: Pass: Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Error pages
> This is my first go around so I won't be using cfcatch/cftry (unless I > really should) You *always* should, every time you think you *might* run into *any* type of error .. and even when you don't think you will, at all. :) > but I'm wondering how many of you have the error page > e-mail you with information? My take is that the app should always E-mail/contact *someone* .. it means that the user has done something that no one ever expected and someone needs to do something about it. > If so, what information do you have it e-mail to you? All info that the developer needs to fix the prob and that the user should never see .. directory path, file name, database error, etc. > Is there a way to have it capture the "original" error message, the one > that appears before the pretty new page, and have that e-mailed off to the > admin? Look up the help doc on cfcatch/cftry. The only "pretty page" that the user needs to see is that an error has occured and that the 'admins' will fix it soon. Anything else should provide contact info to follow-up, if needed. You should be able to combine both functions into one page, so that the app displays both the error to the user and also E-mails the problem to the admin(s). Todd > > I have just written my first web app with cold fusion and I'm wondering > what > > standard practice is with cferror > > > > This is my first go around so I won't be using cfcatch/cftry (unless I > > really should) but I'm wondering how many of you have the error page > e-mail > > you with information? If so, what information do you have it e-mail to > you? > > Is there a way to have it capture the "original" error message, the one > that > > appears before the pretty new page, and have that e-mailed off to the > admin? > > > > Thanks for your time > > > > Jason Stevens > > CF-developer in training ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SSL, IIS & CF...
Hey all... I am going to be a complete heel and ask a few questions about SSL to those who seem to work with it quite a bit in real world scenarios. I haven't had to implement an SSL-protected site or templates in some time and seem to be stumbling when trying to implement a strategy to begin. My situation is this: I have written an entire site, including non-secure forms that collect and store user data and the like using CF and SQL Server. I am in the process of "securing" the pages using SSL but have been having problems getting started. Is there any way I can use a directory to house both secure and non-secure forms and call them merely using https instead of http? I am having the worst time in trying to get even a page to show up using IIS's "directory security" using an SSL key pointed to an IP using the secured directory. There always seems to either be a page not found error or a SSL protected page error. Any help at all in getting any or all of these issues ironed out would be extremely useful, as I did not think it would take much time at all to roll out a secured version of the templates I had already writtenwhich may be an extremely huge misguided thought. Also, does anyone know of a GOOD repository of SSL, IIS, CF and setting these up in general? I have scoured the Microsoft site to no avail, and there is not much better info available from Allaire, it seems. Thanks a ton for the vine...and any help you may send my way. Cheers, Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE4.5 Mac form problem issue! Help.
Have you tried changing the name of the button to something other than 'button'.. There might be some strange reserved word browser issues going on... -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 May 2001 1:51 PM To: CF-Talk Subject: IE4.5 Mac form problem issue! Help. Hello cf-talk, A mac user (HTTP_USER_AGENT = Mozilla/4.0 (compatible; MSIE 4.5; Mac_PowerPC)) This error message is caused by the second line of a page called authenticate.cfm! An error occurred while evaluating the expression: #button# is " L O G I N " I'm using this as the first few lines: SELECT * FROM guides WHERE Password = '#Form.Password#' AND Password = '#Form.Password#' AND Login = '#Form.Login#' How could something so simple cause an error? the page that leads to this has this for a form: Login: Pass: Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IE4.5 Mac form problem issue! Help.
I have heard some odd stories about Macs... Often the solution seems to be Trim(). Maybe: ? > Have you tried changing the name of the button to something other than > 'button'.. There might be some strange reserved word browser issues going > on... > > > > -Original Message- > From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 29 May 2001 1:51 PM > To: CF-Talk > Subject: IE4.5 Mac form problem issue! Help. > > > Hello cf-talk, > > A mac user (HTTP_USER_AGENT = Mozilla/4.0 (compatible; MSIE 4.5; > Mac_PowerPC)) > > This error message is caused by the second line of a page called > authenticate.cfm! > > > An error occurred while evaluating the expression: > > #button# is " L O G I N " > > I'm using this as the first few lines: > > > > > > SELECT * FROM guides > WHERE Password = '#Form.Password#' > > AND Password = '#Form.Password#' > > > AND Login = '#Form.Login#' > > > > > How could something so simple cause an error? > > the page that leads to this has this for a form: > > > >align="CENTER" valign="MIDDLE"> > >Login: > > Pass: > > > > name="Account" >value="#NOW()#"> > > > VALUE="#Now()#"> > > name="Button" >value=" L O G I N "> > > > > > > Best regards, > Jeff Fongemie mailto:[EMAIL PROTECTED] > > Internet Guns For Hire > (603) 356-0768 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS & CF...
Brandon, Say your non-secure site is at "www.mysite.com". Is your certificate issued for "www.mysite.com" or some other host name like "secure.mysite.com"? In IIS, have you set up two distinct virtual sites, or do you merely have both port 80 and port 443 enabled for a single virtual site? I've found the easiest way to work with SSL is to simply have the cert issued for the standard domain name "www.mysite.com". Then content can be served using either http or https. Jim - Original Message - From: "Brandon Wood" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 9:49 PM Subject: SSL, IIS & CF... > Hey all... > > I am going to be a complete heel and ask a few questions about SSL to those who seem to work with it quite a bit in real world scenarios. I haven't had to implement an SSL-protected site or templates in some time and seem to be stumbling when trying to implement a strategy to begin. > > My situation is this: > I have written an entire site, including non-secure forms that collect and store user data and the like using CF and SQL Server. I am in the process of "securing" the pages using SSL but have been having problems getting started. > > Is there any way I can use a directory to house both secure and non-secure forms and call them merely using https instead of http? > > I am having the worst time in trying to get even a page to show up using IIS's "directory security" using an SSL key pointed to an IP using the secured directory. There always seems to either be a page not found error or a SSL protected page error. Any help at all in getting any or all of these issues ironed out would be extremely useful, as I did not think it would take much time at all to roll out a secured version of the templates I had already writtenwhich may be an extremely huge misguided thought. > > Also, does anyone know of a GOOD repository of SSL, IIS, CF and setting these up in general? I have scoured the Microsoft site to no avail, and there is not much better info available from Allaire, it seems. Thanks a ton for the vine...and any help you may send my way. > > Cheers, > Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS & CF...
Jim, I issued the cert under the standard www.mysite.com. I haven't set up two virtual sites using different ports. Is that the key? And if so, how can you set them up to both use the same dir? I have tried to just use a single site with both ports open and that doesn't seem to work. Every time I try to connect to the https URL, I get a page not found error--for the same template I can call with no problem using the standard http request. Thanks for your help, by the way. I think you are on thr right track to getting me edumacated...or as Stan says, "You must no ssl sites good." Cheers and clarification, Brandon - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 11:29 PM Subject: Re: SSL, IIS & CF... > Brandon, > > Say your non-secure site is at "www.mysite.com". Is your certificate issued > for "www.mysite.com" or some other host name like "secure.mysite.com"? > > In IIS, have you set up two distinct virtual sites, or do you merely have > both port 80 and port 443 enabled for a single virtual site? > > I've found the easiest way to work with SSL is to simply have the cert > issued for the standard domain name "www.mysite.com". Then content can be > served using either http or https. > > Jim > > > - Original Message - > From: "Brandon Wood" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, May 28, 2001 9:49 PM > Subject: SSL, IIS & CF... > > > > Hey all... > > > > I am going to be a complete heel and ask a few questions about SSL to > those who seem to work with it quite a bit in real world scenarios. I > haven't had to implement an SSL-protected site or templates in some time and > seem to be stumbling when trying to implement a strategy to begin. > > > > My situation is this: > > I have written an entire site, including non-secure forms that collect and > store user data and the like using CF and SQL Server. I am in the process > of "securing" the pages using SSL but have been having problems getting > started. > > > > Is there any way I can use a directory to house both secure and non-secure > forms and call them merely using https instead of http? > > > > I am having the worst time in trying to get even a page to show up using > IIS's "directory security" using an SSL key pointed to an IP using the > secured directory. There always seems to either be a page not found error > or a SSL protected page error. Any help at all in getting any or all of > these issues ironed out would be extremely useful, as I did not think it > would take much time at all to roll out a secured version of the templates I > had already writtenwhich may be an extremely huge misguided thought. > > > > Also, does anyone know of a GOOD repository of SSL, IIS, CF and setting > these up in general? I have scoured the Microsoft site to no avail, and > there is not much better info available from Allaire, it seems. Thanks a > ton for the vine...and any help you may send my way. > > > > Cheers, > > Brandon > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS & CF...
That sounds like the way I usually set it up. Under the virtual site's properties you have TCP port 80 and SSL port 443 specified. If you click 'Advanced' you should see both ports bound to their respective IP address or host header. Are you using host headers (IPless domains) on your web server? If you're using host headers, remember that for SSL you need to have an IP address to which you bind the certificate. So, you could use host headers for the non-SSL (port 80) site, but you need an IP for SSL. Since you need a (dedicated) IP address for SSL on this site anyway, I'd just set up the http/port80 side using standard IP-based domain resolution as well and not use host headers at all for this particular virtual site. Have you completed installation of the certificate in Key Manager and pointed it to the correct IP address? Jim - Original Message - From: "Brandon Wood" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 11:03 PM Subject: Re: SSL, IIS & CF... > Jim, > > I issued the cert under the standard www.mysite.com. I haven't set up two > virtual sites using different ports. Is that the key? And if so, how can > you set them up to both use the same dir? > > I have tried to just use a single site with both ports open and that doesn't > seem to work. Every time I try to connect to the https URL, I get a page > not found error--for the same template I can call with no problem using the > standard http request. > > Thanks for your help, by the way. I think you are on thr right track to > getting me edumacated...or as Stan says, "You must no ssl sites good." > > Cheers and clarification, > Brandon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Paste Screen Capture into a browser and submit it
I am stumped. Are there any CF Gods out there? I need to add the capability of a user to paste a screen capture(alt - print screen) of a windows application error, into a browser "form" without the user having to open another application, save the image , close the application, find the saved file, select it and then upload it. I am not talking about text, I am talking about the bitmap created from a screen capture . I don't know if it resides in the clipboard. The user needs to be able to paste it into a browser page and submit it. I tried CFX_DynamicImage and it brought my server to it's knees. Any Ideas? Thanks, Don ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Paste Screen Capture into a browser and submit it
I think a printscreen is a bitmap. I cant see how you can avoid the upload step but you might be able to automate the steps in between. At 04:00 PM 29/05/01, you wrote: >I am stumped. Are there any CF Gods out there? > >I need to add the capability of a user to paste a screen capture(alt - >print screen) of a windows application error, into a browser "form" >without the user having to open another application, save the image , close >the application, find the saved file, select it and then upload it. I am >not talking about text, I am talking about the bitmap created from a screen >capture . I don't know if it resides in the clipboard. The user needs to >be able to paste it into a browser page and submit it. > >I tried CFX_DynamicImage and it brought my server to it's knees. > >Any Ideas? > >Thanks, >Don ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Excluding Time in Date/Time db Query
I'm doing a query where I want to get values from a date/time field (Access). I want the date (for grouping), but not the time portion. I've tried datepart, but I would need to do several dateparts, for weekdate, month, day and year - then I can't group by date. Any ideas on how to write the query select statement? Is there sdth=hing I need to do in the CFOUTPUT QUERY area? Thanks, Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
But I have 3 arrays, so it will really need to look like: Application.SM1[n][element] Application.SM2[n][element] Application.SM3[n][element] I can't see how else to work around this. > -Original Message- > From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 8:31 PM > To: CF-Talk > Subject: RE: Referencing an array item > > > ray has an excellent point. however, why not exploit the nature > of arrays? > if you make Application.Sm an array with three elements, each one > the arrays > sm1..3, then you can reference an element in SM(n) by > Application.SM[n][element]. you don't have to futz with string evaluation > at all. > > chris olive, cio > cresco technologies > [EMAIL PROTECTED] > http://www.crescotech.com > > > > -Original Message- > From: Steve Vosloo [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 28, 2001 8:41 AM > To: CF-Talk > Subject: Referencing an array item > > > I have 3 arrays, which are assigned to the application scope: > > > > > > My custom tag receives a number (1,2 or 3), and with that I reference the > correct array. I need to dynamically use this number to reference the > correct array, e.g. > > #ArrayLen(application.SM & attributes.Num)# > > (The above code does not work.) Any help would be much > appreciated!! Thanks > in advance. > > Steve > > > Development Manager > Vardus Internet Solutions (SA) > > Tel: (+27) 21 670 9880 > Fax: (+27) 21 674 4549 > > Email: [EMAIL PROTECTED] > Website: www.vardus.com > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL, IIS & CF...
Jim, Right now, I have only 2 IP Addresses available to use. 1 for the machine, and 1 for the site. Right now, I am using the machine's IP and the site's for the regular http site. I haven't dedicated one of those for the SSL key, which I could. Right now, when I click advanced, I only see port 80 attached to the site's IP. What dould you recommend? I do have two IPs available to use. So are you saying that I create a single site in the MMC and then create 2 virtual directories each having a different IP or are you saying to create 2 sites with each pointing to the same home directory but with different ports and different IPs bound to the same? You are really helping me out here...I haven't message with virtual hosting and leave most of the hosting side of things to those who know better...but in this case, I am the only one holding the bag. If you can be specific in what should go in the site parameters, the IP config for both the ports and sites, advanced properties and possible host header places, I think I might just be on my way...for the record, I guess I do have two IPs I can use, I can point the Key to either of them in the Key Manager and have nothing more to losehehe Thanks a ton, Brandon - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 29, 2001 12:24 AM Subject: Re: SSL, IIS & CF... > That sounds like the way I usually set it up. Under the virtual site's > properties you have TCP port 80 and SSL port 443 specified. If you click > 'Advanced' you should see both ports bound to their respective IP address or > host header. > > Are you using host headers (IPless domains) on your web server? If you're > using host headers, remember that for SSL you need to have an IP address to > which you bind the certificate. So, you could use host headers for the > non-SSL (port 80) site, but you need an IP for SSL. Since you need a > (dedicated) IP address for SSL on this site anyway, I'd just set up the > http/port80 side using standard IP-based domain resolution as well and not > use host headers at all for this particular virtual site. > > Have you completed installation of the certificate in Key Manager and > pointed it to the correct IP address? > > Jim > > > - Original Message - > From: "Brandon Wood" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, May 28, 2001 11:03 PM > Subject: Re: SSL, IIS & CF... > > > > Jim, > > > > I issued the cert under the standard www.mysite.com. I haven't set up two > > virtual sites using different ports. Is that the key? And if so, how can > > you set them up to both use the same dir? > > > > I have tried to just use a single site with both ports open and that > doesn't > > seem to work. Every time I try to connect to the https URL, I get a page > > not found error--for the same template I can call with no problem using > the > > standard http request. > > > > Thanks for your help, by the way. I think you are on thr right track to > > getting me edumacated...or as Stan says, "You must no ssl sites good." > > > > Cheers and clarification, > > Brandon > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists