RE: server crashing... Caught a fatal signal - More Info

2002-05-16 Thread Brian Scandale
Deduced that it only happens when the SQL error is in a table in the same PostgreSQL database as the Client Variable Store. When I switch to another PostgreSQL database or use the Registry(Linux), I get normal CF-SQL errors. too weird At 10:51 PM 5/16/02 -0700, you wrote: >Still happening...

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Jon Hall
Using SQL Server maintaining the connection would be advantageous because their wouldn't be the overhead for making a new connection, logging in, etc. In Access I don't think it matters. It is only Access after all. If I get concerned about performance of a site based on Access, I upgrade the

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Keen Haynes
Not having to re-establish the connections repeatedly helps with performance. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:02 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) What's the advantage of locking the server on to the da

CFINTERNALDEBUG

2002-05-16 Thread Boardworks Interactive
Does anyone know what this tag does? I was able to deduce that it had an attribute, "ACTION" which could be either BREAK, LEAK, PCODE, REPORTSTATE, SETBREAKALLOC and WRITEOUTPUT. Each ACTION has its own attributes, but I don't know what each of these actions does - morever what it outputs (as I

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Mike Kear
What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck main

RE: CFEXECUTE

2002-05-16 Thread Boardworks Interactive
Well, you can try ditching the space at the beginning of the arguments. Also, you can write the generated output to a file. HTH. SCOTT VAN VLIET BRD.WRKS INTERACTIVE T: 714.469.6805 E: [EMAIL PROTECTED] -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: T

RE: server crashing... Caught a fatal signal (11) - Aborting

2002-05-16 Thread Brian Scandale
Still happening... the server.log file shows: -- "Fatal","9225","05/16/02","22:42:12",,"Caught a fatal signal (11) - Aborting" "Information","1024","05/16/02","22:42:16",,"The ColdFusion Application Server started." -- any ideas where to look? At 12:54 PM 5/11/02 +0100, you wrot

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Jon Hall
Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen wrote: > I don't know if any of you work with Access much as a database here and there, but I >have been developing using an access d

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Peter Tilbrook
If you are using ColdFusion 5 there is a button in the Administrator (under "Connection Summary") that allows you to "release" all cached data source connections. Very handy. Note however that doing this on a live server (as opposed to a production server) can be problematic. If doing this on a li

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Jeffry Houser
Then use this one: CFUSION_DISABLE_DBCONNECTIONS (DataSource, switch) I think the switch is a Boolean value.. (?) At 03:56 PM 5/17/2002 +1200, you wrote: >Well, SELECTing a row from a non-existent tables's not likely to create >much havoc. Conversely, CFUSION_DBCONNECTIONS_FLUSH() might n

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Paul Giesenhagen
Agreed ... it is funny when I typed in that message earlier today, I laughed and made a comment that it would probably start some kind of 'you can't do that' argument ..:) I guess with anything it is a good practice to code responsibly .. otherwise you may end up in a ditch or in jail... Cheers

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Matthew Walker
Well, SELECTing a row from a non-existent tables's not likely to create much havoc. Conversely, CFUSION_DBCONNECTIONS_FLUSH() might not be polite on a shared host! Regards, Matthew Walker /* Easier, smarter forms: http://www.matthewwalker.net.nz/inform2 */ > -Origin

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Paul Giesenhagen
Are you serious? select whatever from notable How will that affect the data? Paul Giesenhagen QuillDesign > This is considered bad practice, although it does work. Running an > intentionally bad query is not good practice, you never know how it will > affect your data > > There is a C

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Jeffry Houser
This is considered bad practice, although it does work. Running an intentionally bad query is not good practice, you never know how it will affect your data There is a ColdFusion function (undocumented, I believe) called cfusion_dbconnections_flush which will perform the same function. A

RE: Coldfusion /MS Exchange

2002-05-16 Thread Eric Dawson
http://www.innovationplaygrounds.com/test/LDAP_v01_01alpha/www/ let me clean it up a little tomorrow morning - and I will put a download link there. Not much. and there is only maybe 10 people in the exchange server. Eric From: Bryan Love <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF

