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=2006sugarcrm
SET dbuser=root
SET dbpassword=LetMeIn_0k

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