On Sun, Mar 8, 2009 at 11:42 PM, Claude Schneegans wrote:
I've always thought that all what CFQUERY was doing was to create some
connection to the database, and then the actual content of all records
would be read as needed during some loop on the result set.
That would be impossible for CF
I am not aware of anyone doing so - but if you are able to get it
working, please contact me offlist. I could include the work, or maybe
even just a description of the work, within the Galleon documentation.
On Sun, Mar 8, 2009 at 1:12 PM, Seb Duggan s...@sebduggan.com wrote:
Has anyone ever
On Friday 06 Mar 2009, N K wrote:
I have menu list of items being displayed through CFtree using
foramt=flash. The same code works on CF 7 but does not work on CF 8.
Any idea what would lead to this?
What is being output on the page ? Are all the referenced resources being
loaded ?
--
Tom
Not sure if anyone else has posted this since I started reading this
thread...
http://www.webresourcesdepot.com/jquery-image-crop-plugin-jcrop/
Thanks,
Mike
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
That doesn't work because getArmes contains only a count of the records in
armesArmoriaux, not the actual records.
-Original Message-
From: Al Musella, DPM [mailto:muse...@virtualtrials.com]
Sent: Sunday, March 08, 2009 7:37 PM
To: cf-talk
Subject: Re: What the heck is happening during
I appologise if I really confused you and I am still learning the Coldfusion
and I am unable to code in a proper way.
These are my ColdFuion Fields in the Coldfusion page:
FirstName, LastName,Address,PhoneNumber, EmployerID, DepartmentID ,
DepartmentName, EmployerID, Branch
Sql Database
Yeah, but what are you going to do with 300,000 actual records in a
single recordset?
In his original post, Claude never specified what the requirements of
his CFQUERY were - if we knew what he was trying to achieve, we could
provide better advice on how to do it...
On 9 Mar 2009, at
Nothing is displayed.Yes all the other part of the page is being displayed.
The debugging section shows that the query is running,nothing seems to be wrong.
On Friday 06 Mar 2009, N K wrote:
I have menu list of items being displayed through CFtree using
foramt=flash. The same code works
one sure-fire way to check if the data exists in a table is to run a
SELECT query to select that data.
then check the recordcount of the select query - if it is 0 then no such
data exists; otherwise the data is already there.
depending on your db and exact requirements you may be able to use
More specifically, what are you going to do with 300,000 ntext fields ... that
could potentially be many GB of data, which the server will be holding in
active memory. As a general rule, I leave my ntext fields out of any query
that's pulling a list of more than a few items.
Yes, I can use select statement but I am able to display only the latest
taction taken to the coldfusion page but not all the list of actions taken
in a user session.
On Mon, Mar 9, 2009 at 9:40 AM, Azadi Saryev az...@sabai-dee.com wrote:
one sure-fire way to check if the data exists in a
It gets a connection
from the pool, queries the DB, retrieves all the data and finally
returns the connection to the pool.
Well, I'm stunned. I was sure CF was better designed than that.
I thought that data was retrieved as loops were going.
Obviously course, with 300k records, CF is reading
I noticed a little Windows bug this AM that may affect some of you. My
system clock was showing the correct time, but my CF generated dates and
times were an hour off (behind an hour). This was affecting data base
postings, timestamps, etc.
To correct this I had to turn off the systems
Is your version of Java patched for the latest daylight savings dates?
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/3/10 Robert Harrison rob...@austin-williams.com:
I noticed a little Windows bug this AM that may affect some of you. My
system clock was
I don't think this is unexpected behaviour
It is not only unexpected, it is completely retarded.
All ODBC/JDBC functions are designed so the database can be connected,
then the SQL statement be compiled, then data retrieved row by row, as
needed. Even dBase, Clipper, Foxpro worked this way.
There are a number of reasons why running the select directly in
Access may
appear much faster.
1) You are probably running it locally so there is no costly transfer of
data between servers.
I'm running the CF app locally also, so the difference does not come
from connexion time.
Anywa, the
Change it to this and the time should go down by a factor of about
100,000
Thanks, you bet this is what I would have done if I only needed the
number of records ;-)
The output of recordCount was there only for illustration purpose.
On Mon, Mar 9, 2009 at 4:18 PM, Claude Schneegans wrote:
All ODBC/JDBC functions are designed so the database can be connected,
then the SQL statement be compiled, then data retrieved row by row, as
needed.
CF just needs all the records all the time because that is the only
way to get a
More specifically, what are you going to do with 300,000 ntext fields
I am creating a cross table index on word found in memo fields.
Each memo field needs some special treatment and only some specific
words are retrieved.
So I need to simply read all records and loop on them.
I found another
- if the resultset were never used the query would never be run on
the server;
Well, if the result set is not used, what is the advantage of having the
query run anyway?
- if the resultset were used multiple times the query would be run
multiple times on the server;
If the result set is
CF just needs all the records all the time because that is the only
way to get a recordcount.
While I don't think that is quite true, I do think there is a good
reason for having the resultset downloaded at once. ColdFusion expects
you to use the recordset within the single request and this
just out of curiosity:
did you try experimenting with BLOCKFACTOR attribute of cfquery?
i am just curious, since you already are retrieving such a large
dataset, if using blockfactor makes any difference at all on processing
time...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Claude
that's because you are probably over-writing some variable you created
to hold the action with each subsequent action...
use an array or structure to hold all your action, append each new
action taken to this array/structure, then loop over it to display all
actions taken
Azadi Saryev
IIRC, blockFactor is only relevant on the Oracle drivers, and it refers
specifically to how Oracle expects to batch and return large recordsets. If
Oracle is allowed to spool out large recordsets without returning them in
blocks, it will often spin the DB server out of threads, which then
Yes, that was much clearer. Thank you :)
Are you using the cfapplication tag in your application? Do you have
session management enabled?
If so, you can keep a list of the user's operations in a session variable.
cfset session.array_of_user_actions = arrayNew(1)
cfset
because that is the only way to get a recordcount.
A big price in efficiency to pay for something we use only sometimes.
Most of the time, we only need to know if there are records or not.
~|
Adobe® ColdFusion® 8 software 8
If that's all you need to know, use SELECT TOP 1...
On Mon, Mar 9, 2009 at 11:05 AM, Claude Schneegans
schneeg...@internetique.com wrote:
because that is the only way to get a recordcount.
A big price in efficiency to pay for something we use only sometimes.
Most of the time, we only
Is your version of Java patched for the latest daylight savings dates?
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
What we are really talking about here is having the right tool for the
job.
dBase, Clipper and FoxPro are all database management systems, and so
are designed to work efficiently in examples like the one you are
citing.
ColdFusion is a Web Application server, designed to interact with a
ohh yes.. Thanks a lot.
On Mon, Mar 9, 2009 at 10:56 AM, Azadi Saryev az...@sabai-dee.com wrote:
that's because you are probably over-writing some variable you created
to hold the action with each subsequent action...
use an array or structure to hold all your action, append each
Indeed, while the initial query may take longer, it is perhaps better
performing than hitting the db on each iteration within the request.
Thoughts?
Perfectly right for small result sets.
But as soon as the virtual memory must be used, each record will
generate some read-write-reread action,
did you try experimenting with BLOCKFACTOR attribute of cfquery?
i am just curious, since you already are retrieving such a large
dataset, if using blockfactor makes any difference at all on processing
time...
The blockfactor is supposed to be one by default, but I tried it anyway,
and no, it
blockFactor is only relevant on the Oracle drivers
CF 5 doc says This parameter applies to ORACLE native database drivers
and to ODBC drivers
This is ambiguous, If it applies only to Oracle, it should be stated:
This parameter applies to ORACLE native database drivers and to ORACLE
ODBC
http://apnews.myway.com/article/20090307/D96OSS8G1.html
Microsoft to let PC users turn off IE Web browser
--
A single check box deep in the guts of the next version of Windows is
giving Microsoft Corp. watchers a peek at how the software maker
Hi,
This is my first ever foray into ajax in CF. If I have a set up as below;
cflayoutarea position=center name=center
a href=## onclick=ColdFusion.navigate('page.cfm?id=#id#')nav 1/a
/cflayoutarea
cflayoutarea position=center name=center
cflayoutarea title=TAB1 name=feedTabOne
Ian Skinner wrote:
Stuff I meant to post to the community list.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
On Mon, Mar 9, 2009 at 4:44 PM, Claude Schneegans wrote:
- if the resultset were never used the query would never be run on
the server;
Well, if the result set is not used, what is the advantage of having the
query run anyway?
A select isn't necessarily idempotent (if CF were able to
On Mon, Mar 9, 2009 at 5:05 PM, Claude Schneegans wrote:
because that is the only way to get a recordcount.
A big price in efficiency to pay for something we use only sometimes.
Most of the time, we only need to know if there are records or not.
That is what maxrows is for. The query will
On Mon, Mar 9, 2009 at 4:41 PM, Dominic Watson wrote:
CF just needs all the records all the time because that is the only
way to get a recordcount.
While I don't think that is quite true
It is not strictly true. You can declare a cursor, do a move end, read
from the metadata how many records
if cf did not get the full dataset from the db, would it still be able
to show query debugging / execution times / etc, and would cf monitor
still work and be able to show you long-running/unoptimized queries / etc?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
(if CF were able to determine it was a select in the first place)
Well, it must be able somehow to determine the query returns data,
otherwise, how would it create a structure from any result set?
~|
Adobe® ColdFusion® 8
I've got a query that returns two fields for each record (id, name). There
can be several records returned
Because of the way that the site is set up I need to dump the results into
the session scope and then loop over them on an output page
I think I over complicated it by using Ben Nadel's
A cfquery tag can potentially contain any number of SQL commands which
may or may not return a result set. CF doesn't do any parsing of the
SQL contained within, it just runs it. (The only exception being the
SELECT, UPDATE, DELETE, DROP etc security set up in your datasource
settings-- but
not seeing the need to convert the query to a struct.
cfset session.myQuery = myQuery /
cfoutput query=session.myQuery
#session.myQuery.ID# #session.myQuery.name#br /
(or, if you don't want to fully qualify the names...)
#ID# #name#br /
/cfoutput
depending on how your app is
Probably you can just assign the query to a session variable:
cfset session.myQuery = myQuery /
Then output the query:
cfoutput query=session.myQuery
!--- do stuff ---
/cfoutput
You don't need to change the query itself into structures.
-- Josh
-Original Message-
From: Scott
Charlie, Josh
This worked perfectly... I didn't know that you just dump the query into the
session scope
Thanks a million
sas
--
Scott Stewart
ColdFusion Developer
4405 Oakshyre Way
Raleigh, NC 27616
(h) 919.874.6229 (c) 703.220.2835
-Original Message-
From: Charlie Griefer
hi matt,
the coldfusion.naviagte function takes a paramater where you can post and
pass the tab name that you wish to post to. I think Ray did a good example a
while back.
It is documented in the docs, sorry I cant check at the moment I'm in the
car stuck in traffic using my phone lol.
Thanks
Scott Stewart wrote:
Charlie, Josh
This worked perfectly... I didn't know that you just dump the query into the
session scope
You can dump anything into the session scope.
~|
Adobe® ColdFusion® 8 software 8 is the most
Regardless, CF wouldn't know if the cfquery was going to return a result
set until after it had sent the commands to the database for execution
and waited for the results to come back, and that would sort of defeat
the purpose, wouldn't it?
No, because the driver does not return the result set,
Scott Stewart wrote:
Charlie, Josh
This worked perfectly... I didn't know that you just dump the query into the
session scope
You can dump anything into the session scope.
~|
Adobe® ColdFusion® 8 software 8 is the most
Has anyone done this before? I have an application that is like Microsoft
Project. It shows a list of organizations on the left side and the dates (by
day) to the right. The calendar is a set amount (ex.. October 2008 - August
2010). When the user scrolls to the right, I need the
I am running MX7 on a linux server (ES4) and I am having trouble installing the
DST patch tzupdater.jar. The java community seems to think its a result of the
version of java I am running. (gnu.gcj). How do I go about updating the version
of java I have. Just download and install it? Change
Brian Yager wrote:
Has anyone done this before?
Yes, if you don't have to support I.E. 6, never tried it with I.E. 7 or
8 this was before those existed. But I know longer have access to that
code and only the vaguest idea that I did get it to work once.
To make it work in I.E. 6, I ended up
Brian Yager wrote:
Has anyone done this before?
Yes, if you don't have to support I.E. 6, never tried it with I.E. 7 or
8 this was before those existed. But I know longer have access to that
code and only the vaguest idea that I did get it to work once in Firefox
type compliant browsers.
Thanks Jose, that was my thought also, I've tried all possible parameters of
coldfusion.navigate, nothing seem to work, I'm sure I'm missing something very
obvious, anyone?
Thanks,
Matt.
On 9 Mar 2009, at 19:13, Jose Diaz bleached...@gmail.com wrote:
hi matt,
the coldfusion.naviagte
Michael,
Thanks for the reply.
I already have that handled and it works great.
I am drawing autocad type drawings using the new cf8 image tools and I was
trying to find an easy way to add perspective, but now I am just going to
force the user to be a little more precise by letting them define 3
It seems like you know a bit about databases. Why not write the
looping code in the database using T-SQL, VB, or .NET and keep CF out
of the picture entirely? What is CF providing that makes you want to
use it for this index building task? It doesn't sound like you are
serving up Web pages to
CF has a built-in ColdFusion.Layout.selectTab() function.
read the docs for more info.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Matthew Allen wrote:
Hi,
This is my first ever foray into ajax in CF. If I have a set up as below;
cflayoutarea position=center name=center
a
the code you posted is invalid (probably just bad copy-paste?), so i
will post working code for the test case:
cflayout name=borders type=border
cflayoutarea name=center position=left style=width:100px;
cfoutputa href=##
onclick=ColdFusion.navigate('page.cfm?id=#id#',
59 matches
Mail list logo