cfmx and browser cache issue

2002-07-23 Thread Brian Scandale
I've been working a problem for about 3 weeks now... with no luck. I am having a hard time believing I am the only one affected by this. At first that is what I thought... I am open to any and all ideas. I now think it is a problem with CFMX. I can open access to the application for those who

cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Brian Scandale
I just upgraded from CF5 to CFMX by Uninstalling CF5 and then Installing CFMX. For the last three hours I have been trying to re-establish datasource connections to SQL server which is running on the same box without any luck. This is the error: --- Connection verification

RE: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Brian Scandale
At 01:21 PM 7/22/02, you wrote: In CF 5, you could use trusted connections via Windows authentication to talk to SQL Server. In CF MX, you can't do that; your SQL Server will need to allow native SQL logins (usernames and passwords) I have SQL Admin rights. I deleted the DSN that lives in the

RE: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Brian Scandale
YES, just confirmed connection using username and password via ODBC control panel... then went back to CFAdministrator and tried various ways of making it connect... still a failure. At 02:22 PM 7/22/02, you wrote: I have been attempting to get the datasource configuration module of the

RE: CFMX JDBC Drivers

2002-07-22 Thread Brian Scandale
Thank Ryan, That was a great idea. It works for me too... but yes I do expect a performance hit. Brian At 02:23 PM 7/22/02, you wrote: As a temporary fix, you could always try an ODBC Socket connection. Here's what you do: set the DEN in the Windows ODBC Admin, then go to the admin panel in

RE: CFMX caching...

2002-07-22 Thread Brian Scandale
At 09:52 PM 7/11/02, you wrote: Sounds like Apache. -Original Message- From: mark brinkworth [mailto:[EMAIL PROTECTED]] Sent: Friday, 12 July 2002 2:38 PM To: CF-Talk Subject: RE: CFMX caching... I wish is was just Apache. I just installed CFMX onto a Win2k box with IIS. The problem

Re: CFMX CFM/JSP/Servlets/Beans Compile?

2002-07-22 Thread Brian Scandale
You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX...

Need quick SQL Server Advice

2002-07-18 Thread Brian Scandale
I have a query that works well with postgreSQL I just uploaded the code to a SQL Server installation and this query is failing with the Error: --- Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near 'LIMIT'. SQL = SELECT * FROM SPCData, Device WHERE

Re: Need quick SQL Server Advice

2002-07-18 Thread Brian Scandale
Paul, Doug Thanks! At midnight things get blurry At 11:48 PM 7/17/02, you wrote: SELECT TOP 8 * FROM SPCData, Device WHERE SPCData.SPCDitem_ID = 1 AND SPCData.SPC_Device_ID = Device.Device_ID ORDER BY SPCData_ID DESC --- Outgoing mail is certified Virus Free. Checked by AVG

Re: curious about application.cfm behavior

2002-07-17 Thread Brian Scandale
Yes, CF moves up the directory tree looking for an application.cfm and uses the first one it comes across. At 08:24 AM 7/17/02, you wrote: Hello everyone, I came across a behavior today that I was never previously aware of. Just thought I'd share and see what exactly is happening. Say

Re: Alter Column syntax in Oracle?

2002-07-12 Thread Brian Scandale
This should help: http://info-it.umsystem.edu/oradocs/doc/server/doc/SQL73/ch4a.htm#toc064 At 12:42 AM 7/12/02, you wrote: I want to change a varchar2 field from 10 characters to 50. I can't seem to get the syntax right. I'm not all that familiar with Oracle. What am I doing wrong here?

Re: CFmail can only deliver to our domain name...

2002-07-12 Thread Brian Scandale
Just an idea you might want to check out... If you are being hosted by an ISP and you are not in control of your SMPT server you might find that it is rejecting them because the from:address is not allowed to be off the domain the SMPT is serving. At 07:51 AM 7/12/02, you wrote: I sent 180

Re: importing .dbfs into Access...

