, but
if not, how to I modify the API to provide this?
thanks
alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for test_id. Is there some trick to finding null valued
records in MySQL? This same sql has always worked on any other dbms
I have used.
thanks
alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this;
SELECT * FROM tests WHERE test_id IS NULL
Yes, that works, but I was also trying SELECT * instead of just the
key field (just a typo in the example). The problem was in the equal
sign versus the 'IS' operator. Any reason why MySQL does not honor
field=NULL? Seems kind of odd.
alan
--
MySQL
going wrong?
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light reading
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light reading
All,
Is there a recommended GUI that will administer multiple MySQL 4.x
databases. I need the ability to monitor connections, health, users, etc.
and notify me when there is a problem with an instance.
Regards,
Alan L. Fisher
GPI
--
MySQL General Mailing List
For list archives: http
All,
I would like to knew if anyone knows of a way to automate innoDB Hot Backups
of several databases that can be set to occur at off hours. Also, is it
possible to run several backups at one time. I am using MySQL 4.1.x on a
Solaris system.
Thanks,
Alan Fisher
--
MySQL General Mailing List
All,
I have been tasked with setting up DR between two different sites. Is there
a favorite tool or GUI that someone could recommend for this task?
Regards,
Alan L. Fisher
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
the INSERT/UPDATE/DELETE (or anything that will
make the data change). All other nodes would be considered SLAVEs and
be READ-ONLY.
Hope this helps.
a
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mailing List
= 1;
SET FOREIGN_KEY_CHECKS=1;
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and therefore not have to bring it down ever.
I wrote a blog entry about this very thing, and had some interesting
comments back on
http://blog.spikesource.com/mysql_hotbackup.htm
Hope this helps,
alan
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http
.
HTML is just string; treat it as such and don't give it anymore credit
than that and you'll be fine.
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
this helps,
alan
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
t: 650 249 4279
b: http://compiledby.spikesource.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have made a user with the following command:
GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
Silly question Morten, and I am sure you have probably done it, but
you are definitely running:
% mysql FLUSH PRIVILEGES;
--
Alan Williamson, Technology Evangelist
SpikeSource
(more than one file handle since there is multiple files that
describe a table under MyISAM).
BTW on Linux systems you can check this using:
% lsof
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mailing List
MySQL Server v4.1.x
Is there a table in any instance of mysql that I write some queries and
insert/update statement against for moving databases between systems?
Any assistance would be appreciated.
Does anyone have a sample of a simple update statement I can run to update a
field in a table to all uppercase values.
Any help or web references are appreciated.
We have 2 distinct groups of developers - Windows vs. Linux. Our production
server is going to run on Solaris.
The issue is that all developers run there own instance of MySQL server Linux
or Windows based and the same version 4.1.7. Also, each developer has the
database for their particular
C.B IS NULL
Expected Result:
A3
--
2
Actual Result:
A3
--
1
2
2
Tried in postgresql and it works like the expected result.
Fix:
none
Submitter-Id:
Originator:Alan Tam
Organization:
MySQL support: none
Synopsis: Right join after inner join has wrong result
Severity: serious
to submit it as bug 4893 anyway. The
syntax there should be correct.
--
Regards,
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dan wrote:
the most popular would have been Red Hat, which doesn't have this limit
you speak of, even plain vanilla install (no twiddling needed).
Not to spoil a perfectly good pontification ... but i have to say that
we have a Redhat8 distribution running on a Dell PowerEdge Server and
when
Thank you, a much reasoned and sensible reply.
This is information people can use, as oppose to the posts that 'say
well its okay for me, you must be stupid' types.
;)
Dan Nelson wrote:
In the last episode (Apr 06), Alan Williamson said:
the most popular would have been Red Hat, which
CURDATE() support numeric addition like this? Or is the +0
purely a casting-hack to get the right format. Its not meant as pure
addition.
Thoughts?
thanks
alan
--
Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/
e: [EMAIL PROTECTED]
b: http://alan.blog-city.com/
--
MySQL General
Does CURDATE() support numeric addition like this? Or is the +0
purely a casting-hack to get the right format. Its not meant as pure
addition.
Yes, hav a look at http://www.mysql.com/doc/en/Date_and_time_functions.html
for explaination
further for addition, use date_add(curdate(), interval 1
RTFM!
and what was the reason for this rudeness? Can't you explain yourself
without descending into this sort of language?
I do read the manual, and it is this reason i posted to the list.
Clarity is a wonderful thing, and sadly the manual isn't clear on this
matter.
I stand by my original
to a table using INNODB?
Should it have been created as a INNODB for better performance?
Any thoughts, insights, would be listened to intensely! :)
thanks
--
Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/
e: [EMAIL PROTECTED]
b: http://alan.blog-city.com/
--
MySQL General Mailing List
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
Chris Nolan wrote:
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table
Can people please just email the list and not the person *AND* the list!!!
i get duplicate emails and its very annoying to what is a great list so
far. kinda puts me off from answering peoples questions!
thanks! :)
- Original Message -
From: Alan Williamson [EMAIL PROTECTED
let the real SQL experts jump in here and give
their response.
--
Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/
e: [EMAIL PROTECTED]
b: http://alan.blog-city.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
With respect to this problem, I am not running on Windows, but Redhat,
and seeing this problem often.
Which part of:
http://www.mysql.com/documentation/connector-j/index.html#id2803835
should i be looking at?
thanks
alan
--
MySQL General Mailing List
For list archives: http
error.
Thanks.
- Original Message -
From: Alan
To: [EMAIL PROTECTED]
Sent: Saturday, February 28, 2004 5:07 PM
Subject: procedure entry point question
Hello,
I'm working with MySql 4.0.18 on Windows2000 and have a question about the C API
function
Hello,
I'm working with MySql 4.0.18 on Windows2000 and
have a question about the C API function mysql_real_escape_string( ).
The program I'm working on compiles and links
flawlessly, but at runtime, I get a system pop-up with the error: "The
procedure entry point
thanks.
alan
--
Alan [EMAIL PROTECTED] - http://arcterex.net
There are only 3 real sports: bull-fighting, car racing and mountain
climbing. All the others are mere games.-- Hemingway
--
MySQL General Mailing List
such a lamer n00b, but it's not my DB and mysql has
always just worked for me (though I don't use many 600k row tables :)
Alan
--
Alan [EMAIL PROTECTED] - http://arcterex.net
There are only 3 real sports: bull-fighting, car racing
] http://linuxfromscratch.org/pipermail/blfs-dev/2002-December/001770.html
--
Alan W. Rateliff, II: RATELIFF.NET
Independent Technology Consultant :[EMAIL PROTECTED]
(Office) 850/350-0260: (Mobile) 850/559-0100
In all probability it's (x_section.Status 1) = 0 and
(x_instance.Status 255) = 0 that's giving you the problem.
Unfortunately this is a database schema problem not a query fix. By putting
a computation on a field into the WHERE clause, you're forcing the database
to do that computation on
part_description field,
like the DISTINCT clause does for rows, i need the same thing for a field
value, how can I do this?
Thanks for the help,
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear sirs,
I have mysql 4.01 installed on my pc (not source,only binary)on win98 (I tried in win
XP too).I downloaded myodbc source (3.51)and tryed compiled release with nmake (using
makefile included in source)but aving a link error unresolved esternal _aulldvrm in
mysqlclient (same message
, mysql
--
Alan W. Rateliff, II: RATELIFF.NET
Independent Technology Consultant :[EMAIL PROTECTED]
(Office) 850/350-0260: (Mobile) 850/559-0100
-
[System Administration][IT Consulting][Computer Sales
machine died and has yet to
be replaced. Until then, what kind of problems are you having compiling on
Solaris 7?
Alternately, check out SunFreeware http://sunfreeware.com as Steve has
MySQL 3.23.53 ready to go for 7/SPARC.
--
Alan W. Rateliff, II: RATELIFF.NET
Independent
Okay, I've seen just about every question on last_insert_id(), except this
one:
I am running MySQL on Win XP and when I generate a test table (test) with an
AUTO_INCREMENT column (aid) and a second column (a) then use an insert
statement like: INSERT INTO test (a) values (1); then: SELECT
section 4.1.2 `my.cnf' Option Files, and
section 7.5.2 InnoDB Startup Options.
Unfortunately, MySQL silently accepts and ignores 'innodb' type tables
when innodb is disabled. All the foreign key constraints are accepted
and ignored too.
Good luck,
Alan
?
Thanks for any and all help!! If you need any more information, I would
be more than happy to answer any questions!
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?
.
Dear List,
I'm using
-InnoDB tables), as of version
3.32.50.
I don't want to do an upgrade unless I'm certain that I will
get the feature.
Can anyone enlighten me?
Many thanks in advance,
Alan.
-
Before posting, please check:
http
Mark Matthews wrote:
Alan Hodgkinson wrote:
I would like to extract the meta data describing foreign key
relationships using ODBC (actually in Java using JDBC).
My current version of mySQl 3.23.49 does not seem to support
it. That is the methods DatabaseMetaData.getImportedKeys
From: David T-G [mailto:[EMAIL PROTECTED]]
...I still have to figure
out how to make sure that our credit card types and skill levels don't
get corrupted (MC, MasterCard, mastercard, ...), but I guess that gets
enforced in the software interface, right?
Isn't the card type a piece of derived
From: Michael She [mailto:[EMAIL PROTECTED]]
...So are you saying that the Windows ODBC MySQL driver
doesn't support multiple statements?
So far as I know, *no* drivers support multiple statements.
However, that's not what you want for bulk inserts. What you want is multiple value
sets in
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
...How can I make it so only one form
selection adds a DESC tag to the query, is this possible?
I'm using this code:
$fetch = mysql_query(SELECT * FROM players ORDER BY $var);
select name='var' size='1' style='border-style: solid;
mysql select sum(trial_signups) from campaign_t where
datestamp='20021204'\g
++
| sum(trial_signups) |
++
|100 |
++
mysql SELECT site_id, sum(raws) As RawHits, sum(uniques) As
UniqueHits,
sum(trial_signups)
it only takes a few minutes to uninstall and install...
-Original Message-
From: Amittai Aviram [mailto:[EMAIL PROTECTED]]
Sent: Monday, 2 December 2002 9:37
To: Mysql
Subject: Embarrassing: can't log in
I've got an embarrassing problem. I installed MySQL on my WinXP machine
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 November 2002 13:01
To: MYSQL
Subject: date conversion
I was wondering if some things can be done with mySQL:
Select rows that have a number in ANY column, without specifying every
column in the select statement.
Perform statistical analysis on the numbers in a column (like regression).
I've only seen simple things like maximum and sum.
the
table again to add the ID field
Alan
-Original Message-
From: Chris Walcott [mailto:cwalcott;macromedia.com]
Sent: Thursday, 14 November 2002 9:42
To: Mysql-L (E-mail)
Subject: trouble with LOAD command
How do I LOAD a text file into a table that has a Primary Key defined?
I have
ignore the obsolete in the main select when it's returned since it will all
be the same value... put it first.
Alan
-Original Message-
From: Ed Reed [mailto:ereed;nearfield.com]
Sent: Tuesday, 12 November 2002 18:54
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Newbie Question
MySQLFront will create the tables and pump the data with one button
press
Alan
-Original Message-
From: Terry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 12 November 2002 22:02
To: [EMAIL PROTECTED]
Subject: RE: How to port MS Access to MySQL ??
MyODBC works fine,
but what
The .Neta Adapter.. does it make a persistent connection?
If the connection drops between the first insert and the call to select,
then the return would be zero
Alan
-Original Message-
From: Cain O'Sullivan [mailto:cos;iinet.net.au]
Sent: Wednesday, 13 November 2002 16:13
To: [EMAIL
You can't count the join?
Alan
-Original Message-
From: Rick Baranowski [mailto:rickb;baranconsulting.com]
Sent: Wednesday, 13 November 2002 12:10
To: [EMAIL PROTECTED]
Subject: Count Rows in two tables
Hello all,
Does anybody have a SQL string to count the rows in two
Ah, yes - sorry
Alan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:murad;godel.bioc.columbia.edu]On Behalf Of Murad Nayal
Sent: Wednesday, 13 November 2002 12:58
Cc: [EMAIL PROTECTED]
Subject: Re: Count Rows in two tables
Alan McDonald wrote:
You can't count
I agree mostly,... but why is ASP worthless?
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:vanboers;why.dedserius.com]On
Behalf Of Van
Sent: Monday, 11 November 2002 6:21
To: Paul DuBois
Cc: MySQL
Subject: Re: PHP bias (Way OT)
Paul:
Not sure why my post didn't cc
As Far As I Know
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named mysqld...less one mysqld_safe
which is main
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)
-Original Message-
From: Gelu Gogancea [mailto:ggelu;arctic.ro]
Sent: Saturday, 9 November 2002 23:37
To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
Subject: Re: mysqld refuse to die
Yes.All processes are named
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
-Original Message-
From: 3mip1s4la
MySQLfront does it all
-Original Message-
From: tmb [mailto:topmailbox;yahoo.com]
Sent: Friday, 8 November 2002 23:18
To: [EMAIL PROTECTED]
Subject: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create
maybe it doesn't then in MySQL - it does elsewhere
Alan
-Original Message-
From: David Felio [mailto:david;ark.org]
Sent: Saturday, 9 November 2002 1:59
To: MySQL List
Subject: Re: Copy Records in a table...
Is the implementation of this different than the docs say? According
If the data contains \, then database will automatically takes \
away and shift 1 byte left.
My data will mass up. That is why I still need \
Does your data actually include backslash characters? If you want to import them as
they are, you definitely don't want to ESCAPE BY them.
Escaping is
insert into mytable(field1, field2, field3) select field1, field2, newvalue
from mytable where productcode=xx
-Original Message-
From: Doug Coning [mailto:lists;coning.com]
Sent: Friday, 8 November 2002 14:35
To: [EMAIL PROTECTED]
Subject: Copy Records in a table...
Hi everyone,
I was under the impression that hotbackup was only available with innodb
tables
where do you get amanda from?
Alan
-Original Message-
From: Lewis Watson [mailto:lists;visionsix.com]
Sent: Wednesday, 6 November 2002 14:22
To: mysql
Subject: MySQL and amanda
Hey MySQL users!
I have
Because a primary key is a table property and the index of the key is a
property of the primary key. If you want ot drop a primary key you alter the
table
-Original Message-
From: Eric Frazier [mailto:ef;kwinternet.com]
Sent: Tuesday, 5 November 2002 15:26
To: Paul DuBois
Cc: Uma
-Original Message-
From: Chris Mason [mailto:masonc;masonc.com]
[...]
The problem is, it is easy to test for one amenity, but I need to test
that the hotel has all of the amenities. The query above
returns all the
hotels that have ANY of the amenities, I need the hotels having ALL
Then, why..., if I wait a little longer, does the alter command work? I do
not change the the permissions in the meantime. I just wait.
Alan
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Tuesday, 29 October 2002 1:38
To: Alan McDonald
Cc
I use MySQLFront and is creats the tables and imports the data with one
click
never had a problem
Alan
-Original Message-
From: [EMAIL PROTECTED] [mailto:Sam4Software;aol.com]
Sent: Wednesday, 30 October 2002 9:15
To: [EMAIL PROTECTED]
Subject: Access2MySQL
Hi all,
After setting
.. Is there another way?
thanks
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
But after a while it does, cause I only have to wait a while with no
activity on the database, and the command executes. So it's not permissions
Alan
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Tuesday, 29 October 2002 1:38
To: Alan McDonald
Is it possible to update a field using SQL with the contents of a text file
previoously written to disk?
I want to update a mediumtext field with the contents of c:\data\mytext.txt
file.
update mytable set mymediumtext= filecontents where id=number... ?
Alan
SQL
ASP
I can't seem to find any examples of saving text area form inputs to TEXT
type fields.
They all seem to be text inputs or strings being saved to varchar fields...
Can someone point me to an example of saving large text quantities to a TEXT
Type field in ASP?
Thanks
Alan McDonald
http
SQL
The docs say that recordset1.RecordCount will return the correct value if
adUseClient is used as the cursorlocation setting. I find that this is not
correct - is there another setting which needs to be mae to make this return
correctly - my return matching rows setting is also set.
Alan
John,
StudioName?
GenreName?
F_Name?
L_Name?
DatabaseName?
ServerName?
Alan
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, GenreID
isn't that the month changing?
it's changing from october to january...??
Alan
-Original Message-
From: Jay X [mailto:sparqz50;hotmail.com]
Sent: Monday, 21 October 2002 12:20
To: [EMAIL PROTECTED]
Subject: timestamp bug increments by one day
Hi There,
Just reciently (after
can someone tell me why I get this error back from postings?
Your message was not delivered for the following reason:
E-mail Account: lists-mysql is over the limit of 31457280 bytes.
Automated Postmaster
Alan McDonald
http://www.meta.com.au
I think you need to give us the SQL you are using to do the search - we'll
ba ble to see what your are trying to do better
Alan
-Original Message-
From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 15:37
To: [EMAIL PROTECTED]
Subject: a mysql question
I'm
a generator ID and using that (guaranteed to
be unique) for both the primary key of the master and the foreign key of the
detail records. Surely there is a good method for use with MySQL?
Alan McDonald
http://www.meta.com.au
? Or
does insert_id() return another connections last insert?
Alan
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 0:59
To: Alan McDonald; [EMAIL PROTECTED]
Subject: RE: Inserting Master and Details records
Hi
insert_id returns
Sorry your second link makes that claim a little clearer - it's on a
per-connection basis
Alan
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 16 October 2002 23:58
To: [EMAIL PROTECTED]
Cc: Alan McDonald
Subject: Re: Inserting Master and Details
keyword using your
favorite text editor) works like a charm, promise.
Also, if you have crle configured already, you needn't worry about the
LD_LIBRARY_PATH variable. I don't have it set on any of my boxen, and
everything runs peachy.
--
Alan W. Rateliff, II: RATELIFF.NET
the old package, but I'd hope that package maintainers
wouldn't just nuke a db directory without warning :)
alan
--
Alan Arcterex [EMAIL PROTECTED] -=][=- http://arcterex.net
I used to herd dairy cows. Now I herd lusers. Apart from the isolation, I
think I preferred the cows. They were better
,center_content,right_content) against ('exi');
Empty set (0.00 sec)
As far as I can tell, this *should* be working. Can anyone help please?
Regards and TIA.
alan
--
Alan Arcterex [EMAIL PROTECTED] -=][=- http://arcterex.net
I used to herd dairy cows. Now I herd lusers. Apart from
, but when I execute the
query again, I still get the same results.
Any other ideas? This works for others I am guessing. I've tried this
on the binary 4.0.4-beta on a redhat 7.2 system and 4.0.1-alpha compiled
from source on a gentoo system.
--
Alan Arcterex [EMAIL PROTECTED] -=][=- http
On Sun, Oct 13, 2002 at 10:58:53PM +, Sergei Golubchik wrote:
Hi!
On Oct 13, Alan wrote:
mysql select title from content where match
(title,center_content,right_content) against ('updates');
+-+
| title
I am trying to create a mysql connection pool in Weblogic 6.1 using the
JConnector driver and failing. All I get is no suitable driver which
usually means that the URL and properties aren't right for the driver I'm
using. I defined the pool as:
name: MysqlPool
URL:
??).
Worked like a charm. Thanks for all your hard work. Looks like I'll be
updating my aged HOWTO :)
--
Alan W. Rateliff, II: RATELIFF.NET
Independent Technology Consultant :[EMAIL PROTECTED]
(Office) 850/350-0260: (Mobile) 850/559-0100
anything.
If anyone knows a way to perform an internal select similar to what is shown
above, please let me know.
---
Alan Coleman
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
Never mind, I figured it out by reading a previous question and I understand
how to use Left join to do this.
-Original Message-
From: Alan Coleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:22 AM
To: [EMAIL PROTECTED]
Subject: Internal Select statements using
Thanks Mark. I've now downloaded 2.0.13 and I'll see if the
problem is still there. Meanwhile I've used a workaround involving
two connections, one to each database, so the insert works.
Not ideal, though.
--Alan
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent
for download. Should this be updated?
--Alan
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 6:44 PM
To: Alan Jones; [EMAIL PROTECTED]
Subject: Re: Problem with JDBC2 driver across databases
First, I would recommend upgrading to the latest
();
}
An SQLException is reported saying that table sales_demo.contacts does not
exist. It should
be inserting into table sales.contacts.
--Alan
Alan Jones, Senior Software Engineer
Yospace: Creating Value for Wireless
7
everyone at MySQL simply forgotten?
Any answers would be appreciated.
Thanks.
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I'm developing in asp and connect to databases using something like this:
(using ODBC)
set db = Create.ServerObject(ADODB.Connection)
db.open databaseName;
This works fine and I can get and insert data with no trouble. However,
when I do:
db.close
set db=nothing
Nothing happens. The
... this should be the same on the
server of our web site provider right??
Cheers
Alan Shum
Starf Ltd
PO Box 283
Orewa
Hibiscus Coast
NEW ZEALAND
Ph + 64 9 414 6172
Fax + 64 9 414 6182
Mobile 025 832 682
http://www.starf.net
CAUTION: This message may contain privilaged and confidential information
1 - 100 of 139 matches
Mail list logo