RE: [PHP-WIN] Problem with Insert with ODBC
| From: | HKG) | Date: | Mon, 30 Jun 2003 14:41:04 +0000 |
| Subject: | RE: [PHP-WIN] Problem with Insert with ODBC | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-20627@lists.php.net to get a copy of this message | ||
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:vessi@bfu.bg]
> Sent: Monday, June 30, 2003 3:19 PM
> To: php-windows@lists.php.net
> 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
>