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
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
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.
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
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
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
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
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'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
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,
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
11 matches
Mail list logo