claudeless
|
| Posted: 06/07/2005, 7:43 AM |
|
I am Looking to Post this information into a table after an update...
This is the Code that I am usings...
But getting this Error...
What Am I missing in my Statement Here
Thanks
global $assets;
// Write your own code here.
$assets = new clsDBMaint();
$SQL = "INSERT INTO assetshistory (MIDID, AssetID, CurrentVersion, Quote, VOID, Notes ) VALUES ( "
. $assets -> ds -> ToSQL ($assets MasterCusID -> GetDBValue(), $assets -> MasterCusID -> DataType) . ", "
. $assets -> ds -> ToSQL ($assets AssetID -> GetDBValue(), $assets -> AssetID -> DataType) . ", "
. $assets -> ds -> ToSQL ($assets CurrentVersion -> GetDBValue(), $assets -> CurrentVersion -> DataType) . ", "
. $assets -> ds -> ToSQL ($assets QuoteAsset -> GetDBValue(), $assets -> QuoteAsset -> DataType) . ", "
. $assets -> ds -> ToSQL ($assets VOIDED -> GetDBValue(), $assets -> VOIDED -> DataType) . ", "
. $assets -> ds -> ToSQL ($assets Notes -> GetDBValue(), $assets -> Notes -> DataType) . ") " ;
$assets -> query($SQL) ;
$assets -> close() ;
|
|
|
 |
|
