Webcatalog/ColdFusion/Tango

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21685
interpreted = N
texte = R#233#pondre #224#: Webcatalog/ColdFusion/Tango And what about Tango ?M#237#che#225#l O S#233# wrote: >>I'm getting some pressure from a client to build them an e-commerce >>solution with Cold Fusion rather than WebCatalog. Can somebody who's >>familiar with both give a me an idea of the difference in the products. >>(I'm very familiar with WebCat but have little knowledge of CF) > >.cfm syntax is a lot more cluttered. >Say you want to search a database for all customers and return all fields. > >You would have something like this in .cfm > > datasource=CustomerDB > name=customers> > SELECT name, address, city, > state, zip > FROM CustomerTable > WHERE state=#statevar# > >#statevar# > > #name#
> #address#
> #city#, #state# #zip#
>

> > >It gets worse if you use .asp ><%dim statevar statevar = request.querystring(state)%> ><%Set DataConn = Server.CreateObject(ADODB.Connection) >DataConn.Open DSN=CustomerDB Set DataCmd >=Server.CreateObject(ADODB.Command) >DataCmd.CommandText = SELECT name, address, city, state, zip >FROMCustomerTable WHERE state = &statevar Set DataCmd.ActiveConnection = >DataConn Set customers = DataConn > Set customers = DataCmd.execute%> ><%do While not customers.EOF response.write(& customers(name) > &
& customers(address) &
& customers(city) &, & >customers(state) & & customers(zip) &

) >customers.moveNext loop %> > >Webcat is a breeze compared to all this:-)) > >Regards, >**************************************************************** >Micheal O Se >www.elive.ie Internet Hosting Service >micheal@elive.ie Database powered websites >**************************************************************** > > > > > > > > >RFC822 header >----------------------------------- > > RECEIVED: from SF_Database by POP_Mailbox_-1298892692 ; 09 DEC 98 18:56:44 UT > Received: from NS.smithmicro.com by 192.168.101.12 > with SMTP (QuickMail Pro Server for MacOS 1.1.1r1); 09 DEC 98 18:56:42 UT > Received: from 207.67.226.146 (ns2.smithmicro.com [207.67.226.146]) > by ns.smithmicro.com (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) >with SMTP > id JAA02234; Wed, 09 Dec 1998 09:13:16 -0800 > Date: Wed, 9 Dec 1998 17:04:48 +0000 > Message-Id: > From: =?iso-8859-1?Q?M=EDche=E1l?= O =?iso-8859-1?Q?S=E9?= > Subject: Re: WebCatalog vs. Cold Fusion > To: WebDNA-Talk@smithmicro.com > Mime-Version: 1.0 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > Precedence: Bulk > X-URL: http://www.smithmicro.com/ > X-URL-Search: http://search.smithmicro.com/ > Reply-To: WebDNA-Talk@smithmicro.com > Associated Messages, from the most recent to the oldest:

    
  1. Webcatalog/ColdFusion/Tango (Edouard Janssens 1998)
R#233#pondre #224#: Webcatalog/ColdFusion/Tango And what about Tango ?M#237#che#225#l O S#233# wrote: >>I'm getting some pressure from a client to build them an e-commerce >>solution with Cold Fusion rather than WebCatalog. Can somebody who's >>familiar with both give a me an idea of the difference in the products. >>(I'm very familiar with WebCat but have little knowledge of CF) > >.cfm syntax is a lot more cluttered. >Say you want to search a database for all customers and return all fields. > >You would have something like this in .cfm > > datasource=CustomerDB > name=customers> > SELECT name, address, city, > state, zip > FROM CustomerTable > WHERE state=#statevar# > >#statevar# > > #name#
> #address#
> #city#, #state# #zip#
>

> > >It gets worse if you use .asp ><%dim statevar statevar = request.querystring(state)%> ><%Set DataConn = Server.CreateObject(ADODB.Connection) >DataConn.Open DSN=CustomerDB Set DataCmd >=Server.CreateObject(ADODB.Command) >DataCmd.CommandText = SELECT name, address, city, state, zip >FROMCustomerTable WHERE state = &statevar Set DataCmd.ActiveConnection = >DataConn Set customers = DataConn > Set customers = DataCmd.execute%> ><%do While not customers.EOF response.write(& customers(name) > &
& customers(address) &
& customers(city) &, & >customers(state) & & customers(zip) &

) >customers.moveNext loop %> > >Webcat is a breeze compared to all this:-)) > >Regards, >**************************************************************** >Micheal O Se >www.elive.ie Internet Hosting Service >micheal@elive.ie Database powered websites >**************************************************************** > > > > > > > > >RFC822 header >----------------------------------- > > RECEIVED: from SF_Database by POP_Mailbox_-1298892692 ; 09 DEC 98 18:56:44 UT > Received: from NS.smithmicro.com by 192.168.101.12 > with SMTP (QuickMail Pro Server for MacOS 1.1.1r1); 09 DEC 98 18:56:42 UT > Received: from 207.67.226.146 (ns2.smithmicro.com [207.67.226.146]) > by ns.smithmicro.com (2.5 Build 2640 (Berkeley 8.8.6)/8.8.4) >with SMTP > id JAA02234; Wed, 09 Dec 1998 09:13:16 -0800 > Date: Wed, 9 Dec 1998 17:04:48 +0000 > Message-Id: > From: =?iso-8859-1?Q?M=EDche=E1l?= O =?iso-8859-1?Q?S=E9?= > Subject: Re: WebCatalog vs. Cold Fusion > To: WebDNA-Talk@smithmicro.com > Mime-Version: 1.0 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > Precedence: Bulk > X-URL: http://www.smithmicro.com/ > X-URL-Search: http://search.smithmicro.com/ > Reply-To: WebDNA-Talk@smithmicro.com > Edouard Janssens

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

variables in or out of includes (2001) [HIDEIF] inside [FOUNDITEM] (1997) request for new command (1997) NumFound (1999) I have observed and I am gone. (1998) WebDNA Solutions ... sorry! (1997) OLD PROBLEM (1997) Sherlock plug-in? (1999) shipcost (1997) bug in [SendMail] (1997) How can I Add several Items into the cart at once? (1997) [WebDNA] Update on WebDNA? (2011) Another question (1997) ssh shutdown (2005) RE: Contexts and Ampersands (1997) Press Release hit the NewsWire!!! (1997) no global [username] or [password] displayed ... (1997) Help! WebCat2 bug (1997) += (was RE: ++) (2005) multi-paragraph fields (1997)