Relational databases don't work that way.
Either you have to return all the columns and have data duplication or
you would have to have 2 result sets and match them up with ColdFusion.
It is easier to let the database to the extra heavy lifting and return
one data set with the duplicated informat
Les,
I think the query as is will do what you want. Instead of fixing the
query use the Grouping function of cfoutput to only display the employee
name once, but the other data as it is.
Steve
-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: Friday, October 0
This is a locking problem in the database. Probably two different cfm
pages are attempting to edit the same database records at the same time.
Troubleshooting deadlocks in SQL Server is a big subject. I'd start
searching the SQL server Books online and go from there.
Steve
-Original Messa
I believe you have to do CONTAINS "##" to escape the pound sign.
-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com]
Sent: Tuesday, September 22, 2009 11:19 AM
To: cf-talk
Subject: Re: Coldfusion Autosuggest
I think I found the problem.
In my Database, I found som
If you ever find the root cause, you may want to write an article on it,
or do a presentation for cfmeetup!
I know I'd be interested in it!
-Original Message-
From: Michael Dinowitz [mailto:mdino...@houseoffusion.com]
Sent: Thursday, September 17, 2009 3:08 PM
To: cf-talk
Subject: malwa
I concur. The site is unavailable.
-Original Message-
From: Paul Alkema [mailto:paulalkemadesi...@gmail.com]
Sent: Thursday, September 17, 2009 9:08 AM
To: cf-talk
Subject: houseoffusion.com down?
I've noticed that houseoffusion.com is down. Is anyone else experiencing
this as well?
P
Create a required variable and use that to redirect them back to the
form.
I.E.
Steve
-Original Message-
From: Claude Schneegans [mailto:schneeg...@internetique.com]
Sent: Monday, September 14, 2009 4:00 PM
To: cf-talk
Subject: Re: GET insread of POST: what would you do?
I cfparam both form and url forms of the variable.
Then I convert to Variables...
Of course you can do other checking as well. You may also notice that
because of the order I trust the form variables more than the url
variables.
One thing though, if the values are showing up in the url
Hi all,
It has been a while...
I have a question about multiple instances and memory allocation...
I have a box with multiple instances. Each one has a different amount
of ram set aside for it in jvm.config files.
I have three setups:
JVM-BIG.CONFIG has:
# Arguments to VM
java.args=-server
All,
We are going through a review of our using FusionReactor on some of our
servers. Some people want us to keep it, some want us to switch to
SEEFUSION.
Does anyone have a comparison of SEEFUSION v FusionReactor?
Don't want to start a war, just looking for information!
Steve
All,
I have a unique problem. In SQL 2000 there is a way to convert a
function to being a system function. I.E. instead of
master.dbo.listToTable() you could use fn_listToTable().
The same conversion of a function doesn't work in SQL 2005. This is
causing a problem because we are upgrading f
Nothing hard about it at all.
I'm doing this for a non-profit group. So, I'm trying to keep my coding
time down and was looking to see if there was anything already out there
that would do this.
So, sorry if you thought that I couldn't do it, I just didn't want to
re-invent the wheel.
Steve
-
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 reads in data from an Excel file.
> From there the
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
In this case I believe it's the FusionReactor wrapper drivers.
Steve
-Original Message-
From: Paul Vernon [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2008 4:39 PM
To: CF-Talk
Subject: RE: Strange Error from SQL
> Anyone seen an error like this before? Error Executing Database
Q
Hi all,
Anyone seen an error like this before? Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Unhandled token type: Unknown token:
0x30
The error occurred on line 154.
It has been coming up on my server lately. It is usually followed by a
few null null errors. Some time
When I get the login screen the first time all I see is the screen.
Then when I login in and get re-routed back to the screen, I see not
only the login screen but cfdump information that can only be displayed
if my session variable is set to a specific user id.
>From there, if I then manually type
So I moved it up, but it didn't solve anything.
I'm stuck. Any other ideas?
Steve
-Original Message-----
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Wednesday, February 13, 2008 10:38 AM
To: CF-Talk
Subject: RE: Strange happenings in a login. CFMX 6.1
I can't move it comple
ogin/Application.cfm
-
Move the include to the top.
On Feb 13, 2008 11:15 PM, DURETTE, STEVEN J (ATTASIAIT) <[EMAIL PROTECTED]>
wrote:
> The reason I have two Application.cfms is that the
> /PowerCo/Application.cfm is the full on Application.cfm that sets
almost
> ev
The reason I have two Application.cfms is that the
/PowerCo/Application.cfm is the full on Application.cfm that sets almost
everything I need, the /PowerCo/Login/Application.cfm sets
variables/checks that are specific to that directory, then calls the
/PowerCo/Application.cfm.
I have an Applicatio
Hi all,
Just a quick question. Is CF8 (or even 7) IPv6 compatible? Will the
ColdFusion Administrator debug ips work with IPv6?
I'm being asked because our network is switching to IPv6 and this could
be an issue if it doesn't handle it.
Right now we are on CF7 (we own CF8 but change comes sl
Since you are using IIS... You could also go into the IIS Administrator
drill down to the file, then choose properties. From there go to
security and set it to allow Anon.
IIS allows these settings at the file level. Helps if you are just
having tasks run that don't need to be secured. You could
Hi all,
Last night I patched our CF server instances with the latest security
patch from Adobe. We use multiple instances and going into each one and
applying the patch took a really long time. It got me thinking...
Lets say, I created a directory (c:\cfpatches) and I add the directory
to the
I've always wanted to be able to do something like this also.
Maybe someone should make a wish list item for a directory were we can
put functions and they would be used as if they were part of the
ColdFusion functions.
Steve
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED
Even with that change to the licensing, that still costs more than
Fusion Reactor when you have 6 CF instances on one box. 1 Fusion
Reactor License or 3 SeeFusion licenses.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 24, 2007 3:10 PM
To: CF-Talk
One other thing you might want to consider is the licensing.
The last time I checked SeeFusion and FusionReactor were licensed in
different ways.
A SeeFusion license had to be purchased for each instance of ColdFusion
running on the server. Whereas, one FusionReactor license was used per
server
Hi all,
Here is an interesting OT for you. Is there any way to restrict how
much bandwidth, how many rows, or how high a priority a user has when
connecting to a MSSQL2K server?
My issue is that we have a user, who for political reasons we can't just
boot out of the db, who we were forced to g
Different versions of apache in development and production?
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 13, 2007 1:18 PM
To: CF-Talk
Subject: OT: PURE apache configuration question
But I know many of you out there use apache with your ColdFus
Am I missing something here? Was there an announcement about CFDJ going
away?
Nothing on the cfdj main page.
Steve
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, September 10, 2007 11:47 AM
To: CF-Talk
Subject: Re: Replacing the CFDJ awards ?
How a
Hi all,
We just renewed a maintenance agreement with Adobe for ColdFusion in
March through Software House International (SHI). We have to go through
them for all software/maint agreements/etc as per our company policy.
Any how, we haven't gotten anything from Adobe about our new key for
CF8. Wh
Rick,
Try this site
http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl. You put
in the SQL and how you want it formatted and it comes right back
formatted.
Steve
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 16, 2007 9:18 PM
To: CF-Ta
Dave (and all),
Please correct me if I'm wrong, but I thought you could do Windows
Authentication if you ran ColdFusion under an Windows Account instead of
local. Or... Did that change?
Steve
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 14, 2007
You are correct, I just did it a little while ago (about March). Saved
a bundle!
Steve
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 9:47 AM
To: CF-Talk
Subject: RE: Adobe Nails ColdFusion Cofin
But, you can renew a subscription, c
Hey all,
For quite a while now, the group I work in has been doing code reviews
of our ColdFusion code through the use of a code review tool to pick up
the major stuff, then peer review to get the logic/other problems.
Now we have to start doing it for SQL code. Does anyone know of any
code re
Actually, I'd be happier if it were more of a requirement. I'd also
like to see different levels other than Certified and Advanced.
We regularly look for contractors. I don't think I've seen one of the
resumes that had the certification.
We get the resume's, see the CF experience, contact the
Hi all,
I have a question about CF Flash forms. I get calls from my users
(intranet) where data won't show up on a flash form, just a please wait
message. This please wait is a default message I populate before
remoting gets the data.
Invariably, not changing from please wait to displaying da
Ok, I found the way to test for it. Using REGEX... <[^>]{1,}<[Cc][Ff]
At the moment I really don't care about "writeable". :P
I once had a co-worker that wrote code that had 5 cfifs inside of one
input tag. That was in one single (run-on) line of code! Very hard for
the follow up (meant tha
That would work for thing inside of strings, but one of the other things
I get is:
checked>
Our policy uses:
It is more readable (in my opinion).
Thanks for the idea though, that might be a starting point!
Steve
~~~
Hi all,
Got what I hope will be a quick one for you...
I have a code review tool that finds common CF programming problems, but
if it hits an improperly nested tag the tool tanks and reports no
problems even if there are multiple.
Normally this isn't a problem because the programmers in our s
Hi all,
Recently we moved to a new web server (old one lease rolled). Now all
of the scheduled tasks are getting a 401.3 error. I have added the
IUSR_servername user to have access (right click the file -> properties
-> sharing and security). I have also set the directory that all of the
task
All, I have a semi-urgent need to learn Fusebox and FLiP. Can't get the
funding (at the moment) for going to a training class, so what is the
best book for learning it quickly?
Also, I keep reading that FB6 will be out soon, any books on that or do
you think I should stick with 5 to get started
Actually, a person in our company contacted Adobe and they said that
they aren't going to test every _xx release, but that they would still
support us if we used _13.
-Original Message-
From: Ben Mueller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 4:24 PM
To: CF-Talk
Subject
201 - 242 of 242 matches
Mail list logo