RE: Nested Loops Over Queries

2002-01-21 Thread Pascal Peters
It is still this way. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: maandag 21 januari 2002 3:25 To: CF-Talk Subject: Re: Nested Loops Over Queries No, more like this: cfquery name=a datasource=#dsn# SELECT * FROM table1 WHERE ... /cfquery cfloop query=a

cgi session var - Cf session var

2002-01-21 Thread loic jegouzo
I 've post this question last week but i had no response . i would like to know how to get the value of a sesion that was created in cgi. thank's to Joel Parramore i know how to pass cf session values to cgi script using cfhttp, but i need to read the cgi response session variables with

RE: Retrieving most recent record from db

2002-01-21 Thread Steve Oliver
I believe the first example would be less of a load on the DB and CF. The first example tells the database using SQL to only return the top 1 row. The second example tells the database to SELECT ALL rows, then CF only outputs 1. Both will return the same results though.

OT: looking for Human Resource (HR 24) app by Manish Gupta

2002-01-21 Thread Dave Wilson
Hi all, Sorry for this kind of OT posting. I've been looking to get hold of a copy of the above application which was created by Manish Gupta and is listed in the developer's exchange, unfortunately with dead links. It's a rather old applicaton, last modified in June 1999 according to the dev

Receive CFQUERY results in dollar format

2002-01-21 Thread Kent A. Orso
I'm trying to write a CFQUERY statement that will take data from a Microsoft Access 2000 database and return the numeric value as dollar value. I have tried using DOLLARFORMAT in the CFOUTPUT statement but I have six different pricing columns based on the product size and the empty columns/rows

Re: Receive CFQUERY results in dollar format

2002-01-21 Thread Julia Green
A good way of doing this is formatting the output AFTER it has left the Access table in CFOUTPUT.Just look up format and CFSET. This is what I did for a project, but I used percentages, but you can see how I set a large unformatted number in Access to a percentage. CFSET SEARCH =

RE: Receive CFQUERY results in dollar format

2002-01-21 Thread Steve Oliver
I'm assuming you want nothing returned then if the value is 0? Why not just use a cfif? cfoutput query=cat cfif cat.price_a1 GT 0 #DollarFormat(cat.PRICE_A1)# /cfif cfif cat.price_a2 GT 0 #DollarFormat(cat.PRICE_A2)# /cfif /cfoutput __ steve oliver cresco technologies,

Session variables

2002-01-21 Thread Waldemiro Junior
Hello again folks.. Something weird is happening and I don´t know how to solve it, or maybe I´m doing something wrong... I believe that when I close my browser all those session variables must be killed, but when I open another browser window (it´s not a new window function) the values of

RE: Session variables

2002-01-21 Thread Steve Oliver
This is because sessions are tracked by cookies. If you want the session variables to be killed upon closing your browser window then set the cookies for them. If you put No expiration date, then the cookie will be a session cookie, and will expire when the browser is closed :) cfcookie

RE: Session variables

2002-01-21 Thread Declan Maher
Coldfusion is not like ASP in that session variables are not killed when the browser is closed. YOu can also kill session vars by creating a page with this code and opening it in your browser. cfscript StructClear(session); /cfscript cfscript StructClear(application); /cfscript

RE: looking for Human Resource (HR 24) app by Manish Gupta

2002-01-21 Thread Steve Oliver
I tracked the guy down, it seems he now only does Java apps. Here is his current URL, the email address is the same as from the HR 24 example on the dev exchange, so you should be able to contact him that way. http://industry.java.sun.com/solutions/services/by_service/0,2347,1025-1 ,00.html

RE: looking for Human Resource (HR 24) app by Manish Gupta

2002-01-21 Thread Dave Wilson
Thanks Steve, I've already tried emailing him, so fingers crossed. Dave -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 12:51 To: CF-Talk Subject: RE: looking for Human Resource (HR 24) app by Manish Gupta I tracked the guy down, it seems he now

Query error in aggregate function

2002-01-21 Thread Mark Leder
I want to run a query (using Access) which will return the most recent record ID # (t_mess) and one other column (t_subcat_ID). When I run it without the t_subcat_ID field, it runs great, bringing me the most recent record. When I add t_subcat_ID, I receive the following error:

RE: Query error in aggregate function

