RE: [PEAR] Re: PEAR::DB and autoPrepare with dates (Oracle)

Yeah, the double equal was a typo as I transposed my code into the email. I tried quoting and not quoting the date string, and got the same result. Any suggestions? Thanks Shawn -----Original Message----- From: Justin Patrin [mailto:papercrane@reversefold.com] Sent: Tuesday, February 24, 2004 1:11 PM To: pear-general@lists.php.net Subject: [PEAR] Re: PEAR::DB and autoPrepare with dates (Oracle) Shawn Coomey wrote: > Hi folks- > I am trying to perform an autoPrepare() update on a date column in Oracle 9i. > Seems to be giving me some trouble with the date formatting. Here; an example > of what I am trying to do: > > <?php > > $start = = "TO_DATE(" . date("m/d/Y g:i A", strtotime($start_time)) . > ", > 'MM/DD/YYYY HH:MI AM')"; > $end = = "TO_DATE(" . date("m/d/Y g:i A", strtotime($end_time)) .. > ", > 'MM/DD/YYYY HH:MI AM')"; > > $table_fields = array('event_start', 'event_end'); > $table_values = array($start', $end'); > $table_name = 'calendar_events'; > > $sth = $dbh->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_UPDATE, > 'event_id = ' . $event_id'); > $dbh->execute($sth, $table_values); > > ?> > > But this throws the following Oracle error: > [nativecode=ORA-01858: a non-numeric character was found where a numeric was > expected] > > How do I format the date for autoPrepare to work? > > > TIA- > > Shawn Looks like you're not quoting your date string (also you had two = signs when setting $start and $end): $start = "TO_DATE('" . date("m/d/Y g:i A", strtotime($start_time)) "', 'MM/DD/YYYY HH:MI AM')"; -- paperCrane <Justin Patrin> -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php