nm, it worked like this:

Code:
DIM $sql,$objConn,$var
$ConnDSN		= "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;USER=test;PASSWORD='';OPTION=3;"
$objConn 		= DBConnOpen($ConnDSN)
? "Error @ERROR:  @SERROR"
sleep 2

$LogonServer = Strip('$LogonServer','\','all')
? $LogonServer
;$sql			= "INSERT INTO computer(name,LastLogonTime,LastLogonDate,LogonServer,Domain,CurrentIP,MACAddress,SerialNumber,OSType) VALUES('$HostName','$Time','$Date','$LogonServer','$DomainMemberOf','$CurrentIP','$MAC','','$ProdType')"
$sql			= "INSERT INTO computer(name,LastLogonTime,LastLogonDate,LogonServer) VALUES('$HostName','$Time','$Date','\')"

DBExecuteSQL($objConn,$sql)
? "Error @ERROR:  @SERROR"
sleep 5

DBConnClose($objConn)
? "Error @ERROR:  @SERROR"
sleep 5Code:


thanx for the help guys





Edited by thepip3r (2005-04-14 11:35 PM)