I'm working in visual web developer and i want to use the results of a count query but i don't know how to get them. I am using a select statment:
SELECT Count(Record) From " & Session("Custom er")
And I believe that works, but now i don't know how to actually look at or use the count. I thought i could just use the reader so i tried:
Session("Count" ) = dbreader.Item(" Count(Record)")...
Jschraepf
Last Activity: Jul 5 '07, 03:16 PM
Joined: Jun 25 '07
Location:
-
How to read the results of a "Count" query
-
Need help with dbcommand text in Web Developer
I am creating a fairly simple web app but I am having some trouble with the database access at this point. I need to select a single row which is the most current (has the highest record autonumber). . It is selecting a variable table from a database and works fine if I tell it what to select, but I need to know how I can tell it to pick the highest number. The snippet of code is below. "HIGHEST NUMBER" is obviously where i need to know...
No activity results to display