Re: differentiating images

Abraham Lincoln wrote: > File size is same..any thing related to pixls or colors? Read the file with cffile, Hash() the resulting variable and compare the hashes. But I have never done it on entire files so it might be slow. Jochem _

Re: Time Issue

[EMAIL PROTECTED] wrote: > The time is correct in the spool folder. That is very weird. My experience (based on the timezone attribute of cf_advancedemail) is that mail servers don't change anything in the time. Any chance you can track a message all the way and post the headers here? Make sur

How to expire session variables?

Is there a good way to consistently make sessions expire within a 10 min period? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co

RE: web server for XP home?

I installed Apache a while back with no problems -- about to do it again for the same reason as you. -Original Message- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 26 March 2002 5:29 p.m. To: CF-Talk Subject: web server for XP home? I just bought a laptop and we are discus

RE: IMS Fusion Mail vs. ActivMail ?!!

We will be coming out with Version 1.3 in the next couple weeks, here are some features you can look forward to... SMTP Server Load Balancing - you can now specify multiple SMTP servers to distribute the load across several SMTP servers. Provides a huge performance increase. Queries - now yo

web server for XP home?

I just bought a laptop and we are discussing development (like at the park/beach/pool ;-) ) but I read somewhere that Personal Web Server won't run under XP. I don't really want to upgrade it to XP Pro to use IIS, and I tried two "free" web servers - when I click on the CF Administrator, analog

Re: differentiating images

File size is same..any thing related to pixls or colors? - Original Message - From: "jon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 23, 2002 9:23 PM Subject: RE: differentiating images > File size, maybe? > > -- jon > > - > jon roig > senior

CFHTTP not connection to Authorizenet !!!???!!

Anyone have any ideas why CFHTTP may not be connecting with Authorizenet using the CF Authorize tag? Here is the response message: Your charge was declined for the following reason: An error occurred when attempting to connect with the credit card processor.

RE: CFContent Output

That did the trick. Thanks for your quick help. Thanks, Mark -Original Message- From: Jared Clinton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:09 PM To: CF-Talk Subject: RE: CFContent Output Try separating the two scripts. The first script can be called as a HTML pa

RE: CFContent Output

Try separating the two scripts. The first script can be called as a HTML page by the client-browser. The second can be called from within the HTML page in an IMG tag the src attribute can call your CFCONTENT script Hope this helps, Jared Clinton NEC Australia -Original Message- From:

CFContent Output

I have a template with a CFContent tag placed somewhere between two blocks of normal HTML text and/or images. When the page loads and reads the CFContent tag (as when I would want to display a jpeg photo, for example), all the HTML is ignored, and just the photo is displayed. Is there any way to

Re: Time Issue

Kelly, running Lotus Notes email client by any chance? Jim McAtee wrote: >What are you looking at? The file's date/time, or the message's headers? >Post a set of headers from a message that you're receiving in your email >client. > >Jim > > >- Original Message - >From: <[EMAIL PROTECTED

CFFTP

Hi all, Anyone know the limitations / performance issues w/ cfftp? I building an application that will have many simultaneous users accessing templates that cfftp files to many different locations. Questions: 1) How many simultaneous / active connections can the CF Server handle? 2) Is there

RE: studio issue creating files in file explorer

