multiple outputs for 1 record.

2000-06-10 Thread Spencer Saunders
Hello all. I have a problem with a query output returning multiple outputs of the same record. I only want the information once but for some reason it seems to be cycling trough it 7 times. Any help would be appreciated. I'm sure it's a simple solution sitting right under my nose. Code as follows.

Re: Professional vs. Enterprise

2000-06-10 Thread Daniel J. Cody
Actually, there are a great many differences between Enterprise and Professional atop clustering.. Enterprise includes native databse drivers for Sybase, Oracle, Informix, and DB2 - whereas Professional only includes less efficient ODBC drivers. Enterprise also has connectivity features for LDAP

CFCONTENT... set the filename?

2000-06-10 Thread Mike Amburn
I know this question has been asked before, but I can't find where I'd saved the answer. I need to push a file to the user via file download. However, I would like to be able to set the filename so that when the user goes to save the file, it's not "processingFile.cfm". ideas? mike ---

Java CFX Setup Help w/ Reload

2000-06-10 Thread Reilly, Jim
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFD186.A6754070 Content-Type: text/plain; charset="iso-8859-1" I am playing w/ Java CFX's and want to modify the coldfusion.cfx

Nesting possible?

2000-06-10 Thread Cyrill Vatomsky
Is it possible to nest tags? Cyrill Vatomsky LinguaCom -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to

Replacing list values from a query?

2000-06-10 Thread Cyrill Vatomsky
Hi, All, One of the fields (property.type)in my query contains a comma-delimited list of numbers (1,3,4) I have a lookup table (types) that consists of two fields: ID and Name. Now, I need to replace numbers in Property.type with names from Type.Name. How could that be done with ColdFusion? --

Sending email from database

2000-06-10 Thread Splash! Designs Ink.
This is a multi-part message in MIME format. --=_NextPart_000_0617_01BFD1F3.970664E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am writing a newsletter to an Access database and in some cases, there will be an attachment. I wo

RE: List

2000-06-10 Thread Aidan Whitehall
> This has been happening for the last few days for me. Something is seriously > wrong. Looking at the mail headers, it appears that some sort of looping > is happening that is causing a reinsertion of previous mails... We had that a while back when a mail server (in Germany, I think) resent ever

RE: Reading in PDF Files

2000-06-10 Thread Philip Arnold - ASP
> How do I read in a PDF file into my browser? > > Let me explain. I have a list of numbers associated with documents in a > database. Each document has four different links associated with it > (Summary of Document, Original Document, Reponses, History). What I want > to do is when a user clicks

CFHTTP doesn't know Client/Session vars exist. Please help.

2000-06-10 Thread Hassan Khawaja
Dear friends, I have a peculiar problem at hand. I tried searching the forums and this news group but couldn't find it discussed. I do apologise if it has been addressed before. I have an app. where when a user logs in, it goes out and fetches user preferences, news, weather etc. Calls to news/we

Re: Newsgroups?

2000-06-10 Thread Larry C. Lyons
Actually Brandon the CF-TALK mailing list is mirrored on the fuseware.com NNTP server. Its much easier to handle than the actual list. larry Brandon Whitaker wrote: > > Newsgroups? > > As in, 'why aren't there any ColdFusion...'? > > There could be a whole Allaire group in the comp.* heirarc

RE: studio errors

2000-06-10 Thread Reagan, Leman
Hello All, I do not have MM Dreamweaver installed on my 2000 (development server using studio) and also get the 'saved but not saved' and the GPF errors. Since Allaire charges per incident and this is obviously a programming error on their part (nothing under my control), I have not pursued the

RE: studio errors

2000-06-10 Thread Reagan, Leman
This is still an issue on my 500MB Ram machine... wow need another 500 I guess. /LEMAN/ [EMAIL PROTECTED] -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 04, 2000 12:16 PM To: [EMAIL PROTECTED] Subject: Re: studio errors I have found this to be the case

Re: Can CF generate a Pop-up Window w/o Javascript?????

2000-06-10 Thread Brett Payne-Rhodes
I was very interested in trying this out, it is something that I have been pondering for quite a while, that is, how to use a pop-up window to select from a set of choices. Unfortunately when I went to the URL and tried it a few times the only thing that appeared in the pop-up window was:

RE: Another question on performance

2000-06-10 Thread Philip Arnold - ASP
> In any case, if you're concerned about performance, there are places that > are far better to examine, such as your database queries. Have you run > SHOWPLAN with them (if you're using SQL Server, for instance)? Are you > testing your stored procedure performance? Are you updating DB statistics?

