Re: Need 2 elegant Queries

- Original Message - From: "Kennerly, Rick H CIV" <[EMAIL PROTECTED]> > 5 separate "ads" that run for a week each and rotate each Monday morning. I > need to run ad 1 for a week, then ad 2 for a week, ad 5 for a week, and > then recycle to ad 1 for a week again. These are actually meal

Re: SQL Database "Decimal" problem

Check the scale and precision? CC "Les Mizzell"

Re: MX Hosting

http://www.dmv.com (Delmarva Online) currently has 2 CFMX Servers (Linux) with either SQL or mySQL support. Cutter Robert Bailey wrote: > This is a multi-part message in MIME format. > > --=_NextPart_000_0065_01C29BAD.12311810 > Content-Type: text/plain; > charset="us-ascii" > Conten

RE: MX Server installs and Microsoft Security Toolkits

Hey Dave, Do you have any more info on URL scan specify about preventing URL variables from being received by CF? Is this only the case for extremely long URLs or URLs that contain odd ASCII? I am just about to deploy two new servers next week and I would hate to have a problem with not being ab

CSS Print Styles

Has anyone had any experience using CSS print styles to 'neatly' print out a catalog of products? Usually 2 rows of 5 products consisting of an image(100x100) and product number/description. Any good examples available to build on? Thx, Dave HTC Disclaimer: The information contained in this m

RE: MX Server installs and Microsoft Security Toolkits

