We have a process where some PDFs are flattened and some are not. They'll be
flattened later. We use cfpdf for this.
Is there a test that we can do to determine if a PDF has been flattened
already? Currently we're trying to insert a watermark and if it fails, we
suspect it's been flattened.
Also, I should have said that we are on CF9 for this.
thank you.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
I found that if I decouple the encrypt_column from the insert script by
requesting it from dual first, that it then works fine. While I would prefer
to do it without a two-step process, this works fine for now.
cfquery name=qInsertF9099AlienInfo_prep
datasource=#application.dbDataSource#
I suspect you have a charset mismatch. What is the DB charset, CF charset
and what is the setting for sending cfqueryparams as Unicode?
Our Oracle 11g displays âAL16UTF16â as the char set.
PERM is UTF-8
However encrypt_column is returning a binary and it's going into a RAW field.
I did an experiment, calling ENCRYPT_COLUMN without doing the INSERT. I ran it
300 times and it didn't fail once.
cfloop index = x from = 1 to = 300
cfquery name=qInsertF9099AlienInfo
datasource=#application.dbDataSource#
select Encrypt_Column(RPAD(UPPER(NVL(cfqueryparam
Here is the code, simplified somewhat.
This is the INSERT. The a_alien_last_name goes into a RAW (56bytes) field. It
used to go into a VARCHAR. Following this is the ENCRYPT_COLUMN function in
Oracle that is called in the INSERT.
CFSET a_alien_last_name = ''
cfquery
I'll ask about this. I have to wait for the dba to come in.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Previously the encrypt_column was going to a varchar, so it didn't need to do
any of the RAW stuff.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
I may be outside of the CF bounds here, but this problem wasn't showing up
until we added CFQueryParams. We are in CF9.
I am adding CFQueryparams to an INSERT. The item that I am sending over to the
oracle 11g db is empty text. The CFQueryParam is varchar because I am sending
it over as
I am working on CF9 and I am making a pdf. We did this in CF7, but it's much
different in CF9. I have a signature that certifies my document and it's in
.gif form. I need to import that into the pdf right where a form field goes.
I have
CFSET image = expandpath(images\A_CO_Signature.gif)
We are trying to migrate from CF7 to CF9.
We are receiving many timeout errors (500 internal server error. The request
has exceeded the allowable time limit Tag: CFQUERY). We do not receive these
errors on the CF7 server. They both point to the same database.
The Oracle Views that are
I am on CF9. I am making a temp folder and putting pdfs in it. Then I do a
merge.
Afterwards, I do a CFContent to view the pdf. Then I do a cfdirectory, get a
list of the Directories and delete any directories over an hour old. This is
not working.
If I comment out the cfcontent, it works
Thanks. I actually did read the manual before posting. I appreciate the
assistance.
Here's a reference for merging PDF files with CF9:
http://help.adobe.com/en_US/ColdFusion/9.
0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-798f.html
We are moving from cf7 to cf9 and because of that, we can no longer use COM
objects. I've replaced most of the code with cf9 calls, but I cannot do so
with CopyForm, which copies pages of the form. Here is an example:
CFSET r = PDF.CopyForm(14,14)
We use the COM object to update fields in our PDF. However, since we are going
from CF7 to CF9, we are no longer able to use COM objects. I have been able to
replace most of the calls, but we use the COM object call 'copyForm', which
copies pages of the pdf and reinserts it into the same pdf.
We are moving from cf7 to cf9 and because of that, we can no longer use COM
objects. I've replaced most of the code with cf9 calls, but I cannot do so
with CopyForm, which copies pages of the form. Here is an example:
CFSET r = PDF.CopyForm(14,14)
Updating to JVM 1.6 worked great. Thank you all very much for your assistance.
You've been a great help.
~|
Order the Adobe Coldfusion Anthology now!
I am working on an application that does it's own timeout, at 45 minutes. It
gets the last logged in time and compares it to the database current time. The
database time is correct. However, the now() time is incorrect by an hour. I
assume this is due to daylight savings time.
So where
It's a localhost CFServer (developer mode). That is on a VPN that I am using.
The VPN has the correct time. However the now() is incorrect. It was correct
until daylight savings time.
At this point, I assume that it's getting the time from the machine that is
hosting the VPN, which means
Thanks bobby. I can only see the VPN OS, not the computer that serves up the
VPN. It sounds like I should ask them to check that server's time.
thank you.
It doesn't get its time form the VPN, it gets its time from the host
machine running the CF service. Clock in the bottom right corner of
I get:
JRE:=Java(TM) 2 Runtime Environment, Standard Edition 1.4.2_09-b05
tz:=Eastern Daylight Time
dst savings:=1
uses DST: YES
in DST now: NO
I saw that there is an update to 1.4.2_11, but that came out around 2007 I
think. So I would need a more recent update. A coworker said that she
I've been using the term VPN when I meant VM (virtual machine).
Sorry about any confusion and thank you all for your help so far.
~|
Order the Adobe Coldfusion Anthology now!
I have a line of Oracle pl/sql (9i) where I'm trying to add cfqueryparam in CF7.
I have:
#iif(len(trim(arguments.inStruct.a_person_id))eq
0,DE(NULL),DE(#arguments.inStruct.a_person_id#))#,
a coworker suggested:
cfqueryparam value = #arguments.inStruct.a_person_id# CFSQLType =
CF_SQL_NUMERIC
Ah I understand. Great, thank you.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
ah that worked! Thank you.
And thanks everyone for your assistance.
Java classes don't use or require mappings. They need to be specified
in your JVM's CLASSPATH. If you're using CF Standard, you can add
directories to the classpath in the Java and JVM menu of your CF
Administrator. If
hi, same person here.
I am trying to migrate this to another server. However, I cannot read my old
CF7 settings.
I have a java folder with classes in it that are used by the project. The java
folder is at c:/java. I recall that I need to update the Coldfusion
Administrator so that these
it is probably easier if you justr put then in one of the existing paths
rather than add a new one
c:\coldfusion9\runtime\lib
I'll try that to get by, but I need to duplicate the production environment.
It's difficult to update these settings?
I should begin this by saying that I am not a server admin by any means and I
am a novice at IIS.
I've been on CF7 for my app for the past year. I have the developer cf7
installed on the IIS on XP. It's been working great as my localHost.
I've now been given a site that is on CF8. I've
What services are running?
They're the CF ones that are installed.
For cf7:
ColdFusion MX 7 Application Server
ColdFusion MX 7 ODBC Agent
ColdFusion MX 7 Search Server
For cf8:
ColdFusion 8 .NET Service
ColdFusion 8 Application Server
ColdFusion 8 ODBC Agent
ColdFusion 8 ODBC Server
At the
What services are running?
On Mar 9, 2012 11:47 AM, daniel kessler dani...@umd.edu wrote:
In going through my web site configuration - application configuration, I see
a bunch of paths that go through ColdFusion8 and end with jrun.dll. Could this
be the problem?
Will I need to delete
Check your services for jrun... You may need to copy your web inf over
On Mar 9, 2012 11:51 AM, daniel kessler dani...@umd.edu wrote:
I didn't see a service that started with the term jrun. i don't think that I
see any with jrun in the name anywhere. I do see a Java Quick Starter
Just set the ISAPI paths at the website level for the CF7 site to point to
your CF7 install directory (specifically at the jrun dll's)..
ok, that worked. Thank you very much.
Is that the sort of thing that can be adjusted using a .bat file? I don't know
much about them. However, I'm trying
why not just setup separate sites and set each site to use the appropriate
cf version instead of keep switching one site between different home
directories and cf version ?
It's my understanding that the IIS can only do one site (I'm in XP). To do
more, I have to buy the IIS Server. Please
thank you Andrew; I'll read that.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
I'm in CF7. I'm trying to determine where in my interface a .cfm may be
referenced. The interface is very, very complicated with many pages and
sections, so rooting through it isn't a good solution.
I have queries that references a table that I updated. I know the files that
references
I don't think it was too long. However, I don't really understand the
question at all. What do you mean by instances, or interface in
this context?
For instance, I mean something like:
request.oExistCheck = createObject(component,cfc.ExistCheck);
Note that if I searched for
the code you gave is for instantiating a CFC (ColdFusion component) and
only applies to a .cfc file, you cannot do this with a .cfm files as no
extension is given, a .cfc extension is thus implicitly implied.
so this wouldn't work then:
request.oExistCheck =
this would create an instance of ExistCheck, using the file
cfc/ExistCheck.cfc, meaning that wherever this line of code is, there
would need to be a subdirectory called cfc, with a file called
ExistCheck.cfc in it.
You can only create instances from CFCs, though.
Great explanation. Thank you
you have cf_abort in your code instead of cf_abort()
I am using cf_abort.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Looks like the issue is that you have the cf_dump() and cf_abort() calls
outside of the curly braces.
ok, that's a thought that I hadn't considered. I moved them inside the
brackets and now I don't receive an error. Thank you!
Unfortunately, I also don't receive the dump or the abort. I
Unfortunately, I also don't receive the dump or the abort. I even
built an array to dump to simplify the test and assure that there's
dumpable data. sigh I guess I'm just not used to this. Maybe the
logs will reveal what happened.
ok, it looks like the cf_dump() is working. If I put
I added this to my component, but I'm getting an error while calling it from
within the component.
cfcomponent hint=Replaces The Package PK_employer
cffunction name=cf_abort output=false returntype=void
cfabort /
/cffunction
cffunction name=cf_dump output=false returntype=void
To clarify, I receive an error when these function calls are used and no error
when they're commented out.
---
Invalid CFML construct found on line 78 at column 33.
ColdFusion was looking at the following text:
else
The CFML compiler was processing:
a script statement beginning
First off, this is a nearly 4 year old thread. It may or may not apply to
what you're working on now.
What CFML engine and version are you using?
What is the relevant code?
I didn't think reposting was a good idea, since there was a thread with a
relevant history.
I'm using CF7.
I posted
The error code mentions Line 63 as the start of an if () statement, and
Line 52 as the start of the cfscript tag. We'll need probably the entire
if () block at the least, as it would seem the issue lies in there.
Hard to speculate based solely upon the error message, as CF is notorious
for
I'm receiving this error:
An exception occurred when instantiating a Com object.
The cause of this exception was that: java.lang.RuntimeException: Can not use
native code: Initialisation failed.
The code making the call is here:
CFOBJECT action=Create type=COM class=APToolkit.Object name=PDF
Oh, btw it's in CF7.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
When was the last time you fully re-booted the server?
I don't know. The server is in another part of the country. This morning, we
asked them to restart it, though I've not received a reply. So we are going to
try that method.
Any chance the looping couple be done in a stored proc?
No, it's calling a page and that page is full of CF.
However, I've decided to just do 5 at a time and reload the page. It seems to
be working fine.
Thank you everyone for your help. When I move to an app on CF8 or CF9, I'll
look
What about running the task in a cfthread?
I have some tasks that run on a schedule (or manually triggered)
for an hour or two without issue...
It sounds interesting, but from my checking, it doesn't appear to be a CF7 tag.
Setting up a 'grouped' plan to only run x of them is a valid
assessment, but I would suggest that you do this by tracking which
ones need to be redone outside of the page.
An example would be, you could have each of the necessary redone's to
show up in a database table, and mark them as
I'm creating a scheduled_task to correct a problem. For the correction, I'm
doing a query for the list of problem records. Then I'm looping through the
problem records and resending each one of them through the same code that it
went through when it developed the problem. That code has
I have a page with a stored procedure on it. After the stored proc runs, I
have a database call to set some variables. The variables aren't getting set
in the database occasionally. It also seems that the stored procedure, before
the variables are set, times out at occasionally. If a
I've inherited a project and am not familiar with the code.
When this line appears, I receive an error:
cfobject type=java name=encryptObj class=GenerateKey action=create
The error using cfcatch is:
cfcatch.message: Object Instantiation Exception.
cfcatch.detail: Class not found: GenerateKey
okay, I found a directory of java files and GenerateKey.class is one of them.
My local host is:C:/localServer/PERM
and my java files are on the directory above, just like on the dev server. So
I just want to be sure, I reference them like this?
C:/localServer/java
Then I restart the
Dan,
Post the whole class path of the dev (one that's working) and local... might
be easier if we saw it.
I'm not sure how to post the path of the dev because it's mounted as a drive.
I have it as F:\java and the one on my local server is C:/localServer/java.
It's working, so I suppose it's
I have a date/time that I made using SYSDATE and inserted into an oracle table.
It looks like 2010-09-30 13:34:17.0. I have queried for that date to insert
into another table, but when I go to insert it, I receive a missing comma
error. I assume that it has to do with the date because when
I receive the same error with that, missing comma. However, I have just had
an epiphany and this worked:
#createODBCDateTime(registered.date_added)#
I didn't realize it needed to be an ODBC Date, nor do I really know what an
ODBC date is.
Seems like the error isn't really giving much help.
Can you get full debugging from that error on jobs.cfm?
Can we see the code on and around line 346 of jobs.cfm?
How would I get the full error?
The code on and around 346 is the block of code that I posted last.
cfhttp method=POST
Though I still have hope, I'm starting to think that this is a wasted effort,
because I think it's working off a timed session and that Timestamp is
constantly changing. I suspect that's the reason for the 302 error.
I can ask them to provide a query just for me, but the chance of it being
Hey William, I did try that. It didn't help, but thank you.
try changing the value in your script from SPHL-School of Public
Health to 20
~|
Order the Adobe Coldfusion Anthology now!
I want to send a form through CF, without the user entering anything, to the
this page:
https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp
I would like it to display particular results, so I would have to also send it
a field with a value in it. I wish to do this through
Howdy Jason,
I'm having significant trouble making this work. I'm going through, trying to
simplify it as I go. Here's the current state of the code:
cfhttp method=POST
url=https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp;
columns=di_0_20156
I've been take information that I query regularly and instead using cfschedule
to daily write the output to a static file and then using cfinclude on that.
It's been working great. However, I'm trying to do that with a twitter feed
and it's not working. It seems to doing a callback in
I am receiving the error Routines cannot be declared more than once, which is
true. This function can be declared in multiple places so it's sort of
difficult to track.
Is there a way I can test and check whether a function is already declared
(please say yes, it's easy? Can I query for a
When I use an included file, I set a variable = true. then in all
places where you might want to include it again, you check for that
variable, and if it is not present, include the file. if it is
present, you don't include it.
I'm specifically hoping to avoid that. It means that I must
I'm looking to loop through a query and make a list of these:
Daniel Kesslerdan...@umd.edu
cfset the_from = '#the_from#,#fname# #lname##email#'
However, having the and makes it so that the email address doesn't
appear at all. Put in colons instead and it displays the email address fine.
Problem's not the concatenation, it's just the browser interprets anything
between and as tags, so they're hidden by design.
Once you have your list, try this:
cfoutput#htmlCodeFormat(the_from)#/cfoutput
I tried this and the email message failed anyway. It looked great when I did
the
cfset the_from = the_from , fname lnameemail
ok, so this worked. I swear that I had tried this before I posted, but I
probably didn't try and send the email, just viewed it for debugging. In the
view, it's going to do the same wrong thing.
So it's sending emails fine now.
I want to generate a file (by code) that has CF tags in it so that it can be
included into another file. I can write in the # by escaping them, but I also
want to escape the cold fusion tags so that they're not enacted when I write
the file, but rather when that generated file is included in
This is the right way to do it, in general:
cfsavecontent var=content
#chr(60)#cfoutput
li.../li
#chr(60)#/cfoutput
/cfsavecontent
hey thanks! That worked very well. yay!
~|
Order the Adobe Coldfusion Anthology now!
When you say you run the URL separately are you doing this from the
server console? If not, the server may not be able to resolve the
FQDN.
Dave, I'm still not able to get this cfschedule working. When I say run it
separately, it means that instead of cfschedule activating the cf code that
Logging is your friend. :-) Create a log file for your scheduled task.
Does this page sit in an application that requires authentication? If so,
make sure to specify the username and password.
Qing,
I'm not having much luck logging either. jeez. and no, there's no username
and password for
Could it be DNS (change not getting there yet) or permissions
(automatic Windows domain authorisation, for instance, or saved credentials
in
your browser).
Testing directly on the server or locally with something like 'wget'
is normally the best path forwards.
I can't test directly on
Did you see any problems with the code above?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
I have the following task (CF7). The URL that it specifies is not being run.
This is my first task so I assume I'm doing something wrong. I run that url
separately and it works fine. I check my list of scheduled tasks and my task
shows up in that list and appears to be set up the way I
These all worked great. Thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Those were both very interesting. Thank you. They will help alot.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Is there a way to query to find out if I have any active CFSchedule items? I
tried to set up a cfschedule and it's not executing the file that I specified.
I don't have access to the CF server other than through code and I'm looking
for ways to trouble shoot this. I've not used cfschedule
I'm trying to get cfschedule to send out an email. I've checked out a few
tutorials and I don't see the problem I'm having.
I have a page to set the cfschedule and it contains:
cfschedule
action=update
task=facilities_daily_notification
interval=60
Are you aware that you can schedule tasks using a nice GUI from inside
of ColdFusion Administrator?
It's a centralized server so I don't have access to the Administrator.
The problem might be related to setting the start time to now(), since
the CF scheduler is checked for new jobs to process
Try 61 seconds... You can't set a schedule to run every 60 seconds.
good to know, thanks. I set it to 120 with no effect. See my reply above,
please, for the full code.
~|
Want to reach the ColdFusion community with
Maybe the problem is the way that I'm designating start-date and start time.
This code:
cfset start_date = createDate(year(now()),month(now()),day(now()))
cfset start_time = createTime(hour(now()),minute(now())+10,second(now()))
produces:
{ts '2010-03-26 00:00:00'}
{ts '1899-12-30 14:28:29'}
Session data in ColdFusion is tied to unique combinations of user,
browser and domain. And the http and https versions of your website
are
viewed as two different domains. This is due to the normal behavior
of
ColdFusion using cookies to pass the tokens that lets it know with
I have a login page that sets session (session.user). I was told that to make
it a secure login, I needed to go to that page using https instead of http. I
did that and had certificate problems so I backed out my changes.
Since then, anyone that tried to log in when it was using https is
Are you using the secure attribute when setting the cookies?
I don't know about a secure attribute. I'm not setting cookies though, but
session variables.
Is the SSL
domain the same as the non-SSL domain (i.e. secure.example.com vs.
www.example.com)?
I'm just adding an s to http. In
From a session perspective, the session cookie (the browser side of the
session) for https://www.mysite.com is *not* shared with the session
cookie for http://www.mysite.com.
It sounds like they then won't mess with each other. If I wanted to get rid of
the https variables then I could just
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on passport_listing_id)
2 - my original join that was working except i
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on
And here's the page with the data:
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
I seem to be having trouble posting today, so sorry if this shows up a bunch of
times.
~|
Want to reach the ColdFusion
Sorry about the multiple posts. I waited hours for the others to go through
and they didn't, then all at once.
That worked GREAT! Thank you very much. However, I don't really see any
differences from my attempts and yours except that you did the joins on the
FROM and I did it on the WHERE.
I think I should be doing an outer join. I have a set of data
(passport_registration) and I want to add a field from passport_attendance.
passport_registration is a total set because it's the people that registered
for the event. passport_attendance is a subset of those that attended the
I meant to say - this is Oracle.
thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
This code isn't using inner/outer join notation, but the old style. Is
there a reason for this?
It's the way that I learned to do it. I've read your notation; it's certainly
more explicit.
Further though, the assistance that I needed was adding the field
'passport_attendance_id' from the
I'm using Oracle and CF7, doing a Query of Query. I'm attempting to research a
query to find any that the title doesn't have affiliate Faculty in it.
The query of query is giving me an error:
The system has attempted to use an undefined value, which usually indicates a
programming error,
I'm trying to learn to set up a mySQL database. Does CF have to be on the same
machine/server for it to talk to the mySQL database? I'm also not sure if I
have to set up a web server for anything to talk to the database or can I just
give it an IP that the database is on, somehow.
Finally,
When you set up the CF DSN one of
the fields is for the DB server, just add the IP (or name if you have
one) of the server and the port number (probably 3306) and you should
be good to go.
okay. I see. In my case, I'm in a shared hosting environment where CF and
Oracle are given to me. I
Those are good points. Thank you very much.
It's way past time I learned the management side of CF anyway. I'm sure it'll
be good for me.
thanks for taking the time to respond.
daniel
~|
Adobe® ColdFusion® 8 software 8 is
I'm doing this query in Oracle and am encountering the error:
Encountered student_id = OR. Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition,
CFQUERY NAME=passport_attendance dbtype=query
SELECT passport_attendance_id
FROM
1 - 100 of 725 matches
Mail list logo