RE: Remote SQL Server access

2000-06-10 Thread Philip Arnold - ASP
> Has anyone installed the desktop version of SQL Server 7 on a workstation > and dialed into an ISP to connect to a SQL Server. If so, how did you do > that? I am trying to set up a telecommuting situation. I need to > what steps > I must take to get that desktop version to communicate with a s

RE: application.cfm but not for all

2000-06-10 Thread Jann VanOver
I like to use this in a little different form: ... More efficient (List functions are very fast in CF 4) and easier to add more exception pages when you need to. > -Original Message- > From: Adrian Cesana [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 17, 2000 9:35 PM > To: [E

nevermind

2000-06-10 Thread Jonathan R. Karlen
This is a multi-part message in MIME format. --=_NextPart_000_0006_01BFD241.DA154F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by onyx.he.net id PAA11848 Found the Insert and Len func

RE: studio errors

2000-06-10 Thread Philip Arnold - ASP
> Just to join the gripe session :) > > I often get "Out of system resources" type messages when running CFStudio > 4.5.1. Not uncommon, but this workstation has 512 mb of memory. Whenever > it does crash, I check free memory (running MemTurbo), and there's usually > 250 mb or so free. Just to

Re: Has the list gone buggy??

2000-06-10 Thread Jennifer
At 10:04 AM 6/6/00 -0400, you wrote: >erm, > >Am I the only one getting the messages from the last few days delivered >*again*?? Is there some weirdness happening with the list mail server? No, you are not the only one. Remember when we couldn't send mail to the server at all? I suspect that th

test - list operational?

2000-06-10 Thread pan
do dah -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Best Method

2000-06-10 Thread Philip Arnold - ASP
> Specify a maxrows attribute in your CFQUERY call and sort by date > descending: > > > SELECT > FROM .. > WHERE .. > ORDER BY submittedDateTime DESC > Just one word to say to this - YUK! MaxRows trims the output after SQL has done the work - if the table has hundreds of thousands

Re: MONEY PROBLEM IN SQL

2000-06-10 Thread Julia Green
How's this when it's time to format your number, put the maximum number of 9s you think you'll be needing... $ #NumberFormat(myValue, "999,999,999,999,999,999.99") I don't think there's an automatic format for currency like there is for Date but check around there might be. Just reformat your

RE: trapping sql statement

2000-06-10 Thread Philip Arnold - ASP
> Does anybody know a way to trap a sql statement so that it can be > caught in > a try/catch block? > > Is this supposed to be done when you select "show sql and datasource name" > in the debug settings of CF Admin? It's not working for us, we > only get the > datasource name but no sql. A stan

CFFILE Accept

2000-06-10 Thread Double Down, Inc
This is a multi-part message in MIME format. --=_NextPart_000_0008_01BFD160.7CDD3280 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit Trying to set the accept attribute in CFFILE to only accept .jpg and .gif Can someone tell me how to do this. TIA

RE: Professional vs. Enterprise

2000-06-10 Thread Jeff Honken
The Enterprise has direct drivers for Oracle etc. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 07, 2000 11:10 PM To: [EMAIL PROTECTED] Subject: RE: Professional vs. Enterprise No real difference (apart from the price). Enterprise supports clus

ISAPI

2000-06-10 Thread Jake Hileman
Does Cold Fusion run as an ISAPI? Or just as a stand alone web server (CFServer.EXE)? If it runs as an ISAPI... shweee, that would be nice... :-) thanks and let me know, Jake -- Archives: http://www.eGroups.com/li

CF and IIS on Separate Boxes

2000-06-10 Thread Bob Smith
Hi, We wish to install coldfusion and iis server on separate boxes. Can somebody point in the right direction as to how to install it? Thanks, Bob Smith Get free email and a permanent address at http://www.amexmail.com/?A=1 --

What does the term 'session key' mean?

2000-06-10 Thread Hubert Earl
hi. i'm reading about session variables and cookies, and my text says: cfid--the unique client id. part of the session key. what is the "session key"? sincerely, --- Hubert Earl ICQ#: 16199853 I develop & maintain web sites internationally. I also build web applications using ColdFusion, Ja

Easy way to get a random record

2000-06-10 Thread Gary P. McNeel, Jr.
Is there an easy way to pick a random record from a database. I have a unique ID for each record, but it is not strictly sequential because of record deletions. Here is my thought: Run a query and get the MAX and MIN IDs. Do a loop using them as the beginning and ending range and generate a rand