Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by sbarquero ( 14 years ago )
UPDATE cajeros SET cajeros.Router = (Left([Ip],(InStrRev([IP],"."))) & (((Right([ip],Len([ip])-(InStrRev([IP],"."))))\16)*16)+14)
WHERE (((cajeros.NUOFI)<1000) AND ((Left([IP],3))="10."));
UPDATE cajeros SET cajeros.Router = (Left([Ip],(InStrRev([IP],"."))) & "254")
WHERE (((cajeros.NUOFI)<1000) AND ((Left([IP],3))="172"));
Revise this Paste