Which DB would you choose (MSSQL Express / Apache Derby) for a small (4gb,
with only 10 simultaneous connections) intranet CF App?
I only used MS-SQL before, and I found the management studio very easy to work
with. The only concern I have is the limitation of the Express version might
get
Hey all,
This is my first foray into mxajax, I have it installed properly (I think),
however I'm getting the following error:
output from firebug:
element has no properties
_observeAndCache(undefined, click, function(), false)prototype.js (line 1966)
observe(undefined, click, function(),
Personally, I like MS SQL Express. The only thing is that it doesn't come
with an agent, AFAIK, so you'll need to find another way to do backups.
If you don't want limitations, I would go with MySQL, but I could never get
used to it, as the management tools sucked. Some people suggested
I couldn't quite tell from your sentence whether you were saying Derby
doesn't have a good managment tool like MySQL, or if you thought MySQL
doesn't have a good management suite.
Just in case it was the latter, or in case anyone else isn't aware of it,
I'll bore you with a gushing mention of the
The first thing that popped in my head was MySQL.
Samll, light weight and faast. I have been using it on production
sites (CF and PHP) since v 3.x and only had 2 beefs with it. I had couple
table corruption errors a few years back which repair fixed nicely. The
other was not being able to
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 10:22 AM
To: CF-Talk
Subject: RE: DB choice for small Intranet site
Personally, I like MS SQL Express. The only thing is that it doesn't
come
with an agent, AFAIK, so you'll need to find another
I am not much of a MSSQL person but if you meet that limitation one day,
can't you easily upgrade things into the full version?
I have been using Oracle XE for similar needs that you have and also for
moving things to/from development workstations to our development/production
environments
Haha! StringInTransit... I like it. :]
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
I remember looking at Oracle XE(?) a year or so ago. Doesn't it suck up a
couple of hundred megs of ram? Or was that something else? I don't remember
which version I tried out but I *do* remember it was using some ungodly
amount of ram.
G
On Sun, Mar 16, 2008 at 11:42 AM, Aaron Rouse [EMAIL
On Sun, Mar 16, 2008 at 8:21 AM, Russ [EMAIL PROTECTED] wrote:
This is the first I'm hearing of Apache Derby, and although I'm sure it's a
nice project, it's written in Java, which means it will be slower then MSSQL
Just because it's java doesn't mean it's got to be slow. :]
HSQLDB is
I would go with MySQL and yes there are GUI's out there such as NaviCat,
which I personally use, that rival Enterprise Manager and the Management
suite. I also like the fact it isn't microsoft. It scales rather nicely so
there are few to no limitations on it. It also has a fairly small memory
Banging head on desk, sure I'm doing something daft ...
When I reference the xml item it looks fine, then I try and insert it into a
table and this happenes:
insert into tbl_emails (UserName, Password, FirstName, LastName,
IsSystemAdmin, IsDomainAdmin)
Values (
'?xml version=1.0
I honestly have never paid attention because never had RAM issues. I do not
think my 2003 box here has more than a few gigs of RAM in it and it is used
for MSSQL Express, Oracle XE, Active Directory for the domain, minimal
shared file storage and ColdFusion 8 and it never has resource issues and
Never having dug into them I can't compare it to mySQL
I have. Well... some.
For basic SQL MySQL rocks and will meet the needs of 99% of the needs of
most SMB's. But if you want to get into more nontrivial stuff MSSQL will be
a better bet IMHO. My experience with (some) FOSS packages is that
How are you referencing the XML node? Is the query below the generated
query?
Adrian
-Original Message-
From: Jenny Gavin-Wear
Sent: 16 March 2008 17:20
To: CF-Talk
Subject: XML Question
Banging head on desk, sure I'm doing something daft ...
When I reference the xml item it looks
Ian,
I posted an example of this recently on my blog.
http://www.coldfusionmuse.com/index.cfm/2008/2/22/sql-injection-on-a-charact
er-field
The long and short is that different platforms allow you to escape single
quotes differently and this technique can be used to get the right number of
Hi Adrian, this is an excerpt from the generating code:
cfoutput
cfloop from=1 to=#NumUsers# index=I
Cfset found = 0
cfquery datasource=#application.dsn# name=exists
select * from list_emails where sitedomain like 'fasttrackonline.co.uk'
/cfquery
Hi,
I haven't had a need to do this before and wondering what the best way to
accomplish this question.
A visitor selects a value from a dropdown box, I then need additional form
fields to be required depending on their selection.
All of the form questions are stored in a database. I'm thinking
The last small project I developed was a sales application that met the limits
you mentioned (4Gb and 10 connections) . I compared MySQL (which I am a big
fan of), and MS SQL Express. My customer was on a very tight budget and a
commercial license (because the software is private and not
Thanks Dominic, I'd forgotten the cfreturn
J
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: 03 March 2008 11:28
To: CF-Talk
Subject: Re: CF functions question
I would I would like to return the structure to the refering page, is
this possible,
please?
Hello to everyone familiar with ajaxCFC,
My component file component.cfc start getting too big and difficult to manage
(loads of functions there). Is there any way I could define more than one
components on the config of the index page. For example at the moment I have:
_ajaxConfig = {
denstar wrote:
On Sun, Mar 16, 2008 at 8:21 AM, Russ [EMAIL PROTECTED] wrote:
This is the first I'm hearing of Apache Derby, and although I'm sure it's a
nice project, it's written in Java, which means it will be slower then MSSQL
Just because it's java doesn't mean it's got to be
henry ho wrote:
Which DB would you choose (MSSQL Express / Apache Derby) for a small (4gb,
with only 10 simultaneous connections) intranet CF App?
Of the choices you present I would choose MS SQL Express. Derby is
either a hassle to install, or you need to run it embedded in CF which I
do
Instead of you need to use the XmlText attribute of each of your xml
elements to get at the item's string. So:
Values (
'#MyXML.UserInfoListResult.Users.UserInfo[I].Username.xmlText#',
'#MyXML.UserInfoListResult.Users.UserInfo[I].Password.xmlText#',
Sorted it.
I should have been referencing, for example:
#MyXML.UserInfoListResult.Users.UserInfo[I].Username.XmlText#
-Original Message-
From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: 16 March 2008 19:23
To: CF-Talk
Subject: RE: XML Question
As far as saying Apache Derby being slow just because it is on top of Java
is pretty baseless and making blanket statements like that are just about
as
bad as saying ColdFusion sucksand is slow because MySpace crashes all the
time.
As much a blanket a statement as I also like it cos its'
On Sun, Mar 16, 2008 at 3:27 PM, Jochem van Dieten
[EMAIL PROTECTED] wrote:
denstar wrote:
On Sun, Mar 16, 2008 at 8:21 AM, Russ [EMAIL PROTECTED] wrote:
This is the first I'm hearing of Apache Derby, and although I'm sure
it's a
nice project, it's written in Java, which
Go to the following URL,
http://www.nytimes.com/pages/business/index.html?adxnnl=1adxnnlx=1205702297-fQQvcu4oQALgFskrYAVixw
Look at the center area of the page, Multimedia,
do you see a clear 'flaw'?
To the purists, I'm sorry.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am just about ready to go live with a new application that will allow
School Districts to Delay/Close School for a day. Then have the raw data
sent to the Media so it can be displayed at the bottom of the screen
through the Character Generator.
Ioannis,
I'm not sure you can do that, but, could you extend your cfc's? This might
work --
in your component2.cfc cfcomponent extends=pathtocfc.component1
in your component3.cfc: cfcomponent extends=pathtocfc.component2
-- Josh
- Original Message -
From: Ioannis Papanikolaou
Okay, this one is not making any sense at all to me - it *has* to be a
setting issue but I can't seem to find anything to help.
I have a CFDiv tag - cfdiv id=File bind=url:showfiles.cfm?user=#userid# /
Inside the CFDiv I have a pop-up window that allows the user to edit
or add files. This works
I have a client with a Quickbooks Merchant Account and I am needing to get a
ColdFusion shopping cart setup and integrated with the QBMS API. I have
worked with PayPal and Authorize.NET in the past, but after going through
the QBMS documentation, I am either missing something, or they have done
Is the pop-up window a cfwindow or a new browser window?
Okay, this one is not making any sense at all to me - it *has* to be a
setting issue but I can't seem to find anything to help.
I have a CFDiv tag - cfdiv id=File bind=url:showfiles.cfm?user=#userid# /
Inside the CFDiv I have a pop-up
33 matches
Mail list logo