melnib00ne

Hi, i have a php-page with an mysql-connection and have a problem with left and right join query. i have two tables with two selectboxes on the page. table1 (laenderliste): id,kontinent,land,hauptstadt,iso2,iso3,ioc,domain,waehrung,vorwahl 1 Asien Deutschland Berlin DE DEU GER .de EUR 49 2 Asien Afghanistan Kabul AF AFG AFG .af AFN 93 3 Nordamerika Aruba Oranjestad AW ABW ARU .aw ANG 297 table2 (regionen): id,vid,iso2 1 1 0 DE 2 2 0 DE 3 2 0 AF 4 2 1 DE 5 2 1 AF 6 3 0 DE 7 4 0 DE 8 2 2 DE 9 2 2 AF 10 5 0 DE now, i would have all countrys (land on table1) who's not in table2. the field iso2 where the key to compare the two tables. sql-query: $sql = "SELECT l.iso2, l.land FROM laenderliste l LEFT JOIN regionen r ON l.iso2 = r.iso2 WHERE r.vid <> '$vid'"; whats wrong in my sql-query ? can someone help me please ? thanks

Dear Users, anyone an good idea or solution for email encryption like pgp or else in small companys ? I prefer to take pgp 8 or later, but i dont knew what it cost for round about 10 users with certificate and so on. We have active directory 2003 and outlook 2003. Our members with notebooks works out of office with an vpn-connection to our exchange and file-servers. What must i have or install and configure to encrypt e-mails in outlook ? What does it cost, preferer pgp for companys with 10-20 users ? I have a look on other like etrust, there certificate cost round about 140 per year. What should i do ? any ideas or solutions for me ? Thanks, /KR Melnib00ne

fizban2, it works.. the fieldtypes in the access database doesnt work in time/date-format, it must be text, after script runs, i must convert it into german or international dateformat... thank you all very much.... /kr Melnib00ne,

Hi, thanks for answer. Yes, i'am sure, thats the same script. I have an dsn to the access database, the table in the access database is the same... i copy and paste the script from microsoft also in an new script, but the errormessage was the same..... any ideas ? /kr Melniboone

Hello, can anyone help me to work on the script below ? it came the errormessage: Zeile: 20 Zeichen: 5 Fehler: Fehler bei einem aus mehreren Schritten bestehenden Vorgang. Prüfen Sie die einzelnen Statuswerte Code: 80040E21 Quelle: Microsoft Cursor Engine and thats the vb script: Set objConn = CreateObject("ADODB.Connection") Set objRS = CreateObject("ADODB.Recordset") objConn.Open "DSN=EventLogs;" objRS.CursorLocation = 3 objRS.Open "SELECT * FROM EventTable" , objConn, 3, 3 strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colRetrievedEvents = objWMIService.ExecQuery _ ("Select * from Win32_NTLogEvent") For Each objEvent in colRetrievedEvents objRS.AddNew objRS("Category") = objEvent.Category objRS("ComputerName") = objEvent.ComputerName objRS("EventCode") = objEvent.EventCode objRS("Message") = objEvent.Message objRS("RecordNumber") = objEvent.RecordNumber objRS("SourceName") = objEvent.SourceName objRS("TimeWritten") = objEvent.TimeWritten objRS("Type") = objEvent.Type objRS("User") = objEvent.User objRS.Update Next objRS.Close objConn.Close where is the error ? i dont knew.... thanks /kr Melnib00ne

done. i've found an solution by this way: dtmThisDay = Day(Date) dtmThisMonth = Month(Date) dtmThisYear = Year(Date) strBackupName = dtmThisYear & "_" & dtmThisMonth & "_" & dtmThisDay strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate,(Backup)}!\\" & _ strComputer & "\root\cimv2") Set colLogFiles = objWMIService.ExecQuery _ ("Select * from Win32_NTEventLogFile where LogFileName='Application'") For Each objLogfile in colLogFiles objLogFile.BackupEventLog("c:\scripts\" & strBackupName & _ "_application.evt") objLogFile.ClearEventLog() Next

Hello, please have a look on the commands "rasdial" and "mstsc". i dont knew where rasdial work on vpn-connections, but i think so. with "mstsc computername" your can connect to the given remote pc. you can write it down in a simple cmd or bat file. hope you understand my broken english. :-) /kr Melnib00ne

Hello, anyone to has or help me to scripting an batch or vb-script to export the windows eventlogs to year-month-date.log file or an csv ? thanks, /kr Melnib00ne

thank you very much. works fine. /kr melnib00ne

Hello, is it possible to runs an short vbscript to insert or update data into an access or mysql database ? like over odbc ? i would like to update an recordset like add a counter in the db-field each time, runs the script and insert like username or else in the database. /kr melniboone

Hi, file permissions on the pst-file ? what filesystem u use on the disk ? Try in Outlook, File, Open, common pst and select then your pst. /Melnib00ne

Hi, does you have any rules in your outlook definied ? try some of these outlook switches outlook.exe /cleanrules outlook.exe /cleanviews outlook.exe /resetfolders make an copy of your outlook profile and your pst's before do something. what outlook version you use ? with exchange server ?

@Yzöwl thanks, thats what i need... some modifications and it works.... but i forgot to build an loop, now i must run the batch xx of hotfixes are in the folder. any solutions again ? heres my working code: if exist "c:\programme\" set lang=DEU if exist "c:\program files\" set lang=ENU ver | find /i "3790" > nul if not errorlevel 1 set osv=ws2k3 ver | find /i "2600" > nul if not errorlevel 1 set osv=WindowsXP for /f "delims=" %%g in ('dir /b ^"%cddrive%\hotfixes\%osv%\%lang%\^"') do (reg query "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Hotfix\%%~g" /v Installed | find "0x1" > nul||start /wait %cddrive%\hotfixes\%osv%\%lang%\%%g\%osv%-%%~g-x86-%lang%.exe /quiet /norestart) /BR

wus is very nice, but i would save the hotfixes on my share, folders or cd and the batch is cleaner, no server, no connection need, etc. /BR

Hello, i have an problem by an variable. thats the code: for /f "tokens=*" %%g in ('dir/b ^"%cddrive%\hotfixes\%osv%\%lang%\^"') do reg query "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Hotfix\%%g" /v Installed | find "0x1" > nul if errorlevel 1 start /wait ..... the batch looking the files on my share, then he looks for the installed hotfixes and when an hotfix was not installed, but in the directory exist the script goes to install... thats the idea., the problem is the %%g variable, if i run before reg query the echo command, the script told me all hotfixes in the directory, but not in the reg query command. any solutions, ideas ?