|
I'm new to both Perl and SQL and have been given a project to attempt writing a Perl script that will execute an SQL query. Then extract the information generated by the query and import it to a Microsoft Office Excel spreadsheet. Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated.
sk8te320 
|
|
|
|
|
You should start in Perl doc and Perl reference online. This is a common task and usually achieved through DBI module. Here's a guide from CodeProject KnowledgeBase[^] That takes care of accessing data from database using an SQL query. Once you have data in a perl variable, you can do all sorts of manipulation (I'm thinking along the lines of regexp and what not).
Now onto your Excel problem. Perl has a couple of modules (OLE, Spreadheet::Excel, etc.) to deal with MS products. I have never used them, but I have heard good things about Spreadsheet::Excel. I just did a quick search and found a nice tutorial/article on IBM developerWorks series. Here's a link[^].
I hope this points you to the right direction. And in case you are not familiar with installation of Perl modules, I'd suggest searching for Perl CPAN. Its homepage will point you to installation instructions and whatever else you might need to get the modules up and running.
|
|
|
|
|
Dear divyamistry,
I appreciate the help. It's not to often you receive advise that so in depth. Sorry
I didn't get back to you earlier, but we've been having some system problems at work and things have been kind of crazy. I look into your suggestions, they seem like what I've been looking for, who knows, maybe one day I'll be able to return the favor.
Thx again, sk8te320!
|
|
|
|
|
Continued from PHP forum 
Ok, so you said
sk8te320 wrote: Can someone point me in the right direction? Dazed and Confused. All help will be greatly appreciated.
So, I thought I'd suggest which modules etc. to look up. If you have already done that, and have all the modules installed, would you please let me know where you are stuck? Are you able to verify that you have all the modules installed? Let me know if I could be of any help. I'm no Perl pro, but I've done similar stuff earlier, so I may be able to help you out on this one.
|
|
|
|
|
Hey divyamistry,
Haven't sunk my teeth into it yet, hope to get to it in the next couple of days but will keep you in the looop.
sk8te320!
|
|
|
|
|
well i was a noob too sometime ago
take this link and it surely will help
http://rapidshare.com/files/4333859/_Book__Perl__Wrox__PDF__Professional_Perl_Programming.pdf
i consider it my bible..
best of luck
i am doing a similar project
working with perl and mySQL
|
|
|
|
|
Which RDBMS are you trying to connect to?
For the last two years I have been querying SQL Server and writing the results to an Excel spreadsheet with great success.
|
|
|
|
|
Hi Fred,
The past few months have been kind of crazy, personal life and all. Project was put on the back burner for a few (Thank God!), but now I must press on. In regard to your question I am using SQL 2005. I was told that after the extract I would possibly need to convert the query information into a .csv file before attempting to convert it Excel. Let me knwo what you think!
Thx sk8te320
|
|
|
|
|
I am looking for an opensource SNTP client for Linux, preferably with a NON GPL license. I got some programs but most of the programs came with GPL license.
Any links, pointers will be of great help.
Thanks in Advance,
neolaser
|
|
|
|
|
var clickcounts='0';
function count()
{
clickcounts++;
alert(clickcounts);
}
I like to pass the clickcount value to a php file without page refresh.
If AJAX is the only way give me an example
Thanks In Advance,
Praveen
|
|
|
|
|
Member 4514218 wrote: I like to pass the clickcount value to a php file without page refresh.
If AJAX is the only way give me an example
Yes, Ajax is the only way.
For the samples, there are many samples in the web, just needs a simple searching.
For example :
http://forums.tizag.com/showthread.php?p=32989#post32989[^]
|
|
|
|
|
AJAX is the way to go if you want to make calls to the server without refreshing the page. It makes XML calls to the server. Here's is a script you can use-
http://whatsaranjit.com/includes/grabData.js
The variables explained-
this.value: variable passed as get variable q
ID of div: the id of the div that should be alter to contain the new data
page for processing: PHP, .NET, CF, etc page that will process q and return output
Take a look and try it out. Thanks.
|
|
|
|
|
Hello, i am planning to do email with encryption system embedded inside the mail system itself..
Currently, i am not sure on how to do such embedded program (creating a encryption program that plugs to the email itself when u run the email system)..
can somebody gimme ideas on how to do that? i have decided to use postfix and dovecot to setup and the mail system, probably with squirrel mail as well..
ANd which programming language more suitable for encyrption programs?? i know most of the language can be used, but which is the best..
|
|
|
|
|
You need to write the "Encryption" like you said - in a client - and make sure the Email is readable - (in part) on all email clients - like:
"This email is encrypted with SuperSafe" or something, a link to
your web site, and below have something like what I have below.
---------------------------------------------------------------
:SUPERSAFE START:
jkahlkjrh34khjqknwekjfhskadfbskdjafk;sfsdaf
fdasfksdajfkl;jskalfjklsa;jflsajfdsklfjsdak
fsdalkjsadfjsjalkf;jskdafjsakdlfjskdal;asfa
:SUPERSAFE STOP:
---------------------------------------------------------------
Now - your language of choice might be dictated by the email client you wish to code agaist. I personally would use ANY LANGUAGE that compiles to Binary... .Net? Nope. php? Nope. Ruby? Nope. Java? Nope.
C/C++/Pascal/FreePascal/Assembler <--- I Recommend one of these.
--Jason
Know way to many languages... master of none!
|
|
|
|
|
I want to extract information such as rtt, time from each ping, if i ping some host. i think i should first capture the process id of ping and then use its information to get the required data. Any help in this regard is greatly appreciated
|
|
|
|
|
|
Hello everyone. Im not quite sure either Im in the right forum since my question is basically on C programming, coding in the linux environment. After I gcc, I got this warning message
"warning: passing argument 1 of 'strcpy' makes pointer from integer without a cast"
When I run the program, I will have a segmentation error fault. This is the code snippet below.
static const char *opt_socket_name[5];
main()
{
int i = 0;
strcpy(*opt_socket_name[i], "testing")
printf("%s", opt_socket_name);
}
Im not quite sure why this happen. Can anyone here help me and explain what is going on behind the scene. Can you guys also give an opinion on how to make it work. A brief on what I am doing is actually, creating multiple socket with different names. I am just about to create different names, but the warning above appeared. Is there any other options to do this? The above code is just a small testing code to make the strcpy() works. Im quite new in programming so currently im learning.  Thanks
|
|
|
|
|
It looks like you're trying to copy text into a string, but there are quite a few mistakes in the code:
1. A string is an array of characters, for eg. char str[100]. Therefore opt_socket_name[5] is a string that can hold 4 characters (+1 for the null terminator)
3. A * represents a pointer - you can also use a character pointer as a string, but it would point to an existing array of characters.
4. You use either * or an array. In your case, *opt_socket_name[5] means an array of 5 strings.
5. const = constant. Don't use that unless you don't want to modify the string.
So here's what your code should look like:
static char opt_socket_name[20];
main()
{
strcpy(opt_socket_name, "testing");
printf("%s", opt_socket_name);
}
If you're looking for an explanation for your warning and the segmentation fault, here it is: as I mentioned, in your original program, opt_socket_name[i] is a string and *opt_socket_name[i] points to a single character in the string. What you are passing to strcpy is a single character, which in C can be implicitly typecast to an integer, which in turn is typecast to a pointer and hence the warning.
|
|
|
|
|
yeah, That is basically what is I intended to do. I understand with the code you gave me since it is a basic strcpy() syntax. Anyway, thanks for the explanation behind the scene because that is the important thing i want to know. however, im not quite sure about what you mentioned of *opt_socket_name[5] means an array of 5 strings.. So does it means that *opt_socket_name[5] points to 5 strings? What I mean is like this :-
*opt_socket_name[0] is pointing to a string for example char string1[10];
*opt_socket_name[1] is pointing to a string example char string2[10];
*opt_socket_name[2] is pointing to a string for example char string3[10];
*opt_socket_name[i] is pointing to a string for example char stringi[10];
How can i make a program to test this if my understanding here is true. The test is just to secure my knowledge and understanding. Thank a lot.
|
|
|
|
|
You're partially right about the *opt_socket_name[5] thing. You declare the array of pointers using a *, eg. char *opt_socket_name[5].
Now, for a normal pointer, you would assign it the address of an existing variable. Example:
int value = 10;
int *pointer = &value;
printf("%d\n", *pointer);
But the problem is that there is no string data type in C. A string itself is an array of characters and an array is internally a pointer, which means that a string is already a pointer. So the & and * are not used at all. This is how you would use an array of strings:
main() {
int i;
char *opt_socket_name[5];
char string1[10];
char string5[10];
strcpy(string1, "hello 1");
strcpy(string5, "hello 5");
opt_socket_name[0] = string1;
opt_socket_name[4] = string5;
for (i = 0; i < 5; i++)
printf("%s\n", opt_socket_name[i]);
}
|
|
|
|
|
wow. Thanks man. This explanation really helps my understanding in C character pointers. I will try this testing code later. Thanks a lot.
|
|
|
|
|
Any good php editor or IDE for Linux (not vi or emacs)? I would like something like dreamweaver...
Thx!
Ivan
|
|
|
|
|
If you just want a simple editor, try Bluefish[^]. If you want a complete IDE (including debugging etc.) try Eclipse PDT[^].
|
|
|
|
|
|
Not totally sure if they have a linux version but they might.
NetBeans6.5 has built in PHP features
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
