Referencing an array item

2001-05-28 Thread Steve Vosloo
I have 3 arrays, which are assigned to the application scope: cfset Application.SM1 = SM1 cfset Application.SM2 = SM2 cfset Application.SM3 = SM3 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

Re: Referencing an array item

2001-05-28 Thread Tony Schreiber
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: cfset Application.SM1 = SM1 cfset Application.SM2 = SM2 cfset Application.SM3 =

IP lookup

2001-05-28 Thread Guy McDowell
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

RE: Referencing an array item

2001-05-28 Thread Raymond Camden
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: CFSET Len = ArrayLen(Application[SM#Attributes.Num#] p.s. Don't forget the read lock!

RE: IP lookup

2001-05-28 Thread Dan Phillips
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

RE: Referencing an array item

2001-05-28 Thread Raymond Camden
oops, forgot a closing ) CFSET Len = ArrayLen(Application[SM#Attributes.Num#]) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and

Re: IP lookup

2001-05-28 Thread Howie Hamlin
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:

Duplicating database row

2001-05-28 Thread Bud
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

RE: Best way to limit access to a specific template from only the previous template?

2001-05-28 Thread Sandy Clark
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

RE: Duplicating database row

2001-05-28 Thread Duane Boudreau
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,

Re: Dynamic loop variables (or embedded #)

2001-05-28 Thread Joseph Thompson
There is a function called Evaluate() that is pretty useful for these tasks: cfif isdefined(form.go) cfloop index=loopitem from=1 to=3 cfoutput #evaluate(Form.Input#loopitem#)# /cfoutput /cfloop /cfif Also, if you are using CF 4.5x you can refer to the form fields using the Form

RE: Referencing an array item

2001-05-28 Thread Steve Vosloo
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 ) CFSET Len = ArrayLen(Application[SM#Attributes.Num#])

Re: Duplicating database row

2001-05-28 Thread Don Vawter
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

RE: Referencing an array item

2001-05-28 Thread Christopher Olive, CIO
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

RE: Duplicating database row

2001-05-28 Thread Mark Warrick
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

Error pages

2001-05-28 Thread Stevens, Jason
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

Re: Error pages

2001-05-28 Thread Don Vawter
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

CFXGraphicsserver gets new home

2001-05-28 Thread Michael Smith
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

RE: CFXGraphicsserver gets new home

2001-05-28 Thread Angel Stewart
^_^ 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

RE: DTS from Stored Procedure MSSQL 7.0

2001-05-28 Thread Dave Watts
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

RE: Scheduled Task with NTLM login

2001-05-28 Thread Dave Watts
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

RE: Error pages

2001-05-28 Thread Stevens, Jason
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

Executing a CF page

2001-05-28 Thread Ryan Sabir
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

Re: Error pages

2001-05-28 Thread Don Vawter
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

Re: Executing a CF page

2001-05-28 Thread Paris Lundis
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

Using IE5 HTTP com object

2001-05-28 Thread Robert Everland III
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

Re: Executing a CF page

2001-05-28 Thread Jeffry Houser
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

RE: DTS from Stored Procedure MSSQL 7.0

2001-05-28 Thread Dylan Bromby
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

Re: Executing a CF page

2001-05-28 Thread Tony Schreiber
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

IE4.5 Mac form problem issue! Help.

2001-05-28 Thread Jeff Fongemie
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

Re: Error pages

2001-05-28 Thread Todd Ashworth
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

SSL, IIS CF...

2001-05-28 Thread Brandon Wood
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

RE: IE4.5 Mac form problem issue! Help.

2001-05-28 Thread Ryan Sabir
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

Re: IE4.5 Mac form problem issue! Help.

2001-05-28 Thread Joseph Thompson
I have heard some odd stories about Macs... Often the solution seems to be Trim(). Maybe: cfif Trim(Form.Button) IS Login ? 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...

Re: SSL, IIS CF...

2001-05-28 Thread Jim McAtee
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

Re: SSL, IIS CF...

2001-05-28 Thread Brandon Wood
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

Re: SSL, IIS CF...

2001-05-28 Thread Jim McAtee
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

Paste Screen Capture into a browser and submit it

2001-05-28 Thread Don VanMeter
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

Re: Paste Screen Capture into a browser and submit it

2001-05-28 Thread Mark Ireland
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 -

Excluding Time in Date/Time db Query

2001-05-28 Thread Mark Leder
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