Re: decode statement: Viruses on your site please
I was surprised to see that you put viruses on your website for people to download telling them that they are games. If you are not aware, the download section of your site http://mail.sni.ph/~rroa contains a virus in the file tetris.com This is very bad. I wish the moderator of the MySQL list removes you from it. Thanks Emery - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 11:19 AM Subject: decode statement Hi, Anybody tried to include mysql functions like DECODE('some_text','pass_text') to a PHP script? I know this is not a server question...but I hope somebody can help on this... R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) Web : http://mail.sni.ph/~rroa http://mail.sni.ph/~rroa http://pollquest/rosel http://pollquest/rosel - 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: basic question
Make it TIMESTAMP But remember that this data type gets updated every time the record is changed. Hope this helps. Thanks Emery - Original Message - From: Edward Peloke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 11, 2002 5:50 PM Subject: basic question sql query when I am defining a table, how do I set the default of a datetime column to the current time? I tried setting the default to now() but it just fills the column with 00:00 etc.. Thanks, Eddie - 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
SHAPE command for Hierarchical Recordset
I have created a MySQL database that will help me manage my Invoicing system but I have been stack when I tried to print a report using a VB application. I have read from Help that I will need to use a hierarchical recordset to achieve what I want to. You know an Invoice has some headers like: Customer names, Invoice number, ... It also has details of ordered products/services Like: Item ID, Description, ... So my invoice should look like: ++ NZEYIMANA (Customer name) Some Addresses Invoice No.: 2002-09/5 -+ Item IDDescriptionQtyUPTotal -+ 12dfhsdfdsfjsd525125 ... ... _ Total 125 VAT: - ++ To build such an invoice using ADO, VB, DataReport you need that Hierarchical recordset because DataReport won't accept if it is not a hierarchical recordset. How do I achieve this? Thanks Emery - 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: SHAPE command for Hierarchical Recordset
Where can I get those tools? With MS access, my queries work fine after importing the data from MySQL Thanks Emery - Original Message - From: CP [EMAIL PROTECTED] To: NZEYIMANA Emery Fabrice [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 10:47 AM Subject: Re: SHAPE command for Hierarchical Recordset I would suggest you use MS Access report with MyTool-DLL For VB and MySQL. - Original Message - From: NZEYIMANA Emery Fabrice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 4:40 PM Subject: SHAPE command for Hierarchical Recordset I have created a MySQL database that will help me manage my Invoicing system but I have been stack when I tried to print a report using a VB application. I have read from Help that I will need to use a hierarchical recordset to achieve what I want to. You know an Invoice has some headers like: Customer names, Invoice number, ... It also has details of ordered products/services Like: Item ID, Description, ... So my invoice should look like: ++ NZEYIMANA (Customer name) Some Addresses Invoice No.: 2002-09/5 -- -- -+ Item IDDescriptionQtyUPTotal -- -- -+ 12dfhsdfdsfjsd525 125 ... ... _ Total 125 VAT: - ++ To build such an invoice using ADO, VB, DataReport you need that Hierarchical recordset because DataReport won't accept if it is not a hierarchical recordset. How do I achieve this? Thanks Emery - 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 as a desktop DB
I have tried this but some queries that run on Access failed to run on MySQL. I had this problem with INNER JOIN Thanks Emery - Original Message - From: Gerben Gieling [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED]; David Lloyd [EMAIL PROTECTED] Cc: Adam Parker [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:24 AM Subject: RE: MySQL as a desktop DB The combination of Access front end with MySQL or PostgreSQL works great. However there is a disadvantage in using Microsoft Office applications. If you use Visual Basic code to program the behaviour of your front end (You probably will). The front end will run great until the next major update of MSOffice. It will again make a lot of changes without backward compatibility. This needn't be a problem If you are in control of the migration. But, if your IT department decides to migrate to a new version of MS Office catching you unprepared, your database will be without functional or with a misbehaving front end until you fix the code. I quit using Access and migrated my front end to Apache/PHP running on the same (linux) server as the database (an old pc found in the trashbin because it wasn't fast enough to run windows 95). -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 17:34 To: David Lloyd Cc: Adam Parker; [EMAIL PROTECTED] Subject: Re: MySQL as a desktop DB David Lloyd wrote: MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). I've never done it, but have you tried Access linked to MySQL through MyODBC? PS, SQL ... Query ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Report writer
Can you please help me? If you can help direct me where to get a report writter running on Windows. By reading your post, you know some report writters that run on windows. Thanks Emery - Original Message - From: Derek Scruggs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 6:12 AM Subject: OT: Report writer Hi All, This is a little OT, but I'm looking for a report writer/server for Apache/MySQL. There are lots of report writer/servers out there, but the ones I've found so far either 1) work only on Windoze or 2) cost a lot of money. I'm just looking for a basic tool that allows me to design relatively simple reports on a Windoze desktop and upload the report schema to a Linux/Apache web server, which generates the reports on the fly. It would be great if it used PHP so I could tweak the internals, but I'm not holding my breath on that. I'll probably end up writing my own module, but it would be nice if there were something available that automated some of the more mundane stuff such as pagination, parameters etc. TIA, Derek - 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