I've not used RDS (yet) due to the costs involved but it certainly is an
attractive option as your operations grow as backup and replication are 'built
in'. Overhead that would make it unusable? Why do you think that? It's designed
to perform well.
However what I have used (in fact just put
You'll most likely want your CF server in close proximity to the cloud based
MySQL server, i.e. your server would want to be an EC2 instance.
I've a few servers setup in the Amazon cloud and for the most part it is
really neat. Things to be aware of though are outages, servers have a habit
of
On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote:
Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept
from what I'm reading at least, sounds great.
I currently use shared hosting with CF and MySQL. I'm pouring over the
documentation but most of it is over my head as
I would presume you are not using amazon for a 24/7 database connection as
this would be prohibitively expensive, much more than having your own VPS
or using database hositng, so I presume you are using it only for occasional
access, in which case caching your queries is a must and will overcome
Try http://www.scribblar.com/latestrooms.cfm
The CF server is UK racked, the DB is US-East on EC2 (micro instance, RDS would
arguably perform better). The page runs an uncached query to grab the latest
rooms.
The plan is to move everything onto EC2.
Cheers
Stefan
On 18 Feb 2011, at 10:47,
One thing you may want to take into consideration, if you plan on having
many sites run through this codebase, is NOT giving each site a unique
application name. (as in cfset this.name = #cgi.server_name#). I
once worked on a MSOC system that ran somewhere around 2700 websites,
and each
Probably a stupid question, but if the data was used across applications
wouldn't it make sense to push it into the server scope?
That would allow you to have one copy of the needed items, but still let
you keep the applications separate. I know that a lot of the time having
a different
Hi all,
This is a pretty odd request. I actually found someone asking a similar
question all over the place back in 2003 but they never found an answer as
far as I can tell. Basically, we have multiple products. All of those
products are .NET with exception to the one I work on (the better
Thanks for the feedback, Eric.
Wouldn't sharing an application name cause some
sharing of variables between sites?
And: So using ?reinit=1 or something similar resets
variables within *every* application, even with different
application names?
I thought the main reason for using different
I've never used the server scope in apps, so it's not a question
I can answer...perhaps others will chime in on this one.
And, as part of this situation, there are almost no variables
that are shared between applications, so I don't see that there
would be many variables to put into the server
I think we finally decided that the binding types being RPC on the CF side
and DOC on the MS side was the real issue and that there really isnt a way
around it in CF (please correct me if I'm wrong there).
That being the case, the only option was to support both on the .NET side.
The default is NO so it always has a value
What is the value of #FORM.LoanerYN# when you try to insert it in the
bit field?
~|
Order the Adobe Coldfusion Anthology now!
I'm using 9,0,1,274733.
Jason Durham
On Wed, Feb 16, 2011 at 5:43 PM, Sean Corfield seancorfi...@gmail.comwrote:
CF9 or CF9.0.1? ISTR a bug in this area that got fixed sometime along
the way...?
On Wed, Feb 16, 2011 at 1:05 PM, Jason Durham jqdur...@gmail.com wrote:
I'm re-writing an
Surely a bit field will need 0 or 1, not a string? Or was that not what you
meant?
- Original Message
From: Nicki Tabb vnt...@alaska.edu
To: cf-talk cf-talk@houseoffusion.com
Sent: Fri, 18 February, 2011 15:32:19
Subject: Re: Invalid Precision Value from SQL Server CF9
The default
I am trying to use the autosuggest parameter in a cfinput. I can't quite
figure out how to bind the autosuggest to the CFC.
I have tried:
autosuggest=cfc:users.autoSuggestUsers()
autosuggest=cfc:cfc.users.autoSuggestUsers()
autosuggest=cfc.users.autoSuggestUsers()
You need to use the same URL path that you would expect to use if from the
url, so in your case it is.
autosuggest=cfc: traumasystem.tcda.cfc.users.autoSuggestUsers()
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: Evik James [mailto:e...@evikjames.com]
On Fri, Feb 18, 2011 at 6:14 AM, Eric Cobb cft...@ecartech.com wrote:
One thing you may want to take into consideration, if you plan on having
many sites run through this codebase, is NOT giving each site a unique
application name.
I always take the approach of a single application name - for
SQL will read a NO or FALSE or 0 as the same
Surely a bit field will need 0 or 1, not a string? Or was that not what you
meant?
The default is NO so it always has a value
What is the value of #FORM.LoanerYN# when you try to insert it in the
bit field?
No it doesn't.
Here is an example on SQL 2005:
declare @test table (
testVal bit
)
insert into @test (testval) values (0);
insert into @test (testval) values ('Yes'); -- Results in error
Conversion failed when converting the varchar value 'Yes' to data type
bit.
insert into @test
sorry,
I guess I meant that, when using CF, I have never had issues with No or False
or 0 being read as the same by the SQL Server
No it doesn't.
Here is an example on SQL 2005:
declare @test table (
testVal bit
)
insert into @test (testval) values (0);
insert into @test (testval)
CF will read in bit values from SQL Server and evaluate them as
equivalent to true/false or yes/no. However, SQL Server expects 0 or 1
from ColdFusion when writing to a bit field. There's probably a UDF on
CFLib.org that converts CF boolean values into strict bit values, but
here's one I
Hi folks
What is the best way of downloading web database to a local desktop machine.
clients register for programs and the information is on the web database.
I want to use coldfusion to update my local desktop database
Thanks
Rob
Good points about the single application name.
However, it brings into question my entire approach to application
variables. Take, for instance, my path to userImages.
When a user visits www.xyz.com, onApplicationStart() runs a
query that retrieves, among other variables, the absolute path
to
This one comes up from time to time. The best way to do it is with you
chosen database's own development and management tools. If you use MS SQL
Server Management Studio, they have integrated tools to copy a database. If
you use Toad, they have something too. I have always had... let's say
Hi Nathan
I am using mySQL. On the VPS i have php based myadmin. Doesn't do a lot for
me and then I tried to download that to my local machine. After dowloading and
supposedly installing it I wasted a day scouring the web trying to configure
it. I
gave up in utter disgust at my inability to
Navicat has scheduled, automated backups (any frequency).
Works flawlessly.
Hi folks
What is the best way of downloading web database to a local desktop machine.
clients register for programs and the information is on the web database.
I want to use coldfusion to update my local desktop
I've set up a function (taken from the Adobe site) which concatenates address
fields and is suppose to return one nice address block...
i've placed the function on the report detail band and reference
report.Format_address(query.ADDR1, query.ADDR2, etc) ...all my address fields
in the
On Fri, Feb 18, 2011 at 11:36 AM, Rick Faircloth
r...@whitestonemedia.com wrote:
When a user visits www.xyz.com, onApplicationStart() runs a
query that retrieves, among other variables, the absolute path
to those images. Realize, the application that I'm referencing
is a global site manager
sqlyog or navicat are both great mysql management tools and have free
editions. there is of course free mysql admin (part of mysql tools now,
i think) downloadable from mysql website.
since it is your vps, you can install one of these there as well, and
configure remote access to your db, or
29 matches
Mail list logo