2002-01-21 Thread Jeff Beer
Just add t_subcat_id to a GROUP BY statement: CFQUERY NAME=q_mostrecent DATASOURCE=uspc SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID FROM t_msg GROUP BY t_mess, t_subcat_id /CFQUERY -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002

RE: Query error in aggregate function

2002-01-21 Thread Steve Oliver
You could either use the GROUP BY statement: SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID FROM t_msg GROUP BY t_mess, t_subcat_id or do a subquery: SELECT t_subcat_ID, (SELECT MAX(t_mess) FROM t_msg) AS RECHIGH FROM t_msg __ steve oliver cresco technologies, inc.

NTFS File Settings - advice required

2002-01-21 Thread Nick Betts
I have CF5.0 installed and running on one of my web servers. I was trying to secure my site through IIS and NTFS. However, coldfusion seems to ignore the account set in IIS for anonymous web browsing and only works using the everyone group. Is this normal? surely it can be changed somewhere to

RE: NTFS File Settings - advice required

2002-01-21 Thread Steve Oliver
If you just want to secure a web folder in the IIS manager snap-in, just right click on the folder name that you want secured, and select properties, then go into the Directory Security and turn off anonymous access. Make sure you select Basic Authentication to allow users to login through a web

RE: NTFS File Settings - advice required

2002-01-21 Thread Nick Betts
Thanks Steve. Problem is we need anonymous access as we do not want people to login to these sites. Nick -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 14:24 To: CF-Talk Subject: RE: NTFS File Settings - advice required If you just want to

RE: NTFS File Settings - advice required

2002-01-21 Thread Steve Oliver
Oh ok, I see what you mean, Did you check to make sure that the Anonymous user name in IIS's security settings matches that of the user your trying to allow access to in the security settings of your folder? It should be something like IUSR_ComputerName, you should allow that user everything but

RE: NTFS File Settings - advice required

2002-01-21 Thread Nick Betts
Steve, Yes I have done that but CF seems to ignore it. Thanks for your help anyway! Nick -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 14:41 To: CF-Talk Subject: RE: NTFS File Settings - advice required Oh ok, I see what you mean, Did you check

RE: NTFS File Settings - advice required

2002-01-21 Thread Pascal Peters
CF can be set up to run as any user you want to. Go into your services, right-click on the CF Application Service and select properties. Click the Log on tab and check this account. Then browse for the account you want CF to Use. Make sure the account has all the proper rights. There is a KB

RE: Query error in aggregate function

2002-01-21 Thread Mark Leder
I still have been unable to get this to work, using either method. The Group by brings me the highest number of t_subcat_ID (potential values of 1 thru 9), rather than the t_mess highest value (currently 86). The value of t_subcat_ID is not from the same record as the t_mess highest value. The

Problems with looping

2002-01-21 Thread Angel Stewart
Hey all! Take a look at this code. The idea of course, is to loop through all the employees in the table and run a particular query against each employee. ___ CFQUERY name=GetEmployees datasource=x DBTYPE=ORacle80 Select

RE: NTFS File Settings - advice required

2002-01-21 Thread Nick Betts
Cheers pascal! -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 14:51 To: CF-Talk Subject: RE: NTFS File Settings - advice required CF can be set up to run as any user you want to. Go into your services, right-click on the CF Application Service

RE: Problems with looping

2002-01-21 Thread Kevin Bridges
Does: CFLOOP CONDITION=#CurrentDate# LESS THAN OR EQUAL TO #EndDate# Evaluate to true for each employee? ::: -Original Message- ::: From: Angel Stewart [mailto:[EMAIL PROTECTED]] ::: Sent: Monday, January 21, 2002 8:02 AM ::: To: CF-Talk ::: Subject: Problems with looping ::: ::: :::

RE: Problems with looping

2002-01-21 Thread Mike Connolly
Try adding CFSET CurrentEmpID = getEmployees.Employee_ID before the second CFQUERY and use this variable in your 2nd query. See Below. CFQUERY name=GetEmployees datasource=x DBTYPE=ORacle80 Select Employee_ID

RE: Problems with looping

2002-01-21 Thread Kevin Bridges
Looks like you are not reseting the value of CurrentDate. So it loops through first time until Current Date is not less than or eq to EndDate .. then when next employee comes up CurrentDate has not been reset so the condition is false and the loop never runs. Try something like this on the

