Hi All,
First, happy thanksgiving to everyone (who is celebrating that holiday).
Second, a quick question. We're developing a basic certificates feature in
our event tool. The idea is that you register for an event, attend the
event, and then get a certificate (most likely pdf) for the event.
I'm in the process of rewriting the admin system for an older website.
On this version, client want to be able to edit/add/delete anything at
will, and have it NOT got live until he's decided he's done with that
part.
My current thought is to use a temp table(s) that:
a. when visiting an edit
.
From: Les Mizzell lesm...@bellsouth.net
Sent: Wednesday, March 21, 2012 12:22 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Admin System - Temp Tables? Advice?
I'm in the process of rewriting the admin system for an older website.
On this version
I have done this three ways. I had an edit table (like your temp table) and
that worked fairly well. I did versioning as Jason mentioned, that was a
bit of a PITA. The other way was to use a preview page and I submitted
the form data to the preview page via AJAX and populated it that way. The
My current thought is to use a temp table(s) that:
a. when visiting an edit page - LOADS the live data into the temp table
b. all editing is done in the temp table
c. once he likes it, he can hit the publish button, and the temp data
replaces whatever is currently in the live table.
d.
Most of the case, the user does not want a new item to be published bedore it
is completed.
For existing items, only little adjustements are made and this may be done on
line.
If it is your case, just add some Active logical field in the table and display
the item only if the active flag is
with that file, your sheet may
have differences that no-one else can speak to. Really, I would recommend
installing the trial of CF9 (locally if needed) and testing it out yourself
over relying on other people's advice.
-Cameron
--
Cameron Childress
--
p: 678.637.5072
im: cameroncf
facebook http
Larger files (1000+ records) though - usually time out and the import
fails. Excel 2007 (.xlsx) and forward usually fails too.
A thousand records is not a huge amount, unless there are a large number of
columns involved. How many columns? What portion of the process consumes the
bulk of
Is CF9 limited to the versions of Excel it will work with?
I've got an application running in CF8 to import email/name lists using
the POI Utility (thanks Ben Nadlel). When (and it's not often) the
client normalizes their data and removes all formatting, AND uses a pre
Excel 2007 file
Greetings,
My boss has asked me to come up with a plan of action in case one of our
databases is off line or if we loose connectivity to it.
In this setup we have one DB in one location and another one at a different
ISP. I think he wants a solution in which if its possible that CF would be
able
I presume you already have the database clustering sorted and just want to
handle the CF DSN side of things ?
The easy way to do this is to have 2 DSN's, one pointing to each server.
In your OnRequest method simply check the database connection, if it fails,
switch to the other DSN.
Russ
On
Mallory,
A while back one of the CFGURU's, Mike Brunt, did an excellent presentation at
CF.Objective() 2009 called the Server of Doom. What he covered in the preso
was performance and redundancy. His slide show is still on SlideSix
http://slidesix.com/view/mbruntcfwhisperercfobjective09
Russ Wil Thanks I will be looking at that slideshow.
On Fri, Aug 19, 2011 at 4:20 PM, Wil Genovese jugg...@trunkful.com wrote:
Mallory,
A while back one of the CFGURU's, Mike Brunt, did an excellent presentation
at CF.Objective() 2009 called the Server of Doom. What he covered in the
Jason, you can expect $80 - $90 per hour easily if you don't have layers in
between..
On Thu, Nov 4, 2010 at 4:18 PM, Jason Birch birchma...@yahoo.com wrote:
I am a Senior ColdFusion Developer that is moving out to the Washington,
DC.
Obviously housing is a premium in the DC area. I would
Fellow CF Zealots:
I'm in the process of having a new dedicated server being built by
Hosting.com (formerly HostMySite.com) that will be running, among other
things, ColdFusion 9. Once the build is completed in the next couple days,
I will be systematically moving a few dozen websites from
Make sure you have all the hotfixes and updates installed, there were a few
things that got screwed with CF9 functionality wise that have since been
fixed plus some security issues as well. Other than that I think you will be
pretty safe, we have not had any issues moving customers to CF9.
Josh Adams recently posted a collection of information on the topic.
http://blog.joshuaadams.com/index.cfm/2010/11/2/Upgrading-from-ColdFusion-MX-7-or-ColdFusion-8-to-ColdFusion-9
http://blog.joshuaadams.com/index.cfm/2010/11/2/Upgrading-from-ColdFusion-MX-7-or-ColdFusion-8-to-ColdFusion-9
-Adam
On Wed, Nov 10, 2010 at 7:32 AM, Christian N. Abad
li...@accessiblecomputing.com wrote:
I'm in the process of having a new dedicated server being built by
Hosting.com (formerly HostMySite.com) that will be running, among other
things, ColdFusion 9. Once the build is completed in the next
I am a Senior ColdFusion Developer that is moving out to the Washington, DC.
Obviously housing is a premium in the DC area. I would like to buy or rent a
house in one of the suburbs, so that we can have a fenced in yard for my dogs.
What suburbs are the safest and most affordable in DC that
I have a script that pulls data from several external sources and returns
the top 500 results and takes about 3-5 seconds to render. To speed things
up, I want to database the results for later use. How can I database the
results while the user is viewing the page without the increasing the pages
Ajax?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
Save the query result to a session var or to a file as part of the page
processing. Then have an ajax call to a secondary page that will do the
insert or bulkinsert. Once the page has loaded (onLoad) have an ajax call to
the secondary page.
That's one way. I'm quite sure there's many others.
On
Some ideas to explore:
cfhttp with an immediate timeout
cfthread
CF Event Gateways
Writing 500 rows to a database table should only take a few
milliseconds, which would be unnoticeable relative to the amount of
time you say the page takes to load. If the database is slow for some
reason, perhaps
I've dealt with this issue time and time again. For instance, you want the
results to be downloaded in an excel document but you don't want to
compromise the time it takes to render just the HTML.
I have an image that is hidden and a spinner saying 'loading excel results'.
Then at page load an
Dear Experts,
I have a client who wants to make a barcode application for his general store
for billing purposes. Its like the very common application every other
departmental store uses for billing purposes for its customers. I just want to
know, is it possible to develop something like that
It's not hard to integrate barbecue into CF:
http://barbecue.sourceforge.net/
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 23 April 2010 17:42, Arsalan Tariq Keen arsalk...@hotmail.com wrote:
Dear Experts,
I have a client who wants to make a barcode
missing something fundamental here.
Any advice/direction would be greatly appreciated.
Thanks.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive
an Application.cfm file? I'm clearly missing something fundamental
here.
Any advice/direction would be greatly appreciated.
Thanks.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
advice/direction would be greatly appreciated.
Thanks.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf
[mailto:afpwebwo...@gmail.com]
Sent: 10. juni 2009 4:35
To: cf-talk
Subject: Re: Looking for advice on how to do this - remote printing
I am afraid i dont know we're only starting out on a new project but
it could be dozens or even hundreds of remote points, scattered all
over the place.
So that represents
I am working on a project where I am going to have to print up a job
ticket in a remote location. An event happens on the web site, and
it causes this job ticket to print out in one of perhaps thousands of
locations unattended.The people who are going to fill the job will
have no
I had a similar, yet much smaller project last summer...
Our student center allows students to checkout laptops for a couple of
hours. The staff wanted to be able to print receipts when
checked-out/in. Also, the system was to be web-based.
We purchased an Epson POS thermal printer with USB
I did a similar thing by sending a fax to the remote locations.
Worked nicely.
The fax told them the job, and also told them to acknowledge receipt
on the website.. so they would go to the website and a list of
pending jobs was waiting for them, in case they missed a fax
somehow.. Then they
How many daily tickets on average?
--
Ryan LeTulle
On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote:
I am working on a project where I am going to have to print up a job
ticket in a remote location. An event happens on the web site, and
it causes this job ticket
I am afraid i dont know we're only starting out on a new project but
it could be dozens or even hundreds of remote points, scattered all
over the place.
So that represents lots of scalability issues in designing the
application which i'm giving a lot of thought. But its the remote
printing to
In my earlier reply, I mentioned that we are using an Epson POS printer
with USB. This same printer can be used with a built-in NIC. That
means it would not need a host computer to which it is attached.
Thanks,
Mike
~|
Want
Something like Mike's printer solution sounds promising to me.
You might need to look into some special formatting/pl for the output so the
printer can understand it natively though. I did some work in labs with
Zebra printers that required that to print out barcodes.
--
Ryan LeTulle
On Wed,
What is the nature of the connection between the server and these printers?
Will they be on the same LAN or WAN or are they only going to be accessible
over the internet?
If the former, many modern network printers have the capability to be sent
print jobs to their IP address. Thus I would
You guys are all being very helpful, as always. This is good stuff
and it's helping me work out possibilities.
@Mike Dawson: thanks Mike, directly accessing the NIC wont work in
this case because we wont have all these devices on the same premises.
They'll be too remote for a single
They'll be too remote for a single network.Depending on how the
project develops once it's launched, there could be devices all over
the country. I dont think you can connect on a single network that
far can you and therefore be able to access the NICs directly? I think
it will require
Yeah.. I realized that I was the only one that has already listened to
the entire song catalog. But like you said, for most people that won't
be the case and I will make my mark all listened link only mark the
songs listed on the page, not the entire catalog.
Thanks!
Mike
Barney Boisvert
What do you do when they hit mark all listened?
Barney Boisvert wrote:
Databases are good at storing data. With proper indexing, a few
million rows is nothing. I'd store tracks listened to. Make the
model simpler, speed user creation, and odds are most people are going
to listen to
Insert into linkTable
Select song.id, #userId#
from song
Where not exists (
Select *
From linkTable
Where songId = song.id
And userId = #userId#
)
Obviously with CFQUERYPARAM and no auto-capitalize.
cheers,
barneyb
On 1/13/09, Mike Soultanian msoul...@csulb.edu wrote:
What do you do when they
IN and not NOT IN.
Any ideas?
Sorry for the half-a-thread hijack!
Adrian
-Original Message-
From: Mike Soultanian [mailto:msoul...@csulb.edu]
Sent: 13 January 2009 07:37
To: cf-talk
Subject: need some database advice
Hey Everyone,
I have a project and I'm trying to figure out
January 2009 07:37
To: cf-talk
Subject: need some database advice
Hey Everyone,
I have a project and I'm trying to figure out the best way to go about
it. What I want to do is keep track of what songs a user has listened
to and what songs they haven't. The first thing that comes to mind
-talk
Subject: Re: need some database advice
SELECT TOP 1 itemID
FROM item
WHERE itemID NOT IN (
SELECT itemID
FROM vote
WHERE userID = theUserVoting
)
That doesn't work? Should work fine, as should NOT EXISTS:
SELECT TOP 1 i.itemID
FROM item i
WHERE NOT EXISTS
Unless all the users listen All songs, the cross table will not be that
large.
The only trouble with a cross table is when you have to replace joins by
others.
In your case you don't even have that problem since all what can happen
is adding
new records.
[mailto:watson.domi...@googlemail.com]
Sent: 13 January 2009 13:48
To: cf-talk
Subject: Re: need some database advice
SELECT TOP 1 itemID
FROM item
WHERE itemID NOT IN (
SELECT itemID
FROM vote
WHERE userID = theUserVoting
)
That doesn't work? Should work fine, as should NOT EXISTS
Hey Everyone,
I have a project and I'm trying to figure out the best way to go about
it. What I want to do is keep track of what songs a user has listened
to and what songs they haven't. The first thing that comes to mind is a
table with song IDs and a table with user IDs and a join table
Databases are good at storing data. With proper indexing, a few
million rows is nothing. I'd store tracks listened to. Make the
model simpler, speed user creation, and odds are most people are going
to listen to less than 25K distinct songs so it'll require less rows
too.
---
Barney
hi guys,
i have a product table with over 500 records in it. each product is linked to a
category and brand. when a user inputs a search i need all three elements
searched (plus other fields as you will see in query below). at the moment, the
query is not the fastest of queries (database is
333184
w: http://sebduggan.com
From: Mike Little m...@nzsolutions.co.nz
Sent: 16 December 2008 09:06
To: cf-talk cf-talk@houseoffusion.com
Subject: product search query - advice needed
hi guys,
i have a product table with over 500 records
Nothing is glaring, but you would definitely want to look at optimizing MYSQL
for this. You can create indexes, views, etc that should help with the speed.
Take a look at http://www.learn-mysql-tutorial.com/ for a bunch of optimization
tips/tricks.
hi guys,
i have a product table
will need to
update that function to include cfqueryparams. good advice.
mike
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk
ah, just discovered my version of mysql 4.1.18 does not support views. i shall
talk nicely to my webhost i think!!!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
The main reason why I switched from MySQL to PostgreSQL years ago was
that MySQL failed to support standard RDBMS features including views,
stored procedures, functions, transactions, triggers and more.
I hear the newer versions of MySQL can do some of these now, but why
limit yourself. Get
Thanks for the input - but not really what I am looking for.
I am leaning towards some kinda flash/customtag - I've seen a couple of
examples online but none that quite satisfy all my needs at once.
~|
Adobe® ColdFusion® 8
- faster uploads
- multiple file upload
- limits on how large files you can upload (bytesize)
- limits on how large images you can upload (pixelsize)
- good error handling
So... any recommendations? Thx :o)
I would think CFMultiUploader would solve a lot of your issues.
I mean fast in comparison to the traditional form-post upload - I am sure most
solutions would be faster than that :)
But I'll definitely look into your suggestion.
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Hello experts
We are looking to improve file uploads into our CMS.
Currently we are using a form-post and CFFile, but I am not happy with the
performance.
I have the following wishlist;
- faster uploads
- multiple file upload
- limits on how large files you can upload (bytesize)
- limits on
What we have done is write up a client application that converts the image
files to BASE64 format and then break these text files up into smaller chunks
and then transmit them piece by piece... The client piece is done in .NET but
you may be able to swing it in JS but I am not certain though..
this issue at an Apache form
[http://www.apacheforum.com/forumdisplay.php?f=15] as well. But it does
not seem to be a hot bed of activity either. I'll gladly accept other
recommendations for appropriate and useful lists to post my issue to.
Apache Configuration Advice:
http
IMHO, independant permissions for viewing, adding, editing, deleting
elements
may be going too much into details and obviously adding to the complexity.
Having only one permission for each type of element should be enough.
- any one can view elements on the public site anyway, so no permission
Thanks for your suggestions Claude. Perhaps i should give you a bit
more background to this project. Just to clarify, the scenario is
about the opposite to the one you are puzzled by. I see the
circumstances where we might want to allow someone to edit content,
but for safety's sake not
Thanks Gerald, I'll go have a look at that reference.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
On Tue, Jun 17, 2008 at 6:58 AM, Gerald Guido [EMAIL
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2008 6:52 PM
To: CF-Talk
Subject: Re: Looking for advice on permissions
Thanks for your suggestions Claude. Perhaps i should give you a bit
more background to this project. Just to clarify
You know, I've been struggling with this too.
Not really struggling, as, hell, you can code up something that will
work for one set of variables pretty easy, but making a general deal
that's flexible and whatnot? Harder.
I'm leaning pretty heavy towards AOP and business object level
I have decided that the permission system i use on my CMS is getting
too complicated and difficult to administer, and my users are having
problems understanding it, so I want to fix it.
Can any suggest a good scheme ot use, or point me to some reading to
help me figure out what i need to do?
The
I don't have an answer but I can point you in a direction of a possible
option.
Take a look at this:
http://photos.guidofamily.org/grid.PNG
We need to do some fine grained permissions. Not nearly as fine grained as
your require. But I can see adding other edit/permissions options to the
drop
Hi All,
I need a little help and direction with a project. Iâve got 50+ .pdf
âjournals.â Each journal has 3 to 5 articles in it.
We want to make the journalâs text searchable, and to be able to send
(download) just the related article(s) instead of the whole journal.
Weâre
Google can index PDF files can't it? Why not install a Google search on your
site and let it go to town on your directory structure?
-Original Message-
From: Ry Mittlestadt [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 11:18 AM
To: CF-Talk
Subject: Advice and direction, please
Thanks for the wildcard idea, Isaac... that definitely sounds better!
Welcome. :)
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 617.365.5732
http://onTap.riaforge.org/blog
~|
Adobe® ColdFusion® 8
Thanks for the feedback, Isaac...
Welcome.
Actually come to think of it, you can specify an arecord for
*.domain.com as a wild-card for any values that aren't otherwise set for
that domain. So you should be able to make it automatically throw people
into the agents directory with just the one
Thanks for the wildcard idea, Isaac... that definitely sounds better!
Rick
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2008 8:49 PM
To: CF-Talk
Subject: Re: Need some advice on approach...
Thanks for the feedback, Isaac...
Welcome
Hi, all...
I'm working on a real estate website
and for the first time, I'm setting up agents'
sites using subdomains.
I have some ideas on how to approach this, but
I thought I'd ask about those of you with experience
doing this kind of thing to offer advice.
First, on the folder structure
Hey Rick.
Brief recommendation. You mentioned you're using Application.cfm still -
what you might want to do is add an Application.cfm in your /agents
subdirectory to modify whatever the original Application.cfm did to
set up the page...
/root/Application.cfm
original code ...
and queries?
Rick
-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 08, 2008 11:29 AM
To: CF-Talk
Subject: Re: Need some advice on approach...
Hey Rick.
Brief recommendation. You mentioned you're using Application.cfm still -
what you might
To clarify your statement about application.cfm...
Are you suggesting putting an application.cfm in the main agents
folder, and then having an application.cfm in *each* of the specific
agents' folders and simply have that included application.cfm
contain the specific variables needed an
Thanks for the feedback, Isaac...
I was actually planning to use url's like agent.c21ar.com
and create subdomains (A records in the DNS manager) and then
point those subdomains to the main agents' folder and use
cfif statements to setup the variables for
a particular agent's version of the site.
It looks like the characters were escaped, you need to escape the first
ampersand when posting it amp;amp;amp; = amp;amp;
The only thing that comes to mind, unless Google is broke, is that you may have
a page where you are escaping a URL twice.
how to join them together based on this. i usually
join queries together using:
select s.subject id, t.testid from subjects s, tests t etc...
i also know that query on query in coldfusion is very limited. so i would
like some advice on the best possible way to do this please
Note: i Have looked
Doesn't a left outer join do the job?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
Hi Gerald, yeah that seems the best way to go about it
thanks gerald
richard
you can use ColumnList to tease out the column names and use them to
dynamicly created the query.
cfquery name=getProj datasource=#application.DSN#
SELECT *
FROM
hi axel,
i have tried this but query of query in coldfusion doesnt seem to accept left
outer join. i get an error saying '...syntax error near left...'
is the left outer join meant to work in query of query in coldfusion
thanks
richard
Doesn't a left outer join do the job?
]
Sent: Thursday, May 08, 2008 11:39 AM
To: CF-Talk
Subject: Re: query on query advice
hi axel,
i have tried this but query of query in coldfusion doesnt seem to accept
left outer join. i get an error saying '...syntax error near left...'
is the left outer join meant to work in query of query
thank brad
your right it is a shame, i hope that adobe will be enhancing the query of
query to support any sql as this will make all our jobs easier :)
thanks
No-can-do compadre.
There are some funky workarounds
(http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-que
Go forth unto all the nations and make your voice heard.
Or at least go forth unto Adobe...
http://www.adobe.com/go/wish
~Brad
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 08, 2008 12:07 PM
To: CF-Talk
Subject: Re: query on query advice
thank
thanks for the link i just submitted the request :)
Go forth unto all the nations and make your voice heard.
Or at least go forth unto Adobe...
http://www.adobe.com/go/wish
~Brad
thank brad
your right it is a shame, i hope that adobe will be enhancing the query
of query to support any sql as
Me too :)
I also threw the fact that there are no string manipulation functions in
QofQ like substring or mid.
~Brad
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 08, 2008 12:19 PM
To: CF-Talk
Subject: Re: query on query advice
thanks for the link
together using:
select s.subject id, t.testid from subjects s, tests t etc...
i also know that query on query in coldfusion is very limited. so i would like
some advice on the best possible way to do this please
Note: i Have looked on cflib and seen a query merge function but it only allows
me
together using:
select s.subject id, t.testid from subjects s, tests t etc...
i also know that query on query in coldfusion is very limited. so i would
like some advice on the best possible way to do this please
Note: i Have looked on cflib and seen a query merge function but it only
allows me
-Talk
Subject: query on query advice
hi,
i have 2 coldfusion queries and need to combine them together on their
primary keys
the problem is, is that i don't know what the column names will be, i only
know what the primary keys will be.
therefore i have no idea how to join them together based
Lately when crawling my site, googlebot has been throwing errors. Instead of
the url parameters being seperated by an , when I get an error, the
cgi.query_string value has an amp; as a seperator instead. (see below.)
Has anyone come across this before? Any ideas on how to stop it from
happening
Where would I find info on how to use a thread like that?
I don't have a clue... the cf docs? Know of a blog about it?
The cfdocs should pretty much cover it, you're just throwing a cfthread tag
with action=run around the code that does the re-cache.
, 2008 10:32 AM
To: CF-Talk
Subject: Re: Need some advice on speeding up query...
Where would I find info on how to use a thread like that?
I don't have a clue... the cf docs? Know of a blog about it?
The cfdocs should pretty much cover it, you're just throwing a cfthread tag
Is that all there is to it? And this creates a running
of the query which doesn't involve the browser? Is that what
this means (from the cfdocs):
Basically, yes, although I wouldn't really think of it in terms of whether or
not the browser is involved, it's more to do with the current
And to reiterate, don't stick the entire query in there, it should be out in a
CFC, or at the very least, in a separate template so if you make any changes,
you aren't updating it in multiple files. You would just use a variable for the
cachedwithin time sort of like this:
cfparam
Oops, sorry about that partial post
To reiterate, don't stick the entire query in there, it should be out in a CFC,
or at the very least, in a separate template so if you make any changes, you
aren't updating it in multiple files. You would just use a variable for the
cachedwithin time
Thanks for all the info, Mary Jo!
It's been ( and will be ) a big help!
Rick
-Original Message-
From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 2:24 PM
To: CF-Talk
Subject: Re: Need some advice on speeding up query...
Oops, sorry about that partial
how and where is that url/link generated? can you also pass the property
type in the url? that can tell you which table to query...
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Rick Faircloth wrote:
Now's here's a new problem I haven't encountered.
How do I use a url variable to
1 - 100 of 679 matches
Mail list logo
