I have this page on a website in ASP which allows me to enter the Emp#. When I enter the Emp# I get all the data relevant to that Emp# like Name, Age, Address, etc
The present url doesnt change even after getting the results ( so I guess I cant pass the variable to the url) Is there any way to get all the records for employees with Emp# 1 to Emp# 2000
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?
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.
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. Code:
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?
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:
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:
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.
I am new to ASP and tried to do an ASP page up using FrontPage and Access. I have encountered a problem that even when I select all records in the database, the records are not showing in the ASP page as they shld be. Code:
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
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.
Is it possible to print multiple records wherein there should be 3 records per page.Once the supervisor logged-in, there's a link where he can print all the records of his subordinates. Currently I have a print.asp file which gets all the data and arranged in aparticular format.
I've created a tabular form(interface) with proper arrangement of data. How can I set such condition, wherein there's only 1 form, but it should be printed on the paper depends on the # of records (3 tabular form per page, where 3 tabular form = 3 records of different people)? Is it possible? Do I have to make 3 tabular forms? If I'm going to do this how will I select or use the recordset?
I got a test asp page which connects to Northwind.mdb database. This page pulls all the rows from the Customers table. One column i.e. GoodStatus has been added to the customers table. The following is the code to display all records of the customers table with some customization. Code:
I'm trying to specify how many records to be display per page. I put a limit of 40 records and i'm getting only 2 per page. The number of pages it seems ok but the records displayed are only 2 instead of 40. Code:
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.
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.
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.
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:
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".
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.
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:
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
I would like to do something like this: <!--#include file="C:dbutilsdbConfig.asp"-->
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?
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?
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.
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.
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:
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:
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'
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.