Re: Retrieving most recent record from db

2002-01-21 Thread Tyler Silcox
The Top function would work if you want to grab the highest numbered identity field in your table (you could also use the SQL function getMax(ColumnName)), but I think you are probably trying to grab the auto-incrementing ID of a recently inserted record? If so, you'll probably want to use

RE: Query error in aggregate function

2002-01-21 Thread Pascal Peters
SELECT t_mess, t_subcat_ID FROM t_msg WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg) -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: maandag 21 januari 2002 15:56 To: CF-Talk Subject: RE: Query error in aggregate function I still have been unable to get this to

RE: NTFS File Settings - advice required

2002-01-21 Thread Mark A. Kruger - CFG
Nick, You have CF running as a local system account - and as such it must have everyone access to access the files. Put CF on a local or domain account and give that user permission to the files in question. Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent:

RE: Problems with looping

2002-01-21 Thread Pascal Peters
This is because you always access the first record from the outer loop in the inner loop. Solution in your code below! -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: maandag 21 januari 2002 16:02 To: CF-Talk Subject: Problems with looping Hey all! Take a look

OT: CSS

2002-01-21 Thread Steven Dworman
I've been reading through css resources, but I can't seem to find much on altering the properties of a select box. Changing the font, width, height, blah blah is no problem. This issue is changing the scroll bar properties such as color, and border properties so that I can remove the 3d effect.

RE: cfhttp to retrieve cookies from a different server

2002-01-21 Thread Martin P. Cadirola
Never mind! I got it working. Your tip was great. Martin __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup

Re: Trouble installing CF Express

2002-01-21 Thread Billy Cravens
Note that the downloadable version of CF5 has a developer's liscense available (connections from one IP address), so that you can explore the full feature-set of CF (CFExpress is feature limited, missing things like CFFile) Of course, this may not be the issue at all. Do ASP pages work in PWS?

Re: CSS

2002-01-21 Thread Douglas Brown
There should be a area in your css like so. body{ scrollbar-face-color: #CC; scrollbar-shadow-color: #00; scrollbar-highlight-color: #FF; scrollbar-3dlight-color: #CC; scrollbar-darkshadow-color: #00; scrollbar-track-color: #ADAED6; scrollbar-arrow-color: #FF;

RE: CSS

2002-01-21 Thread Craig Dudley
As far as I know, you can only do it in IE 5.5 and later on a PC but have a play with these... scrollbar-3d-light-color : White; scrollbar-arrow-color : White; scrollbar-base-color : White; scrollbar-dark-shadow-color : White; scrollbar-face-color : White; scrollbar-highlight-color : White;

RE: CSS

2002-01-21 Thread Kola Oyedeji
IF its any help I believe this ie specific only, try somewhere on the microsoft site. Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]]

RE: Problems with looping

2002-01-21 Thread Carlisle, Eric
I'm no SQL guru, but seems like you could do another table join and sweep all this information in one query. The condition for which you are looping over could probably be made into part of the main WHERE clause. That would make the code cleaner and much faster. That's my take on it ;)

Re: CSS

2002-01-21 Thread Billy Cravens
I don't think this will work very well. I know you can change some of the information in IE, but it won't be cross-browser. If you really need that look, I'd replicate a drop down using DHTML. (go to www.mr-bill.net/archives.cfm for something I've done - I know it only works in IE now, but it

RE: Query error in aggregate function

2002-01-21 Thread Mark Leder
That worked - thanks. Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 10:12 AM To: CF-Talk Subject: RE: Query error in aggregate function SELECT t_mess, t_subcat_ID FROM t_msg WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg)

RE: CSS

2002-01-21 Thread Steven Dworman
I know about the scrollbar properties for the browser. What I'm trying to alter are the properties for a select box. -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 10:56 AM To: CF-Talk Subject: Re: CSS There should be a area in your css

RE: CSS

2002-01-21 Thread Craig Dudley
Steven, if you use that on the body, it will 'cascade' down to select boxes, or should anyway. -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 21 January 2002 16:11 To: CF-Talk Subject: RE: CSS I know about the scrollbar properties for the browser. What I'm

Re: CSS

2002-01-21 Thread Bryan Stevenson
and just in casethis stuff only works in IE ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com -

