Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql result

Status
Not open for further replies.
elly00

elly00

Technical User
Jun 30, 2011
69
IT
Hi,,
how can I test the result of a query?

For example I've SELECT COUNT(*)FROM TABLE..

I would like to store the result in a variable in order to test it
 
Sort by date Sort by votes
If you have a single value returned from a recordset, it can be retrieved with something like:

[tt]myvariable = rst.Fields(0)[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
execute sql store prodecure
Replies
1
Views
104
SaltyTheFrog
SaltyTheFrog
elly00
  • Locked
  • Question
printig sql tabel from vbs
Replies
0
Views
76
elly00
elly00
elly00
  • Locked
  • Question
vbs - select on sql view
Replies
1
Views
86
xwb
xwb
chaznbs
  • Locked
  • Question
Need help please. VBS to display specific SQL record
Replies
5
Views
96
chaznbs
chaznbs
whois12000a
  • Locked
  • Question
vbscript insert into a oracle DB using sqlplus
Replies
2
Views
118
guitarzan
guitarzan

Part and Inventory Search

Sponsor

Back
Top