ASP :: Get All The Records From A Directory Page In ASP

ASP Directory Browsing Page
I'm using the code found at http://support.microsoft.com/?kbid=224364 called
Creating a Directory Browsing Page Using ASP.

The code works fine. I would like to find a way NOT to show hidden files or
folders. I don't know (if it's possible) how to test for the hidden
attrobute and create an IF condition that will allow only non-hidden files
and folders to show up.

Also, can anyone suggest how to add an "up directory" link (like you might
see in Windows Explorer) to this page?

Virtual Directory Not Accessible From Web Page?
I've got an 'include' file that is referenced in a .asp file. The include file (users.inc) needs read a .txt file (data.txt) located on another server (within the same domain). At this point, I'm not able to read that file from within the users.inc file in order to take action within the .asp file.

Here's what I've got in the users.inc file: Code:

How To Limit No Of Records In A Page ??
On entering some parameters by the user, a form comes up with the values retrieved from the database (i.e. dynamic table is generated.) Also, I have a select all checkbox for selecting all the rows.

Since sometimes the rows fetched are more than 500, I want to limit them to 30 rows per page with the option to go to new page with select all checkbox (as in yahoo, hotmail inbox) . How can I achieve this ?? Code:

How Do I Delete Records From My ASP Page?
At the load of an ASP page I would like to delete all records in my MDB that have the value of 'gmp@gmail.com' in the 'email' field. How would I do this using VB? Here is the code I have: Code:

Display Records On A Page
i want records displayed on one side of the page and the other side i have a form where users enter data using the list that they have. i am able to list the records after or before the form but not to the side of it. how do i do that.

Saving And Display Of Records In Asp Page
I need to build a asp page where it would serve as a data entry record page
as well as display page for records saved. This page should also allow
editing of records that has been saved. e.g.

SAVEBUTTON
SS# EntryBox Name EntryBox Date EntryBox Revenue Generated EntryBox

DISPLAY OR EDIT BUTTON

---------- ------------ -------------
------------------------
---------- ------------ -------------
------------------------
---------- ------------ -------------
------------------------

The process of the first part of saving record is fine. However, the second
part of displaying all the records that has been saved including the current
record saved is where I am having problems.

Search Records And Get Results On Same Page
how to create a search option that would search the recordsets in my database table.

I would be allowing users to search by name or date. I'd like the results in the same page. Any suggestions or tutorials?

Get All Records, But Display On Separate Locations On Page
I have a table with a number of 'advertisements', and each ad specifies a page display location (#1 - #9). I would like to query for all ads, but display them only where they have their location (see image above). I currently have 9 different SQL queries, one for each location:

"SELECT * FROM tb_ads WHERE f_adlocation = 1

I would like to have one query, and at location 1, simply say: "If f_adlocation = 1, then display here. If there is more than one, then repeat as necessary". Here is what my database looks like: I have attached sample data as a .txt file.

Can't Insert Records From Page With Request.form
I'm trying to insert records into an SQL database coming from a page using the request
..form method. The table "general" has a primary key 'geid .' I get the following error:

Cannot insert the value NULL into column 'geid', table 'general';

column does not allow nulls. INSERT fails.

....not sure how to include the 'geid' field into the scheme.

strSql = "insert into general (firstname,surname,company) values ('"
strSql = StrSql & Request.Form("firstname") & "', '"
strSql = StrSql & Request.Form("surname") & "', '"
strSql = StrSql & Request.Form("company") & "')"
myconn.Execute (StrSql) ....

Recordset Based On Records Selected Freom Previous Page
What I want to do is have a recordset with all records in and display a list by title with a tick box next to them, then goto a new page which the recordset is all the records that the user selected on the previous page.

Display Records From MS Access Tables As A Total In A Table In A ASP Page
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)

Joe Bloggs ---> 100 Closed

Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:

Systematic Updating Of Records Depending On Amount Of Records In Another Table
The problem concerns 2 tables, cart_products and cart_shoppingcart.

Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.

cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).

Now, what I want to do is this:

For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).

I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".

Pulling Records From End Of A Database Or Inserting New Records To The Beginning
I'm trying to pull the last 5 records from my database.

<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here

<%rs_article.MovePrevious
j=j-1
Wend%>

Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.

Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.

Grouping Records Within Another Group Of Records
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".

I have the code correct for grouping by location. That code looks like this: Code:

Directory
im brand new to ASP and all but at school they want a webpage and they wont support PHP which is what i know so i need to figure out how to show everything under a directory then if sub folders have them link to that folder

Outside Of Web Directory
I would like to do something like this:


Where the directory C:dbutils is OUTSIDE of the web directory and not
accessible by a client web browser.
The reason I would like to do this is in case somehow ASP processing
gets turned off in IIS. Since "dbConfig.asp" contains a
username/password for the database, I don't want this file to somehow
get sent back to a client browser as plain text.
Two questions:
1) is it possible to use an include file that is outside of the web
directory?
2) is there even any way that ASP processing can be turned off?
perhaps not explicitly, but maybe via malicious code or virus?

Directory To Pdf
Does anyone know if it's possible to convert files to .pdf format through ASP? or better yet, does anyone know of a utility that can take a directory of word documents and form one pdf file with the contents?

