Re: merge two statements

2001-06-03 Thread Patrick Goetz
h daily U.S. oil consumption would drop if SUVs' average fuel efficiency increased by 3 mpg: 49,000,000 *** _Patrick Goetz _| ~-. Dept. of Mathematics \, *_} The University of Texas at Austin[EMAI

How long should sql-bench/run-all-tests take?

2001-05-10 Thread Patrick Goetz
d by 3 mpg: 49,000,000 ******* _Patrick Goetz _| ~-. Dept. of Mathematics \, *_} The University of Texas at Austin[EMAIL PROTECTED] \( Austin, Texas 78712-1084 Phone: (512) 232-2746 ht

Re: XML support under mySQL

2001-02-27 Thread Patrick Goetz
eir cars while 32 percent have actually given their four-wheeled gas-guzzler a name. Seventeen percent of male participants planned to buy their vehicle a gift on Valentine's Day, the poll said. ******* _Patrick Go

Boolean Puzzler - What is the parser doing?

2001-02-18 Thread Patrick Goetz
I have a cgi-bin script which generates SQL expressions based on some user input. I noticed yesterday that for certain input, the script would return wildly incorrect results from the database. The problem was fixed by adding parentheses around part of the Boolean expression in the WHERE clause

Re: secure web server to database server connection

2001-01-26 Thread Patrick Goetz
Thanks for the response. On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote: > > It just occurred to me, however, that this becomes a much bigger > > problem when the web server(s) and the database server are running > > on different machines. > > Only if they're on different networks. Ideally, you

secure web server to database server connection

2001-01-25 Thread Patrick Goetz
Currently, every system I've set up is small enough so as to have the web server and the database server on the same machine. Consequently, loss of security due to packet-sniffing can be completely controlled by using, say, apache-ssl, since communications between the web server and the database