Getting cloumn names

[arunbalait]

Hi all

Am using asp and mysql...

I have to fetch columns from mysql database..

In jsp there is an option to get the column names directly by using getColumnName(ih)

And how to use this in asp like getColumnName(ih) in jsp...

I want to use that same in asp...

Give me some hints..
Am using request.form for each and every values...

Thanx

[Arnold Schuur]

If you use ADODB to connect to your MySQL database, then you could use the following code to achieve this:

Sub ListTableAndColumnNamesADO()
  Dim Conn As New ADODB.Connection
  Dim TablesSchema As ADODB.Recordset
  Dim ColumnsSchema As ADODB.Recordset
 
  'Open connection you want To get database objects
  Conn.Provider = "MSDASQL"
  Conn.Open "DSN=...;Database=...;", "UID", "PWD"
 
  'Get all database tables.
  Set TablesSchema = Conn.OpenSchema(adSchemaTables) 
  Do While Not TablesSchema.EOF
    'Get all table columns.
    Set ColumnsSchema = Conn.OpenSchema(adSchemaColumns, _
      Array(Empty, Empty, "" & TablesSchema("TABLE_NAME")))
    Do While Not ColumnsSchema.EOF
      Debug.Print TablesSchema("TABLE_NAME") & ", " & _
        ColumnsSchema("COLUMN_NAME")
      ColumnsSchema.MoveNext
    Loop
    TablesSchema.MoveNext
  Loop
End Sub