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