Re: CSS

2002-01-21 Thread Tyler Silcox
I've searched for many a moon and as far as I know, you can't alter the border attributes or 3D properties on a select box. It doesn't make any sense, because just about all the other form elements accept these attributes. And the body properties won't cascade to select boxes, only textareas.

Manual statistics/ Hits counter at DB?

2002-01-21 Thread JAAV
Hello, Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time

Re: CSS

2002-01-21 Thread corrigan
Here's a link that defines the different properties. The stuff you want is in the box properties section. It's best to play around with it to get it working right. http://www.pageresource.com/dhtml/cssprops.htm Michael Corrigan Programmer Endora Digital Solutions 1900 S. Highland Avenue,

Re: tag for sweeping HTML code, making safe, XHTML-compliant, etc.

2002-01-21 Thread Gyrus
On the acs_stripTags.cfm, you could make that quicker using one regex. The only thing is that my longer version was designed to catch 'orphaned' opening and closing tags as well. I thought of maybe putting in a couple of extra regexes to catch these, or maybe just using your regex for speed,

Structures vs. 'flat' variables

2002-01-21 Thread Gyrus
In setting global variables in Application.cfm, how would this: request.DB = StructNew(); request.DB.DSN = datasource; request.DB.type = ODBC; request.DB.username = admin; request.DB.password = password; compare to this: request.DB-DSN = datasource; request.DB-type = ODBC; request.DB-username

NT login

2002-01-21 Thread Kris Pilles
I need to know how I can pop up the windows login and use that info to verify my usernames and passwords. Note: I do not want to use the NT login ids, I just want to use the windows login as my login form to my members area. Anyone know how I can achieve this?? Thanks KP

Re: NT login

2002-01-21 Thread Jochem van Dieten
Kris Pilles wrote: I need to know how I can pop up the windows login and use that info to verify my usernames and passwords. Note: I do not want to use the NT login ids, I just want to use the windows login as my login form to my members area. Anyone know how I can achieve this??

Re: CSS

2002-01-21 Thread Jon Hall
You cannot change the border properties of a select box widget in any browser other than Mozilla. You can fake it though, by creating a drop down like effect with layers. Go here http://www.webfx.eae.net/dhtml/select/jsGenerated.html for the script. jon - Original Message - From: Steven

Re: Receive CFQUERY results in dollar format

2002-01-21 Thread Kent A. Orso
Steve and everyone else, Thanks for the CFIF suggestion, this will work, I was attacking the problem from a different direction. Kent - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 7:35 AM Subject: RE: Receive

RE: Capture Output from CFINCLUDE?

2002-01-21 Thread James Ang
{Sent earlier but never appeared on CF-Talk. Converted to [].} I guess I should have revealed more. ;) Like most solutions out there that modularized the look and feel of a website, there are two CFINCLUDEs to every template that takes care of encapsulating a script's logic (shielding the

RE: Capture Output from CFINCLUDE?

2002-01-21 Thread Steve Oliver
I tried this to test it. cfmail cfinclude template=header.cfm Body stuff... cfinclude template=footer.cfm /cfmail It works fine, all of the cfml in the header and footer was executed in the email I received. Try using another method to validate the email addresses, there are several

RE: Problems with looping

2002-01-21 Thread Angel Stewart
Hey all, I tried the two solutions offered, end neither of them worked. The code is still only cycling over the first employee and simply not moving to any other employee in the database. I'm at a complete loss as to why, since the logic should be sound. -Angel -Original Message-

RE: Problems with looping

2002-01-21 Thread Steve Oliver
Why not try a join instead of multiple queries? Something like: Select SUM(RegHrs) AS TotalHours FROM TblMainEntry,TblDetailEntry, Empl_General WHERE TblMainEntry.EmpID = Empl_General.Employee_ID AND tblDetailEntry.RecordDate = to_date('#currentdate#','mm/dd/') I'm not sure exactly what

ColdFusion Linux configuration issue

2002-01-21 Thread Zac Belado
There is supposed to be a knowledge base article detailing configuration issues that can cause error 111 messages to be displayed under Linux. The article in question appears to have been removed or hasn't been completed (despite an Oct 2001 published arrival date). Does anyone know if this

RE: ColdFusion Linux configuration issue

