 |
|
มันขึ้นerrorคะ แต่หาสาเหตุไม่เจอ
ใช้ access เป็นดาต้าเบสคะ
Code (PHP)
$objConnect = odbc_connect("mydatabase","","") or die("Error Connect to Database");
$strSQL = "SELECT Max(Time) as LastestTime FROM Thermal ";
$objExec = odbc_exec($conn, $strSQL) or die ("Error Execute [".$strSQL."]");
while(odbc_fetch_row($objExec))
{
$LastRecord = odbc_result($objExec,"LastestTime") ;
$nextRecord = xxx.txt ;
if(file_exists($nextRecord )){
$Data=" ";
$Data= ReadData(x,xx) ;
}
function ReadData(x,xx){....};
$strSQL2 = "INSERT into Thermal ";
$strSQL2 .="(Time,a,b,c,d,e,f) ";
$strSQL2 .= " values('$Data[0]','$Data[1]','$Data[2]','$Data[3]','$Data[4]','$Data[5]','$Data[6]')";
$objExec2 = odbc_exec($conn, $strSQL2) or die ("Error Execute [".$strSQL2."]");
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000?P in SQLExecDirect in xxx
Error Execute [INSERT into Thermal (Time,a,b,c,d,e,f) values('2010-04-10 12:00','15.19','14.81','15.19','13.70','15.19','15.56')
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
2010-06-09 17:14:11 |
By :
S-t-A-r |
View :
1453 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
