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