and comma as decimal separator).
HTH HAND
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFBPPGHGb7uCXufRwARAllpAKCzmDQpbLcVa5q9MvXlo8ZxkHjM1wCfQGAb
wind down.
TIA HAND
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFBNFRwGb7uCXufRwARAsqrAKCfPPhC56rMGoza4dsz1rB4xN4IUgCeNRBC
0frePa4NG3sEv57ysVDsfAo=
=tHet
structure. Good enough...
%
% With regards,
%
% Martijn Tonies
Thanks HAND Still listening...
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD
HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg
and then give the user permissions on
it (thereby creating the user record).
%
% Any help would be appreciated.
%
% Thanks,
% BGLefty
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work
denied for user: '[EMAIL PROTECTED]' (Using password: YES)
and, similarly, the web script cannot get in. Yet when I select the user
record from mysql.user and mysql.db they appear complete.
What glaringly obvious omission have I failed to see?
TIA HAND
:-D
--
David T-G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again, all --
...and then David T-G said...
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program.
...
Sorry for the duplicate post; I only realized
a password
properly asks me for one (so I'm not showing it on the command line to
anyone with ps tools :-)
%
% /OFF TOPIC
Thanks HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G [EMAIL PROTECTED] wrote:
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program
HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg
for each database .
% is it possible to copy the particular folder(database) to 3.23.58 and then running
it smoothly ...
Probably. Back up your .58 system, try it, and see!
%
% Any body got any idea ???
%
% Please help me out..
%
% Thanks in advance
%
% Binay
HTH HAND
:-D
- --
David T-G
, there is, indeed. CF normalization :-)
HTH HAND good luck Paul
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
. Is there any way to do
What about, on machine two,
mysqldump -hmachine1 -uuser -ppassword --opt --all-databases backup
or so?
% this besides using ftp.
Definitely. There's scp, for instance ;-)
%
% Any help would be appreicated.
%
% Richard
HTH HAND
:-D
- --
David T-G
in the script file for all to see,
how do you keep all from seeing them? And those of you who don't, what
are you doing to stay secure? And those of you who have a different
approach, what is it?
TIA HAND
:-D
- --
David T-G * There is too much animal courage in
(play
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mike --
...and then Michael Stassen said...
%
% Mikael Fridh wrote:
[And thank you to Mikael, too.]
%
% On Wednesday 12 November 2003 17.15, David T-G wrote:
%
% What if one user connects to the database as different users (as I do
. Read this once at
% least.
Agreed. It has everything you need.
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
password?
Why not instead save the encrypted password and then when checking always
encrypt what you're given and compare it? Not only is it more secure,
it's easier :-)
%
% thanks,
Sure thing.
%
% Luis R. Lebron
% Sigmatech, Inc
HTH HAND
:-D
- --
David T-G
% corrupt the database files?
Very probably.
%
% Thanks,
Sure thing!
%
%
% Keith
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy
to speak :-) Could you afford a little bit of
extra load time at startup to have your un-split, all-RAM, fast table?
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
with disk RAID; they are completely
separate.
%
% Thanks,
%
% Steve
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
tables for myself and everyone said
% you need the raid option in MySQL. Now I'm not sure!
That's probably because ext3 and reiser and xfs weren't around :-)
%
% Thanks,
%
% Steve
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED
() but
perhaps you don't even need that temp table...
%
% Thanks.
Good luck! let us know how you end up doing it.
%
% -Doug
HTH HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug, et al --
...and then David T-G said...
%
% ...and then Comcast said...
% %
% % I would like to ORDER BY RANDOM - is there an easy way to do that.
%
...
% I don't know if you can select random() like you can select count() but
% perhaps you
for the docs with a docid, one table
for all of the words with a wordid, and one table to tie them together
containing the docid and the wordid. Duplicate words only require one
row in the word table and would have required separate docid entries
anyway, so you save.
HTH HAND
:-D
- --
David T-G
is what put me onto the
idea of storing the order in a single spot in the first place. But it
seems so much cleaner :-) The only problem is [efficiently] getting the
data back out when I want to display it...
%
% I hope that helps,
It does; thanks!
% Andy
HAND
:-D
- --
David T-G
in
% the question table.
Excellent; great to know. Thanks!
%
% Best regard,
% Andy.
Thanks HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science
of another field (but not simply sorting on that field)?
TIA HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
be a dependent leaf or just pull down
your own mail and news to have it locally (web sites aren't typically
meant to be mirrored by the anonymous visitor).
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral
[database]
to not expose the password on the command line. That, in fact, seems to
be what Eldon was doing, as I read his original email, so there may be a
problem that we don't yet see.
So the reply simply becomes give us more detail and actual examples.
HTH HAND
mysql query,
:-D
- --
David T
to my question
in the thread problems with GRANT, user, databases.
%
% Thanx
% -- Mitko
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP
to the filtering concept mentioned a while
ago. Have they been implemented yet?
2) Why not just have all posts from non-subscribed users either moderated
or handshaken via tmda or the like?
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL
on -- and then it should probably send the email to the user, too!
%
% Any ideas would be greatly appreciated.
HTH HAND
%
% - Sheryl
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work
grant privs, but it didn't work anyway!
I give up. Hlp! :-)
TIA HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science
and Stefan's messages mentioning
it.
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg
a
question... Does the ODBC back end read the Access DB file, and if so
what sorts of back ends are out there for Linux and FreeBSD?
% Hth,
% Arthur
Thanks a *bunch* HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society
of which can make it onto my list today).
Does mysql have a formatting option (other than -H, since HTML is the
last thing I want) to allow me to define the output, perhaps in a manner
similar to a printf string?
TIA HAND
mysql query,
:-D
- --
David T-G * There is too much
:-)
Thanks a bunch for the clarification!
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg
.
I *promise* I looked in the reference manual; CONCAT does not appear in
the TOC at all, and there is no how do I glue these fields together
example listed in the 3.5 examples.
%
% Duncan
Thanks again HAND
mysql query,
:-D
- --
David T-G * There is too much animal
make little
optimizations, to avoid such problems, or is any OPTIMIZE a game
of roulette and so one should do it only when absolutely needed?
3) What does one do if one has a fragmented table and yet cannot
optimize it because of said problems?
TIA HAND
mysql query,
:-D
- --
David T
. What platform are you using?
%
%
% Thank you
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
converter -- also quite possibly because MS hasn't released the file
spec and nobody has reverse-engineered it :-)
I did a quick CPAN search and found DBIx::Record::Format::ODBC::MSAccess
which looks somewhat hopeful; you might dig into that a bit.
HTH HAND
mysql query,
:-D
- --
David T-G
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE
-- but without
having to have MS Access. That would be my desire if I ever had to touch
an MS Access file, since I don't have Access almost don't run Windows at
all.
Did I misunderstand anyone?
HTH TIA HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage
for any suggestion on this.
Since you're just holding data and not, as far as I can tell, doing lots
of transactions, an ordinary myisam table is probably quite sufficient.
%
% anupam.
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage
to the robot to turn off autoreplies to
one's address...
%
% Sherzod
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
it is
because it doesn't really matter (and geeks such as I can make anything
funny) or change from 'sex' to 'gender' to make the subject unambiguously
a noun.
HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society
.
%
% I have previously used a company in India and I am not averse to trying this
% again.
%
% Suggestions anybody...
HTH HAND
%
% Thanks to all.
%
% Richard
%
% SQL
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED
these steps, start with the apache docs and try to
get something simple like a static html page or an image to come up.
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work
any
other machine that has cron or task scheduler or whatnot.
Meanwhile, start shopping around for other hosts that let you use cron :-)
%
% Any help is appreciated.
%
% thanks
HTH HAND
%
% MS
mysql query,
:-D
- --
David T-G * There is too much animal courage
that they won't let me run a task from the server.
% What about running a script from an exe ?
What script, what exe, and what machine?
%
% thanks
Sure thing!
%
% MS
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society
not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)?
Nope.
%
% Thank you,
% Vicente
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN
T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE
it :-)
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% Hi, David
Hi!
%
% On Tue, 21 Jan 2003, David T-G wrote:
%
% % Are you sure that smallint is enough for your index? Do you really need to
%
% I've thought about that a bit, but don't know
SuSE a try.
%
% Your comments are really appreciated.
%
% Thank you,
%
% JFernando
% * sql *
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria, et al --
...and then Victoria Reznichenko said...
%
% On Monday 20 January 2003 16:16, David T-G wrote:
% create table pieces
%(
...
% words text (4095) ,
% fulltext index (words(4095))
%) ;
%
% David, words text (4095
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% On Mon, 20 Jan 2003, David T-G wrote:
%
...
%create table pieces
%(
% # ID number
% id smallint unsigned not null default 0 auto_increment primary key ,
% title char(50
an
UnSubscribe Support Services Contract.
%
% Sam
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg
to name a few of the *many* possibilities and
permutations thereof.
% Any comments are welcome. Thanks a lot.
%
% --
%
% Clemente Zamora
% GlobalReservas
% (http://www.clementezamora.com)
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage
-- and vice versa.
%
% thxs.
HTH HAND
%
% Alex.
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
for a complete disaster on my
machine?
and go from there; if any of the answers don't sound right, then ask more
questions about that topic.
% Any opinions on either?
I have the best quality/price ratio, of course. [Oops; I did it again.]
% Thanks.
HTH HAND
mysql query,
:-D
- --
David T-G
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP
some features here and there in the MySQL world
as well as for much other software.
I think that Microsoft starts selling their products at about the 'beta'
stage, and 'gamma' is called buy the next beta ;-)
%
% Thanks,
% Elby.
HTH HAND
mysql query,
:-D
- --
David T-G
qsecretary is better than this mysql query thing!
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg
in a grey area of this sort -- in this
situation, for example? ;-)
TIA HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science
tables.
Oh, I agree :-)
%
% YMMV, HTH,
% =C=
Thanks HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
like that. I'm sure there's not a lot of posts that
% mention grapes and wines on the list.
Yeah :-)
Thanks! to all HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
figured it out yet. Pointers
to favorite tutorials are appreciated, but I'm trying not to flat-out ask
the list to explain it to me (though that's fine with me at this point,
too).
%
% =C=
Thanks again HAND
mysql query,
:-D
- --
David T-G * There is too much animal
detail now that I have an example against it, and then I have
to figure out how to read that to learn a bit about how it works -- but
I'm very grateful!
%
% =C=
%
% *
% * Cal Evans
% * Stay plugged into your audience.
% * http://www.christianperformer.com
Thanks HAND
:-D
- --
David T-G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Zak George --
...and then Zak Greant said...
%
% On Fri, Jan 10, 2003 at 11:50:28PM -0500, David T-G wrote:
%
% ...and then Gman said...
% %
% % How can I delete a database in MySQL so I recreate it?
%
%echo 'drop database dbname
for that user. More in the manual :-)
%
% George Flatman
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science
have the
time for all of that other stuff, even if I do run off at the mouth
mysqlf (hey, that typo is good enough to leave in here :-) sometimes.
%
% Larry S. Brown
% Dimension Networks, Inc.
% (727) 723-8388
mysql query,
:-D
- --
David T-G * There is too much animal
, it may be better for you to credit back the hours because you can
then count up what you've given away.
%
% Many thanks,
HTH HAND
%
% Jeff Snoxell
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society
engine and how to get data in and out quickly; backup
is an entirely separate issue. Yes, it's important, but it's very much a
different animal -- and so it shouldn't be part of the same package.
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage
FAQ, so I've
copied the mysql-faq list on this reply.
Thanks HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
be happy to build the software, if that helps.
We'd love to have you :-)
%
% Let me know
%
% Peter
Thanks HAND HNY
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
PROTECTED]
Thanks for the pointer!
%
% Bruce
Thanks HAND HNY
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
off and your finger on the trigger. Don't
stumble :-)
%
% TKS
% Rick
HTH HAND Happy New Year
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary
:-)
%
% Regards,
% --
% Stefan Hinz [EMAIL PROTECTED]
Thanks HAND HNY
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
HNY
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg
a lovely
++-+
| substring(s.timeslot,1,13) | concat(c.fname,' ',c.lname) |
++-+
| 2002-12-27 06 | david t-g |
| 2002-12-27 07 | david
back to an unique index, you mean, perhaps?
%
% Hope this helps
It's a start; thanks a bunch!
HAND HNY
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED
I have a single record for
each which lists the client(s)?
Thanks again HAND HNY
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy
in a text field and then parse my way across that field, or can the DB do
it?
%
% Any way
% You may have to re-think parts of your database structure. A good book on
% ERD diagrams might help.
Indeed.
%
% Best of luck.
Thanks again HNY
:-D
- --
David T-G
://iConnect.de
% Heesestr. 6, 12169 Berlin (Germany)
% Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
HTH HAND Happy Holidays
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work
,
%
% Benjamin.
%
% --
% [EMAIL PROTECTED]
Thanks again HAND HH
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
about the non-abbriviation in your first mail
% already. ;-)
*grin* I figure the first one in the thread will define it for later
since it's not too standard... :-)
%
% HTH,
%
% Benjamin.
%
%
% --
% [EMAIL PROTECTED]
Thanks again HAND HH
mysql query,
:-D
- --
David T-G
.
TIA HAND Happy New Year
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
...and then David T-G said...
%
% I'm so far about knee-deep in my project where I'll be using php to talk
% to the mysql database and spit out my web pages. I wonder if I should be
% making individual calls to the database or loading
.
HAND Happy New Year
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/ Shpx gur
in one script, all my
% create scripts in another, and all my populate scripts in yet another.
Yeah, I think I'll do something like that.
%
% Arthur
Thanks HAND Happy Holidays
mysql query,
:-D
--
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED
) not null
but that puked at the create stage :-)
TIA HAND Happy Holidays
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
...and then David T-G said...
%
...
% hashsum tinyblob not null , # hash of the card: have we seen this one?
% index (hashsum) # for quick lookups
...
% ERROR 1170 at line 49: BLOB column 'hash' used in key
:-)
%
% 'Preciate any aid on this.
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
.
%
%
% --
% [EMAIL PROTECTED]
Thanks HAND HH
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://www.justpickone.org/davidtg/Shpx gur
.
%
% --
% [EMAIL PROTECTED]
Thanks HAND Happy Holidays
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http
I can just take the extra
steps of detecting the database and getting rid of it as a subtask.
%
% HTH,
It does; thanks!
%
% Benjamin.
%
% --
% [EMAIL PROTECTED]
HAND Happy Holidays
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL
with the SELECT and only add CREATE TABLE / INSERT part at
% the end. And LIMIT is your friend.
OK :-)
%
% HTH,
%
% Benjamin.
%
% --
% [EMAIL PROTECTED]
Thanks HAND Happy Holidays
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society
1 - 100 of 139 matches
Mail list logo