[EMAIL PROTECTED] (Miles Thompson) wrote in
news:[EMAIL PROTECTED]:
This query:
SELECT
member_id,
member_sub_id,
IF( ( monthly_cost = 10 ), ( SUM(( monthly_cost * 2.00 ) + 200 )
), ( SUM(
monthly_cost * 12.00 ) ) ) AS Amount
FROM subinfo
WHERE
Since no one seemed able to answer my question, I went looking elsewhere,
and found the solution. Just wanted to share with you, in case anyone else
is having the problem. I realize now (too late), that I should have posted
this on the MySQL .NET list. I'm sure someone would have answered
Does the ODBC connector itself pass its test (on the connector configuration
page)? That would determine whether or not this is an MS Access problem, at
least.
Unfortunately, I don't know what to suggest in either case, other than
making sure you have the latest connector software. I presume you
-Original Message-
From: Colin Charles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 17, 2007 9:08 PM
To: Kristen G. Thorson
Cc: mysql@lists.mysql.com
Subject: Re: Log Warnings Level
Kristen G. Thorson wrote:
Hi!
But all I really get from this reading is 0 turns it
Hello list,
I am currently trying to fix a bug in a search function with a request
like this one :
select * from forum where topic like '%[...]%' ;
where [...] is a string escaped by mysql_real_escape_string (C API) and
topic is a varchar field (not null).
It works, but there is a bug if
Hi,
gif will inevitably gravitate towards jif for the same reason SQL is
sequel and lib, as in /usr/lib, is often 'libe'. The reasons
are described in the Appendix to Orwell's 1984 which is dedicated to
newspeak, look for 'duckspeak' in particular,
and the consideration of 'Minitruethful' vs
Are you working on a Mac? If so, logging in as root is not good
enough. You must have set up and log into the root user account of
your Mac computer or server. This, if anything is a Apple problem and
advantage. The Administrator is opening to the account you are in,
the login in window
Don't include the password, let mysql prompt for it. ' ./bin/
mysqladmin -u root password -p '.
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote:
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
* Robert DiFalco [EMAIL PROTECTED] [06/04/30 03:09]:
Thanks Sergei, it's nice to know for sure. Do you know if there is any
documentation on how memory is used to store LOB data? For example, is
it a percentage of the total buffer pool size or is it allocated from
available memory
Hello!
I'm thinking to develop a database interface for our company and I thought
great when I discovered that Visual Basic 6 was able to interact with MySQL.
That's because VB6 is very easy and PHP (even being fast, but its hard for
me) gets slower because the source code for HTML pages
Thanks for the reply Daniel,
This is not on a Mac. I'm running MySQL Administrator 1.2.8 on a XP/SP2 machine
and I'm connecting to a MySQL 5.1.9 server running on Netware6.5.
- Still looking for help.
Daniel Culver [EMAIL PROTECTED] 1/19/07 9:52 AM
Are you working on a Mac? If so, logging
Hi Gabriel,
Try as:
mysql select * from forum where topoc like %%;
To search for '\', specify it as ''; this is because the backslashes are
stripped once by the parser and again when the pattern match is made,
leaving a single backslash to be matched against. (Exception: At the end of
Hi
Update will never support group by clause, only supports group functions;
Try as:
Update teams t
inner join rider_team as rt on (rt.team_id=t.id)
inner join participants as p on (p.rider_id=rt.rider_id)
inner join races as r on (r.id=p.race_id)
set
Kristen G. Thorson wrote:
But all I really get from this reading is 0 turns it off, 1 prints
some
warnings, and 2 prints level 1 warnings plus aborted connections
warnings. I have not been able to find any additional information
in my
search. Am I missing something, or is this all the
14 matches
Mail list logo