Hi,
under here there is a script for create a .TXT file from a windows
machine (it's a task), but file is created successful but have no data
in....

Someone can help me?


Alen, Italy
BYE


------------------
ECHO OFF


for /f "tokens=1-4 delims=/ " %%a in ('date/t') do (
set dw=%%a
set mm=%%b
set dd=%%c
set yy=%%d
)


for /F "tokens=5-8 delims=:. " %%i in ('echo.^| time ^| find "current"
') do (
set hh=%%i
set ii=%%j
set ss=%%k
)


SET bkupdir=C:\BKP\BAM
SET mysqldir=C:\Program Files\SugarCRM\oss\mysql
SET dbname=myDB
SET dbuser=root
SET dbpassword=myPsss


ECHO Inizio procedura di creazione file


cd %mysqldir%\bin\


mysql --u %dbuser% -p%dbpassword% %dbname% -e "SELECT * FROM
opportunities" > C:/BKP/BAM/SugarCRM_%yy%%mm%%dd%.txt


ECHO Operazione terminata con successo!
ECHO Nuovo file creato in: SugarCRM_%yy%%mm%%dd%.txt