> $ki="UPDATE table1 SET name= 'ok5' where id=4 "
!! Is there a semicolon after "where id=4 ""??
# well, i´m using Linux & mySQL,
# i don´t have any idea about using disconnect on M$-SQL
# (but it will propably work the same (??))
regards (gerhard);
--
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->c
I think the right thing would be:
> $ki="UPDATE table1 SET name= 'ok5' where id=4 "
> $st=$dbh->prepare($ki);
$st -> execute;
$st->finish;
#
# You do not need to finish the handler if you re-use it
# use $st again (makes the code more raedable)
#
> $sth= $dbh -> prepare ("SELECT id,name,phone,
i have problem with write sql
writing like this:
$ki="UPDATE table1 SET name= 'ok5' where id=4 "
$st=$dbh->prepare($ki);
$sth= $dbh -> prepare ("SELECT id,name,phone,data from $table order by id") or die
"Cannot SELECT from '$table'" ;
$sth -> execute ;
i can't update the table, alse delete
how
