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
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
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
cfif IsDefined(URL.MM_logout) AND URL.MM_logout EQ 1
cflock scope=Session type=Exclusive timeout=30
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
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
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
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
requirements, using
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
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 a
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 when
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 CF
You can use cfobjectcache action = "" to clear all cached queries
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
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
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 cfobjectcache action = "" to clear all cached queries
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
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
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 cfflush. 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() --
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:
divPlease wait because this may take a minute/div
cfflush
Then, at the bottom
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 use cfflush,
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
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 does a
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
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
cfqueryparam 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:
cfquery name=getArticles datasource=#dsn#
select *
from Articles
LIMIT 5
/cfquery
Or at the most, for a specific article with an ID
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 the
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
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'm
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]
cfqueryparam 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
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:
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
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
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 [EMAIL
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
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
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
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
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
d'oH!true :)
ok...i'm only 3 minutes into Ben's 10 minute book g...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 from
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 easiest way
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 anda 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:
input type=text size=95 name=side_1_comments maxlength=100 CFIF trim(side_1_comments) NEQ value=#trim(side_1_comments)#/cfif
But I get an error. It seems simple, but I must be
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
an xml
ur missing a
input type=text size=95 name=side_1_comments maxlength=100 CFIF
trim(side_1_comments) NEQ value=#trim(side_1_comments)#/cfif
try that.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF
You're missing a right angel bracket after the double quotes.It should
read:
CFIF trim(side_1_comments) NEQ value=#trim(side_1_comments)#/cfif
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input
I
but at the same time...i would...
cfif isDefined(side_1_comments) and len(side_1_comments)
input type=text size=95 name=side_1_comments
value=#trim(side_1_comments)# maxlength=100
cfelse
input type=text size=95 name=side_1_comments maxlength=100
/cfif
just to double check, and its more read-able
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
input type=text size=95 name=side_1_comments maxlength=100 CFIF
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 wanted
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. :)
cfif isDefined(side_1_comments) and len(side_1_comments)
input type=text size=95 name=side_1_comments
value=#trim(side_1_comments)# maxlength=100 cfelse
input type=text size=95 name=side_1_comments maxlength=100
/cfif
forgot 's
-Original Message-
From: Robert Orlini
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:
!--- testing for variable foo ---
cfif
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.
cfif isdefined(var_name)
_
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
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
Subject:
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
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
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 verify
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
Hi,
This is what I use:
head
style type=text/css
!--
#LoadingMessage {
position: absolute;
visibility: visible;
height: 100%;
width: 100%;
top: 0px;
left: 0px;
background-color: #FF;
}
--
/style
script language=_javascript_ type=text/_javascript_
function showMessage () {
if
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 arrayobject named message
var messages =
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
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 adding
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 desktop?
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
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
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
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
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
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]
[Fast
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 number of
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
hey guys, what do u think the performance difference is in MS SQL Server 2000
Querying from a table of 500,000 rowsor 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
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: brobborb
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 you're
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
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,
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
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: Tuesday, April
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
Subject: RE:
1 - 100 of 132 matches
Mail list logo
