Search results for query: *

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...

I have to use perl since its a unix environment...

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.

I am using perl to connect to a mysql db. How do I export the data returned from the sql command into a nice looking table in excel?

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.&quot;BITS&quot; 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...