RE: Very vague error message

2003-11-16 Thread peter . tilbrook
1000+ lines of code in a single CF template seems a bit excessive for starters. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927  

Inserting rows into a 2d array

2003-11-16 Thread DougF
Hi all, Need some help with inserting rows into a 2d array. As an example I populate an array with values cityName and LocationID from a query. I then need to insert a new ROW between row 4 and row 5. In essence shifting rows 5 and below down one row. I'd thought of appending to the array, then us

Re: CFMX JRun Servlets - Help!

2003-11-16 Thread Ryan Sabir
Heya Will, Are you running Enterprise or Standard? Unless you are running Enterprise, then you can't use the included JRUN server to serve anything but Cold Fusion templates... or thats what I understand anyway... What problem are you having, are they license violation errors? bye Monday, Novem

CFMX JRun Servlets - Help!

2003-11-16 Thread Will Blackie
I'm attempting to setup a credit card gateway (Worldpay - select pro, java) which requires some servlets to operate.  Basically I'm having trouble setting them up to run on the version of JRun that comes with CFMX, can anyone offer a basic tutorial on what/how i have to configure on the server to a

RE: Very vague error message

2003-11-16 Thread Michael T. Tangorre
Cool. I wish I wasn't up Managerial accounting homework is not as much fun as Cold Fusion Coding :-)   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:42 PM To: CF-Talk Subject: RE: Very vague error message taking it @ max on the 20th :) studying while

RE: Very vague error message

2003-11-16 Thread Tony Weeg
taking it @ max on the 20th :) studying while working tonight!! tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:42 PM To: CF-Talk Subject: RE: Very vague error message Weegs, how did the test go?   _   From: Tony Weeg [

RE: Very vague error message

2003-11-16 Thread Michael T. Tangorre
Weegs, how did the test go?   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:37 PM To: CF-Talk Subject: RE: Very vague error message how about it? never used it :) tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: S

RE: Very vague error message

2003-11-16 Thread Tony Weeg
how about it? never used it :) tw -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:33 PM To: CF-Talk Subject: RE: Very vague error message How about cftrace?   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, No

RE: Very vague error message

2003-11-16 Thread Michael T. Tangorre
How about cftrace?   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')#> ! and place it before trouble points, or after them to see if they are reall

RE: Very vague error message

