Here are steps
1. switch your local copy to trunk (Project -> Team -> Switch)
2. Merge your working copy (trunk) with the version xx
On Sun, Feb 22, 2009 at 3:33 PM, Chad McCue wrote:
>
> I am confused on how to update my trunk from my working branch. Here are
> my steps below. Please let me kn
- Original Message -
From: "Matt Williams"
To: "cf-talk"
Sent: Tuesday, February 24, 2009 7:47 PM
Subject: Re: Can I do this in a single SQL query?
> UPDATE comments
> SET userID = (
> SELECT userID
> FROM users
> WHERE users.email = comments.email
> )
Doh... Really?
On Tue, Feb 24, 2009 at 9:25 PM, Jim McAtee wrote:
>>
> The new system requires user registration and new comments are now tied
> directly to a user account. What I'd like to do is link any newly
> registered users to their old comments by using the email address. It's
> imperfect, but better t
Can you update the comments table when a new registration happens, with the
userid that matches the email address?
William
-Original Message-
From: Jim McAtee [mailto:jmca...@mediaodyssey.com]
Sent: Tuesday, February 24, 2009 6:26 PM
To: cf-talk
Subject: Can I do this in a single SQL qu
I have an old table of comments made to a web site in which no user
registration was required, but commenters were required to enter an email
address. The system had little verification and users could enter bogus
addresses, but most people did enter their real email address.
The new system r
>Will,
>
>Ah... Your problem could be networking. On our network (for example) we have
>both "internal" and "external" IP addresses running through cisco pix. We
>have to run an "internal" DNS server to dole out interal IP addresses for
>the reason you describe below. A web server could not (for e
Update:
I end up using activepdf tool to import vector pdfs, does not
support this functionality.
On Sat, Feb 14, 2009 at 3:28 PM, Guru wrote:
> Couldn't find it anywhere so thought to ask.
>
> I have couple of illustrator files (which can be export to EPS on any other
> vector format).
>
> I
Thanks to everyone, I got it working. For the sake of posterity, here
is what I came up with:
SELECT a.*
FROMappointment a INNER JOIN
(SELECT patient_id, MIN(appointment_date) AS appointment_date
FROM appointment
GROUP BY patient_id, convert(va
Isn't this way easier and executes way faster?
select * from appointment
left join (
select
patient_id,
min(appointment_date) as firstAppt,
datepart(yy,appointment_date),
datepart(dd,appointment_date),
datepart(mm,appointment_date)
from appointment
group by p
I like this approach. That middle query inserting into the temp table
might be what I need for the view.
Thanks,
Judah
On Tue, Feb 24, 2009 at 12:48 PM, wrote:
>
> These sort of queries are always kind of annoying. My approach is to to
> use an intermediate temp table, group by patient and da
> What I still don't get is how/why Google managed to
> crawl part of the admin site in question to start with.
My guess is that someone, somewhere, wrote a link to the admin URL in
a public web page.
Generally, you can find what pages link to your page in Google using
the "link:" operator.
Dav
This is the sort of approach I was trying to think of, couldn't
remember derived tables. This query only grabs the earliest
appointment for each patient though not the earliest for every day.
But it is a good starting point, I'll try to massage a group by date
in there and see what I can come up w
I've had pretty good success with creating the necessary formatting in Word,
saving as HTML, then using that HTML in CF to generate Word docs with
appropriate labels on the fly. User selects contacts to mail to, a Word doc is
generated, they open and print on their labels. Simple and accurate.
Bliss and Fisher...
Thank you very much. the "?" did it
andy
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Arc
> My understanding in talking with some Google reps is that
> the google-bot does not click submit buttons, but it does follow all
> links.
What I still don't get is how/why Google managed to crawl part of the
admin site in question to start with.
Yes, there were mistakes and "not best practic
Maybe
Select top 1 * from appointment where appointment between (date/time and
date/time) order by appointment_date
Ben Conner wrote:
> Hi Judah,
>
> I suppose there's more than one way to do this, but this should work...
>
> SELECT a.*
> FROM appointment a INNER JOIN
>
Cool, used the pipe and it worked like a champ. Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
htt
The importer is broken. The quotes surrounding each field imply that
the field is terminated by a quote as well, so any commas within the
quoted string are NOT field separators. That's part of both standard
CSV and Excel's slightly modified dialect. If the importer truly
splits on every comma i
Jason Fisher wrote:
> You're not doing anything wrong, any system that tries to import the CSV will
> automatically assume that every comma is a field delimiter, just like it's
> supposed to do. If you have content with commas in, you'll have to pick a
> different field delimiter, like Tab or
Hi Judah,
I suppose there's more than one way to do this, but this should work...
SELECT a.*
FROM appointment a INNER JOIN
(SELECT patient_id, MIN(appointment_date)
AS appointment_date
FROM appointment
You're not doing anything wrong, any system that tries to import the CSV will
automatically assume that every comma is a field delimiter, just like it's
supposed to do. If you have content with commas in, you'll have to pick a
different field delimiter, like Tab or pipe (|).
Example with pipe
These sort of queries are always kind of annoying. My approach is to to
use an intermediate temp table, group by patient and day, and find the
min() appointment date. Then join that temp table back to your
appointment table to pull out the rest of the information for that first
appointment based
FYI:
I did some testing and research (with some help :) and I posted an article
with my findings on this issue.
http://www.coldfusionmuse.com/index.cfm/2009/2/24/CF-SSL30-Authorize-net
-mk
~|
Adobe® ColdFusion® 8 software 8
Nope, you're good.
On Tue, Feb 24, 2009 at 15:06, Ian Skinner wrote:
>
> Dave Watts wrote:
>> You can edit this in jrun.xml, or within the JRun admin console web
>> application, but you need to do this before configuring Apache of
>> course.
>
> Of course, or modify Apache accordingly I presume.
Here's my code
"Email Address", "First Name", "Last Name", "Company", "Address Line 1",
"Address Line 2", "City", "State", "Postal Code"
"#RTRIM(EMAIL)#", "#RTRIM(FIRSTNAME)#",
"#RTRIM(LASTNAME)#", "#RTRIM(COMPANY)#", "#RTRIM(ADDRESS1)#",
"#RTRIM(ADDRESS2)#", "#RTRIM(CITY)#", "#RTRIM(STATE)
This is related to an earlier post today "Coldfusion 8 Data Source Timeout".
I am still getting a timeout when configuring a certain Data Source to a remote
database.
Using dbaccess from my CF8 machine works - no problem.
I looked the cfserver.log and get: A non-SQL error occurred while requesti
Dave Watts wrote:
> You can edit this in jrun.xml, or within the JRun admin console web
> application, but you need to do this before configuring Apache of
> course.
Of course, or modify Apache accordingly I presume. I just wanted to
make sure that there wasn't anywhere else I need to configure
> I'm hoping someone can clear up some confusions I
> have regarding Flex and Coldfusion. Currently I am
> hosting my site with a well-known hosting company. I
> have many Coldfusion sites running in their shared
> environment. Today when I talked to them about
> loading my Flex site up (which
I'm ill and having difficulty wrapping my head around an issue I know
I've done before, so I'm hoping that someone can help me out.
I have a table that lists patient's appointments.
Appointment
id
patient_id
doctor
appointment_date (datetime)
A patient can have 0...n appointments o
After a few hours on this I have run into a wall, I think I am close.
This is on Windows XP.
I have Apache Installed and working, I have Tomcat Version 6.0.18
installed and working. I did a J2EE install of CF8 Developer got the
war file and loaded into: C:\xampp\tomcat\webapps\cfusion
I can b
> As I have recently learned better, when one creates
> multiple ColdFusion instances (aka JRun Servers)
> each one gets a unique port number staring
> at 51000 and incrementing from there. One then uses
> this port number in the "JRunConfig Bootstrap
> 127.0.0.1:51000" line as part of the httpd
Ian,
We use Apache + CF 8 Multi-Instance in our local development, with each
developer maintaining a mirrored environment. What we've found is that
by setting a process, and building out each instance in the same order,
we all retain the same ports.
Changing port numbers shouldn't an issue fo
That's a nice one but I prefer the multiple file uploader example here:
http://weblog.cahlan.com/2006/12/flex-upload-component.html
It's not quite as pretty but it's way more functional. If you have
flexbuilder you can easily open the project and skin it differently.
-Jake
Tony Bentley wrote
You could probably figure out a way to calculate processing time based on
connection speed. For uploading files, there is nothing except client side
plugins or flash that will calculate the file size being uploaded and how much
of the file has been transferred.
The best example I have found i
As I have recently learned better, when one creates multiple ColdFusion
instances (aka JRun Servers) each one gets a unique port number staring
at 51000 and incrementing from there. One then uses this port number in
the "JRunConfig Bootstrap 127.0.0.1:51000" line as part of the
httpd.conf do
Kim Hoopingarner wrote:
> Thanks for the information. No one could answer this for me on the support
> lines I called. I knew to come to this site first. You guys got it
> together.
>
> Turns out I get the white screen with no errors. So I think I can move
> forward. Take care!
That i
Keep in mind, you run the risk of developing a bunch of remoting CFCs
and they might turn this off. In a shared hosting environment where
they say it's not allowed but it might technically be, you might be
safer to take the web service approach and secure them.
Kim Hoopingarner wrote:
> Thank
Thanks for the information. No one could answer this for me on the support
lines I called. I knew to come to this site first. You guys got it together.
Turns out I get the white screen with no errors. So I think I can move
forward. Take care!
~
Just to clarify, Flex is Flash and therefore a client-side environment. All
you need on the server side is the SWF file. I'm not sure if most shared
hosts disable Flash Remoting support, seems silly to me that they would, but
Jake is right on in that you can instead use Web Services or HTTP Servic
That is true if the flex component is self-contained, meaning it doesn't
need to communicate with the server. If it needs to communicate with
the server, they have to open up the flex gateway. You can find out
very easily if that is open simply by going to
http://yourdomain/flex2gateway/. I
I'm hoping someone can clear up some confusions I have regarding Flex and
Coldfusion. Currently I am hosting my site with a well-known hosting company.
I have many Coldfusion sites running in their shared environment. Today when I
talked to them about loading my Flex site up (which includes
>>Any clever suggestions?
Look for CF_Avery. Pretty good piece of soft, and it is free.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207
On Monday 23 Feb 2009, Burns, John D wrote:
> the google-bot does not click submit buttons, but it does follow all
> links. Needless to say, the google-bot deleted all of the records where
> that was the case in this app. So, as an added precaution, use type="button"> or but do not use on
> any
Hi All,
A lot like EBay, I have a client that wants to create a niche site where people
can list specific used items to be sold. I'm looking for advice on a
transaction
processing service that will allow my client to process, hold and release funds
and transactions. They know they could just
Could /CFIDE be inaccessible, but the working client has a copy of the class
file for some other reason ?
--
Tom Chiverton
Helping to centrally participate integrated supply-chains
This email is sent for and on behalf of Halliwells LLP.
Ha
I'm wanting to set up Excel as a data source, but the driver isn't
currently available on the server. I got the below from the Server
folks. Will Coldfusion see the source once added, or will I be wasting
my time?
-
It's because the excel odbc driver is 32 bit and the server is 6
hey guys..
just wanted to pick your brains real quick.
was curious if any of you had used or created any sort of progress bar
for display in a cffile upload
and then a progress bar to display the progress of a cfloop on an
insert or update of sql server..
my scenario, we have a xls that a user up
On server A we have CF8 installed, also INFX 9, with 2 databases.
We have 2 Data Sources defined to these databases - no problem the Data Source
verifies without any problem.
We also have server B, with INFX, and another database.
We define a Data Source to this database, but here is the problem
You need to determine the proxy port of your ColdFusion instance. This
is found in your jrun.xml, or you can use your jrun admin interface to
determine your port number (default is 51000 for the cfusion instance
but each subsequent instance will be assigned a new port).
In your vhost conf, load jr
On Monday 23 Feb 2009, Ian Skinner wrote:
>
You should only need one, outside the virtual hosts if you want CF available
to them all.
Then just set up a new VirtualHost entry.
--
Tom Chiverton
Helping to enormously monetize bandwidth
On Monday 23 Feb 2009, Claude Schneegans wrote:
> In my case, I think the problem is related to 8bits bytes subject and
> addresses.
SA learns.
I get zero legit email that requires 8-bit address or subject.
Ergo, I expect SA throws away a lot of stuff with 8-bit subjects for me.
--
Tom Chiverto
On Mon, Feb 23, 2009 at 7:21 PM, Daniel Baughman wrote:
> Anyone came across anything really handy there?
I typically create a PDF template in LiveCycle Designer with a
repeating subform and push data into it with cfpdfformdata.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
~~~
52 matches
Mail list logo
