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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. taphonomist

    Multiple self references in arg list

    Thanks microm! I came up with a method that used optional arguments, but your solution has the benefit of showing the optional arguments in the function definition. Many ways to the same end, but some make more sense. More importantly, thanks for the time spent on the explanation!! D
  2. taphonomist

    Multiple self references in arg list

    Is it possible to include more than one instance of self in the set of function arguments? As in def functionForClass(self,firstArg, keyArg=self.stringProductingFunction()): #do stuff, things ... return I keep getting errors with similar code, and was wondering if there was another way...
  3. taphonomist

    VBScript for "control-shift-enter"

    Got it!! Just had to set the range ArrayFormula property, rather than specifying the Value property. http://msdn2.microsoft.com/en-us/library/microsoft.office.interop.excel.range.formulaarray(VS.80).aspx Dustin
  4. taphonomist

    VBScript for "control-shift-enter"

    Hey all, I'm trying to use a vbscript to do some matrix calculations in excel and having trouble figuring out how to apply the functions. When actually working in a workbook, you select the cells you need, type the array function (MINVERSE, eg), and then press control shift enter, but I can't...
  5. taphonomist

    Nested select problem

    No worries, thanks to you both for the help! taphonomist
  6. taphonomist

    Nested select problem

    Thanks much!! That'll do. It seems kind of odd that you have to give an alias to "transient" data... oh well, as long as it works!! taphonomist
  7. taphonomist

    Nested select problem

    but is the second column in the two column table, the first being bte.buildfile (see the group by statement). In any case, I've also tried the code you've written with no luck. taphonomist
  8. taphonomist

    Nested select problem

    I get syntax errors with this select but from (select bte.buildfile, max(bt.buildtime) as but from buildtimeestimator bte, buildtime bt where bte.buildfile=bt.buildfile group by bte.buildfile) while this select bte.buildfile, max(bt.buildtime) as but from buildtimeestimator bte, buildtime...
  9. taphonomist

    Networked DTS package executes manually but not when scheduled: SQL Server Agent problem

    What seems to be a pretty common problem is that a DTS package will execute if told to from Enterprise Manager, but will not execute when scheduled as a job. One possible problem is the account that the server agent is running under. When you manually execute a package, the package is run with...
  10. taphonomist

    DTS Package Problem

    It turns out that the Server Agent was running under the local system account, which has no permissions for anything. With some fairly targeted googling I found a slew of people with similar problems, most of which appear to be related to the account that the Server Agent was running under...
  11. taphonomist

    DTS Package Problem

    Quick update: Using remote desktop, I ran the package (on the server) that I'd designed on my machine with no problems, but it still won't execute if scheduled. taphonomist
  12. taphonomist

    DTS Package Problem

    I'm having some trouble with a scheduled package with SQL Server 2000. The package basically accesses and pumps data from an Access file that basically tracks usage of some machines, which I'd like to have a daily log of. As seems to be a pretty common problem, I'm able to execute the package...

Part and Inventory Search

Back
Top