RE: Asking again... please help me!!!

2003-12-10 Thread Jan Magnusson
You really need to look at your DW installation/user manual/tutorial: how to set up a site within DW and how to configure a db resource. The mySQL part as such seems to work ok, but I doubt there are any db connections defined yet (ODBC or JDBC). If this is new stuff to you take the ODBC route, it'

RE: Licence question

2003-12-04 Thread Jan Magnusson
Hi Stéphane, I share the comments already expressed by Roger. But would like to add the following: - If you represent company 2 you will not have to purchase the client licenses. - It seems to me it is the sole responsibility of company 1 to secure the legality and the compliance to the GPL lice

RE: "not null" and default values confusion

2003-11-01 Thread Jan Magnusson
o:[EMAIL PROTECTED] > Sent: Saturday, November 01, 2003 05:13 > To: Jan Magnusson > Cc: Mysql General mailing list > Subject: Re: "not null" and default values confusion > > > Jan, > > This question comes up a lot. You should take a look at > <http://www.m

"not null" and default values confusion

2003-10-31 Thread Jan Magnusson
Dear List, Could sombody explain this behaviour of mySQL 4 to me: Assigning a column as "not null" will AUTOMATICALLY assign (=force upon) it a default value of an empty string ('') if a string or zero (0) if a numerical datatype. Thereby effectively bypassing all and every error message during

RE: Several tables or huge single table?

2003-10-29 Thread Jan Magnusson
Hi Wolfgang, I'd say it somewhat depends on what data you have and what you really are going to use the records for. If you never need to retrieve data for more than one product at a time and there are significant differences in the data set between the products then maybe you might split it. Othe

RE: making specific query for big data

2003-10-23 Thread Jan Magnusson
I think he is looking for a way to just retrieve some data prior to a specific (although dynamic) point of the full data saved in a longtext datatype column. Like retrieving just the header of email messages saved with attachments etc in a longtext column. Perhaps having that header data saved in