I am looking for a way to create a function that gets called when the user
changes the layout for example when they change the size of a box/pane or
collapse a area.
I would guess that there should have been a kind of onCollapse, onExpand,
onResize something like that.
Anyone have a solution
http://www.footlocker.com/catalog/supercat_womens.cfm?TID=0supercat=womensmodule=cartaction=topNavViewWomens
http://www.footlocker.com/catalog/shoppingCart.cfm?TID=0
asked by a friend of mine - not a CFspy investigation :-)
On 8/10/07, John Beynon [EMAIL PROTECTED] wrote:
are you seeing .cfm
Billy Cox wrote:
If I understand the question properly, here is today's date in literal
format:
'2007-08-10'
That is what I expected, but this failed.
SELECT aField
FROM aTable
WHERE aDateTimeField = '2005-07-01'
Apparently Oracle needs a DATE command in there. This is what worked
SELECT
the nice thing about this is that if URL.userID isn't an
integer, int() returns 0, and the query executes and simply
returns no records. For us, this is a far preferable method
than what cfqueryparam would do, which is to bomb before
executing the query.
You'd rather run a query
Mike,
Thanks for the response. But the question is this: what benefits will I get
from saying this:
cfqueryparam cfsqltype=cf_sql_integer value=#val(url.userid)#
over just this:
#val(url.userid)#
Am I going to see a significant performance increase? For the sake of
argument, pretend that
As many others have said, there is never a reason NOT to use
cfqueryparam.
You can still use your trick and cfqueryparam doesn't have to bomb:
cfqueryparam cfsqltype=cf_sql_integer value=#val(url.userid)#
M!ke
-Original Message-
From: Ben Mueller [mailto:[EMAIL PROTECTED]
Sent:
I'm trying to determine if cfqueryparam is really worth using.
For data validation, we tend to do something like this:
SELECT username
FROM user
where userID = #int(URL.userID)#
the nice thing about this is that if URL.userID isn't an integer, int()
returns 0, and the query executes and
In general, the more complex the query (multi table joins,
subqueries, that sort of thing), the more complex the
execution plan, and the greater performance benefit from
having that execution plan cached.
On the other hand, the more complex the query, the more likely that an
execution plan
Okay, now I need to do some homework. Are there resources
anywhere that can help tell me what queries would benefit
from such things? My knowledge of SQL is decent, but isn't
quite *that* deep. I would think all queries would benefit
from that.
Basically, if different inputs would
In general, the more complex the query (multi table joins, subqueries, that
sort of thing), the more complex the execution plan, and the greater
performance benefit from having that execution plan cached. You also want to
factor in how often the query is executed as well since a cached execution
Hi Rey,
I submitted iowalum.com/magazine
But I didn't give a contact. If it wins one of the prizes let me know :)
-Carlos
On 8/10/07, Rey Bango [EMAIL PROTECTED] wrote:
Hi everyone,
I'm very happy to announce that GotCFM.com is just 10 sites shy of
reaching 1000 CFML-Powered sites. This
Okay, now I need to do some homework. Are there resources anywhere that can
help tell me what queries would benefit from such things? My knowledge of SQL
is decent, but isn't quite *that* deep. I would think all queries would
benefit from that.
Ben
Am I going to see a significant
Dave, thanks for the reply. I won't bore you with details, but suffice it to
say that we prefer getting empty recordsets back in some cases because it makes
our overall error handling and application flow better--granted, perhaps to the
detriment of application performance. However, for us
I think this is the fastest way you can do it in mssql
SELECT
a,b,c,d
FROM
tbl1
WHERE
tbl1.a = [passed in a]
AND NOT EXISTS (
SELECT 'x'
FROMtbl2
WHERE tbl2.a = tbl1.a
Still, in that case, the DB will simply perform a recompile to find a
more suitable execution plan-- a step which would have had been
performed anyway had there not have been a cached plan. So the worst
case scenario seems to be you would break even. Doesn't seem like you
can go wrong with that.
All,
Thanks so much. I think I'm sold, especially if performance benefits are
really as much as double, by and large.
As far as why we want empty recordsets returned, 99.9% of the time, actual data
is returned from these queries, and so the .1% that a bogus value is passed in,
we find that
You can work off the assumption that all of your queries will benefit. While
I'm sure they exist, I've never seen a query that wasn't faster using bind
variables.
On 8/10/07, Ben Mueller [EMAIL PROTECTED] wrote:
Okay, now I need to do some homework. Are there resources anywhere that
can help
Sounds like the 1000 should have been reached or soon. I presume you
will broadcast the winner here? I submitted three myself.
~|
Check out the new features and enhancements in the
latest product release - download the What's
Yes, a prepared statement using bind variables is going to be significantly
faster in virtually all cases. By significant, I mean twice as fast, if not
more. It depends on the database.
I can't imagine why you'd want to let an invalid value still execute the
query, but if you choose to do this
Rey, I could add a couple hundred or so to the list. Most are somewhat
brochure ware and may only use cfinclude and cfmail (for contact form)
for its only cfcode. But many of them are also database powered.
However, I do not see myself having the time to enter these into the
form. Perhaps there is
Am I going to see a significant performance increase? For
the sake of argument, pretend that sample query I included in
my first post is heavily hit. I'm running SQL Server 2000
(soon to upgrade to 2005).
The answer will depend on whether that particular query benefits from a
generic,
Ben,
Please take a look at the following post by Ben Forta. This should clear up
some why issues for you.
http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks-Easy-To-Prevent-But-Apparently-Still-Ignored
Dan Vega
http://www.danvega.org/blog/
On 8/10/07, Ben Mueller [EMAIL
Thanks, Dan. We know about SQL injection attacks, and that's why we have
things like this:
#int(URL.userID)#
If the value isn't an integer, then int() returns 0, and the query will not
throw an exception. Preventing injection attacks isn't enough of an incentive
to use cfqueryparam--at
OK, I am trying to make a dynamic collabsable menu system. The links show up
fine, but the collapse/Expand parts are not working. Every link shows,
parent and child.
Here is the code:
!--- Get a list of the site navigation from the tblPages table---
cfinvoke
component=CFC.SiteQueries
Hi everyone,
I'm very happy to announce that GotCFM.com is just 10 sites shy of
reaching 1000 CFML-Powered sites. This is really an awesome achievement
and helps to show that CF-technologies are very relevant in today's
Internet development efforts.
To commemorate the 1000th site submission,
There is a way, you use the array syntax to get at a specific value in the
query. Someone already posted about how to do this:
#myQuery['myColumn'][rowNumber]#.
To be clear, you don't want to condense your work into a couple of
databases. You want to normalize your single database to keep the
DATE '-mm-dd'
I guess I can caulk this up to Oracle not my poor memory. I know in the
other DBMS I have used - I did not have to use DATE.
Thank You.
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and
If I understand the question properly, here is today's date in literal
format:
'2007-08-10'
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, August 10, 2007 9:28 AM
To: CF-Talk
Subject: SQL Date Literal Syntax
I think I'm getting old. I've been using
Also, go to google code and checkout litepost. Example blog app showing
a best practice layout for your Model, and how that can translate into
any framework if thought out properly. The example works in Model-Glue,
MachII, and Fusebox 5. Nicely done, though very little in the way of
I think I'm getting old. I've been using cfqeuryparam... so long I
can apparently no longer remember how to properly pass a data literal in
a SQL statement.
I'm trying to run a query through SQL Plus to our Oracle DBMS to compare
to my CF template results. Obviously SQL Plus is not going to
I did a preso for the Nashville CFUG last October. Intro material, and
not overly outdated.
http://mmusergroup.adobe.acrobat.com/p45277812/
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
There are also a few examples apps out there that you can dig into
I used the gallery app that Ray Camden had posted on his blog as practice...
I found that it was helpful to dig into a couple of apps like that after I
had read some docs and done the examples.
And I'm still really learning..
Google man, google!!!
Tutorial: http://www.web-relevant.com/mg_tutorial/
Faq: http://awads.net/wp/2005/06/24/model-glue-faq/
Entire Series from Ray Camden is on www.coldfusionjedi.com on the right
(click My Model-glue series)
Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion
There is a way and someone answered it here in this thread (maybe you missed
it):
Assuming you have always one row returned from the query:
cfoutput#Rate1[time1][1]#/cfoutput
Or, if you have more than one row:
cfoutput query=Rate1
#Rate1[time1][currentRow]#
/cfoutput
Alternatively:
Speaking of frameworks and tutorials, what's good tutorial for model glue?
A potential new job (which I think I got YAY!!! No more consulting!!!) uses
model glue and I need to learn it.
Eric
~|
Get the answers you are looking
Unicode rulez! :)
-Original Message-
From: Crow T. Robot [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 09, 2007 4:16 PM
To: CF-Talk
Subject: Re: MySQL front end...
Oðuz - always with the Unicode. LOL.
On 8/9/07, Oðuz Demirkapý [EMAIL PROTECTED] wrote:
I also searched a lot but
Dave, thanks for the reply. I won't bore you with details,
but suffice it to say that we prefer getting empty recordsets
back in some cases because it makes our overall error
handling and application flow better--granted, perhaps to the
detriment of application performance. However, for
You can work off the assumption that all of your queries will
benefit. While I'm sure they exist, I've never seen a query
that wasn't faster using bind variables.
I've seen plenty, actually. Not that I think that's a justification for not
using it.
Dave Watts, CTO, Fig Leaf Software
Make sure that you have cifide and CFIDE set. I have had issues with
the casing in the past and that is one reason why.
J.J.
On 8/10/07, Ian Skinner [EMAIL PROTECTED] wrote:
A coworker developed an application using Flash forms locally on his Win
XP workstation running a developer version of
A coworker developed an application using Flash forms locally on his Win
XP workstation running a developer version of CF and all was well. He
then published it to our Unix/Apache 2 development server and all went
wrong.
When he runs the simplest Flash Form code on the development server he
How about the Model Glue site?
http://www.model-glue.com/index.cfm?mode=entryentry=FA2A2669-E081-2BAC-6979D3478AEDC219.
Bruce
On 8/10/07, Eric Roberts wrote:
Speaking of frameworks and tutorials, what's good tutorial for model glue?
A potential new job (which I think I got YAY!!! No more
Thank you for your suggestions. I will definitely look into condensing my work
into a couple databases. But as far as the problem I had in case I run into
something like this in the future. I take it there is no way to do what I want
in ColdFusion. It seems like this would be something more
found it : http://www.guidance.com/cs_foot.asp there's also a pdf with the
case study on the infrastructure used :-)
On 8/10/07, Aaron Wolfe [EMAIL PROTECTED] wrote:
Just go to the main page and view the source and look for .cfm. It is
all over the place. Without looking at the source html
Just go to the main page and view the source and look for .cfm. It is
all over the place. Without looking at the source html it hard to see
that it is CF because the site was written to be so SEO friendly.
-Aaron
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent:
Here is another solution I just came up with which I think is a little more
elegent + efficient if neccessary; it removes all blank elements before
looping the array:
cfscript
function RemoveEmptyArrayElements(a_array)
{
var a_fixer = ArrayNew(1);
a_fixer[2] = ;
a_array.RemoveAll(a_fixer);
}
Edit that (woops):
cfscript
function RemoveEmptyArrayElements(a_array)
{
var a_fixer = ArrayNew(1);
a_fixer[2 ] = ;
a_array.RemoveAll(a_fixer);
return a_array;
}
/cfscript
cfset CiteDataArr = RemoveEmptyArrayElements(CiteDataArr)
cfloop from=1 to=#ArrayLen(CiteDataArr)# index=i
Dom
On
are you seeing .cfm in the URLs - i can'tunless you have inside
information :)
On 8/10/07, Assistenza Sito [EMAIL PROTECTED] wrote:
Someone know if the ColdFusion ecommerce software used at footlocker.com is
a packaged one or in house made?
thks
Someone know if the ColdFusion ecommerce software used at footlocker.com is
a packaged one or in house made?
thks
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs
Hi
sorry if this question if offtopic.
I want to develop a site in coldfusion for which I have the necessary skills
but I don't have the finances to buy coldfusion s/w.
I can do my coding in notepad. I would like to host them on some cheap servers
provided. Will I be violating any licensing
Just to pass this along to see if we're not the only ones seeing this issue.
If someone can confirm this, I'll pass it on to Adobe.
It appears that CF 8 is truncating floats from Sql Server 2000.
Thanks,
John Mason
[EMAIL PROTECTED]
770.337.8363
www.FusionLink.com - ColdFusion and Flex
Just to pass this along to see if we're not the only ones seeing this issue.
If someone can confirm this, I'll pass it on to Adobe.
It appears that CF 8 is truncating floats from Sql Server 2000.
Thanks,
John Mason
[EMAIL PROTECTED]
770.337.8363
www.FusionLink.com - ColdFusion and Flex
You can use the free, developer version to build your sites, and as long as
your hosting company has a license, you are good to go.
Look at cfeclipse for building your sites in - it's free and is an excellent
tool, so there's no need to use notepad unless you really want to!
Hope that helps.
Hi,
Have anyone tried to invoke MS Word's Mail Merge feature with CF8? Since we
can do .NET integration now, I wonder if there is a way we can use a query
result as a datasource for the mail merge feature. That way we don't have
reinvent the wheel on our web app.
What I am thinking of is
Anyone on this??? Anyone at all? Sorry if this is off topic but I'm sure
there are coldFusion people using various WYSIWYG editors. Just hoping that
someone uses tinyMCE.
_
Jake Churchill
CF Webtools
11204 Davenport, Ste. 200b
Omaha, NE 68154
http://www.cfwebtools.com
402-408-3733
That is a false statement.
There are reasons not to use it. They come with perils. If the data
being sent to the query does not come from the outside then the only
risk to SQL injection comes from the developers working on the query,
and they have other ways to cause havoc without having to write
There are reasons not to use it. They come with perils. If the data
being sent to the query does not come from the outside then the only
risk to SQL injection comes from the developers working on the query,
and they have other ways to cause havoc without having to write SQL
injection attacks.
Have anyone tried to invoke MS Word's Mail Merge feature with
CF8? Since we can do .NET integration now, I wonder if there
is a way we can use a query result as a datasource for the
mail merge feature. That way we don't have reinvent the
wheel on our web app.
What I am thinking of is
I'm not seeing any unexpected truncation with SqlServer 2000 sp3 on
Windows 2000sp4 using CF8.
Per: http://livedocs.adobe.com/coldfusion/8/Variables_06.html
A real number can have up to 12 significant digits.
I see SqlServer FLOAT values rounded to 12 significant digits in CF8.
Two records
Odd. I've always had problems unzipping eclipse unless I used a 3rd
party tool. I guess YMMV.
--Ben Doom
Eric Roberts wrote:
XP's unzip utility works fine...it's Vista's that has a problem with how
Eclipse is compressed.
Eric
-Original Message-
From: Ben Doom [mailto:[EMAIL
Benbig thread on this very subject all this past weekread the
archives...all questions answered in GREAT detail
Long story shortuse it...no reason not tolots of reason's for ;-)
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group
Mikkel, check the reference guide. There is a whole section just on
the JS api for stuff in CF8. It looks like there _IS_ a way to force
an area to collapse (ColdFusion.Layout.collapseArea), and do the
reverse, but unfortunately I don't see a way to capture the user doing
it.
On 8/10/07, Mikkel
Still, in that case, the DB will simply perform a recompile
to find a more suitable execution plan-- a step which would
have had been performed anyway had there not have been a
cached plan. So the worst case scenario seems to be you
would break even. Doesn't seem like you can go wrong
Hi all,
Anyone dealt with selectOnLoad in CFGRID -- in the docs, it's there, plain
as day, but when I try to use it, I get this:
Attribute validation error for tag CFGRID.The tag does not allow the
attribute(s) SELECTONLOAD.
This is CF8
--
Charles Sheehan-Miles | http://www.sheehanmiles.com
Maybe I'm confused a bit on what we are talking about then. My
assumption was that it _is_ the process of compiling the SQL that
generates the plan based on how the DB expects the code to run, the
sizing of its temp tables, and the input being used, etc.
From my research in the past on MS SQL
Is the CFIDE virtual directory configured correctly?
That did it! I completely forgot about the virtual directory! Thanks!!
JH
~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and
I have just had a quick look at the adobe Docs
and maybe this only works with Queries,
and not CFCs via bind??
CFGRID:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_g-h_03.html#3987012
CFGRIDCOLUMN:
From my research in the past on MS SQL Server, the DB will
stop even in the middle of a proc and recompile because of
any number of factors. For instance, a declaration of a temp
table inside of a conditional statement will cause a recompile.
There are several factors that may cause the
Ahh, I think I see what you are saying. To be more correct I should
have worded your quote as the _OPTIMAL_ execution plan of a piece of
SQL code differs based on your input.
Given that the DB is likely to recompile the code if it senses that the
current plan may not be optimal I assumed you
Works for me... selectOnLoad=false
Here is a demo with it:
http://demo.thinksys.com/cf8/cfgrid/contacts.cfm
Are you still on a beta or the release?
Hi all,
Anyone dealt with selectOnLoad in CFGRID -- in the docs, it's there, plain
as day, but when I try to use it, I get this:
Attribute
Given that the DB is likely to recompile the code if it
senses that the current plan may not be optimal I assumed you
were pointing out that there would be overhead in the
generation of the new plan.
There are a set of specific things that will cause the database to recompile
the plan.
Weird. Definitely the release version -- developer edition, just downloaded
from Adobe 4 days ago. Thanks.
On 8/10/07 10:15 PM, Steve Sequenzia [EMAIL PROTECTED] wrote:
Works for me... selectOnLoad=false
Here is a demo with it:
http://demo.thinksys.com/cf8/cfgrid/contacts.cfm
Are
This was only added in the final version so it sounds like you are still on
an older beta version. This definitely works in the final release.
On 8/10/07, Charles Sheehan-Miles [EMAIL PROTECTED] wrote:
Weird. Definitely the release version -- developer edition, just
downloaded
from Adobe 4
I would just bind the grid to a JavaScript function using the cfajaxproxy.
That JavaScript can trigger anything you want, including a page redirection.
On 8/9/07, Charles Sheehan-Miles [EMAIL PROTECTED] wrote:
All,
Just really getting started with CF8, so if this question is too basic,
such
Hi,
I have ColdFusion 8 on Mac OSX(power PC)java 1.42.
It seems that ColdFusion does not start on startup(it is suppose to), and when
I try to start CF that I can not. I am using the ColdFusion launcher, as I do
not know that commands to use in terminal.
I put the error message here:
74 matches
Mail list logo