Replies

AHA!

Changing the “Group By” to “Expression” in my In Access “query builder” saves 2 steps in my 3-step process!

Thanks Marks – you both taught me something! I can throw even MORE code away

hunh! I would’ve expected you [of all people!] to have an Access solution to this “problem”

FWIW, i’ve found Excel useful as a tool to develop complex queries. Expression 1 in column C, expression 2 in D, etc. Then I combine them such that I have one stmt that gives the same answer as the series of simpler stmts. Unfortunately, I havent found a way to adequately document what winds up in the app…

Hey MarkJ ~ I tried the “more direct” method, using ID, Year, and Month as Select fields (because there are criteria on them), with SumOF the other fields, and i always wind up with distinct records for each year and month. I’ll go back and look at my SQL again, perhaps I can simplify what I’m doing…

What I’ve been doing is a three-step process:
1. Use a Make Table Query to create a table with the appropriate fields
2. Query the table using the SQL aggregate functions (Sum, Avg, etc)
3. After all the data are presented, I run a Drop Table query.

Gaak! check this out ~ it makes VSS useless IMO. [indent]

---

All Visual SourceSafe operations are performed by FrontPage Server Extensions on the Web server itself, not client machines.

---

[/indent] Thanks, Jefferson!

I appreciate the fact that I am not alone Here’s a quote from the FP “help” [indent]

---

For information about how to integrate Visual SourceSafe with FrontPage, see the Microsoft Office XP Resource Kit.

---

[/indent] The RK is a book+CD for sale by MS. I checked the contents online, no reference to this “problem”.

After some trial and error, something that sorta works…

        Dim name as String
        For Each myPageWindow In ActiveWebWindow.PageWindows
            myPageWindow.Activate
            If myPageWindow.IsDirty Then
                name = myPageWindow.Document.Title & ".asp"
                myPageWindow.SaveAs name
            End If
        Next

A few of advantages:
* it’s already written and works (probably the major advantage)
* you can get a specific row by specifying the start
* you can specify how many rows to get.

Why not use the Recordset.GetRows method?

No looping required.

my host is parcom.net, reasonably priced and extremely conservative. I use their win2k servers and ASP.

MS has always been extremely helpful when I’ve had disk/CD/password problems, and I have no reason to believe that policy has changed.

Jim – while those of us in the Lounge ponder your situation, I suggest you surf to the MS site and simultaneously look for a description of your problem in the MSDN Knowledge Base.

Thanks Preston ~ I’ll have her check in that direction

Hi Kate ~

Would you be so kind as to elaborate a bit about what unnecessary code is, and how it was so determined?

E.g., i use a lot of “unnecessary” code in my *.ASPs to trace execution. I can turn execution of the code on and off. It’s like a parachute: “unnecessary” most of the time.