|
 |
asp_databases thread: Displaying Directories
Message #1 by Tim Brooks <TBrooks@c...> on Fri, 25 May 2001 12:08:31 -0400
|
|
I'm doing the chapter 10 examples on displaying directories and it works
fine. My question is how can I dispplay a directory that is on another
computer?
Timothy S. Brooks
tbrooks@c... <mailto:tbrooks@c...>
ext. 365
Message #2 by "Dallas Martin" <dmartin@z...> on Fri, 25 May 2001 20:14:24 -0400
|
|
You need to use ADSI.
You need a logon to the remote server.
You need ACL to the directories/files on the remote server.
Go to www.wrox.com
Search for their books on ADSI.
Download the source code listings.
You'll find lots of helpful info in the code.
Dallas
----- Original Message -----
From: "Tim Brooks" <TBrooks@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, May 25, 2001 12:08 PM
Subject: [asp_databases] Displaying Directories
> I'm doing the chapter 10 examples on displaying directories and it works
> fine. My question is how can I dispplay a directory that is on another
> computer?
>
> Timothy S. Brooks
> tbrooks@c... <mailto:tbrooks@c...>
>
> ext. 365
Message #3 by "Jay" <jtienor@m...> on Tue, 29 May 2001 13:51:15 -0500
|
|
I know it is a little off topic but would anyone know how, in ASP or
otherwise, I could retrieve a listing of all fields in a table and
their attributes? Basically want to be able to extract the database
design.
Thanks for any help in advance.
Jay
- ----------------------------------------------------------
Jason L. Tienor
Interactive SolutionZ, LLC
jtienor@i...
xxx.xxx.xxxx
- ----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, May 25, 2001 7:14 PM
Subject: [asp_databases] Re: Displaying Directories
> You need to use ADSI.
> You need a logon to the remote server.
> You need ACL to the directories/files on the remote server.
>
> Go to www.wrox.com
> Search for their books on ADSI.
> Download the source code listings.
> You'll find lots of helpful info in the code.
>
> Dallas
>
>
> ----- Original Message -----
> From: "Tim Brooks" <TBrooks@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Friday, May 25, 2001 12:08 PM
> Subject: [asp_databases] Displaying Directories
>
>
> > I'm doing the chapter 10 examples on displaying directories and
> > it works fine. My question is how can I dispplay a directory that
> > is on another computer?
> >
> > Timothy S. Brooks
> > tbrooks@c...
> > <mailto:tbrooks@c...>
> >
> > ext. 365
Message #4 by "Blake, Shane" <Shane.Blake@p...> on Tue, 29 May 2001 16:25:44 -0400
|
|
use adox...
it's described in detail in the ado 2.1 book, chapter 8
shane
-----Original Message-----
From: Jay [mailto:jtienor@m...]
Sent: Tuesday, May 29, 2001 2:51 PM
To: ASP Databases
Subject: [asp_databases] Re: Displaying Directories
I know it is a little off topic but would anyone know how, in ASP or
otherwise, I could retrieve a listing of all fields in a table and
their attributes? Basically want to be able to extract the database
design.
Thanks for any help in advance.
Jay
- ----------------------------------------------------------
Jason L. Tienor
Interactive SolutionZ, LLC
jtienor@i...
xxx.xxx.xxxx
- ----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, May 25, 2001 7:14 PM
Subject: [asp_databases] Re: Displaying Directories
> You need to use ADSI.
> You need a logon to the remote server.
> You need ACL to the directories/files on the remote server.
>
> Go to www.wrox.com
> Search for their books on ADSI.
> Download the source code listings.
> You'll find lots of helpful info in the code.
>
> Dallas
>
>
> ----- Original Message -----
> From: "Tim Brooks" <TBrooks@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Friday, May 25, 2001 12:08 PM
> Subject: [asp_databases] Displaying Directories
>
>
> > I'm doing the chapter 10 examples on displaying directories and
> > it works fine. My question is how can I dispplay a directory that
> > is on another computer?
> >
> > Timothy S. Brooks
> > tbrooks@c...
> > <mailto:tbrooks@c...>
> >
> > ext. 365
Message #5 by "Dallas Martin" <dmartin@z...> on Tue, 29 May 2001 16:31:16 -0400
|
|
Try This:
set cnConn = Server.CreateObject("ADODB.Connection")
strConn = Application("strConn")
cnConn.Open(strConn)
table_name = request.querystring("tablename")
set rsCOLS = cnConn.OpenSchema(4)
response.write("<table><caption>" & UCASE(table_name) & "</caption>")
while not rsCOLS.eof
if UCASE(table_name) = UCASE(rsCOLS.Fields("TABLE_NAME")) then
response.write "<tr><td>"
response.write Ucase(rsCols.fields("column_name"))
' response.write " = "
' response.write Ucase(rsCols.fields("column_name"))
response.write("</tr></td>")
end if
rsCols.MoveNext
wend
response.write("</table>")
rsCols.close
set rsCols = nothing
cnConn.Close
set cnConn = nothing
response.end
Dallas Martin
----- Original Message -----
From: "Jay" <jtienor@m...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 29, 2001 2:51 PM
Subject: [asp_databases] Re: Displaying Directories
> I know it is a little off topic but would anyone know how, in ASP or
> otherwise, I could retrieve a listing of all fields in a table and
> their attributes? Basically want to be able to extract the database
> design.
>
> Thanks for any help in advance.
>
> Jay
Message #6 by "Jay" <jtienor@m...> on Tue, 29 May 2001 15:45:25 -0500
|
|
Hash: SHA1
Thanks for all respondents, that is exactly what I needed. Thanks
immensely for all the help!
Jay
- ----------------------------------------------------------
Jason L. Tienor
Interactive SolutionZ, LLC
jtienor@i...
xxx.xxx.xxxx
- ----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, May 29, 2001 3:31 PM
Subject: [asp_databases] Re: Displaying Directories
> Try This:
>
> set cnConn = Server.CreateObject("ADODB.Connection")
> strConn = Application("strConn")
> cnConn.Open(strConn)
>
> table_name = request.querystring("tablename")
>
> set rsCOLS = cnConn.OpenSchema(4)
>
> response.write("<table><caption>" & UCASE(table_name) &
> "</caption>") while not rsCOLS.eof
> if UCASE(table_name) = UCASE(rsCOLS.Fields("TABLE_NAME")) then
> response.write "<tr><td>"
> response.write Ucase(rsCols.fields("column_name"))
> ' response.write " = "
> ' response.write Ucase(rsCols.fields("column_name"))
> response.write("</tr></td>")
> end if
> rsCols.MoveNext
> wend
> response.write("</table>")
>
> rsCols.close
> set rsCols = nothing
> cnConn.Close
> set cnConn = nothing
> response.end
>
> Dallas Martin
>
Message #7 by "Craig Flannigan" <ckf@k...> on Wed, 30 May 2001 08:25:01 +0100
|
|
You need to open the table you want to list fields from, for example ...
objRst.Open "Select Company.* From [Company]", objConn , 1, 3
Then to work through the list of fields, use this:
<%
For each x in objRST.fields
Response.write x.name%>
Next
%>
The x.name can be changed, to say, x.size for example. I'm not sure of the
other properties (I only know, Name, Size and Value) but this is the way you
need to do it.
Hope this helps.
Craig.
-----Original Message-----
From: Jay [mailto:jtienor@m...]
Sent: Tuesday 29 May 2001 19:51
To: ASP Databases
Subject: [asp_databases] Re: Displaying Directories
I know it is a little off topic but would anyone know how, in ASP or
otherwise, I could retrieve a listing of all fields in a table and
their attributes? Basically want to be able to extract the database
design.
Thanks for any help in advance.
Jay
- ----------------------------------------------------------
Jason L. Tienor
Interactive SolutionZ, LLC
jtienor@i...
xxx.xxx.xxxx
- ----- Original Message -----
From: "Dallas Martin" <dmartin@z...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, May 25, 2001 7:14 PM
Subject: [asp_databases] Re: Displaying Directories
> You need to use ADSI.
> You need a logon to the remote server.
> You need ACL to the directories/files on the remote server.
>
> Go to www.wrox.com
> Search for their books on ADSI.
> Download the source code listings.
> You'll find lots of helpful info in the code.
>
> Dallas
>
>
> ----- Original Message -----
> From: "Tim Brooks" <TBrooks@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Friday, May 25, 2001 12:08 PM
> Subject: [asp_databases] Displaying Directories
>
>
> > I'm doing the chapter 10 examples on displaying directories and
> > it works fine. My question is how can I dispplay a directory that
> > is on another computer?
> >
> > Timothy S. Brooks
> > tbrooks@c...
> > <mailto:tbrooks@c...>
> >
> > ext. 365
|
|
|
View Cart
