Can I find out what the key field of an Access DB is by using ASP?
<%<BR>Dim cn<BR>Dim strSQL<BR>Dim rs<BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>cn.Open YourConnectString<BR>strSQL = "select KeyField from AccessDBtable"<BR>set rs = conn.execute(strSQL)<BR>response.write rs("KeyField")<BR>rs.close<BR>cn.close<BR>set rs = nothing<BR>set cn = nothing<BR>%>
Yeah ... SQL
He was trying to figure WHICH the key feild was in ASP :P<BR><BR>Hand in your cloak captain and wear your underwear INSIDE your pants from now on<BR><BR>Brain Power.
http://www.devguru.com/Technologies/ado/quickref/ado_intro.html<BR>This will tell ya how to find it.
what happened to your site??<BR><BR>
You can use the openschema method<BR><BR>set rs = connection.openschema(28)<BR><BR>You better check the docs at MSDN as I'm not sure aboute the right value for gettinng the primary keys.
Whooooosh!<BR><BR>(The sound of my humor going over your head)
SQL *IS* one of the components of ASP.