RE: Count (*) function results needed in echo statement

2003-03-04 Thread Sqlcoders.com Programming Dept
> -Original Message- > From: Stitchin' [mailto:[EMAIL PROTECTED] > Subject: Count (*) function results needed in echo statement > > > I've got the following code in my php file: > > > > /* Select all categories from designcatagories table */ > $query = "SELECT

RE: Just being prudent - upgrade MySql v3.23 to v4.0.2

2002-09-02 Thread Sqlcoders.com Programming Dept
Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for "You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html)" ..." In general what you have to do when upgrading to 4.0 from an earlier MySQL version: Run the mysql_fix

RE: LOAD DATA LOCAL INFILE "not allowed this version"?

2002-09-08 Thread Sqlcoders.com Programming Dept
One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0. In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): The used command is not allowed with this MySQL version http://www.m

RE: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Sqlcoders.com Programming Dept
It's also possible someone subscribed abuse@verizon to the mySQL mailing list I think. Perhaps someone has a grudge against verizon. > -Original Message- > From: Joel Rees [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 18:07 > To: Franz, Fa. PostDirekt MA > Cc: [EMAIL PROTECTED]

RE: SPAM *** Audit feature in MySQL ***

2002-09-23 Thread Sqlcoders.com Programming Dept
Try http://www.mysql.com/doc/en/Query_log.html > -Original Message- > From: Imro Benito STROK [mailto:[EMAIL PROTECTED]] > Sent: 23 September 2002 20:04 > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]'; Imro Benito STROK > Subject: SPAM *** Audit feature in MySQL *** > > > Hi All, > >

RE: Archive of this mysql list

2002-10-03 Thread Sqlcoders.com Programming Dept
Ahem, have a look at the bottom of any post to the list: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) :) HTH, William. > -Original Message- > From: Chris Becker [mailto:[EMAIL PROTECTED]] > Sent:

RE: Reply-to munging

2002-10-03 Thread Sqlcoders.com Programming Dept
> > I don't by the "less functionality" argument any more than "if > you have a good > emailer". I think I have a good emailer, and on the "munging" > lists, I press > Reply-All, it will also send to the original author, but >95% of > the case I > want the list, and original author doesn't want t

RE: Question Regarding Update Year statement

2002-10-04 Thread Sqlcoders.com Programming Dept
Hi!, > From: W [mailto:[EMAIL PROTECTED]] > Sent: 04 October 2002 15:11 > To: [EMAIL PROTECTED] > Subject: Question Regarding Update Year statement > I'm looking for a date function that will allow me to update only the year > portion of a field to a particular year, in this case, 2002. > > I've

RE: Reposting: Connecting a web server to a db server

2002-10-08 Thread Sqlcoders.com Programming Dept
> -Original Message- > From: Nestor [mailto:[EMAIL PROTECTED]] > Sent: 08 October 2002 16:01 > To: [EMAIL PROTECTED] > Subject: Reposting: Connecting a web server to a db server > > > Any ideas? > Have you reloaded the mysql server? Try this at the shell... mysqladmin -u root -p reload

RE: storing PDF files in mysql ?????

2002-10-08 Thread Sqlcoders.com Programming Dept
Toby, If I understand correctly you want to perform two distinct actions: 1. Convert Microsoft Office Word .doc files into .pdf 2. Store those pdf's in MySQL. You should look into (via google.com) some doc to pdf converters. An example is this com object: http://www.convertzone.com/doc2pdfcom/help