RE: MySql 5.0
Has 4.0 Been offical release, I thought it was still in Beta? -Original Message- From: Josh Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: Re: MySql 5.0 When can we expect a release of 5.0 with stored procedure functionality in MySQL? Sincerely, Joshua Wilson Software Engineer SOSystems Corporation [EMAIL PROTECTED] 801-222-0200 'Whoever controls your thoughts, controls your actions.' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get the total of a feild
Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. Chuck Payne Magi Design - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please confirm (conf#3609bdcf19fdd5aadddc58b8665f2e25)
IMPORTANT INFORMATION! This is an automated message. The message you sent (attached below) requires confirmation before it can be delivered. To confirm that you sent the message below, just hit the Reply button and send this message back (you don't need to edit anything). Once this is done, no more confirmations will ne necessary. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMACION IMPORTANTE Este es un mensaje automatico. El mensaje que usted ha enviado (mostrado mas abajo) necesita su confirmacion antes de ser entregado. Para confirmar que usted ha enviado el mensaje, solo presione el boton de Reply y envie éste mensaje (no es necesario editar el mensaje). Una vez realizado esto, no se necesitarán mas confirmaciones. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAÇÃO IMPORTANTE Esta é uma mensagem automática A mensagem que você enviou (em anexo) requer confirmação antes de ser entregue. Para confirmar o envio basta pressionar o botão de Reply e enviar esta mensagem de volta (não é necessário editar). Uma vez que isto seja feito, novas confirmações não serão necessárias. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- WICHTIGE INFORMATION Dies ist eine automatisch generierte Antwort. Ihre Mail (unten angehaengt) muss vor der Zustellung an mich explizit bestaetigt werden. Um dies zu tun, beantworten Sie einfach diese Mail mit der Antworten oder Reply-Funktion Ihres Mailprogramms. Es sind keine Aenderungen am Text noetig. Dies ist die einzige Bestaetigung die Sie je an mich senden muessen; Ihre weiteren Nachrichten werden automatisch akzeptiert. Diese Massnahme dient der Bekaempfung von Spam. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMATION IMPORTANTE Ceci est un message automatique. Le message que vous avez envoye (dessous) demande confirmation avant qu'il puisse etre envoye Pour confirmer que vous avez bien envoye le message ci-dessous, simplement appuyez sur la touche Reply, et renvoyez ce message (Vous n'avez pas besoin d'editer quoique ce soit). Une fois que ceci est fait, vous n'avez pas besoin d'autre confirmations. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAZIONE IMPORTATE! Questo è un messaggio automatico. Il messaggio che hai spedito (allegato sotto) richiede una conferma prima che sia consegnato. Per confermare che sei tu che hai spedito il messaggio, basta cliccare il tasto Reply e rispedirlo nuovamente (non hai bisogno di scrivere nessuna altra informazione aggiuntiva). Fatto questo, nessuna altra conferma è richiesta. --- Original Message Follows --- Date: Tue, 1 Oct 2002 23:38:34 +0200 From: [EMAIL PROTECTED] To: Chuck Payne [EMAIL PROTECTED] Subject: Re: How many days out... Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I am having problems get how many days out an invoice is. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support This email account is protected by: Active Spam Killer (ASK) V2.0.2 - (C) 2001-2002 by Marco Paganini For more information, visit http://www.paganini.net/ask - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How many days out...
Hi, I am having problems get how many days out an invoice is from mysql. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql, mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to get the number of days an invoice was submitted.
Hi, I am having problems get how many days out an invoice is. I have try this sql statement. SELECT NOW()-submmitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was submmitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Urgent!!
There is a package called Chilisoft that will let you take your ASP pages and change them to PHP, I am not sure how well it works. I had a client that want to run ASP on linux and told I didn't think you could but PHP works and to me is better. But the price of Chilisoft was a little hight. I think a round $500. But hey that my 2 Cents. Chuck Payne Magi -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:29 PM To: Insanely Great Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED] Subject: Re: Urgent!! On Sun, 29 Sep 2002, Insanely Great wrote: Date: Sun, 29 Sep 2002 22:43:43 +0530 From: Insanely Great [EMAIL PROTECTED] To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Urgent!! Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Doesn't do to badly with .jsp either. ? How do you intend to run .ASP on linux? Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FileMaker Pro Schema Export?
Question are you want to take your data from Filemaker to Excel? Because what I had to do was re-create the tables in MySQL then out putting the data to cvs table. Making sure the data was divide by a command, then I use mysqladmin or you can use phpMyAdmin import it into you MySQL. If that what you are doing. I might be able to help a little. Chuck Payne Magi Design and Support Account Protect by ASK! -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 2:52 PM To: Jan Steinman Cc: [EMAIL PROTECTED] Subject: Re: FileMaker Pro Schema Export? I never actually looked into it. There are so many work arounds I need to do in FileMaker that I just redesign the tables in MySQL. If there isn't a FileMaker converter, I'm sure there is a DBF converter. You can just save you FileMaker databases as DBF and then convert them. On Monday, September 30, 2002, at 09:14 AM, Jan Steinman wrote: Before I go and write one, does anyone know of any tools to create MySQL tables from FMP databases? All that I've seen are commercial products that synch the two, but the MySQL tables have to already exist. (I have hundreds of columns that I'd rather not key in manually!) -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert into multi-tables
Hi, I have a question. I have two tables that I want to post data too. Is there a way to do a sql statement that lets me post data two tables at the same time? Thanks, Chuck Payne - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Goodday
'mysql' there need to be a better filter. Yes, We get this letter 20 times a weeks. I will forward this on to the FBI to add to their list. -Original Message- From: Clive Smart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 9:55 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Goodday How did this get past the filters? Ocita Gabriel wrote: Attn: mysql , My name is Ocita G, the manager, credit and foreign bills of Ecobank Plc. I am writing in respect of a foreign customer of my bank with account number 14-255-2004/utb/t who perished in a plane crash [Korean Air Flight 801] with the whole passengers aboard on August 6, 1997. Since the demise of this our customer, I personally has watched with keen interest to see the next of kin but all has proved abortive as no one has come to claim his funds of usd.20.5 m, [twenty million five hundred thousand united states dollars] which has been with my branch for a very long time. On this note, I decided to seek for whom his name shall be used as the next of kin as no one has come up to be the next of kin. And the banking ethics here does not allow such money to stay more than Six years, because money will be recalled to the bank treasury as unclaimed after this period. In view of this I got your contact through a trade journal after realizing that your name and country is similar to the deceased. I will give you 25% of the total. Upon the receipt of your response, I will send you by fax or e-mail the application, bank's fax number and the next step to take. I will not fail to bring to your notice that this business is hitch free and that you should not entertain any fear as all modalities for fund transfer can be finalized within five banking days, after you apply to the bank as a relation to the deceased. When you receive this letter. Kindly send me an e-mail signifying Your decision including your private Tel/Fax numbers for quick communication. Respectfully submitted, Ocita G. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . -- | _ __ ___ | | | |/ / ___/ __ \/ ___| Clive W. Smart | | | | / / /__/ /_/ / / R D Director | | | |/|/ / ___/ __ |\_ \WEBServ a div. | | | / /__/ /_/ /__/ /of Melange Hold | | |_/|_//_//ERV [EMAIL PROTECTED] | || | Tel: +27 11 372-9800 Fax: +27 11 372-9801 | || - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql wont start on SUSE
Have you went into YaST and turn it on? I won't run until you do so. You can start it yourself as well; /etc/rc.d/mysql start Chuck Payne On Monday, July 1, 2002, at 09:47 AM, Cal Evans wrote: What's your log file say? * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Jacques Steyn [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 8:28 AM To: Alexander Barkov Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: mysql wont start on SUSE Anybody had a problem with MySQL that does not start on SUSE 8 with default installation? If yes, what was the problem? Thanks Jacques ___ Jacques Steyn +27 (0)11 478-1259 http://www.knowsystems.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql wont start on SUSE
SuSE 8 and for that matter all version of SuSE MySQl doesn't run until you use YaST to turn it. That why it's not starting. You can start it your by the following command; /etc/rc.d/mysql start If there is no problem with mysql you should see this mysqld done By going into YaST2/YaST and telling it to start mysql it will start it from boot up. For more help with SuSE and start up daemons feel free to write me ok. This isn't really mysql fault, it the way SuSE control things. Chuck Payne Magi Design and Support SuSE user from the past 5 years. On Monday, July 1, 2002, at 10:34 AM, Egor Egorov wrote: Jacques, Monday, July 01, 2002, 4:28:25 PM, you wrote: JS Anybody had a problem with MySQL that does not start on SUSE 8 with default JS installation? JS If yes, what was the problem? What do you mean does not start? If you get any error please provide more info. Check also you host_name.err file in the MySQL data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with PHP, but I know it MySQL
Hi,
I am working on a movie database I have two database that I am calling from
but the problem I am having when I ask it to go and fetch all the movies
with the same title, it stops and only shows one.
Here is a basic layout...
if($videoid) {
$result = mysql_query(SELECT * FROM library WHERE videoid=$videoid,$db);
$myrow = mysql_fetch_array($result);
// The Myrows
$title = $myrow[title];
$videoid = $myrow[videoid];
$catergory = $myrow[catergory];
$appraisal = $myrow[appraisal];
// Some where here it's not working.
$sql = SELECT concat_ws(' ', fname, lname)as actor FROM actormovie WHERE
title = '$title' ORDER by lname;
$result = mysql_query($sql);
print $sql;
$actor = ;
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= A HREF='' . $actor . /ABR\n;
}
What am I doing working.
Chuck Payne
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
