Thanks for the ideas, Dan. I'm making progress!
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Sue Cram" <[EMAIL PROTECTED]>
Cc:
Sent: Sunday, February 13, 2005 12:34 AM
Subject: Re: Total Counts, Multi-Report Questions
In the last episode (Feb 12), Sue Cram said:
I h
Thank you kindly for your gracious help.
I am making much progress (the 'as r' and 'as g' syntax is helpful; I'd
forgotten about it since I'm doing most of this through Perl; thanks). I
played with the COUNT solution for a while and was initially encouraged,
nay, ecstatic.
However, I was ge
--- Osvaldo Sommer <[EMAIL PROTECTED]> wrote:
> David:
>
> If you have windows XP go:
> Start/Control Panel in ther choose "Administrative
> Tools" and in there
> is "Data Sources (ODBC)" where you can define your
> dsn.
I can't see Administrative Tools anywhere in my
Control Panel, but I now ha
David:
If you have windows XP go:
Start/Control Panel in ther choose "Administrative Tools" and in there
is "Data Sources (ODBC)" where you can define your dsn.
Osvaldo Sommer
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 13, 2005 12:46 PM
To:
I would just like to say thank you to everyone on the list who helped hunt
down and find quirks while we coded up our latest software.
We are absolutely thrilled with the resulting speed and power of our CMS
software now. The ability to Optimize peoples websites while still keeping
them dynamic i
--- Andrew Pattison <[EMAIL PROTECTED]> wrote:
> < rewarded with
> something similar to what I got before.>>
>
> Not sure what you are looking for then. The myODBC
> driver should not need configuring, beyond setting
> up data sources, which is exactly what the control
> panel applet does for y
<>
Not sure what you are looking for then. The myODBC driver should not need
configuring, beyond setting up data sources, which is exactly what the control
panel applet does for you. There is no program to launch - you configure a data
source to allow you to access data, then use your ODBC-capa
--- Andrew Pattison <[EMAIL PROTECTED]> wrote:
> The ODBC control applet in Windows can be found in
> two places:
>
> 1. Control Panel.
> 2. Administrative Tools (if you are using Windows
> 2000 or XP).
>
> If you have Windows 2000 or XP, the easiest way to
> find it is to find
> your "Administ
The ODBC control applet in Windows can be found in two places:
1. Control Panel.
2. Administrative Tools (if you are using Windows 2000 or XP).
If you have Windows 2000 or XP, the easiest way to find it is to find
your "Administrative Tools" folder (usually you need to tweak the Start
menu to make
I've checked Start > Programs very thoroughly, and I
can't find any reference to ODBC. That's what's so
weird; I can see it in Add/Remove programs.
I made a desktop shortcut icon to the system32/ODBCad
file, but all it does is open up ODBC DataSource
Administrator, which doesn't appear to be a sta
Except that he/she is using 4.0, which doesn't support subqueries.
Michael
Peter Brawley wrote:
Have a look at the manual page for EXISTS, you appear to need something
like
SELECT * FROM resources AS r
WHERE EXISTS (
SELECT resource_id FROM goals AS g
WHERE g.resource_id = r.id AND grade=1
AM Thomas wrote:
I'm trying to figure out how to select all the records in one table
which have multiple specified records in a second table. My MySQL is
version 4.0.23a, if that makes a difference.
Here's a simplified version of my problem.
I have two tables, resources and goals.
resources tab
Creating users in mysql is: GRANT ALL|[CREATE|UPDATE|etc.)] PRIVILEGES ON
dbname.tablename TO [EMAIL PROTECTED] IDENTIFIED BY password
If you want to check the "grants" to see if you've created that user
correctly, try: SHOW GRANTS FOR [EMAIL PROTECTED]
Michael
-Original Message-
From:
David,
>I installed ODBC before but never got a chance to do
>much with it before my computer crashed. But I could
>have sworn there was a simple icon that I clicked to
>start it, just like a normal software program.
My recollection is that ODBC installation "normally" adds ODBCAdmin to
the Start
--- Neculai Macarie <[EMAIL PROTECTED]> wrote:
> > I just installed MySQL's ODBC program, but I can't
> > figure out how to launch it. I see no reference to
> > ODBC when I go to Start > Programs. The only thing
> > resembling an executable icon I can find is in my
> > Add/Remove programs directo
> I just installed MySQL's ODBC program, but I can't
> figure out how to launch it. I see no reference to
> ODBC when I go to Start > Programs. The only thing
> resembling an executable icon I can find is in my
> Add/Remove programs directory. I did a Windows search
> and found many files named ODB
I just installed MySQL's ODBC program, but I can't
figure out how to launch it. I see no reference to
ODBC when I go to Start > Programs. The only thing
resembling an executable icon I can find is in my
Add/Remove programs directory. I did a Windows search
and found many files named ODBC, most of t
Hi all
I've installed MySQL on my Ubuntu Linux system. Then I installed MySQL
Query Browser on my Win XP laptop.
I've created a user for the MySQL which in the host field I've put %,
I guess it means access from every IP (am I right?)
But I cant connect to the MySQL instance. What could be wrong
Have a look at the manual page for EXISTS, you appear to need something like
SELECT * FROM resources AS r
WHERE EXISTS (
SELECT resource_id FROM goals AS g
WHERE g.resource_id = r.id AND grade=1 AND subject='English'
)
AND EXISTS (
SELECT resource_id FROM goals AS g
WHERE g.resource_i
Original Message
From: "Oddvar Kragseth" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Sunday, February 13, 2005 3:35 PM
Subject: Importing a separated file into mysql, national charset
problem??
> I'm importing a file into mysql.
>
> Most work fien, but numbers are given like this
I'm importing a file into mysql.
Most work fien, but numbers are given like this :
`487,90`116,40`4467,00`
This creates a problem, as the decimal numbers are NOT read... i.e i get 487.00
, 116.00 in my database.
Is this a "national" problem as we use komma as a decimal seperator in Norway?
Do
We did get the problem kind of solved up to now. We basically use as advised
the option innodb flush_log_at_trx_commit=2. This did get the timelage
solved.
I still do not really understand why we had to speed the slave up like this
because it should have been faster due to the hardware already. I
Hi all,
Does anyone know how to detect if error occurred during runtime in a
transaction block?
For example :
Begin tran A
Drop table X #error will occurred because there is no table X
#if error occurred go to exit point. This is the sql code I'm
asking.
COMMIT
Dears,I have following Makefile :
INCS=-I/usr/include/mysql
LIBS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
LIBS_R=-L/usr/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm
-lpthread
MYSQL_LIBS=-L/usr/lib/mysql -lmysqld -lpthread -lz -lcrypt -lnsl -lm
-lpthread -lrt
CXXFLAGS=-march
I'm trying to figure out how to select all the records in one table
which have multiple specified records in a second table. My MySQL is
version 4.0.23a, if that makes a difference.
Here's a simplified version of my problem.
I have two tables, resources and goals.
resources table:
ID TITLE
1
Hi,
Sometimes an example is worth a 1000 words.
Does anyone know of a website with lists of mysql statement examples?
ie a list of queries, a list of updates, list of inserts
from simple examples to joins regexps etc
zzapper (vim, cygwin, wiki & zsh)
--
vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbby
On Fri, 11 Feb 2005 18:41:38 -0500, wrote:
>
>zzapper wrote:
>
>> On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote:
>>
>> Tom adapting your script,
>>
>> create table test (txt varchar(255)) Type=MyISAM;
>> insert into test values('Some Text\nand some more');
>> update test set txt = replace(tx
Chris,
- Original Message -
From: "Chris Elsworth" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 12, 2005 2:14 PM
Subject: Re: slow query, how can i imporve it?
On Fri, Feb 11, 2005 at 10:45:46AM -0500, [EMAIL PROTECTED] wrote:
Normally I do not reply t
OK, I use an older version of PHP where mysql_real_esacpe_strings isn't
avail. But nevertheless I would always prefer double-quoting with
$descrip_field=str_replace("'","''",$$descrip_field);
This is because I got lot's of Problems with different languages on
different databases when you try to m
Hi leegold,
I don't know what mysql_real_escape_string would do, because it isn't a
standard-php-function. So I don't regard it and talk about the basics.
In fact you have a string delimiter in "Librarian's Edition" so you have to
escape it to make MySQL know where the string really ends.
The
In the last episode (Feb 12), Sue Cram said:
> I have a request for a list of database entries "Select x,y,z, etc"
> that is now working OK. I have several questions, however. Here
> they are:
>
> 1.. Can I add a "total" line at the bottom of the report (ex:
> "Total Selected: 23") for the to
31 matches
Mail list logo
