Thanks, this helped so far!


"Delphi-PHP Forums" <405hp.3u9i0z@no-mx.delphi-php.net> wrote in message
news:130959@forums.codegear.com...
>> Also there is an issue saving the data: sometimes it works, mostly not,
> John - are you using table/query components or direct mysql access for
> the postings? With direct you can just trap the result failures and look
> up what the error is.
>
> PHP code:
> --------------------
>
> function sqlErrors($query)
> {
> //debug log
> $regdate=date('Y/m/d H:i:s');
> $message = $regdate.' <b>'.$_SERVER['PHP_SELF'].' - Invalid query:
> '.mysql_errno().'</b><br>' . mysql_error() ." ip
> ".$_SERVER["REMOTE_ADDR"]. '<br><br>';
> $message .= '<b>Whole query:</b><br>' . $query
> .'<br>'.json_encode($_REQUEST).'<br>______________ _____________________<br>';
> $file="errors.html";
> $handle = fopen($file, "a");
> fwrite($handle, $message);
> fclose($handle);
> }
> $result=mysql_query($sql);
> if (!$result) sqlErrors($sql);
>
> --------------------
>
>
> I've never tried this but, you may be able to check the errors in adodb
> with just adding mysql_errno().'</b><br>' . mysql_error() to a test
> label value to see if anything is happening that you can check.
>
> from the docs 'MySQL :: MySQL 5.1 Reference Manual :: 10.3 Date and
> Time Types'
> (http://dev.mysql.com/doc/refman/5.1/...ime-types.html)
>> Although MySQL tries to interpret values in several formats, dates
>> always must be given in year-month-day order (for example, '98-09-04'),
>> rather than in the month-day-year or day-month-year orders commonly used
>> elsewhere (for example, '09-04-98', '04-09-98').
>
>
> Steve - I've not had any problem with viewing ajax responses with
> firebug, from old versions to new ones they are always visible in the
> console. A quick look there has always told me if I had a problem.
>
>
> --
> 405hp
> ------------------------------------------------------------------------
> 405hp's Profile: 1089
> View this thread: Datetime fields return value in different format?