2003-11-16 Thread Tony Weeg
assuming that it is within tags, that is ;) tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 10:24 PM To: CF-Talk Subject: RE: Very vague error message i always use Im here (#timeFormat(now(),'hh:mm:ss')#> ! and place it before troub

RE: Very vague error message

2003-11-16 Thread Tony Weeg
i always use Im here (#timeFormat(now(),'hh:mm:ss')#> ! and place it before trouble points, or after them to see if they are really, trouble points.  stepping through the code, its the easiest way i can see for myself to debug, unless i know *exactly* where the code is wrong, of course. but, yo

RE: Very vague error message

2003-11-16 Thread Michael S. Hodgdon
I have never come across this in a ColdFusion.  One way you can try to pinpoint the error is to place statement at say, line 50. Run your code and if you don't get an error, place the on line 100 and run the code.  Keep doing this until you get closer to the error. Do you have any idea where it

RE: SQL server question

2003-11-16 Thread Robyn Follen
Ah, perfect. This worked! Thanks -Robyn -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 8:42 PM To: CF-Talk Subject: RE: SQL server question > I recently did something really dumb - I had a really small > SQL server database that I was usi

RE: SQL server question

2003-11-16 Thread chris kief
Open Enterprise Manager and right click the Databases folder. Choose attach database from the all tasks menu. A new window will open which will allow you to select the MDF file and attach the database. chris   _   From: Robyn Follen [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 200

RE: SQL server question

2003-11-16 Thread Dave Watts
> I recently did something really dumb - I had a really small > SQL server database that I was using for a home project, and, > during an upgrade fiasco (long story), I deleted it by mistake. > Now... I see that the .MDF and .LDF files still exist in my > MSSQL7/data folder, and I would like to

OT: SQL server question

2003-11-16 Thread Robyn Follen
Hey all, I recently did something really dumb - I had a really small SQL server database that I was using for a home project, and, during an upgrade fiasco (long story), I deleted it by mistake.  Now... I see that the .MDF and .LDF files still exist in my MSSQL7/data folder, and I would like to re

Re: Compensating for Server Time

2003-11-16 Thread Chris Montgomery
Sunday, November 16, 2003, 6:14:47 PM, Chris Montgomery wrote: > LocalTime() at cflib.org This UDF uses , which I guess is an MX tag. I converted Chad Jackson's UDF to be compatible with CF5 (in case anyone else wants it). Note that the offset is for Central Daylight Time (-6).   function Loc

Re: Compensating for Server Time

2003-11-16 Thread Chris Montgomery
Looks like LocalTime() at cflib.org might be just what the doctor ordered ( http://www.cflib.org/udf.cfm?ID=719 ). Gonna give it a try. -- Chris Montgomery Airtight Web Services   http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads]

Re: Compensating for Server Time

2003-11-16 Thread Chris Montgomery
Howdy Tony, Sunday, November 16, 2003, 3:49:51 PM, Tony Weeg wrote: > there is a great little cfc @ cfczone.org Ooops, forgot to mention: this is on CF5/Windows. I'll take a look at the CFC anyway, might give me some good tips. -- Chris Montgomery Airtight Web Services   http://www.airtightweb

Re: Compensating for Server Time

2003-11-16 Thread Chris Montgomery
Sunday, November 16, 2003, 2:55:11 PM, Jochem van Dieten wrote: > I use the AT TIME ZONE functionality from SQL, it even > compensates for daylight savings time... Thanks Jochem, Tony, Tim, Novak, et. al. I'll look into your recommendations. I should have clarified the situation a bit more, how

RE: Ideas needed! Password protect a file download.

2003-11-16 Thread Michael T. Tangorre
Thats why I love hostmysite.com for my CF hosting needs.. They allow the tags!   _   From: Jeff Fongemie [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:00 PM To: CF-Talk Subject: Re:Ideas needed! Password protect a file download. You guys are fantastic. I just talked to the cru

Re:Ideas needed! Password protect a file download.

2003-11-16 Thread Jeff Fongemie
You guys are fantastic. I just talked to the crummy isp for the site and it looks like it may take some work to get them to allow me to use the cfcontent tag, but they are considering it. Looks like it is the way to go. I'll report back if I can get them to switch it back on. Thanks!!! [Todays T

RE: Compensating for Server Time

2003-11-16 Thread Tony Weeg
sure, but just getting it from their browser time is the best way, if you let them input it, they can mess it up, user error, one more thing to tech support. either way is fine, but somethign that is easy to abstract from a "dumb" customer is always nice! tony -Original Message- From: Ti

RE: Compensating for Server Time

2003-11-16 Thread Tim
Yes you can detect their time zone everytime they login or what I've done in the past is to build it in to the users profile, so that the user has the ability to select the time zone their in when they create/update their profile. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED

RE: Compensating for Server Time

2003-11-16 Thread Tony Weeg
read on tony, sorry, i see you were just explaining the way to the sql in one shot :) tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:38 PM To: CF-Talk Subject: RE: Compensating for Server Time but how are you going to *KNOW* the perso

RE: Compensating for Server Time

2003-11-16 Thread Tony Weeg
but how are you going to *KNOW* the persons local time? _javascript_ is the only way. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:35 PM To: CF-Talk Subject: RE: Compensating for Server Time If you want to it directly from SQL you can create a

RE: weird one! help :)

2003-11-16 Thread Tony Weeg
but of course ;) -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:34 PM To: CF-Talk Subject: RE: weird one! help :) Weegs, I sure hope you got the monitor in one eye and an NFL game in the other :-)   _   From: Tony Weeg [mail

RE: Compensating for Server Time

2003-11-16 Thread Tim
If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin     declare @localtime datetime     select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate)     retur

