Find Out Whether a Specific Column Exists in a Database Table
<% 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) %>
Where to Next?
Wonder where to go next? You can post a comment on this article.
Links in this Document
|Written by||Imar Spaanjaars|
|Date Posted||03/15/2004 16:33|
|Date Last Reviewed||02/28/2006 19:28|
Talk Back! Comment on Imar.Spaanjaars.Com
I am interested in what you have to say about this article. Feel free to post any comments, remarks or questions you may have about this article. The Talk Back feature is not meant for technical questions that are not directly related to this article. So, a post like "Hey, can you tell me how I can upload files to a MySQL database in PHP?" is likely to be removed. Also spam and unrealistic job offers will be deleted immediately.
When you post a comment, you have to provide your name and the comment. Your e-mail address is optional and you only need to provide it if you want me to contact you. It will not be displayed along with your comment. I got sick and tired of the comment spam I was receiving, so I have protected this page with a simple calculation exercise. This means that if you want to leave a comment, you'll need to complete the calculation before you hit the Post Comment button.
If you want to object to a comment made by another visitor, be sure to contact me and I'll look into it ASAP. Don't forget to mention the page link, or the Doc ID of the document.
Please correct the following errors:
Unfortunately, something went wrong and your message or comments have not been submitted successfully.
There's a fair chance things broke down because you tried to post something that looks like HTML. Things that look like HTML include (X)HTML, obviously, XML, ASP.NET markup and c# generics syntax as all of them use the < and > characters.
If that's the case, try altering your message and remove anything that looks like an angled bracket. You can replace them with [ and ] for example so you can still make it look like HTML to some extend.
If, on the other hand, you were trying to spam this web site, I am pretty glad I caught you in the act and stopped you from doing so ;-)
Also, please don't use links in your posts; I had to block them to filter out most of the junk mail I am receiving.