If you're going to the Excel manipulation server-side then this is probably
a good bet:
http://jexcelapi.sourceforge.net/
You will need to install the relevant jars on to your server, update your
java classpath in cfadminstrator and then call with cfobject.
After that it should be a simple
Does anyone know how/if you can change the icon indicating a cfmenu has a
submenu. The default seems to be a small grey arrow. Even being able to change
the colour/size of the arrow would be useful.
Cheers
~|
Get the answers
Not sure, but does it need Format=Applet?
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
Not sure but does format need to be Applet
- Original Message -
From: Anthony Doherty [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, October 29, 2007 11:44 AM
Subject: Inserting a record into CFGRID
Im trying to insert a record into my employees table in
Not sure, but does it need Format=Applet?
No the problem i think has something to do with BIND statement - when i
remove this the add button appears fine but i take it you can have an add
button when you are using cfc to bind and change the data within a cfgrid
Im trying to insert a record into my employees table in coldfusion but i have
the update working fine and the delete is also working fine, however i have
added the tags insert and insertbutton but they wont display on my grid.
I have posted my grids code below if someone could help that would
Anthony,
I am pretty sure that the insertbutton and deletebutton attributes are for
applet only, additionally the insert attribute is for applet only, which
means you can't insert a row into a cfgrid only update or delete.
--
Gary Gilbert
http://www.garyrgilbert.com/blog
Can CF use datasources that have been manually created using the Windows
ODBC Admin program?
Or does CF require all datasources be created through the CF Admin
screen?
Thanks,
Dave Bosky | Information Services | HTC | direct: 843-369-8613 | fax:
843-369-7178 | [EMAIL PROTECTED]
Over the last few weeks we have noticed our servers starting to queue up and
often not recover; upon inspecting the stack trace, we invariably see lines
like the following;
Thread jrpp-485:
- waiting to lock 0x60597d10 (a java.lang.Class)
Runing a CFQUERY
at
Hi
Thanks for your replies, Yes i think server side would be easiest. I would ask
the user to browse for the excel document they want them upload it to the
server then manipulate there with server side script.
Thanks for the link i will take a look at it
thanks again for your help
Brian,
Use firebug to inspect the element which should let you know what the style
class for that element is. Then all you have to do is override the element
in your page or include your own style sheet.
The class is located in the
inetpub\wwwroot\CFIDE\scripts\ajax\resources\yui\yui.css. The
I think years ago (CF4) you could just set up a system DSN in the ODBCAD32, but
these days I think you need both. What I do (CF8) is set up the system DSN
first using ODBCAD32, then set the same dsn in the CF Administrator
~|
I have a brand new intranet server with Blue Dragon and SQL Server 2005
Express. I need it to connect to a Pervasive SQL database on another server
so I can put this thing to work.
I have configured an ODBC datasource for the Pervasive SQL connection. Is
it better or even possible to configure
Sean,
Thanks for the response. I just took a look and here is the java version
diff
current
1.6.0_03
mx6
1.6.0_02
On 10/28/07, Sean Corfield [EMAIL PROTECTED] wrote:
On 10/28/07, Dan Vega [EMAIL PROTECTED] wrote:
I have done some searching around and have yet to find an answer. I
upgraded
I'm tracking down my options for converting an uploaded document (variety of
document formats or images) to PDF. Need to do this automatically, server
side. As we're running CF8 - we can do lots of stuff to the PDF afterwards,
but it's the conversion into PDF that's getting to me at the
Our jobbank program needs an upgrade. Currently, the resumes are pasted into
FCKeditor and stored in a database in HTML format. However, this doesn't seem
to be getting the job done, and we've received a deluge of complaints and
demands for the ability to just upload a pdf/word document.
You could do this two (at minimum) ways. One is to add the db content
to your Verity collection. Then you can just search the Verity
collection.
Another option would be to perform both searches and join them using
QofQ. The main problem you would have (I think) is sorting, as Verity
returns a
I'm trying to integrate Ray Camden's CanvasWiki into my main site. The easiest
thing would be to plop it down in a subdirectory and let it fly with it's own
application name. However, I'd like the session information from the main
application available to the sub-application, specifically,
Thanks Gary - that's done it for me
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
There are a lot if issues to work out and understand well but it is
entirely possible to combine Application.cfm / Application.cfc
functionality.
You can have a lower level Application.cfm include a higher level
Applicaiton.cfm template. You can get also have a lower level
Application.cfc
There are a lot if issues to work out and understand well but it is
entirely possible to combine Application.cfm / Application.cfc
functionality.
Well, this would be two application.cfc. I already converted Ray's stuff to
application.cfc.
This may help
http://www.brucephillips.name/blog/index.cfm/2007/8/8/Updating-and-Adding-Records-Being-Displayed-In-ColdFusion-8s-cfgrid
On 10/29/07, gary gilbert [EMAIL PROTECTED] wrote:
Anthony,
I am pretty sure that the insertbutton and deletebutton attributes are for
applet only,
You can extend the parent Application.cfc in the child Application.cfc. Make
sure you don't override the application name though as I'm pretty sure that
would create a different application name (and thus session scope). Also,
make sure you call super() if the parent has any logic that also needs
You can extend the parent Application.cfc in the child Application.cfc. Make
sure you don't override the application name though as I'm pretty sure that
would create a different application name (and thus session scope). Also,
make sure you call super() if the parent has any logic that also needs
Thanks Ron i had already found this link - im gonna have to submit to the
conclusion that you cannot insert a new record to a CFGRID when you are binding
the results as i found the following quote on a live doc
âYou cannot insert new rows directly in a grid that uses a
bind
Greetings all-
I realize this topic may have been covered on this list a while back, but
I'm having problems locating a good answer, so here goes. Typically in our
administrative web sites, on a request, we copy over our session variables
to the request scope so we can have read-access to the
As you know, cfset session.object = request.object / only
creates a pointer to original, and duplicate() doesn't work on CFCs
(we're using CFMX 7). Anyone have a workaround or best-practice solution
for this type of thing?
No workaround is needed. You don't need anything more than a
Can CF use datasources that have been manually created using the Windows
ODBC Admin program? Or does CF require all datasources be created through
the CF Admin screen?
For ODBC datasources, you will need to first define them as System DSNs
within the ODBC Administrator, then define them as CF
I realize this topic may have been covered on this list a while back, but
I'm having problems locating a good answer, so here goes. Typically in our
administrative web sites, on a request, we copy over our session variables
to the request scope so we can have read-access to the information
Anyone have a workaround or best-practice solution for this type of
thing?
The easiest would be that one no longer needs to have locks everywhere when
reading session or other global scopes. The bugs that where the reason for
this old rule of thumb have long been handled. This has not been a
How about a method in all your CFCs called 'copy' (perhaps in a generic base
cfc that they all inherit from):
cffunction name=copy access=public
cfreturn this
/cffunction
I'm quite sure that doesn't return a pointer (no time to test the theory but
I'm sure someone could verify that).
Regards,
Justin,
If the applications are not related at all, what benefits do you seek
to gain from joining the two files. Are you just looking for less
coding time?
William
-Original Message
-From: [EMAIL PROTECTED]
-Date: Oct 29, 2007 9:42
-To: CF-Talkcf-talk@houseoffusion.com
-Subj:
I don't see the problem, users with Web accelerator get their stuff from
Google's cache, not from my server, so I don't even hear about them.
Anyway, our sites are dynamic, we publish news every day, so robots are
asked to not use cache anyway.
No, Google Web Accelerator doesn't rely on
On 10/29/07, Justin T [EMAIL PROTECTED] wrote:
Extension was something that I looked at as I use that extensively
already, but the two applications are not related at all. I didn't want the
onRequestStart, and onApplicationStart events firing in Canvas from my main
application. In addition,
I'm quite sure that doesn't return a pointer (no time to test the theory
but I'm sure someone could verify that).
No, it returns a reference, just like any other assignment that doesn't
explicitly use Duplicate.
Dave Watts, CTO, Fig Leaf Software
I'm looking to share authentication so that users don't have to login twice. I
think I'm going to refactor Canvas a tad so I can just go with extension. It
won't take a lot of work.
I was just wondering if this was something possible as I've never looked at it.
I see that Kinky Ben had
I'm not clear on why you would want to copy the instance instead of create a
reference to it.
That said, you could serialize the original and then deserialize the
serialized version to make a true clone of the object (this requires using
Java though). You could even wrap up this logic into a
No, Google Web Accelerator doesn't rely on Google's cache, it prefetches
links from your server.
Are you sure about that ?
It uses client software installed on the user's computer, as well as
data caching on Google's servers...
( http://en.wikipedia.org/wiki/Google_Web_Accelerator )
Sending
Afternoon all,
I have just received a new project that requires very sensitive information
about assault victims to be stored in a sql 2k database. I have already
gotten the SSL up and running but can anyone give me some ideas has to how
you might securely store/encrypt that information in the
Can anyone point me in the right direction.
I would like to update form elements as a user makes changes. So instead of
hitting a submit button, I'd like each one updated via AJAX through a CFC.
Are there any downsides to doing this? Are there any tutorials or docs to
help me accomplish this? I
Jeff,
I think we might need more clarification here. ...update form elements
as a user makes changes has a few different meanings. If field
elements (say city and state) are bound to other elements (like a zip
field), then you might use Ajax to update the city and state with info
brought
Ok... Hopefully I can explain this a little better.
In simple terms... Say I have a mailing list signup form with different news
letters.
=
{{You have been added to [mailing list X] using [email address select]}}
[ ] Mailing List A [email address select]
[ ] Mailing List B [email
Thanks everyone for responding. Unfortunately, the method suggested by Rich
below seemed to create a pointer rather than a separate instance of the
object, as I had hoped. However, after discussing this with a co-worker, we
seem to have cooked-up a viable solution.
There were two objects I wanted
Yes, but why are you creating a copy in the first place? Why do you think
you need a copy and not a reference?
On 10/29/07, Ryan Heldt [EMAIL PROTECTED] wrote:
Thanks everyone for responding. Unfortunately, the method suggested by
Rich
below seemed to create a pointer rather than a separate
You can replace the loading.gif image in
cfide/scripts/ajax/resources/cf/images with any image you like.
On 10/29/07, Asim Manzur [EMAIL PROTECTED] wrote:
I am using HTML CFGRID using the ajax calls, and wondering that if there
is
any way to replace the loading image, (the one which is right
Is there a way to add custom functions to ColdFusion, so that I can
reference them without having to put them in a cfc or cfm page?
For instance, I've written a simple, user-defined function. But I don't
want to save it in the Application or Request scope, because it needs to
be available
I have a presentation with a installation guide for CFX_payflowpro - the one
provided with the custom tag does not work when followed exactly.
http://www.colderfusion.com/presentations.cfm -- Dec '06
I believe there's some authorize.net stuff in there also - what you're looking
for is the PDF
The objects I am copying from are persisted in the session scope. I would
like to be able to read from these objects at runtime without having to lock
them all over the place. Does creating a pointer in the request scope to an
object in session absolve you from locking? I'm not sure, and to be
On 10/29/07, Dan Vega [EMAIL PROTECTED] wrote:
Thanks for the response. I just took a look and here is the java version
diff
current
1.6.0_03
mx6
1.6.0_02
Hmm, I didn't think MX actually ran at all on Java 5 or 6?
--
Sean A Corfield -- (904) 302-SEAN
An Architect's View --
On 10/29/07, Rich [EMAIL PROTECTED] wrote:
I would suggest that you create a Session Facade and then have all your
objects reference the façade. It is generally a bad idea to have an object
reference an external scope (session, request, etc.), and this technique
hides the implementation from
is there any open source admin style interface from CF to an MS access
database to give access to raw tables information or a query window or
anything of this type?
Thanks
~|
Create robust enterprise, web RIAs.
Upgrade to
cfquery name=myQry datasource=myaccessdsn
#form.query#
/cfquery
cfdump var=#myQry#
That should probably do the trick. Of course it's very unsafe, and will
allow people to do anything they want to the db, which is sort of the idea,
I guess.
Russ
-Original Message-
From: Scott Raley
Is this what you're looking for?
http://cfdbexplorer.riaforge.org/
All you'd need to do is set up a ColdFusion DSN to your Access database.
-Original Message-
From: Scott Raley -ITC [mailto:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 3:57 PM
To: CF-Talk
Subject: Access db
is there any open source admin style interface from CF to an MS access
database to give access to raw tables information or a query window or
anything of this type?
Thanks
~|
ColdFusion is delivering applications solutions at
I am using HTML CFGRID using the ajax calls, and wondering that if there is
any way to replace the loading image, (the one which is right beside the
paging buttons) or any other way to display some kind of animation while the
grid is being loading.
Thanks,
That is, in fact, what I am doing. I have a AuthenticatedUser CFC that
contains all of the information about the user that is signed in. Now, for
example, say I want to run a query that gets all of the timebills for that
user, I would SELECT foo FROM bar WHERE UserID =
Graham,
I haven't seen this exact error before, but do you perchance have a
cflock around the QoQ code?
Query of queries are very expensive on the server and grow more so as
the record set being manipulated increases. Many times, the same
functions performed in QoQ can be performed by
This can get tricky because the user can fill out the form without using the
mouse by tabbing with the keyboard. So you'd need onKeyPress handlers for
each field as well.
I suppose I'd be careful with this, but nothing is stopping you from doing
it. Most people are used to having things save when
Ryan.
You don't have to lock shared scope variables, unless you need to
account for race conditions.
Mark
On 10/30/07, Ryan Heldt [EMAIL PROTECTED] wrote:
The objects I am copying from are persisted in the session scope. I would
like to be able to read from these objects at runtime without
Every since upgrading to CF8 I've been having a frustrating problem. After
starting CF, it will run for a while (sometimes serveral hours, sometimes
less than an hour) at about 1% - 3% in terms of processor load. (It's a 2
cpu - 4 core system.) Then, all of a sudden, the processor load will
Yes, but why are you creating a copy in the first place? Why do you think
you need a copy and not a reference?
I think he is copying from the session scope to the request scope, and he
does not want to change the session object's values when changing with the
request object's values.
-- Josh
There should, since MX6 or so, be no reason to create read-only locks
unless you have some sort of weird race condition going on. All session
vars are thread-safe, and so cannot be simultaneously read and written to.
So, you don't need to be absolved from locking even if you are
referencing
Ryan Heldt wrote:
The objects I am copying from are persisted in the session scope. I would
like to be able to read from these objects at runtime without having to lock
them all over the place. Does creating a pointer in the request scope to an
object in session absolve you from locking? I'm
Unless you have an issue with race conditions, you don't have to bother with
any of this. If you do have a situation where a race condition will cause an
error, just add locking for that situation.
On 10/29/07, Ryan Heldt [EMAIL PROTECTED] wrote:
The objects I am copying from are persisted in
And having references to sessionFacade.getFoo() everywhere is somehow
better than having references to session.foo?
I think you are getting stuck on the name 'sessionFacade'; I was attempting
to suggest abstracting access to the variable of which his components had no
direct knowledge. If my
At the risk of disagreeing with Sean, which usually ends up with me
realizing I'm wrong about something...
On 10/29/07, Sean Corfield [EMAIL PROTECTED] wrote:
And having references to sessionFacade.getFoo() everywhere is somehow
better than having references to session.foo?
I do see a
Anyone seen this, or have any ideas. BTW, I'm running the
standard edition of CF so I don't have access to the server monitor.
I suggest you invest in one of the other monitoring tools available -
SeeFusion or FusionReactor. You will likely find the problem a lot faster,
and it'll pay for
The objects I am copying from are persisted in the session
scope. I would like to be able to read from these objects at
runtime without having to lock them all over the place. Does
creating a pointer in the request scope to an object in
session absolve you from locking? I'm not sure, and
That is, in fact, what I am doing. I have a AuthenticatedUser
CFC that contains all of the information about the user that
is signed in. Now, for example, say I want to run a query
that gets all of the timebills for that user, I would SELECT
foo FROM bar WHERE UserID =
I have just received a new project that requires very
sensitive information about assault victims to be stored in a
sql 2k database. I have already gotten the SSL up and
running but can anyone give me some ideas has to how you
might securely store/encrypt that information in the
I would like to install something on our server that will check an emails spam
score before we send it out to catch any problems. Is there any solution cfc,
java, .net, server software ( windows 2003 ) that anyone knows about. Having a
hard time refining google search to come up with a
On a four core system, a CPU pegged at 25% means one core is at 100%;
CF has probably filled the JVM memory and is permanently garbage
collecting.
I agree with Dave - get FusionReactor and set a memory alert threshold
in the crash prevention options.
On 10/30/07, Kevin Pompei [EMAIL PROTECTED]
Yes you can,
We do this via Application.cfc, using the following technique. The udf.cfm
has all the common functions.
!--- Request ---
cffunction name=onRequest returnType=void output=true
cfargument name=targetPage type=string required=true/
That only includes the UDF into the variables scope of the requested
page. They won't be present in CFCs, custom tags, etc.
cheers,
barneyb
On 10/29/07, Dale Fraser [EMAIL PROTECTED] wrote:
Yes you can,
We do this via Application.cfc, using the following technique. The udf.cfm
has all the
Kevin,
What codebase are you running on it?
Mark
On 10/30/07, Kevin Pompei [EMAIL PROTECTED] wrote:
Every since upgrading to CF8 I've been having a frustrating problem. After
starting CF, it will run for a while (sometimes serveral hours, sometimes
less than an hour) at about 1% - 3% in
No hacking necessary, just place your tags in /WEB-INF/cftags.
On 10/30/07, Nicholas Vacek [EMAIL PROTECTED] wrote:
Is there a way to add custom functions to ColdFusion, so that I can
reference them without having to put them in a cfc or cfm page?
For instance, I've written a simple,
That's for tags, not functions.
cheers,
barneyb
On 10/29/07, James Holmes [EMAIL PROTECTED] wrote:
No hacking necessary, just place your tags in /WEB-INF/cftags.
On 10/30/07, Nicholas Vacek [EMAIL PROTECTED] wrote:
Is there a way to add custom functions to ColdFusion, so that I can
You could also install the Dev version locally at and try running the code
with the server monitor turned on.
On 10/29/07, Kevin Pompei [EMAIL PROTECTED] wrote:
Every since upgrading to CF8 I've been having a frustrating
problem. After
starting CF, it will run for a while (sometimes serveral
Ah, that'll teach me to half-read a question.
On 10/30/07, Barney Boisvert [EMAIL PROTECTED] wrote:
That's for tags, not functions.
cheers,
barneyb
On 10/29/07, James Holmes [EMAIL PROTECTED] wrote:
No hacking necessary, just place your tags in /WEB-INF/cftags.
--
mxAjax / CFAjax docs
I would like to install something on our server that will check an
emails spam score before we send it out to catch any problems.
If you know of one I'd love to hear about it as well.
One idea that came to mind - if there were a way to use CFExecute to
fire off SpamAssassin and tell it to
That's for tags, not functions.
What about the base component? Correct me if I'm wrong but while it does not
fit with all the restrictions the base component automatically inherited by all
components. So you might be able to use this for your UDF's.
Hey ... I just stumbled across this thread. In the future - If you guys
would like to make a little cash off a referral, Alagad will pay you. Check
out the Alagad Affiliate Program here:
http://alagad.com/go/footer/alagad-affiliate-program
And, BTW, we can do anything Figleaf or Teratech or any
I think you're referring to %ColdFusion%/WEB-INF/cftags/component.cfc
Might want to give this a read first:
http://www.briankotek.com/blog/index.cfm/2007/8/27/Base-CFCOMPONENT-Rant
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 9:14 PM
On 10/29/07, Rich [EMAIL PROTECTED] wrote:
I think you are getting stuck on the name 'sessionFacade';
Only because that's what most people do *literally*.
I was attempting
to suggest abstracting access to the variable of which his components had no
direct knowledge. If my code is calling
On 10/29/07, Brian Kotek [EMAIL PROTECTED] wrote:
And since I have never run into a situation where different
services needed to use different persistence mechanisms
I have. One day you will too.
peeveAnd it's not persistence - memory is not persistent by
definition, disk-based systems are
On 10/29/07, Larry Lyons [EMAIL PROTECTED] wrote:
What about the base component? Correct me if I'm wrong but while it does not
fit with all the restrictions the base component automatically inherited by
all components. So you might be able to use this for your UDF's.
That would make the
On 10/29/07, Brian Kotek [EMAIL PROTECTED] wrote:
just because I do this, I was missing the fact that many people might not
impose the same limitation on themselves. By eliminating the centralized
facade, you're not even giving other services the possibility of digging
into shared scope data
On 10/29/07, Sean Corfield [EMAIL PROTECTED] wrote:
For mock testing, just extend that service CFC and override that one
method. That one method is often responsible for creating the cached
object on-demand so the extended mock can double up as both a mock for
the cache access and a way to
I'm curious, then, how you handle reference to the session scope in your
service. Do you actually reference the session scope directly? One of the
things I like about the centralized SessionFacade is that it is easy to test
by feeding in a fake struct that the facade uses in place of a real
On Oct 30, 2007 12:46 AM, Sean Corfield [EMAIL PROTECTED] wrote:
Once a
service has access to a generic facade like that, it can access *any*
data behind that facade and the faux-encapsulation of the facade
encourages developers to do so, believing they're using good OO
practice. All that
90 matches
Mail list logo