Search results for query: *

Hello. I'm doing an SQL query and converting it to XLS. When I run the query on the localhost DB, The file outputs to the specified location at C:/tmp/myfile.csv. However, when I run the query on the live DB, it outputs to the DB server at /home/mysql/csv/myfile.csv. As result, I can only...

Hello. I'm making a routine to run daily in SQL Workbench. I want the exported file to have curdate() added to the name for organizational purposes. SELECT d.emailaddress, d.fullname, d.address, d.city, d.state, d.zip, d.makepayabletoname, d.makepayabletoaddress...

Hello all- I'm trying to export to excel from a php mysql_query. It opens excel, but all i get is "  " in Cell A1. <?php $str='select d.emailaddress, d.fullname, d.address, d.city, d.state, d.zip, d.makepayabletoname, d.makepayabletoaddress, d.makepayabletocity, d.makepayabletostate...

Hello, I modified the code from here but i can't get it to work on my site. the only thing i changed was the id of the table: tbl2013-06-03 function write_to_excel() { str=""; var myTable = document.getElementByID('tbl2013-06-03'); var rows = myTable.getElementsByTagName('tr')...

Hello. I'm trying to implement this into my site. function toggle_visibility(tbid,lnkid) { if (document.getElementsByTagName) { var tables = document.getElementsByTagName('table'); for (var i = 0; i < tables.length; i++) { if (tables[i].id == tbid){ var trs =...