RE: Inserting into 2 tables with a relationship

2002-05-16 Thread Joe Bastian
Steven, You can use the below query. This only works if TableA has an IDENTITY field. Insert into Table1 values('some','some') SELECT @@Identity as NewID JOe -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 1

Re: SHA-1

2002-05-16 Thread James Sleeman
> We have a requirement to use SHA-1 encryption to store certain values > within a MS SQL7 database. Does anyone know of a custom tag or any other > encryption tool that utilizes SHA-1? Just a note, I'm sure you know, but others might not. SHA-1 is not an encryption method, it's a one-way hash,

RE: Problem with cfhttp

2002-05-16 Thread Ben Densmore
Thanks Dave, I thought maybe I was missing something. Glad to see someone could reproduce the problem. Can Christine or anyone else at MM that watches this list give us some ideas as to why this is happening? Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thur

EVENT: CFUN-02 detailed schedule, hotel discount code until 5/24

2002-05-16 Thread Michael Smith
Come to the CFUN-02 2 day ColdFusion conference in Washington DC June 15th-16th http://www.cfconf.org/cfun-02/. Here is a detailed schedule of the talks and the hotel room discount code. The hotel discount expires May 24th, so be quick to get a room to save money! PS If you know any of your CF f

[admin] Off Line

2002-05-16 Thread Michael Dinowitz
I'll be offline until Saturday night. I have people with the various codes needed to remove autopost people and to reboot the lists/machine as needed. These should not be necessary, but I like to be prepared. Enjoy all. Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusion

RE: CF Scheduling again

2002-05-16 Thread Donnie Bachan
Glad to help! :-) Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" == The information transmitted is intended only for the person or entity to which it is addressed and may conta

Re: How to detect timeout session??

2002-05-16 Thread Mario Martinez
Thank you for all your concern Thank you Sharon specially . I finish to polish the suggestions with this last mail regards Mario - Original Message - From: "Sharon Diorio" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:56 PM Subject: Re: How to detect

RE: Problem with cfhttp

2002-05-16 Thread Dave Watts
> I was wondering if anyone has experienced this problem > with cfhttp in CFMX? I haven't tried it in CF5 so not > sure if it's happening there too, but I am using cfhttp > to get the xml feed off of MM's site. I run the page that > grabs the xml file to get it to my local machine but for > s

RE: CF Scheduling again

2002-05-16 Thread Eric J Hoffman
Perfect! Cfexec95.exe did the exact trick. Thanks a million. Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Donnie Bachan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 5:15 PM To: CF-T

RE: CFEXECUTE

2002-05-16 Thread Bryan Love
I've never been able to get CFEXECUTE to work when using arguments +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +

Re: CF Scheduling again