Hear Here. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:07 AM To: CF-Talk Subject: RE: MX Server installs and (the key to your security issue

RE: MX Server installs and Microsoft Security Toolkits

> Microsoft provides a whole bunch of Security Toolkits > to help lock down a server. For example there is the > "Microsoft Baseline Security Analyzer". Some of these > tools "blindly" goes in and locks down a bunch of stuff > that you are not aware of. You should be very reluctant to make "bl

Re: Is Coldfusion REALLY multi threaded?

Checking the Limit Simultaneous Requsts box, and setting it to 10 certainly has no effect. One connection doing the query, everyone else just stuck. Interestingly, they make the connection to the database (I can see them attempting to log in, which they do as a different user), but they get no res

Re: Need 2 elegant Queries

Have a table with the fields, ItemID, AdBeginDate, AdEndDate, ItemDetail, AdDate (if needed) Then just write a query to check what todays date is and what Ad/item should be displayed depending on where todays date falls within the AdBeginDate and AdEndDate. Just be sure to that add dates do not o

RE: Is Coldfusion REALLY multi threaded?

Fully agree with you there Dave, like yourselves at Fig Leaf we are often involved in load-testing big web apps and that setting should be nowhere near 40 unless this is 6 processor box. You are totally right the actual number per processor is determined by the results of controlled and monitored l

Re: Need 2 elegant Queries

oops.. messed that up. something like: julian date / 7 mod 5 I think will do it.. At 01:37 PM 12/5/2002, you wrote: >One possible solution is to convert the current date to a julian >date, mod 5 and that is your "week number". >Al ~

Re: SQL Database "Decimal" problem

Creating a Decimal data column types take two arguments: precision and scale. Check to make sure that you have declared your column properly... More.. CREATE TABLE FOO( myDecimal DECIMAL(5,4); ) Would generate a column that stores data like so 1.2345 >From the SQL SERVER Books OnLine: p (prec

Re: Need 2 elegant Queries

One possible solution is to convert the current date to a julian date, mod 5 and that is your "week number". Al >Query 1. > >5 separate "ads" that run for a week each and rotate each Monday morning. I >need to run ad 1 for a week, then ad 2 for a week, ad 5 for a week, and >then recycl

Exchange Address List

Is it possible to get the usernames and email address from a local Exchange server using CF? thanks, Luis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lis

Re: SQL Database "Decimal" problem

Set the scale to something other than 0. -- jon mailto:[EMAIL PROTECTED] Thursday, December 5, 2002, 1:20:44 PM, you wrote: LM> Hi, LM> 1. Field data type is defined as "Decimal" LM> 2. Insert/Update from form "1.234" LM> 3. Look in database - value written is "1". LM> It's getting truncated

Strange characters appearing in emails?

This may not be cfmail, but the issue is hard to diagnose, so I'm wondering if anyone else has seen this before I start digging. Using MX, I am seeing to the string "Â Â" appended to one line in one particular html email. Here is where it gets strange though. When I look at the email in

SQL Database "Decimal" problem

Hi, 1. Field data type is defined as "Decimal" 2. Insert/Update from form "1.234" 3. Look in database - value written is "1". It's getting truncated Suggestions? Thanks... ~| Archives: http://www.houseoffusion.com/cf_lists/ind

RE: Is Coldfusion REALLY multi threaded?

> At the moment, limit simultaneous requests is not ticked - > perhaps I should and set it to 40. I'll try it and let > you know. Setting it to forty would probably not be an especially good idea - that's an extremely high value. CF is designed to take advantage of queuing requests - some number

CFMX/SQL Error

I am getting a very non-descript error in CFMX when doing a query on query. Has anybody seen this error before? I have posted the CFMX/SQL code below as well. Thanks - Error Message - Error casting an object of type java.lang.boolean to an incompatible type. This usually indicates a p

RE: Is Cold Fusion REALLY multi threaded?

> Subject: Is Cold Fusion REALLY multi threaded? Yes, it really is. > If I execute a killer query (one that takes, say 2 > mins for the database to return the result set) from > a coldfusion page, then all other cold fusion users > are left hanging until the query has returned it's > result s

Need 2 elegant Queries

This is classic me. I've promised myself into a corner and demoed something hard coded without thinking about how to construct an elegant query to feed it in production-mode via a database. Query 1. 5 separate "ads" that run for a week each and rotate each Monday morning. I need to run ad 1

RE: Switch in MX

Yeah, you are right. Its been addressed. Thanks -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 17:32 To: CF-Talk Subject: Re: Switch in MX > > ST.st_trdate > ST.st_trdate DESC > IN CF5.0 it is OK but in MX it probably takes

Fw: Is Coldfusion REALLY multi threaded?

moving the CF server onto another box was indeed the next line of attack, until I saw that if the query was executed from outstide CF, then other users, invluding CF users couls access the DB fine. It's definitely not table locks unless the DB puts the lock on when the query comes from CF, and not

Re: Fw: Is Coldfusion REALLY multi threaded?

I don't know if this is what you were looking for, but here it is: The thing is, I know there is plenty I can do to make these queries run faster - it is just a general question: why does CF just hang for all the other users when this query is executed from a CF page, and not when executed from t

CF Connection = License Used?

Can anybody tell me how CF's use of a database connection works as far as license compliance is concerned? Say if a client has 10 licenses and CF is set to allow 10 Limit Simultaneous Requests, is it possible to "gobble up" all the licenses and lock other users out? I don't really understand this

Re: deadlock errors

This has nothing to do with CF, so locking your queries and sp calls won't help you. The deadlocks are probably occuring because a user is trying to read at the same time someone else is trying to write, or vice versa, or two people are trying to write to the same record at the same time, etc, e

RE: Is Coldfusion REALLY multi threaded?

Hi Stephen, 40 is an awfully high setting for Limit Simultaneous Requests, we typically recommend you set that to 3-7 * per CPU, with 7 being on the high side. Regards, Christine Lawson Macromedia -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: Thursday, Decem

RE: Switch in MX

That's true, it is -Original Message- From: Ryan Kime [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 17:37 To: CF-Talk Subject: RE: Switch in MX Wasn't that addressed in the CFMX updater? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Thursday, Decem

Fw: Is Coldfusion REALLY multi threaded?

How your's works is how I would have expected. At the moment , limit simultaneous requests is not ticked - perhaps I should and set it to 40. I'll try it and let you know. - Stephen Richards 020 7903 3226 -- - Original Message - From

RE: Switch in MX

Wasn't that addressed in the CFMX updater? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:22 AM To: CF-Talk Subject: Switch in MX ST.st_trdate ST.st_trdate DESC IN CF5.0 it is OK but in MX it probably takes 1D as

Fw: Is Cold Fusion REALLY multi threaded?

That is interesting. However, I wonder just what effect it will have in this case, because the long page is executing a SERIES of 6 long queries (it is producing a page of stats), and all CF activity stops until all six queries have been executed. If the blockfactor was going to release the CF s

Re: Switch in MX

> > ST.st_trdate > ST.st_trdate DESC > > IN CF5.0 it is OK but in MX it probably takes 1D as "1.0" so gives error > saying DUPLICATE CASE VALUES. How can I sort this thing out now. If that's the case, then it's a bug and it should be reported, however, I think you need # symbols

Fw: Is Cold Fusion REALLY multi threaded?

Yes, I agree with you, we are denormalizing like mad and retuning the database, and am confident that we will get the two minute query down to something more manageable. yes, the CPU maxes out at 99.9% while the query is executing. However, that doesn't alter the fact, that if the query is execut

Switch in MX

ST.st_trdate ST.st_trdate DESC IN CF5.0 it is OK but in MX it probably takes 1D as "1.0" so gives error saying DUPLICATE CASE VALUES. How can I sort this thing out now. Regards Shaz ** This email and any file

RE: Is Coldfusion REALLY multi threaded?

..with regards to the long query...we have an app that has several queries that run quite long, a couple in the 3 or 4 minute range. These do not bring my CF server to a halt at all. We average almost 200 users per hour on busy days on this box. Have a look at all your CFAdmin settings. Yo

deadlock errors

Hey, been getting the page of DOOM on our development server over the last couple of weeks, I am properly locking all queries and stored proc calls but still it creeps in, averaging 2 a day. error desc: [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #20) was deadlocke

Cfpop

Hey Is there any way of returning the size of a message using cfpop? Also is there any way of returning whether the email has an attachment using the GetHeaderOnly action ? Using the getall action seems over kill for a simple is there an attachment or not query... Ryan ~~

Using CfQuery

I am trying to do a cfquery without setting up a DSN on the CF Admin. I am using CF 5. I pasted the code that I am using below. It works fine in most instances however, when using a query that uses the CreateODBCDateTime I get an error: Malformed GUID. in query expression. I am using Access 97

Re: Fw: Is Coldfusion REALLY multi threaded?

Stephen Richards wrote: > - Original Message - > From: "Jochem van Dieten" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, December 05, 2002 4:14 PM > Subject: Re: Is Coldfusion REALLY multi threaded? > >>And how many of them are idle? > > how do I tell which one

RE: Is Coldfusion REALLY multi threaded?

It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free. Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the

RE: CFX_Image - Quality of images not good when rotating

Agreed. It's in PHP. You can do all kinds of cool manipulations in either the GD or ImageMagick libraries without any funny business. -- jon -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:53 AM To: CF-Talk Subject: Re: CFX_Imag

Fw: Is Coldfusion REALLY multi threaded?

- Original Message - From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 4:14 PM Subject: Re: Is Coldfusion REALLY multi threaded? > Stephen Richards wrote: > > > > We have 24 connections at the moment, as reported by the datab

Re: Personaliztion with Coldfusion ?

Hi I have just been trying what you suggested, and it works but not 100% as of yet. If the login is successfull I set a session variable in the login check page 'the division variable is from the itadmin table' and contains teama, teamb values. Then in the actual linkdisplay page I use the fo

Re: Is Coldfusion REALLY multi threaded?

Stephen Richards wrote: > > We have 24 connections at the moment, as reported by the database. (can't > use netstat because the CF server is running on the same machine as the > database, so it's a unix socket rather than port 5423. And how many of them are idle? In the mean time you might want

RE: MX Hosting

>>Rob, I have had a couple CFMX sites with www.hostmysite.com for almost a >>year now and it's been a wonderful experience so far, and fairly cheap Are you using shared hosting? if so, that is odd, as when I inquired about their CFMX hosting I was told they did not allow (presumably createObject

Re: Please help me achieve this with CF and Javascrip please

I was more suggesting that you could learn from the code in the ThreeSelects tag and apply it to what you have now. I initially looked at slimming the code down and then decided it would be good to go stock. I also have a small amount of HTML to put between the selects for my use. As for the

RE: Is Coldfusion REALLY multi threaded?

OK, next step is to check the number of database connections you actually have. Easiest is if you are only using one datasource on that particular server, just run a netstat and check the number of TCP connections to port 5423. Else, start working from the database side, use the standard tools to d

Re: Please help me achieve this with CF and Javascrip please

I have used the three select related tag and agreed it works quite well, nate has done a good job. However there is a lot of code bloat with that tag i.e. there is a lot of javascript product that you do not use, and the control you have over the page is not as great as if the webtricks version ha

Re: cfmx and FORM file oddity

The variable you want to call is actually #File.ServerFile# This is the default name assigned by CF to any just uploaded file. There's also a host of other available attributes. Check the docs for more info. hth, ~Val - Original Message - From: "Jaye Morris - jayeZERO.com" <[EMAIL P

RE: cfmx and FORM file oddity

You might want to try something like this instead: File to upload: File uploaded successfully: Filename on client: #cffile.clientfile# Filename on server: #cffile.serverfile# File Size: #cffile.filesize# File successfully moved to D:\Junk\#cffile.serverfile# Peter Bagnato

RE: Is Cold Fusion REALLY multi threaded?

Another thing to check, in Select queries are you using the Blockfactor = x (x being a number between 1 and 100). Using Blockfactor causes CF to bring back blocks of results. Mike Brunt - CTO Webapper Services LLC Blog - http://www.webapper.net Downey CA Office 562.243.6255 AIM webappermb Web Ap

RE: Please help me achieve this with CF and Javascrip please

Look here http://www.happyhacker.com/Code.cfm?Cat=CF&SubCat=2_3Slcts#StartHere WebGuy > -Original Message- > From: Ian Vaughan [mailto:[EMAIL PROTECTED]] > Sent: 05 December 2002 15:15 > To: CF-Talk > Subject: Re: Please help me achieve this with CF and Javascrip please > > > Hi > > I th

Re: Please help me achieve this with CF and Javascrip please

I posted a link to the Three Selects Related tag. It does the same thing that you are looking for. Perhaps you might try downloading it and reading through the code of the tag to find the answer to your question. Hatton Ian Vaughan wrote: >Hi > >I think you will find it is more difficult the

Re: Please help me achieve this with CF and Javascrip please

Hi I think you will find it is more difficult then you may think... I am using the sample code from webtricks.com. Their default is two selects - what I need to find out is where to add javascript and coldfusion to build arrays for the third select box This is the actual code for two selects, n

Re: Lists vs. Arrays vs. Structures

Michael Dinowitz wrote: >>isn't structkeyexists better than structfindvalue? as our jedi friend >>says, after not evalutating, cflocking I think that's his next biggest tip > > It's better if you just want to know if the value exists. I need to know where > it exists. > > >>my experience is that

Re: CFX_Image - Quality of images not good when rotating

Man, this is the never-ending, and ever-recurring, thread...but I have to try and ask a summarizing question, because after all these posts and replies I still don't have a solution to my personal problems. The perfect tag/function I'm looking for needs to be able to: 1) Get dimensions from an im

RE: cfmx and FORM file oddity

How are you getting this ? > R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp1 > 6991.tmp This looks like the tmp file created before Show us your blahblahblah.cfm template WG ~| Archives: http://ww

RE: Please help me achieve this with CF and Javascrip please

Which situation do you want? 1) Select A choice affects Select B choices Select B choice affects Select C choices (C depends on B depends on A) Or 2) Select A choice affects Select B choices and Select A choice affects Select C choices as well (C and B

cfmx and FORM file oddity

I am using something relative to the following code: During the process, I am attempting to catch the variable "uploadedFileName," but instead of getting a file name like myfilename.zip or whatever, I get something like: R:\CFusionMX\runtime\servers\default\SERVER-INF\temp\w

Re: Is Cold Fusion REALLY multi Threaded?

Stephen Richards wrote: > > Limit connections is not checked, however the value is 0. OK, next step is to check the number of database connections you actually have. Easiest is if you are only using one datasource on that particular server, just run a netstat and check the number of TCP connec

Re: MX Server installs and Microsoft Security Toolkits

David Adams wrote: > > I noticed in the Security Section of the > Macromedia that the white papers that still have the Allaire Logo > stamped on them with dates such as 2001. Hope Macromedia is a little > more serious about security than this. It does not help the CF cause. Security is a matte

RE: Is Cold Fusion REALLY multi threaded?

Date: Thu, 5 Dec 2002 10:25:39 - From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> Subject: RE: Is Cold Fusion REALLY multi threaded? Message-ID: Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a ti

Follow-up on the one-site for many businesses discussion

Not sure I'm totally understanding problem, but sounds like you may be trying to use some settings that apply to all the *sites*, such as for a parent business. Since you are defining application as unique to each site, don't think you can mix parent and child in application variables. In this d

Re: Is Cold Fusion REALLY multi Threaded?

Date: Thu, 05 Dec 2002 11:41:28 +0100 From: Jochem van Dieten <[EMAIL PROTECTED]> Subject: Re: Is Cold Fusion REALLY multi threaded? Message-ID: <[EMAIL PROTECTED]> Stephen Richards wrote: > > For the record, the applicable CF Admin settings ara: > - Single Threading: not checked > - Variable Scop

RE: Please help me achieve this with CF and Javascrip please

It really shouldn't be difficult at all... what problems are you running into? have you got some semi-working code at all? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 14:08 To: CF-Talk Subject: Re: Please help me achieve this with CF and Javascrip

Re: Please help me achieve this with CF and Javascrip please

Just wondering if anybody else could shed some light on if this can actually be accomplished?? There must be a way of adding a third select dynamically to this code? I have been looking into it all morning with no success as of yet, but would be interesting to hear views from the experienced profe

RE: MX Server installs and Microsoft Security Toolkits

No, as I *never* use the out of the box lockdown tools, I will always follow the manual instructions... sorry, -Original Message- From: David Adams [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 13:51 To: CF-Talk Subject: MX Server installs and Microsoft Security Toolkits Microsoft p

MX Server installs and Microsoft Security Toolkits

Microsoft provides a whole bunch of Security Toolkits to help lock down a server. For example there is the "Microsoft Baseline Security Analyzer". Some of these tools "blindly" goes in and locks down a bunch of stuff that you are not aware of. Has anyone had problems running CFMX after applyi

RE: Verity size constraint?

Check the archives for post about indexing database queries with Verity. A couple people have run into some sort of nebulous limitation with it where it will not index past a certain amount of records. Sometimes this limit is 5,000sometimes its 10,000it fluctuates. In short, there's some

RE: init and destroy

While the methods you mention are page specific, I think you can accomplish what you want by using Application variables. Ie: (and this is non-locked mx code) However - there is no way to catch the expiration of the application scope, and as I said, what you want is page specific, and

RE: Lists vs. Arrays vs. Structures

> > isn't structkeyexists better than structfindvalue? as our > jedi friend > > says, after not evalutating, cflocking I think that's his > next biggest > > tip > It's better if you just want to know if the value exists. I > need to know where it exists. Michael is correct here. StructFindVal

Re: Flash MX mailing list

flashcfm.com was before devmx.com and a good source - same guys I believe. Probably so far the most dedicated to coldfusion and flash - not many others out there that address coldfusion specifically - jay miller Stacy Young wrote: http://www.devmx.com is a good place to

Re: Is Cold Fusion REALLY multi threaded?

Stephen Richards wrote: > > For the record, the applicable CF Admin settings ara: > - Single Threading: not checked > - Variable Scope Lock settings: all set to no automatic checking or locking > > Is there anything else I need to set? For the datasource, what do you have for "Limit simultaneou

RE: Is Cold Fusion REALLY multi threaded?

Yes, ColdFusion Server is multithreaded; AFAIK, CF does not simply call one DB call at a time, that would be utterly ridiculous and a waste of time! What are your servers specs? Memory etc..? Neil -Original Message- From: Stephen Richards [mailto:[EMAIL PROTECTED]] Sent: 05 December

Is Cold Fusion REALLY multi threaded?

Please, someone tell me that there is a configuration option I have wrong. If I execute a killer query (one that takes, say 2 mins for the database to return the result set) from a coldfusion page, then all other cold fusion users are left hanging until the query has returned it's result set.. I

Re: Lists vs. Arrays vs. Structures

Thanks for the note. I'll test list sorting and the like next. > Michael Dinowitz wrote: > > > > On the whole, unless you see a need to, I'd stick with using lists in CFMX. I > > have heard of people who have seen some major slowdowns due to lists and I'd > > love to hear the specifics. > > Anythi

Re: Prevent include from caching?

Matt Kornguth wrote: > Is it possible to prevent an included template from caching without preventing the >parent template from caching? If you are talking client side caching: no, they are one request. Server side you can do anything you want. Jochem ~

Re: Lists vs. Arrays vs. Structures

Michael Dinowitz wrote: > > On the whole, unless you see a need to, I'd stick with using lists in CFMX. I > have heard of people who have seen some major slowdowns due to lists and I'd > love to hear the specifics. Anything that changes a long list (or string for that matter) is slow. It is real

Re: Lists vs. Arrays vs. Structures

> isn't structkeyexists better than structfindvalue? as our jedi friend > says, after not evalutating, cflocking I think that's his next biggest tip It's better if you just want to know if the value exists. I need to know where it exists. > my experience is that structures are always *way* faster

Re: Please help me achieve this with CF and Coldfusion please

Hi Bob Thanks that would be great if you could show me an example if I could see an example. Was your code generated from your database table like the one at webtricks? The three related selects I have used and although very good, I would rather use this approach as only one table can be used whe

RE: Known MX bug or have I found one? URL.threadID in CFLOCATION

Thanks for the test. The pasted "threadID" link worked some of the time, but the "tID" should always work (that’s the fix). But put the "threadID" in any CFLOCATION on an MX server and (I hope!) you'll see what I mean. Jim Davis > -Original Message- > From: Sean A Corfield [mailto:[EMAI

Re: Known MX bug or have I found one? URL.threadID in CFLOCATION

On Thursday, Dec 5, 2002, at 00:17 US/Pacific, Jim Davis wrote: > http://www.grapeaperacing.com/GrapeApeRacing/OpenForums/ > thread.cfm?threa > dId=165&forumID=21&confID=1 > > The weird thing is that this link produces a completely blank page - as > if the browser was never given a response (you c

Known MX bug or have I found one? URL.threadID in CFLOCATION

I'm in the unenviable position of trying to get the forum system from www.stickshiftsolutions.com to work on MX. (It's for my brother's racing site, www.grapeaperacing.com). I'm not pleased with it (many bugs, some outright omissions and really poor, I think, code). However the thing that I just

Re: CFMX application/session error

> Post the rest from the log ? Allright, here goes. 04/12 13:56:13 error Exception occurred invoking custom error page /WEB-INF/exception/java/lang/Exception.cfm java.lang.IllegalArgumentException: err.io.short_read at coldfusion.filter.FormScope.parsePostData(Unknown Source) at

<    1   2