RE: weird one! help :)

2003-11-16 Thread Michael T. Tangorre
Weegs, I sure hope you got the monitor in one eye and an NFL game in the other :-)   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:24 PM To: CF-Talk Subject: RE: weird one! help :) yeah, i thought the same, but on any other page request, no error like that,

RE: weird one! help :)

2003-11-16 Thread Tony Weeg
yeah, i thought the same, but on any other page request, no error like that, ive actually narrowed it down to some code in some cfcase tags, its weird... tony -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:27 PM To: CF-Talk Subject: RE: we

RE: weird one! help :)

2003-11-16 Thread Dave Watts
> i have site director3 and for some reason on my console > this is the error i get, when trying to load my order manager... > what does this mean?  ihave at line 1.  what gives? I have no idea, but I'd guess that the error is occurring in Application.cfm. Dave Watts, CTO, Fig Leaf Software http

weird one! help :)

2003-11-16 Thread Tony Weeg
i have site director3 and for some reason on my console this is the error i get, when trying to load my order manager... what does this mean?  ihave at line 1.  what gives? thanks. tony Error Occurred While Processing Request   The system has attempted to use an undefined value, which usually in

Directory, download and cfmail attachment issues

2003-11-16 Thread Carol Chandler
Hi all, We have just moved from Windows to Linux, and CF5 to MX.  This move brought a whole host of unpleasant issues with it, mostly having to do with our download process.   1.  Does anyone know of a really good zip tag that works with Linux?  I loved Ben Forta's cfx_zip on Windows, but can't f

RE: Compensating for Server Time

2003-11-16 Thread cf-talk
Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer.  I then store the time zone offset in a cookie or session/client variable.  I then use a UDF to convert the time from the SQL server to that user's local time. If there was a

RE: Compensating for Server Time

2003-11-16 Thread Tony Weeg
there is a great little cfc @ cfczone.org that paul hastings whipped up that does some timezone work.  best way, is to use _javascript_ to get the time of the browser, set that timezone offset as a cookie on the users browser, then access that with the cookie. whatever you call it variable name in

Re: Compensating for Server Time

2003-11-16 Thread Jochem van Dieten
Chris Montgomery wrote: > > What's the best way to compensate for time on a server in a hosted > environment when the time is set to a different time than a user's local > time zone? Ex: client is in Central Time, server is on Eastern Time (one > hour ahead); client wants everything to reflect loc

Compensating for Server Time

2003-11-16 Thread Chris Montgomery
Howdy, What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. Thanks. -- Chri

Opinions: Where to Save data for both "public" and "logged in" users

2003-11-16 Thread Jim Davis
I've got an existing site for a large, day festival.  The system has three types of identification: 1) "SessionID" - ID stored in a non-persistent cookie.  We store clickstreams (page visits), for example linked to the SessionID. 2) "ClientID" - ID stored in a persistent cookie.  We store, for ex

RE: Ideas needed! Password protect a file download.

2003-11-16 Thread Kwang Suh
If you put the downloadable files into the web root, then they're not at all protectable by CF. Downloadable files need to be placed somewhere off the web root. -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: November 16, 2003 10:41 AM To: CF-Talk Subject: RE: Idea

Re: SOT: Internal/Intranet Search Engines - What to ask the sales critters

2003-11-16 Thread Larry C. Lyons
Jeremy Brodie wrote: > Larry, > > Some of the critical questions to help you in your search. > > 1) Do you need to search locally from a CD/DVD or from a server? > 2) In what file format is the manual (PDF, word docs, etc) > 3) What will you use as your user interface for searching the manual >

RE: Ideas needed! Password protect a file download.

2003-11-16 Thread Philip Arnold
Use CFContent to pass the file to the user, but have it behind a login type thing - then you can check that the user has rights to the relevant file With CFContent you can place the files anywhere on the hard disk, so they can be nowhere near the browsable area -Original Message- From:

Re: Ideas needed! Password protect a file download.

