Recent content by pdupreez

Yes Sir

With the help of a colleague I found the solution: SELECT NoNameTable.ProductionCODE, NoNameTable.Year, NoNameTable.Month, Val(Nz( SELECT Top 1 ClosingStock FROM NoNameTable N WHERE DateSerial(N.Year,N.Month,1)<DateSerial(NoNameTable.Year,NoNameTable.Month,1) AND...

I have progressed a little, in that if I include the other fields in my sort code, I get an answer, not the right answer always, but something at least. The code now looks as follow: SELECT NoNameTable.ProductionCODE, NoNameTable.Year, NoNameTable.Month, Val(Nz((SELECT Top 1 ClosingStock FROM...

Having worked through some Google results for the error code given, I understand now that we are talking about subqueries, and that the error is caused by the subquery returning multiple records even though Top 1 is included. The table contains data for many product types, in different budget...

Thank you very much Duane, for a noob like me that is an awesome looking query, and exactly the direction I am looking to go. I will look into the detail of what it does to ensure I understand how it works. I get no major errors when executing that query, but end up with no data (#name? in all...

I do not know if my question is clear enough, so please bear with me: I have a table with the following fields of information: Year[tab]Month[tab]ClosingStock 2009[tab]1[tab][tab][tab]1000 2009[tab]2[tab][tab][tab]1500 I want to calculate what was produced, and that is done by subtracting the...

Thanks for the input. I have only started using Perl and Ruby in the last few days, and I am learning a lot. You are right, I can run Perl outside of Cygwin, which is nice to know. Time to go fix the path!

Just shopping around. But no, seriously there is no need to convert, I just know this is a Perl forum, if people want to have it in Perl. It works great in Ruby, which in the Windows environment seems to have less overheads (no Cygwin)and integrates better into Scite in any case.

I have struggled with this and found my all solution by searching further and at the end I found a number of scripts which I cannibalized to give me a fairly good PERL script that will export each email as a text file, with its attachments into its own folder with a cleaned up subject field as...

Thanks Kevin for responding. That did not give me what I was looking for but further searching on Google did the trick. I had to mash a number of different scripts together, but can now efficiently process hundreds of Google Starred links and dump the selected links to a text file for further...

I have struggled with this and searched all over the net without a solution, but at the end I found a number of scripts and combined to give me a fairly bulletproof perl script that will export each email as a text file, with its attachments into its own folder with a cleaned up subject field as...

I use Google Reader (RSS aggregator?) a lot to capture interesting links and store them as "starred" for later processing. What I am looking for is a way to get all the links in the starred items, create a new html page (if necessary), spider through all the links within that new page and...

This is interesting, but there are times when having your XP on the "wrong drive", i.e. not Drive C could cause problems. Some software does not use the correct method to address the system disk path, and have it hardcoded. It will therefore look for c:\program files\etc when the actual install...

I have also been trying to extract all mail attachments from my Lotus Notes mailbox. I found the code below on perlmonk, and it works fantastically, other than for one small problem. It only saves the first attachment from the mail, and seemingly ignores the rest. I have looked everywhere to...

I have been trying to extract all mail attachments from my Lotus Notes mailbox. I found the code below on perlmonk, and it works fantastically, other than for one small problem. It only saves the first attachment from the mail, and seemingly ignores the rest. I have looked everywhere to try...