I have 40 different users. Each user manages a subset of the total database. Currently I have a pull-down menu to let the user select their subset and then manage the data within it. I'd like to use their login info to pre-select the subset so that they have access only to their assigned areas. How do I "send" the subset name from one asp page to another? the db is "2004" the table is "Students" .
I'm attempting to limit a query which is being ordered by a date field to 10 records. The date field contains duplicate values, which are sorted from most recent, back. However their suggestion of sorting by a secondary field is not providing acceptable results (it returns all the rows in the database). Does anyone have any suggestions of another way around this?
I have a database with about two thousand records, and I would like to only display about 50 per page. How would I go about doing this? I have a hunch it has something to do with the <% Do While not objRS.EOF %> code?
I'm using getrows to speed up data access time, i wonder though if there is a better way. Each recordset returns up to or more than 500 records, this is still quite an overhead for the server when there are lots of people on the site.
Rather than reading all 500 records into the array and then paging the results is it possible to create the recordset with just 25 entries?
ie if you are on page 1 then only the first 25 records are retrieved from the database, page 2 - records 25 - 49 are retrieved etc
when a form is submitted which takes it to a process page, i have 2 seperate fields called hour and min to insert into a database field, basically what i want to do is run a check on the hour field to make sure it doesnt go higher then 23 if it does, return an error, also with the min field to not go above 59
I am looking for a simple way to limit the amount of letters/Characters returned so that it does not throw off my pages styling. Basically I have the following: Code:
<% Dim SomeVariable response.write(SomeVariable) %>
If that SomeVariable has 300 characters in it it will create a very large table that it displays in so, what I want to do is limit it to say 25 or 50 Characters and simply put like .... after it. Any Ideas?
I have built and app where people can add records to a database the problem is while the next page is loading some people are impatient and click refresh adding another same record with slightly different time stamp.
Is there anyway to limit the number of records insterted to my SQL database from my asp pages to one.
I'm using the script below to limit a visitor at my site to only be able to post a form 5 times. I believe the reason I've received more e-mails is because the visitor closes their browser then opens a new one and they can post two times each time they do this.
<% count = Request("count") if count = "" Then count = 0 Else count = count + 1 End If %>
<% If count < 5 Then %> <a name="step5"></a><input type="submit" name="Submit" value="Submit"> <% Else %> This form has been submitted 5 times. Please contact me for more information.
Can somebody show me how I can do this so it will only work twice within a 24 hour period even if the visitor closes their browser and opens a new one? I would think cookies be the answer to this but what happens if the visitor has cookies turned off? If this would be a good solution can somebody please help me out? I'm not familiar with cookies.
I'm developing a page in which different users have different rights within the site. I don't even know where to start with this one because searching for anything to do with "website", "user", "rights", "permissions" or anything along those lines gives me nothing but server file permissions.
What I'm trying to do is allow anybody with a username and password to sign in, then based on their security permissions they will be able to use certain functions of the website. I want all this to be modular though...
I don't want a million IF's in my asp code. What I'm looking for is to have a list of groups, each having a checklist of functions they can perform. Assign a user to a group, and they can do those tasks.
When displaying data from a database, how can I limit how many columns are displayed on the page?
I am trying to build an image gallery, and I want it to be 5 images across by x number of rows. I know how to make each image it's own column, or it's own row, but I don't know how to limit how many columns are displayed per row.
I am able to upload files to my server using free asp upload software. But i have another requirement now.
#1) I need to let the user upload files upto 5MB only. Not more. I need to limit the size of the file. This is how i am using the file upload.
#2) I have a txtbox and button on my main form. The name of the button is Upload and when i click on upload button i get another asp form which has Code:
I need to develop an asp application wich allow users to upload files, but I need to limit every user folder with 10MB.How can I do that?not pure asp solution? each user must be a IIS/FTP user that will control that?
I am looking to return the first 50 characters from a database field. Does anyone know if there is a SQL function that returns a defined amount of characters from a database field?
This is my query.i have a access database, hooked up to dreamweaver mx. inside the database are 3 tables. sun/moons/planets. the planets table is linked to the moons table. In the planets table are the fields: planet name; Text_1; Text_2; planetID; Distance; Pic_1; Pic_2; What i wish to do is from my index.asp page click on a link which then displays the planet and EITHER text_1 or Text_2, and seperately Pic_1 or Pic_2.
I have tried using random nos 1 or 2 but i dont know how to pull the number and access the right table/field
i want to display DATA stored in Access DB by using ASP script.i can read data from access so that task is only to display data is a list like.i have a record of some users and i just want to display the users name in a list.how can i do this.
i am working on a interanet application for Inventory handling, i have a problem while submitting the data to server, the problem goes like this
Data base : Ms-Access Front End : ASP
how to comit the data "say Invoice" to main database is two persons tries to make invoice at same time at different computers, How to maintain the series of Invoice unaffected, how to allocat Invoice number to them, and how to put a check that both of them can't make a invoice of same customer at a same time at different computers.
i am wondering if there's oledb provider for DB2? and where can i get it ? we use asp, not asp.net , therefore we can't install .NET framework , is there any other solution ?
Im trying to write some asp code to copy MS Access Data into an Oracle database. I have one connection open to the access database but when I try and open the oracle connection it says that the ms access tables does not exist.
Basically what Im trying to do is get the data from a row in the Access db and insert it into a row in an oracle db.
I am using winXP pro + IIS5.1 to develop my site offline.
My data is in a folder outside the web, and I am told "my IUSR account needs to have read/write/modify NTFS permissions to the directory housing the file"
I can find no info on how actually to do this. Can anyone explain?
I'm attempting a login script where I first authenticate a user's login info for a valid connection. When I use a valid ID/Password everything works. When I use a bad user/password I get an error page stating the login failed.
I would prefer to redirect the user to another page on a failed login. This is the part that doesn't work. I'm new to ASP and JavaScript, but have done this kind of thing with PHP with no problems.
I'm using Dreamweaver MX with ASP VBScript and using a MS Access Database. For about the longest time now, I've been trying to make a Mailing List form online and when you submit the data, [data] goes into the Access Database.
The Form is obviously working fine, although sometimes I do get errors, I'm mainly trying to get this data skullduggery working. Is that even possible (with ASP even)? I have to use ASP and I can't use SQL (because I would), but I think my n00b self has tried everything I could think of. Code:
I have an access database with about 5 tables. One of which i want to populate data to. Specially 1000 enties at one time(In this example im adding employee numbers to a database table. Initially i want to add the for the employee name field " Unassigned" and when i ready to append a real employee name to the fields add if through a script(Can this be done?
Or is there a better way to do this?)This way, in my script i can call one of of those 1000 entries or employee numbers from a dropdowlist (ex. 1-1000). This way if go to use one of those entries from the dropdownlist the database would not get the " EOF/BOF error ". What logical suggestions do you guys have ?
My code show no error but the record cannot appear. My code =
if request("tarikh") = "" then tarikh = Date() else tarikh = request("tarikh") if isdate(tarikh) = false then ralat = "Sila masukkan tarikh dalam format dd/mm/yyyy" tarikh = Date() end if end if
sql = "select * from audit_trail where cstr(tarikhlogin) = '"&tarikh &"' order by masalogin desc" set rs = conn.execute(sql)
response.write sql = select * from audit_trail where cstr(tarikhlogin) = '04/02/2005' order by masalogin desc
Storing record have no problem but this code cant display any data.
I have an Access database containing 10 Tables with a lot data in each Table. I need to copy the database with no data in another directory. Is there an ASP code or object that allows me to clear data in all Table at once? How can I clear all data from Access DB?
I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo.
Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason).
Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??
I am trying to retrieve some data from a table which is the link table from another Ms Access database of my network computer but i got a error message "It is already opened exclusively by another user, or you need permission to view its data."