> Hey there, I am just getting home looking over my emails and I saw this
> in one of my security bulletins, thought some of you might want to know
> (doesn't look like a big deal)
>
It doesn't affect DW's ColdFusion server model at all.
Massimo Foti
http://www.massi
I have been googling and playing with XUL for several hours and I am
impressed with what it (you) can do.
XUL has been out there for a while --- guess I just missed it.
Here's a start (a little dated):
http://www.sitepoint.com/article/xul-nets-biggest-secret-1
XUL is a framework for creati
Hi Dave,
Sorry about the wait. Here is the code generated by DWMX. I am starting to get a little down on CF. I can't decide if the bugs on 6.1 are worse for me than the ones in 6.0...
James
[Todays Threads]
[This Mess
Dan Farmer wrote:
> This may seem obvious but I have some fields that do represent money or
> dollars.
>
> Should I use ( int, varchar or money ) what advantages does 'money' have
> over 'int' ?
You should use numeric or decimal. Both are exact numeric types
which allows you to specify the pre
> You should use numeric or decimal. Both are exact numeric types
> which allows you to specify the precision. The main reason not to
> use money is that it is not completely standardized, i.e. there
> is no money type in the JDBC spec. Also, depending on your
> requirements, using numeric and a se
If you can do everything you need in cfscript, it's much more readable
IMHO. However the functionality gap between cfscript and cf tags
negates this to some degreee. In my experience switching back and forth
between tags and cfscript has yielded some very awkward code. I've
almost completely st
Nick de Voil wrote:
>> You should use numeric or decimal. Both are exact numeric types
>> which allows you to specify the precision. The main reason not to
>> use money is that it is not completely standardized, i.e. there
>> is no money type in the JDBC spec. Also, depending on your
>> requirement
> If you can do everything you need in cfscript, it's much more readable
> IMHO. However the functionality gap between cfscript and cf tags
> negates this to some degreee. In my experience switching back and forth
> between tags and cfscript has yielded some very awkward code. I've
> almost complet
I have an app with a front end (the main site that users see) and a
backend (an admin app for updating articles, calendar events, etc). On
the front end, I want to use cached queries to make the performance
better. However, if I use cached queries and an admin user goes into
the backend and adds
I agree completely on the readability issue. In my application.cfm
file, I try to use cfscript blocks as much as possible, mainly to keep
code both compact and readable. I do the same thing on pages where I
need to set more than one or two variables. cfscript blocks are also
easier to find w
We are in the Eastern US Timezone (GMT-5). After the DST adjustment this weekend, some CF5 code that relies on UTC adjustments began failing, showing a one hour difference. We checked our servers (Win2K, Apache 1.3) and the time, date, time zone and DST checkboxes were all correct. We dumped the
You can use
Qasim
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:53 AM
To: CF-Talk
Subject: Cached Queries
I have an app with a front end (the main site that users see) and a
backend (an admin app for updating articles, calendar event
Hi,
I have a page that takes a long time to process, I would like to update the
user, or at least hide the form that appears on the page, while the pages
are processing.
I think I need to use cfflush, but if anybody has any pointers on how to
accomplish this I would be very appreciative.
I'd the
Is there any way to clear just individual queries? Would the best
method for doing that be to execute the same query and give it a new
cachedwithin value of #CreateTimeSpan(0,0,0,0)# to kill the cache from
the backend and then when the frontend query is called again, it will
reset the cache? I'm
>You can use
>
I'm not sure that's what he's after. If you use the above, you blow away the
entire cache, instead of just the query or queries that you want to refresh.
You could store the query results in the Application scope (or some shared
scope) and then refresh the key in the scope when
>Is there any way to clear just individual queries? Would the best
>method for doing that be to execute the same query and give it a new
>cachedwithin value of #CreateTimeSpan(0,0,0,0)# to kill the cache from
>the backend and then when the frontend query is called again, it will
>reset the cache?
>
> I think I need to use cfflush, but if anybody has any
> pointers on how to accomplish this I would be very appreciative.
It is actually pretty simple. Just use . There is one thing to
worry about. In IE, the browser "helps" by not displaying content until it
gets "enough" content. Let's all
John
I did exactly this on a site with news articles. You want to used
cached after with on the Articles query the date-time stored as an
application variable, e..g., Articles,CachedAfterDateTime,
When an admin updates an article reset the Articles,CachedAfterDateTime
variable to now() -- for
You can use CFFLUSH, but that just writes the data to the page. You
can't really "erase" what you wrote to the page without using some form
of _javascript_ and hiding and showing divs. I've done this before with a
simple:
Please wait because this may take a minute
Then, at the bottom of your co
> Just a note on this: the bug is basically that you never see
> value of 1-9 - only 0, 10 or more than 10. (and I think it's
> actually an OS problem on Windows, not a CF issue - can any
> Linux/Unix user confirm the bug on their platform?)
According to the MM guy who explained this problem to
It's also important to note that cfflush doesn't like to be within an opening and closing custom tag.
- Calvin
- Original Message -
From: Raymond Camden
To: CF-Talk
Sent: Tuesday, April 06, 2004 11:19 AM
Subject: RE: Show status during long request
>
> I think I need to
Raymond,
OK, that worked really well to get a "please stand by" style message while
processing,
Is there a clean way to clear that message before displaying the results?
Thanks for your help.
-Nate
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Tuesday
Well, my thought was as follows:
People visit the front end and set the query into cache.
More people visit the front end and see cached query.
Admin user goes into backend and inserts a new record.
At the bottom of the code where I insert the new record, I do the select
query and set createTimeSp
Barney said:
> ... We opted to leave it high, as the app
> running on there does a fair amount of non-local "stuff" (DB
> access, web service calls, etc), where there is significant
> potential for requests to be waiting on external resources,
> not processor time.
Andre said:
> ... Our app do
There are tricks - see John D Burn's suggestions.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
On Tuesday 06 Apr 2004 14:52 pm, Burns, John D wrote:
> the backend and adds a new article, then goes and views the front end,
> he won't see the new update automatically, right? How could I (in my
If you use cfqueryparam, you don't need to worry about caching your querys
yourself.
Oh, and it's
put the message in a DIV with an ID. Then just add an onLoad event to your body tag to remove the DIV from the DOM.
Doug
-Original Message-
From: Nathan C. Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:30 AM
To: CF-Talk
Subject: RE: Show status during long request
R
> While setting a createTimeSpan value of 0 will indeed work,
> the results won't take effect until the *next* page request,
> I think. In the above scenario, you'd be relying on somebody
> hitting that page again before showing the proper results
> (even if you just hit Refresh in your browser
> If you use cfqueryparam, you don't need to worry about
> caching your querys yourself. Oh, and it's more secure.
> Oh, and quicker.
While I just love the CFQUERYPARAM tag to death, it's not a substitute for
in-memory recordset caching. It doesn't cache recordsets in memory, and
therefore isn't
makes it so your query is cached automatically? These
are static queries written directly in CF with no CF variables being
passed in. For instance:
select *
from Articles
LIMIT 5
Or at the most, for a specific article with an ID passed through the URL
select *
from Articles
where arti
On a phone number field I want to make sure that users haven't added ()-.
I figure the easiest way is to strip it off before entering it into the
database.
How would I set that?
Thanks,
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> Is there any way to clear just individual queries? Would the
> best method for doing that be to execute the same query and
> give it a new cachedwithin value of #CreateTimeSpan(0,0,0,0)#
> to kill the cache from the backend and then when the frontend
> query is called again, it will reset th
Well, since no one responded that they'd already made this into a UDF, and
since I advocate for the sharing of code, here's the code for a
"google-like" next-n interface, all wrapped up in a nice little UDF. You
need a few parameters for it, but otherwise, it's pretty well encapsulated.
It's desig
Replace(my_string, '-','','ALL')
At 10:37 AM 4/6/2004, you wrote:
>On a phone number field I want to make sure that users haven't added ()-.
>I figure the easiest way is to strip it off before entering it into the
>database.
>How would I set that?
>Thanks,
>
>
[Todays Threads]
[This Message]
On Thursday 01 Apr 2004 17:33 pm, Dick Applebaum wrote:
> This Thin Array contains very little non-data overhead and can be sent
> to the client, quickly with minimal bandwidth usage (and very few
> processing cycles to serialize/de-serialize at either end) .
Do you have any idea how much quicker
>
>No, I'm pretty sure that once you run the query with CACHEDWITHIN set to a
>timespan of zero, that'll remove the previous cached query from the cache.
>Someone will need to rerun the query against the database to recache it,
>though.
>
That was my point (however unclear it may have been!), if I
you would do some fancy regex, and im sure someone will chime in
however, ray forgot the ()'s to remove
you could kludge it like this...
replace(replace(replace(my_string,
'-','','ALL'),')','','all'),'(','','all')))
tw
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
S
> makes it so your query is cached
> automatically?
No, it doesn't.
> I can see using cfqueryparam in the second instance, but I
> don't see how it helps in the first and I don't see how using
> it caches my queries or improves performance. I looked at
> the CFDOCS and don't see any info ab
On Tuesday 06 Apr 2004 15:49 pm, Tony Weeg wrote:
> you could kludge it like this...
> replace(replace(replace(my_string,
> '-','','ALL'),')','','all'),'(','','all')))
rereplace would look much nicer:
rereplace(my_string,'[-()]','','all')
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +4
as I said :) someone will certainly come up with a fancier way...i just suck
@ regex!
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:55 AM
To: CF-Talk
Subject: Re: Strip ()-
On Tuesday 06 Apr 2004 15:49 pm, Tony Weeg wrote:
> you cou
agreed. I'm praying that a major improvment in the next cf will be that all
(or as many as possible) tags and functions are available within cfscript.
-Original Message-
From: Howard Fore [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 6:14 AM
To: CF-Talk
Subject: Re: Script vs Ta
instead of looking specifically for those 3 characters, you could just say
you want a numeric value (you likely don't want any %!#%! or alphas).
so:
phone = rereplace(phone, '[^0-9]', '', 'all');
should work.
- Original Message -
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <
> > No, I'm pretty sure that once you run the query with
> > CACHEDWITHIN set to a timespan of zero, that'll remove
> > the previous cached query from the cache. Someone will
> > need to rerun the query against the database to recache
> > it, though.
>
> That was my point (however unclear it m
On Tuesday 06 Apr 2004 16:00 pm, Dave Watts wrote:
> When you use CFQUERYPARAM, the database will generally cache query
> execution plans, which can speed up future database queries using the same
> plan.
Hmm...
:tests
I'll typical get consistant ~3ms query times using cfqueryparam, compaired to
Can we switch it to monday? I dont think I'll have much time till the
weekend.
DRE
-Original Message-
From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 8:18 PM
To: CF-Talk
Subject: RE: ColdFusion Coding Contest
Contest is still open until Friday April 9t
On Tuesday 06 Apr 2004 15:59 pm, Charlie Griefer wrote:
> phone = rereplace(phone, '[^0-9]', '', 'all');
Technicaly you should allow leading '+' for international numbers :-)
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Unde
potent stuff isnt it? Kinda makes you rethink application design and chucks
out the window the need to learn flash to make a ria.
DRE
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 4:31 AM
To: CF-Talk
Subject: Re: desktop application
I ha
Thomas
It is very much quicker!
When I originally got the idea for the thin array it was for an
application that had up to 5 selects related.
Rather than load them dynamically, as the user chooses, I preloaded the
entire set of data with the initial page load,
The time to download the thin ar
d'oH! true :)
ok...i'm only 3 minutes into Ben's 10 minute book ...and I can kind of
visualize the "allow + as first char only"...but it's eluding me.
btw, for anybody else who has been wrestling with learning regex (it's been
on my 'list' for years), I recently found this site (was posted thru
You could just use a regex that replaced anything that wasn't a number.
The only tricky thing with this is when you get into international. If
it's local, you could just strip out all non-numeric characters and see
if the string length is 10 and if not, show an error to the user. Then
on output f
ReplaceList(form.PhoneNum, "(,),-", ",,")
Hatton
> -Original Message-
> From: Janine Jakim [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 06, 2004 10:38 AM
> To: CF-Talk
> Subject: Strip ()-
>
> On a phone number field I want to make sure that users haven't added ()-.
> I figure the ea
Hey All,
I'm sending some HTML formatted mail in CF MX 6.1 via CFMAIL and some folks
with Eudora for a mail client are finding that text of the e-mail displaying
overtop the graphics and a few other layout oddities.
I've heard the Eudora has issues with making links in to proper links (not
just
I want to display text in a input box's value field if there is any info in the database. The code I'm trying is:
>
But I get an error. It seems simple, but I must be missing something I can't see.
Any suggestion please? Thanks.
Robert O.
HWW
[Todays Threads]
[This Message]
[Subscription]
Yes, Andre -- and thanks to your prior response to this thread for
suggesting XUL
On Apr 5, 2004, at 10:07 AM, Andre Turrettini wrote:
> Check out xul. You can write an application in and write a delimited
> file
> to the harddrive each time someone enters their email. Its kind fo
>
ur missing a ">"
trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">
try that.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input box's value field
You're missing a right angel bracket after the double quotes. It should
read:
value="#trim(side_1_comments)#"
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input
but at the same time...i would...
value="#trim(side_1_comments)#" maxlength="100">
just to double check, and its more read-able :)
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within
Thank you Tony. Easy...like I said.
Robert O.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input
ur missing a ">"
trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">
try that.
---
> > XUL is platform independent -- anywhere Mozilla runs, XUL
> > runs
>
> potent stuff isnt it? Kinda makes you rethink application
> design and chucks out the window the need to learn flash to
> make a ria.
Except for the fact that very few people use Mozilla. I use it, and like it,
but if I
Tony,
When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a syntactically valid variable name
RO
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input
shite. :)
value="#trim(side_1_comments)#" maxlength="100">
forgot "'s
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input
Tony,
When I try this I get this error:
Parameter 1 of f
I'm not sure how far it's gotten, but there is the XRE: XUL Runtime
Environment, so you can have standalone apps without bundling (or
requiring) Mozilla.
http://www.mozilla.org/projects/xul/xre.html
--
Howard Fore, [EMAIL PROTECTED]
On Apr 6, 2004, at 11:40 AM, Dave Watts wrote:
> Except for
> When I try this I get this error:
>
> Parameter 1 of function IsDefined which is now "text" must
> be a syntactically valid variable name
When you use IsDefined, you specify a literal string as its argument to test
whether a variable by that name exists:
...
Dave Watts, CTO, Fig Leaf Soft
You don't have a closing tag on your first CFIF
John
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I want to display text in a input box's value field if there is any info
in the database.
_
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input
Tony,
When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name
RO
-Origin
There y'go Dave, being logical & practical!
We do need to remember who lost the browser wars :)
There is a tradeoff, however.
Flash can do somethings (the smackdown at Fig Leaf comes to mind) that
would be difficult with XUL.
But for the kinds of things I normally do, Flash is a little heavy,
> I'll typical get consistant ~3ms query times using
> cfqueryparam, compaired to much longer without.
>
> Of course, caching into a persistant scope will get
> you a 0ms query time, but then you have to manage the
> cache (I really must write a generic memoiser CFC)
> yourself. And if you're
How about we switch it to Sunday at midnight, and I will do the final
judging on Monday. No more extensions ;) By the way, I just got a new
submission. We are up to three.
Kevin
_
From: Andre Turrettini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:04 AM
To: CF-Talk
WOW, this contest is on fire! :-)
>We are up to three.
>
> Kevin
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
On Tuesday 06 Apr 2004 17:09 pm, Dave Watts wrote:
> Unfortunately, even with consistent use of CFQUERYPARAM, many of us will
> have longer query times than 3 milliseconds.
Really ?!?
This is on a very loaded desktop dev box, to a remote Oracle, that isn't on
the best hardware either...
--
Tom
At the risk of being on both sides of an issue, it this case XUL vs
Flash, here's an interesting quote:
"The open source revolution has done nothing to change the fact that
the best-designed, most-intuitive user interfaces are found in
closed-source commercial software."
This comes form a comm
On Tuesday 06 Apr 2004 16:10 pm, Dick Applebaum wrote:
> It is very much quicker!
:experiments
In the chatdemo, what tells it to link the messages ThinArray _javascript_
object, to the query returned byrobject.getMessages (that I can see calls a
web service) ?
--
Tom Chiverton
Advanced ColdF
I have a production server that we updated from CF 6.0 Enterprise to
CF6.1. I've successfully updated the server but now my datasources are
having problems with hanging up. I am using JDBC connections and have
fixed the JVM/Class Path setting for the path. I can verify the
datasources and then v
On Tuesday 06 Apr 2004 18:08 pm, [EMAIL PROTECTED] wrote:
> I have a production server that we updated from CF 6.0 Enterprise to
> CF6.1. I've successfully updated the server but now my datasources are
Have you deleted them, restarted CF, and then re-added them ?
--
Tom Chiverton
Advanced Cold
Hi,
This is what I use:
function showMessage () {
if (document.layers) {
Rob can answer this much better than I, but he is N/A.
So here goes
Keep in mind the chat is multi-threaded: where the messages are
retrieved and refreshed in a background thread; while the user may be
typing in a foreground thread.
// sets up a thin array object named message
var
Thomas,
I can try to delete the datasources but wouldn't if the datasources were
the problem then the select that I do for login be affected also? I can
successfully login to the application without errors. It appears that
the server hangs only when an insert/update/delete statement is
processed
I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)
This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank. This UDF
lends its self very well for addin
> > Unfortunately, even with consistent use of CFQUERYPARAM, many
> > of us will have longer query times than 3 milliseconds.
>
> Really ?!?
> This is on a very loaded desktop dev box, to a remote Oracle,
> that isn't on the best hardware either...
How many users are you serving from your deskt
mark, im a bit interested however, im not following what ur saying...
can ya explain a bit more..?
thanks
tonyS
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 1:53 PM
To: CF-Talk
Subject: RE: CFIF within input
I spend way too much time
hey there.
is there a parameter of a textarea that enables what maxlength does for
input type elements?
thanks
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe
http://www.w3.org/TR/1998/REC-html40-19980424/interact/forms.html#h-17.7
You can use _javascript_ though
http://_javascript_.internet.com/forms/limit-textarea.html
Doug
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 2:46 PM
To: CF-Talk
Subj
No dice Tony...
This is a function I use to put a counter above each text area on some of
our internal apps..
function txtCounter(field,cntfield,maxlimit) {
if (field.getValue().length > maxlimit)
{
field.setValue(field.getValue().substring(0, maxlimit));
cntfield.setValue('0');
}
else
why thank you michael.
what do you do? put an onKeyUp or something like that?
tw
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 2:58 PM
To: CF-Talk
Subject: RE: maxlength for textarea
No dice Tony...
This is a function I use to put a
At 12:46 PM 4/6/2004, you wrote:
>hey there.
>
>is there a parameter of a textarea that enables what maxlength does for
>input type elements?
When I need to do something like that, I just use a little JS function...
stick it in onKeyUp on the field in question. I don't have the code handy,
but e
Ok, sureThe code I posted was one part of my "system" that I use for
building admin pages or order forms. I originally build this to speed up
building admin pages but found that I could use it for any form.
Forgive if I over simplify this.
Let me start on defining the problem this solves. I
>If people keep trying to type the last character they type keeps
vanishing.
Just beware the wrath of that data entry person who types without
looking and didn't realize the length limit had been hit long before
they stopped typing :)
Ken
[Todays Threads]
[This Message]
[Subscription]
[Fa
>>If people keep trying to type the last character they type keeps
vanishing.
>Just beware the wrath of that data entry person who types without
>looking and didn't realize the length limit had been hit long before
>they stopped typing :)
hehe...that's why my little function also shows the numbe
makes sense.
thanks!
just wondering...i toil in the CRUD (CreateReadUpdateDelete)admin building
realm more than id like to admit and im always looking for ways to make what
I do more dynamic. I can only cut/paste so many things before an individual
app and its form elements need some specifics..
hey guys, what do u think the performance difference is in MS SQL Server 2000
Querying from a table of 500,000 rows or querying from a table of 1 million rows?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Does anyone have quick overview or insight, tag etc that would allow me to
send a page to a fax printer on the network...if I did some kind of
cfexecute on the server and point it to that fax...using some windows
command?
Thanks for any guidance!
Regards,
Eric J. Hoffman
Managing Partner
Datas
Hard to tell -- depends on the db structure. density, indexes defined
and the query itself.
There are discussions of performance in any good SQL-Server book.
need more info
Dick
On Apr 6, 2004, at 12:38 PM, brobborb wrote:
> hey guys, what do u think the performance difference is in MS SQL
>
If you're WHERE clause uses an index, it should be log(2) times slower for
the actual row selection, but parsing the query, doing JOINs, packaging the
data, etc will all be the same, so the actual time difference will be less
than that.
Cheers,
barneyb
> -Original Message-
> From: brobbor
Has anyone done a tag for Geotrust quick payments? http://www.geotrust.com/quickpayments/portal/index.htm
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Let me rephrase "If you're WHERE clause uses an index" to be "If your WHERE
clause uses a single indexed field".
Cheers,
barneyb
> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 06, 2004 12:53 PM
> To: CF-Talk
> Subject: RE: SQL Query
>
> If
Depends on a lot of things...
1. how many fields make up your search criteria?
2. What is the datatype of those fields?
3. Are those fields indexed, and if so are they being used?
4. What indexes are being used by your query?
5. What kinds of indexes are being used?
6. Are those indexes optimized?
if correctly indexed, none.
I have a table that is 1.57 millions rows, we index on an integer field, and
I can return to a cf page, a recordset with 100+ rows in milliseconds
its all about the indexing.
tw
-Original Message-
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: Tuesday, Apri
CF 4.5 on XP Pro (IIS), test machine
Came back from vacation and CF pages no longer get served.
HTM pages serve correctly.
Can't open administrator, naturally.
I get the "The Page Cannot Be Displayed" error message.
Removal and reinstallation of CF changes nothing.
Any suggestions?
[Todays T
Yes, indexing helps a wholebunch! But how does one practice indexing correctly? Which fields should be indexed? Right now, all the identity fields are indexed. Was wondering if there is aything else that should be index
- Original Message -
From: Tony Weeg
To: CF-Talk
Sent: T
How do you optimize an index? I tried dumping the old one and creating a new one. Something like that.
I will have to read more on the isolation levels. They are a bit confusing to me!
- Original Message -
From: Paul Kenney
To: CF-Talk
Sent: Tuesday, April 06, 2004 3:02 PM
1 - 100 of 132 matches
Mail list logo