• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

How to treat fields name of table as a clletion or object?

Hello,

My friend is trying to read data from a MySQL table using VBScript and wondering if instead of typing each field of the table in his code one by one could use an object (like dealing with collection) and read all the field of a table and read them.

Is this possible in VBScript?

Thanks,
Ak
0
akohan
Asked:
akohan
1 Solution
 
andrewssd3Commented:
I have not done this, but I believe you can connect to MySQL using ADODB (see for example this).  Then once you read your data into a normal Recordset, you have the Fields collection and can do all the usual Recordset stuff.
0
 
akohanAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now