ASP :: Limiting Data Access

Limiting Results From An Access Query
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?

Data Type Mismatch When GETting Data From An Access DB
We are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.

THE RESULTS:
(returns a blank page with only HTML Titles)

THE SCRIPT:
(you may notice this is a modified sample script): Code:

Limiting Duplicates
I am required to prevent duplicate posts........how can i do this?? my database is MS Access and am using ASP.

Have been scratching my head fo quite some time now........cant figure out the logic.

I understand i cant limit it from the database....if possible i'd like to know how to handle the error that it would give with a page with message

or how can i compare the entry from the database before i post it

Limiting Database
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?

Limiting Size
How does one limit the amount of characters being entered into a <textarea>. I know we I can maxlength="50" an <input>, but what about a textarea?

Getrows, Paging And Limiting
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

or will this slow things down?

Limiting Number Range
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

Limiting Characters Returned
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?

Limiting Users To How Many Session They Can Run
Can anyone please tell me if i can limit the amount session any given user can open at any one time?

Limiting Number Of Form Submissions?
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.

Limiting User Abilities By Group
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.

Limiting Number Of Columns Displayed
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.

Limiting The Size Of Uploaded File
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:

Limiting User Size Upload
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?

Limiting The Amount Of Characters Returned
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?

Asp+access Data
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

Access Data
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.

Access Data
i want 2 asked 2 howwe can acces the data from database using combo box.and how we can save the data to the database from combo box.

Data Access Via ASP
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.

Use Asp To Access Data In Db2
is there anyone use asp to acess data in db2?

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 ?

or i can only do that through ODBC ??

Data Access Permissions
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?

Data Access With JavaScript
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.

Can't View Data In Access DB
I have a datbase (db2.mdb) on the server

Here is the information:
DB name-Addresses
Input - user
Input - password

Here is the script that I'm using to try to view, unsuccessfully, the user in this database. Does anyone see the error? Code:

Data From ASP Web To Access Database
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:

Populating Data With Asp And Access
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 ?

Cannot Show Up Data From Access
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.

How Can I Clear All Data From Access DB?
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?

Entering Data Into Access.
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??

Retrieve Data From Ms Access
How can I retrieve data from Ms Access Database which is located in another computer over the network.

Retrieve Data From MS Access
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."

Access Data Base
a website connected to access database, i have a table which contains the names of all ppl members and users, users table. if someone can help me in giving me the code of a login page .. how it can check if the password and username are correct, i had already entered information of few users for testing. by the way i dont use java messages, i have to give a message wich will be shown in a new page and the user should press back button to retain to the login page.

Access Data To Excel Using Asp
I have an intranet application written in asp using access as the backend database. My users have requested they be able to download certain data into an excel spreadsheet. I have limited asp experience and could use some help.

Ideally, the user would be prompted to save and name the file (save as dialogue) and then the data would be selected and saved into that file. I know I can use a select statement to select data directly into an excelspreadsheet using:

SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable

But I'm not sure that is the right approach.

Data Not Saving In MS Access
I have an MS Access database within the same folder as the web pages on my IIS server. I input data into the forms but the data isn't being saved to Access. Is there a problem with this code?

Migrating Data (MS Access)
if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml?

Input Data In Access Db
I think u don't seem to understand my question. I'm not talking about ur coding. what do type in the url address to open ur htm page? is it D:messageform.htm or something using http:// ?

Retrive Data From Ms Access
i am designing a database using Ms Access and ASP. i have 3 tables in access namely 'PERSONAL', other as 'POLICY' and 3rd one is named as 'STAFF'. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, amount_paid, amount_balance and similarly the 3rd ie., staff has few fields. all three are linked my a common field which is ID

all i want is when the user searches for a perticular name (from frontend) it should search through table- 'PERSONAL' (fields- Name and Children). once it get the perticular name with the help of the ID it should retrive the datafrom both 'POLICY' and 'STAFF' of that perticular Name.

i do know how to search and retrive data from the same table but got a bit confused on how to retrive data from different tables using the 'PERSONAL' table just for reference and linking to the other 2 tables.

Data Into A Access Table
I have coded a form which enters data into a access table however I want the same recordset when clicked to go to another table in the same database then when clicked again to go to another table within that database...is this possible?

Access Data Base
This error occured with me when i want to open my access database:

----------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x888 Thread 0x1288 DBC 0x2e8f014 Jet'.

/AAA/Afghanistan.asp, line 374
----------------------------------