Robert - I get this all the time, but it always follows me creating a directory. I have not found a real fix, but I just create the directory, click on another directory, click back to the one I created, and then create a file. This seems to work without the error. Bill Henderson [EMAIL PROTECT

RE: Looping over a query with

Many Thanks ^_^ -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 3:56 PM To: CF-Talk Subject: Re: Looping over a query

Re: Looping over a query with

http://www.houseoffusion.com/docs/cfscript.htm note 8.7 At 06:47 PM 3/25/02, you wrote: >Is this possible? If so, sample code would be appreciated. > >I tried the following, and got an access error (i understand that you can't >modify currentrow, etc, but one can wish, right ^_^): > > > while (s

Looping over a query with

Is this possible? If so, sample code would be appreciated. I tried the following, and got an access error (i understand that you can't modify currentrow, etc, but one can wish, right ^_^): while (selProd.CurrentRow LTE selProd.RecordCount) { writeOutput(selProd.PR_NAME); writeOutput("");

Re: Screen width, Height, & Color Depth

A complete code sample is here: http://foohbar.org/snippets/docs.cfm All you have to do is write up an appropriate referer test to go with it. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com

Re: Time Issue

What are you looking at? The file's date/time, or the message's headers? Post a set of headers from a message that you're receiving in your email client. Jim - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 4:23 PM Subject: R

RE: Time Issue

I think CFMAIL forces the time zone based on the server time. Perhaps your email server is set with a different time zone than your server. Check your mail headers, should give you a clue Adrian - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMA

Re: Time Issue

The time is correct in the spool folder. - Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 3:50 PM Subject: Re: Time Issue > [EMAIL PROTECTED] wrote: > > When I send an email through the mail server through P

500 internal server error wap coldfusion

anyone know why I keep getting a 500 internal server error when trying to use wap with CF. I have the cfcontent tag at the top of the page. This is annoying me. if anyone has gotten wap and cf to work together, plwase help. __ Get

Re: Passing Arrays to Custom Tags

DOH! Thanks :) - Original Message - From: "Sharon Diorio" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 4:15 PM Subject: Re: Passing Arrays to Custom Tags | You need to evaluate the array. | | | | Sharon | - Original Message - | From: "Jare

Re: Passing Arrays to Custom Tags

You need to evaluate the array. Sharon - Original Message - From: "Jared Stark" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 6:07 PM Subject: Passing Arrays to Custom Tags > Hello all, > My Wrox ColdFusion book says that "arrays can be passed to

Does CFHTTP in CF 5 only handle 56 bit encyrption?

Does CFHTTP in CF 5 only handle 56 bit encyrption? This is what I read on their site? If its true, it sucks, because I'm trying to use CF Authorize, a 3rd party tag. "Due to United States export limitations that were in effect when Macromedia ColdFusion Server 4.5 and 5 were released, the cfhtt

Passing Arrays to Custom Tags

Hello all, My Wrox ColdFusion book says that "arrays can be passed to custom tags just like any other variable", but I am getting errors when I try it. I have the following: which returns an array of shopping cart items into a variable called 'myCart'. I can run: IsArray(myCart) and it ret

Re: Testing Software

> Does anyone know of any software like vmware that will allow for Mac > emulation. From what I understand vmware does not, but does anyone know of > another that does? Best way is to... buy a mac. We have a lone iMac sitting in middle of the office for website testing. And when it's not testi

Re: Time Issue

Perhaps your server is stuck in a time warp? - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 5:48 PM Subject: Re: Time Issue > When I send an email through the mail server through POP account - the time > is correct - when I

Re: Time Issue

[EMAIL PROTECTED] wrote: > When I send an email through the mail server through POP account - the time > is correct - when I send it via cfmail - it is wrong. Any other ideas? Check the mail while it is in the spool dir. If the time is wrong there: http://www.macromedia.com/support/email/wishform

Re: Time Issue

When I send an email through the mail server through POP account - the time is correct - when I send it via cfmail - it is wrong. Any other ideas? - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 3:23 PM Subject: Re: Time Issue

CFAuthorize tag not working with CF 5 ?!! Any ideas why not?

Am having a problem connecting to Authorizenet using the cfauthorize tag with Cold Fusion 5. Any ideas what the problem might be or any ideas on how to fix it? Regards, Pardee. __ This list and all House of Fusion resources hos

Re: IMS Fusion Mail vs. ActivMail ?!!

You can see a comparison here: http://www.coolfusion.com/imssecomparison.cfm HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks

RE: Stored procedures & pdfs

>(without pdf conversion all show up correctly) wouldn't this indicate that the problem is NOT in the stored proc?? +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAI

Re: Time Issue

time zones are correct. - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 2:58 PM Subject: Re: Time Issue > I know that Now() uses GMT. > If this is the case, do you know how to avoid this. > > - Original Message - > Fro

IMS Fusion Mail vs. ActivMail ?!!

Does anyone know the main differences between IMS Fusion Mail tag at: http://www.coolfusion.com/moreinfo.cfm?Product_ID=39 and the ActivMail tag at: http://www.cfdev.com/jmail/ __ Get the mailserver that powers this list at

Stored procedures & pdfs

I am switching over from using cfquery to stored procedures for my large jobs. In one of those I am filling in a pdf with report card information. I am unable to get the sp to show more than one report card (out of a whole class/grade). With the cfquery I set it up with many little queries (ie:

special characters

CFDJ'ers: When trying to add characters like ñ and Ñ, my SQL 7 server tells me I have not enclosed my strings properly. I'm assuming the tilde is breaking it. Any way around that, other than looking for that character and replacing it, with say the HTML equivalent that works? Or will I just have

RE: Time Issue

from the docs: "NOW: Returns the current date and time of the computer running the ColdFusion server" christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: Time Issue

Are you sure about that? When we use #Now()#, it gives use the time on our server .. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 20

RE: Time Issue

Also make sure you have the correct time zone selected. -- Sam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:52 PM To: CF-Talk Subject: Re: Time Issue checked smtp server time and it is right as well. - Original Message -

Re: Time Issue

I know that Now() uses GMT. If this is the case, do you know how to avoid this. - Original Message - From: "Marlon Moyer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 2:50 PM Subject: Re: Time Issue > Is it GMT time by chance? > > - Original Mes

Re: Time Issue

checked smtp server time and it is right as well. - Original Message - From: "VAN VLIET, SCOTT E (SBCSI)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 2:48 PM Subject: RE: Time Issue > Are your web server & smtp server on the same box? If not, then

RE: Time Issue

You might want to check the SMTP servers date/time Joseph DeVore VeloxWeb Technologies -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:46 PM To: CF-Talk Subject: Time Issue I am using cfmail to send some emails - when I receive the

Re: Time Issue

Is it GMT time by chance? - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 3:45 PM Subject: Time Issue > I am using cfmail to send some emails - when I receive the email it says it > was sent at 1:30 this morning instead of th

RE: Time Issue

Are your web server & smtp server on the same box? If not, then this time may be coming from the smtp server. HTH -- SCOTT VAN VLIET SENIOR ANALYST SBC SERVICES, INC Tel: 858.886.3878 Fax: 858.653.6763 Email: [EMAIL PROTECTED] -Original Message- From

Time Issue

I am using cfmail to send some emails - when I receive the email it says it was sent at 1:30 this morning instead of the appropriate time this afternoon (that I sent it). The system time is correct. Any ideas? Thanks __ Your ad

RE: Screen width, Height, & Color Depth

You will need to have a listener page grab the screen properties via JS, then send those to a CF page, then go to the index page as if they were entering the site. You can also base this on session state - so that if this is the users first request for a particular session. EXAMPLE (in you "appl

RE: Screen width, Height, & Color Depth

Send to him privately, or post a link to the files. CF-Talk does ( or used to, at least ) wipe out all attachments before sending posts to the list. At 04:12 PM 3/25/2002 -0500, you wrote: >can you attach files to post to the mail list? I keep getting my email sent >back to me when I attach

RE: Screen width, Height, & Color Depth

test.htm Untitled function GetWHC(){ //alert(screen.colorDepth); //alert(screen.availWidth); //alert(screen.availHeight); myURL = "insert.cfm?width=" + screen.availWidth + "&height=" + screen.availHeight

RE: Screen width, Height, & Color Depth

I need to obtain this info when someone enters the site. Thanks, Jason Larson -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 2:06 PM To: CF-Talk Subject: RE: Screen width, Height, & Color Depth opps forget the first half: can you use:

RE: Screen width, Height, & Color Depth

can you attach files to post to the mail list? I keep getting my email sent back to me when I attach files for a solution to his question. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: Monday, March

CF & Quickbooks?

Hi Anyone out there know of a ODBC driver for quick books? I have been looking and found one for $188 from http://www.massinissa.com/ But I've heard mixed reviews and I haven't heard back from their tech support to see if anyone using CF can make it work. I'm just building a reporting package

RE: Screen width, Height, & Color Depth

opps forget the first half: can you use: document.write(''); document.write('Java wiz please contact me off list

2002-03-25 Thread Robert Everland

If anyone is any sort of java wiz please contact me off list, I am trying to make cf read images through java and get height, width, and maybe even resize it if I am lucky. Please email me off list or through instant messenger bassman696. Robert Everland III Dixon Ticonderoga Web Develope

RE: Screen width, Height, & Color Depth

2002-03-25 Thread Sam Roach

can you use: #screen_height# #screen_width# #screen_colors# -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:49 PM To: CF-Talk Subject: Re: Screen width, Height, & Color Depth You will have to have one form page that

Re: Screen width, Height, & Color Depth

2002-03-25 Thread BEN MORRIS

You will have to have one form page that they come to and have JS write the values in a hidden form field, then have that submit to an action page, after which you will have the values to use in CF. Of course, you can't capture this in all browsers. More JS help: http://www.webreference.com/js

RE: Screen width, Height, & Color Depth

2002-03-25 Thread Jason Larson

What I am trying to do is building my own log file that logs the client data into a txt file so then I can store it into a database. I have tried using the custom tag at the developer exchange and I can't get it to work right, for what I want. Thanks, Jason Larson [EMAIL PROTECTED] www.larzz.com

Re: Testing Software

2002-03-25 Thread Dick Applebaum

Both of these emulators are limited to Mac OS versions that are so old that they will be of little use... You likelywill not find anyone with these old OS's accessing your web site. HTH Dick On Monday, March 25, 2002, at 07:23 AM, Albrechtas, Adam wrote: > http://www.emulators.com/sof

RE: Screen width, Height, & Color Depth

2002-03-25 Thread Tony_Petruzzi

you do realize that once the CF page has been thrown to the user, there is not way to get it back and then reprocess it. What exactly is your goal? Maybe I have a JavaScript function that could help you. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- F

Screen width, Height, & Color Depth

2002-03-25 Thread Jason Larson

I have very little javascript experience and what I am trying to accomplish is to use javascript to give me the height, width and color depth of a user's browser and turn those javascript variables into a CF variable so I can use them in a cf template. I was wondering if anybody had any code snipp

RE: City database...

2002-03-25 Thread Tony_Petruzzi

Does anyone know if CF will ever make it so that cfinput will use the focus event on an error? this is the only thing that prevents me from using it and I hate writing JS ;). Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org ___

RE: City database...

2002-03-25 Thread Yager, Brian T Contractor/NCCIM

Is there anyway I could get that from you? Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:13 PM To: CF-Tal

RE: City database...

2002-03-25 Thread Eric J Hoffman

We have one that is city, state, zip. That's it. Not sure where we got it. -Original Message- From: Yager, Brian T Contractor/NCCIM [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:03 PM To: CF-Talk Subject: City database... I know a few of you had country/state databases (a

WAP & CF - 500 error

2002-03-25 Thread Tony_Petruzzi

anyone know why I would get a 500 internal error when trying to use cf and wap? I have the cfcontent mime declaration at the top of the page. this is my first wap application. Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org _

RE: cfx_image memory problems

2002-03-25 Thread Brunt, Michael

Brook, in a word yes it could. Unlocked cfx_'s and unlocked application-session vars can cause all kinds of curious instabilities. Just give cflock a try to see if it helps. Mike Brunt Sempra Energy 213.244.5226 "An elephant is a mouse with an operating system." -Original Message-

studio issue creating files in file explorer

2002-03-25 Thread Robert Gatton

Not often, maybe 10% of the time I try to right click in studio's file list and 'create file here' I get a message box 'system could not find the specified path' or similar and the create fails but an untitled.cfm is created in the folder. Not really a major problem but a hassle I could do without

RE: cfx_image memory problems

2002-03-25 Thread Robert Everland

Yeah, just think of windows 95. Single user app, memory issues all over the place. All those BSOD (blue screen of death) error messages were because of memory issues. Microsoft should have used cflock, j/k on that one, but it's how the program runs in memory is where your problem is, so if they ar

City database...

2002-03-25 Thread Yager, Brian T Contractor/NCCIM

I know a few of you had country/state databases (and you sent me one)...Buy does anyone have a city database as well? If not, any leads as to where I might go? Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 _

RE: cfx_image memory problems

2002-03-25 Thread Brook Davies

Thanks Guys. I will try that, but right now, the app is a single user app, so could this really be the problem? Brook At 10:32 AM 25/03/02 -0800, you wrote: >Robert you hit a very important point. In my experience as an Allaire >consultant I found many instances where unlocked cfx_ tags were c

CFGrid Enhancements/Replacement?

2002-03-25 Thread Shawn Grover

We have a need for a grid that will allow hiding/showing columns, adding new rows, displaying query results, capturing click and double click events, and summing columns together with the result in another column. Preferably without requiring the user to load the Java 2 runtime environment. All

RE: Reading ID3-Tags w/ColdFusion

2002-03-25 Thread Rick Osborne [mojo]

I wrote a CFX tag that parses out ID3v2 tags, but it is more Prrof-of-Concept that production-quality. It comes with full source, so you are welcome to hack on it to do what you want. http://www.rixsoft.com/ColdFusion/CFX/MP3Dir/ HTH, -R -Original Message- From: VAN VLIET, SCOTT E (S

RE: cfx_image memory problems

2002-03-25 Thread Brunt, Michael

Robert you hit a very important point. In my experience as an Allaire consultant I found many instances where unlocked cfx_ tags were causing major memory corruption issues. It is a good policy to always use cflock around cfx_ tags, just in case. Mike Brunt Sempra Energy 213.244.5226 "An eleph

cached excel file?

2002-03-25 Thread Attley, Simon (CMG-SF)

Hi all, I have an absolute link to an excel file on our server. When you right click the link to the file and do a Save Target As, the saved file always appears to be cached (I know because the data is different from the file that I have uploaded to the server). However if you click the link and

RE: cfx_image memory problems

2002-03-25 Thread Robert Everland

Have you tried using cflock around the tag? The tag may not be thread safe, so locking it would allow only one person to access it at a time. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent:

Re: cfqueryparam question

2002-03-25 Thread Brook Davies

Has any one had any memory leak problems with cfx_image tag? I haven't been able to pin our server issues on the tag yet with 100% certainty, but it seems as though making about 3-4 consecutive calls to the tag is causing the cfserver to become unresponsive (timeout). Anybody have any similar

RE: cfqueryparam question

2002-03-25 Thread Robert Everland

This AND title LIKE Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Jen Perkins [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:08 PM To: CF-Talk Subject: cfqueryparam question When you are doing a sql query with a LIKE statement:

cfqueryparam question

2002-03-25 Thread Jen Perkins

When you are doing a sql query with a LIKE statement: ..AND title LIKE '%#TRIM(FORM.criteria)#%' Should you do this: ..AND title LIKE OR this? ..AND title LIKE '%%' Many thanks in advance. Jen Perkins Macromedia Certified ColdFusion Developer Carol/Trevelyan Strategy Group Phone: 925.432.4

RE: Client variable security (Re: The trouble with cookies ...)

2002-03-25 Thread Chris Norloff

Good code. We use something just like that, so our cookies expire when all the browser windows are closed. Also, we use client.CFID and client.CFTOKEN so we don't have to lock. CF makes CFID and CFTOKEN available in both session and client scope. Chris Norloff -- Original Message -

Looped CFTRYs to re-attempt query?

2002-03-25 Thread Jamie Jackson

(Newsgroup folks: Sorry about the repeated post.) I'm having a very intermittent MSSQL connection problem when using OLEDB connections: OLEDB Error Code = 18456 Login failed for user 'myLogin' The only recommendation I have been given on CFTALK is to disable "maintain db connections" in the adm

RaidenFtpd

2002-03-25 Thread Critz

oi CF-Talk,!! does anyone here use raidenftpd ? I've got a stats application, I'd like to get some opinions on. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - __ Your ad could be here. Monies from ads go to

Re: OT: count(distinct) in MS Access

2002-03-25 Thread Richard Meredith-Hardy

I think this is right An Access DISTINCT = DISTINCTROW ie ACCCESS only accepts SELECT DISTINCT [combination of values of all columns in each row you are outputting] This is not such a big problem (unless it is a subquery) as you can do a SELECT DISTINCT count(unique_keyvalue) AS mycount, c

RE: Random CF Service Spikes

2002-03-25 Thread Mark A. Kruger - CFG

Gary, Ok - that would indicate you have a process that is hanging (revelation eh? ), and is unable to complete - therefore returning a "busy" message. As far as your cluster, are these 2 servers exactly alike? Does one do anything that the other one does not (directory replication, ODBC connecti

RE: Random CF Service Spikes

2002-03-25 Thread Houk, Gary

When looking in the CF logs, it gave me a couple of NT errors. Here is what I found in the Event Viewer for the two different types of errors: Cluster (cpenetcluster) SERVER WARNING: In the last hour Server (cpenet.verizon.com) has been in the BUSY State 3.7778 percent of the time A server ab

RE: Two_SelectsRelated problem - Help!

2002-03-25 Thread Cornillon, Matthieu

Frank, I've been working with CF_TwoSelectsRelated in the last week or so, so I could probably help, but I'd need more detail. Please post your SQL query and your CF_TwoSelectsRelated statement. Also, as a first try before you post all that: make sure that your query results are sorted by whate

RE: Random CF Service Spikes

2002-03-25 Thread Mark A. Kruger - CFG

Gary, A few seconds is not aberant behavior (even for virgin install with no load). 10 minutes however is a concern. What is happening on the server when this is going on? Have you saved off a perfmon log file for analysing? And do you have a baseline log for normal behavior? Getting your arms

RE: Random CF Service Spikes

2002-03-25 Thread chris.alvarado

just went through a similar issue here. Although we WERE running CF 4.5 Eventually we narrowed it down to a Verity issue. People were uploading files that were in excess of 20MB and while trying to index this file, CF would hog nearly 100% of server resources. the solution I came up with was bu

RE: Two related drop-downs

2002-03-25 Thread Declan Maher

Check out http://www.webtricks.com/SourceCode/ Heres the code. If you need further details go there. SELECT S.State, S.StateCode, AC.AreaCode FROM States S, AreaCodes AC WHERE S.StateCode = AC.StateCode ORDER BY S.State, AC.AreaCode SELECT AreaCode FROM AreaCodes ORDER BY AreaCode