I can get link tables through mysql and get everything into one table and print it to excel using Spreadsheet::WriteExcel::FromDB
It becomes very straightforward. My only problem now is that it would repeat the data for some of the columns because of the linking. So i get results like that
A...
OK so when i run the query, how do i get the results in a csv file?
I will try and group everything in One table.
While browsing cpan, i also found a module called, Spreadsheet::WriteExcel::FromDB
This takes the entire table and prints it in excel. You may choose to ignore columns or put...
ok so how would i import my data from 3 MySQL queries into a csv file? Sorry, I don't know how to do that.
Would i run query 1
append to myoutput.csv file
query 2
append again?
query 3
append again?
the problem is that they are three separate queries as opposed to one. SO initially I was...
What I did was stored the result from the query straight into a hash of array and then printed it in excel using WriteExcel.
foreach $record (@output) {
$i=2;
while ( $i <= $#{$record->{tableref}} ) {
$j=0;
while ($j < $record->{field_count}) {...
i am trying to use Spreadsheet::WriteExcel. But how do I break it down and put it in rows? How do i create a table and also how can i link the data from two different queries to enter all values in one table?
Sorry for my ignorance but i am new at perl and dont have much experience with it.
Here is what i tried - the table contains different systems and the different volumes attached to it.
SELECT systems.HOSTNAME, volinfo.SYS_ID, volinfo.VOL_ID, volinfo.MOUNT, max(volcap.sampletime),volcap.KB_USED, volcap.KB_TOTAL FROM (volinfo INNER JOIN systems ON volinfo.SYS_ID =...
Hi,
How would I access the values of the last datetime stamp for different system id's present in the table?
For example, if i have 5 system id's their last entered datetime stamps might be different. How would i access the related values for the systems?
Thanks for all help in advance.
Hi,
I have a table that contains data as follows:
SYSTEM MOUNT KB_USED KB_TOTAL
host_1 / 1000 30000
host_1 / 1500 30000
host_1 /apps 1092 234343
host_1 /apps 7266 234343
host_2...
hi,
i have a question for danENW. i am having the exact same problem tht u mentioned.... that is converting embedded blanks to barcodes. i tried using the replace function but tht gives me an error saying it should be a boolean function although it already is. if u kindly tell me the proper...
I am using oracle 8 version ODBC (VISUAL)
crystal reports version 8.5
the field type in the database is supp to be LONGVAR
the statement i used was
CAST ( CAST ( PART_BINARY."BITS" AS VARBINARY(254))) AS VARCHAR(254)
how do you convert binary into character??
i am trying to convert a BLOB field into text and trying to extract the information put into the blob field.
i had read up suggestions which said to write a sql expression using cast statement but it does not work . it gives me an error.
how do i go...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.