[PHP-users 29761] Re: SQL 文に日本語名

2006年 7月 13日 (木) 17:04:27 JST

$B%3!<%I$rA4It=q$-$^9ドル$H!"(B
<?php
$conn = mssql_connect("PRIUS\SQLEXPRESS", "usr", "");
mssql_select_db('main', $conn);
$sql="SELECT barcode FROM dbo.arrival WHERE id=1;";
$res=mssql_query($sql,$conn);
print($res);
?>
$B$r<B9T9ドル$k$H!"(B
Resource id #3
$B$HI=<(5ドル$l!"@.8y7ドル$F$$$^9ドル!#3ドル$l$OLdBj$"$j$^$;$s!#(B
$B7ドル$+7ドル!"F|K8円lL>$r;H$C$F(B
$sql="SELECT '$B:G=*@.LsHV9f(B' FROM 'dbo.$B%7%9%F%`Dj?t%F!<%V(B
$B%k(B' WHERE '$BIJL\C4Ev2]?t(B'=3;";
$B$H9ドル$k$H!"0J2<$N%(%i!<,ドルI=<(5ドル$l$^9ドル!#(B
'$B$H(B"$B$r5U$K7ドル$F$bF1MM$K%(%i!<$K$J$j$^9ドル!#(B
$BLdBj$O!V(Bphp$B$G$O(BSQL$BJ8$KF|K8円lL>$r;H$($k$+$I$&$+!W$G9ドル!#(B
Access2000$B$G$OLdBj$J$/;H$($k$N$G9ドル,ドル!#(B
Warning: mssql_query() [function.mssql-query]: message:
'.' 
$BIU6a$KITE, @ Z$J9=J8,ドル$"$j$^9ドル!#(B (severity 15) in ...
Warning: mssql_query() [function.mssql-query]: message: 
$BJ8;zNs(B '$B%N%O%U%o%F%(%Jv2%s%=!&(B=1;' $B$N8e$G0zMQId,ドルJD8ドル$F(B
$B$$$^$;$s!#(B (severity 15) in ...
Warning: mssql_query() [function.mssql-query]: Query
failed in ...