2003-11-16 Thread Tom Kitta
What you need is cfcontent tag. Set standard security in application.cfm file. Once user is logged in create a page under application.cfm control called download.cfm. In that file place cfcontent tag set for the file you wish user to get. User selects what he wants from index.cfm and gets redirecte

RE: Ideas needed! Password protect a file download.

2003-11-16 Thread Paul Vernon
> The part I'm not sure about is protecting the file itself. I want the file to be protected so no one can brows to it by http. Jeff, A bit of pseudo code for you.         value="attachment;filename=thefilenamethatyouwanttheusertosee">     type="putyourmimetypehere">     Access denied! P

Ideas needed! Password protect a file download.

2003-11-16 Thread Jeff Fongemie
Hey everyone, Very soon I'll need to set up a system that will let users download files. The users will need to be logged in, so I'll be checking for a username and password before I let them download the file. The part I'm not sure about is protecting the file itself. I want the file to be protec

RE: HTML e-Newsletter

2003-11-16 Thread Matt Robertson
To add another bit to this:   You can do the same thing as ubqtous referenced for images to your style sheet call.  Won't work on any kind of web mail, but not sure what your project requirements are.  Best used when you know your recipients are using mail clients that can handle this (i.e. Outloo

Re: JOIN help

2003-11-16 Thread Cedric Villat
Jochem, Thanks, that worked like a champ. I had a solution using 2 queries, but that wasn't really elegant. This should be much better. Thanks! Cedric > Subject: JOIN help > From: Jochem van Dieten <[EMAIL PROTECTED]> > Date: Sun, 16 Nov 2003 13:53:17 +0100 > Thread: http://www.houseoffusion.com

Re: HTML e-Newsletter

2003-11-16 Thread cf-talk
That might help: http://www.easycfm.com/tutorials/pdf_output.cfm?tutorial_id=14' Uwe DC> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

HELP - Logout (sessionDelete, StructClear)?

2003-11-16 Thread Michael Grove
I have written an application that allows a user to log in. When the user logs in I run the following code... I first check to see if the user exisits. If so...       Then I set some session variables               
  self.location ='https://foo';
     return them to the home page

Very vague error message

2003-11-16 Thread Ryan Mitchell
Hello I have a rather large page of code which ive been working on, and I get the following error: This _expression_ must have a constant value. It doesn¹t give me a line number, or a code snippet, just that text. As I said I have a lot of code (1000+ lines) and I cant quite tie down the proble

Re: HTML e-Newsletter

2003-11-16 Thread Ubqtous
Dwayne, On Sunday, November 16, 2003, 9:00:58 AM, you wrote: DC> I'm looking for a tutorial that would explain how to send HTML DC> e-Newsletters. I am particular interesting in finding out how DC> include graphics in the message. Any advice would be useful. All you need to do is code the images

HTML e-Newsletter

2003-11-16 Thread Dwayne Cole
I'm looking for a tutorial that would explain how to send HTML e-Newsletters. I am particular interesting in finding out how include graphics in the message. Any advice would be useful. Dwayne Cole, MS in MIS, MBA Florida A&M University Certified Advanced ColdFusion Developer 850-591-0212

Re: JOIN help

2003-11-16 Thread Jochem van Dieten
Pascal Peters wrote: > SELECT Q.QueueID, XUQ.AccessID, Q.QueueName > FROM Queues Q >    JOIN SecurityXrefUserQueues XUQ > ON XUQ.QueueID = Q.QueueID > WHERE XUQ.UserID = > UNION > SELECT Q.QueueID, NULL AS AccessID, Q.QueueName > FROM Queues Q > WHERE Q.QueueID NOT IN ( >   SELECT XUQ.QueueID

RE: JOIN help

2003-11-16 Thread Pascal Peters
Cedric, I didn't examine the query too well in the first place. The outer join doesn't work because of the filter on the table you want nulls in. I would suggest a UNION instead of an outer join. I'm not sure it's the most efficient solution though. SELECT Q.QueueID, XUQ.AccessID, Q.QueueName