2002-05-16 Thread Donnie Bachan
I have never installed on Win95 but I know on Win98 the CFEXEC would not start up by default, this is what manages the schedules for CF4.5, you need to ensure that the program is running before scheduling will take place. It is located in the same place as the CF Server and RDS engines (CFUSION

RE: CF Tag Poster

2002-05-16 Thread Eric J Hoffman
Thanks! -Original Message- From: Neil Giarratana [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 4:34 PM To: CF-Talk Subject: RE: CF Tag Poster Michael Smith from TeraTech puts one out. I think it www.teratech.com Regards, Neil -Original Message- From: Eric J Hoffman

RE: CF Tag Poster

2002-05-16 Thread Neil Giarratana
Michael Smith from TeraTech puts one out. I think it www.teratech.com Regards, Neil -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 5:31 PM To: CF-Talk Subject: CF Tag Poster I had at one time had or seen a CF Tag Reference poster...anyo

CF Tag Poster

2002-05-16 Thread Eric J Hoffman
I had at one time had or seen a CF Tag Reference poster...anyone know where to get one? We have a newer developer and I'd like to give him it for reference. *evil laugh The spread of Cold Fusion continues! Bwahhahahaha* Thanks for any pointers. Regards, Eric J. Hoffman Director of Internet De

CFEXECUTE

2002-05-16 Thread Ray Bujarski
I am using the cfexecute to execute a local file on the server Executing... Problem is it just decided to quit with any output! I tried it from a prompt and everything works fine, it executes and shows me everything I don't see when trying with cfexecute.

Re: Running a query in javascript

2002-05-16 Thread Jon Hall
This is my preferred way, it can be made cross browser by using ilayers in NS4. Don't use the gif thing, it's very limited. However I think their article does link to a site that shows how to do it with ilayers/iframes. jon - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To:

RE: CFLDAP Problem

2002-05-16 Thread Kevin Cundick
I'm not sure if anyone is watching this, but the problem seems to be related to the number of rows being returned. If I limit the number of rows by using Maxrows="200" it returns that many records. Does anyone know if CFLDAP is knowing limited to the number of rows it can return? Thanks, Kevin

RE: Inserting into 2 tables with a relationship

2002-05-16 Thread Costas Piliotis
Why would you avoid that out of curiosity? Auto incrementing new fields pretty well guarantees that you won't accidentally cause a duplicate. It's quite the standard practice out there from what I understand... Honestly, you should really be using GUID anyways for most new databases anyways,

CF Scheduling again

2002-05-16 Thread Eric J Hoffman
We had an extra 4.5 license and made a monitoring machine for all of our clients,etc using SitePeeker. This is sitting on a real old P200 Win95 machine...and SitePeeker utilizes CFScheduler to monitor at intervals...yet it never seems to fire off at the intervals named. Does this service require

Re: WAY OT DTS PACKAGE

2002-05-16 Thread Jon Hall
>From within the DTS Designer choose the Execute Process Task, and run an unzip program on your zip. jon - Original Message - From: "Joshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 10:18 AM Subject: WAY OT DTS PACKAGE > Does anyone know

RE: Need some help setting standards.

2002-05-16 Thread Phillip Broussard
Thanks. That is just what I was looking for. Phillip Broussard Tracker Marine Group 417-873-5957 > -Original Message- > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 16, 2002 3:02 PM > To: CF-Talk > Subject: RE: Need some help setting standards. > > I wrote this

RE: SHA-1

2002-05-16 Thread Jeff Brown
CF_SHA_1 in the DevEx... -Original Message- From: Robert Weimer [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 4:21 PM To: CF-Talk Subject: SHA-1 We have a requirement to use SHA-1 encryption to store certain values within a MS SQL7 database. Does anyone know of a custom tag

SHA-1

2002-05-16 Thread Robert Weimer
We have a requirement to use SHA-1 encryption to store certain values within a MS SQL7 database. Does anyone know of a custom tag or any other encryption tool that utilizes SHA-1? Thanks, Robert Robert Weimer Director of Application Development StoneGround 5100 West Kennedy Blvd, Suite 430

RE: Running a query in javascript

2002-05-16 Thread Bruce, Rodney S HQISEC/SIGNAL
Nate I watched the viewlet and this looks great. I will defenetly download v1.0 and give you feed back. If I can get it to work this looks like it could realy make a hugh difference in designing many of the pages I need to do. Thanks for the information Rodney -Or

RE: Dynamically Selecting Option with CFSELECT

2002-05-16 Thread Bryan Love
Syntax +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be i

Dynamically Selecting Option with CFSELECT

2002-05-16 Thread Smith, Daron [PA]
Is there a way to select dynamically an option with cfselect? I know how to do it with a regular select, but I wanted the functionality of cfselect but need to specify an option as selected based upon a query value. Is this possible? Thanks, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED]

RE: Yo Macromedia: CFMX and UUID Issue!

2002-05-16 Thread Neil Clark - =TMM=
>It doesn't make any sense to say "JDBC is faster than ODBC". There are fast >and slow JDBC clients, and fast and slow ODBC clients. I doubt that using >the best Type 4 JDBC client against MS SQL Server will be as fast as using >the standard ODBC client for it. Agreed, I have seen stuff around th

RE: Need some help setting standards.

2002-05-16 Thread Duane Boudreau
I wrote this at the last place I worked. Use what you want if it applies (some of it is dated and hasn't been updated for a while) http://www.cfexperts.com/documents/codingstandards.doc -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 3:5

OT or not OT: Voxeo and ColdFusion

2002-05-16 Thread Erika L Walker-Arnold
Anybody here do anything with Voxeo and ColdFusion? If so, are there any pitfalls to avoid? Words of warning? Some, "oh yeah and if you try this it won't work."'s? Thanks in advance Going through the developer's stuff on the site and it's pretty straightforward, I'm just doing some resear

Problem with cfhttp

2002-05-16 Thread Ben Densmore
Hi all, I was wondering if anyone has experienced this problem with cfhttp in CFMX? I haven’t tried it in CF5 so not sure if it’s happening there too, but I am using cfhttp to get the xml feed off of MM’s site. I run the page that grabs the xml file to get it to my local machine but for some reas

Re: Coldfusion /MS Exchange

2002-05-16 Thread Donnie Bachan
It depends on what version of Exchange you are using, if you are using 5.5 then you can use the methods given at cfcomet.com but Exchange 2K is a bit different you can use COM to access the Exchange server, check out the MSDN for more information, the examples are given in VB but you can map th

Need some help setting standards.

2002-05-16 Thread Phillip Broussard
We want to set some standards and guidelines for our contract help to use. I have always wanted to do this but have never had a chance until now. Does any one have something I could look at as an example? The ultimate goal is to be able to tell a contractor that this is what we want and this is h

RE: Coldfusion /MS Exchange

2002-05-16 Thread Rick Eidson
Well checkout the Outlook Web Client it is wrote in ASP and you can access the files. You maybe able to make a CF version from that. Rick -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 2:43 PM To: CF-Talk Subject: RE: Coldfusion /MS Exchange

Re: Running a query in javascript

2002-05-16 Thread Nate Nielsen
oh - btw - Here is a little viewlet movie tutorial of how to do this dynamic client-server communication with basicly 4 CF tag calls to the activeServer component. http://www.fusionscript.com/viewlets/as_zipcode/as_zipcode_viewlet.html =) Nate Nielsen FusionScript DevTeam [EMAIL PROTECTED] D

RE: Coldfusion /MS Exchange

2002-05-16 Thread Bryan Love
I'd love to see that too, if you don't mind :) +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ "...'I

RE: Running a query in javascript

2002-05-16 Thread Bryan Love
I think related selects are the best approach. I haven't used the custom tags you mentioned, but I've written my own JS to do the same thing many times. Some general things to keep in mind: - page size: if you have 10 options in box 1 and each one has 10 options in box 2 and each of those has 1

Re: Running a query in javascript

2002-05-16 Thread Nate Nielsen
Bruce, I have started the development of a new technology called FusionScript. With the v1.0 beta release it allows you to exactly what you are wanting. Make a dynamic call to the server, run CF code, return results - all without a page reload. It's open source, free and has a community establis

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Eric Dawson
I should read the rest of the responses first but. But another trick is to set your datasource to one MDB which links to the MDB database which will be uploaded on occasion. Eric From: "Paul Giesenhagen" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject:

RE: Subquery from the same table: Is it possible??

2002-05-16 Thread James Taavon
ok, Matt. Thanks. I will get back to you on this. Thanks for your assistance. -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 3:32 PM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? If I have this correct, then th

Re: Coldfusion /MS Exchange

2002-05-16 Thread Eric Dawson
I did do a phonelist app using LDAP to connect to exchange. If I get some time I'll get my head around the code and post it for you. I only did contacts, but I'll play around a little. Eric From: "Chris Bohill" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Su

RE: Subquery from the same table: Is it possible??

2002-05-16 Thread Matthew R. Small
If I have this correct, then the below query should work. I inserted the data that I made up into a table and I executed the following query on it - no problems. You may need to inspect your table for duplicates if you are getting more than one return. Or, it is possible for more than one insta

RE: Running a query in javascript

2002-05-16 Thread Shawn Grover
Others have suggested to use the Gif datapipe, but there is another option. You can create an IFrame (be aware of browser issues of course) with hight and width set to zero. Then use JS to set the location of the IFrame to a page that does your required queries. This page can then set values on

RE: Running a query in javascript

2002-05-16 Thread Ben Johnson
> You can't really do this with just JavaScript and CF, within a single page, > without using some "tricks". You'll need to send data back to the server, > and then receive data back from the server. You can do this with a hidden > frame, or a "GIF pipe" as described at > http://www.depressedpress

Re: Inserting into 2 tables with a relationship

2002-05-16 Thread Brian Scandale
I suggest using the custom tag... Max_ID from the Macromedia Custom Tag library. It is well documented. Then search the archives for discussions on use of the tag. I use this exclusively now and avoid AutoIncrementing primary key fields like the plague. hth Brian At 10:49 AM 5/16/02 -0500, y

CFLDAP Problem

2002-05-16 Thread Kevin Cundick
I have a LDAP database setup to authorize the login of Vendor's to a web application we have setup. To manage the Vendor's that have been setup in LDAP we have an administration screen. When we list the Vendors we have two ways to list them, by Company Name and by Vendor ID. Sorting by Company

RE: Anybody have a nice CFERROR page for me?

2002-05-16 Thread jon
sure -- just put this into your error page: -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Jon Block [mailto:[EMAIL PROTECTED]]

RE: Running a query in javascript

2002-05-16 Thread Dave Watts
> I am trying to run a query inside of a javascript function. > Unless there is another way of doing this. > > Without reloading/submitting the form I need to run a query > based on user selected options Pass these options to the > query and then place the results in a select box. > > Somethin

RE: Inserting into 2 tables with a relationship

2002-05-16 Thread Kevin Schmidt
If you are using SQL server and are within a transaction you can use SELECT @@identity AS newid FROM table It holds the value of the last id inserted in the table for that transaction Kevin -Original Message- From: Donnie Bachan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002

RE: Running a query in javascript

2002-05-16 Thread Matthew R. Small
OK, you're going about this all wrong... you can't execute a query in javascript. Your data needs to be processed by the server. Use the two_selects_related or three_selects_related custom tag. If these aren't any good for you then I suggest you look into the gif data pipes. http://www.depres

RE: Inserting into 2 tables with a relationship

2002-05-16 Thread Donnie Bachan
Okay let's say that you are incrementing the primary key in the first table upon an insert, and then you want to insert the value of that key into the second table as var_id, what you have to do is after you did the first insert, you need to select max(variable) as new_var_id from table1 This

RE: Subquery from the same table: Is it possible??

2002-05-16 Thread James Taavon
CORRECT!! -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 2:24 PM To: CF-Talk Subject: RE: Subquery from the same table: Is it possible?? I am very confused now as to what you are trying to accomplish. Maybe you could show a little more

RE: Running a query in javascript

2002-05-16 Thread Eric J Hoffman
Try activeSelect I think its called from cfdev.com Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Bruce, Rodney S HQISEC/SIGNAL [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 1:51 PM To:

Running a query in javascript

2002-05-16 Thread Bruce, Rodney S HQISEC/SIGNAL
Hello all I am trying to run a query inside of a javascript function. Unless there is another way of doing this. Without reloading/submitting the form I need to run a query based on user selected options Pass these options to the query and then place the results in a select box. Something like

RE: dynamic select boxes in netscape don't work

2002-05-16 Thread Donnie Bachan
Your problem is that you have to remove the items in the second select list first then add new items with the correct values. The person that said the options object is read only is correct, I misunderstood what they meant, in Netscape you cannot overwrite the values, you have to remove the opt

RE: Looping Over Variables Scope

2002-05-16 Thread Shawn Grover
Ya keep doing that Dave shooting holes in my comments... :D Oh well, I'd rather be told I'm wrong than continue with faulty info. Thanks I think... LOL Shawn Grover -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:34 PM To: CF-Talk

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Eric J Hoffman
Doesn't that flush every datasource on a server, thus a BIG no-no in a shared hosting environment?? Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent:

RE: Looping Over Variables Scope

2002-05-16 Thread Dave Watts
> Variables is NOT a scope (in CF5 or lower - to the best > of my knowledge). It is more of a naming convention. I > think it has become a scope in MX though. > > However, a Variables Structure might be created, if so, > then yes, you can use CFLOOP to loop over the collection. This is incorr

RE: Subquery from the same table: Is it possible??

2002-05-16 Thread Matthew R. Small
I am very confused now as to what you are trying to accomplish. Maybe you could show a little more of your database. As I understand it, you have about six managers each with a key user. You have a number of employees whom each fall under a manager. When an employee responds to a form, the empl

RE: dynamic select boxes in netscape don't work

2002-05-16 Thread Steven A. del Sol
Take a look at www.bobdaviscamera.com let me know if this is what you need and I will send you the code off list... >-Original Message- >From: Donnie Bachan [mailto:[EMAIL PROTECTED]] >Sent: Thursday, May 16, 2002 11:47 AM >To: CF-Talk >Subject: Re: dynamic select boxes in netscap

RE: Looping Over Variables Scope

2002-05-16 Thread Shawn Grover
Variables is NOT a scope (in CF5 or lower - to the best of my knowledge). It is more of a naming convention. I think it has become a scope in MX though. However, a Variables Structure might be created, if so, then yes, you can use CFLOOP to loop over the collection. Shawn Grover -Original

Re: How to detect timeout session??

2002-05-16 Thread Sharon Diorio
In the application.cfm: On the login page, you'd set the session variable "loggedIn" to equal 1. This catches people who've timed out as well as people who've not logged in yet. Sharon DiOrio - Original Message - From: "Mario Martinez" <[EMAIL PROTECTED]> To

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Sharon Diorio
Or you could just run the undocumented function to release it: CFUSION_DBCONNECTIONS_flush() :-) Sharon DiOrio - Original Message - From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 12:32 PM Subject: A Tip (maybe new, maybe not)

Looping Over Variables Scope

2002-05-16 Thread Van Vliet, Scott
Is it possible to loop over the Variables scope? #ind#: #Variables[ind]# ??? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED] "Hello Stupid, and welcome to your crappy computer." - Str

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Sam Roach
What usually I do is upload the database to a new name and change the ODBC connection to point to the new file. -- Sam -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:25 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Eve

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Andy Ousterhout
You can always upload to a second DB, then switch your app to the new DB. This will enable you to unwind if necessary and will diminish you site down-time. Andy -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:42 PM To: CF-Talk Subject: RE

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Joshua Tipton
Might be dangerous Question Is there any way to disconnect from a database programmatically? Answer This is possible, but not recommended, especially if it is a multi-user database. To do so, however, clear the cached connection information with the following code: This code flushes all conne

Next Page / Last Page" with CFoutput group="

2002-05-16 Thread Carlisle, Eric
I'm using cfoutput group="column" to show grouped output like this Group Item Item Item Group Item Item Item I'm trying to show 10 items per page. Using group="column" like this..

WOT: Query for Web Domains

2002-05-16 Thread Rosa, Issac
This is way OT, but maybe someone knows how to do this. Is there any way to query WHOIS or someother database to get a listing of domain names that have the word TRACK in the domain name? Thanks, Issac __ Get the mailserver th

Re: A Tip (maybe new, maybe not)

2002-05-16 Thread Paul Giesenhagen
Even slicker thanks! Paul Giesenhagen QuillDesign > There is an undocumented CF Function that will do the same thing. > > CFUSION_DBCONNECTIONS_FLUSH() > > I used to use the bogus query to do this as well until I found out about > this function. > > Cheers! > > -- > Scott Van Vliet > Sempr

RE: How big a file can CFFILE work with

2002-05-16 Thread Shawn Grover
Processing time depends on the server configuration. There is a setting in the CF Administrator for how much time can pass before a page is deemed unresponsive. However, I have yet to run into this, even with upload 25 Meg + files (I know, slightly different issue...). And I've heard from other

RE: Inserting into 2 tables with a relationship

2002-05-16 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
The problem I am having is that it adds the variable to the field, but it won't update the var_id that has the relationship with the main table it adds a "0" in the field.. Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -Original Message- From: Do

RE: A Tip (maybe new, maybe not)

2002-05-16 Thread Van Vliet, Scott
There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 E

RE: How to detect timeout session??

2002-05-16 Thread Tony_Petruzzi
put this in your application.cfm. make sure to client variables enabled. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:23 PM To: CF-Talk Subje

RE: OT : js submit into new window...

2002-05-16 Thread Shawn Regan
you could always just use the attribute target="_blank" inyour form tag. That is if your not trying to control the type of new window, size and tec.. -Shawn Regan -Original Message- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:45 AM To: CF-Talk Subject

RE: OT : js submit into new window...

2002-05-16 Thread David DiPietro
function PopUpWindow(TargetURL, WindowName, wWidth, wHeight) { var newPop = window.open(TargetURL, WindowName, width='+wWidth+', height='+wHeight+', menubar, scrollbars, resizable, status, toolbar, location'); } *Pictures of this rotation. David DiPietro Systems Developer / Engineer OS

RE: What do you use to send out HTML NEWSLETTERS from your site

2002-05-16 Thread Jon Block
You want to use gammadyne mailer. It is the hands down best mail software I've ever used. The author wants a miniscule $100 for the license, and you'll get to send out TONS of email based on addresses in your database. It does all kinds of stuff. Really awesome software! A+++ Beats anything I've s

RE: Recommend a replacement for CFMAIL

2002-05-16 Thread Jon Block
http://www.gammadyne.com/mmail.htm Gammadyne mailer is the most awesome mail utility i've ever used. Amazingly the guy only wants about $100. Cheers, Jon -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:19 AM To: CF-Talk Subject: Recommend a

RE: GetTickCount()

2002-05-16 Thread Dave Watts
> It must be able to tell values in "increments" of less then > 10 - otherwise I would never see 35 or 16 or 18 mils. I would > only see 30, 20 or 10 right? Isn't it just for processes > that tick below 10 mils (like a query that runs for 8 mils) > that it has a problem? I see variance i

Anybody have a nice CFERROR page for me?

2002-05-16 Thread Jon Block
Anybody have a really nice CFERROR page that mails the site administrator all of the error information plus a listing of the variables and database queries etc? Thanks... __ Get the mailserver that powers this list at http://www

RE: [SOT] CF on OS X... just venting

2002-05-16 Thread Tony Schreiber
> > Wow, those look freaking amazing. > > Just wait until they start making them in five different fluorescent colors > like their iMacs. But I love the brushed aluminum look, very nice. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED]

RE: Trouble with Access and Single Numbers

2002-05-16 Thread douglas . kronenberger
It's set to auto. After hours of stumbling around try'n sql functions and CF formatting I finally tried the left function in the SELECT statement. SELECT CourseName, CourseDate, LEFT(CourseHours, 6) As CourseHours FROM Course WHERE Course.CourseID = #URL.CourseID# For what ever reason this w

RE: OT : js submit into new window...

2002-05-16 Thread Van Vliet, Scott
This works in IE, but I haven't tested it in NN. Untitled http://www.site.com/action.cfm"; target="WinName"> Enjoy! -- Scott Van Vliet Sempra Energy 555 W. 5th

Is there any way to "touch" a file and update its dateLastModifie d?

2002-05-16 Thread Margaret Fisk
Is there any way to "touch" a file and update its dateLastModified? I'm trying to archive files after 5 days that are moved over to the CF server for download but they are retaining their dateLastModified from their original location. I've checked the file properties in the OS and the date create

RE: dynamic select boxes in netscape don't work

2002-05-16 Thread Tony_Petruzzi
function ChangeSubCategories(obj){ if(obj.value == "#GetCategories.FK_tblCategories#"){

OT : js submit into new window...

2002-05-16 Thread Tyler Silcox
Is there a way to submit a form into a new window, on somebody else's server, and control it's properties (size, status bars, etc)? Right now, I'm using the target attribute in the form tag, but I'd like to have more control over the the window...TIA-> Tyler Silcox email | [EMAIL PROTECTED]

  1   2   >