Meaning of error codes

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 Specializing

RE: timestamps and time zones

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 [EMAIL

multiple unique updates

query. mysql Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming.

multiple incremental inserts

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

RE: How do I connect to two databases at the same time

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

OUTFILE

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

RE: Maximum JOINED tables

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. -Original Message- From

RE: Indexing Question

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

Load Infile to more than one table

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 PHP/MySQL

RE: data compare and duplicate entries..

to be 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

RE: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

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 PROTECTED

RE: data compare and duplicate entries..

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 when it was entered

RE: [thelist] MySQL to Excel Problem Pivot Table SOLVED!

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] Fascinating. But how do you build

mySQL PervasiveSQL

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 Hazen

MySQL PervasiveSQL

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 Developer

RE: Blobs+ASP+MySQL

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

temporary tables

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

MyODBC arrrgghh!

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 applications and PHP

RE: MyODBC arrrgghh!

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] Subject

RE: LOOKUP

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

RE: LOOKUP

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; 'Simon Tienery'; [EMAIL

RE: LOOKUP

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

myODBC

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

MD5

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

Not null not working??

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 posting, please check: http://www.mysql.com/manual.php (the manual

RE: mysql schema manager

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

RE: Adding a Column to an existing table

as 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 PROTECTED

mysql/php on Win2000

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-9833

RE: mysql/php on Win2000

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: mysql

RE: MySQL, MyODBC and MS 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 Stringham [mailto

x-ref insert from within an insert. . .select

. 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

RE: x-ref insert from within an insert. . .select

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: Paul

automating mysql command

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