At 11:00 AM 7/12/2000 +1000, you wrote:
Hai,
can i get information how to display alphabetical order from a query
cfquery
SELECT id, blah, moreblah
FROM sometable
ORDER BY blah
/cfquery
Assuming that blah is some sort of character field, this will sort it
alphabetically. Options
Looks good, although I have one thought to throw in...
At 05:47 PM 7/10/00 -0400, you wrote:
sniped
!--- Can convert multiple IP's using large dim arrays?? *shrug* ---
CFLOOP LIST="#ipAddress1#" DELIMITERS="." INDEX="i"
CFSET ipAddress1Arr[loopCnt] = i
CFSET loopCnt = loopCnt
At 04:47 PM 7/6/2000 -0400, you wrote:
On Win2000, be forewarned that you'll experience about a 17-20% performance
degradation over NT 4.0. This is with the ZDLabs ServerBench 4.1 CPU suite
of tests in our labs.
Any ideas why? I've been pondering moving some servers to W2K as I've like
W2K
At 04:55 PM 6/29/2000 -0400, you wrote:
Hello,
We are about to start a fairly large project using mysql on Unix
as our DB. I hear there is no transaction support, you can't do
'sub selects' (Is that the same thing as a sub-query?), and that it is
in some way 'single threaded' and/or unsuitable
At 10:04 AM 6/22/2000 -0700, Karl Simanonok wrote:
My experience with Sybase has been that the company is incompetent about
technical matters regarding their own products, nonresponsive to support
issues and even to potential buyers,
and their database is a dinosaur that performs poorly
At 01:18 PM 6/21/2000 +0200, you wrote:
Hi everyone.
We're using SQL server 7.0 and it's working great. The DoD recently
purchases a site license
for the entire DoD for Oracle. My question is should I move my SQL server
DB to Oracle?
Just to be contrary, I'd put my vote in for Sybase. Great
At 01:27 PM 6/21/2000 -0400, Zac wrote:
Hope that's helpful.
Do be careful using host headers, tho. They're far less reliable
than using separate IPs. I'd consider them accessable for internal
stuff or for personal sites, but I would NEVER rely on them for a
publicly accessable site that
If you are implementing form2urlattributes, it doesn't like pages in
sub-folders. It has a few built-in assumptions (if I recall correctly),
two of which are that the page being called is index.cfm and the second
being that it is at the top level of the web directory (i.e.,
At 05:51 PM 6/17/2000 -0400, you wrote:
We're in the midst of a minor disagreement about the location of
the default 404 error message delivered by CF (_not_ the web
server default; we started abusing that one long ago). I'm pretty
sure that it's being spat directly out of the application
Not very elegant, but here it is...
cfset new_date = #CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))#
Currently outputs: {d '2000-06-01'}
Good luck.
Judah
At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote:
I have been on a 23 hour coding spree to finish up a project. How do
you
I had to set up a system like this for a client. Basically, the process
needs to work by attaching the web cam to a video board (like the Winnov)
and having software that snags a jpg from the video feed every 20
minutes. Generally speaking, as long as the video board supports Video for
We don't use Spectra at the moment (wish I had a spare $15,000 laying
around...), but I can tell you the way that we tackled that problem. We
defined a table of option types (color, size, fabric, etc) and a table of
option values with foreign keys to the option types (color, red; color,
At 11:13 AM 5/17/2000 -0700, you wrote:
Now, if you need to perform a search on the db in real time, Verity's not
the answer. Easy enough, however, to "almost" query in real time: everytime
you update/insert to the db, you re-run your collection page (of course,
that can be a bit excessive
At 01:14 PM 5/15/2000 -0400, you wrote:
I completely agree with you. The main thing I got out of my comp sci degree
was the ability to think more logically. And, boy, do I know how to sort
(bubble, merge, radix, quicksort)!
Woo Hoo!! Let the fun begin!
Stephanie Cunningham
Web System
At 08:40 AM 5/11/2000 -0700, you wrote:
We spec our CF boxes (NT/2000) at 2 PIIIs (not Xeon), mirrored disks and
512 MB. We generally buy the fastest processors available, lately 733s
and, as tempting as those little IBMs may be, we currently favor Dell 2450s.
We've got much the same setup,
At 12:42 PM 5/11/2000 -0400, you wrote:
Well with database more RAM is always better. Though on the list it has been
posted many times that if you're going to get a multiprocessor do 2
computers with 2 processors instead of one 4 processor. Not only do you get
clustering, but the performance
I can't tell you about CommerceTrends, but I used Webtrends for awhile and
was not terribly impressed. The biggest problem was that a combination of
Webtrends, IIS, and CF reliably crashed CF once every couple days (or more
often). Since uninstalling Webtrends, my CF stability has increased
At 10:55 AM 5/3/2000 -0700, chris wrote:
Leave it to Microsoft to make it so the escaped HTML entities
are essentially reserved words. Pretty pathetic.
To be completely fair, the W3C specs for HTML say that if you are going to
use in the url, you are supposed to use the character entity. If
iginating server has requested no caching
Can anyone tell me what the difference between these two are and if they
would effect browser and proxy caching differently?
I looked through the http 1.1 spec and could get a really solid grasp on
caching and proxy vs. browser implementations.
T
At 02:24 PM 4/20/2000 -0500, you wrote:
Alright, I think it's beer:30 again. We're getting cranky. Myself included.
Yeah, I agree. Even though it's only 1 something in my time zone. Good
thing I work only 2 block from a fantastic pub...
Judah
Here is the code:
CFSET NewDate=CreateODBCDate(#dateformat(Now(),"mm/dd/yy")#)
Should be cfset NewDate = #CreateODBCDate(Now())#
Pound signs always go on the outside, any text not escaped (inside single
or double quotes) insides the pound signs are interpreted as
variables. And creating a
At 11:23 AM 4/13/00 -0400, you wrote:
Yes. You can save the query to SESSION scope.
cfif NOT IsDefined("SESSION.QueryName")
cflock name="#SESSION.SessionID#" timeout="30"
cfquery name="SESSION.QueryName" datasource="#dsn#"
SQL STUFF
I'm also working with Jeff, and I wanted to add that when RDS goes down,
you cannot stop and start the service. It doesn't respond to any control
signals, even if both CF server and CF Exec are shutdown. The only thing
the brings RDS back up is a full reboot of the server.
Judah
At 01:37
At 03:19 PM 3/29/00 -0500, you wrote:
Are you saying you got cfa_htmleditor to work in netscape?
No, I'm saying that I was told that it worked. I didn't do anything, I sat
and watched the people demonstrating do things. I was also saying that,
with creative use of javascript to tweak the
401 - 424 of 424 matches
Mail list logo