2002-01-21 Thread Jesse Noller
Hey Zac- Those are my articles, and I know, they are not done. (I've been caught up in development). None of them are supposed to address the Unix 111 errors, however, what's going on? (ot: you should also send unix/linux stuff to cf-linux (as to avoid the noise of cf-talk). -Jesse

Help with creating ODBC connection to use with MySQL

2002-01-21 Thread Larry Juncker
I need some direction in creating a workable ODBC connection with mySQL. I can see the connection in the system DSN setup, but I can not verify it with CF 5.0 Administrator . Any help with this would be greatly appreciated. Larry Juncker Senior Cold Fusion Developer Heartland Communications

RE: ColdFusion Linux configuration issue

2002-01-21 Thread Zac Belado
Those are my articles, and I know, they are not done. (I've been caught up in development). None of them are supposed to address the Unix 111 errors, Someone had better change the FAQ at ftp://ftp.allaire.com/kbftp/coldfusion/50/21908/jnoller-LinuxFAQ_21908.htm then as it seems to state that

RE: ColdFusion Linux configuration issue

2002-01-21 Thread Jesse Noller
Yeah, those links are my bad. ::sigh:: Anyone got some more hours in the day I can have? -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 3:02 PM To: CF-Talk Subject: RE: ColdFusion Linux configuration issue Those are my articles, and I

RE: Help with creating ODBC connection to use with MySQL

2002-01-21 Thread Jesse Noller
What's the error you get? -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:49 PM To: CF-Talk Subject: Help with creating ODBC connection to use with MySQL I need some direction in creating a workable ODBC connection with mySQL. I can

RE: Help with creating ODBC connection to use with MySQL

2002-01-21 Thread Steve Oliver
If you can see the connection in the system DNS setup, then I'm sure you have MyODBC drivers installed. You need to put in a few variables. Windows DNS name: (the odbc name you want) MySQL host: (localhost if it's on your computer) MySQL database name: (the exact name of your dbase in mySQL)

sessions

2002-01-21 Thread Shawn Regan
Does anyone know what this is? session.mytype=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223334 4445654321 Shawn Regan Applications Developer pacifictechnologysolutions __ Why Share? Dedicated Win 2000

RESOLVED RE: Help with creating ODBC connection to use with MySQL

2002-01-21 Thread Larry Juncker
I forgot to set up my username and password for the DSN - It works ok now. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:03 PM To: CF-Talk Subject: RE: Help with creating ODBC connection to use with MySQL If you can see the connection

Verity Question

2002-01-21 Thread Brian Scott Barnett
On CF Server 5, does Verity log the searches that people do, somewhere? If so, how can I get to them? I'd like to see the search terms that people are using, so that I can architect the site better. Brian Barnett [EMAIL PROTECTED] FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Coldfusion Server

2002-01-21 Thread Chad McCue
I am experiencing 100% CPU usage on my cold fusion server. One reason suggested to me was that large files may be getting uploaded on my server. Can anybody tell me what is considered a large file that would be capable of timing out my server? Any other suggestions about this problem would

RE: sessions

2002-01-21 Thread Steve Oliver
It means that your cfml is wrong somewhere. Can you paste the code that brings on that error? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:00 PM

Query output in a form question

2002-01-21 Thread Schwartz, Paul
Hello, I have a db table that im querying into an html form table. I would like have an input field linked to each entry in the database. So that on submit it will only show the choices that were checked with a radio button or something. Is this possible? Here is the information that Im wanting

RE: sessions

2002-01-21 Thread Brendan Avery
you can make it happen any time by doing this: cfparam name=session.x default=1 when you don't have sessions enabled in your cfapplication. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 12:00 To: CF-Talk Subject: sessions Does

Re: sessions

2002-01-21 Thread Jochem van Dieten
Shawn Regan wrote: Does anyone know what this is? session.mytype=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223334 4445654321 It usually means you tried to write a read-only variable. Jochem __ Why

RE: sessions (further clarification)

2002-01-21 Thread Brendan Avery
what it really means is that you have an assignment somewhere, either through a cfparam or complex cfset statement where coldfusion has created a temporary storage item (the variable named CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode122333565 4321 ) and an error occurred trying

Browser Detection UDF

2002-01-21 Thread Russel Madere
Does anyone have a UDF that will detect the type and version of a user's browser? I checks CFLib.org and could not find one. I can probably write one, but I need the time to do it and it is outside of the domain of the current application I am working on. Russel

RE: Query output in a form question

2002-01-21 Thread Steve Oliver
I'm not sure what you mean, do you just want to pass the Item ID of an item with a radio input next to it? If so just do something like this. input type=Radio name=ItemID value=#ItemID# #ItemName# Then the value of FORM.Item on the next page will be your itemID. __ steve

RE: Verity Question

2002-01-21 Thread Garza, Jeff
Not to my knowledge. What you could do is on the search action page (where you call CFSEARCH, do a simple DB insert of the search terms... Or use the NIFTY CFLOG tag, which is new to CF5, to create a running log of all the search terms that are tried... Speaking of that.. Thanks for reminding

Re: Coldfusion Server

2002-01-21 Thread Bryan Stevenson
If you are using Access as a database and have an ols version of MDAC (Microsoft Data Access Components) then that can cause that issues to arise. That MDAC bug was solved quite a while ago and then re-introduced around the time IE 5 came out. As long as your server has IE 5.5 or better you

RE: Browser Detection UDF

2002-01-21 Thread C. Hatton Humphrey
I don't think you need a UDF for that... look at the CGI.HTTP_USER_AGENT for that info. C. Hatton Humphrey, Developer Fisher, Towne Associates 716-839-2141 x336 [EMAIL PROTECTED] -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:55

RE: Browser Detection UDF

2002-01-21 Thread Steve Oliver
I found a custom tag and just converted it over to a UDF, hope it helps! !--- to use just call the function --- cfscript getBrowser(cgi.http_user_agent); /cfscript !--- outputting the function --- cfoutput#getBrowser.browsername# - #getBrowser.browserVersion#/cfoutput !--- here's the UDF ---

RE: Browser Detection UDF

2002-01-21 Thread Kevin Bridges
I just saw one in the exchange on macromedias site earlier today ... didn't download it though so have no opinion about it ... I think I searched for browser detect ::: -Original Message- ::: From: Russel Madere [mailto:[EMAIL PROTECTED]] ::: Sent: Monday, January 21, 2002 1:55 PM :::

RE: Browser Detection UDF

2002-01-21 Thread Russel Madere
This is perfect! Thanks. I hope to put this into production. Russel -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:12 PM To: CF-Talk Subject: RE: Browser Detection UDF I found a custom tag and just converted it over to a UDF, hope

RE: Coldfusion Server

2002-01-21 Thread Brunt, Michael
Chad, I have never yet seen any file large enough to consume 100% CPU usage but I have seen many 100% CPU usage issues. I would say that this is almost certainly related to shared scope variable memory corruption. However, before sending off on a wild goose chase, here is what I suggest. Look

Re: Coldfusion Server

2002-01-21 Thread Alex
100%CPU usage is a common complaint. I haven't seen any resolution to it though. Try the basics: lock your variables, look for infinite loops, odbc driver leak, CF doesn't reallocate memory, bad sql On Mon, 21 Jan 2002, Chad McCue wrote: I am experiencing 100% CPU usage on my cold fusion

CFContent Delete File Error

2002-01-21 Thread Bernd VanSkiver
I am using cfheader and cfcontent to get the user to download a dynamically created file from the server and that is working great, but when I set the deletefile attribute to yes so that the file will be deleted after the user downloads it, it puts a CF Error in the file instead of sending the

ColdFusion Crystal Reports References

2002-01-21 Thread Gregory Harris
Hey there, right now I'm trying to learn Crystal Reports design with ColdFusion, and I wanted to see if there was a place that had any good tutorials, samples, etc. Any ideas? Thanks! __ Dedicated Windows 2000 Server PIII 800

cf sites go poof

2002-01-21 Thread Lewis Sellers
I was letting my bookmarking script repopulate everything last night .. and noticed several of the old cf places were marked as dead?. That's interesting. :) __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD /

RE: Coldfusion Server

2002-01-21 Thread Carlisle, Eric
Also check the /cfusion/mail directory for 0 byte spool files (or any malformatted spool file). If you feed the spooler directory anything other than a perfect spool file and the processor will spike to 100%. Once in a while, ColdFusion can spit out one of these 0 byte files. If that's

RE: cf sites go poof

2002-01-21 Thread Robert Everland
Like which ones? Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:36 PM To: CF-Talk Subject: cf sites go poof I was letting my bookmarking script repopulate everything

RE: sessions

2002-01-21 Thread Shawn Regan
Yeah, I have it enabled in my cfapplication tag. Shawn Regan Applications Developer pacifictechnologysolutions -Original Message- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 12:45 PM To: CF-Talk Subject: RE: sessions you can make it happen any time

RE: sessions

2002-01-21 Thread Shawn Regan
cfif session.type EQ user cflocation url=#self#?Fuseaction=course.feeApproval addtoken=Yes cfelse cflocation url=#self#?Fuseaction=applicationCore.ProjectTeam addtoken=Yes /cfif --- /cfcase Shawn Regan Applications Developer

javascript/coldfusion--- Can you do this?

2002-01-21 Thread Metzy Martinez
i have an application that saves a listing entry. this entry can have multiple number of addresses. so i have a child window that pops up. this window then calls addresspost.cfm, this is the code you will find below, and with this page i save the address and proceed to get all of the address that

RE: Browser Detection UDF

2002-01-21 Thread Pete Freitag
here's one: http://www.cfdev.com/products/productdetail.cfm/id/1003 -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:55 PM To: CF-Talk Subject: Browser Detection UDF Does anyone have a UDF that will detect the type and version of a

RE: CFContent Delete File Error

2002-01-21 Thread Steve Oliver
Yeah I had that same problem. You need to go into the security settings of the folder where the files are stored, and set it so IIS users can modify files. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Bernd VanSkiver

RE: Coldfusion Server

2002-01-21 Thread Brendan Avery
actually i have seen large files or large multi-file set uploads cause coldfusion to go right to 100% CPU usage. usually after 15 minutes or so you'll get a winnt error returned about unable to write file or some other bs. our machines usually start hating around 40 megs using cf and apache.

RE: javascript/coldfusion--- Can you do this?

2002-01-21 Thread Steve Oliver
Look into WDDX, CFML2JS will create an array of all of your values for you. Something like script cfwddx action=cfml2js input=qryName toplevelvariable=variablename /script That will result in script variablename = new array stuff /script You'll need to include wddx.js which is in your

Re: cf sites go poof

2002-01-21 Thread Lewis Sellers
On Mon, 21 Jan 2002 16:56:03 -0500, Robert Everland [EMAIL PROTECTED] wrote: Like which ones? I'd have to go poking through the deleted table. Maybe it's just been a while since I did a full refresh. trilimetry was one I remember. (cfdefusion of course is closing but the site's still there

Re: cf sites go poof

2002-01-21 Thread Lewis Sellers
On Mon, 21 Jan 2002 17:11:22 -0500, Lewis Sellers [EMAIL PROTECTED] wrote: On Mon, 21 Jan 2002 16:56:03 -0500, Robert Everland [EMAIL PROTECTED] wrote: Like which ones? I'd have to go poking through the deleted table. Maybe it's just been a while since I did a full refresh. trilimetry was

Re: cf sites go poof

2002-01-21 Thread Jon Hall
Well, obviously your ISP was having a major routing issue last night! ;-) - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 4:35 PM Subject: cf sites go poof I was letting my bookmarking script repopulate

Re: CFContent Delete File Error

2002-01-21 Thread Bernd VanSkiver
That solved it, thanx Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 4:06 PM Subject: RE: CFContent Delete File Error Yeah I had that same problem. You need

RE: cf sites go poof

2002-01-21 Thread Mark A. Kruger - CFG
hehe -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:18 PM To: CF-Talk Subject: Re: cf sites go poof On Mon, 21 Jan 2002 17:11:22 -0500, Lewis Sellers [EMAIL PROTECTED] wrote: On Mon, 21 Jan 2002 16:56:03 -0500, Robert Everland [EMAIL

ColdFusion/Crystal Reports question

2002-01-21 Thread Gregory Harris
Perhaps someone can help me with a more direct question, how do I pass a parameter variable from CFREPORT into Crystal Reports 8.5. Specifically in Crystal Reports I have parameter variables StartDate and EndDate and I'd like to pass them from CFREPORT in looking something like this StartDate =

  1   2   >