this discussion list?
e
- Original Message -
From: Brad Roberts
To: CF-Talk
Sent: Wednesday, October 01, 2003 9:24 AM
Subject: OT: Freelance Sites
Anyone have suggestions on freelance sites (like rentacoder.com)?I need a
few websites designed, and didn't have much luck with
Hi all,
I'm looking at setting up a new CFMX installation and have been given
the option of Windows 2000 Server , or 2003 Server.
Which would be the safer option?
Not had having a great deal of experience with 2003 I was going to say
2000, but are there any significant advantages of 2003?
Had the same choice last week and went for 2003, MX doesn't have any
isues installing on either.
We went for 2003 as it's supposedly more stable/secure and is likley to
be supported longer.
Craig.
-Original Message-
From: Ryan Sabir [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003
Is it possible to gzip encode .js (as you can with text/html in http 1.1).
That could be an option then.
-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm
As one who is running servers in both configurations, I strongly recommend the
Win 2003 server.
First, it does not have the vulnerabilities that are found in Win2k, and do not
require patching anywhere near as often.
Second, Most services are default to OFF, which requires a little more attention
Personally I'd wait for SP1 before even thinking about it. However, if
I had some wiggle room (meaning huge client wasn't going to kill me if
the server had a few hiccups), and upgrading to 2003 in 6 months or so
didn't look likely...it might be worth it to bite the bullet now
rather than be stuck
That is total crap as Win2003 is based on WinXP code which was based on
Win2K code and as suchshares many of the same vulnerabilities.
Do not consider installing Win2003 to be as safe as an unpatched Win2K
installation.
-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED]
Sent:
You are incorrect.
Win2k supports IIS 5.0 and Win 2003 is IIS 6.0
There are patched vulnerabilities in IIS 5.0 which are not needed in Win2003 as
the release is a redesign.
For instance the ISAPIfilter URLScan is not needed on Win 2003.
This is not to say that one should not keep up with patches
I'm not sure how you can claim that Win 2003 do not require patching
anywhere near as often - the bad boy has only been out for a few
months!Give it a while - it may surprise us with many, many patches.
;^)
That being said I've been impressed with 2003 myself - I'm running it
now as a Virtual
Hello!
Using the popular mod_rewrite module I would like to offer simple entry
points to our website like
http://www.somewhere.com/go/customer1/
Internally, these requests should be redirected to
http://www.somewhere.com/gocustomer.cfm?customer=customer1
Using mod_rewrite I have declared the
On Thursday 02 Oct 2003 11:15 am, Peter Mayer wrote:
Any hints?
[P] ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
If I set my site wide DSN in the request scope will this be set every time a template is requested?
Should I put the following code in application.cfm
cfif Not IsDefined(Request.DSN)
cfset Request.DSN =mydsn
/cfif
Can you access the Request scope from inside CFC's?
-Original
Setting up CFHTTP, need to set the delimiter for a tab-separated file.
What is the proper syntax for specifying the delimiter as tab-separated?
Thanks, Mark
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
#chr(9)#
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: donderdag 2 oktober 2003 13:48
To: CF-Talk
Subject: Tab Delimiter
Setting up CFHTTP, need to set the delimiter for a tab-separated file.
What is the proper syntax for specifying the delimiter as tab-separated?
Thanks, Mark
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 7:54 AM
To: CF-Talk
Subject: RE: Tab Delimiter
#chr(9)#
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: donderdag 2 oktober 2003 13:48
To:
Looks like there might be a line monster somewhere. Here's this post
resent again.
Date: Wed, 1 Oct 2003 14:07:01 -0700
To: [EMAIL PROTECTED]
From: Bill Doerrfeld [EMAIL PROTECTED]
Subject: [Stats] Cold Fusion Talk List Stats; September 2003
Cc:
Bcc:
X-Attachments:
Greetings:
For those of you
This might help.
cfobject type=JAVA name=jFR class=java.io.FileReader
action="">
cfset jFRobj = jFR.init('c:/somefile.txt')
cfobject type=JAVA name=jBR class=java.io.BufferedReader
action="">
cfset jBRobj = jBR.init(jFRobj)
pre
cfscript
line = ;
while ( len(line) ){
line =
Still now seeing any stats
Dave
-Original Message-
From: Bill Doerrfeld [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 8:29 AM
To: CF-Talk
Subject: Fwd: [Stats] Cold Fusion Talk List Stats; September
2003
Looks like there might be a line monster somewhere.
Boy, either that line monster is a meanie or I'm going blind... i still don't see any stats
Mitch
Shameless plug for my wife's business:
http://www.mygccandle.com/showmescents
-Original Message-
From: Bill Doerrfeld [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 7:29 AM
To:
I'm working to retrieve a tab-delimited list of members from a remote server
using CFHTTP.
Problem is, the source list headers in the first row have spaces in between
some of the words.For example, first name.CFHTTP doesn't like column
names with spaces.I've tried specifying my own columns, such
This is better though.
cfobject type=JAVA name=jFR class=java.io.FileReader
action="">
cfset jFRobj = jFR.init('d:/sites/test/dates.cfm')
cfobject type=JAVA name=jBR class=java.io.BufferedReader
action="">
cfset jBRobj = jBR.init(jFRobj)
pre
cfscript
line = ;
while ( isDefined(line) ){
line =
That is total crap as Win2003 is based on WinXP code which
was based on Win2K code and as such shares many of the same
vulnerabilities.
Do not consider installing Win2003 to be as safe as an
unpatched Win2K installation.
The default install of Windows Server 2003 is much safer in many
Is there anyway to tell when the next time ColdFusion thinks (used
loosely) that a job is supposed to be run?
My problem is that I have a job that has a start date of Aug 6, 2003 and is
scheduled to run monthly at 4:00 am.It actually runs on the 1st of each
month at 4:00 am.
I also have
was it an attachment?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Bill Doerrfeld [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 8:29 AM
To: CF-Talk
Subject: Fwd: [Stats] Cold
I've had the same problem, but it isn't consistent. Never been able to track
it down to any one thing.
Steve
-Original Message-
From: David Delbridge [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 5:35 PM
To: CF-Talk
Subject: 'Enable Debugging' Option Turns Itself Off?
Okay, I give up. There's something going on with this listserver
which is preventing my post from going through in it's entirety. We
have searchable archives for this list which also provide detailed
stats on usage of this list. You can view reports on the number of
posts by author and thread
The bulk of the reasons that the default install is safer is that it turns off a lot of unnecessary services/etc. If you standard firewall/DMZ setup, you weren't really vunerable to external attack on those services anyhow. And running IIS Lockdown takes care of most of the rest...
So Windows
Ah ha!This explains a problem I've been hitting my head over.Thanks!
There are a number of subtle, yet significant differences between IIS 5
and 6 that I keep learning about and have made this Windows upgrade
challenging.All in all, though,I like the lock everything down by
default philosophy
I have a site that I have no access to the DB from work (SQL Server).I am getting an error with one of my queries.It looks as if the field is either not there or spelled wrong.Can anyone tell me how I can tell what fields I have for a table?
Thanks,
Brian Yager
President - North Alabama
Cold
you can use this: cfoutput#yourQuery.columnlist#/cfouput
that will dump a list of your fields.
Shawn Regan
Head Applications Developer
pacifictechnologysolutions
-Original Message-
From: cf talk [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 7:10 AM
To: CF-Talk
Subject:
I have a site that I have no access to the DB from work (SQL Server).
I am getting an error with one of my queries.It looks as if the
field is either not there or spelled wrong.Can anyone tell me how
I can tell what fields I have for a table?
Select column_name
From
oi cf!!
select top 10 * from table
cfdump var=#query#
or output query.columnlist
--
Thursday, October 2, 2003, 10:09:51 AM, you wrote:
ct I have a site that I have no access to the DB from work (SQL Server).I am getting an
ct error with one of my
I am a coder who has become responsible for managing my company's servers - so please know I am a little green here, and absolutely desperate.
After going crazy trying to update CFMX to CFMX 6.1 (and the mess that the failed upgrade left behind - CF was down), I uninstalled CFMX and did a fresh
Hi Folks,
I'm wondering if anyone's run into this before.We recently upgraded
one of our servers from NT4/CF 4.5 to Windows 2k/CF MX.One of the
applications running on the server uses a dynamically generated menu -
lots of _javascript_.Everything seemed to be running fine - until one of
our
On Thursday 02 Oct 2003 15:33 pm, Sutton Yamanashi wrote:
I don't know how to fix this. I am dead in the water until I figure this
out. I am trying to research the error message, but can't find the answer.
If you can, please help me.
Is IIS running ?
Are the CFMX adapters in place ?
Are you
Have you gone into IIS and made sure IIS is started? It's possible CFMX
stopped the service and didn't start it back up. Go to Start Settings
Control Panel then go into Administrative Tools and Open IIS. In there
you can tell if the web server is stopped or not.
Ben
-Original
1.Is IIS running ?
1A:The IIS Admin Service has status of 'started'.
2. Are the CFMX adapters in place ?
2A: I don't know.How do I determine this?
3. Are you fully patched with windowsupdate ...
3A:Yes.
Thanks for you help!
-sutton
-Original Message-
From: Thomas Chiverton
Check the front page of http://www.houseoffusion.com/
http://www.houseoffusion.com/Michael has some examples of problems and
solutions. I had the same thing happen to me when we upgraded. I bet the
solution might be something like this:
ODBC services do not start - This is an interesting error
Montara Software today announced the immediate availability of its
newest product, Black Knight, a powerful new .NET runtime extension
for Macromedias ColdFusion application servers.
Black Knight, priced at $199.95 per server, is the first CF extension
to allow ColdFusion developers to make
Where'd you find that out?
I've been looking through CFWACK for the CFQUERY tag, and I can't find
anything that mentions the columnlist variable for CFQuery.
Is there also some other variable that stores field type?
-Gel
-Original Message-
From: Shawn Regan [mailto:[EMAIL
We are using Windows Server 2003 Web Edition with ColdFusion MX 6.1
standard; similar setup to you in that it is a 1U hooked up to a more
powerful database server. Works really well and we like Win2k3 overall.
Matt
-Original Message-
From: John Paul Ashenfelter
[mailto:[EMAIL
On Thursday 02 Oct 2003 15:47 pm, Matt Liotta wrote:
http://www.montarasoftware.com/go/47f9e1e3-f448-1157-affb-e87c411e1c8f
What horriable URL's
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey
Dirk,
On 10/2/2003 at 10:35, you wrote:
DS I'm wondering if anyone's run into this before.We recently upgraded
DS one of our servers from NT4/CF 4.5 to Windows 2k/CF MX.One of the
DS applications running on the server uses a dynamically generated menu -
DS lots of _javascript_.Everything seemed
I checked it out as you suggested.It appears to be running.In Services,
the IIS Admin Service has status of 'started'.Isn't this the same thing?
Thanks!
-sutton
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 10:34 AM
To: CF-Talk
IIS's service name is World Wide Web Publishing Service, the admin
service is somethgin different.
-Original Message-
From: Sutton Yamanashi [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003 15:46
To: CF-Talk
Subject: RE: CFMX 6.1 on Windows 2003 = Service Unavailable !!!
1.Is
Is that something that really concerns you?
-Raymond Camden
-- Original Message --
From: Thomas Chiverton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Thu, 2 Oct 2003 15:49:55 +0100
On Thursday 02 Oct 2003 15:47 pm, Matt Liotta wrote:
From what I have been told from a Microsoft Rep if you are an Internet
service provider (WebHost) you are supposed to be running Web Addition. This
is because it is a stripped down version and does not require any CALs. The
full version will require CALs for all users accessing the server
After the install, make sure that both Web publishing and ColdFusion server is
running
if both are running, then open administrator, and it will then complete the Jrun
connectors, etc.
The service unavailable message is due to one of the services not running.
This is a issue with CFMX 6.1
You could always run an external scheduler, windows scheduled tasks
works fine for us, just fire off wget to a specific cf template, very
reliable.
Other than that, both your tasks are firing 5 days early each month,
which is mostly likely not a co-incidence, you sure the server date is
correct?
What horriable URL's
Why do you feel that way? What makes them horrible?
Matt Liotta
President CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
nothing that returns field type.
cfquery returns 3 'special' vars in addition to the actual database values.
1) queryname.columnlist - comma delimited list of column names
2) queryname.recordcount - the number of records returned from the query
3) queryname.currentrow - when cfoutputting over a
In some cases, a system reboot is required to get all services up and running.
After the reboot, check to see that CF server is running, and IIS is running.
If so, CF administrator should come up.
==
Stop spam on your domain, use our gateway!
For hosting
matt is entering those into the Obfuscated URL Contest :)
I had to. im sorry.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Thursday, October
My production server is running Win 2003 Enterprise.I have not tested Web
Edition or Standard edition.
==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all
On Thursday 02 Oct 2003 15:46 pm, Raymond Camden wrote:
Is that something that really concerns you?
Imagine me saying to my boss:
Hay, check out this bril new bit of thing we can use
That's nice, what's the URL and I'll look at it on my desk
Were you sending it as an attachment? The list strips out all attachments for
security. Can you send me the post you sent to the list so I can see what's up
with it. Thanks
Okay, I give up. There's something going on with this listserver
which is preventing my post from going through in it's
I'm confused... won't this just list the columns in your query? It doesn't list all of the columns in the table does it? (Which is what the original question was).
Mitch
Shameless plug for my wife's business:
http://www.mygccandle.com/showmescents
-Original Message-
From: Angel
I must admit, I'm with Thomas, I only like short, descriptive url's.
Personal preference maybe, but big long urls with lots seemingly random
characters do tend to annoy me.
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003 16:01
To: CF-Talk
Hmm..
So how would you determine the field type of the underlying table for a
query?
Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ?
-Gel
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
nothing that returns field type.
cfquery returns 3
Imagine me saying to my boss:
Hay, check out this bril new bit of thing we can use
That's nice, what's the URL and I'll look at it on my desk
w-w-w-.-montara-software-.com-/-go-/-9-d-5-8-a-5-9-e---d-...
Stop there, I'm too busy.
I completely agree with you, the URLs that I used in my email
All of a sudden cfdump stopped displaying formatting for me, anybody else
having this problem? Basically the text is all still there, but I lost my
precious tables and color-coding like so:
cfdumpinited TRUE
somestruct
struct
YOMAMMY blah blah
YOPAPPY [empty string]
YOSISTERTOO [empty
Heh, I don't typically tell my boss anything, I just IM or email it. ;) Guess I'm a spoiled telecommuter.
-Ray
-- Original Message --
From: Thomas Chiverton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Thu, 2 Oct 2003 16:03:53 +0100
On Thursday 02
Folks,
As I said in a previous post, I'm looking at Win 2003 Web Edition vs RedHat Enterprise ES 3.0 for a small farm of web servers. I'm comfortable with Apache, but since RH ES comes with the tux web server as well, which is part of what I assume I'm paying a premium for, has anyone used CFMX
On Thursday 02 Oct 2003 16:17 pm, Matt Liotta wrote:
Just to be clear, we have didn't URL formats that lead to the same page
and make use of those different formats for different reasons. In the
case of UUID-based URLs, we use those for public communication in email
and HTML since those URLs
Angel Stewart wrote:
So how would you determine the field type of the underlying table for a
query?
Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ?
That is why you should use the INFORMATION_SCHEMA. Just try
cfquery datasource= name=qColumns
SELECT *
FROM
Matt,
The price list is almost invisible...at least on my portable screen. Was
looking around for about 5 mins hehe.
Congrats on the release tho..good stuff.
Stace
_
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: October 2, 2003 11:01 AM
To: CF-Talk
Subject:
Not really sure why you'd need to, what with CF not being strongly typed...
I guess if the need arose, yes, you could probably whip up a UDF to loop over the columns of one of the rows returned, testing with the various functions you named...store that in a struct...with columnname as the key and
Thanks Critz!
This worked like a charm.
I'm alos going to look at what you recomended Philip.
Thanks to all!
Brian
oi cf!!
select top 10 * from table
cfdump var=#query#
or output query.columnlist
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Figures this thread would turn into a debate on 'clean' URLs. All that
aside:
Matt is there a developer's version I could mess around with?
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From:
yeah...matt?
is there?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 11:36 AM
To: CF-Talk
Subject: RE: Montara
Of course, it's your URL scheme, but why not just have one format, and
make it
the 'remember the URL' format :-) ?
Because history has shown that those URLs tend to break over time.
Matt Liotta
President CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
[Todays
Is that really how things go around your office? I didn't think that happened anymore..
You copy and paste a URL into an email, boss clicks on it, away he/she goes. I can't possibly imagine why the content of a reasonably lengthened URL would be of ANY concern in this day and age (short of
Matt is there a developer's version I could mess around with?
We are planning on making a 30-day evaluation available for download
from our site next week.
Matt Liotta
President CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
[Todays Threads]
[This Message]
There are some issues with both the HTML and the style sheets used with
CFDump (don't know about CFTrace but I assume it's the same story). In
short, they are incompatible with several different DTDs. You can
experiment with different DTDs or, as I do, just remove the DTD
declaration from the
cool.
and I know what we have read on the site, but what, give us a real live this
is what it could do type thing.
I have a .net guy here who, well, for the sake of argument, doesn't really
love cf like we do.(That's a nice as I
could say anything) anyway, can you give us a real world example? or
We are using CFMX 6.1 and Oracle 9i.How do we retain database row locks from one request (query of information to display in a HTML form) to the next (updating the information)?Data integrity is the concern of course...how to keep two users from updating the same record from the database at the
How can I lock a database row?Does anyone know any good examples of database locking everything accompanies it?
Thanks!
Scott
Scott Wilhelm
Computer Technician/Web Developer
http://www.sllboces.org http://www.sllboces.org/
[EMAIL PROTECTED]
Canton (Mon/Tue)
St. Lawrence-Lewis BOCES
PO Box
The price list is almost invisible...at least on my portable screen.
Was
looking around for about 5 mins hehe.
That has been fixed.
Congrats on the release tho..good stuff.
Thanks!
Matt Liotta
President CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901
I'd be much more interested in a discussion about the merits of the
new product than this other nonsense. Has anyone run through the
tutorials?
There have been over 50 downloads of the tutorial so far this morning,
so certainly others are reading it. It is my hope that the tutorial
will
A great site for oracle stufflike this is :
http://asktom.oracle.com/
Theres a great search engine and Tom seems to spend a lot of his time
answering questions.
-Original Message-
From: Ryan Geesaman [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003 04:46 PM
To: CF-Talk
Subject:
looking at it...thanks, just found that!
:) thanks!
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 11:55 AM
To: CF-Talk
and I know what we have read on the site, but what, give us a real
live this
is what it could do type thing.
I have a .net guy here who, well, for the sake of argument, doesn't
really
love cf like we do. (That's a nice as I
could say anything) anyway, can you give us a real world
Has anyone created a web page or more along the lines as a file to synch
a PDA with in order for someone to view Appt times from a CF
Application?
What I need to do is have an online Appt calendar and with all those
appts,
be able to sync that to a PDA.
Any good tutorials, examples, products
There is another way to do much of this in SQL Server:
Use the following two queries and do a cfdump on them:
-- To get all tables in a database, just do:
SELECT * from sysobjects where type='u'
(the type='u' means just show USER tables, not system tables)
-- To get info on table, including
We are using CFMX 6.1 and Oracle 9i.How do we retain
database row locks from one request (query of information to
display in a HTML form) to the next (updating the
information)?Data integrity is the concern of course...how
to keep two users from updating the same record from the
Tony,
SQL doesn't do things in order it actually starts with the where clause
and works up. This makes sense when you think about it - it filters out the
stuff that you don't want before it selects the stuff that you do.
- Original Message -
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk
yeah, I remember hearing that.
the only reason I was trying to do this, in the first place was because I
wanted to take some calculation effort off the cfmx server and put it on the
sql server, but its not a biggie, just wanted to try it to expand my brain a
bit, and try a real world example of a
I am using windows 2000 with CFMX 6.0. The server is currently serving 3
web sites, and here is the problem I am running into.
If I name a page from one site the same as I name a page from another site
cold fusion will show the page of the of the wrong site.
Has any one dealt with this before?
yeah, there is a fix on macromedia.com, there is basically an xml file that
you have to turn that kind of caching off.
someone will have it soon in a post, im sure.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original
http://www.macromedia.com/support/coldfusion/ts/documents/tn18258.htm
-Original Message-
From: Randy Morse [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 12:45 PM
To: CF-Talk
Subject: weird caching?
I am using windows 2000 with CFMX 6.0. The server is currently serving 3
Tony Weeg wrote:
isnt there just a way to use those calculated values, referenced in the
beginning of the query, later on down in the query?
SELECT
*
FROM (
SELECT
count(tony) as tonysCount,
sum(jayme) as jaymesCount
FROM
orders
) a
WHERE
Abs(tonysCount-jaymesCount)/tonysCount) 0
with about 5000 lines coming from sql server, if I do the math with a cfloop
and cf tags in between, versus, calculating in sql server and discarding
what I don't want?
what do you think?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
Tony Weeg wrote:
with about 5000 lines coming from sql server, if I do the math with a cfloop
and cf tags in between, versus, calculating in sql server and discarding
what I don't want?
what do you think?
SQL of course. Don't put off to the business layer what you can
do in the data
a quick non-scientific test says DON'T USE THIS QUERY TONY, that's actually
what query analyzer said
too much too long, can get better data quicker calc'ing in cf.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
here is the whole thing, in its entirety now, and it takes about 3 minutes.
not good.
select * from
(select
r.IpAddressNum, v.VehicleIp, v.firmwareRev,
Count(r.ReportId) as ReportsInDatabase,
Count(DISTINCT timeId) as DistinctTimes, v.VehicleName, c.companyName
from reportsView r
INNER JOIN
Actually Win 2003 is IIS 5.2 and XP is IIS 6.x
Don't ask me why.I just happen to have a Win 2003 server right here and a
cfdump reveals IIS 5.2 :-)
Also... as far as Win2003 is concerned.I've had CFMX 6.1 running on
Win2003 for a couple months now and couldn't be happier.
-Novak
- Original
Tony Weeg wrote:
here is the whole thing, in its entirety now, and it takes about 3 minutes.
not good.
It is impossible to debug performance issues without a complete
query plan and schema (including cardinality).
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast
Stan wrote:
Can you show an example of how you would use cfheader or cfhttp?
cfhttpparam
type=CGI
name=http_referer
value=https://foohbar.com
I was given a way to do it with cfheader (here, I think) but I've lost
the thing now.Deleted the file I originally tested it on :-(.Not
sure how
Manually test each field with IsNumber,IsDate,IsBoolean etc. etc. ?
Nope, this will only test for the CF variables containing values returned by a query, which is quite fuzzy.
For instance 1234 stored as a text field in the database will be declared numeric by CF.
[Todays Threads]
[This
Thanks.I did reboot, and they are both running.But I am still getting
the same 'Service Unavailable' message on every http request.Any other
solutions?
-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 11:02 AM
To: CF-Talk
Subject: Re:
1 - 100 of 177 matches
Mail list logo