Try iText. It's comes bundled with CF and is what runs CFDOCUMENT.
I stopped using CFDOCUMENT years ago in favor of directly calling iText.
It's a lot more powerful and stable.
Warren Koch
-Original Message-
From: Igor Ilyinsky [mailto:cf-t...@maverickmaven.com]
Sent: Friday, June
Hi, I was doing some testing my CF pages and got a surprise. I use Session
variables to hold certain pieces of user information. I had always thought
session variables were unique to a browser session such that each new
browser invocation would get a new, unique session variable that would be
I really didn't want to use any kind of cookie. I have data in the session
variables I don't want compromised in any way. I was just hoping the J2EE
solution would be a magic bullet.
-Original Message-
From: Kelly [mailto:webd...@gmail.com]
Sent: Friday, April 01, 2011 12:32 PM
To:
of these, and probably
both. Setting CFCOOKIE with no expiration is a browser-level cookie; no
user files necessary.
From: CraigSell craigs...@charter.net
Sent: Friday, April 01, 2011 2:03 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: RE: Session
If you are doing the insert inside the Oracle stored procedure, then you
have to commit inside the stored procedure. I have evolved into setting up
a general exception process so that if, for some reason, a stored procedure
fails, it can call a rollback and send some sort of a status message
Shannon is right on. However, I tend to use a weak ref cursor like
PROCEDURE procName (
(input params)
p_cursorOUT sys_refcursor)
Makes thing much easier.
Your example is not returning cursors. All you are doing is looping over a
cursor without outputting anything except to the
I have a large array of struct I'm trying to send to oracle. Right now I'm
converting it to a clob using delimiters, then parsing the result on the oracle
end. It's not running well on oracle due to all the parsing.
I was hoping I could turn the array into a refcursor and send that to
In Cold Fusion I have a large array of struct I'm trying to pass into ORACLE
10g using stored procedures. I am hitting a performance wall inside ORACLE
(probably self inflicted).
I don't know of a way to transfer a complex array directly to ORACLE -- if
there is, I'd love to hear it.
So
I'm in the same boat. Here's a little code I knowkced to gether to tell me
waht was going on for my CFMX8 instance
!-- put in server root --
ColdFusion Information - click on struct for infomationbr
cfoutput
brBase Template Path = #GetBaseTemplatePath()#p
cfdump var=#server#expand=no
I would use iText (http://itextpdf.com/). It's the same code that runs
behind CFPDF. I gave up on CFdocumnat about a month ago and haven't looked
back. The amount of control I have is great, all my layout issues went
away, and it runs faster. CF7/8 ships with version 2 but I used version 5
I jsut started working with iText version 5.0.1 from my CF8 8.0.0 instance.
Soon we will be migrating to CF9. Does anyone know the itext version that
ships with CF9 and if there are any differences with the latest version? I
know the new version was refactored so that it no longer conflicts
Just a little update on my problem after digging with Adobe.
CF 8.0.0 had all the scaling and such in CFDocument tag messed up. You are
supposed to apply hotfix 3 to correct it. It mostly does that but underlining
still doesn't work right.
CF 8.0.1 also needs hotfix3 applied to correct the
I'm trying to get someothing to underline properly in a CFDocument tag. So far
the tag is winning and refusing to underline to the end of the top line. Does
anyone have a fix for this or am I missing something obvious?
I am running CF8 with Hotfix3 and the CFDocument update.
Thanks!
Warren
Well, I may have answered my own issue. We have been applying version 8.0.1
hotfixes but my version is 8.0.0. The problem goes away in version 8.0.1.
Somehow no one applied the 8.0.0 to 8.0.1 updater and I didn't catch it.
Sigh.
Warren
Is there some way to introspect settings like the Site Wide Error Handler using
something like the Service factory? I don't have access to the CF
Administrator on CF8 but there are times when I need to figure out basic
settings.
Thanks!
Warren
Good idea but.
I am already using the Site-wide error handler to invoke a template.
Problem is I can't remember what template it was set to on various CF
instances I run. Since I don't have access to CF Admin, I'd like some sort
of way to introspect the instance and find out what that
Sorry. I meant I have a bunch of separate CF8 installations on different
physical servers. We do one cf install per base application URL here so one
server can have a lot of CF installs. I guess I have a dozen different
installs to keep track of.
I would love to be able to read the
I can manually figure it out as suggested by sweeping for recognizeable
text.
I was hoping for something simpler and more powerful that would tell me that
parameter and others on the Server Settings page, giving me tool for future
use. I'd really thought there would be some sore of Java
Hi!
I have an ORACLE stored proc returning a query back to my CFC using
CFProcResult. I pass this query up to Flex and some other places. Works fine
but
What I'd like to do is remove a column or two before I pass it on. Selected
columns are only needed by the CFC so I'd like to
Well,
For two reasons
1) I really didn't want to incur the overhead of creating a new variable
and running the query. I know it has to be much slower than simply dleting
for the object. Not the best reason but...
2) Maintenenace issues. The columns I wish to delete are fairly static but
That's a good way to re-use the variable. Since there doesn't appear to be
a simple function, that's the way I'll go.
Thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
You really don't need to use analytics in this case.
The inline subquery presented by Mr. Holmes is the correct one.
See
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/pseudocolumns009.htm#i1006297
Although this is for 11g, it holds for the other verisons as well
Here's some similar code I cobbled together which tells you a bunch of info
about the server. I don't have access to the Server Admin and was tired of
annoying the server team when I (or they) forgot something.
ColdFusion Information - click on struct for infomationbr
cfoutput
pbServer
I can't answer your question since we are still on 10G but I would suggest
you check/update the drivers. We were running the drivers that came with
CF7 -- certain things in 10G wouldn't work at all. We are now running 3.50
on CF7 and 3.6 on CF8.
You need to refresh the datagrid after the user submit comes back
successful. Just fire the same function that populated the grid in the
first place from the user input result handler.
You can also do that in the CFC too. If the update is successfull, have the
CFC retreive a fresh set of
Good points.
It seems to be an ORACLE thing. You can make the Global Temporary table
either transaction or session specific using the ON COMMIT clause (DELETE
ROWS or PRESERVE ROWS). No, we don't drop tables since there is only one
type of temporary table. You just specify how it responds
There is one other thing to consider in using connection pooling. I admit
it is a bit off the beaten path but it bit me pretty good. I use Oracle
stored procedures as much as I can. You cannot use connection pooling if
your stored proc uses Global Temporary Tables. Since the connection is
Need help with another shining example of my ignorance -- I'm more of a
developer than a webserver person.
We are working on one of our CF webservers and noticed something strange. A
user was running a very long query which subsequently displays on the browser
(10+ minutes, tons of data -
I said not to ask.
Just to answer what the heck are we doing --We are looking at all the
possibilities. The instance in question has thousands of pages on it
running all sorts of bad code built over10 years by a host of developers.
When activity recently picked up on this server and the
I've been working with JAKARTA POI HSSF to create spreadsheets and have run
into a strange issue. Certain HSSF methods become unavailable when the
workbook is contained in a query loop. An index loop works fine but the query
loop throws an error:
Oops! Sorry.
Here's the code that throws the error. If you remove the CFLOOP tags, the
addMergedRegion method becomes available.
Merged Cell Test CFoutput#now()#/cfoutput
cfset myQuery = QueryNew(REGION, STATE, ZIP, VarChar, VarChar,
VarChar)
cfset newRow = QueryAddRow(MyQuery, 1)
cfset
Sigh. That fixed in my simple example. I will have to go back to my more
complicated development code and check to see I didn't do something this
silly twice.
Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most
DTS functions were moved to SSIS (SQL Server Integration Services). There
is a wizard in there which will migrate your old DTS package into SSIS. The
SSIS language and format is different than DTS so they need to be imported
or re-written. That's as far as I can take you. Our company is
We've been having a problem with our cfmx7 server. Something is grabbing all
the memory and refusing to release it. The memory just spikes right up and
sticks. The only way we have been able to fix this is to restart. We are
trying to use FusionReactor to figure out the cause but so far
It's more than just varring or cfc's -- i know we have issues with that but
not to the extent where 1gb of memory is consumed in no time flat. Problem
is this is a corporate box -- lots of developers at varying levels of
experience with thousands of pages. I can't tell what the heck is
We are running Jrun version 4.
Our plan is to try and tune the JVM -- it needs it. We have folks who
specialize in that and will be bringing them on board as soon as they are
available.
Immediate problem is whatever is grabbing the memory is not releasing it so
the GC can clean it up. Or
No, neither application shows memory usage at the thread level. They only
display the two types of allocated memory in the heap-used memory and total
memory at the time the thread was running.
I would love to try and tune the server but I don't own the box. I have
no access at that level.
Please be kind -- I am JAVA illerate.
I am creating workbooks using POI HSSF. Here is a code snippet from a page:
cfset myWorkBook =
createObject(java,org.apache.poi.hssf.usermodel.HSSFWorkbook)
create and fill workbook sheets with data..
cfscript
context = getPageContext();
Thanks! I was hoping it was something easy -- I can live with doing nothing
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
know
the difference.
cheers,
barneyb
On 12/2/08, Craigsell [EMAIL PROTECTED] wrote:
We currently have a CFMX7 application that uses Jakarta POI HSSF to
create
excel spreadsheets from a query. We initially chose POI because we
wanted a
higher degree of control over cell formatting
Your POI code could be optimized for memory usage. POI has problems
with memory leaks, but these problems are fixable with
experimentation. String handling is a place to look for optimization.
In my experience, a suboptimal arrangement of the POI code could be
the difference between creating
We currently have a CFMX7 application that uses Jakarta POI HSSF to create
excel spreadsheets from a query. We initially chose POI because we wanted a
higher degree of control over cell formatting (currency, date, etc) than what
we could get in CFReport. The problem is that POI is eating
The Datadirect Driver for Oracle supports returned ref cursors but not
encryption. The Oracle Thin Client Driver supports encryption but not
returned ref cursors. I seem to recall the older Data Direct drivers did
not support ref cursors but that was some time ago
3.6
~|
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
Archive:
My 2 cents
I use ORACLE stored procs exclusively (using a CFSTOREDPROC tag) and have
found them to be great. There are things I can do in stored procs that
would be difficult to do in a CFC. I can easily have multiple datasets
returned in one call. And the CFPROCPARAM gives me the same
Bobby is right. The userid and password in the code will override the DSN.
Just put in a dummy user name and password.in the DSN if you must have one.
The DSN won't verify but so what?
Warren Koch
~|
Adobe® ColdFusion® 8
I'm trying to use functions in a QoQ to parse out some text. I have a
directory that has folders of images in it. What I want is a simple QoQ that
will extract the directory and filename from a CFDIRECTORY tag into another
query. My plan is to put this resulting query into the application
Dang. I was trying to keep this in a query datatype so I could use it in
subsequent QoQ. I wanted to get rid of the names I don't need to reduce
memory usage -- I have a lot of image names to store!
~|
Adobe® ColdFusion® 8
Thanks! I just realised that I could do that. Now I have to figure out
whether it is a good idea to store 6 rows in an application scope query.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
To what CF8 goodies do you refer? I do everything in ORACLE (mostly using
stored procs) but I haven't had a chance to do a deep dive into CF8 yet...
Thanks!
Warren Koch
~|
Adobe® ColdFusion® 8 software 8 is the most
What database are you running?
Things like this are much better left to the database than the web server.
For example, on Oracle I'd write a stored procedure to calculate and return
each report's data, then use CF/Flex to show the resulting data. Or I'd
make an Oracle view, depending on how
That range matches all the characters in the ascii chart except the control
characters. Same as saying give me all the Ascii characters from Ascii 32
(space) to Ascii 126 (_). I thought it was a bit more restrictive than the
dot operator.
In the [\w -~], the -w is actually redundant since
If tmp 0, it's there!
reFindNoCase(a[ ]+href[ -~]+productID[ -~]+/a,inputString, pos)
Warren Koch
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Sorry -- you only wanted it if productid was in a query string.
Try this
reFindNoCase(a[ ]+href[ -~]+\?[ -~]+productID=[ -~]+/a,inputString,
pos)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
http://www.adobe.com/products/coldfusion/editions/#s4
Developer edition is free. All that's left is the will to learn.
I'll bet that as Adobe merges more applications together like the are doing
now (LiveCycle, CF, Flex, etc.) and make everything PDF compatible, the
market share will
CF is great but CF coupled with Flex is even better. We have a lot of Java
developers here who don't think much of CF but they kinda gulp when they can
see what a Flex front end and a CF backend can do. Flex is starting to make
inroads here since it is easy to make killer apps with it and it
Interesting site. One thing you should add. From nobosh you can get to
answers via that tiny navigation bar. I would make that bar a bit taller if
you want folks to know it is there. And I would add the same navigation bar
to answers so you can get back to nobosh -- there was no way I could
An option would be to create different accounts in Windows - one for work
and one for home. That way you can configure each (including the startup
folder) however you want and maintain separation between them.
Warren
~|
I'm pretty sure you don't need to use all that concatention. Try:
cfset sqlQuery = insert into testTable(testID,data1,data2) values
(#testIDValue#,'#data1Value#','#data2Value#');
Warren Koch
- Original Message -
From: Richard White [EMAIL PROTECTED]
To: CF-Talk
And to further emphasize that -- I would encourage the use of stored
procedures whenever possible. I've been using Oracle stored procdures with
CF for years with great success. You all the benefits of the CFQUERYPARAM
and you let the database do what it does best -- process data.
Warren Koch
so.
On Jan 21, 2008 12:16 PM, Craigsell [EMAIL PROTECTED] wrote:
And to further emphasize that -- I would encourage the use of stored
procedures whenever possible. I've been using Oracle stored procdures
with
CF for years with great success. You all the benefits of the
CFQUERYPARAM
From http://www.tri-phase.com/data/pdf/coldfusioncookbook41.pdf
Does CFFILE have a file size limit?
There is no specific limit on file size for CFFILE. However, CFFILE loads
the file into the server's memory, so you will get an error if the file size
exceeds the amount of free RAM.
Also note,
Dave is right --- when in CF use CF!
Here's a code snippet fron June 19,2003 entry is Chris Cantrell's blog (he's
an Adobe expert)
http://weblogs.macromedia.com/cantrell/archives/coldfusion/index.cfm
cffile action=readbinary file=/home/cantrell/Pictures/Corrs2.jpg
variable=pic/
cfcontent
63 matches
Mail list logo