Hi
I have created a web form, but what I would like it to do (and I'm not
sure if this is possible with Coldfusion?) is when a user enters their
employee number into a text field without a page refresh it runs a
database lookup and populates other fields in the form with that
employees
It is definitely possible and rather easy using CF (or just plain
javascript) - all you need to do is make an ajax request to a cfc/cfm on
your server passing entered employee number as data/argument, which will
return necessary data based on emp number. You then populate necessary
fields
Hi
We are on CF7, not sure if this restricts the amount of functionality
available to me?
So how would it work - when a user types in their employee number in the
text field how would ajax call a SQL query to lookup the data in the db
table to populate the rest of the fields in the form.
Do
Ian,
on CF7 you do not have the built in CFAJAX stuff, so it simply means you
have to do a little more work using CF + JQuery to make ajax calls.
Here is a quickstart using CF7
http://365labs.net/cf_jquery/jquery_coldfusion_quickstart.htm
You will find plenty more examples on google.
even
This will take some research on your part, and there are thousands of
resources out there on the web. I would suggest using JQuery for this.
Basically, user fills in their userid, hits a button (or something) that
triggers the ajax call back to the server. On the server you have a CFC
with a
Basically the easiest way to do ajax, is the following...
1. download jquery libraries, or in your source code refer to different hosting
of the jquery libraries. jquery fyi, is javascript libraries, that work
cross-browser and make it easier to do things like ajax, and millions of other
Hi Craig et al
Thanks for this
So download JQuery and link to the file on your server
Does it have to be a CFC? Its just that I have never used them before -
where would your SQL go in the CFC and would it be the same as a cfm
page
i.e.
cfquery select * from emptable where employeenumber =
Sending this to cf-talk on behalf of my coworker...
-- Forwarded message --
From: Nate ncwe...@gmail.com
Date: Wed, Mar 2, 2011 at 10:39 AM
Subject: [tacfug] CFCACHE and the Dreaded Quirks Mode
To: TACFUG tac...@googlegroups.com
Does anyone have a fix for this?
Coldfusion is
Here is a brief tutorial on writing a CFC (Google is your friend)
http://www.learn-coldfusion-tutorial.com/ColdFusion-Components.cfm
You would put your query in a method in the CFC.
You would use the success handler of your ajax call to populate the
form. This will take some further research
Does anyone have a fix for this?
Coldfusion is inserting an html comment before any other markup in a
cfcache'd page. This is fine unless you are using IE. IE will go
into quirks mode if the very first line of the page is not the doctype
declaration. Some have suggested to use cfcontent
Does it have to be a CFC? Its just that I have never used them before -
where would your SQL go in the CFC and would it be the same as a cfm
page
No, it doesn't have to be a CFC. You could write a CFM file that
accepts inputs and generates JSON or XML output directly. But CFCs are
preferred
I have created a web form, but what I would like it to do (and I'm not sure if
this is possible with Coldfusion?) is when a user enters their employee number
into a text field without a page refresh it runs a database lookup and
populates other fields in the form with that employees
Now I did mention that Flex says it REQUIRES RDS to be enabled in order
to use Flex data services.
This is only required to use the wizards in Flash Builder, just like
you need RDS to do things in CF Builder. Once your code is written,
you can deploy it to servers without RDS enabled.
Dave
Way back in the day I was told RDS was horribly insecure and I wrote it
off and never looked back.
Neither RDS nor the CF Administrator should be exposed to untrusted
clients. They're both password protected with no auditing of failed
authentication events.
Dave Watts, CTO, Fig Leaf Software
Dreamweaver aso needs RDS for a lot of its features, but RDS is not
supposedly to be installe don production servers.
If you run CF enterprise, then you can sandbox RDS access and give each user
their own login and limit what folders they have access to.
This is what I do on cfmldeveloper.com to
Good morning everyone,
I'm aware that www.hosting.com now offers ColdFusion 9 in a cloud
environment. I'd be curious to hear if other hosting companies offer CF9 in
the clouds as well. I know this is a twist on an old question concerning the
best CF hosts. Any suggestions for CF9 cloud
Hi Peter,
yes we have been offering it for quite some time now over at
www.bluethunderinternet.com
--
Russ Michaels
www.bluethunderinternet.com : Business hosting services solutions
www.cfmldeveloper.com: ColdFusion developer community
www.michaels.me.uk : my blog
We need a better solution available to developers
to be able to switch between local and server DNS.
There are several tools out there to let you manage your hosts file,
but frankly it's pretty easy to just keep it open in a text editor,
and keep a command prompt open to flush your DNS after
Hello Russ,
I'll check it out.
Peter Donahue
- Original Message -
From: Russ Michaels r...@michaels.me.uk
To: cf-talk cf-talk@houseoffusion.com
Sent: Wednesday, March 02, 2011 10:56 AM
Subject: Re: ColdFusion 9 Cloud Hosting
Hi Peter,
yes we have been offering it for quite
yes we have been offering it for quite some time now over at
www.bluethunderinternet.com
I'm not trying to be difficult, but it takes more than virtual servers
to make a solution a cloud solution. I don't see anything on your
site about being able to allocate more resources on an as-needed
I haven't read the rest of this thread, but I agree with Dave, editing the
hosts file is so simple it really doesn't need any other solution..
Where most people fall down is trying to use the same domain for their dev
site, staging site and live site, which means you have to remember to keep
Dave,
this is possible yes, it just isn't automated via the control panel (yet).
There is still confusion in the world about what exactly CLOUD hosting is
and what the difference is between that and VPS hosting etc, and different
people have different definitions both on the vendor and client
I am trying to clear all of the data from a table before importing new data.
Example code:
*
cfquery name=qryClear datasource=datasource
TRUNCATE TABLE tablename
/cfquery
---
!---
cfquery name=qryDelete datasource=datasource
delete from tablename
/cfquery
---
... it is easier to just keep it simple terminology wise and asses each
persons requirements ...
^
I see what you did there.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB)
I wouldn't expect that the delete or truncate would still be running,
but if they are, wrapping all of the cfquery tags in a cftransaction
might help, or wrapping the delete/truncate in a transaction, then
calling the insert in a separate cftransaction?
HTH,
Carl
On 3/2/2011 9:57 AM, Mallory
Hello Dave and everyone,
I went to www.bluethunderinternet.com and didn't see anything about
cloud hosting at all. I did observe that BlueThunderInternet.com is a UK
based company. I had a reseller account with another UK Hoster but
discontinued it due to currency issues. I should have
Carl,
I will try that. I had the truncate in a cftrans.. let me try them both and
see what I get.
Nope.. still the same result. I have tried having both of them in one
cftrans and also having them in their own cftrans block.
The odd thing is.. When the truncate works, It removes all of the
What DBMS are you using? SQL Server, MySQL, Oracle, or MS Access?
Carl
On 3/2/2011 10:43 AM, Mallory Woods wrote:
Carl,
I will try that. I had the truncate in a cftrans.. let me try them both and
see what I get.
Nope.. still the same result. I have tried having both of them in one
However, the next set of lines which is supposed to import the data runs but
no data is imported.
You say import, so I suppose you INSERT records from another SELECT.
I also suppose that you have checked if this SELECT actually returns records?
Also, do you have an auto-increment field in this
Carl its MySQL
On Wed, Mar 2, 2011 at 2:00 PM, Carl Von Stetten vonner.li...@vonner.netwrote:
What DBMS are you using? SQL Server, MySQL, Oracle, or MS Access?
Carl
On 3/2/2011 10:43 AM, Mallory Woods wrote:
Carl,
I will try that. I had the truncate in a cftrans.. let me try them
The import is not being done via SQL. It's reading an excel file then doing
a SQL insert.
On Wed, Mar 2, 2011 at 2:06 PM, wrote:
However, the next set of lines which is supposed to import the data runs
but
no data is imported.
You say import, so I suppose you INSERT records from
It's reading an excel file then doing a SQL insert.
I'm affraid you will have to show us some more code.
~|
Order the Adobe Coldfusion Anthology now!
I don't have any experience with MySQL, but I've heard that there's a
way to enable multiple statements in a single cfquery. Once thats
enabled, look at the MySQL docs for the syntax for putting multiple SQL
statements together. In SQL Server (which I use frequently), you would
do something
Carl,
I tried that but it caused another error:
Here is more code:
This code comes directly from Ben Nadel so all street cred goes to him! :)
Here is the blog that I got most of the code from:
http://www.bennadel.com/projects/poi-utility.htm
I modified the code to handle more columns and of
First, you need to move the Truncate query outside the loop. Otherwise
it is being called on each loop iteration, and erasing any records you
inserted on the previous iteration.
Second, close your table with a /table tag after the /tr
Third, you have a comment about blank rows being invalid,
I love that hosts file. I make all of mine site.geodesic.com or
site.local. It's portable too, in that it's easy to share with other
dev's this way.
Matthew Williams
Geodesic GraFX
www.geodesicgrafx.com/blog
~|
Order the
Thanks Carl that was a big DUH on that part for me. I will check it out.
Thanks for the help!
On Wed, Mar 2, 2011 at 3:30 PM, Carl Von Stetten vonner.li...@vonner.netwrote:
First, you need to move the Truncate query outside the loop. Otherwise
it is being called on each loop iteration, and
Just to confirm, its working now! :)
Its amazing what a fresh set of eyes will do.
On Wed, Mar 2, 2011 at 3:36 PM, Mallory Woods mallory.wo...@gmail.comwrote:
Thanks Carl that was a big DUH on that part for me. I will check it out.
Thanks for the help!
On Wed, Mar 2, 2011 at 3:30 PM, Carl
Glad to here you got it sorted. Good luck!
Carl
On 3/2/2011 12:43 PM, Mallory Woods wrote:
Just to confirm, its working now! :)
Its amazing what a fresh set of eyes will do.
On Wed, Mar 2, 2011 at 3:36 PM, Mallory Woodsmallory.wo...@gmail.comwrote
Thanks for your suggestion. I'm sure your solution would have
worked
but I started messing with getPageContext() and was able to use that
to overwrite the existing headers.
I found that by doing the following after cfcontent it corrected
my
problem.
cfset
Thanks for your suggestion. I'm sure your solution would have
worked
but I started messing with getPageContext() and was able to use that
to overwrite the existing headers.
I found that by doing the following after cfcontent it corrected
my
problem.
cfset
I agree, Dave... once I understood the issue and possibilities
better, it became clear that it wasn't much of an issue, especially
when I could just use local.xyz.com, which I'd never put
on public server.
It's been really convenient to have an actual domain to use
for development as opposed to
Yep... exactly what I finally figured out.
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Wednesday, March 02, 2011 12:31 PM
To: cf-talk
Subject: Re: I think I'm confused...
I haven't read the rest of this thread, but I agree with Dave, editing the
hosts
We are evaluating Terremark's Enterprise Cloud solution right now. It really is
amazing what you can do through their control panel. I can spin up or shut down
VMs, allocate additional vCPUs, memory, or hard drive space all through the
panel. Within a few minutes, I had multiple VMs with a
I have seen the same sort of thing with Amazon's AWS. Their Elastic
beanstalk service http://aws.amazon.com/elasticbeanstalk/ allows you to
fire up an automatically scaling Java application, by uploading a war file,
filling out a few form fields and a few clicks. I am sure it takes a bit
more
I have seen the same sort of thing with Amazon's AWS. Their Elastic
beanstalk service http://aws.amazon.com/elasticbeanstalk/ allows you to
fire up an automatically scaling Java application, by uploading a war file,
filling out a few form fields and a few clicks. I am sure it takes a bit
46 matches
Mail list logo