Image - Crystal Report - VB6.0
Hi experts, I have blob filed, which contains the image. I am using BV6.0 as my front end application. And i have some pre-defined [defined by me] .rpt file. Along with the details, i would like to add the photo on the report. Can you help how to do this? Thank you Regards, VIKRAM A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
MySQL University session on February 11: MySQL Galera Multi-Master Replication
MySQL Galera Multi-Master Replication http://forge.mysql.com/wiki/MySQL_Galera_Multi-Master_Replication This Thursday (February 11th, 14:00 UTC), Seppo Jaakola Alex Yurchenko will talk about MySQL Galera Multi-Master Replication. Galera provides synchronous multi-master replication and uses a certification-based replication method for replicating transaction write sets in a DBMS cluster. The replication method requires close co-operation with database transaction processing and DMBS must support a specific replication API to be compatible with Galera. Codership has integrated Galera replication in the InnoDB storage engine, and the resulting MySQL/Galera cluster product has been published as a production-ready GA release in December 2009. The MySQL/Galera release 0.7 is available on the Codership and Launchpad sites. For MySQL University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks: Here's the tentative list of upcoming sessions: * February 18: Performance Schema: Instrumenting Code (Marc Alff) * February 25: Securich - Security Plugin for MySQL (Darren Cassar) * March 4: MySQL Column Databases (Robin Schumacher) * March 11: Improving MySQL Full-Text Search (Kristofer Pettersson) By the way, did I mention that we need more speakers to fill up the 2010 schedule? If you'd like to be a speaker, have a look at this blog post: http://blogs.sun.com/mysqlf/entry/mysql_university_speakers_wanted1 Cheers, Stefan -- Stefan Hinz stefan.h...@sun.com, Documentation Manager MySQL Phone: +49-30-82702940, Fax: +49-30-82702941, http://dev.mysql.com/doc Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels Vorsitzender des Aufsichtsrates: Martin Haering -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
logging of BAD queries
I've used the general and slow query log in the past, but I am trying to track down some queries from a compiled app that never seem to be hitting the DB server. My guess is that the SQL syntax is bad and never get executed, but I don't see any related queries in the general query log. Does the general log include invalid SQL? I've also tried to use the driver logging, but on Windows it overwrites with the last SQL command so I cannot get a good capture as requests are sent to the DB. DB is MySQL 5.0.x Thanks andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
query help
I am trying to write a query that merges 2 columns from different tables and show them as one column of data. Something like the following. payables ID |check_no| amount| 3 |3478| 67.00 | 4 |3489| 98.00 | 8 |3476| 56.00 | paychecks ID |check_no| amount 23 |3469|498.00 | 34 |3502|767.00 | 36 |3504}754.00 | I am struggling to write a select query that gives me amounts and check numbers from both of the tables in the same column. Like the following: ID |check_no| amount| 3 |3478| 67.00 | 4 |3489| 98.00 | 8 |3476| 56.00 | 23 |3469|498.00 | 34 |3502|767.00 | 36 |3504}754.00 | Any help would be greatly appreciated. Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: query help
SELECT ID, check_no, amount FROM payables UNION SELECT ID, check_no, amount FROM paychecks; Regards, Gavin Towey -Original Message- From: Richard Reina [mailto:rich...@rushlogistics.com] Sent: Tuesday, February 09, 2010 9:23 AM To: mysql@lists.mysql.com Subject: query help I am trying to write a query that merges 2 columns from different tables and show them as one column of data. Something like the following. payables ID |check_no| amount| 3 |3478| 67.00 | 4 |3489| 98.00 | 8 |3476| 56.00 | paychecks ID |check_no| amount 23 |3469|498.00 | 34 |3502|767.00 | 36 |3504}754.00 | I am struggling to write a select query that gives me amounts and check numbers from both of the tables in the same column. Like the following: ID |check_no| amount| 3 |3478| 67.00 | 4 |3489| 98.00 | 8 |3476| 56.00 | 23 |3469|498.00 | 34 |3502|767.00 | 36 |3504}754.00 | Any help would be greatly appreciated. Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com
Creating subsets on timestamp with modulo, date_trunc and ?suggestions?
A simple way to do this is to truncate the date and then GROUP BY it. So if you have 2009-08-08, and you want a subset on month, then just truncate the day-part: 2009-08-00 on the whole column, and SELECT DISTINCT so you have a subset. You can use this subset then to join the dates, GROUP BY and aggregate An other way I found is described in Celko's 'SQL for smarties'. He uses modulo there. It seems powerful, but also tricky to implement for dates. I was wondering if anyone knew some other way to create a subset of a timestamp column. Any input is welcome. Regards, Davor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: logging of BAD queries
At 09:27 AM 2/9/2010, andy knasinski wrote: I've used the general and slow query log in the past, but I am trying to track down some queries from a compiled app that never seem to be hitting the DB server. My guess is that the SQL syntax is bad and never get executed, but I don't see any related queries in the general query log. Does the general log include invalid SQL? I don't think it does. I've also tried to use the driver logging, but on Windows it overwrites with the last SQL command so I cannot get a good capture as requests are sent to the DB. DB is MySQL 5.0.x I do something like that in my compiled application. All SQL queries are sent to a single procedures and executed there. I trap any errors and log the SQL in a table along with the error message. This is useful to determine if someone is trying to break into the database (sql injection). Having a central procedure to execute all queries is paramount in controlling and capturing errors. I can also unplug and plug in a different database engine quite easily rather than hunting down all direct calls to the database. I also don't have to worry about trapping errors throughout the application. It's all done at one central point. I've been doing it this way for 5 years and would never start a large application without it. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: logging of BAD queries
Unfortunately, I'm using a commercial application and trying to debug as to why some data does and does not get updated properly. On Feb 9, 2010, at 2:57 PM, mos wrote: I do something like that in my compiled application. All SQL queries are sent to a single procedures and executed there. I trap any errors and log the SQL in a table along with the error message. This is useful to determine if someone is trying to break into the database (sql injection). Having a central procedure to execute all queries is paramount in controlling and capturing errors. I can also unplug and plug in a different database engine quite easily rather than hunting down all direct calls to the database. I also don't have to worry about trapping errors throughout the application. It's all done at one central point. I've been doing it this way for 5 years and would never start a large application without it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: logging of BAD queries
I'm not positive if the general log captures all invalid queries but it does capture at least some. I was asked the same question a few months back and checking to make sure that manually issued invalid queries are logged (IIRC). Could it be that the queries are never even making it to the database? Kyong On Tue, Feb 9, 2010 at 2:05 PM, andy knasinski a...@nrgsoft.com wrote: Unfortunately, I'm using a commercial application and trying to debug as to why some data does and does not get updated properly. On Feb 9, 2010, at 2:57 PM, mos wrote: I do something like that in my compiled application. All SQL queries are sent to a single procedures and executed there. I trap any errors and log the SQL in a table along with the error message. This is useful to determine if someone is trying to break into the database (sql injection). Having a central procedure to execute all queries is paramount in controlling and capturing errors. I can also unplug and plug in a different database engine quite easily rather than hunting down all direct calls to the database. I also don't have to worry about trapping errors throughout the application. It's all done at one central point. I've been doing it this way for 5 years and would never start a large application without it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kykim...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
my.cnf settings
I currently have a dedicated database server with 8 GBs of RAM and 8 1.60 GHz processors. The tables on my databases are almost exclusively InnoDB, except for 2-3 tables that are MyISAM and used for logging purposes (lots of INSERT DELAYED statements). I have the following settings in my my.cnf, and I'm having trouble adjusting the innodb_buffer_pool_size to something logical. I first tried setting it to 6000M, but the server went OOM and eventually crashed. I've subsequently kept bringing it down, and now it's at 4000M but it looks like swap is still being hit. $ free -m total used free sharedbuffers cached Mem: 7982 7943 38 0 8175 -/+ buffers/cache: 7759222 Swap: 1992702 1289 I spent some time looking at various Google links to figure out memory usage, and what I'm confused by is how mysqld is still talking up 8388m of virtual memory (according to top) and has 6.7g of physical memory used. http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/ http://www.mysqlperformanceblog.com/2009/02/12/how-much-memory-can-mysql-use-in-the-worst-case/ What I'm trying to figure out is 1. Are there settings I should turn down for myisam or myisamchk, and is that why I'm hitting 6.7GBs of actual memory? 2. Is 4000M the correct setting for innodb_buffer_pool_size? 3. Even if it is 6.7 GBs of memory, isn't 1.3 GBs of RAM (give or take) more than enough to run the rest of the machine? I don't see anything else coming close to the memory footprint of mysql, and I'm not sure why swap is still getting hit. [mysqld] #datadir=/home/mysql socket=/var/lib/mysql/mysql.sock max_connections = 320 safe-show-database skip-locking key_buffer = 192M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 32M thread_concurrency = 8 wait_timeout = 15 innodb_buffer_pool_size=4000M innodb_log_buffer_size=4M #innodb_log_file_size=128M #innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit=2 log-slow-queries=/var/log/mysql/log-slow-queries.log log-error=/var/log/mysql/mysqlerror.log #innodb_file_per_table sql-mode=NO_AUTO_VALUE_ON_ZERO [mysqldump] quick max_allowed_packet = 16M [mysql] #no-auto-rehash max_allowed_packet = 1M [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M
Re: logging of BAD queries
Am 09.02.2010 16:27, schrieb andy knasinski: I've used the general and slow query log in the past, but I am trying to track down some queries from a compiled app that never seem to be hitting the DB server. My guess is that the SQL syntax is bad and never get executed, but I don't see any related queries in the general query log. Does the general log include invalid SQL? I've also tried to use the driver logging, but on Windows it overwrites with the last SQL command so I cannot get a good capture as requests are sent to the DB. DB is MySQL 5.0.x you can try MySQL proxy -- Sebastian Mendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org