larly by one particular
user.
Can anyone tell me what this means or direct me to the appropriate
documentation. I searched it on the mysql.com site and came up with
nothing.
TIA
Filter:mysql
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializi
I think the pertinent question is how to reliably get the client's time
zone? I think you need a javascript to use the browser controls to check
the timezone setting on the local computer and add it to a form on the
page. Web page issue more than a DB issue.
Andrew Hazen
www.jatech.ca
[
query.
mysql
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
to put the query in a for_next loop and let the webserver churn
away on it?
Thanks.
Andrew Hazen, O.C.P. Jatech Solutions Inc.
E-Commerce Developer www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
[EMAIL PROTECTED]
[EMAIL PROTECTED
Both of the connections shown below are for the same database server.
If both dbs are on the same server you only need one connection, but
then you need to use mysql_select_db($database_name,$link1) for each
database.
Andrew Hazen
-Original Message-
From: Fred Kamwaza [mailto:[EMAIL
Would have been a little spooky if were '42'! :)
Andrew Hazen
-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 11:51 AM
To: 'Arthur Fuller'; mysql mailing list
Subject: RE: Maximum JOINED tables
32.
-Origin
Hi,
Is there a way to designate which folder on the server the OUTFILE ends
up in? Will it accept a full path in the file name?
Mysql;mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming
indexing is preserved.
Andrew Hazen
-Original Message-
From: Ben Holness [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 26, 2002 3:48 PM
To: [EMAIL PROTECTED]
Subject: Indexing Question
Hi all,
I have developed a system that lets people send messages to each other,
with
a MySQL database
Hi Folks,
Can I do the following:
LOAD DATA INFILE 'persondata.txt'
INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...);
Mysql the spam filter.
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and
checked individually, and how busy you expect the system to be overall.
Andrew Hazen
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 8:17 PM
To: [EMAIL PROTECTED]
Subject: RE: data compare and duplicate entries..
IMHO it is an expensive to
uot;, and get it all done at
once, right?
Andrew Hazen
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:47 AM
To: 'Andrew Hazen'; [EMAIL PROTECTED]
Subject: RE: [thelist] MySQL to Excel Problem Pivot Table SOLVED!
[snip]
Fascinat
ot;;
Reset form
Andrew Hazen
-Original Message-
From: Tech @NorthWeb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 9:32 AM
To: mysql
Subject: Fw: data compare and duplicate entries..
hi,
I was looking for an SQL statement or script that whould allow me to
compare
data w
Fascinating. But how do you build the SELECT? Seems to me you would
first have to "SELECT RecordID FROM tblClass10" and then script an
iteration to build the whole series of IF clauses. Or did I miss
something?
Andrew Hazen
-Original Message-
From: Gabriel [mailto:[EMAIL
Now here's a bit of an oddball question:
I am building a php/mysql web app that will be linking with an
accounting system in PervasiveSQL. Right now the various pieces of the
web app are built in mySQL.
Is there a way to do JOINS between tables in the two different
databases?
Andrew
I would be interested in this too. With a corollary: does anyone know of
a small script other than java applets that would effectively place a
freehand drawtool on the webpage, and capture the resulting image for
insertion as a db blob?
Andrew Hazen
-Original Message-
From: Zill-e
have the headache of
synchronization with Pervasive(any good docs on that would be
appreciated!)
OR
b) build the app with Pervasive and have the security issues of
a web app directly accessing the internal db
Any advice greatly appreciated!
Andrew Hazen, O.C.P.
E-Commerce Deve
Hi,
Does it make sense to use temporary tables as a substitute for Views?
Where do I look in the docs for info?
Thanks.
Mysql.
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming
Well go figure. Seems like our firewall is blocking things. Guess I'll
have to run local for development.
Thanks for your help.
Andrew Hazen
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 3:12 PM
To: [EMAIL PROTECTED]
Su
ccess from a phpMyAdmin on one webserver to a db on the other webserver
fine. But when I try to access with ODBC, using the same
username/password it's no go.
mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE appli
Good point. Also, how would you capture the current enum list to add or
substract from? Might have to hold that in an array or constant of some
sort depending upon the language used.
Andrew Hazen
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April
h the enum column to change the list of accepted
values for the enum.
Would this work Gurhan, or would the constant ALTER table commands mess
things up?
Andrew Hazen
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:46 PM
To: Andrew Hazen;
Gurhan,
I think Simon was looking for a way to make the enum dynamic from
another table. ??
Andrew Hazen
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 10:22 AM
To: Simon Tienery; [EMAIL PROTECTED]
Subject: RE: LOOKUP
Hi ..
You
Hi,
I'm trying to use the old MS Visio Modeler with mysql. I have
downloaded and installed the myODBC driver and set up a DNS. But I keep
getting this connection error:
"Can't connect to MySQL server on 'www.jsicorp.com'(10060)"
I set the username and password the same as what works with phpMy
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
spam filter: mysql
Andrew Hazen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
plogin field is
SOMETIMES blank where is should be "Robyn".
I'm perplexed.
Andrew Hazen
Database Developer
Jatech Solutions Inc.
160 Bartley Drive
Toronto, ON
M4A 1E1
www.jatech.ca
416-288-9833
-
Before postin
If you are looking for a web version, the best is phpMyAdmin which
allows you to do just about everything you need to manage any number of
mysql dbs.
Andrew Hazen
-Original Message-
From: Vu, Steve [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:54 PM
To: [EMAIL PROTECTED
you have suggested, but in multiple runs using LIMIT, or by
specifying incrementing ranges of the primary key for each table, so
that you don't blow out your RAM. Takes longer, but shouldn't crash your
server.
Andrew Hazen
-Original Message-
From: Ulrik Witschass [mailto:[EMAIL
Hi, if you think that IIS and Apache are going to have problems
co-habitating then, yes, please tell me which services to kill. On the
other hand, I'm not using IIS for anything else, maybe I should try to
uninstall it before installing Apache???
Thanks.
Andrew Hazen
Spam filter:
rking with? Or are they happy running side by side
on the same box?)
Any advice, or links to useful docs would be appreciated.
Andrew Hazen
Database Developer
Jatech Solutions Inc.
160 Bartley Drive
Toronto, ON
M4A 1E1
www.jatech.ca
416-288
the Access data as comma delimited files and import
them into mysql. If you want to do this on a regular basis you could
set a schedule(either human or with crontab) to periodically export the
Access contents and reload the mysql tables.
Andrew Hazen
-Original Message-
From: Mark Stringh
Yeah,
I've abandoned the nice neat insert . . . select.
Instead I am selecting the table B dataset, inserting each row into
table A, capturing the insert id, populating the x-ref, and going on to
the next row. Twice as much code, but it works.
Andrew Hazen
-Original Message-
From:
.
Is there anyway to do this in mysql/php?
Spamfilter: mysql
Andrew Hazen
Database Developer
Jatech Solutions Inc.
160 Bartley Drive
Toronto, ON
M4A 1E1
www.jatech.ca
416-288-9833
-
Before posting, please check:
http
tables into
a comma separated values fixed width text file.
Can I just write the mysql commands as a .sql file and tell Unix to
execute it? Or is there another way?
Andrew Hazen
Database Developer
Jatech Solutions Inc.
160 Bartley Drive
Toronto, ON
M4A 1E1
www.jatech.ca
416-288-9833
33 matches
Mail list logo