Search results for query: *

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.

...=~s/Tr\://gi; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...

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

...=~s/Tr\://gi; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...

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

...= $doc->{Subject}->[0]; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...

...= $doc->{Subject}->[0]; while($Cleaned_Subject =~ s/[^A-z0-9\$%'`\-\@{}~!#()&_^ ]/\-/g) { ; } $Cleaned_Subject =~ s/^\s*//; $Cleaned_Subject =~ s/\s*$//; $Cleaned_Subject =~ s/\\//; $Cleaned_Subject =~ s/\s+/\-/g; my $subdir = $Cleaned_Subject; $subdir =~...

Thanks for responding. The Freelance systems we have were originally manufactured by Hartmann&Braun who was later taken over by ABB. The system operates at DCS level on 5Mb/s Ethernet on a protocol I believe called ControlNet. I have limited information beyound that at present, but does know...

Does anyone have any ideas on how we can integrate data from a Freelance PLC (1996 vintage) to inSQL?

I always partition my HD into c: and D: and place all my user documents in the D: drive. However Windows insists on c:\Documents and Settings\... for all users. This includes the My faxes, documents, pictures etc. How do I ensure that it never looks in the c: drive for any documents but only on...

I have group of employees for which I want to add daily working hours, leave sick leave etc. I want to select the start of week using a combo box (done already). This should then populate a subform in datasheet view, filled with all active employee's name, number and the relevant fields such as...

Hi CUOK There is maybe two ways of doing this: One : If you cannot connect via network, you can, if both are connected to a modem on different telephone lines, set up a dial up network connection between the two computers. You can then on connection transfer the data from one machine to the...