On Monday 10 Mar 2008, Gert Franz wrote:
the next patch release will contain the fix, so that cfc objects can be
passed according to your needs. I'll let you know.
Great news Gert, cheers !
--
Tom Chiverton
Helping to challengingly negotiate dot-com clusters
on:
Tom,
the next patch release will contain the fix, so that cfc objects can be
passed according to your needs. I'll let you know.
Greetings from Switzerland
Gert Franz
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List
german: http://de.groups.yahoo.com/group/railo/
On Friday 07 Mar 2008, Kevin Aebig wrote:
Hey Tom,
If you want to simply use a native support for AMF0, you can use the
NetConnection class instead. I've successfully used it with old versions of
I've found renaun.com's RemoteObjectAMF0 which seems to work better, just not
with Railo (yet
On Friday 07 Mar 2008, Ruf Manuel (SEFH 2) wrote:
Now I can handle complex data types in CF using structures, but the
inheritance part doesn't work.
If you have the WSDL of a web servive that doesn't work, I'm sure the eng.
team will try and take a look at it...
Using complex and large
Hi Mike
Does this look ok to you ?
I have added the CHTTP tag to load the CSV file, but is the get all
users from active directory look correct ?
!--- get the csv file ---
CFHTTP METHOD=GET URL=http://localhost/filename.csv;
NAME=csvQuery
!--- get all users from Active Directory ---
Hi William, Thanks for your reply.
Yes, that is what I've been doing for a while now. The only problem is that it
messes up my display:
cfoutputDisplaying #StartRow# to 25 of #Query.recordcount# results/cfoutput
This is not too much of a problem with lots of rows returned. However it looks
Just so you know Will, I've had no problems getting file uploads working
with Spry tabs. I seem to recall finding the CF8 tabs problematic and
switching to Spry, which seems to work much better. Might be worth a look.
Cheers
Will
-Original Message-
From: Will Tomlinson [mailto:[EMAIL
Anyone else who could shed some light on this or who tried something similar?
If all else fails I might fire off a request to adobe.
On Friday 07 Mar 2008, Ruf Manuel (SEFH 2) wrote:
Now I can handle complex data types in CF using structures, but the
inheritance part doesn't work.
If
Hi,
I've got a silly problem with CF_SQL_TIMESTAMP and CF_SQL_DATE changing my
dates from dd/mm/ to mm/dd/.
I can work around using CF_SQL_VARCHAR, but it's not ideal.
Why would CF_SQL_TIMESTAMP and CF_SQL_DATE be doing this, please?
TIA, Jenny
No virus found in this outgoing message.
Hi all,
Sorry for the off topic, but this has been a real pain in my behind. We
have a process were our SQL server reads in data from an Excel file.
From there the data is used in various CF pages.
The problem is that the file that we import data from is opened by users
to make changes before
Question: Do you also want a result in the case where there is no USER_DOCS
record for a given USER and DOC record (FULL OUTER JOIN)?
On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley [EMAIL PROTECTED] wrote:
I've got three tables like this (simplified):
USERS
user_id
user_name
DOCS
doc_id
This query will return all users and docs that have a relationship
established but don't have a sign-off record:
SELECT u.user_name
, d.doc_name
FROM user_docs ud
INNER JOIN users u
ON ud.user_id = u.user_id
INNER JOIN docs d
ON ud.doc_id = d.doc_id
WHERE ud.signoff_id
Is there any way you can copy the file and use the copy? That was my first
thought.
On Mon, Mar 10, 2008 at 8:29 AM, DURETTE, STEVEN J (ATTASIAIT)
[EMAIL PROTECTED] wrote:
Hi all,
Sorry for the off topic, but this has been a real pain in my behind. We
have a process were our SQL server
Hi All,
I'm trying to figure out how to grab a specific digit in a number. For example
if I have
34859, I want to grab the third digit from the right or 8 for evaluation. How
do I do this?
I've got so far ...
CFSET digits = len(getdon.recordcount) to get the number
The I could use right
If it is always the 3rd digit from the left:
cfset thisNumber = 34859
cfset thisDigit = mid(thisNumber,3,1)
If it is always the 3rd digit from the left:
cfset thisNumber = 34859
cfset thisDigit = mid(reverse(thisNumber),3,1)
Are you trying to see if 8 is in the digits and if so get the
Are you referring to the Tag changes since ColdFusion 5 and Function changes
since ColdFusion 5 sections in the CFML reference? Or is there a different
section that I should be looking at?
Nate
I believe there's a what's new in the language reference for each
version in both the livedocs and
Mid(getdon.recordcount,2,1)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 8:21 AM
To: CF-Talk
Subject: Get a digit out of large number
Hi All,
I'm trying to figure out how to grab a specific digit in a number. For
example if I have
I've got so far ...
Take a look at the mid() function.
CFSET digits = len(getdon.recordcount) to get the number
Btw, should that not be len(theNumber) instead of recordCount?
~|
Adobe® ColdFusion® 8 software 8 is the
I've got a silly problem with CF_SQL_TIMESTAMP and CF_SQL_DATE changing my
dates from dd/mm/ to mm/dd/.
Most of the standard date functions use U.S. date formatting rules. So I
imagine 12/04/2008 would be converted to December 4th not April 12th.
You might try parsing it into a less
Mid(getdon.recordcount,2,1)
This will in fact return the second digit from the left, same thing only
for 5 digit numbers.
For the third digit from the right
I would rather use this:
CFSET digits = left(right(getdon.recordcount, 3),1)
___
REUSE CODE! Use
I think you've made a bit of an error there. With inner joins, the query
returns no results. This is what I expected. Using a left outer join also
returns no rows. This makes sense as you're maintaining the rows from the
wrong table. Changing it to a right outer join creates a cross dependency
New item we recently discovered. It wasn't an issue with 7, but is an
issue with 8, especially in view of the documentation. We have a
password that we 'encrypt'ed into the db, using 6.1. We later 'decrypt'
the password for use with a cfexecute call.
In 6.1, the Decrypt() function took two
The funniest ones are the people who want to have shared hosting for
less than $10 a month with multiple domains - then they complain the
servers are overloaded:)
What I was addressed was the nearly continuous arguments that run like this:
Poster 1: Hey guys, what's a good host?
Poster 2: My
I'll give that a try and see what happens.
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 9:09 AM
To: CF-Talk
Subject: Re: OT: SQL Server Accessing Excel file.
Is there any way you can copy the file and use the copy? That was my
first
You are pretty close.
First, I would filter your LDAP results a bit more. You are pulling in
groups, computers and other objects, in addition to users.
Add this to your first CFLDAP tag:
FILTER=((objectCategory=Person)(objectClass=User))
It is interesting to note that an objectClass of
The next thing to check is if the admins have denied the ability to
query the directory. They would be the only ones to tell you that.
Or, if you have admin access, you can open Active Directory Users
Computers and check the permissions of the domain root level.
(Right-click, Properties,
Now that I understand your data structures, I understand how to solve the
problem. I hope this works on MySQL. I tested it using OpenOffice.orgBase.
SELECT users.user_id
, users.user_name
, docs.doc_id
, docs.doc_name
, user_docs.signoff_id
FROM users, docs
LEFT OUTER JOIN
We've got a public Web site built on MX 6.1. We have a lot of problems with
users who don't have cookies enabled in their browsers. This causes problems,
especially, when users are attempting to log in.
I know I can check if cookies are enabled by creating a cookie variable on one
template and
When creating an RSS feed, does an XML file always need to be generated? Or
can the XML can be created on the fly by using CFFEED. The reason I ask is
that when I use cffeed to create the XML and then use cfcontent
type=text/xml reset=truecfoutput#rssXML#/cfoutput to push the data,
I always get a
I don't know if it works or not, but I highly doubt you'd want to generate
the XML on every request. That's sort of the point of RSS readers. They
watch a file to see when it changes, and then pull in the update.
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent:
Interesting:
http://www.newatlanta.com/corporate/news/bluedragon_opensource_announce.
jsp
~Brad
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Well, if I have to write the XML file to make my feeds work, I'll just use a
ST and update them a couple of times a day. Still want to know why
cffeed/cfcontent is not working for me.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 1:27 PM
I swear I remember a CF function that would total a query's results.
Like if my query returns 10 rows of grandTotal and grandTotal is a field that
contains numbers.
You could run a function and it would add the 10 rows together so you get one
number.
Am I dreaming this? I cant find the
Whats even more interesting is that announcement is from the future ;)
On Mon, Mar 10, 2008 at 12:38 PM, Brad Wood [EMAIL PROTECTED]
wrote:
Interesting:
http://www.newatlanta.com/corporate/news/bluedragon_opensource_announce.
More info here:
http://blog.newatlanta.com/index.cfm?mode=entryentry=EABF951D-453A-486E-9647E2825D1E6F39
(watch the wrap)
http://www.newatlanta.com/corporate/news/bluedragon_opensource_announce.
jsp
~|
Adobe® ColdFusion® 8
I swear I remember a CF function that would total a query's results.
Like if my query returns 10 rows of grandTotal and grandTotal is a field that
contains numbers.
You could run a function and it would add the 10 rows together so you get one
number.
ArraySum?
total =
arraySum(queryName[columnName])
On Mon, Mar 10, 2008 at 1:43 PM, Chad Gray [EMAIL PROTECTED] wrote:
I swear I remember a CF function that would total a query's results.
Like if my query returns 10 rows of grandTotal and grandTotal is a field
that contains numbers.
You could run a function
Dang it, you stole my comment!
On Mon, Mar 10, 2008 at 1:46 PM, Aaron Rouse [EMAIL PROTECTED] wrote:
Whats even more interesting is that announcement is from the future ;)
On Mon, Mar 10, 2008 at 12:38 PM, Brad Wood [EMAIL PROTECTED]
wrote:
Interesting:
Ah! That is it!
Thanks!
-Original Message-
From: Phillip Ciske [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 1:49 PM
To: CF-Talk
Subject: Re: adding query results
I swear I remember a CF function that would total a query's results.
Like if my query returns 10 rows of
SQL function would be SUM()
you could do it in CF via a few functions...
arraySum(listToArray(valueList(queryname.columnName))) i think... but
SUM in SQL would probably be the way to go in most cases.
On Mon, Mar 10, 2008 at 10:43 AM, Chad Gray [EMAIL PROTECTED] wrote:
I swear I remember a CF
Am I dreaming this? I cant find the function.
Maybe it was a SQL function...
I don't think you can do that in CF without looping or perhaps query of
query. Maybe you're thinking of valuelist which takes a column values and
returns a delimited list of the values.
In SQL check out
One of the beautiful aspects of the Query response object is that you can
access it like a struct of arrays. Because of CF's dynamic nature, you do
have to give hints.
This will work: arraySum(queryName[columnName])
This win NOT: arraySum(queryName.columnName)
On Mon, Mar 10, 2008 at 1:53 PM,
We are not yet using CFFEED, but we generate our HR RSS feed per
request. I always thought the pubdate of each article is what the
readers used.
m!ke
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 12:44 PM
To: CF-Talk
Subject: RE: Newbie
http://www.bennadel.com/blog/167-Calling-Array-Functions-on-ColdFusion-Query-Columns.htm
On Mon, Mar 10, 2008 at 2:01 PM, Sonny Savage [EMAIL PROTECTED] wrote:
One of the beautiful aspects of the Query response object is that you can
access it like a struct of arrays. Because of CF's dynamic
I just installed CF8 on a dev server and I'm running into issues trying
to use a webservice.
Does this error ring a bell with anyone? Are there any 'special' tricks
I need to do for webservices to work?
coldfusion.jsp.CompilationFailedException: Errors reported by Java
compiler:
So there were modifications done to our staging server on Friday..
today the staging server is not working..
directory listing works fine.. but if I click on a .cfm page I get
page cannot be displayed in IE.. in FF the page is blank.
I can remote into the server and hit the CF Admin on the
Also.. I can't hit the administrator from my local machine I have to
remote in.. but if I type in
https://cfserver:100/cfide/administrator/
I get the page cannot be displayed..
however the dev server on the same box works..
http://cfserver/cfide/administrator/
(staging runs on port 100, dev on
On Mon, Mar 10, 2008 at 12:00 PM, Greg Morphis [EMAIL PROTECTED] wrote:
So there were modifications done to our staging server on Friday..
today the staging server is not working..
directory listing works fine.. but if I click on a .cfm page I get
page cannot be displayed in IE.. in FF the
Sounds like your JRun connectors might have been removed so .cfm files
are no longer associated correctly anymore.
What exactly where the modifications made to your server?
You might need to run wsconfig to fix. Is this CF standard or
enterprise?
What version of IIS do you have?
In IIS 6, if
I believe they were wanting to change the default folder.. for example
if you just typed in https://server:100/
it would take you to a different directory.
The email they sent out says try to create a virtual directory in
staging pointing to prod directory..
Thanks
On Mon, Mar 10, 2008 at 3:10
CF Enterprise..
how can I tell which version of IIS I have?
Where can I go to get that information?
I was able to follow your instructions though so possibly I do have 6..
Anwyways I have
..jsp
..jws
..cfm
..cfml
..cfc
..cfr
..cfswf
all pointed to D:\JRun4\lib\wsconfig\4\jrun.dll
Verbs (all)
I think
Windows 2000 = IIS 5
Windows 2003 = IIS 6
It basically dependant on your version of Windows.
It sounds like your mappings might be fine-- I'm out of ideas for now
without knowing more about what actually changed on your servers.
~Brad
-Original Message-
From: Greg Morphis
I wasn't involved in what was done just in the clean up...
I did see them playing around with JRun.. but when I try to access the
Jrun Admin I get page cannot be displayed after I log in.. If I log
in incorrectly it tells me so..
Anything I can check on the machine for Jrun settings?
and as I said
Is your RSS url anywhere online where we can see? What is a live
bookmark? I've not had issues pointing Firefox to a page that does the
cfcontent thing like you have below.
On Mon, Mar 10, 2008 at 12:23 PM, Che Vilnonis [EMAIL PROTECTED] wrote:
When creating an RSS feed, does an XML file always
To complicate the matter staging is clustered.. there's 2 instances of
it running..
I run the Jrun4\bin\jrun.exe and I see them listed with status of Running
On Mon, Mar 10, 2008 at 3:59 PM, Greg Morphis [EMAIL PROTECTED] wrote:
I wasn't involved in what was done just in the clean up...
I did
So far, we have
* QuerySetCell
* LDAP queries
* cfbreak inside of cfcase
* Encrypt and Decrypt nuances
Doesn't sound like there's a complete list anywhere from Adobe. Does this
strike anyone else as just ridiculous? Who releases a major revision of a
language platform without a
What address do you use to get to the JRun admin? For me, it is on port
8080. Also, is CF Admin using the built-in Java Web Server, or an IIS
site?
Are your IIS sites bound by IP, or Host headers? When you hit a .cfm
page, can you check the logs for that IIS site and see if that request
Are you referring to the Tag changes since ColdFusion 5 and
Function changes since ColdFusion 5 sections in the CFML reference?
Or is there a different section that I should be looking at?
Yeah, that's probably it -- I was probably just misremembering the label.
--
s. isaac dealey ^ new
It's on port 8000.
How can I tell the following information you ask?
Please remember this is the deepest I've dug around in CF and IIS.. on
a normal day I'm a CF / Oracle developer.. not the server guy..
I don't have that short cut.. is that the jrun.exe file?
If so, I have
cfusion port 8300, N/A
Who releases a major revision of a language platform without a
exhaustive change log? Even Microsoft, who every developer loves to
hate, has this information available for .NET. Adobe is billing CF 8
as a drop-in replacement for earlier versions of MX. If there's no
other option besides a
Looks like it's corrected. isapi caching was turned off
man I need to do some research on this stuff incase something else gets FUBAR..
Thanks Brad for the help with this..
On Mon, Mar 10, 2008 at 4:37 PM, Greg Morphis [EMAIL PROTECTED] wrote:
It's on port 8000.
How can I tell the following
The issue is not that there might be problems running the new version,
but that the vendor has not properly documented the changes between
versions. I don't think they should be required to maintain a version
x to version x + 2 set of issues, but a comprehensive list of
compatibility-related
Sorry if this was mentioned already, but what about the Code Analyzer in the
CFAdmin?
Rich
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I completely agree. I have no problem adapting to the changes - if I
knew what the changes were. It's the possibility of unexpected changes
not being discovered until we upgrade production servers.
Nate
--
Nathan Wells Web Developer
[EMAIL
Unfortunately, the code analyzer in ColdFusion 8 seems to identify the
same issues the code analyzer in ColdFusion 6.1 did. It doesn't give
any report (even at the INFO level) for any of the issues identified in
this thread.
Nate
-Original Message-
From: Rich [mailto:[EMAIL PROTECTED]
I am new to coldfusion. using a video lesson from total training i learned
how to use dreamweaver / coldfusion and MySQL database driven site. i use a
mac, and my webpage works beautifully on my computer (locally). the problem
is when i try to upload the site at godaddy, it gives me an error
someone said i have to have the database string from the
hosting company - godaddy. i got the string, but don't know
where to put it. the index.cfm file doesn't say where to find
the database, the table...
You (or your hosting provider) need to create a datasource in the CF
Administrator.
Daniel,
You need to place the DSN string (Datasource name as defined in the CF
administrator by godaddy) in the CFQUERY tag (that you did not show in your
code sample).
Ex:
cfquery name= rs_christmas datasource=DSN_STRING_HERE
SELECT * FROM FOO
/cfquery
HTH,
Rich
The string that needs to be replaced is probably in the
application.cfm or application.cfc page.
If you send us a copy of the cfquery that creates the
'rs_christmas query, we can help you find out where it is.
Also, just to be sure, do you have MySql loaded on your local mac, or
is it
That's weird, isapi caching is supposed to only be a performance-related
setting according to:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/I
IS/3fd05620-78f1-4d51-8709-b142807cf9de.mspx?mfr=true
In other words, it _should_ have worked just as well (but potentially
Just so you know Will, I've had no problems getting file uploads working
with Spry tabs. I seem to recall finding the CF8 tabs problematic and
switching to Spry, which seems to work much better. Might be worth a look.
Cheers
Will
Thanks Will!
Will
I am pumped.
One thing I did notice was it was the J2EE version. Which, if I understand
correctly, is the version that is deployed on a Java App server like TomCat
or JBoss and not a regular web server like Apache or IIS. Which is all
fine with me in that is the direction I am heading anyways.
You can tie J2EE servers into Apache. In fact, the Smith Project has a
simple step-by-step on how to do that with tomcat:
http://smithproject.org/doc_preinstall.cfm
I'm anxious to see the details of the new license agreements, as that
will be the determining factor into how it's used by hosting
James,
That's the plan. We're migrating to a new facility this week, and have SQL
Server on a separate box.
- CF is a two processor, 4gig mem box, 500 gig mirrored, for OS and CF. 1.3tb
for storage. 32 bit OS
- Data is two proc, 8gig mem, 225GB mirrored for OS and SQL 64bit OS
- Windows
CF itself runs on a J2EE server - JRUN and can be made to run on other J2EE
servers.
The one thing I think I'm reading is that it's still not for commercial use.
If that's true, then it's really no better then the free bluedragon product
that they're currently offer. They seemed to be open
We are not yet using CFFEED, but we generate our HR RSS feed
per request. I always thought the pubdate of each article is
what the readers used.
My understanding is that readers may also rely on HTTP caching functionality
(If-Modified-Since request headers, 304 status codes). Of course,
I completely agree. I have no problem adapting to the
changes - if I knew what the changes were. It's the
possibility of unexpected changes not being discovered until
we upgrade production servers.
I agree that it would be better if Adobe provided this documentation, but
why in any case
I just installed CF8 on a dev server and I'm running into
issues trying to use a webservice.
Does this error ring a bell with anyone? Are there any
'special' tricks I need to do for webservices to work?
Generally, no. What JVM is CF using?
Dave Watts, CTO, Fig Leaf Software
The one thing I think I'm reading is that it's still not for commercial use.
If that's true, then it's really no better then the free bluedragon product
that they're currently offer. They seemed to be open sourcing it just to
get some free help with the development of the server.
Where did you
You can't always simulate every possible client action on a staging server.
Sometimes the changes are such that they fail in very specific instances.
Personally, I am running CF8 on my personal development environment and CF7
on production. There were a few things that broke right after the
I guess I was confused by the dual license approach they were talking about.
I guess you would only need the commercial license if you intent to
distribute your product and don't want to distribute the source? Is that
even possible with CF? I mean yea you can encrypt your code, but it's that
Distribution as I have had it explained to me means bundling BD with
some other product, be it physical or software.
Hatton
On Mon, Mar 10, 2008 at 8:12 PM, Russ [EMAIL PROTECTED] wrote:
I guess I was confused by the dual license approach they were talking about.
I guess you would only need
Hi -
The error message (which occurred in the line reading
filter=cn=#FORM.UserLogin#) is below:
Authentication failed:[LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334,
comment: AcceptSecurityContext error, data 525, vece ]
Does this help identify the problem?
Thanks very much!
David
Is the working admin username just a name like admin or a DN like
cn=admin,dc=something...?
On Tue, Mar 11, 2008 at 11:35 AM, david reiter [EMAIL PROTECTED] wrote:
Hi -
The error message (which occurred in the line reading
filter=cn=#FORM.UserLogin#) is below:
Authentication
Is that even possible with CF? I mean yea you can encrypt your code,
but it's that fairly easily decrypted?
but it's that fairly easily decrypted?
Very easy. IIRC you can do it with a CFX tag.
Is that even possible with CF?
Yes.
As of v. 7 you could turn CFML into compiled Java bytecode.
Very easy. IIRC you can do it with a CFX tag.
Let me clarify: Very easy for pre v. 7
On Mon, Mar 10, 2008 at 10:09 PM, Gerald Guido [EMAIL PROTECTED]
wrote:
--
I am always doing that which I can not do, in order that I may learn how to
do it.
- Pablo Picasso
Isn't the point of edge cases to find these types of situations, and
document them? This speaks volumes to why automated testing is so crucial.
Note, I said automated tests not unit tests. Unit tests are important, no
doubt about it, but when dealing with a language such as ColdFusion,
especially
Testing is very important, and I do not want to do anything to discount it, but
it has been my experience that it has limitations and it is not going to catch
every issue. I have found that it is not wise for a developer to rely on
testing methodologies, whatever they may be, to help them;
Automated testing isn't always possible, especially when you are dealing
with enterprise applications with millions of lines of code.
If you have infinite resources, you can spend all the time you want testing
and documenting things. Unfortunately, for most of us that is not the case,
and
Looks like a simple username/password error. Can you confirm that the
username/password is actually correct? Can you log in to a computer using
those credentials? In other words, take your application out of the equation.
You should use either the userPrincipalName ([EMAIL PROTECTED]) or
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 11 March 2008 2:05 PM
To: CF-Talk
Subject: RE: What are the Necessary Code Changes for Migrating from 6.1
to 8?
Automated testing isn't always possible, especially when you are dealing
with enterprise
The issue is not that there might be problems running the new version,
but that the vendor has not properly documented the changes between
versions. I don't think they should be required to maintain a
version x to version x + 2 set of issues, but a comprehensive list
of compatibility-related
You can't always simulate every possible client action on a staging
server. Sometimes the changes are such that they fail in very specific
instances.
Sounds to me like there's an expectation that the folks doing the beta
for new versions will be more superhuman than everyone else.
--
s.
93 matches
Mail list logo
