MSsql query Error
Posted: Sun Jun 19, 2005 10:00 pm
When executing the MSSql query below, it spits an error saying
Can anyone tell me what's wrong? Thank you.
Here's the queryAn explicit value for the identity column in table 'tblosfdtl' can only be specified when a column list is used and IDENTITY_INSERT is ON
Code: Select all
// assuming that all variables have values
$query = "INSERT INTO tblosfdtl VALUES (
$available_id,".$this->so_no.",$itemcode,$formatid,$qty,$sel_price,
$discount,$amount,0,'".date("m/d/Y")."','')";