one more quick question though, SQL doesn't like backslashes "\" is there a backslash stripping function in the UDFs? If so I couldn't find one on the UDF forum.
I've tried using strip($LogonServer,'\','all') but it doesn't seem to be working cuz i'm printing the var after the strip function and it still shows the full UNC pathname...
Code:
DIM $sql,$objConn
$ConnDSN = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;USER=test;PASSWORD='';OPTION=3;"
$objConn = DBConnOpen($ConnDSN)
? "Error @ERROR: @SERROR"
sleep 2
$ = 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','\')"
