Funny thing, I have just had this issue come up while working on code to
consume a Web service. The issue is that there are lots of elements in the WSDL
file that have a period in the name- e.g. contact.name. The convention comes
from the earlier (pre-Web) days of the client-server application
Tom,
Forgive me if I seem a bit dense here, but I may actually understand
what you're saying. ;) I hope you don't mind if I rephrase just to
prove to us all that I'm not a True Dolt.
A while back, I blew a day trying to create a struct in which an
element contained both a string and another
In Case of Emergency, Put Emphasis Here:
Granted, everybody needs to do what must be done to get the app
working... don't NOT do it just because of me. Hehe, yeah right... ;)
Like anyone would take me that seriously.
Laterz,
J
On Mon, 14 Mar 2005 03:16:48 -0400, Robert Munn [EMAIL PROTECTED]
Don't worry about redirecting in Application.cfc too much. It is a
CFC, but it's a little different than most other CFCs, so the same
rules don't apply to the same degree. It's really a very procedural
construct, it's just packaged into a CFC, because it makes things a
lot cleaner.
And you can
Hello everybody, I really need someone to help me here. I'm new to charting.
I'm developing a graphical interface to report the no of jobs logged in a
period. The x axis displays the period (days) and the y-axis displays the
number of jobs logged in a given day.
The data is pulled from the
I ended up doing this - which I believe gives me the correct numbers.
cfcollection action=list name=lsCurrentCollections
cfset variables.verityDocCount = 0
cfoutput
cfloop query=lsCurrentCollections
cfif lsCurrentCollections.registered NEQ K2
cfsearch
Hello All,
My developer and I are working on a CMS for various clients. Our clients keep
coming up with new requirements as the project grow or change. We are not
having any issues meeting these requirement for new functionality on the
website. But in my opinion we are not achieving an
Mickael,
This is something you hear often. Mostly this is the result of having to
much functionality and showing to much to the user. The end result often
is a busy interface. And still for experienced UI designers, it is often
a challenge finding a balance between what to show, and what to
The reason is that the library and template functionality actually let you
see in Dreamweaver what you are working on while you work on it. But not
only that, if it worked correctly (which in this case it didn't), the
resulting html only code will run on any server that can serve up html,
This is good, but I would do the following instead:
In the CSS put...
..searchHighlight {background-color: #00}
In the HTML...
You can span class=searchHighlighthighlight/span text within search
results.
The reason is that there should only be one instance of an ID in an html
document and
Jim,
I am just concerned that redirecting out of a CFC might
create sloppy code.
I would probably want to continue to use Application.cfm
for the redirecting
or use an include at the top of every page.
Can I use both Application.cfm and Application.cfc? If so,
what order do they
get
Thanks Troy. It does not submit the value just refreshes though.
Robert O.
-Original Message-
From: Troy Murray [mailto:[EMAIL PROTECTED]
Sent: Friday, March 11, 2005 4:29 PM
To: CF-Talk
Subject: Re: OT: Image Submit button
Try this instead for the button:
button type=submit
You should be able to accomplish what you're looking for just by adding 3
data series to the chart you're building. The most straightforward way to
do it would probably be to modify your stored procedure to take another
input parameter called status so you could view the results for a
particular
Anyone out there have a NCAA pool app written in coldfusion they'd be
interested in sharing? =)
- Rick
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting
You shouldn't need the javascript, the fact that it's an image should also
ensure that it's a submit button. Are you doing some sort of check on your
action page to see if it has been submitted?
Kola
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: 14 March 2005
Exactly what I was begining to type :) We're going through a lot of
un-needed code revisions to undo that which should not have been done.
Everything is an ID in our CSS and it is realy really messed up.
Adam H
On Mon, 14 Mar 2005 08:38:45 -0500, Calvin Ward [EMAIL PROTECTED] wrote:
This is
thanks Cliff for the reply. That did occur to me and its probably the only way
to do it. However, I don't know how to build the select sql query. From what I
understand when using the count() function, I can't any other column name in
the select.
select count(*), jobPriority from call
where
When taking a semantic approach, I would consider using strong for
highlighting. Not span.
Micha Schopman
Project Manager
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
Rick Root wrote:
Anyone out there have a NCAA pool app written in coldfusion they'd be
interested in sharing? =)
A former co-worker of mine wrote one last year.
What's interesting is that he allowed you to enter the number of arrests
for players and the severity of each crime for each
Jared Rypka-Hauer wrote:
I was under the impression that the error came up when the CF session
timed out first, but, logically, that makes no sense. If the CF
session timed out, it would just ask Jrun for a new one... so the
issue pops up when CF expects Jrun to be holding session information
and
*watches the SmugBug sitting on his desk die, crumble into dust, and
blow away in the breeze from the forced-air furnace since it's 9
degrees outside this morning*
Yep, it's Monday... ;)
I tried! I really, really tried!
Laterz,
J
On Mon, 14 Mar 2005 10:13:21 -0500, Bud [EMAIL PROTECTED]
Hello everybody, I really need someone to help me here. I'm developing a
graphical interface to report the no of jobs logged in a period. The x axis
displays the period (days) and the y-axis displays the number of jobs logged in
a given day.
The data is pulled from the jobs table. The job
Hmm, would em be more appropriate in that context?
- Calvin
-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 9:37 AM
To: CF-Talk
Subject: RE: Gmail highlighting
When taking a semantic approach, I would consider using strong for
I have to disagree. This is very much on topic in my opinion. Since when is
discussing UI design for a CF application not appropriate for cf-talk?
I liked the rest of your post, very useful and well written.
- Calvin
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent:
At first I would say yes, EM would be a good candidate, however I would
reserve EM for larger code blocks. Like a note, a warning, etc.
This part states you might better use strong for it. But honestly, I
wouldn't care while both have their semantics in letting content stand
out.
Thus, it would
So, say, in terms of a wiki... strong would be viable for terms
while em would suffice for meta-information like last-updated-by:
Blah blah blah strongwiki term/strong blah blah blah strongthe
end of the world/strong blah blah blah strongDouglas
Adams/strong
emEntry created by Fred Smith, last
So, in that scenario, I would consider the following:
In the CSS put...
#searchResults strong {background-color: #00}
In the HTML...
div id=searchResults
You can stronghighlight/strong text within search results.
/div
This results in less code! Of course you can only have one search results
Can someone send me Jim's note I did not get it, strange?
- Original Message -
From: Calvin Ward [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, March 14, 2005 10:30 AM
Subject: RE: OT - UI problems
I have to disagree. This is very much on topic in my opinion.
Yes, that is the idea.
Micha Schopman
Project Manager
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
Cfcoder,
=
select count(*) as numofjobs, jobPriority, jobNumber
from jobs
where logdatetime = #startdate# and logdatetime = #stopdate#
group by logdatetime, jobPriority, jobNumber
order by logdatetime,jobNumber -- if need orderby
=
Which will of course return a job count of 1 for each row, since it is
grouped by jobNumber.
To get the result set you want, if your DB supports it, you will need a
referential subquery something like this:
select j.jobPriority, j.jobNumber, (select count(*) as numofjobs from jobs
where
I wish to modify an existing table by increasing the varchar limit from 1000 to
2000. Is there a alter table command that can be used after the field has been
created?
~|
Find out how CFTicket can increase your company's
Does anybody know if the WDDX implementation in CF 7 is actually updated from
previous versions? Is there any work on the project?
More to the point will the current release (now well over 5 year old) still
work in modern Java/JavaScript implementations?
Any other tool that's as easy to use
As long as jobNumber is not a unique field, the query works.
select count(*) as numofjobs,
convert(char(10),logdatetime,101) as DTLOGGED,
jobPriority,
jobNumber
from jobs
where logdatetime = '02/01/2005'
and logdatetime = '02/02/2005'
group by
On mssql 2000,
alter table [tablename]
alter column [columnname] varchar(2000)
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 10:51 AM
To: CF-Talk
Subject: sql ( ms sql ) alter command
I wish to modify an existing table by increasing the
Sorry folks - I meant that for CF_Community. It's really off-topic for this
list.
That being said I'd still like to hear what you have to say - but please post
to the CF-community thread if possible.
Jim Davis
~|
Discover
Anyone have a solution for setting the image browse and upload path in
FCKeditor (version 2 with the default CF connector)? I'd like to share the
editor among several sites.
I've searched the FCKeditor forum, as well as this list, but haven't seen a
solution.
Thanks,
Brad
That's great news Larry. Look forward to hearing what Doug has done. I managed
to get around what I needed to do by creating the SOAP envelope using CFXML and
using CFHTTP to post it to the web service in question, but I would rather use
the CFINVOKE/CreateObject path with structures. Thanks,
Does anybody know if the WDDX implementation in CF 7 is
actually updated from previous versions? Is there any work
on the project?
I would be surprised if there have been any recent changes to it, or if
there ever will be. What's to change, after all? You can still use WDDX to
describe
I am planning on rebuilding two web sites that exist on the same server.
A few sections of each site will share related information.
Given that, are there any suggestions as to how I can structure my site
so that shared resources (udfs, cfcs, cust tags, etc) are visible to
each site yet not
I searched the MM exchange, but the tags that I found don't seem to work
anymore due to updates in the mappers sites.
Anyone have a tag or link to a function where I can pass the address and
get a map?
Mapquest or Yahoo maps or google maps, etc...
To date my CF apps have been on a server on our campus network. That makes it
simple to get to the data with MS Access.
I'm working on a couple of apps that will be hosted on a commercial server so
I'll be ftping to it. I've split my data into two databases - one that will not
be written to
SOAP is a transport protocol which is only useful in the context of web
services. Why not just write your own schema? It's not that difficult to do
this. I don't see much reason to bother with WDDX if you have a more
domain-specific way to talk about your data.
Right now it's purely business-BS.
I customized the CF connector to allow this. Basically there are a few
variables that are set that get used in the actual read/write calls that
are necessary for the function to work. The majority of that connector
is just figure out what the path should be based on the current tag
location,
Brad Roberts wrote:
Anyone have a solution for setting the image browse and upload path
in FCKeditor (version 2 with the default CF connector)? I'd like to
share the editor among several sites.
I'm actually (right now) in the middle of writing our own connector to
cope with the virtual
I think the settings for this are in one of the *.js files.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
My boss asked me to hook into our ldap system for password validation
and I'm looking for any heads-up or advice that I could get. Do
people use cfLDAP for this? If I have an app and I just want a few
people to have access to it, do I use a DB to store access groups and
names of people and
KNOW YOUR LDAP CONFIGURATION.
The ldap tag is pretty straight forward to use, if you know how your ldap has
been configured.
We currently use ours to control access based on NT security groups, stored in
our ldap data. We currently do not do password verification with ldap, we do
that
What brand of LDAP server are you planning on using? If it's Windows
Active Directory, there are some things to know about.
I use IIS/browser authentication for our intranet, but I use CFLDAP to
connect to Active Directory to get group membership for each user. I
also pull mailbox-related
I don't know why I thought that the coldfusion reports were being stored
in an xml and xslt file- apparently I'm nuts. I tested out report
builder and the report metadata is stored in the.cfr file which is
pretty much encrypted and not easily database-enabled. You want to
build a new report?
we use LDAP for authentication on our intranet apps. We use a sun ONE
IIRC. Its fairly easy to use cfldap tag for this. Googling should
get you an example or three. I suggest getting the ldap browser tool
from softerra, its free, and it simply rocks.
D
On Mon, 14 Mar 2005 12:50:42 -0600,
What brand of LDAP server are you planning on using? If it's Windows
Active Directory, there are some things to know about.
I don't know which LDAP server it is because I didn't realize I needed to know,
hmmm. Time to ask. But it's the University of Maryland so I guess it's
something that
I've been thinking of a new method of presenting dynamic content,
specifically the list archives. At the moment you get to a single post by
passing an ID on the url. Even if this is 'hidden' using SES Urls or the
like, your still passing something.
My idea is to use the application.cfc to 'catch'
I have run across a problem for which I think a SQL solution should exist.
I essentially need to do a left-join on two columns.
I need to get every row from one table (say lessons) and any rows from
another (say students) for which the LessonID columns of each table match AND
where the
Don,
The reports are stored in an XML file which was encrypted for your
protection:)! Which at times makes debugging a bit more of a
challenge.
Rick Mason
On Mon, 14 Mar 2005 14:00:06 -0500, Don Smith [EMAIL PROTECTED] wrote:
I don't know why I thought that the coldfusion reports were
I did this at a company I worked for in order to catch error pages.
What we did was grab the path after the domain and run that through our
search tool automatically. Our search tool kept track of common
searches and especially ones that returned zero results, so we had a
table where we could set
Would this work or am I missing a piece of the puzzle?
Select *
From lessons
Left join lessons on lessons.lessonID = students.lessonID
Where students.studentID = #studentID#
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-Original
There isn't a recommended number, There are a lot of variables so
publishing a recommendation is a little hard. It's pretty much up to you
on what you think is reasonable. With that said, what you are seeing
makes sense, we know that the flash components can't handle the amount
of data that the
I don't know much about LDAPs. Are you saying that I can introduce my
own group type and add existing people too it? I only want these two
people into the Admin parts of my app, so could I make a group called
myApp_admin and add them to it without affecting their current setup?
Nope. That returns only rows from lessons where either no matching row exists
in the students table at all or where a matching row exists for that student.
In other words, it eliminates any lessons for which there is a match in the
students table, but not for the given student.
Steve
Would
Thanks. I like the methods, just wasn't sure how I would deal with
redirection. It sounds like the consensus is that it is very appropriate to
do a redirect from the Application.cfc
Thanks,
Andy
-Original Message-
From: Jared Rypka-Hauer
Andy,
If I understand correctly, it's an
Steve Bryant wrote:
I have run across a problem for which I think a SQL solution should exist.
I essentially need to do a left-join on two columns.
I need to get every row from one table (say lessons) and any rows from
another (say students) for which the LessonID columns of each table
How about something like this? Not sure if it does the join before or after
the where clause...
Select * from lessons left join students on
lessons.lessonID=students.lessonID where students.studentID=#studentID# or
ISNULL students.studentID
-Original Message-
From: Steve Bryant
Steve Bryant wrote:
Nope. That returns only rows from lessons where either no matching row
exists in the students table at all or where a matching row exists for
that student. In other words, it eliminates any lessons for which there
is a match in the students table, but not for the given
I am working with an iMail mailing list for a
relatively large organization and need to work on a
way to deal with bounced mailing list messages. When
the messages come back, they are delivered to the
mailing list owner's mailbox. What I'd like to do is
download the mail messages with CFPOP,
Okay, so I've got a site on my localhost. I'm setting it up to use CFCs and
I've got my CFC all created, and it's working locally perfectly.
The path is C:\Inetpub\wwwroot\MySite
I have the CFC in the root of my site, and it's called, let's say,
myCFC.cfc.
So in my page, I have the code that
I'm confused about what exactly you want
From your original email I get that you want
1. All the rows from lessons
2. Any rows from students table that matches lessons on the lessonid
3. A where clause to narrow down the students who are listed.
However in your comment to John you said that you
Does anyone know of a quick example for using the group attribute of the CFMAIL
tag? Nothing fancy, just something that illustrates its use.
Thanks,
Howie
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
I expected that to work as well (in fact, I thought that I had used this
approach successfully in the past). I tried it again this time, however, and it
didn't work.
Some rows from lessons were missing.
Would it matter that while lessons has a primary key of LessonID,
students has a joint
There are actually less than a dozen formats that account for over 90% of
the bounced mail you'll get. I've been planning an app to do exactly what
your requesting but never got around to it. I'd ask Howie Hamlin about it as
he's probably written or heard something that does this for iMS.
If not,
paths to cfcs have to be absolute wite createObject() A pita for site
portability, eh? There are ways around this. You could create a CF
mapping called com to C:\Inetpub\wwwroot\com\. Then place your CFCs
in there in teh 'Java way'
C:\Inetpub\wwwroot\com\domainname\app1\mycfc.cfc
Then all
Yeah, I'm confused too. A better explanation would help if Jochem's
(and others') posts didn't solve it already.
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL
Hello, I'm trying to use the CFTREE to populate another frame with data
based on the id of the node selected. Here is my code:
cftreeitem value=datefmt,RequestID
display=datefmt,timefmt
img=folder,document
imgopen=folder,document
paths to cfcs have to be absolute wite createObject() A pita for site
portability, eh? There are ways around this. You could create a CF
mapping called com to C:\Inetpub\wwwroot\com\. Then place your CFCs
in there in teh 'Java way'
C:\Inetpub\wwwroot\com\domainname\app1\mycfc.cfc
Then
For those of you who use activepdf, a quick question.
According to the docs you can put an image into the setformfield tag
I tried their code, but no luck. Not only does the image not show up, but if I
open the final pdf and click to view the fields- the field doesn't even
transfer to it
Just create the mapping on both your local and live sites. Use
hardcoded fully qualified paths if you can... try to avoid dynamic
path names when refering to the names of CFCs. It makes things easier
to understand when you look at it later, and if you have to change the
names at some point the
Thanks Michael! I'll do that. EC
-Original Message-
From: Michael Dinowitz
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 3:47 PM
To: CF-Talk
Subject: RE: Dealing with bounced email
There are actually less than a dozen formats that
account for over 90% of
the bounced mail
Try this:
select
count(*),
jobPriority
from
call
where
logdatetime = @x + '00:00:00'
and
logdatetime = @x + '23:59:59'
group by
jobPriority
-Cliff
Subject: cfchart and cfchartdata question. Kindly help!
From: cf coder [EMAIL PROTECTED]
Date: Mon, 14 Mar 2005 09:26:39 -0400
Just create the mapping on both your local and live sites. Use
hardcoded fully qualified paths if you can... try to avoid dynamic
path names when refering to the names of CFCs. It makes things easier
to understand when you look at it later, and if you have to change the
names at some point
Define in application.cfm file. You only have to look and change in a single
location. If at some point the location changes you don't need to search
and replace you know exactly where to look.
Also what's up with little local telco's? I think they rule!
-Original Message-
From: Jeff
A single mapping should be a one time thing, so it *shouldn't* be a
big deal for them.
On Mon, 14 Mar 2005 16:19:28 -0500, Jeff Small [EMAIL PROTECTED] wrote:
Just create the mapping on both your local and live sites. Use
hardcoded fully qualified paths if you can... try to avoid dynamic
I don't think they should have a problem with it. It's a simple thing
for them to do and if they're offering CF hosting, that's a simple
support issue that doesn't open any vulnerabilities on their server so
it shouldn't be a problem.
John Burns
Certified Advanced ColdFusion MX Developer
Wyle
OT
And HTC is the largest telephone cooperative in the US. Not just some
little local telco. :-)
/OT
- Matt Small
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 4:25 PM
To: CF-Talk
Subject: RE: CFCs and paths...I'm having a couple of
The issue with dynamic paths is that you can't do any type-checking at
all in the cffunction, cfargument, and cfproperty tags. For me,
this is too important since it saves a lot of time debugging. It also
makes the structure of component files clearer since I am always
having to use it. It may
+1 on the softerra ldap browser tool.
-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 1:08 PM
To: CF-Talk
Subject: Re: LDAP
we use LDAP for authentication on our intranet apps. We use a sun ONE
IIRC. Its fairly easy to use cfldap tag
The way I do it is to use my CFX_POP3 Pro tag rather than the built in CFPOP
tag because it's got bayesian filtering capabilities built in so I train
them to recognise bounces as opposed to spam and score them appropriately.
When I process the mailbox for bounces, I don't have to do half as much
Ok guys, I just read in my Internet Retailer about how teen shoppers do NOT
want to register before shopping online. This plays right into my plan on the
Volleyball site as teen shoppers *are* my target audience. My client and myself
did not want to force them to register.
Some argue that
I think maybe you want this...
Select *
From lessons
Left join lessons on
(lessons.lessonID = students.lessonID
AND students.studentID = #studentID#)
Putting the AND in the join clause (and not in the WHERE clause) will give
different results.
Mark
Make the registration after everything else and optional. Since you already
have the info, it's only an extra few keystrokes.
- Matt Small
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 3:45 PM
To: CF-Talk
Subject: E-commerce - Make them
Ask for the info, just don't tell them they are registering!
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 1:45 PM
To: CF-Talk
Subject: E-commerce - Make them register or don't make them register
Ok guys, I just read in my Internet
OT
And HTC is the largest telephone cooperative in the US. Not just some
little local telco. :-)
/OT
- Matt Small
Well, you-know-who is lurking, so I figured I'd take a couple digs...make
sure he's paying attention...heh.
- Jeff Small (not related to Matt...seriously)
Teens (and alot of online shoppers) do not like you to store anything about
them (even though common sense dictates they'll have to always repeat the
reg info for every purchaseand you could store it without their
knowledge anyway).
So if you think you'll cheese off your main market...I'd
It *shouldn't* matter what brand you use, but since they may have their
own implementations, it's helpful to know.
Directories are organized into containers named Organizational Units
which are basically sub-directories similar to a file system. The
admins can create an OU just for you, give you
That's it!
I didn't even realize that you could use an AND in a join clause like that
(embarrased that I didn't even think to try it).
Sorry to everyone if my explanation of the desired result was confusing. Thanks
to all for the help!
Steve
Select *
From lessons
Left join lessons
Does anyone use/integrate with intranets.com? Looks like a great hosted
service, but their apparent lack of APIs means I can't do too much
customization (post items from my site, to their task list, etc).
Just curious...
Any other hosted intranet solutions you'd recommend for low end crm,
I've been following the Crystaltech session issue with moderate
interest. I say moderate because its not really my problem yet, as I
and my clients are running either CF 6.1 or CF 5.
But talking to another client today, looks like I'll be setting up a
server for him sooner rather than later, so
You can also use inequality operators in a join as well. I found a very
good use for this when I was creating an IP Telephony billing app for
our campus.
Table1 INNER JOIN Table2 ON (Table1.pk = Table2.fk AND Table1.date =
Table2.billingDate)
(This is kind of a nonsense query, but you get the
You could take a paypal approach and ask after the checkout is complete do
you want to save this information so you won't have to enter it again? I
know it isn't foolproof but I tend to gravitate to the way amazon.com does
ecommerce. They've spent millions doing research on it - it can't be all
Are you sure Application.cfc will fire for that? Because
Application.cfm doesn't.
cheers,
barneyb
On Mon, 14 Mar 2005 12:17:27 -0500, Michael Dinowitz
[EMAIL PROTECTED] wrote:
I've been thinking of a new method of presenting dynamic content,
specifically the list archives. At the moment you
On Mon, 14 Mar 2005 14:53:28 -0700, Paul [EMAIL PROTECTED] wrote:
You could take a paypal approach and ask after the checkout is complete do
you want to save this information so you won't have to enter it again?
I do something similar to that. The checkout form is a simple
1-screener with a
1 - 100 of 149 matches
Mail list logo