========================================================================= Date: Mon, 30 Jun 1997 15:01:08 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Nicolas Rosner Subject: Re: Question about databases by Curtis Palmer Comments: cc: webmaster@landesslezak.com In-Reply-To: <199706270404.AAA09637@services.web.aol.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII If I understand your message correctly, there are actually several different questions involved. Please note that a) I'm no real pro at this, and b) I'm used to the Illustra database, which may or may not be your case. (But I'm a PrimeHost Commercial customer myself, so I guess we both have access to the same tools.) > we would want to be able to upload from an existing database file 1) Yes, you can export your current tables from your favorite application in CSV format (any decent application should be able to handle CSV) and upload the files, which will be converted to the native Illustra table format for you. 2) If something goes wrong, you can always export in your favorite format (TSV, DBF, whatever) and write a small script that reads in the file contents and performs an sql insert() for each row. If you choose this, I would suggest you pick a text-based format, because you'll eventually run into trouble with Tcl if you try to post-process raw binary files. > and be able to easily modify on a constant basis I have a special (private, under password protection) section in my database-enhanced websites which lets me control this. It's nice, because this means you can update your tables using your browser -- i.e. you can actually add or modify information from some cybercafe in Asia :) You can use the built-in add/delete/modify tools that come with the Commercial service (/NS/Db/Admin) or you can write your own (it's not difficult at all, just a form and some sql update() statements plus some filters to avoid unwanted values). > We would want to completely control the look of the pages > (hopefully dynamically), and possibly cross reference items in > the storefront if this is possible or maybe make our own new > simpler approach to the storefront on our secure server. I'm not a user of the AOL/PH storefront package, so I can't help you out with this. However, as for building dynamic pages based on database values, I'm doing it all the time and it works fine. The main issue is that the basic HTML code for those pages (i.e. the static portion that won't change) is normally embedded in the Tcl scripts you'll want to write, which can be annoying because you have to actually re-edit the Tcl code if you ever choose to change the look-and-feel of your pages. I wrote a small script that I use all the time which basically parses a special HTML file and inserts dynamic content whenever it finds a special tag (like ). You can have the code if you want. Or, of course, you can use server- side includes for this purpose. > Is there an easy way to reference graphics in a database (for > instance: say we have 500 photos, gif or jpeg format, that we > want to have them in one directory for easy modification if > needed, and we want them to be shown dynamically on the > referenced page or entry in the database, of course along with > all the description of the particular resource. I tend to store small objects (strings, short texts, numerics) in the actual table columns, and store larger objects (large text files, graphics, movies, etc.) in actual separate files. All you have to do is to keep a correlation between the two. Example: Suppose you have a table 'employees' with the columns: emp_id first_name last_name age position You could then define (it's your table, so it's your rules) that every employee with an ID xxxx will have his/her photograph at /web/pages/employees/photos/xxxx.jpeg, and his resume at /web/pages/employees/resumes/xxxx.txt. So you can safely write a script like set db [ns_db gethandle sql] set row [ns_db select $db "select * from employees \ where age < 20;"] while {[ns_db getrow $db $row]} { set id [ns_set get $row id] set name "[ns_set get $row first_name] [ns_set get $row last_name]" append the_html_output "$name