ASP Directory
I've been playing with the script at http://www.asp101.com/samples/dir_list.asp

What I want to know is if the script can be changed to 'read' from the dir it 'loads' from..

So I can just put the script is heaps of folders without having to edit the 'strPath' for each.

IIS 6 And Virtual Directory
I have an Intranet site sitting on an Windows XP server, which has IIS 6.0 installed. This Intranet site contains a virtual directory (VD), which sits on a second server and has Windows 2000 installed.

To test how a virtual directory would work for this particular Intranet site, I had previously set up the VD on the web server. Everything worked well...no errors.

Once testing was complete and the location of the VD changed to the second server, I have been receiving the following error:

Microsoft VBScript runtime error '800a004c'
Path not found

I understand what this error is saying, but I was wondering if anyone knows of any problems between IIS 6 being on a XP server and the VD on a 2000 server and any possible implications.

Get All Filenames From A Directory?
Is it possible to read the all filenames from a directory? Basically I want to grab all the filenames from a directory and make a flat file with all the values in it.

Trying To Browse A Directory
I'm trying to create my own browsing window for a directory on my webserver. I can access the root the directory and the first sub-directory but anything lower than that I get "path not found". I'm almost sure the problem is attaching the selected directories names on to the objFSO.GetFolder line.

I used the Mid function to get my selected directories. I can't figure out how to add the selected directories to the objFSO.GetFolder line. Code:

Protect Directory
I'm trying to protect a directory from users not logged in.
Let say i'm trying to protect a direcory called files.

I only want the user to acces the files when they've logged in.

http://www.sitename.com/files/filename.doc

Even though they know the name and path i want to prevent people from downloading the files.

I don't want the user to be able to send out the link to another friend without logging in.

Is this possible i'm using a wiindows server.

ASP Active Directory
I'm trying to connect to the active directory using asp. I'm having problems with logging in, what happens is the username accepted is not the user logon name but the displayname is accpeted heres the code:

ASP & Active Directory
Could anyone show me a sample, snippet, code chunk ... etc of how I can get ASP to find the Active Directory username based on a supplied email address?

For example: I want ASP to query active directory and retrieve the AD username for where user email address = 'whatever@whatever.com'

Active Directory
I was wondering whether if it was possible to insert users into active directory using ASP and then also viewing those users as well. Also, how would I implement such tasks in the most secure way?

Directory Trick?
Not sure how to address this, but...

Obviously in the SEO world, this:

http://domain.com/my-article-name

Is better than:

http://domain.com/article.asp?articleid=67

Here's the challenge though: How do you get your dynamic pages to appear as a directory rather than an asp page with a querystring? I'm fairly certain that there is a workaround to this to be able to have one dynamic asp script that appears in your address bar as a directory.

Active Directory
I have written a script to update user information in the Active Directory using ADSI. Here is part of it:

Set User = GetObject("LDAP://<GUID=" & GUID & ">")

User.Department = DepartmentName

User.SetInfo

Set User = Nothing

This works fine unless DepartmentName is an empty string ("").
Then I get error 0x8007200B: "The attribute syntax specified to the directory service is invalid."
This happens with all the attributes I have tried, including TelephoneNumber.
Do I need to delete the value of the attribute instead of setting it to an empty string? If so, how do I do it?

Active Directory
I'm trying to add a user to active directory using ASP and am receiving the
following error:-

Active Directory (0x80070005)
General Access Denied Error

Does anyone know how to get round this problem?

Virtual Directory
Is there a way in asp to create a new default web site within IIS
I am setting a content managament system and want to create a new default web site during on of the processes.
So for example if people create a new site within the admin section and call it Jacinto this will create a new virtual directory called Jacinto.

This would then be accessed at http://localhost/jacinto

Virtual Directory
Here are a couple of links that describe how to create a virtual directory programmatically on IIS.

http://support.microsoft.com/defaul...kb;EN-US;188954

http://www.vbrad.com/pf.asp?p=sourc...ate_iis_dir.htm

I haven't had a close look at the code yet but it's not in asp/vbscript

Has anybody done it in pure asp.I would like to do it on a site hosted by a third party and I am unable to install any dll's or exe's on the machine because it is a shared webserver.Both .NET and Non .NET would be good

