Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to convert '2005-9-22 3:9:00' to 200509220309
i use SELECT concat(YEAR(now(), MONTH(now()), DAY(now()), HOUR(now()), MINUTE(now())); return 200592239. but i want double digit hour and minute anybody knows. -
exec("mysql -uusername -ppassword <'export.sql'") return nothing
Hi, when I run exec("mysql -uusername ppassword<'export.sql'"); on solaris9 it returns nothing. I also tried system("mysql -uusername -ppassword <'export.sql'") it return nothing. but when I run on windows xp exec("mysql -uusername -ppassword -e \"source export.sql\""); it works and returns... -
Error executing: Query was empty
expert, I run a perl script on solaris9. this is the script: my $sql = "SELECT produce_code, product_name INTO OUTFILE 'export.txt' from products"; my $sth = $dbh->prepare($sth); $sth->execute or die("Error executing:$DBI::errstr"); it returns error excuting: Query was empty at line 222. when I... -
when download file, permission denied. but file is 0777 mod
Hi, all, I have a website run solaris9 using apache that come with solaris9. I use perl as cgi script. I want to upload files from browser and download file from browser also. right I can upload file and set directory mod777 using perl upload script. but when I download the file, server can't...
