|
I don't want other do my coding.
i was just asking where i am going wrong that it.
I will start a new thread for that.
This time i will see my English.
i understood one thing from your code that query for
the filter was not good.i am able to download 10000 records.
But fails when i apply filter to that.
Can you see the Query and tell me what is wrong please.
i have 4 table champs(Champion Ships),teams(team),matchs(matchs played),rag(scores)
I hope the below Query will be understandable.
SELECT date,(select champname from champs where champid=matchs.champid) AS ChampionShip, matchs.round AS Round, (select teamname from teams where teamid=matchs.home) AS home, (select teamname from teams where teamid=matchs.away) AS away, HomeOdds,AwayOdds,DrawOdds, rag.goalno AS NoOfGoals, (select sum(rag.home) from rag where matchid=matchs.matchid) AS HomeGoals, (select sum(rag.away) from rag where matchid=matchs.matchid) AS AwayGoals FROM matchs, rag WHERE rag.matchid=matchs.matchid And rag.goalno=(select max(goalno) from rag where matchid=matchs.matchid);
|
|
|
|
|
That might be better off in the database section as it's a SQL related question, not a PHP related question, again start new threads, this one is going off topic and out of control.
|
|
|
|
|
Ok,
Thanks you for every thing.
|
|
|
|
|
EliottA wrote: Before you post, consult with Mr. google[^] and RTFM[^] so you can give it a try before you post.
Well put  Do you think we could get Chris to put something like that at the top of every forum?
Regards,
--Perspx
"A refund for defective software might be nice, except it would bankrupt the entire software industry in the first year."
-Andrew Tanenbaum
"Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer."
-Fred Brooks
|
|
|
|
|
Something like that exists in the C# and VB.Net sections, I don't see why it's not in the PHP board too. Put it in the suggestions board, I'm sure it will go under consideration, assuming it's not in the to-do already.
|
|
|
|
|
Well put Poke tongue Do you think we could get Chris to put something like that at the top of every forum?
Regards,
--Perspx
What you guys are thinking are not right.No one here come and
posts with out trying it in google and other tutorials.Of course for
you smart guy its very silly and easy.Here people come when there are
no other ways to find solutions to their problem.
Regards,
Pavan.
|
|
|
|
|
LazyDragonfist wrote: No one here come and posts with out trying it in google and other tutorials
Really..? No-one?  Jeez, a hell of a lot of answers to questions I've seen here are simple, bog-standard, type it into Google sort of things..
Regards,
--Perspx
"A refund for defective software might be nice, except it would bankrupt the entire software industry in the first year."
-Andrew Tanenbaum
"Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer."
-Fred Brooks
|
|
|
|
|
Well put Poke tongue Do you think we could get Chris to put something like that at the top of every forum?
Regards,
--Perspx
What you guys are thinking is not right.No one here come and
posts with out trying it in google and other tutorials.Of course for
you smart guy its very silly and easy.Here people come when there are
no other ways to find solutions to their problem.
Regards,
Pavan.
|
|
|
|
|
I disagree, a lot of people come here without searching google or the documentation.
|
|
|
|
|
I am running a website where i require uploaded word document to be shown on the fly on the particular poages. , but i dont have a php script that converts .doc file contents to html .
Please help me out.
Regards
Jude Dcoutho
judedcoutho@gmail.com 
|
|
|
|
|
It's good news for python developers.. !!!
It is good, To started python message board.. on codeproject ..
I m too happy 
Thanks
Pavan Pareta
modified on Thursday, March 12, 2009 9:41 AM
|
|
|
|
|
I didn't realize that we had a Python formum. 
I'll have to start watching it, as Python is my second favorite language after C++.
Later,
Mike
|
|
|
|
|
Seems things are odd right now. I came in here, didn't see any posts, made the one above and then after posting, saw that there were two other posts ahead of mine.
I replied to one of them (which seems to now be linked to this subject rather than the one I replied to) and now I only see this subject.
Weird.
|
|
|
|
|
And now, after posting the above, things seem to be back to normal.
Oh well. Still cool that we have a Python forum here.
-Mike
|
|
|
|
|
MikeBeard wrote: Python is my second favorite language
You mean something like my brain is my second favorite organ ...
In January you said "Money in April" -
That was two years ago!
B. Python
|
|
|
|
|
You got me. I should read over what I write before I post.
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