Active Directory
We have a custom webpage that connects to Active Directory and pulls down
the users information which then creates a phone list for the office. We
have hardcoded the user name and password in the webpage which has to be a
domain admin in order to view the accounts... ( we have tried this with an
account that has access to AD but it did not work, we get access denied. The
process is we connect to LDAP which also needs to access a domain
controller. The problem we are having now is we are being told that we
cannot use a domain admin account to do this anymore... the question I have
is does anyone know another way of doing this without using a domain admin
account.

Virtual Directory
I have a virtual directory set up and it's fine. Now what I want to do is write files into them. When I try to do that it gives me a "path not found" error.How can I do this? Is this even possible?

IIS Virtual Directory
I want to write a web hosting application. But how to create a IIS virtual
directory programmatically in ASP page?

Directory On Unix
Is there a way to create directories using vb or jscript in IIS to a unix machine? I want to have the aility to upload files through my Win2k Web Server, and have those files stored on my Mac OS X Server under new directories based on date and Upload ID's from the Db.

PHP Scripts To Run In Another Directory With IIS
I would like to have PHP for windows run in another directory than
c:inetpubwwwroot. I have tride changeing parameters in php.ini in my
c:php directory. But nothing changes. When I run the phpinfo() I always get
Configuration File (php.ini) Path as c:windows. But I do not have the
php.ini file there. Is there something I am doing wrong or is it a bug.

I tried renameing the php.ini file and reseting the IIS and believe it or
not my scripts still work in c:inetpubwwwroot.

Keep Database In C: Directory
Is it possible to keep my database file (access db) in local pc (C drive)? I have created all the page with asp, the reason is that I cannot set the server path to write on the database if it's save under server.

I am only running all this file in one pc. how can I change below statement if I want the db file save in the local c:...Tks

<%Dim DBPath, connstring, conn
DBPath = "score.mdb"
connstring = "PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=" & server.mappath(DBPath) & ";" & "Jet OLEDBatabase Password=welcome"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstring
%>

Path Name Of FTP Directory.
I'm trying to find out the entire path for the directory on the web server that I use for FTP'ing.

I had an ASP script which did it for me once before but I've lost it. Does anyone know how to retrieve the full path name?

ASP To Active Directory
I would like to write an ASP ap that asks for username/password and
validates against the active directory. Any ideas how/where I can do this?
In addition, once these people are logged in I want to be able to send the
to exchange's OWA and just be logged in, no second login/password.

Directory Listing
At work I was asked to add a link to a directory listing page. This page is with the link is located behind a secure page requiring a username and password. When I added the link I also went to iis and checked to make this directory have directory browsing listing checked.

Everything is fine however now this directory is open if you just post the complete link to it in the URL bypassing the login page. Is this a nornal behavoir and is their anything that can be done to make it prevent it to be opened?

Directory Structrure
Does anyone know any good tutorials / websites that show directory structure.

Ie like windows explorer but on the web in asp.

so that i can click a file and edit, rename, move.. so on and soforth

Asp And Active Directory
Is there anyway that I can add user to the active directory with asp?

Because I found one code to view information but not to add. Or if you can tell me where to see the command for asp and active Directory.

Virtual Directory
I have a website hosted on an ISP server, my code creates folder and places files in it using the FileSyestemObject. The problem is that I have to write the absolute folder/file path in the createFolder method, and I don't know the absolute path on the server, when i use relative path, the folder is placed on the system32 directory as the root folder (That is where the ASP dll is located). So how can I create folders and files on the virtual directory without knowing the physical path.

Virtual Directory
I created virtual directory(IIS) in which i placed images and scripts.I referred this directory from my application(ASP.Net).But during run time this folder is copied to my application root.How can i avoid this.

Virtual Directory
I used KB 308150 as a guide to create a virtual directory shared by a few webstores that my company hosts. The virtual folder and websites reside on the same box. The shared directory includes code files used by all the webstores.

The problem - when a user adds items to the shopping cart, ***sometimes*** the session variables get reset and all cart information is lost.I can't consistently make the error occur - it seems to be random.Also, if you have any different ideas on how to share code between many websites.

Securing Directory
I have a client who has a password protected page via session that lists a bunch of pdf's.They are a little worried that you are able to browse and see the pdf's via the url without being logged in.

I'm not sure if it's possible or not but is there a way after their username and passord is verified to automatically grant them permisson to view the contents of the pdf directory?

Directory Upload
where to find some decent code samples for using SoftArtisans FileUp Professional.I have used aspUpload to code a webpage to upload select files, rename them and check they have the right file extension but now I need to do the same for uploading the contents of a selected directory.

Directory Browsing
it is possible to add ASP code in the page displayed during the directory browsing.This page is returned by windows and lists all the files and directories contained in the current directory.The page that I'm talking about is something like:

Server IP address - /current directory/

[link to parent directory]
day, month day, year hour size file name1
day, month day, year hour size file name2
day, month day, year hour size file name3
...

Indicate The Parent Directory
I have a software that has generated a code for me, not sure if I'm allowed to give out names of other companies on here so i won't for now. anyways, the code has worked for a long time on my server just fine. Until I got a new server, same operating system and everything, i just cut and paste everything over from the old server to the new one. But for some reason now one of my sites will not let me use ".." in my code.



I would just place the "2020applicationsconnections.asp" file in the folder my current file is in, but then that messes up all the the linking that the "2020applicationsconnections.asp" file had in it. So is there any phrase, symbol, ect. that i should use to indicate a parent directory in this code? or is there some setting i need to change on my server that was set up on my old one.

Ftp Directory Permissions
can someone explain to me what the following privelages . eg. in one folder i want my database to be written to, but not allowed to be downloaded as a single mdb file.

in another folder i want my user to be able to upload images into it freely. other folders i want untouchable. here are the settings my host give me. if somebody could explain to me what the different users are. what certain settings will allow. in terms of ftp and website use.

here are the settings i can apply to each directory/file ....