------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 20:59
To: CF-Talk
Subject: Re: To ASP or not to ASP
If you have a single datasource set up on the server, you can point to any
database in your TransactSQL statements.
SELECT column
FROM databasename.databaseowner.tablename
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
Erika L Walker wrote:
> Examples?? Very interested in this.....
>
> "I have used dynamic OLEDB database connections many times with 4.0 and
4.5.
> Don't have to have a connection set up on the server even now.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> ICQ #: 916324"
>
> -----Original Message-----
> From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 10:20 AM
> To: CF-Talk
> Subject: RE: To ASP or not to ASP
>
> I have used dynamic OLEDB database connections many times with 4.0 and
4.5.
> Don't have to have a connection set up on the server even now.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> ICQ #: 916324
>
> ----Original Message Follows----
> From: "Ben Forta" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: RE: To ASP or not to ASP
> Date: Wed, 21 Mar 2001 09:49:21 -0500
>
> Andy, FYI, CF5 lets you do the same thing. Specify __DYNAMIC__ as the
> DBTYPE, and just pass the connection string to <CFQUERY> (and <CFINSERT>,
> and <CFSTOREDPROC>, etc).
>
> --- Ben
>
> -----Original Message-----
> From: Andy Ewings [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 9:40 AM
> To: CF-Talk
> Subject: RE: To ASP or not to ASP
>
> Yeh I agree but some clients will insist their site is built in ASP...and
if
> you refuse to use it then you're gonna loose the work
>
> Also you say CFQuery sure beats all that ADO code - I agree it does but
> using ADO/RDO/DAO etc with ASP does have one advantage. You can create
> connexions on the fly.....i.e. you do not have to rely on the server
having
> a DSN set up....which cold fusion does. Not a masive advantage when
> building web sites as there tends to be only one machine but when writing
> client server apps and roling out to a hundred machines..........
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> ------------------------------------------------------------------
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> ------------------------------------------------------------------
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> ------------------------------------------------------------------
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy, distribute,
or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
> -----Original Message-----
> From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]]
> Sent: 21 March 2001 14:32
> To: CF-Talk
> Subject: RE: To ASP or not to ASP
>
> I first developed web apps in ASP but soon discovered CF. But I was one
of
> those who came from a programming background -- 10+ years in VB, C, RPG,
and
> COBOL. I gladly embraced CF for something that none of these other
> languages offer: simplicity and speed of development. Having coded CF
> full-time now for over three years I have yet to encounter a situation
where
> I wished I was back in ASP-land. Plus I have never encountered a language
> where it is easier than CF to decipher and understand code written by
> someone else -- even bad code.
>
> Also, CFQUERY sure beats all that ADO code.
>
> > -----Original Message-----
> > From: Zhou, Mei Y (Mei) [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 21, 2001 7:30 AM
> > To: CF-Talk
> > Subject: RE: To ASP or not to ASP
> >
> > Hi, I think I am in the opposite position as you, I have worked for ASP
> for
> > more than 3 years, and now I have to learn ColdFusion. Since I do not
> know
> > CF as much as ASP,
> > what I can say is that:
> >
> > 1. ASP is much powerful for people who comes from programming
background,
> > you can have much
> > flexibility for customizing your web application, but CF will be more
> > friendly for
> > people who does not want to do much by themselves instead using
tags...,
> >
> > e.g. you can use both VBScript/JavaScript for ASP, however, what we can
> use
> > for
> > CF? I have tried <CFSCript>, and from CF document, it says to look
> for
> > JavaScript like to put it there, but I do not see too much
> explanation
> > there..
> >
> >
> > 2. Besides, the most important thing here for us is:
> >
> > If Alliare disappear one day ( e.g. no more support for the marketing
> reason
> > ), where else you can find a job?
> >
> > However, if ASP disappear, e.g. C# is coming up... then, you can still
> use
> > your VBScript
> > and JavaScript to find yourself very marketable in the job market...
> >
> >
> > Mei
> >
> > -----Original Message-----
> > From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 20, 2001 5:34 PM
> > To: CF-Talk
> > Subject: To ASP or not to ASP
> >
> >
> > This is a Microsoft shop here so that makes me a lone CF'er singing the
> > praises and virtues of CF. One of our Small Apps Team members in IS is
> keen
> > to explore CF a bit as he is currently entirely limited to ASP. He
asked
> me
> > the other day, "What makes CF better than ASP?" I said that might be an
> > interesting question to pose on CF-Talk (for legitimate comments, one
way
> or
> > the other, without wishing to incite any flame wars :-)
> >
> >
> > ****
> >
> > Kevin Parker
> > Web Services Manager
> > WorkCover Corporation
> >
> > [EMAIL PROTECTED]
> >
> > www.workcover.com
> >
> > p: +61 8 82332548
> > f: +61 8 82332000
> > m: 0418 800 287
> >
> >
> >
> >
> >
> >
>
****************************************************************************
> > This e-mail is intended for the use of the addressee only. It may
contain
> > information that is protected by legislated confidentiality and/or is
> > legally privileged. If you are not the intended recipient you are
> prohibited
> > from disseminating, distributing or copying this e-mail. Any opinion
> > expressed in this e-mail may not necessarily be that of the WorkCover
> > Corporation of South Australia. Although precautions have been taken,
the
> > sender cannot warrant that this e-mail or any files transmitted with it
> are
> > free of viruses or any other defect.
> > If you have received this e-mail in error, please notify the sender
> > immediately by return e-mail and destroy the original e-mail and any
> copies.
> >
>
****************************************************************************
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
