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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import Mysql data into a table in excel
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... -
Import Mysql data into a table in excel
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... -
Import Mysql data into a table in excel
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... -
Import Mysql data into a table in excel
I have to use perl since its a unix environment... -
Import Mysql data into a table in excel
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}) {... -
Import Mysql data into a table in excel
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. -
Import Mysql data into a table in excel
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? -
How to access the last entry for different systems
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 =... -
How to access the last entry for different systems
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. -
Average of grouped fields?
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... -
Converting alphanumeric data fields to Code39One Barcodes
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...- aks2trip
- Post #10
- Forum: Business Objects: Crystal Reports 1 Formulas
-
how do you convert binary into char
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)- aks2trip
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
how do you convert binary into char
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...- aks2trip
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
