i have try it .but server error also?
i have cut the select out .left this: my system is :winnt+sql+perl5.6.0+apache1.3.12
#!perl5.6.0.exe
print "Content-type:text/html\n\n";
$table="table1";
use DBI ;
$DSN = 'driver={SQL Server};Server=172.16.166.49;database=myweb;uid=sa;pwd=sa;';
$dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";
$ki="UPDATE table1 SET name= 'ok5' where id=4 "
$st=$dbh->prepare($ki)or die"cannot update";
$st->execute;
$dbh->disconnect;
Server Error too,
-----------------------------------------------------
�� 00-11-23 ���� 08:33:00 �����
>I think the right thing would be:
>
>> $ki="UPDATE table1 SET name= 'ok5' where id=4 "
>> $st=$dbh->prepare($ki);
>
>$st -> execute;
>$st->finish;
>
>$sth->finish;
>$dbh->disconnect;
>
>
>
>Regards, Gerhard
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
��
��
lyf
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
