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
