Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Could someone explain this query to me

Author  Topic 

kathunter
Starting Member

35 Posts

Posted - 2001-04-03 : 17:15:02
I am beginning, and this is code from a contractor.

SQL= "SELECT SUM(packagesources.number), packagesources.source "
SQL= SQL + "FROM packagesources "
SQL= SQL + "WHERE packagesources.yearday = (SELECT yearday.yearday from yearday) "
SQL= SQL + "GROUP BY packagesources.source "
SQL= SQL + "ORDER BY sum(packagesources.number) desc"

But when he writes the data, he writes:
"<td>" + cstr(oRS1(1)) + "</TD>"
"<TD>" + cstr(oRS1(0)) + "</TD>"

What is the 1 and 0?

I should have taken the blue pill
   

- Advertisement -