Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Ignatius Reilly
no quarrel with this behaviour. Ignatius _ - Original Message - From: Peter Beckman [EMAIL PROTECTED] To: Ignatius Reilly [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:13 PM Subject: Re: [PHP-DB] MySQL, PHP or ghost? On Wed, 27 Aug 2003

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió: Hmmm... You have a point; the doc is not quite clear. Illegal YEAR values are converted to My understanding is that any illegal value will be first converted into '', then into the corresponding year inside the 1901-2155

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Ignatius Reilly
, August 28, 2003 2:36 PM Subject: Re: [PHP-DB] MySQL, PHP or ghost? El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió: Hmmm... You have a point; the doc is not quite clear. Illegal YEAR values are converted to My understanding is that any illegal value will be first converted

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió: Well, it IS logical provided one is aware of the rules of the game, meaning, as you rightly point out, that MySQL does not reject SQL statements for incorrect values, but attempts at converting them at any price. I have no clue whether it is

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Ignatius Reilly
28, 2003 9:37 PM Subject: Re: [PHP-DB] MySQL, PHP or ghost? El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió: Well, it IS logical provided one is aware of the rules of the game, meaning, as you rightly point out, that MySQL does not reject SQL statements for incorrect values, but attempts

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-28 Thread Martin Marques
El Jue 28 Ago 2003 17:20, Ignatius Reilly escribió: Well, you're certainly right (except I didn't get the meaning of 'FS' - anything obscene?). However: File System. 1. The job of this ML is to help people get things done 2. For criticisms concerning the design of MySQL, you may get better

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Ignatius Reilly
Read the MySQL manual. 0 value is interpreted as 2000. Your empty string is converted to an integer, thus 0. HTH Ignatius _ - Original Message - From: Peter Beckman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 3:39 AM Subject: [PHP-DB]

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread David T-G
Peter -- ...and then Peter Beckman said... % % Seems that either I don't understand mysql, or something. Looks like it, though I admit that the manual doesn't adequately explain your results. Check out section 6.2.2.4 for details. % % My table, with the non-important things removed... ... %

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Peter Beckman
On Wed, 27 Aug 2003, Ignatius Reilly wrote: Read the MySQL manual. Hmmm, I thought I did. 6.2.2.4: Illegal YEAR values are converted to . 0 value is interpreted as 2000. Your empty string is converted to an integer, thus 0. What confuses me (what I can't find) is why a quoted empty

RE: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Griffiths, Daniel
its nothing to do with php as your working from the shell in your eg. mysql will default to 2000 for a year value if you pass it as an entry because it will accept short values for the years this century, eg pass it 1 and it'll give you 2001, so it thinks is nothing. if you want to default to

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Peter Beckman
On Wed, 27 Aug 2003, David T-G wrote: Looks like it, though I admit that the manual doesn't adequately explain your results. Check out section 6.2.2.4 for details. I did; see my previous (moments ago) email on my read on that manual section. % So my assumption is that if I insert with

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread David T-G
Peter, et al -- ...and then Peter Beckman said... % % On Wed, 27 Aug 2003, David T-G wrote: % % Looks like it, though I admit that the manual doesn't adequately explain % your results. Check out section 6.2.2.4 for details. % % I did; see my previous (moments ago) email on my read on that

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Ruprecht Helms
Hi Peter Beckman, Seems that either I don't understand mysql, or something. My table, with the non-important things removed... mysql explain plate; +-+---+--+-+-++ | Field | Type |

RE: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Griffiths, Daniel
:[EMAIL PROTECTED] Sent: 27 August 2003 15:29 To: Griffiths, Daniel Subject: RE: [PHP-DB] MySQL, PHP or ghost? On Wed, 27 Aug 2003, Griffiths, Daniel wrote: mysql will default to 2000 for a year value if you pass it as an entry because it will accept short values for the years this century, eg

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Peter Beckman
On Wed, 27 Aug 2003, Ruprecht Helms wrote: you have chosen a wrong format. The format for year is . With string the field years don't know what to do. Right -- and if it doesn't know what to do, why would it insert a value that isn't correct and not give me an error? It does give a

RE: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread Hutchins, Richard
- From: Ignatius Reilly [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 9:31 AM To: Peter Beckman; [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL, PHP or ghost? Read the MySQL manual. 0 value is interpreted as 2000. Your empty string is converted to an integer, thus 0. HTH