Well, do you have a logout.cfm page?
If so, do something like this.
document.location.href="index.cfm">
Then if they click the back button, it sends them right back to
index.cfm
That way you could also clear your cookies if needed, since your not
using a cflocation
_
Steve,
Thanks for the posts. But I tried your codes and still haven't got it to
worked. If you have time, can you give me a little detail? My JS level is
pretty junior.
nathan
- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday
>>The only way I can think of is to include something like:
>>window.history.forward(20);
Disregard that, I went looking around and found that IE only supports
-1, 0, or 1 in the history function.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
_
But you do know, if you have some sort of session checking involved in
each *secure* page, they won't be able to do anything, except *look* at
the pages.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Nathan Chen [mailto:
Actually, now that I think about it. Use a logout.cfm page to clear the
session variables, and put this at the top of that page.
window.history.forward(1);
Then at the bottom of the logout page use cflocation to go to the index
or something.
If they click back, it will shoot them forward agai
I use the location.replace() function on my logout page. That works
well, but isn't supported by older browsers. So you can use if
document.images to test it.
On the logout page:
If (document.images)
location.replace('http://yourserver.com/inde
I'm sure as everyone knows, there's at least 15 different ways to do the
same thing in coldfusion, some ways execute quicker, some are shorter in
length, some are just *out there*, but all seem to give the same
results.
I try to give advise that I believe executes the quickest and most
efficient.
I guess, after solving the killing session issue, my next problem is how to
prevent or stop users from clicking the "Back" button in the browser and
getting back to the system after they logout. I know this is an old issue
and someone has mentioned this before, but I didn't keep those messages. C
Funny you said that ..> I almost added that to the bottom of the post ...
:)
No problem!
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursda
Thinking about it more: your way in some cases would add extra steps..
..do this
..do that
.do something else
Your way
..do this
..do that
.do something else
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message --
Sorry, I seem to be in an arguing mood tonight. (must be the lack of
sleep)
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:21 AM
To: CF-Talk
I agree ... (didn't actually disagree) ..
does about the same thing and IsDefined...
I just happen to be working with sessions at that time, and that is one w
ay
I was clearing it out .. but I didn't want to loose the session either ...
If I were just doing a login/logout yeah .. your way is t
Why keep the session if there's nothing in it :)
Dropping the session will log them out.
If he's tracking loggedin status by isDefined("SESSION.loggedin"), he'd
have to go through and add AND len(SESSION.loggedin) since your way just
sets them to "".
__
steve oliver
atnet so
Oh, ok, I thought you was saying that it wouldn't work.
Yeah if they are using client variables then just set a client variable.
My bad.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECT
You can, but the original post was talking about client vars.
You suggested using a session var, did you stop to think that session
scope is not practical or how about setting a client var. My point is
that both session and client work the same, so to the original post you
could set either a sess
I must be viewing this wrong, here's how I see it.
User clicks a button, or clicks a link to create a new job.
-Session variable is set saying a job is open.
User opens another browser, and clicks the link again to create a new
job.
-CF sees the existing session variable, and says no, you can't
So why can't you check for a session variable on each page load, if it's
there don't let them create a new job?
I'm assuming there IS a login to the function that we are talking about,
otherwise nevermind.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
Steve's dumps the session totally and my example keeps the session, but
drops anything in it.
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
- Original Message -
From: "Nathan Chen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursd
Thank you, Paul and Steve, for your help.
- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 9:31 PM
Subject: Re: simple question - how do you manually time out a session
variable
> If you are wanting th
Steve Client and Var scopes work the same way, they are both reliant on
the CFID & CFToken. Do I need to spell it out for you.
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 3:35 PM
To: CF-Talk
Subject: RE: >1 browser window kill client v
tag implementation example
blah...
--
Search the Holy Bible: http://www.bibleclicks.com
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Mon
I don't see how, if your tracking sessions by cookies, two browsers open
will see the same cookie, so you should be able to just check for an
existing session variable.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Andre
Yes,
Make sure you lock it though.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Nathan Chen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 11:29 PM
To: CF-Talk
Subject: simple question - how do you ma
If you are wanting the session to END, just
(Wrap it in cflock EXCLUSIVE)
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector - Commerce Builder
> Hi,All:
>
> I know you can set time out for a session variable by changing the
> default value in CF administration, but can you
Hi,All:
I know you can set time out for a session variable by changing the
default value in CF administration, but can you time out a session
variable manually? For example, if the user clicks a button called
"logout", then the next page sets the session expire or time out.
Nathan
___
Steve Client and Session work the same way, so the problem would still
be the same.
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 5:47 AM
To: CF-Talk
Subject: RE: >1 browser window kill client var
Why don't you just use a session variabl
It would appear that you have found a bug. I've reproduced your error
as
well. When computing a sum on a column it is missing the where clause.
I'd report it to macromedia and see what they have to say...
Now, to solve your problem... What database are you using? Can you run
this
as a store
The company I used to work for was developing one. Contact them at
http://www.mcdelectric.com
- Original Message -
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 9:04 PM
Subject: CF Based CRMs
> Anyone out there know of a
that is strange. Have you tried the HAVING clause instead of WHERE?
- Original Message -
From: "Daniel Quinones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 6:24 PM
Subject: Strange Query of Query Behavior
> Hello,
>
> I am doing a query that
Anyone out there know of a CF based CRM tool for managing sales leads?
TIA,
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://w
I know sooner or later some one will complain about this thread but I
just want to throw my two cents in... I'd give something away free too.
Sure I might be able to sell it to a handful of people, but then what? A
handful of people appreciate it and a handful of people may want to hire
me to do o
Yeah, after the file is uploaded.
CFFILE.clientDirectory
Directory location of the file uploaded from the client's system
CFFILE.clientFile
Name of the file uploaded from the client's system
CFFILE.clientFileExt
Extension of the uploaded file on the client's system without a period,
fo
Hello,
I am doing a query that extracts all sales info for an employee in a
particular time frame.
Then I am doing 2 querys of that query as seen:
SELECT SalesAmount AS Sales1Sum FROM SalesQuery Where BonusDeal =
1
SELECT SalesAmount AS Sales2Sum FROM SalesQuery Where BonusDeal =
0
This is w
Hi, when submitting a multi-type form with an input of type "file", is there
a way to reference the text value of that input before you do any file
actions on it? Outputting the variable form.filefieldname will give the
local tmp file where the file is being stored. I could probably do it with
jav
Thank you
At 09:43 AM 2/15/2002 +1000, you wrote:
>Try secretagents.com and look for the nested hierarchy tute for SQL.
>It's what I use and its incredibly powerful (e.g. one-query hierarcy
>display, tree walks, etc)
>
>Darryl
>
>-Original Message-
>From: Ray Bujarski [mailto:[EMAIL PROTE
Try secretagents.com and look for the nested hierarchy tute for SQL.
It's what I use and its incredibly powerful (e.g. one-query hierarcy
display, tree walks, etc)
Darryl
-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 9:32 AM
To: CF-Talk
Hi Ray, I've done something like this. You can see the result at
http://www.theanticool.com/pages/index.cfm. Basically you have to call
a
custom tag that checks for families for each child. If the child(ren)
exists, then you write his info and call the tag again. If theres no
children the node
The end result I am trying for is a structure (associative array)
suvPhNum = empList where empList = all direct reports and all of
each direct reports reports etc...
At 03:31 PM 2/14/2002 -0800, you wrote:
>My mind just isn't working, I need help with some logic here if any of you
>wo
My mind just isn't working, I need help with some logic here if any of you
would
I have a table that houses all employees and each is unique by employee
number, there is a hierarchy of management by storing each employee's
supervisors employee number in the record. For example my bosses e
don't forget to lock your session variables.
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 5:04 PM
Subject: Login expired vs. Not logged in
> In an app I'm developing, I'm using a simple system of using se
A cookie would probably be easiest, just set the cookie each time the
page is loaded. Cookie.lastactivity.
Then do something like:
Your session expired.
Hey you gotta login.
..
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message
In an app I'm developing, I'm using a simple system of using session
variables for access control:
Hey, you gotta login.
..
Is it possible to detect if a user session has _expired_?
Your login session has expired. You must login again.
Hey, you gotta login.
...
Roll my own, using
It may be a perms problem. I think when you manualy execute it , it runs
under the logged on username and when it is scheduled it runs under the
mssql service account. I've had that happen with other stuff, just a
thought.
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Inst
yes
-Original Message-
From: Darryl Lyons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 4:11 PM
To: CF-Talk
Subject: RE: executing a dts package
You've set up an SQL Job for running the DTS package I am assuming?
-Original Message-
From: Steven Dworman [mailto:[E
You've set up an SQL Job for running the DTS package I am assuming?
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 7:15 AM
To: CF-Talk
Subject: executing a dts package
Here's the deal. We have a DTS package that needs to be executed o
maybe not the fix you were looking for...but you could execute it from CF.
www.cfcomet.com has an article by Simon Horwith that steps through this
method...
http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297-
4E80-92CC7A8907B0A5B2
-Original Message-
From: Steven
Here's the deal. We have a DTS package that needs to be executed on a
monthly basis. The problem is that SQL server 7 can't execute it. It fails
every time. If we run the package manually it works just fine.
Any ideas?
Thanks,
Steven D Dworman
---
also, how are you generating the primary key for the insert statement?
If
you are using SELECT MAX() then you can have issues without using
CFTRANSACTION.
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database
What kind of variables are you using? I'll assuming you're not using
the application scope for the email address. ;-)
Are you locking your session reads and writes?
Jamie
On Thu, 14 Feb 2002 14:31:24 -0500, in cf-talk you wrote:
>Hi list . . .
>
>just a little help please . . .
>
>I have a for
I think you have missed the problem... If user2 gets user1's info, then
where did user2's email address come from? I assume it came from the
form,
which means you haven't lost the form information. These problems can
be
tricky, so take your time and go over the thing with fine-tooth comb.
+-
Excellent!, thanks all. I need to read up on ReFind.
Adrian
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Probably something more along the lines of:
Jim
- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
> Ok, in that case in your action pa
Use
This will single thread the execution.
> Dan Rosenbaum
> Wachovia Securities
> Corporate & Investment Banking
> [EMAIL PROTECTED]
>
> -Original Message-
> From: Steve Oliver [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 14, 2002 2:33 PM
> To: CF-Talk
> Subject: RE: A-Z
At 02:32 PM 2/14/02 -0500, you wrote:
>You could use a and group your cfquery and cfmail
>together.
>
>__
We are currently using a wrapped around a CFINSERT and
query getting back the New ID of the new record created . . .doesn't seem
to hold up . . .
jim
>
>steve oli
ok.
but if the page changes then the form action would have to change?
so i cant just say
action = 'verityResults.cfm'
if the verityResults.cfm is also in each seperate page?
or could i just have it
where thispage always posts to the current page the form is included in?
-paul
-Orig
Two possible suggestions: Do not allow multiple jobs to be processed
simultaneously. That is, do not allow that particular session to process
more than one job at a time. The other would be to make arrays of all
your job related variables and track them separately.
> - Original Message
Probably something more along the lines of:
Jim
- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 12:30 PM
Subject: RE: A-Z 0-9 form validation
> Ok, in that case in your action page you could do s
Since its an INSERT is seems like this should not happen, I could see this
happening with an UPDATE. In any case without reviewing your code you may
want to CFLOCK the INSERT EMAIL process. If its a heavy usage site I would
look further into why this is happening and code around it rather than u
You could use a and group your cfquery and cfmail
together.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Jim Mixon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 2:31 PM
To: CF-Talk
Subject: RE: A-Z 0-9
This is why it's a very bad idea to track application state using session or
client variables. A user opening two browser windows and performing
different tasks in each will usually screw up your logic. You need to know
what kind of information you can and cannot safely keep in the client and
se
Ok, in that case in your action page you could do something like:
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 2:23 PM
To: CF-Talk
Subje
Hi list . . .
just a little help please . . .
I have a form that collects data, inserts a new record and send out a
confirmation email to the submitter . . and CC's me with form info also . .
It seems that when two or more people submit the form at the same time,
their session or data overlap
As a reminder, URL and FORM variables are available to custom tags too.
Mike
- Original Message -
From: "Steve Oliver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 14, 2002 1:59 PM
Subject: RE: cfinclude, who to pass for variables to?
Didn't we go over
And speaking of page numberswhy are all the page numbers off on the ColdFusion
Developer's
Journal Articles. There is always 1 less page than it says (i.e. 6 out of 7 is the
last page of
this article). Somebody fix it ;-)
OK...I'm done
Bryan Stevenson
VP & Director of E-Commerce Developm
Only want to allow A-Z or 0-9 character/digits in the form input. Anything
else I want to return a message back to the user to fix the input. I have
tons of other server side validation happening so I want to keep it on the
server side, rather than using JS.
Still running 4.01
-Origin
PS... It's on page 3 of that article :)
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 2:11 PM
To: CF-Talk
Subject: RE: A-Z 0-9 form validation
can you elaborate on A-Z and 0-9?
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
---
If your using CF Server 5.0 you can use RegEx in a tag.
http://www.sys-con.com/coldfusion/article.cfm?id=376
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Febru
Didn't we go over this earlier?
When you cfinclude something, it has access to all variables on that
page, including FORM and URL variables.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTEC
Anyone have a good snippet of code to do A-Z 0-9 form validation server
side? Im trying to roll my own but its starting to get ugly
Thanks,Adrian
__
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB M
I'll grant that point but will also point out that there were several calls
for moving those threads to Community as well.
Hatton
> Oh come on now, if people can discuss broadband issues, bitch about open
> source, and discuss the post on fuckedcompany.com, I think it's
> certainly OK to talk ab
hello all.
just curious how i would pass form to a n included page.
say verity
i have an cfinclude search field on the top of all my pages.
i cfinclude the results page in small box on all my pages
how do i pass the search info to the results page?
normally i would just select the result page i
Use two different browser types: IE & Netscape, IE & Opera, Netscape &
Opera
Kevin
>>> [EMAIL PROTECTED] 02/14/02 10:38AM >>>
We just made an interesting discovery. We process multiple jobs,
identified by different job numbers. We were looking into using client
variables for job numbers, bu
Why don't you just use a session variable to track if a job was created
or not?
User opens a browser, opens a job, gets a job number, gets a session
number.
User opens another browser, CF sees the session number, and either shows
the same job or says "you already have a job open"
__
We just made an interesting discovery. We process multiple jobs, identified by
different job numbers. We were looking into using client variables for job numbers,
but if (when?) users open more than one browser window this can cause problems.
If the user uses a second browser instance to go t
Amen, brother.
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 14, 2002 1:31 PM
To: CF-Talk
Subject: RE: free CF hosting - is available!
Oh come on now, if people can discuss broadband issues, bitch about open
source, and discuss the post on fuc
Oh come on now, if people can discuss broadband issues, bitch about open
source, and discuss the post on fuckedcompany.com, I think it's
certainly OK to talk about a ColdFusion related web hosting service.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-
Many people have had experiences with CFM-Resources... good and bad.
Personally I don't think CF-Talk is the right place for discussing the pro's
and con's of the service.
Hatton
> -Original Message-
> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 14, 2002 1:2
By they way, I know your going to say "what do you expect from a free
service". Well I had the developers package, which was around $24 a
month, and my pages would take at least 30 to 45 seconds to load.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
---
My bad, I do have the comma, missed it in my mail example. Initially I
tried it with the CFSET, but had it all in a single CFOUTPUT block, Im
assuming that was the problem. Using did not error and did NOT get sent to the browser, it appeared
to get processed by CF...maybe ive had too much cof
I tried cfm-resources before, they have really slow servers, connection
speed-wise, and there customer service is Very bad.
Take a look at the forums on their page and read what people have to say
about how crappy the service is ;)
__
steve oliver
atnet solutions, inc.
http:/
OR..
for $9.95 CDN (about $5 US) you can host with WeDoHosting.com and not have a banner
plastered onto
your pages ;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
--
> Im trying to change a query value using QuerySetCell, it appears to be
> working (no error) but when I CFOUTPUT I dont see the new
> result...Initially I was using it in the same CFOUTPUT block that my
> test used but then thought it needs to be in a different CFOUTPUT
> block prior, tried that
There is a free CF hosting company out there!
They place banners at the top - so if you don't mind
that you get:
- 30mb space
- ftp
- 1 ODBC connection (Access 2000)
- 1 free email addresss
- 72 hour technical support
http://www.cfm-resources.com/apply.cfm?signup=free
Bimal Shah
Senior Web de
Initially I used in the same CFOUTPUT block, which didnt work. I then changed
to whioch didnt work. I
then slit to 2 blocks, didnt work. I finally changed the initial block to
use .
Worked!.
-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Im trying to change a q
>Im trying to change a query value using QuerySetCell, it appears to be
>working (no error) but when I CFOUTPUT I dont see the new
>result...Initially
>I was using it in the same CFOUTPUT block that my test used but then
>thought
>it needs to be in a different CFOUTPUT block prior, tried that di
If you use query analyzer to view the execution plan and run a number of
fairly complex queries, it's pretty obvious (to me) that SQL server uses
some form of logic in constructing the execution plan that does not appear
to depend on the order of the where, order by or group by (though the group
b
Okay,
Then... As a best practice(?) start by assuming that you're DB will
process your where clauses from the bottom up and help the system out.
If you're lucky enough to have the best stuff out there, like Oracle,
which I assume atleast 85%, probably more, don't have then just code
completely fr
I'm fairly certain that SQL Server processes top down. Oracle used t
o
process them bottom up.
-Original Message-
From: Tyler M. Fitch [mailto:[EMAIL PROTECTED]]
Sent: February 14, 2002 10:15 AM
To: CF-Talk
Subject: RE: cfqueryparam - order of where/and
Actually,
The where clause proc
Im trying to change a query value using QuerySetCell, it appears to be
working (no error) but when I CFOUTPUT I dont see the new result...Initially
I was using it in the same CFOUTPUT block that my test used but then thought
it needs to be in a different CFOUTPUT block prior, tried that didnt work
Have a look at http://www.intrafoundation.com/
They've got a kit that will access all this information
HTH
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2002 17:44
To: CF-Talk
Subject: Re: Accessing Accounts on NT via CF
Is there a way to add/delete
>Actually,
>
>The where clause processes bottom up.
>
>So, if possible, for best results place your most restricting clauses
>LAST and filter out the greatest amount of data. Then the next where
>clause up from the bottom has the least amount of records possible to
>compare against and will perfo
Is there a way to add/delete/modify user NT accounts via a web interface?
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.
Actually,
The where clause processes bottom up.
So, if possible, for best results place your most restricting clauses
LAST and filter out the greatest amount of data. Then the next where
clause up from the bottom has the least amount of records possible to
compare against and will perform faste
Yes the order of the clauses in the where statement matter.
First, you want to use indexed fields. That way, you make full use of
database optimizations. The execution plan *should* figure it out, but it's
still good practice to use indexed fields first regardless.
Dunno about the second quest
I personally have found that when I have a huge query it makes it faster if
I do the joins that get rid of the most data first. So say I have a query
like this.
Select *
>From Accounts,
Sales
Where accounts.address = sales.address
And salesdate = #now()#
And item = 13882
I would redo th
I read an article by Ben Forta in CFDJ about using I wanted
to test it out, but had a question, well actually two questions. First has
nothing to do with CFqueryparam
1) Does where/and clauses ORDER matter? ie
select *
from table
where id = 'xxx'
and data1 = ''
Verses
select *
from tabl
You can use Access as a front end to almost anything via ODBC. On the
machine with Access, create an ODBC connection to your foreign database -
this assumes that the database is accessible via the network. Then you can
either link to or import the foreign database, depending on your needs.
If
Alright already, I get the point.
Use CFINCLUDE, It's much faster when doing something like this.
All your base
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
> Ok were talking milliseconds here, but yeah variables are passed to any
> page that you cfinclude, so it would be easier to do it that way.
>
That may be true with one or two users on the server, but you try that on a
live server with hundreds of concurrent users where the web server is
queuing
iMS can do this with only a few lines of code. It could integrate into your
ColdFusion site seemlessly and you wouldn't need to use
cfpop of cfmail. iMS is akin to a web server using ColdFusion as it is a server and
ColdFusion controls the functionality. When
mail is received by the iMS SMTP
1 - 100 of 126 matches
Mail list logo