check is column name is correct

ryanvdmerwe · March 15th, 2004, 11:02 AM

Hi

I need to check if a column name exists.

a script like this if exists(objRS("column_name")) = true then.....

obviously there is no such scrit as the one above, but if anyone has an idea or sample code i could try I'd appreciate it very much.

thanks
Ryan

Imar · March 15th, 2004, 11:13 AM

Hi there.

What you could do is execute a SELECT * query and then loop through the Fields available in the Recordset, comparing their Name property against the value you're looking for. The code below shows what I mean:

Code:

<%
    Dim oField ' As ADODB.Field
    Dim oRecordset ' As ADODB.Recordset
    Dim oConn ' As ADODB.Connection
    Dim nameToCheck
    Dim nameExists

    ' The column name you're looking for
    nameToCheck = "ID"
    nameExists = false

    ' Create connection
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open "YourConnectionString"

    Set oRecordset = oConn.Execute("SELECT * FROM YourTable")

    For Each oField In oRecordset.Fields
        If oField.Name = nameToCheck Then
            nameExists = True
            Exit For
        End If
    Next

    oRecordset.Close()
    oConn.Close()
    Set oConn = Nothing
    Set oRecordset = Nothing

    Response.Write("Field " & nameToCheck & " found " & nameExists)
%>

I am curious why you need to perform this check. Are you working on generic code, or coding against an unknown database?

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

ryanvdmerwe · March 15th, 2004, 02:55 PM

you are correct in that I am coding against an unknown database.
I have an app where a user imports data from a csv file into an sql table that has specific column names.

I want to make sure the user has the column names correct in his csv file and if not let him know which columns he has incorrectly named.

I'll give you code a try.

thanks

Imar · March 15th, 2004, 03:12 PM

Right, in that case my code should be useful to you.

You'll probably need to set up a loop for the columns in the database, and then inside the code block that checks the name, compare against the name in the CSV file.

You're probably best off with using a counter instead of a For Each statement, as you probably want the order of the columns in the CSV file to match those in the recordset.

Good luck, and let me know if you need any more help with this.

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.