As someone else has mentioned, SQL Server cursors are not super efficient.
Often, there is a non cursor alternative to what you are trying to do. For
example, if you have a identity column (or a column you know to be unique)
in the table you want to iterate over, you can use this trick to avoid a
I've noticed that cflocation seems to fail when the url argument is very
long, for example 850 chars. I think I remember seeing somewhere that
CFLOCATION actually implements an HTTP 302 Redirect. Is there something in
the html headers which is restricts the url length, or is this an artificial
:) I recall a convo where IE was restricting limits.
the question is, what the heck are u passing?!
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 5:17 PM
To: CF-Talk
Subject: cflocation url length
I've noticed that cflocation seems to fail when
we
have to go) Or have I missed something?
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 20, 2002 4:04 AM
To: CF-Talk
Subject: RE: Killing Client vars session on closing browser.
Correct me if I'm wrong, but I believe that eliminating a user's
I've had the exact same issue with our SNAP server. I think their NTLM
emulation software is somewhat bunk. I've had alot of problems with it. What
version of the SnapOS are you using?
/rob
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002
Dave, thanks for the info
From my understanding of that article, the auto disconnect timeout is
controlled by the server, is that right?
If that is the case I don't think it will help in this particular situation.
The Snap servers are running some sort of Linux based NTLM emulation
software and
The Client variables are specific to each application. Notice how the
application name is stored along with the cfid and token in the database.
/rob
-Original Message-
From: Brian Eckerman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 11:58 AM
To: CF-Talk
Subject: How do
Both IIS and CF will have to be able to access the NAS device.
For CF this means that the user running the Cold Fusion Application Server
needs read access to your networked drive (I'd suggest using a UNC path
instead of a drive mapping).
In IIS I think that you have to allow the anonymous user
Can anyone tell me what the behaviour of CFLOCK is when you give it a
timeout value of 0? What I'm looking to do is create a situation where if
one user has acquired the lock, any other users who reach the lock will
immediately skip the synchronized section. I thought the following might
work...
Interesting. I found the exact opposite. CFLOCK behaved as I hoped it would.
Here is my test script...
--
cflock name=MyLock timeout=0 throwontimeout=no type=exclusive
cfset timeA = GetTickCount() + 15000
cfloop
This is likely due to a setting on your datasource. In the cfadmin, go to
your datasource, and hit the cfsettings button to get the advanced view.
Toward the bottom there is a flag Enable Long Text Retrieval. If you check
it, your select should return the entire text column. However, as the
If I have a cftry block which contains calls to custom tags, what happens if
there is an error in one of the custom tags? I would expect that the
exception would be thrown out and caught by the catch block of the cftry,
but that doesn't seem to be the case. I'm still getting untrapped errors out
I've had to deal with similar issues on our site which has some bilingual
sections. It's never easy and I don't know that there is a single good
catch-all approach, but here is what I have found to work pretty well...
Take a look at
http://www.microjuris.com/Profile.cfm
Profile.cfm is just a
Instead of selecting it, why not just put the expression in the order by
clause?
i.e.
order by Right(Title, Len(Title)-2)
Then you don't have to worry about the aliasing.
/rob
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 5:04 PM
To:
]]
Sent: Wednesday, June 05, 2002 5:31 PM
To: CF-Talk
Subject: RE: Sorting problem
Tried that. Then it doesn't sort properly - it's still going RD1, RD10...
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 2:24 PM
To: CF-Talk
Subject: RE: Sorting
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 5:57 PM
To: CF-Talk
Subject: RE: Sorting problem
Good idea, but that really got some weird results. My guess is Access just
can't handle any of this.
-Original Message-
From: Rob Baxter
How about:
FileExists(file)
/rob
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 10:19 AM
To: CF-Talk
Subject: Check for file existence
I need to check if a file exists on the server and if so, run some code.
Whats the best way to check if
Just a guess as I don't use RDS (or really know anything about it) but it
seems like the transfer mode RDS is using is ASCII, that might explain why
the images are coming through scrambled. Not sure RDS is meant for binary
transfers.
If ftp is not an option because of security, have a look at
No, you are right. Mapped drives are specific to the currently logged in
user. That's why UNC paths are much better in this case as they don't
require the user to be actively logged in to work.
/rob
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Phillip,
I'm not sure what you mean by naturally faster due to the way it's calling
the custom tag. Anyway, I got curious about this and rigged up a very
simple test. I wrote a simple custom tag which just displays the current
time. The tag file is located in a directory which is both included
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 1:25 PM
To: CF-Talk
Subject: RE: cf_ vs cfmodule (was: Quick question on custom tags)
Can I ask, which version of the server this is? In CF4 and 4.5, I know
it's true, not done extensive
Good point Zac,
For the curious I did the N=10,000 test with a udf (exact same
functionality) replacing the custom tag.
results:
10,000 calls in 1833 ms, or about 9 times as fast as cfmodule!
/rob
-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31,
the udf was cfincluded within the timed block but outside of the loop.
/rob
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 2:52 PM
To: CF-Talk
Subject: RE: cf_ vs cfmodule (was: Quick question on custom tags)
How did you call the UDF?
Was the
Not sure it is the problem, but I didn't see an xml header...
-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:18 AM
To: CF-Talk
Subject: RE: XML output
i'm not sure about that...
i've been using the samples given by SOXML v1.6 XML Interface
oops, there it is. never mind...
/rob
-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 11:18 AM
To: CF-Talk
Subject: RE: XML output
i'm not sure about that...
i've been using the samples given by SOXML v1.6 XML Interface for Allaire's
One problem with cfmodule is that you cannot take advantage of the ThisTag
type functionality you get from using the different execution modes. In
other words you can't have tags like
cf_MyCustomTag
blah blah
/cf_MyCustomTag
I think someone else alluded to it, but starting with CF5 you can add
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
Tel: +32 2 639 68 70
Fax: +32 2 639 68 99
Email: [EMAIL PROTECTED]
Web: www.lrt.be
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: donderdag 30 mei 2002 17:47
To: CF-Talk
Subject: RE: Quick question on custom tags
One problem
check to make sure your SQL server is listening on tcp port 1433 (unless you
have changed the default port). You can either do a netstat -an from the sql
box or from the client machine try
telnet sql-server-ip 1433
If you get a response your traffic is getting through. If not you've either
got
Ah, thanks guys. I wasn't aware you could have /cfmodule tag. Good to
know.
One question, and maybe this is what Pascal meant in his original reply.
What happens if in my custom tag I call another cfmodule /cfmodule?
Will the parser barf?
/rob
-Original Message-
From: Paul
Why is cfmodule faster? I assume it might be a bit faster on the first call
to a tag since the cf_ method requires that CF search the tree of installed
tags to find the correct template to run, whereas with cf module you can
specify the exact location. However, I've noticed that CF seems to cache
Deanna,
Macromedia released a patch recently to fix a buffer overflow exploit in
JRun 3.x See http://www.macromedia.com/v1/handlers/index.cfm?ID=22994 The
bulletin indicates it only effects JRun.
A notice about the patch was posted to the NT BugTraq mailing list
yesterday, so perhaps your admin
the SQL service and restart the others services again,
in
this way SQL server takes this port firts.
I have to work around it because it could happen again anytime
I restart the machine.
Thanks for your concern
regards Mario
- Original Message -
From: Rob Baxter [EMAIL PROTECTED
If you want the results sorted on the DISTINCT column(s) there's no need to
include an order by. The SQL engine must sort the results on those fields to
determine uniqueness. It's probably a good practice to include an order by
anyway, just for clarity.
/rob
-Original Message-
From:
Make sure you change the maximum session timeout in the CF administrator. It
defaults to 20 minutes and if you haven't changed that it won't matter what
you put in the cfapplication tag.
/rob
-Original Message-
From: Perez, Percy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002
All I can quickly come up with would be to use self-joins for every
attribute/value pair.
select A.DocId from
attrib_xref A inner join attrib_xref B on A.DocID = B.DocID
where A.attribId = 12
and B.attribId = 24
and A.attribValue = 'some text'
and B.attribValue = 'some other text'
...
You'll
Two questions..
1) How big are you access dbs? After a couple million records access tends
to go belly up...
2) are you using connection pooling? Access memory leaks will kill you if
you have the maintain db connectoins box checked in the ODBC administrator
/rob
-Original Message-
Well, why do you think he's moving the list archive out of Access?
Up to a certain amount of traffic/data MS Access is a decent solution. After
that it's a 'disaster waiting to happen' to quote Michael himself.
I'd definetely begin considering other alternatives, ASAP.
/rob
-Original
No need to reinvent the wheel. How about
average = ArrayAvg(avgMark)
Don't think it will work on a 2D array but I don't see how your data fits a
two dimension array.
/rob
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:29 PM
To: CF-Talk
I would think it would work. However you lose the association with the
second dimension. i.e. if you were sorting it by the first dimension and
then wanted display data from the second you'd be out of luck.
/rob
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent:
You could create a special noiseword dictionary which would have all the
generic search words you don't want to return. In you example I guess it
would look something like this...
University,of,The
Then I'd create a view which consisted of
Id, sort_title
where id was a fk back to the schools
You probably want to have % signs around your LIKE data. Otherwise it more
or less functions as an =
/rob
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 2:09 PM
To: CF-Talk
Subject: search problem
Hello,
I have a simple search code
It depends on the db vendor and the primary key type (if it's anything other
than an int it is a little more tricky). In SQL Server you can use the
@@Identity immediately after the insert. It will return the last primary key
(as long is it is an identity) which was inserted. There are some
About the only thing I can think of is to add some code to your App.cfm file
which checks for the existence of CFID and CFTOKEN as URL variables and if
found, just redirect to the same page minus the session info on the url
line. Of course this assumes you don't ever pass the session info in the
I suppose the answers were MS centric but in my experience on this list if
someone doesn't explicitly state which database they are using in a post,
99% of the time it will be Access or SQL Server so I suspect that's why the
anwers were geared that direction. As I mentioned in an earlier
Certainly you can do that (or even more reliably you could get a UUID value
and insert that and then select it back out to get your PK). However, then
you end up cluttering up your database with a bunch of information whose
life span is essentially over once the insert is complete. Personally I
Thanks, Ben I was not aware of that. Unfortunately, it does seem new to SQL
Server 2000, at least I don't see anything about it in books online fot
MSSQL7. Good tip though.
/rob
-Original Message-
From: Ben Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 11:21 AM
To:
Usually machines behind a firewall will have non-routable IP address (ex.
any ip address starting with 192.168.*.*)
When any user on our trusted network access a resource on the external
network (such as an external website), their IP address is masqueraded by
the external WAN interface. So the
claudia,
I played around with this code in my Application.cfm file. It seems to work
ok. The idea is to check for and invalidate any session information passed
along on the url line. You can probably spruce it up by actually removing
the CFID and CFTOKEN arguments with an REReplace or something,
Most efficient probably depends on how the list is organized, but check out
cflib and the ListInCommon or ListUnion udfs. You could probably modify one
of them to just return true as soon as a match was found instead of building
the entire union.
/rob
-Original Message-
From: Won Lee
addtoken=no) made their way from development (through QA) to production.
That's not a small number of files and that's not an easy task.
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:32 PM
To: CF-Talk
Subject: RE: sharing sessions due to url.cfid
Don't think so. I can't speak specifically toward the Hiermenu, but I had a
similar situation last year (needing a popup menu to cross a frame border).
I looked at all kinds of dhtml and flash options with no luck. The closest I
found was a dhtml menu which was displayed in one frame but popped
In addition to what Jon suggested you may want to consider implementing the
UUIDToken solution described here:
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22427Method=Full
It helped our site when we were seeing Session/Client variables being
improperly shared by different users as you
Jim,
Short answer no with an if. Long answer yes with a but. just kidding ;)
You can certainly create and index which contains multiple columns. Whether
or not you want to do this is another topic completely.
There are alot of questions which you need to answer to properly index a
table.
-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 3:12 PM
To: CF-Talk
Subject: Macromedia Forums (aka FuseTalk)
Dear MM,
Your forums blow. snip
--
Try setting them to suck ;)
/rob
Any chance you can change that db schema, or is it too late? I would think
it might be a big headaches to maintain such a scheme. It's also likely to
be much slower than some other approaches.
If you're stuck with the current setup, just try something like this:
select blah
from Functions
where
you are correct, MM/Allaire best practices for Access DBs says not to use
connection pooling.
see http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540Method=Full
/rob
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 2:26 AM
To: CF-Talk
Subject:
What about this
cfif Not IsDefined(IsOperator)
cfscript
function IsOperator( value ) {
blah blah blah;
return something;
}
/cfscript
/cfif
/rob
-Original Message-
From: heirophant mm [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:28 AM
To:
You need to use the name attribute to specify a name unique to that locking
code. For example, for Session var locking I usually used cflock
name=#CFID#_#CFTOKEN# ... The trick is to be consistent with your lock
naming so that different code block which you want to lock will have the
same name.
.
/rob
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 10:09 AM
To: CF-Talk
Subject: RE: CF4.0 shared scope locking?
You need to use the name attribute to specify a name unique to that locking
code. For example, for Session var locking I usually
In short, name locking provides more flexibility and granularity but also
requires better planning on lock usage. My personal best practice is to
always use scope locking for memory variables.
However that doesn't mean there is no place for name based locks. For
example, when I modify a file
be completely independant of one another.
/rob
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 10:48 AM
To: CF-Talk
Subject: RE: CF4.0 shared scope locking?
On 5/15/02, Rob Baxter penned:
You need to use the name attribute to specify a name unique
If you're looking to schedule it I wouldn't even bring CF into the equation.
Just create a batch file with net stop and a net start command for your
service, and then use the NT scheduler to have it run at your desired times.
Unless you need to be able to execute this via the web, there's no need
The older Transact SQL syntax (*=) is pretty widely supported, but as Adam
suggested for portability (and IMO readability) it is better to use the ANSI
SQL syntax (LEFT OUTER JOIN).
In addition, both Microsoft and Sybase reccommend using ANSI style joins.
Deanna,
I've made a few alterations to the highlight UDF which should work. It
basically uses recursion to call itself on each word of a comma delimitted
list (you should probably change this to make the delimiter an optional
parameter, I was just lazy). I've done a few basic tests and it seems
I'm curious to know how any CF admins out there have setup a multi-server
configuration. I've recently been tasked to look at/improve our security
setup here at work. Currently we have a web/cf server (IIS 5.0 and CF 5.0)
running on W2K server. On another server we have NT4 with SQL Server 7.0
The tag is called CF_Highlight. There's also a CFX tag CFX_Highlight, which
is faster than the custom tag. But I'd stick with the UDF unless performance
becomes an issue.
/rob
-Original Message-
From: Robyn Follen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 6:14 PM
To:
It would seem that TOP is more efficient because you're dropping the extra
rows on the sql side instead of the cf side, thereby saving yourself some
resources on the recordset transfer.
/rob
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002
Put quotes around the variable name, i.e.
cfset keith#dynamicpart# = No
That should do the trick. 'though you may want to consider using a structure
instead ...
StructInsert(Keith, dynamicpart, No)
Then you could acess it as
Keith.blue, Keith.red, Keith.green, etc.
/rob
-Original
Presumably putting locks around the tag call will only lock that particular
call. Calls to the same tag in other locations will not be locked. This is
only a logical guess, not verified.
/rob
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 28, 2002
Perhaps what was meant was that instead of using:
cfparam name=a_var default=1
you should use:
cfif Not IsDefined(a_var)
cfset a_var = 1
/cfif
when you're initializing variables which may already exist.
I've heard the second version is sligtly faster. Although in practice I
haven't
Not sure if anyone else has suggested this but try having the two users
delete their cookies. They may have the same session ids.
/rob
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 10:58 AM
To: CF-Talk
Subject: Session variable question
Mapped drives are specific to the current user. Unless the user who mapped
the drive is currently logged into the server AND CF is running as that same
user the mapping will not be available to CF. For these reasons it is not a
good idea to depend on mapped drives. To bad CF won't work with UNC
I believe that IsDefined is only meant to check for the existance of top
level variables, for complex data types you have to use the specific
functions for each type. So here CF is trying to find out if there is a
variable named aStruct[aField] and brackets are illegal in cf variable
names.
In
BTW - When I say CF is running as that same user I mean the Cold Fusion
Application Server service.
/rob
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:52 AM
To: CF-Talk
Subject: RE: CFDirectory Network Drive - Help
Mapped drives
Why the 2 queries? How about this?
CFQUERY NAME=qSpecificLocations DATASOURCE=Events
SELECT DISTINCT EventID,EventType,X,Y,EventText
FROM Events
/CFQUERY
CFOUTPUT QUERY=qSpecificLocations
#qGroups.CurrentRow#, #qSpecificLocations.CurrentRow#,
#qSpecificLocations.X#, #qSpecificLocations.Y#
You didn't say what DB you are using but this should work on SQL Server ...
select count(id) as Num, datepart(ww, date) as weekofyear, year(date) as
year
from main
where date #firstDate# and date #lastDate#
group by datepart(ww, date), year(date)
order by year, weekofyear
/rob
-Original
you weren't too specific but try something like:
select ... where ColA is null
/rob
-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 1:41 PM
To: CF-Talk
Subject: Null Values in MSSQL
Group:
This is the first time that I have to test for
CFHTTP is terrible. It will sometimes just return Connection Failed. Try
refreshing several times. I have often encontered this problem while using
CFCACHE. Allaire/MM claim the problem lies in the 3rd party components which
do the heavy lifting inside CFHTTP, but that doesn't do us much good.
78 matches
Mail list logo
