Re: How to summarize recordset...Select Distinct alternative?

Thanks ekkehard,
I'm learning all kinds of things from this thread!
:-)
I don't know how to use scripting but I put in a vb form and tried running
replaced WScript.Echo with Debug.Print for now
(cause I got an Object Required error on WScript)

oRs.Source - now that's really cool, had no idea you could get the sql
string back from the Recordset

Join(Array s, s1 ...
first i've seen that method of concatenation...
is that faster/better than s = s & s1 ???

clever sample of formatting output... thanks

sSQL worked for me

sSQLD gave me an error Wrong numbers of parameters Expected 3
will have to look into that one some more to see what i'm doing wrong..

Thanks for the input
Mark


"ekkehard.horner" <ekkehard.horner@xxxxxxxx> wrote in message
news:473b5b91$0$4362$9b4e6d93@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
MP schrieb:
I have a table with (lets say) 3 fields: fldFile, fldPage, fldItem
I want a summary report of Items/counts on a per file/ per page basis.
[...]
Because I like/learned a lot from the ideas/code of Bob Barrows and
Stephen Howe and think it sad that MP feels a bit discouraged:


:-)
no i'm not discouraged, just saying that I haven't seen an sql that
"formats" the output for me...
That code is required to do the "parsing" on the returned rs
I already have code that does what I need,,,using the Select Distinct method
I mentioned originally.
I was just looking to see if there was a "code-less" sql method of reading
recordsets...
:-)



I hope it shows the general strategies - how to get the info and how to
format
it.


Thanks again
Mark


.

Relevant Pages

  • Re: mySQL Problem
    ... sql servers) specify precisely where the problem is - this time it ... are things called RESERVED WORDS. ... by virtually any programmer I know. ... *formatting* said query so you could break it down and isolate the problem. ...
    (comp.lang.php)
  • Re: Set based solution
    ... And SQL IS a data manipulation language, hence my problem with not using it ... that I had always used SQL Server to do data formatting for the past 12 ... instead of coding hooks in a dll to do this formatting, ... SQL, and T-SQL, is not a general purpose programming language. ...
    (microsoft.public.sqlserver.programming)
  • Re: mySQL Problem
    ... sql servers) specify precisely where the problem is - this time it ... are things called RESERVED WORDS. ... Steve - I don't agree with your method of "properly formatting" the ... virtually any programmer I know. ...
    (comp.lang.php)
  • Re: Set based solution
    ... coding off the database server, then it is worthwhile doing it. ... I'd argue that formatting things that differ from country ... > And SQL IS a data manipulation language, hence my problem with not using ...
    (microsoft.public.sqlserver.programming)
  • Re: mySQL Problem
    ... sql servers) specify precisely where the problem is - this time it ... queries code readability you are, of course, right, since a programmer ... are things called RESERVED WORDS. ... about formatting. ...
    (comp.lang.php)