Hola,
Tengo una base de datos realizada con MySQL y desearÃa generar informes
mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC 3.51.10
me sale el siguiente error:
Logon Failed
Details: ADO error Code 0x8000fff
Source: Provider
Description: Error catastrófico
Native Error: -21474
solved it...
i used 'distinct' in main and subquery and somehow it affects the whole
query results...
---
Badai Aqrandista
Cheepy (?)
From: "Badai Aqrandista" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: subquery accross different database
Date: Mon, 19 Sep 2005 15:14:06 +100
Hi all,
I have two three tables, spread accross two databases:
hotel_1 database:
table room (room_id, room_name)
table package (package_id, package_name)
master database:
table search_cache (date, room_id, package_id, hotel_id)
I'd like to search for any combination of room/package ids that do
Belay my comments on true and false. I got mixed up. That works as documented.
On Mon, 19 Sep 2005, Roger Baklund wrote:
> [EMAIL PROTECTED] wrote:
> > I did not expect that null was not not-equal to 1.
>
> Any comparison with NULL returns NULL:
>
> mysql> select null<>1,null>1,null<1,null=1;
> +
[EMAIL PROTECTED] wrote:
Thanks but I still do not get why this does not merit a, "you might want to
think about this".
So in the following query:
select * from new_payments where closed<>1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a fe
Thanks but I still do not get why this does not merit a, "you might want to
think about this".
So in the following query:
select * from new_payments where closed<>1;
it is desired that null=1. DeMorgan's law takes a vacation here.
Correct behavior, in that it is a feature, I expected that; des
Schalk Neethling wrote:
Greetings
What might be causing the 1064 error in the following query?
SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
+ Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpum
[EMAIL PROTECTED] wrote:
I did not expect that null was not not-equal to 1.
Any comparison with NULL returns NULL:
mysql> select null<>1,null>1,null<1,null=1;
+-++++
| null<>1 | null>1 | null<1 | null=1 |
+-++++
|NULL | NULL
Ken Gieselman <[EMAIL PROTECTED]> writes:
[...]
> Yeah, that's my "fall-back" option -- though the thought of executing
> the query twice is a bit daunting. Some of the tables run into
> billions of rows per year (the merge tables anyhow, the data tables
> are broken down by month to keep them f
Greetings
What might be causing the 1064 error in the following query?
SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
+ Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpumalanga
GP + Glam Slam Mo
2005/9/18, Miguel Cardenas <[EMAIL PROTECTED]>:
> > http://dev.mysql.com/doc/mysql/en/mysql-free-result.html
> > it does not says : you have to retrieve all rows before freing it. So
> > you should be able to free the result. Otherwise it's a bug or
> > undocumented behaviour.
> > But why don't you
Richard
>I would like to display all messages which match both 5 and 7 in terms
>of the parent_id, meaning messages 10 and 13 would be displayed.
SELECT f1.child
FROM foo AS f1
INNER JOIN foo AS f2 USING(child)
WHERE f1.parent=5 AND f2.parent=7;
PB
-
Hobbs, Richard wrote:
Hello,
I hav
My question question from MySQL 4.0.22: is it okay that a null interger tests as
equal to any value. I am not sure the table structure matters but in case it is
I included it.
I did not expect that null was not not-equal to 1. Cursory testing seems to
indicate that a null integer field is not not-
Hello,
I have two tables - one containing messages, and another containing links
between messages and other messages in a tree structure (much like a threaded
mailing list archiving thing). A single message can have multiple "parents"
though, meaning the links table can have several entries for a
Scott Gifford wrote:
Ken Gieselman <[EMAIL PROTECTED]> writes:
[...]
So, here's my question: How can I find out how many rows are being
returned by a query, without using mysql_stmt_store_result() to
buffer all the rows back to the client?
One straightforward way is to replace the SELECT c
Alvaro,
>The problem is that in the same php page I would like to choose
either the
>calculation from an especific year or the calculation from the
whole table
>using URL.
That needn't raise a problem, especially in PHP. If the user chooses a
year, have the page construct the appropriate WHER
Hello
I've just experienced troubles with mysql_free_result() but don't know what is
wrong... one of my programs has 2 simultaneous connections to MySQL and
crashed when doing the mysql_free_result(), I thought it was 'cos the way I
was making the program, but now I have the problem with single
Josh Chamas <[EMAIL PROTECTED]> writes
>Dyego Souza Dantas Leal wrote:
>> I want to use INTEL SHARED MySQL 4.0.25 - Pro with innodb tables on
>> PRODUCTION SERVER DELL 2600
>>
>> The Linux Kernel is 2.6.12 and the hardware is DUAL XEON 2.4 HT iwth 4
>> GB of RAM
>> (i'm using raw partitions feat
--
___
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.
Powered by Outblaze
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
If you can catch hold of a windows box then there is
tool called SQLyog that has a great migration tool.
I was able to import a clients MDB database with all
the FKs directly from Access to MySQL. You dont need
to go thru Access -> Script -> MySQL.
You can download it from http://www.webyog.com
> http://dev.mysql.com/doc/mysql/en/mysql-free-result.html
> it does not says : you have to retrieve all rows before freing it. So
> you should be able to free the result. Otherwise it's a bug or
> undocumented behaviour.
> But why don't you use the Count(*) solution ?? that's exactly what you
> ne
hi
how can i uninstall mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz i would
like to install mysql-4.1.14.tar.gz
thank you very much.
rgds,
Joeffrey
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005
Hi,
Database is MySQL 4.1.5-gamma, running on Linux.
All charset variables are set to default 'latin1', except
'character_set_system', which is utf8.
A database was created and running in this environment, but the data it
gets (from php) were in utf8. Mysqldump is used without any options to
expor
Hi,
> while ( my1.fetch ) {
>my2.query + my2.store
>if ( my2.fetch ) {
> report = my1 + my2 results
>} else {
> report = my1
>}
>my2.FreeResult <--- free for every my2.query inside loop
> }
> my1.FreeResult <--- free for unique my1.query
One My2.store == One My2.f
2005/9/17, Miguel Cardenas <[EMAIL PROTECTED]>:
> > In the last episode (Sep 17), Miguel Cardenas said:
> > > I have a technical doubt, very simple but not mentioned in the manual...
> > >
> > > What happens if I call mysql_free_result() after performing a query
> > > but without doing mysql_fetch_
2005/9/18, Jasper Bryant-Greene <[EMAIL PROTECTED]>:
> Alvaro Cobo wrote:
> > Thanks Pooly and Peter:
> >
> > The problem is that in the same php page I would like to choose either the
> > calculation from an especific year or the calculation from the whole table
> > using URL.
>
> The same page c
26 matches
Mail list logo
