Try this: odbc_error Get the last error code (PHP 4 >= 4.0.5) string odbc_error ( [resource connection_id] )
"Veselina Jecheva" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > How can I do this - odbc_exec returns just false on error? > > At 16:41 6/30/03 +0200, Svensson, B.A.T. (HKG) wrote: > >You ought to test for an error in your "error detection" > >not for an return value on the execute of an SQL query. > > > >> -----Original Message----- > >> From: Veselina Jecheva [mailto:[EMAIL PROTECTED] > >> Sent: Monday, June 30, 2003 3:19 PM > >> To: [EMAIL PROTECTED] > >> Subject: [PHP-WIN] Problem with Insert with ODBC > >> > >> > >> Hello, > >> I've got the following problem: the following line prints "Error" all the > >> time: > >> > >> $link = odbc_connect("conference","",""); > >> $query="insert into participants (name, surname, family, degree, > >> work_place, speaker, listener, topic, title, > >> co_author, aspekt, comp, proektor, video, date15, date16, date17, > >> fee) > >> values ('$name', '$surname', '$family', '$degree', '$work_place', > >> '$speaker', '$listener', '$topic', '$title', > >> '$co_author', '$asp', '$computer', '$proekt', '$video', '$date15', > >> '$date16', '$date17', '$fee')"; > >> $result=odbc_exec($link,$query); > >> if ($result) echo "Thank you, your request has been processed."; > >> else echo "Error"; > >> > >> The database is created by Access, all variables are defined and have their > >> values. It seems the SQL statement is not ok. > >> Thank's in advance. > >> Veselina > >> > >> > >> -- > >> PHP Windows Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > >> > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