" append the_html_output "" } This is not a complete script, but I suppose you'll get the idea. > be able to search boolean and control the results, etc. Yes, you can do all that and much more with select() statements. But remember you'll only be able to effectively search the REAL table contents. In other words: it's easy to search "all employees with age below 25", or "all employees with last name SMITH", or "all employees with names that start with A, sorted by age"... but you will NOT be able to search "all employees with a resume containing the string 'PhD'" if your resumes are text files not actually contained in the Illustra tables. (I think you can achieve this if you use the Text DataBlade, but I can't really tell, it's beyond my area of knowledge...) If you want to exchange tips or useful experiences, I'd be happy to. Sounds like we're doing quite similar work. Regards & good luck, Nicolas Rosner nrosner@slack.net nicolas_rosner@yr.com ========================================================================= Date: Tue, 8 Jul 1997 20:36:47 -0400 Reply-To: philg@mit.edu Sender: Web Development with AOLserver From: Philip Greenspun Subject: Oracle driver available Comments: To: doug@aol.net Comments: cc: feedback@aolserver.com Doug, We (the http://www.arsdigita.com nerds) have developed an Oracle driver for AOLserver and tested it successfully running as an internal driver for 2.2b2. We are going to distribute two things: 1) oracle.so shared module files. Currently we only have this for Solaris 2.5.1 with Oracle 7.3.3. 2) Sources for the oracle driver, under the GNU Public License. Do you want us to distribute these from our site or do you want to add them to the www.aolserver.com pages? Also, for big rich companies, we will be willing to offer support contracts for the Oracle driver (this includes installation, custom compilations, etc.). Philip ========================================================================= Date: Wed, 9 Jul 1997 18:02:55 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Doug McKee Subject: Re: Oracle driver available Comments: To: philg@mit.edu Comments: cc: feedback@aolserver.com In-Reply-To: <199707090037.AA143668669@martigny.ai.mit.edu> (message from Philip Greenspun on Tue, 8 Jul 1997 20:36:47 -0400) >>>>> "Phil" == Philip Greenspun writes: Phil> Doug, We (the http://www.arsdigita.com nerds) have developed Phil> an Oracle driver for AOLserver and tested it successfully Phil> running as an internal driver for 2.2b2. Excellent! Does that mean the Oracle api is thread safe or that you locked it down so that it can only handle one query at a time? And I guess it doesn't try and catch signals for you? Would you believe I'm almost done with the docs on writing External Drivers? Better late than never! I'll send you a copy when I'm done. Phil> We are going to distribute two things: Phil> 1) oracle.so shared module files. Currently we only have Phil> this for Solaris 2.5.1 with Oracle 7.3.3. Can you do this legally? I know Sybase wouldn't let us do this -- that's why we only distribute the source. Phil> 2) Sources for the oracle driver, under the GNU Public Phil> License. Great! Phil> Do you want us to distribute these from our site or do you Phil> want to add them to the www.aolserver.com pages? I'd like to link to your site from www.aolserver.com; that way you can plaster the pages with offers of support for the big rich companies. Phil> Also, for big rich companies, we will be willing to offer Phil> support contracts for the Oracle driver (this includes Phil> installation, custom compilations, etc.). doug -- ------------------------------------------------------------------- Doug McKee, Manager, Web Server Development Email: doug@aol.net America Online, Inc. Voice: (703) 918-1333 8619 Westwood Center Drive Fax: (703) 918-2710 Vienna, VA 22182 ------------------------------------------------------------------- ========================================================================= Date: Tue, 8 Jul 1997 15:31:35 -0500 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: "Michael W. Chalkley" Subject: Help! AOLserver thread max reached? MIME-Version: 1.0 Content-Type: TEXT/PLAIN; CHARSET=ISO-8859-1 I keep getting this warning in my AOLserver log: [08/Jul/1997:14:25:13 -0400][2525.3][-Scheduler-] Warning: iproute: thread max (50) reached with 14 connections waiting. Usually when I get this, I can't retrieve a web page. Any suggestions on how to fix this problem? Mike -- 15:31:39 07/08/97 _______________________________________________________________________ Michael W. Chalkley Tel: +1.770.823.7846 ZapNet! Inc. Fax: +1.770.475.7640 Suite 400-120 E-mail: mikech@well.com 10945 State Bridge Road mikech@avana.net Alpharetta, GA 30202 (wireless) mikech@radiomail.net ========================================================================= Date: Wed, 9 Jul 1997 18:20:06 -0400 Reply-To: philg@mit.edu Sender: Web Development with AOLserver Comments: RFC822 error: CC field duplicated. Last occurrence was retained. From: Philip Greenspun Subject: Re: Oracle driver available Comments: To: doug@aol.net Comments: cc: feedback@aolserver.com In-Reply-To: <199707092202.SAA22684@helix.office.aol.com> (message from Doug McKee on Wed, 9 Jul 1997 18:02:55 -0400) >>>>> "Phil" == Philip Greenspun writes: Phil> Doug, We (the http://www.arsdigita.com nerds) have developed Phil> an Oracle driver for AOLserver and tested it successfully Phil> running as an internal driver for 2.2b2. Excellent! Does that mean the Oracle api is thread safe or that you locked it down so that it can only handle one query at a time? And I guess it doesn't try and catch signals for you? Would you believe I'm almost done with the docs on writing External Drivers? Better late than never! I'll send you a copy when I'm done. Good. We're getting some nasty Oracle internal errors right now which could be related to signal problems and are about to try running the same code as an external driver. I have ported over my Q&A forum software (what you see at http://photo.net/photo/ ) to Oracle so we have a real test suite. Phil> We are going to distribute two things: Phil> 1) oracle.so shared module files. Currently we only have Phil> this for Solaris 2.5.1 with Oracle 7.3.3. Can you do this legally? I know Sybase wouldn't let us do this -- that's why we only distribute the source. I've talked to some Oracle execs and they definitely thought it was good for us to be distributing an AOLserver driver. If they tell us to stop, we'll stop. I'd like to link to your site from www.aolserver.com; that way you can plaster the pages with offers of support for the big rich companies. OK. I'll build a web page for it. Meantime, if anyone wants the source or the .so they can have it by sending me email. We're going to wait to build the official page until the system can (1) run the /NS/Admin pages reliably (2) run my Q&A forum software reliably Philip ========================================================================= Date: Thu, 10 Jul 1997 19:27:07 -0400 Reply-To: philg@mit.edu Sender: Web Development with AOLserver From: Philip Greenspun Subject: Re: AOLSERVER Digest - 1 Jul 1997 to 9 Jul 1997 Comments: cc: doug@aol.net, cottons@lcs.mit.edu In-Reply-To: <199707100405.AAA22987@services.web.aol.com> (message from Automatic digest processor on Thu, 10 Jul 1997 00:03:36 -0400) Date: Wed, 9 Jul 1997 18:02:55 -0400 From: Doug McKee Subject: Re: Oracle driver available >>>>> "Phil" == Philip Greenspun writes: Phil> Doug, We (the http://www.arsdigita.com nerds) have developed Phil> an Oracle driver for AOLserver and tested it successfully Phil> running as an internal driver for 2.2b2. Excellent! Does that mean the Oracle api is thread safe or that you locked it down so that it can only handle one query at a time? According to various semi-official Oracle docs, the Oracle C library is thread-safe as of Release 7.3. We were having some problems running it as an internal driver and we were only trying to do one query at a time so perhaps there is a signaling problem or something else nasty... Philip testing the external driver tonight ========================================================================= Date: Mon, 14 Jul 1997 17:09:49 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Barlow Subject: access log eliminating selected users Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings is there any way to make aolserver not log certain URL address;s? I would like to prevent the logs from recording my local server access;s and only record true outside users hitting my site. Thankyou Sincerely Kerry & Donald Barlow&Barlow computers Servers for you. http://mntnweb.com barlow@servtech.com ========================================================================= Date: Mon, 14 Jul 1997 01:18:49 -0400 Reply-To: philg@mit.edu Sender: Web Development with AOLserver From: Philip Greenspun Subject: internal Oracle driver complete; a few issues on external remain Comments: To: doug@aol.net Comments: cc: feedback@aolserver.com Doug, We pronounce the internal Oracle driver working. My threaded discussion software (what you see in the http://photo.net/photo/ Q&A forum) works (except some Illustra-specific SQL that I haven't ported yet, e.g., for the delicious PLS Blade). The external driver doesn't work and doesn't log any place that we can find. You will have to explain a couple of more things to me and Cotton (see previous message). We know of no reason why you'd want to run the external driver (Oracle 7.3 libraries are claimed to be thread-safe and don't appear to fight for signals). However, we are going to make source code for both versions available. Everyone else: Budget a lot more time than you'd think porting from Illustra to Oracle. Oracle does not support a lot of Illustra's SQL, e.g., 1) casting 2) subqueries in the FROM list of a SELECT 3) the ANSI timestamp and time interval stuff 4) case-sensitivity (we bashed our driver to return table and column names from Oracle in lower case; if you rely on mixed-case column names being preserved, you are hosed with a capital H) 5) Oracle is basically designed to always run "autocommit off" and doesn't have SQL equivalents to "begin transaction", "end transaction", "abort transaction" (we're emulating these in our driver). You have to decide on the transaction semantics that you want and set up our driver accordingly. 6) all the hinting for locking levels and so forth is different (probably unnecessary in Oracle for the most part, except that you want SELECT .. FOR UPDATE where with Illustra you'd take a table lock) If you port to Informix Universal Server, you have to create your database with "MODE ANSI off" if you want the Illustra semantics. And even then you have to say "begin work" and "commit work" instead of "begin transaction" and "end transaction". Anyway, this is not to scare you too much. It is certainly easy to develop a new AOLserver application with Oracle as the back end. But if you're laboring under the misconception that SQL is some kind of standard, you'll be very disappointed at how long it takes to port an old AOLserver/Illustra app. -- Philip Greenspun ------------------------------------------------------------- MIT Department of Electrical Engineering and Computer Science 545 Technology Square, Rm 609, Cambridge, MA 02139, (617) 253-8574 Web: http://www-swiss.ai.mit.edu/philg/ ========================================================================= Date: Sun, 13 Jul 1997 23:28:50 -0700 Reply-To: blakeman@pipedream.com Sender: Web Development with AOLserver From: James Blakeman Organization: pipedream.com Subject: Writing CSV back to the client...? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I've spent all day trying to get write CSV (application/csv) mime types from AOLserver without any luck. I've gone through the code that came with AOLserver (the Get Data stuff) & still can't seem to get it working. Can anyone help? Here's what I assumed: If I want to send a CSV file back to the client, it seems like I should just be able to do a: ns_return $conn 200 application/csv "comma-delimited stuff..." (or a ns_returnfile). The problem is, Excel launches but it doesn't recognize the split-out cells. This works fine with the AOLserver "Get Data" command, but not mine. Does the "ACTION" of the html form have to end in .csv? Are there headers that I'm leaving out? Thanks. Please e-mail me (as well as posting to the listserv). -James blakeman@pipedream.com ========================================================================= Date: Tue, 15 Jul 1997 19:18:24 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Doug McKee Subject: AOLserver 2.2 beta 4 AOLserver beta 4 is now available for download from www.aolserver.com. What's new: * A new Ns_ConnReturnProxyNotice C function, which is identical to Ns_ConnReturnNotice except that it includes a hostname and port in the URL for the inline image. * The following bug fixes: * The full text indexes and archives are updated when AOLpress deletes a MiniWeb. * The ns_httpget Tcl function is working correctly. * If you update a permissions record that has an IP address restriction on it, AOLserver no longer crashes. Of course, there a few new known bugs: * The ns_ext Tcl function does not work with the SOLID database driver. * You cannot set MaxThreads for a virtual server to the same value as MinThreads; if you do, the server will hang at start up. We are also tracking down some external database driver problems. As the number outstanding bugs is getting smaller than the number of known bugs in the 2.1 release, we're getting very close to calling 2.2 released. We're even getting some development done on the next rev of AOLserver while waiting for bugs on 2.2 to come in! Expect the next rev to have some great performance optimizations for both regular old static pages and AOLserver Dynamic Pages! So if you're holding out with 2.2 bugs, now's the time to send them our way (feedback@aolserver.com). doug -- ------------------------------------------------------------------- Doug McKee, Manager, Web Server Development Email: doug@aol.net America Online, Inc. Voice: (703) 918-1333 8619 Westwood Center Drive Fax: (703) 918-2710 Vienna, VA 22182 ------------------------------------------------------------------- ========================================================================= Date: Thu, 17 Jul 1997 10:16:19 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Eric O'Laughlen Subject: Re: nsftp GET problem /correction/ Comments: To: Laszlo Palmai Comments: cc: feedback@aolserver.com In-Reply-To: <199707161251.OAA00996@gw2.interware.hu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 16 Jul 1997, Laszlo Palmai wrote: Hey Laszlo, > I wrote in my previous e-mail, that I can not GET > any file with the nsftp modul (PUT, DEL, DIR works). > The server give us the following message at any GET: Have you tried using the new beta4 module? It has some bug fixes that may clear up your problem. If not, could you send me the entry for nsftp in your nsd.ini? I'll try to recreate the what your seeing on a SUN box here. Thanks for the report, o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o | Eric O'Laughlen e-mail: erico@aol.net| | AOL Web Development W: 703.918.2142 | o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o ========================================================================= Date: Thu, 17 Jul 1997 22:51:16 +0000 Reply-To: webster1@numen-lumen.com Sender: Web Development with AOLserver From: David Luhman Organization: Numen Lumen Subject: NeXT / Rhapsody port MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit This may be a little ahead of schedule, but do the folks at AOL have any plans to port AOLServer to Apple's new NeXT / Rhapsody OS -- either on Intel or PowerPC? My impression is the OS is basically a pretty BSD 4.3 so the port may not be too difficult... -- David Luhman, MBA, EA, of Numen Lumen Audio-based business and financial information for everyone http://www.numen-lumen.com ------ ========================================================================= Date: Fri, 18 Jul 1997 17:17:16 +0200 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Martijn Wismeijer Subject: Re: AOLSERVER Digest - 15 Jul 1997 to 17 Jul 1997 In-Reply-To: <199707180351.FAA19626@netlynx.neturl.nl> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Fri, 18 Jul 1997, Automatic digest processor wrote: > There is one message totalling 27 lines in this issue. > > Topics of the day: > > 1. nsftp GET problem /correction/ > > ---------------------------------------------------------------------- > > Date: Thu, 17 Jul 1997 10:16:19 -0400 > From: Eric O'Laughlen > Subject: Re: nsftp GET problem /correction/ > > On Wed, 16 Jul 1997, Laszlo Palmai wrote: > > Hey Laszlo, > > > I wrote in my previous e-mail, that I can not GET > > any file with the nsftp modul (PUT, DEL, DIR works). > > The server give us the following message at any GET: > > Have you tried using the new beta4 module? It has some > bug fixes that may clear up your problem. If not, could > you send me the entry for nsftp in your nsd.ini? > > I'll try to recreate the what your seeing on a SUN box here. > > Thanks for the report, > > o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o > | Eric O'Laughlen e-mail: erico@aol.net| > | AOL Web Development W: 703.918.2142 | > o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o > > ------------------------------ > > End of AOLSERVER Digest - 15 Jul 1997 to 17 Jul 1997 > **************************************************** > ========================================================================= Date: Mon, 21 Jul 1997 02:25:33 PST Reply-To: chlowe@uci.edu Sender: Web Development with AOLserver Comments: Authenticated sender is From: "chlowe@uci.edu" Organization: uci.edu Subject: Question About the Page Builder Module Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7BIT Has anyone experienced this error message when using the page builder module? Cannot Perform Search: The following database exception was raised while the server was attempting to satisfy your request: XL0002:schema ColValue does not exist (Note: I can access the database when going through the Database Services page but not through the page builder.) The server log produces these messages: [21/Jul/1997:01:45:05 -0700][215.117][server1] Notice: Ns_DbOpenDb(illustra): Opening datasource: default:mynewdb [21/Jul/1997:01:45:05 -0700][215.117][server1] Notice: SQL(default:mynewdb): select *,oid from gradfund where lower(ColValue.last_name) like lower('%Lowe%'); [21/Jul/1997:01:45:05-0700][215.117][server1] Notice: Ns_Ill(default:mynewdb): XL0002:schema ColValue does not exist The problem's stumping me. As far I can see (and my experience is limited), I've followed the instructions that came with the page builder. Namely, the html form input name matches those in the table. The right table's specified in the script. set sql "select *,oid from gradfund" Both the template and the html header exist and take the script defaults. set templatefile /yourtemplate.txt set headerfile /yourheader.htm Any ideas on what I'm missing here? Thanks Charles Lowe Research & Graduate Studies Univeristy of California, Irvine ========================================================================= Date: Thu, 24 Jul 1997 15:16:35 +0000 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Reinhard Henning- Abdel Hamid Subject: ODBC on Windows 95 (AOLServer 2.1 ) ? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Hi Web and AOLServer Developers I am using AOLServer 2.1 on my Home PC running Windows 95 to develop some CGI Perl Scripts and AOLServer TCL Scripts. Is it possible to use ODBC database access with this configuration (Win 95) ? I have loaded the nsdb.dll module into server1 and the nsodbc.dll as a database driver but Aolserver can't execute the tcl command ns_db: ----------------------------------- invalid command name "ns_db" while executing "ns_db pools" invoked from within "set pools [ns_db pools]..." ... invoked from within "nsp_tableperms nsc10 {}" ------------------------------ What must have been configured to let AOlserver know how to execute the ns_db command ? Maybe i configured wrong... Maybe i must have Windows NT to use the odbc functions ? I can use the external perl.exe (5.003) interpreter via CGI that is running on Windows 95 well. Perl can access odbc databases using an odbc.dll. Anyone else is using any database access and AOlserver on Win95 ? Greetings from germany Reinhard Henning ----------------------------------------------------- Reinhard Henning - Abdel Hamid, henning@hannover.de ----------------------------------------------------- ========================================================================= Date: Sun, 20 Jul 1997 13:15:34 -0700 Reply-To: blakeman@pipedream.com Sender: Web Development with AOLserver From: James Blakeman Organization: pipedream.com Subject: Call it *anything* but AOLserver! MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, Over the past few months, my company has sold our product (which interacts with AOLserver) to a few big companies here in Portland. While the companies are both really impressed with the features and performance of the server, one big thing is hampering the server's acceptance-- the name. Is anyone else having similar credibility problems? This seems like such a silly request, but could the name be changed back to NaviServer? UNIX and PC IT people at these companies have a real hard time with the "AOL" in AOLserver. They see the performance/features & say "wow", but then they hear the name & say "oh :( ... why are you using AOLserver?". I can talk until I'm blue in the face about how incredible the server's API is, but it all comes back to the name. Unfortunately, its like saying I'm going to install an Apple web server (well, maybe not that bad). Its funny, because if I said I was going to use Microsoft's IIS (a very poorly conceived architecture IMHO), there wouldn't be an issue at all. Its a marketing thing. I'd really like to see a new name, and then get NaviServer in the web server comparison reviews again. If we don't speak up, the community will blindly follow Microsoft's IIS marketing hype. What do you think? -James ========================================================================= Date: Thu, 24 Jul 1997 15:00:04 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Doug McKee Subject: Re: NeXT / Rhapsody port Comments: To: webster1@numen-lumen.com Comments: cc: petej@clickvision.com, markd@aol.com In-Reply-To: <33CEA1E5.62FD@numen-lumen.com> (message from David Luhman on Thu, 17 Jul 1997 22:51:16 +0000) >>>>> "David" == David Luhman writes: David> This may be a little ahead of schedule, but do the folks at David> AOL have any plans to port AOLServer to Apple's new NeXT / David> Rhapsody OS -- either on Intel or PowerPC? David> My impression is the OS is basically a pretty BSD 4.3 so David> the port may not be too difficult... While we don't foresee a big demand for this AOLserver on this platform either in the market or internally, we may still do the port as there is significant developer interest in doing the port. In other words, there a couple Mac-head programmers in my group that think this would be pretty cool. Of course, Apple's got to release the OS first! doug -- ------------------------------------------------------------------- Doug McKee, Manager, Web Server Development Email: doug@aol.net America Online, Inc. Voice: (703) 918-1333 8619 Westwood Center Drive Fax: (703) 918-2710 Vienna, VA 22182 ------------------------------------------------------------------- ========================================================================= Date: Fri, 25 Jul 1997 23:30:06 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Brad Chick Subject: simple way to count the number of records in a table Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Is there a simple SQL query that returns the number of rows (records) of a table without pulling all the data out with a SELECT and iterating through it? Or maybe a TCL function? Thanks. +-------------------------------------------------------------+ | | | o _ _ _ | | _o /\_ _ \\o (_)\__/o (_) | | _< \_ _>(_) (_)/<_ \_| \ _|/' \/ | | (_)>(_) (_) (_) (_) (_)' _\o_ | | --------^ ---^--- ---^--- ------- ----------- | | | +-------------------------------------------------------------+ "Doesn't matter where you finish, as long as nothing's broken!" -DoMan Brad Chick doman@doitsports.com Do It Sports, Inc. Voice: (313) 998-0007 150 S. Fifth Ave. Fax: (313) 998-0056 Suite C, Ann Arbor, MI 48014 http://www.doitsports.com ========================================================================= Date: Sun, 27 Jul 1997 11:46:13 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Krish Menon Subject: Re: simple way to count the number of records in a table In-Reply-To: <3.0.1.32.19970725233006.00c46ebc@ic.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 11:30 PM 7/25/97 -0400, you wrote: >Is there a simple SQL query that returns the number of rows (records) of a >table without pulling all the data out with a SELECT and iterating through >it? Or maybe a TCL function? > Sure. SELECT COUNT(*) FROM dataTable; Krish ========================================================================= Date: Sun, 27 Jul 1997 16:22:14 -0700 Reply-To: blakeman@pipedream.com Sender: Web Development with AOLserver From: James Blakeman Organization: pipedream.com Subject: Re: NeXT/Rhapsody Support MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "David" == David Luhman writes: David> This may be a little ahead of schedule, but do the folks at David> AOL have any plans to port AOLServer to Apple's new NeXT / David> Rhapsody OS -- either on Intel or PowerPC? David> My impression is the OS is basically a pretty BSD 4.3 so David> the port may not be too difficult... From a performance point of view, it might be better to look at a BeOS port. They already have a public release, its screaming fast, and it has great multi-processor support. I like the fact that they wrote it from the ground up-- it allow us to see what a PPC processor can really do with a clean OS. I would think that a $3K dual 604 running the BeOS would be a cost-effective alternative to a $40K SGI workstation. Netscape has already announced that they plan to port their web server to the BeOS platform. Of course, I'm a Mac person myself, so I'm definitely interested in anything that helps Apple fight the Dark Side. Speaking of multi-processor support (and in case anyone is interested) we are running AOLserver on a quad pentium pro (4 x 200MHz P6s) and it seems to scale quite well. At times it doesnt seem to use the second two processors as much as expected, but that might be a Windows NT threading issue. -James ========================================================================= Date: Mon, 28 Jul 1997 09:28:27 +0100 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Howard Jones Subject: Re: simple way to count the number of records in a table MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="---- =_NextPart_000_01BC9B38.A6E60EA0" ------ =_NextPart_000_01BC9B38.A6E60EA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit select count(*) as Num from TableName will give you a one row (and one column!) dataset with the answer in it. Cheers, Howard. -----Original Message----- From: Brad Chick [SMTP:doman@doitsports.com] Sent: Saturday, July 26, 1997 4:30 AM To: Multiple recipients of list AOLSERVER Subject: simple way to count the number of records in a table Is there a simple SQL query that returns the number of rows (records) of a table without pulling all the data out with a SELECT and iterating through it? Or maybe a TCL function? Thanks. +-------------------------------------------------------------+ | | | o _ _ _ | | _o /\_ _ \\o (_)\__/o (_) | | _< \_ _>(_) (_)/<_ \_| \ _|/' \/ | | (_)>(_) (_) (_) (_) (_)' _\o_ | | --------^ ---^--- ---^--- ------- ----------- | | | +-------------------------------------------------------------+ "Doesn't matter where you finish, as long as nothing's broken!" -DoMan Brad Chick doman@doitsports.com Do It Sports, Inc. Voice: (313) 998-0007 150 S. Fifth Ave. Fax: (313) 998-0056 Suite C, Ann Arbor, MI 48014 http://www.doitsports.com ------ =_NextPart_000_01BC9B38.A6E60EA0 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IjAIAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA/AEAAAEAAAARAAAAAwAAMAIAAAAL AA8OAAAAAAIB/w8BAAAAWwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFdlYiBEZXZlbG9wbWVu dCB3aXRoIEFPTHNlcnZlcgBTTVRQAEFPTFNFUlZFUkBTRVJWSUNFUy5XRUIuQU9MLkNPTQAAHgAC MAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAAB8AAABBT0xTRVJWRVJAU0VSVklDRVMuV0VCLkFPTC5D T00AAAMAFQwBAAAAAwD+DwYAAAAeAAEwAQAAACEAAAAnV2ViIERldmVsb3BtZW50IHdpdGggQU9M c2VydmVyJwAAAAACAQswAQAAACQAAABTTVRQOkFPTFNFUlZFUkBTRVJWSUNFUy5XRUIuQU9MLkNP TQADAAA5AAAAAAsAQDoBAAAAAwBxOgAAAAAeAPZfAQAAAB8AAABXZWIgRGV2ZWxvcG1lbnQgd2l0 aCBBT0xzZXJ2ZXIAAAIB918BAAAAWwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFdlYiBEZXZl bG9wbWVudCB3aXRoIEFPTHNlcnZlcgBTTVRQAEFPTFNFUlZFUkBTRVJWSUNFUy5XRUIuQU9MLkNP TQAAAwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAAIIbAEEgAEAOQAAAFJFOiBzaW1wbGUg d2F5IHRvIGNvdW50IHRoZSBudW1iZXIgb2YgcmVjb3JkcyBpbiBhIHRhYmxlAOkTAQWAAwAOAAAA zQcHABwACQAcABsAAQA4AQEggAMADgAAAM0HBwAcAAkAGwAUAAEAMAEBCYABACEAAAA1MTkxN0U2 QjJCMDdEMTExQThBQzAwQTBDQ0EwNjA5QwAdBwEDkAYAfAcAACEAAAALAAIAAQAAAAsAIwAAAAAA AwAmAAAAAAALACkAAAAAAAMALgAAAAAAAwA2AAAAAABAADkAgGbAODCbvAEeAHAAAQAAADkAAABS RTogc2ltcGxlIHdheSB0byBjb3VudCB0aGUgbnVtYmVyIG9mIHJlY29yZHMgaW4gYSB0YWJsZQAA AAACAXEAAQAAABYAAAABvJswOI5rfpFpBysR0aisAKDMoGCcAAAeAB4MAQAAAAUAAABTTVRQAAAA AB4AHwwBAAAAFQAAAGhqb25lc0B2b3NzbmV0LmNvLnVrAAAAAAMABhAzvNKwAwAHEDUDAAAeAAgQ AQAAAGUAAABTRUxFQ1RDT1VOVCgqKUFTTlVNRlJPTVRBQkxFTkFNRVdJTExHSVZFWU9VQU9ORVJP VyhBTkRPTkVDT0xVTU4pREFUQVNFVFdJVEhUSEVBTlNXRVJJTklUQ0hFRVJTLEhPV0FSAAAAAAIB CRABAAAAOwQAADcEAADOBwAATFpGdQv9Ap8DAAoAcmNwZzEyNSYyAPgLYG5nAdA1N50B9yACpAPj AgBjaArA4HNldDAgBxMCgwBQoRB2cHJxMhF2fQqA2QjIIDsJbw4wNQKACoFsdWMAUAsDYwBBDwIx qDAzMwumIBEwbAWQCwVABaB1AjAoKikgImEHoXVtIANSIFTzAaAYAE5hB4AKogqAA/ACbAMgZ2l2 ZSB5ewhgGNAgAiAbEANgB+AonQBwZBuDCOEZIG4hGMAsZGEBkBExIAPwdGiuIB3QGxAAcXcEkCAL gNkeoHQuGjQaNEMeEASQ9HMsGjRIG+ALER8LCvTwbGkzNgFAFpABQBLADG90GBESBDE2IC3tI9JP BRAa4G4HQAXQB5Dwc2FnZSPTHxYi5CKxgwsTIuZpLTE0NAFAcSIwMTgwAUAM0CdzYlQgRgNhOgyD YhFgQhxyYRxAH9AN4GsgW0BTTVRQOmQDckCTKqAdwHNwCRFzLgWg/G1dHxUooAZgAjApBwYQBnQI cB0weSwgSnUgbHkgMjYt0DE5QDk3IDQ6MxFhTakr91RvKQdNLgB0BSB/GAAbwAWQBSAIkAIwBCBv FGYgIjBzBUBBT0wwU0VSVjKAK/h1Yu5qGBEpBwCQbTDSIMAuIKx0bxhEHfNuGSBiHoH3McExEQWw ZAQgHrEbcAGRfxgAJX8miiI0DwYLpxpDSR8EIB4BCXAbYTRlU1FM9CBxClByNPERAAVACXDfLXEG MTWtG+AEICg2hRjAfTHBYRo0N1MdowhgBUBw/y4AIjAPIBjQGrEeAh0yG4APQOEdsxtwMnBMRUNU /x4xHEAdwASQHUBBUh3QA2CYdWdoGjQdwD8gJCCaIADAeTYQG2FUQzxwVmYYcBggaQIgPx8aVNkR AG5rK5AaNCsj00jfl0nvSv8j0ysaNHwgTO/3Tf9PD0+nfEx/UTU1IFE3Ll9Sf1NNULpfUkkvXD5c UvZS8FaQVpBSRChfcilWkV8vV5dUf1LRPJtXQVL4PljWV/EvPFL2j1aRUSBWkFKVfC8nV0H+L1S8 V/FbJ1jLWKpY2Ffxv12AUuBXcVLyULdLVl5RM/9jYiPRY8tj0yPSZRllhFC//2ffaO9p/2bGSI9s n22vS7+QCiJEbweQbicFQPcAwAJAHoF3O3MbMidAAwB8c2gt0BjhCQBBYgQgblci8CnwDyAnBCBi A2BruQnwISIaNGofdS0tb/D+TQBwGjQpmXefeJ0qryux0xo0b/AgSQVAUytTLdBaSUaALniffNVW KxBjxGU6HAAzMTMYwC6QNDgtKAAwOkAaQzE12y0xfFBGBpAd0UEbAHxfcYEnRmF4fjBX0X5pNT42 GjQzYEPBKdAt0EFulwOgBxAG4HIt0E1JgSA+NCfwJ3CBJxaDLgAgaEECQHA6Ly93hzAuv3oNIpIu ADrFGjQTgQCJ0AADABAQAAAAAAMAERAAAAAAAwCAEP////9AAAcwYFk9ETCbvAFAAAgwYFk9ETCb vAELAACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAA ABCFAAAAAAAAAwAFgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAALcNAAAeACWACCAGAAAAAADAAAAA AAAARgAAAABUhQAAAQAAAAQAAAA4LjAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAAL AC+ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABGF AAAAAAAAAwAygAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAA RgAAAAA2hQAAAQAAAAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAA AAAAAB4AQ4AIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAeAD0AAQAAAAUAAABS RTogAAAAAAMADTT9NwAAadc= ------ =_NextPart_000_01BC9B38.A6E60EA0-- ========================================================================= Date: Mon, 28 Jul 1997 03:15:15 +0000 Reply-To: webster1@numen-lumen.com Sender: Web Development with AOLserver From: David Luhman Organization: Numen Lumen Subject: Rhapsody / BeOS MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > David> My impression is the Rhapsody OS is basically a BSD 4.3 so > David> the port may not be too difficult... > > >From a performance point of view, it might be better to look at a BeOS > port. They already have a public release, its screaming fast, and it > has great multi-processor support. Hi James, BeOS might well be a faster OS on the PowerPC, but I wonder if AOL would even consider a port to BeOS. Remember, they dropped support for Windows NT. I don't know anything about BeOS, but I get the impression it has little POSIX / UNIX functionality. If it's not UNIX-based, like Rhapsody, I doubt if AOL will support it. -- David Luhman, MBA, EA, of Numen Lumen Audio-based business and financial information for everyone http://www.numen-lumen.com ------ ========================================================================= Date: Tue, 29 Jul 1997 11:06:19 -0400 Reply-To: Web Development with AOLserver Sender: Web Development with AOLserver From: Mark Dalrymple Subject: Re: Rhapsody / BeOS > I don't know anything about BeOS, but I get the impression it has > little POSIX / UNIX functionality. It's got a bit of Posix stuff in it. The main sticking point right now is that its socket handling is a little funny (it doesn't inherit sockets across fork()), which is currently holding up Apache on Be. Outside of that little snag, it's a wicked-cool platform. ++Mark Dalrymple, Certified MacHead America Online Web Server Development