2002-07-12 Thread Brian Scandale
Rewrite the script to do it in pieces. My guess... a guess mind you... is that you are most likely running out of memory. At 09:58 AM 7/12/02, you wrote: Hello CF Gurus, I need to write a script that will import a 180MEG dbf file into an empty Access table. My first attempt at going

RE: Storing Queries in Application Scope

2002-07-12 Thread Brian Scandale
Ben, Please clarify for me. I'm a bit slow as others on the list can attest to. ;-) Are you saying that in the background, CFMX will upload patches and hotfixes? And then CFMX will install those patches and hotfixes on the CFMX server? Thanks, Brian At 11:23 AM 7/12/02, you wrote: Todd, I

Re: SQL question...

2002-07-11 Thread Brian Scandale
- Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 10:34 PM Subject: SQL question... I now this is quite simple... however I need clues to get me started... How does one go about breaking out the various

RE: CFMX caching...

2002-07-11 Thread Brian Scandale
=Form.test Then run the first file. You should get a dump of the HTTP headers that were sent back. What headers do you get? Cheers, Mark From: Brian Scandale [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CFMX caching... Date: Wed, 10 Jul 2002 10:52

RE: CFMX caching...

2002-07-11 Thread Brian Scandale
which way to go from here to solve this one. From: Brian Scandale [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: CFMX caching... Date: Thu, 11 Jul 2002 02:01:42 -0700 That worked like a champ Mark. These are the two results... Nothing obvious to me

RE: Access on CFMX Linux?

2002-07-10 Thread Brian Scandale
Yeah, perhaps true but truthfully mySQL smokes as a readonly filesystem... Different tools for different problems. Hey while you're at it maybe one of you geniuses can help me get my head around my problem with CFMX vs CFM5 causing a Refresh to Repost the Form Data notice on the exact same

RE: Access on CFMX Linux?

2002-07-10 Thread Brian Scandale
Perhaps just dump the subscriber list to a csv file, and use that as the input to your app... Assuming it's a once a month affair it could work. At 11:14 PM 7/9/02, you wrote: Thanks Matt, Peter for your advise. The situation I'm in is my customer is given MS Access databases which contains

RE: CFMX caching...

2002-07-10 Thread Brian Scandale
At 12:55 AM 7/10/02, you wrote: The first question you have to ask yourself is, what changed? Just pulled CF5 off a dev machine and put CFMX up... then the trouble started. the same code still works well on a CF5 production machine. Are you sure the only difference is CFMX? What web server are

RE: CFMX caching...

2002-07-10 Thread Brian Scandale
Just noticed that the included header from my last post was stripped out because it contained a cut and paste of the header... htlm,javascript and all... I'll try again with the javascript pulled out and the tags mangled. - the top of the file with the header !-- Application -- !--

SQL question...

2002-07-10 Thread Brian Scandale
I now this is quite simple... however I need clues to get me started... How does one go about breaking out the various subtotals from a dataset? Example: In this example table there are multiples of the same parttype. parttype partnameinstock --- carparts

cfusion_verifymail error in CFMX

2002-07-09 Thread Brian Scandale
The CFusion_VerifyMail(server,port,timeoutInterval) function generates an error in CFMX. Anyone know of a suitable replacement? Thanks, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in

CFMX caching...

2002-07-09 Thread Brian Scandale
I switched to CFMX a few days ago... Suddenly (when clicking back) Many pages declare the Warning: Page has Expired. The page you requested was created using information you submitted in a form. This page is no longer available. To resubmit your information and view this Web page, click the

RE: CFMX caching...

2002-07-09 Thread Brian Scandale
. There are hundreds of people asking this very same question. Matt -- Matt Wisdom CTO Turbo Squid -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 7:39 PM To: CF-Talk Subject: CFMX caching... I switched to CFMX a few days ago... Suddenly (when

Re: Skimmin the list.......? [oT]

2002-07-09 Thread Brian Scandale
Way to go critz... Yep. I got the same Spam today too. At 04:16 PM 7/9/02, you wrote: oi CF-Talk,!! I use this addy only for this list. (almost positive) today I received an email to it from: [EMAIL PROTECTED] [EMAIL PROTECTED] (The Recruitment Consultant) someone here sucking

RE: CF SQL Tool

2002-07-08 Thread Brian Scandale
And the .rar file throws errors when i use WinRar 2.80 on it. At 06:09 PM 7/8/02, you wrote: Both of your CF SQL Tool links are for the .rar file :) -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 9 July 2002 4:14 AM To: CF-Talk Subject: CF SQL Tool I

date field formats in CFMX

2002-07-08 Thread Brian Scandale
I have experienced a difference between CF5 and CFMX in default display of date database fields. In CF5 a date database field would display as: 2002-05-01 00:00:00 In CFMX it shows up unformatted as: {ts '2002-05-01 00:00:00'} I can take care of it by using the DateFormat function... however

RE: CF SQL Tool

2002-07-08 Thread Brian Scandale
Hey Trent... the zip is missing the style.css file... At 07:18 PM 7/8/02, you wrote: I apologize.. They are fixed now. -- Original Message -- from: Tilbrook, Peter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 9 Jul 2002 11:09:34 +1000 Both

RE: CFMX editors...

2002-07-06 Thread Brian Scandale
/coldfusionstudio/productinfo/resources/ta g_updaters/ CFMX Help: http://download.macromedia.com/pub/homesite/updates/cfml_ref.zip ~Todd -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 06, 2002 12:44 AM To: CF-Talk Subject: CFMX editors... Curious

RE: CFMX editors...

2002-07-06 Thread Brian Scandale
Let's hope not! If it's not for sale anywhere I don't really see the problem. At 09:36 AM 7/6/02, you wrote: does anyone want to share? Share what...a jail cell? :) __ Get the mailserver that powers this list at

RE: CFMX editors...

2002-07-06 Thread Brian Scandale
Didn't they have a Trial download at one time? I never downloaded it. Perhaps someone has that available? At 09:36 AM 7/6/02, you wrote: does anyone want to share? Share what...a jail cell? :) __ Structure your

coldfusionMX and postgresql

2002-07-05 Thread Brian Scandale
Having trouble getting coldfusion to access postgresql tables... Recall that in 5.0 I just needed to make an ODBC driver available... What are the steps to get it running in MX ? Thanks, Brian __ Signup for the Fusion

RE: coldfusionMX and postgresql

2002-07-05 Thread Brian Scandale
Thank you Dave, That was EXACTLY what I needed. and Thank you Jochem! It's guys like you who make this list rock! At 04:33 PM 7/5/02, you wrote: Having trouble getting coldfusion to access postgresql tables... Recall that in 5.0 I just needed to make an ODBC driver available...

CFMX editors...

2002-07-05 Thread Brian Scandale
Curious as to what everyone is using now... It might save me a bunch of time. I've been using CFStudio 4.5.2 but now that I've loaded CFMX onto the development server I was wanting to use the new charting tags etc and an editor that supported the help for the new tags... thanks, Brian

OT: Unpacking JAR files...

2002-07-02 Thread Brian Scandale
I am trying to unpack one of the jar files shipped with cf5 to see if it might be possible to add some features to the cfgraph tag. the jar command entered at the prompt seems to run and then hangs... with no cpu cycles being consumed by jar according to the task manager. Am I nuts or is it

Re: OT: Unpacking JAR files...

2002-07-02 Thread Brian Scandale
Yep, that worked. Thank you. Now my next task is to decompile them? At 09:12 AM 7/2/02, you wrote: oi Brian!! you could just use winrar to open it up www.rarsoft.com -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion

RE: OT: Unpacking JAR files...

2002-07-02 Thread Brian Scandale
Rant Great, So the tag doesn't work properly and we're prohibited from fixing it. Kinda like you buying a car and being told... by law you are not permitted to tinker with the engine to make it perform better for your environment. Intellectual property is sort of an oxymoron. Stealing

CFGRAPH Replacement?

2002-07-01 Thread Brian Scandale
I'm searching for a replacement for cfgraph if anyone can point me... I need to display several data sets on one graph. VERY much appreciated. Brian __ Signup for the Fusion Authority news alert and keep up with the latest

String Manipulation troubles

2002-06-26 Thread Brian Scandale
Why doesn't this cfif statement catch the ] character? Or a better question is How do i branch on that character... chr(93) doesn't work either. cfset temp = ] cfoutputbrtemp = #temp#br/cfoutput cfif temp IS ] cfoutputbrtemp = #temp#br/cfoutput Yep It Works! /cfif

Re: String Manipulation troubles

2002-06-26 Thread Brian Scandale
-- from: Brian Scandale [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 26 Jun 2002 00:49:35 -0700 Why doesn't this cfif statement catch the ] character? Or a better question is How do i branch on that character... chr(93) doesn't work either. cfset temp

Re: String Manipulation troubles

2002-06-26 Thread Brian Scandale
this problem before and by always trimming my vars and using eq instead of is, I have had far less problems like this. HTH Clint -- Original Message -- from: Brian Scandale [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 26 Jun 2002 00:49:35 -0700 Why

RE: String Manipulation troubles

2002-06-26 Thread Brian Scandale
Sorry All SOE Stupid Operator Error: It works... I just can't read. That's what I get for 2am morning sessions. Brian At 09:05 AM 6/26/02, you wrote: It works for me Ade -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 08:50 To: CF-Talk

Javascript, form input colors and Netscape

2002-06-26 Thread Brian Scandale
Does anyone know how to use javascript to change the background color of an input type=text form element with Netscape 4.0? I have been using statements like this for IE and Netscape 6.0+ -- frm.elements[itemNumber].style.background = #00FF00; -- but it does not work with

Re: Javascript, form input colors and Netscape

2002-06-26 Thread Brian Scandale
series browsers but it's not an authoritive statement that I've heard yet. My searches turn up nothing definitive. Anyone? Brian At 04:47 PM 6/26/02, you wrote: http://www.mako4css.com/cssforms.htm - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED

IIS / CF ReInstall Question...

2002-06-24 Thread Brian Scandale
If I reinstall IIS on a Win2k Server will I have to reinstall CF 5.0 as well? Thanks. At 11:03 AM 6/24/02, you wrote: The only way might be through the Jrun OEM program...Where they sell licenses to include the Jrun app server as part of your product...I'm assuming they may or possibly already

RE: IIS / CF ReInstall Question...

2002-06-24 Thread Brian Scandale
Thanks Dave!!! Really appreciate this information. Brian At 12:12 PM 6/24/02, Dave Watts wrote: If I reinstall IIS on a Win2k Server will I have to reinstall CF 5.0 as well? No, but if you don't, you'll have to manually configure IIS to send CFML files to the CF server. This is pretty easy

RE: IIS / CF ReInstall Question...

2002-06-24 Thread Brian Scandale
Hi Dave, What all needs to be set? I'd look myself at what is currently set except that the machine is reporting 'Can't find path: when trying to Open the IIS Management Console That's why we're going to have IIS Reinstalled. At 12:12 PM 6/24/02, you wrote: If I reinstall IIS on a

RE: DNS Havoc!!

2002-06-13 Thread Brian Scandale
I'm getting your new ip address when I ping. You are probably just getting the results of cached DNS entries... it should clear up in a couple of hours. P.S. about half of the pings are timing out. At 02:29 PM 6/13/02 -0500, you wrote: I'm getting the nw IP from both 207.x.x.x and 68.x.x.x

RE: Ridiculous Problem!

2002-06-05 Thread Brian Scandale
I think this is because you are missing this file :\Inetpub\wwwroot\Main\ide.cfm I belive I read that somewhere recently. At 04:25 PM 6/5/02 -0400, you wrote: Bud, What is '/' mapped too? Also, are you hosting multiple sites on the webserver? Which one is CFIDE physically located in?

RE: IE 6.0 Bug ... style sheet bug ... looking for workaround

2002-06-03 Thread Brian Scandale
Tried that... and a zillion other things too. ;-( Are you running IE 6.0 and see the problem?? At 11:09 PM 6/2/02 -0700, you wrote: Brian, Try adding a pound sign before the rgb color value. background: #66; Robert -Original Message- From: Brian Scandale [mailto

RE: IE 6.0 Bug ... style sheet bug ... looking for workaround

2002-06-03 Thread Brian Scandale
) [EMAIL PROTECTED] -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 1:48 AM To: CF-Talk Subject: RE: IE 6.0 Bug ... style sheet bug ... looking for workaround To: [EMAIL PROTECTED] Subject: IE 6.0 Bug ... style sheet bug ... looking

A table design puzzle

2002-06-03 Thread Brian Scandale
I have a table relationship puzzle to solve... thought I might run it by the list before I commit to tables and code... A factory builds integrated circuits on silicon wafers, 25 wafers to a lot. Each Lot has a unique ID. The 25 wafers each have a unique serialized ID. The wafers can transfer

Re: Does posting to cf-talk via the fuseware.com newsgroup actually makeit out to the list members?

2002-06-03 Thread Brian Scandale
if that is where you mailed this from then YES, it made it to me. At 11:07 PM 6/3/02 -0400, you wrote: On Mon, 03 Jun 2002 17:26:25 -0400, in cf-talk you wrote: Anyone? TIA Geo __ Get the mailserver that powers this list at

IE 6.0 Bug ... style sheet bug ... looking for workaround

2002-06-02 Thread Brian Scandale
I just installed a large project on a site that is used exclusively with IE 6.0 and suddenly some very simple text is not displaying inside forms. So I hit it with IE 5.5 and all is OK. I am having trouble with Free Form text that floats above Select Boxes not displaying unless I drag the

RE: IE 6.0 Bug??

2002-05-31 Thread Brian Scandale
-serif; font-size : 16px; } - table class=form-color form action=gohere.cfm method=post tr tdinput type=text name=qwqw size=20/td /tr Hope that helps! Ryan Kime -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, May

IE 6.0 Bug??

2002-05-30 Thread Brian Scandale
Just installed on a site that is exclusively IE 6.0 and suddenly some very simple text is not displaying... So I hit it with IE 5.5 and all is OK. Next I pulled the View/Source output apart and everything looks OK. Discovered that if I pull the background statement,(SeeBelow) out of the .css

Re: IE 6.0 Bug??

2002-05-30 Thread Brian Scandale
- background-color: #66; one of those should do it - I recommend #1 jay miller Brian Scandale wrote: Just installed on a site that is exclusively IE 6.0 and suddenly some very simple text is not displaying... So I hit it with IE 5.5 and all is OK. Next I pulled the View/Source output apart

Re: IE 6.0 Bug??

2002-05-30 Thread Brian Scandale
the color statement out leaves the Form white... At 10:01 PM 5/30/02 -0400, you wrote: 2 suggestions 1 - move it into the body tag body { background-color: #66; } 2 - background-color: #66; one of those should do it - I recommend #1 jay miller Brian Scandale wrote: Just installed on a site

SQL Upper Function Replacement?

2002-05-30 Thread Brian Scandale
What replaces the SQL UPPER() function ins SQL Server? It's used to return the upper case of it's argument... It's complaining that Argument data type text is invalid for argument 1 of upper function thanks again! ~Brian __

inhibit form password cacheing

2002-05-29 Thread Brian Scandale
How does one inhibit the password caching request that browsers make when users enter their passwords into forms? I thought there was a meta tag but I can't find it. meta http-equiv=Pragma content=no-cache doesn't work... it only prevents caching the page... Any directions would be

RE: Server Restarts

2002-05-27 Thread Brian Scandale
Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 25, 2002 6:03 PM To: CF-Talk Subject: Server Restarts Over the last several days I notice that the Server is taking longer and longer to post the pages I am developing. After a ReStart everything is snappy

Server Restarts

2002-05-25 Thread Brian Scandale
Over the last several days I notice that the Server is taking longer and longer to post the pages I am developing. After a ReStart everything is snappy again!! For example... Multiple Crtl-RReLoad's of the page shows 4000 +/- 200 milliseconds. After ReStart it now is showing 1500 +/- 200

CSS trouble

2002-05-21 Thread Brian Scandale
I'm using a .css file to manage the look of a site. The site allows for some user configurable content via soEditor that I then display in a cell in a table. That content inherits the .css file setting and ignores much of the users designs. I'm wondering how I leave the .css settings off

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

2002-05-17 Thread Brian Scandale
checked your disk space? Check logs too Dave -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 11 May 2002 04:52 To: CF-Talk Subject: server crashing... Server keeps crashing suddenly... Because a Simple SELECT Statement with a bad spelling for a column. Usually I get

Re: False template file ... encrypted and its data has been corrupte d error

2002-05-17 Thread Brian Scandale
Send me one of the files and I'll try it on my Linux CF installation... send one that would run. At 12:20 PM 5/17/02 -0400, you wrote: I got the error below. I wrote my file in DW4, edited it in CF Studio 4, saved and tested it on an IIS server. When I uploaded it to an HP/UX box running

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,

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

2002-05-16 Thread Brian Scandale
shot, but have you checked your disk space? Check logs too Dave -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 11 May 2002 04:52 To: CF-Talk Subject: server crashing... Server keeps crashing suddenly... Because a Simple SELECT Statement with a bad spelling

RE: check for mixed case plus a numeric

2002-05-14 Thread Brian Scandale
a numeric Brian Scandale wrote: Trying to check for mixed case, and at least one digit in a prospective password. Any ... snippets that might help me get started?? Thanks, Brian __ This list and all House of Fusion resources hosted

Re: CF MailServer On-Line Check?

2002-05-10 Thread Brian Scandale
-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 6:51 PM Subject: CF MailServer On-Line Check

Re: session cookies to expire immediately on browser close

2002-05-10 Thread Brian Scandale
This is what I use I picked it up off I don't actually remember where but it works great. - this is what I use --- !--- At times developers are frustrated that the session does not end when the user closes their browser—that they must wait for the session to time out. If

check for mixed case plus a numeric

2002-05-10 Thread Brian Scandale
Trying to check for mixed case, and at least one digit in a prospective password. Any ... snippets that might help me get started?? Thanks, Brian __ Your ad could be here. Monies from ads go to support these lists and provide

server crashing...

2002-05-10 Thread Brian Scandale
Server keeps crashing suddenly... Because a Simple SELECT Statement with a bad spelling for a column. Usually I get a error message telling me attribute (bad spelling variable) does not exist. But suddenly the last few hours... the CF server is crashing... see error below... I just rebooted

CF MailServer On-Line Check?

2002-05-09 Thread Brian Scandale
I seem to recall there was a way to get CF to check if a mailserver is up and responding... but searching the forums I can't seem to find anything. Would someone please direct me? thanks, Brian __ Signup for the Fusion

cfset var1 = or EQ var2

2002-05-04 Thread Brian Scandale
What's the Difference between these two? cfset SomeVar = SomeOtherVar vs cfset SomeVar EQ SomeOtherVar I've been chasing a bug using the latter expression for 10 hours... until I noticed the improper use of EQ. No compile error was generated these last 10 hours making me think that perhaps

cfif failure?

2002-05-04 Thread Brian Scandale
Whats up with this ? Seems like the comparison is allowing any 'ole case to cause the cfif compare to be 'true'. cfset asod = tobinary(theUser.pw) cfset asod = tostring(asod) cfset asod = cfusion_Decrypt(asod, Hash(UCase(theUser.UserName))) cfif asod EQ Attributes.password cfset

RE: cfset var1 = or EQ var2

2002-05-04 Thread Brian Scandale
be inside of a cfset tag. Comparing two variables is a valid expression. -Matt -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 04, 2002 4:40 PM To: CF-Talk Subject: cfset var1 = or EQ var2 What's the Difference between these two? cfset SomeVar

RE: cfset var1 = or EQ var2

2002-05-04 Thread Brian Scandale
logic with it or assign the result to a value. Most likely the programmer made a mistake and since CF never threw an error, he or she didn't notice. -Matt -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 04, 2002 7:05 PM To: CF-Talk Subject: RE

Re: cfset var1 = or EQ var2

2002-05-04 Thread Brian Scandale
Justin, Matt, Ok, I get it now... Thanks for the heads up. At 12:08 AM 5/5/02 -0400, you wrote: There really is no reason to ever have a comparison in a cfset tag as you can't do logic with it or assign the result to a value. Most likely the programmer made a mistake and since CF never

Re: Cache size

2002-05-02 Thread Brian Scandale
open a terminal window... dos box... whatever you call it now... type cd \ to get to the root... type dir *.cf /s the last line output will be a summation of the size of all *.cfm files. Repeat for each drive in your system that you want a summary for. At 05:39 PM 5/2/02 -0700, you wrote: I

CF_HierMenus

2002-04-27 Thread Brian Scandale
CF_HierMenus I've been trying to use this tag for a few days now and can't seem to figure out how to populate it from a database. ...ANY cfml in the middle of the tag seems to blow it up. Anyone using this tag successfully??? Throw me a bone ;-) Thanks guys, Brian

Re: CFGraph precision problem

2002-04-18 Thread Brian Scandale
Off the top of my head... perhaps it's the use of quotes that's the key??? cfgraphdata item=#subgroup# value=#numberformat(percent_hrs, '__._')# At 12:42 PM 4/18/02 -0700, you wrote: I am using the following code to display a graph data item. I am using numberformat function, but the graph

Re: SQL insanity...

2002-04-17 Thread Brian Scandale
Why not do a join... something like this I expect... cfquery name=sermon_nums datasource=maindsn maxrows=5 SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally sermons.title etc, speakers.initials FROM sermons_details JOIN sermons ON

SQL server and Interval data type

2002-04-16 Thread Brian Scandale
I have built an application using PostgreSQL and it's interval data type to hold things like the time between two events etc (as you might expect) I am now required to deploy that app on SQL server too... and I just discovered they have no interval data type... or at least it looks that

Re: SQL server and Interval data type

2002-04-16 Thread Brian Scandale
Ahh yes Jochem... so true, However my puzzle still remains... what/how is that handled in SQL Server... I did notice that one source says to import interval data into SQL server set up a char field Now I'm wondering how that would work inside CF... trying to process it that is... At

Re: Preventing SQL injection attacks...?

2002-04-12 Thread Brian Scandale
There is a custom tag... cf_formfilter on the developers exchange that I've been using... It searches the caller.form.fieldnames structure looking for all sorts of nasty includes. After just reading it again I think I can also make it filter url submitted input as well. Anyone here use or

SQL Server Install and CF

2002-04-10 Thread Brian Scandale
Just sold our first CF app... a large manufacturing system. It is based on our previous client server mfg systems. The Installation environment is Windows 2000, SQL Server 2000, and CF5. Our development environment is RedHat 7.2, PostgreSQL 7.1, and CF5. Two Questions: 1. Was wondering if

RE: SQL Server Install and CF

2002-04-10 Thread Brian Scandale
answers there. If you can't find your answer there, hit groups.google.com. MS also has a SQL Server section www.microsoft.com/sql Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Wednesday

Re: listing all form variables

2002-04-08 Thread Brian Scandale
Sure Jim, try this !--- Form variables --- H4Form Variables/H4 CFIF NOT IsDefined(Form.FieldNames) PThere are no form variables/P CFELSE CFLOOP LIST=#Form.FieldNames# INDEX=Key Form.#Key#: #Evaluate(Form. Key)#BR /CFLOOP /CFIF At 12:43 PM 4/8/02

RE: CF on Redhat 7.1

2002-04-05 Thread Brian Scandale
Jim, I'm running CF5 very successfully first on RH7.1 and now 7.2 with apache and postgreSQL ... cfinstall handles it very well. However my similar problem arose when I used the RH GUI tool to make any configuration changes to apache. It ended up removing the cfinstall changes. So I now only

SQL Order By weirdness

2002-04-02 Thread Brian Scandale
Does anyone recognize why this list seems Out of Order? I am getting an odd result when using a calculation as the argument of an ORDER BY Statement... cfquery name=Hist SELECT Starts, Rejects FROM History ORDER BY ((Starts-Rejects)/Starts) /cfquery cfoutput query=Hist tr

Re: CF 5 Pro License Agreement (what if change of mind on platform?)

2002-04-01 Thread Brian Scandale
Hi Tracy, I've had the same question from time to time across the years... you get any definitive answer to that question yet? Would love to hear it. Thanks, Brian At 07:46 PM 3/29/02 -0600, you wrote: If someone purchases the CF5 Pro for Windows, has a mind change decides he wants to run

sql and alias names

2002-03-20 Thread Brian Scandale
I have a query that is giving me a bit of a problem. cfquery datasource=#request.theDSN# name=theHistory SELECT * FROM History LEFT OUTER JOIN Op ON History.Op_ID = Op.Op_ID LEFT OUTER JOIN TravelerD ON History.TravelerD_ID = TravelerD.TravelerD_ID LEFT

SQL case insensitive search ???

2002-03-14 Thread Brian Scandale
how does one go about structuring a case insensitive search on a text field in a database? Currently using WHERE Table.FieldName LIKE '%searchString%' Thanks, Brian __ Get Your Own Dedicated Windows 2000 Server PIII 800 /

RE: SQL case insensitive search ???

2002-03-14 Thread Brian Scandale
, and Author Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com more people are killed by donkeys than by airplane crashes each year -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 9:36 PM

RE: popUp Window trouble

2002-03-13 Thread Brian Scandale
=return popUp('index.cfm?fuseaction=Work.StepDetailStep=1', 'theDetailWindow', 'width=600,height=500')DETAILS/a /body Conrad -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 08:18 PM To: CF-Talk Subject: RE: popUp Window trouble Steve, It does work

RE: Question About Query Caching

2002-03-13 Thread Brian Scandale
Now I'm a bit confused... I thought that as long as the query had not expired that cf would return the cashed results... regardless of which page called the query... particularly if the query name and slq were identical. ??? am I getting marauded by a donkey? At 01:36 PM 3/13/02 -0800, you

RE: popUp Window trouble

2002-03-12 Thread Brian Scandale
) _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 3:00 AM To: CF-Talk Subject: popUp Window trouble One of my popUps

RE: cfhtmlhead

2002-03-11 Thread Brian Scandale
://www.atnetsolutions.com -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 2:49 AM To: CF-Talk Subject: Re: cfhtmlhead Sometimes I want to use cfhtmlhead to push some JavaScript into the head tag. Then in the body tag I want to include onLoad

RE: input readonly or disabled

2002-03-11 Thread Brian Scandale
://www.atnetsolutions.com -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 2:57 AM To: CF-Talk Subject: input readonly or disabled I've been using disabled in text form fields quite a bit lately when I need to gray out something and keep users from changing

<    1   2   3   >