Agree with that, especially if you have to manage a project of 2000+
Coldfusion Files like I do.
I personally have many more issues with DWMX7.1 like a total useless
treeview which doesn't let me cut/copy items to other folders because a
file with the same name already exists (erhmm .. folder is
An INNER JOIN join is the best option by far. Use one query to build one
recordset object and reference that. There is no real reason for using two
queries here.
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: 09 November 2004 19:14
To: CF-Talk
Subject: Re:
then go to communitymx.com and buy the darned extension
hell it works great, use it all the time
-- Original Message --
From: Micha Schopman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Wed, 10 Nov 2004 09:23:29 +0100
Agree with that, especially if
What ever happened to CFCOMET?
I would like to get at Exchange server public address books from CF5 but
have no idea where to even start...
--
Regards;
Richard Meredith-Hardy
-
r[dot]mh[at]flymicro[dot]com
Tel: + 44 (0)1462 834776
I don't want to stretch this thread to much, but an inner join won't do
at all. He needs the info on ONE specific article (with an author) and
the info on ALL the authors (probably to populate a select in a form).
An inner join will only return the info on the author related to the
article.
As I
Gonna try that out :) But my main frustration is over the fact I take a
serious amount of time to file a bug reports, and not only hear nothing,
but also don't see any bug fixes coming out.. that makes me wanna ..
*argh* ..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821
become a beta tester and squash them damn bugs before they come out ;)
damn im full of good advise huh? haha
-- Original Message --
From: Micha Schopman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Wed, 10 Nov 2004 10:04:50 +0100
Gonna try that
Lol .. yes you are sharp .. ..
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to the CF
yes but im not always bitching about everyting, except for microcrap cause they
could go ahead and suck a fart right outta my azz for all i care!!
-- Original Message --
From: Micha Schopman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Wed, 10 Nov
On Tuesday 09 Nov 2004 16:31 pm, Jeff Chastain wrote:
How do you
declare an enumeration in CFMX? CreateObject only works with classes (as
far as I can tell).
You can either create a new instance of the java enumeration object (whatever
the java class is for that) or write a java wrapper that
You need to put your licence key in the call the the cf tag, it's not
neededd for IE as that uses DHTML, not the java applet.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: 10 November 2004 05:34
To: CF-Talk
Subject: ActiveEdit4.0 demands money from firefox users
Is
Mike Kear wrote:
Is anyone else finding this? We have fully licensed ActivEdit4.0 but
FireFox users calling the page with the ActivEdit control get a
messages saying they've tried to use an unlicensed copy of ActivEdit.
If they click away the warning, they go back to the page and have the
Neil,
It's not that he wants to get the author of the given article - he
wants to get a list of all authors so that his app can assign one to
the article, so an INNER JOIN is kind of out of the question.
Outer joining would pull back the full text (and whatever other fields
are selected) once
I use this principle a lot, just join them, and then you get authors *
articles records back but it saves you a lot of database calls, and thus
boosting your application performance. Use coldfusion variables like
arrays, structs etc. to group your data for reuse.
Micha Schopman
Software Engineer
In other words
cfquery name=showArticle datasource=user020
SELECT A.*, Au.authorID, Au.authorFirstName, A,authorSurname
FROM Articles A
JOIN Authors Au ON (Au.AuthorID = A.AuthorID)
WHERE A. articleID = '#url.updateID#
/cfquery
Now you get authors * articles on records back. No problem with
Ah, OK..it was early in the morning ;-)
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: 10 November 2004 12:25
To: CF-Talk
Subject: Re: When two tables go to war (JOIN)
Neil,
It's not that he wants to get the author of the given article - he
wants to get a list of
From: Micha Schopman [mailto:[EMAIL PROTECTED]
cfquery name=showArticle datasource=user020 SELECT A.*,
Au.authorID, Au.authorFirstName, A,authorSurname FROM
Articles A JOIN Authors Au ON (Au.AuthorID = A.AuthorID)
WHERE A. articleID = '#url.updateID# /cfquery
Now you get authors *
Hello
Apologies for the OT, but I have tried email Mike directly
I've just moved work and as I couldn't edit the account I had thro the
problem I am about to describe, I just created a new one with my new
details.
Unbeknownst (is that a word) to me my actual email address is
different from
Micha Schopman wrote:
In other words
cfquery name=showArticle datasource=user020
SELECT A.*, Au.authorID, Au.authorFirstName, A,authorSurname
FROM Articles A
JOIN Authors Au ON (Au.AuthorID = A.AuthorID)
WHERE A. articleID = '#url.updateID#
/cfquery
Now you get authors * articles on
From: David Collie [mailto:[EMAIL PROTECTED]
As I said, I did try and email Mike directly but I've not
heard back and was wondering what's up with that section, it
hasn't worked for me for about a year... is it something to
do with my account, the way I am using it?
Hasn't worked for me
My apologies. I should have said Business Basic. We were taught bad
database design skills. Luckily for me, I had other RDBMS experience
before I started. I did have many problems with RPG programmers who
designed poor tables in a previous job.
Russel Madere
Webmaster
504.832.9835
SunShine
Browsers nowadays have sufficient possibilities to take out that last
postback you mentioned. I don't see any need for a new server request.
Get the data once, store it in Javascript arrays.. and based on the
author selection show the articles. One of the main principles of Rich
Internet
One of the most used bad practices is the use of extra queries to
accomplish getting data. That is the NR.1 cause of bad application
performance no matter what language you are programming in. Prevent new
database connections at all costs where possible, seriously.
Micha,
I'd point to poorly
One of the most used bad practices is the use of extra
queries to accomplish getting data. That is the NR.1 cause of
bad application performance no matter what language you are
programming in. Prevent new database connections at all costs
where possible, seriously.
I would disagree with
Micha Schopman wrote:
Browsers nowadays have sufficient possibilities to take out that last
postback you mentioned. I don't see any need for a new server request.
Get the data once, store it in Javascript arrays.. and based on the
author selection show the articles. One of the main principles
On Wed, 10 Nov 2004 09:23:29 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
Agree with that, especially if you have to manage a project of 2000+
Coldfusion Files like I do.
I personally have many more issues with DWMX7.1 like a total useless
treeview which doesn't let me cut/copy items to
What is the best way to add performance to an application that is currently
utilizing a ColdFusion application server (CF5 -soon to go to MX) and a
database server (SQL Server 2000). The database server is under too much of a
load currently as all transactions are stored procedures.
I've
What is the best way to add performance to an application that is currently
utilizing a ColdFusion application server (CF5 -soon to go to MX) and a
database server (SQL Server 2000). The database server is under too much of a
load currently as all transactions are stored procedures.
I've
Hi,
I know it's been discuss before but I don't find it in the archive. I'm
looking for a way (free) to have a progress bar of the file upload when
using cffile...
Thanks
Pat
~|
Special thanks to the CF Community Suite Gold
2 possible solutions:
1. With authorize.net you can validate just the 5 digit zip code. That
way, even if they mistype part of the address, it still gets authorized
and goes through.
2. Use an address validation software to correct the address before it
is sent to authorize.net. This is the
Chris,
If the database is under too much of a load the first place to look is the
database and database code. Migrating to CFMX might aleviate some issues if
the database queries perform better with the JDBC drivers than the current
drivers - so in that sense Java is helping you. But that is
Hi Barney,
I installed it. And it works great!
Thanks
- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 09, 2004 4:12 PM
Subject: Re: DW Title Bar
Nope, MM wouldn't want DW to be easy to use like that. I know there's
Well, if you get really really fed up, you could try here:
http://www.macromedia.com/macromedia/hr/reqs/engineering/2094br.html
:)
On Wed, 10 Nov 2004 09:23:29 +0100, Micha Schopman
[EMAIL PROTECTED] wrote:
I personally have many more issues with DWMX7.1 like a total useless
treeview which
Ryan,
That's a very good idea. I will add that to my options - thanks!!
-Mark
-Original Message-
From: Ryan Duckworth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 8:39 AM
To: CF-Talk
Subject: RE: CC Gateway question
2 possible solutions:
1. With authorize.net you can
They'll have to read their mail first ;)
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
~|
Special thanks to
Something else came to mind regarding Stored procs. A lot of people use them
as sort of an evaluate function for an SQL string. They pass in a string
variable or a series of them and then build an SQL statement - then use
sp_executeSql( ) to execute them. Or perhaps they switch off on an order
by
My apologies. I should have said Business Basic. We were taught bad
database design skills. Luckily for me, I had other RDBMS experience
before I started. I did have many problems with RPG programmers who
designed poor tables in a previous job.
Russel Madere
Webmaster
504.832.9835
SunShine
On Wednesday 10 Nov 2004 13:32 pm, Chris Bestall wrote:
What is the best way to add performance to an application ...
... The database server is under too much
of a load
I think you've answered you own question - buy a bigger DB server.
Stored procs are almost always more efficent than select
I guess I'm not the only one stumped.
-Original Message-
From: James Holmes
Sent: Wednesday, 10 November 2004 2:47
To: CF-Talk
Subject: RE: CFmail problems with 6.1 Updater
Some further info:
Googling turned up cases of Java developers running into this problem when
mail.jar and
Dain was going to take it back and set it up on a new server (I was running it
for him). I need access to the network solutions settings to get it back up.
I'll try to contact him again.
What ever happened to CFCOMET?
I would like to get at Exchange server public address books from CF5 but
I've noted the issue and it will be fixed by days end. Sorry for the
inconvenience.
Hello
Apologies for the OT, but I have tried email Mike directly
I've just moved work and as I couldn't edit the account I had thro the
problem I am about to describe, I just created a new one with my new
Hum ho - thanks.
Michael Dinowitz wrote:
Dain was going to take it back and set it up on a new server (I was running
it for him). I need access to the network solutions settings to get it back
up.
I'll try to contact him again.
What ever happened to CFCOMET?
I would like to get at
If you have the site on your server couldn't you set up something like
http://cfcomet.houseoffusion.com?
--- On Wednesday, November 10, 2004 10:38 AM, Michael Dinowitz scribed: ---
Dain was going to take it back and set it up on a new server (I was
running it for him). I need access to the
http://blog.mxconsulting.com/mxc-blog/archives/entries/B17FBDFD-EBB8-DFFC-87
E24B10A97A0BA2.shtml
Folks, the article mentioned is *very* misleading, and it could lead to some
bad decisions:
From the article: Since each of the sprocs searched exactly one column,
there is no need to recompile.
Well, that's the problem. We don't want to buy a bigger DB server, we would
like to buy more application servers and load balance them, so we can offload
some of the processer usage on the app servers.
I thought we could use Java or C++ for the db transactions instead of
ColdFusion and stored
It's now up and running on
http://cfregex.com/cfcomet/
If you have the site on your server couldn't you set up something like
http://cfcomet.houseoffusion.com?
~|
Special thanks to the CF Community Suite Gold Sponsor -
Douglas Knudsen wrote:
The main PITA I have is that damn file_save.js error I get. It sucks
major! Keeps me from saving a file. Have to shutdown DW, fart around
with the local site copy, then restart DW. It really sucks major big
blue monkey butt! I spoke to a DW engineer at MAX, he was
Wow - thanks...that was fast :)
--- On Wednesday, November 10, 2004 11:08 AM, Michael Dinowitz scribed: ---
It's now up and running on
http://cfregex.com/cfcomet/
If you have the site on your server couldn't you set up something
like http://cfcomet.houseoffusion.com?
Anyone have a good Internet Cafe in their town? There isn't one here
where I live and I've debated on opening one but I know that providing
high-end computers with fast internet access is not going to be
enough. Would like to hear about others out there, and if within
reasonable driving area
reasonable driving area from where?
On Wed, 10 Nov 2004 11:47:40 -0600, Donna French [EMAIL PROTECTED] wrote:
Anyone have a good Internet Cafe in their town? There isn't one here
where I live and I've debated on opening one but I know that providing
high-end computers with fast internet
Adam,
I'm sorry... but the way you described it below is exactly the same message
I got from the article - that the value of ordery by was deterimining the
execution plan and subsequently slowing down the stored procedure when other
values were specified.
More to the point I think perhaps your
you'd get a better response posting this to cf-community :)
On Wed, 10 Nov 2004 11:47:40 -0600, Donna French [EMAIL PROTECTED] wrote:
Anyone have a good Internet Cafe in their town? There isn't one here
where I live and I've debated on opening one but I know that providing
high-end computers
Donna,
I don't have alot of experience in internet cafes, but I was in Poland
recently and this mall was walking distance from our hotel.
http://skyscraperpage.com/gallery/showphoto.php?photo=44155papass=sort=1
They had an internet cafe in the food court area. There was free
wireless but I always
Probably not the right term but I don't have my HTML guide in front of me.
In HTML: a href=somepage.htm#gohere
Can I do that in CF?
Larry V. Stephens
Office of Risk Management
812-855-9758
[EMAIL PROTECTED]
~|
NE Texas
On Wed, 10 Nov 2004 10:55:07 -0700, dana tierney [EMAIL PROTECTED] wrote:
reasonable driving area from where?
On Wed, 10 Nov 2004 11:47:40 -0600, Donna French [EMAIL PROTECTED] wrote:
Anyone have a good Internet Cafe in their town? There isn't one here
where I live and
In CFTML: a href=somepage.htm##gohere
Doubling up the # sign escapes it. ONly necessary if the link is within a
cfoutput block.
Probably not the right term but I don't have my HTML guide in front of me.
In HTML: a href=somepage.htm#gohere
Can I do that in CF?
Larry V. Stephens
There are several ones in the Boston/Cambridge area.
They generally fall into three categories:
1) Game-centric. There aren't any more of these around here, but they're
still out there (I know there's a huge one call LanWorks in Seattle for
example). The first here was called CyberSmith it
Anchors, and yes you can. Just remember to escape the pound with itself in
between cfoutput tags.
cfoutputa href=page.cfm##goherelink/a/cfoutput
Outside cfoutput tags should work just as you have it
-Original Message-
From: Stephens, Larry V [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Thanks. I didn't get an error using this but it still didn't work (i.e., didn't
jump to the location indicated by a name= That's the problem I had before
trying to use it.
-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 1:26 PM
To:
flush out your browser's cache a couple of times... i noticed this with
CF quite a bit...
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
Tried that, too... Thanks.
-Original Message-
From: Lawrence Ng [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 1:27 PM
To: CF-Talk
Subject: RE: jumps
flush out your browser's cache a couple of times... i noticed this with
CF quite a bit...
Hello all,
I'm running into a similar problem attempting to access an external website via
cfhttp (and eventually I'll use cfinvoke since it is a web service. The
vendor is using a homemade cert which he as sent to me along with a keystore.
I've attempted loading the .CER file into the
The original topic link for this is:
http://www.houseoffusion.com/lists.cfm/link=m:4:13865:72003
Thanks!
Mark
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
I am trying to insert '' some text '', but cf keeps reducing it to a
single ' when i do the insert or update into a database. I tried
preservesinglequotes and it didn't change anything.
~|
Special thanks to the CF Community
I tried preservesinglequotes and it didn't change anything.
PreserveSingleQuotes() will only work on a variable, not directly on a string.
It might be your problem.
--
___
REUSE CODE! Use custom tags;
See
try ''' some text '''
-Original Message-
From: JB McMichael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 1:53 PM
To: CF-Talk
Subject: Preserver single quotes
I am trying to insert '' some text '', but cf keeps reducing it to a
single ' when i do the insert or update into
I have an input box called test_text. I enter in ''some text''.
Insert that into the db
insert into table (some_text)
values('#preservesinglequotes(test_text)#')
When I output that I get 'some text'
I then tried '''some text''' and got back ''some text''
It seems as if cf internally just
Do you have your anchor set up right?
Try this...
a href=thispage.cfm#anc1AnchorL Link 1/abr
a href=thispage.cfm#anc2Anchor Link 2/a
brbrbrbrbrbrbr
brbrbrbrbrbrbr
brbrbrbrbrbrbr
brbrbrbrbrbrbr
a name=anc1Anchor one/a
brbrbrbrbrbrbr
brbrbrbrbrbrbr
brbrbrbrbrbrbr
brbrbrbrbrbrbr
a name=anc2Anchor
what about using cfqueryparam?
cfqueryparam value=#form.test_text# cfsqltype=cf_sql_char
On Wed, 10 Nov 2004 11:14:36 -0800, JB McMichael [EMAIL PROTECTED] wrote:
I have an input box called test_text. I enter in ''some text''.
Insert that into the db
insert into table (some_text)
Brilliant! Thanks. Not much stuff on exchange but v helpful on COM
stuff which should get me going.
Michael Dinowitz wrote:
It's now up and running on
http://cfregex.com/cfcomet/
If you have the site on your server couldn't you set up something like
http://cfcomet.houseoffusion.com?
That did it. Thank you very much.
On Wed, 10 Nov 2004 12:18:38 -0700, Charlie Griefer
[EMAIL PROTECTED] wrote:
what about using cfqueryparam?
cfqueryparam value=#form.test_text# cfsqltype=cf_sql_char
On Wed, 10 Nov 2004 11:14:36 -0800, JB McMichael [EMAIL PROTECTED] wrote:
I have
Any time. I'll try to get in touch with Dain about a 'real' solution and get
it back up 100% asap.
Brilliant! Thanks. Not much stuff on exchange but v helpful on COM
stuff which should get me going.
Michael Dinowitz wrote:
It's now up and running on
http://cfregex.com/cfcomet/
I said:
For some functions we use the native Oracle 8.0 drivers supplied with CF
5.0 Enterprise to access Oracle 8i. They worked fine till Monday, now none
of them work and they will not verify.
Dave said:
Perhaps there were some network changes made?
You might try connecting from the CF
Hi all!
After Max I've decided to start playing around with caching some of my
more frequently used CFCs in memory for faster execution times. I'm
only caching components that are used extremely often (those that handle
security, generate navigation, data formatting, etc.) The navigation
I had a server crash last night. This was a very strange crash. The server
was running but the nic card was off and not accepting any connections
obviously. Well the individual that went to the datacenter to look at the
box couldn't get a video signal from the video card so we don't know what
a name=mem2Name/a
I put the cflocation tag inside a cfloopcfif The index is x
cflocation url=MembershipForm.cfm##mem#x#?#SESSION.addToken# addtoken=no
When it goes back to the form I see the address as
...MembershipForm.cfm#mem2?
The test environment should be hitting this when the index is
I'm sorry... but the way you described it below is exactly the same
message
I got from the article - that the value of ordery by was deterimining
the
execution plan and subsequently slowing down the stored procedure when
other
values were specified.
To clarify a little, the fact that he was
Put your anchor at the end of the url and see how that goes
cflocation url=MembershipForm.cfm?#SESSION.addToken###mem#x#
-Original Message-
From: Stephens, Larry V [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 2:44 PM
To: CF-Talk
Subject: RE: jumps
a name=mem2Name/a
I
I've got an upload utility I'm using to allow the client to upload a
txt file which could go into 1 of 33 different tables.. the reports
are structured so differently it's impossible to put them all into one
table.
After uploading the first document (304 rows), I try to upload another
this one
I have never had this issue before, but my navigation menu in the ColdFusion
Administrator is totally broken. I did a clean install of
CFMX6.1 Ent (with a new Jrun 4 instance)
CFMX Updater (on the Jrun4 instance)
Jrun Updater 4
As told in the release notes for the CFMX updater I have two
Resolution:
Turns out our sqlnet.ora file was bad. Once we copied in a
correct one all of our native data sources started to work
again. Funny thing is it appears we had been using this bad
sqlnet.ora file since June without seeing the problems that
started on Monday . . .
My guess
Have you looked at the way the database is used? Maybe you can take some load
away from that database by caching resultsets with ColdFusion's query caching
abilities, and ColdFusion's varity of caching in memory with session,
application and server variables :)
Have you looked at the way the database is used? Maybe you can take some load
away from that database by caching resultsets with ColdFusion's query caching
abilities, and ColdFusion's varity of caching in memory with session,
application and server variables :)
I know this may have been done to death; but checked CFComet, and the
old code there for trying to connect to Outlook to display tasks seems
not to work.
Is there a relevant way or example or tags (free or $) to connect to a
users Task List in Outlook 2003? Server is Web Edition 2003 CFMX 6.1
Well, I even have more problems.. before I applied the updater everything
worked perfectly, but now I cannot access cfm files anymore at random. I just
get a ColdFusion message stating the template file could not be found since the
path is 100% correct.
Chris Bestall wrote:
What is the best way to add performance to an application that is currently
utilizing a ColdFusion application server (CF5 -soon to go to MX) and a
database server (SQL Server 2000). The database server is under too much of
a load currently as all transactions are
Mark A Kruger wrote:
But if the cached plan is select col1, col2 where col1 =
@boundCharacterVar1, then you will indeed get a cached hit by binding 'abc'
or '123' or whatever. That's the beauty of databinding.
Getting a cached plan is a mixed blessing. If I have a table with
a dominant
You're actually not connecting to outlook, you're connecting to exchange
server. I'd assume this might be able to be done through ldap or something
like that. I'm not sure, I just wanted to clarify that outlook is just the
client and exchange is the server.
John
You know, you are right. Just looking for examples. Just feel like I
am missing an obvious resource somewhere. :)
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 10, 2004 3:05 PM
To: CF-Talk
Subject: RE: Outlook from CF
You're actually not
Yes the anchor name should be at the end of the URL.
I'm curious though, how long is the page? If you anchor to a page that is
not more than one browser window it will not adjust the position of the
browser window for any of the anchors. Also if you do have a long page and
lets say you have 5
the only thing close to an internet cafe here in Albuquerque is Flying
Star, a local coffeehouse that advertises itself more as a meeting
place and bakery than anything else. It also distinguishes itself by
subscribing to about 50 different publications, which patrons are
welcome to read at their
I uninstalled all and re-installed again. Applications all work, but... the cf
administrator still has the navserver.cfm issue. I even downloaded the hotfix
for navserver.cfm but it didn't solve the issue.
~|
Special thanks to
Does anybody know any good resources for writing scripts inside of the cfscript
tag? I found something on macromedia's live doc's site but it wasn't very easy
to follow. Specifically i'm looking for loops, handling arrays, and handling
cfc's as objects.
Thanks,
Ryan
The docs installed as part of CF are a decent start. Just hit
/cfdocs/dochome.htm and hit one of the local HTML options. Or
livedocs.macromedia.com has all the same docs for all their software,
though it's in a much less usable format, I think.
In general, it's very similar to JavaScript,
i've got a very introductory cfscript tutorial up on easycfm. a
couple on arrays and structs, but those aren't in cfscript contexts.
http://www.easycfm.com/tutorials/authors.cfm?Author=Charlie%20Griefer%20%28CJ%29
maybe they'll give you a little something to go on at least.
On Wed, 10 Nov
http://www.houseoffusion.com/script.ppt
Covers the basic constructs. One trick not covered is a query loop
cfquery ... name=myQuery
... sql goes here...
/cfquery
cfscript
LoopStep=1;
do {
// stuff
LoopStep=LoopStep+1;
} while (LoopStep LTE myQuery.RecordCount);
/cfscript
You can play a
Won't that loop break if you have a zero-row recordset? This one
won't, and is more readable (I think), and less prone to forgetting
that increment line in the middle.
cfscript
for (LoopStep = 1; LoopStep myQuery.recordCount; LoopStep = LoopStep + 1) {
// stuff
}
/cfscript
cheers,
barneyb
Also
http://www.houseoffusion.com/docs/cfscript.htm
This covers all the loops and is only missing try/catch
http://www.houseoffusion.com/script.ppt
Covers the basic constructs. One trick not covered is a query loop
cfquery ... name=myQuery
... sql goes here...
/cfquery
cfscript
Came across a weird one (or so i think)
cfset i = 5
cfoutput#i GT 0 AND i LT 4#/cfoutput
Returns NO - expected
cfset i = 5
cfoutput#i GT 0 LT 4#/cfoutput
Return Yes - not expected
With the second snippet surely this should error??
Andy
www.andyjarrett.co.uk
No, it's behaving correctly, you've just found one of the edge cases
with a loosely typed language. That second expression is equivalent
to this one:
(i GT 0) LT 4
the i GT 0 part evaluates to true. It's then used in a numeric
context, so it is coerced to the numeric version of true, which is
1 - 100 of 111 matches
Mail list logo
