<cfquery name="QueryName" datasource="DataSourceName" username="DBUserName"
password="DBPassword" dbtype="OLEDB" dbserver="ServerIP" dbname="DDName"
provider="SQLOLEDB"></cfquery>
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
ICQ #: 916324
----Original Message Follows----
From: "Erika L Walker" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: To ASP or not to ASP
Date: Wed, 21 Mar 2001 10:53:29 -0500
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