Data Access Timeouts
I'm beta testing a community membership site using ACCESS/asp on IIS5/windows server, shared with other sites. The performance is not consistent - sometimes OK, sometimes very slow and sometimes data access scripts time out (even when timeout set to 5 minutes) - sometimes the server recovers, and others a re-boot is necessary.

Can some one tell me if there are (or where I can find out if there are) performance issues involving 1. shared servers 2. incorrect data access set-up resulting in data access (e.g.concurrency/record locking, etc) problems 3. possible sloppy asp coding resulting un resource-hogging/non release, record locking etc.

Displaying Data From Access
I am trying to display a vaule from access (which is set to currency in access) as a currency (2 dp) on a web page. Here is the code: code:

Dim rsDB
Dim strSQL

Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )

rsDB.Open strSQL, Application("strConn" )%>
<p><b>Product:</b> <%=rsDB("ProductName" )%></p>
<p><b>£</b><%=rsDB("ProductPrice" )%></p>
<% rsDB.Close %>

Should be easy enough, but I'm just starting out.

Retrieve Access Data
I am using access database to store test results. Each test is asigned a automatic ID number in access. I have all the data collecting fine to the correct columns but had to add a new column named (comments) to the database and this column is made to store students comments on the tests. I created a new, view comments page where the students can view comments on the tests.

The problem I have is, I need to be able to bring up the info from the comment column by that asigned automatic id number thats asigned to the test. I can get it to show all comments on all tests but need to be able to view comments on each seperate test and each test has a diferent automatic id number.

How can I bring up the comments to view by the automatic number thats asigned to each diferent test? We need to view all comments that were made to each individual test by that tests automatic id number and using asp. This has got me puzzled to view comments to each individual test thats asigned with an automatic number generated by access database.

Access.mdb Data Connectivity
Does ACCESS or a server behave like ACCESS on a local machine? - in particular are there the same query performance advantages in applying indexes to certain table fields?

Hiding Paths In ASP To Data In MS Access
Does someone have a reasonable method for concealing the paths to data when using ASP to MS Access?

I maintain a website where some data is intended to be released according to date:time. Some visitors like to "jump the release date" and just copy-n-paste the visible short cuts so they can get an early view of the material stored in a MS Access database.

Because I do want to continue using a straightforward naming convention for the various files, I was hoping someone might have information on how they had kept from pre-releasing information in this situation.

Inserting Data/time To An Access Db
i have an access db with a "date/time" data type with a format of "Long format";
i want to add the date/time automatically in DB when a user submit a form.

i tried using the
xdate = formatdatetime("var",1)

and putting that var in the DB, but i get an error

can someone show me how to do it right?

Data Type Relation Between SQL/ASP And Access
I am trying to insert data from one table to another but it always errors me on type mis matches or parameters.

Basically the SQL statement looks like this:

sql6 = "Insert Into tblWeeklyFixtures_Div3 Select * From tblAllFixtures_div3 Where GameDate > date() <=date()+7"
conn.execute(sql6)

and it gives me error:

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/DIGFootball/Admin/FriDiv3/update2.asp, line 142]

I tihnk it has to be that i havent declared that i will be importing into a Date/Time field in access but when i change this in acess it gives me more errors so for a peacful life i chnaged the field back to text but by doing this the above SQL statement is pretty useless.

Data Loads Slowly From Access...
I am using a script for my site's songs,

Forexample Song is: ASP Song
And Artist is: SitePoint

It shows the songs data in the form of:

<td height="-1" bgcolor="<%=co%>" class="t">
<a href="player.asp?song=<%=rs("song")%>&artist=<%=rs("artist")%></a> by <%=rs("Artist")%>
</td>

It produces like : "ASP song by SitePoint" on songs.asp

But the problem is I have 62 songs, And they takes a lot of time to load,

Is there any other way to call the song details from the database and it will load fast ?

Passing Data In Text Box To Access Db.
i have 2 text box whom data are generated randomly, how can i get this data and pass it to a access database using ASP?

Access Data Retrieval And Creation
Already have an asp page showing results from an access database table (supplies)
Need to know way select items from this list w/o the need of retyping to another form.
Also would like to be able to insert order_date automatically to another access table (orders).

Pulling Data From Access Database
I have an access database from which I am pulling records. The main table contains all the info for a specific person and their business. I am retrieving the data and sorting based on last name, and I am also retrieving and sorting the data based on the specific region a person is in.

What I would like to do is also sort based on a sector that a person’s business is a part of. I would be able to retrieve all the records for each sector and sort them just as I did with region, but I don’t want to list ALL the sub-sectors. Code: