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?
ADVERTISEMENT
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 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?
View Replies View RelatedGetrows, 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
View Replies View RelatedLimiting Data Access
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" .
View Replies View RelatedLimiting 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?
View Replies View RelatedLimiting Number Of Records
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.
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?
View Replies View RelatedLimiting 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?
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?
View Replies View RelatedDatabase Limit - Microsoft JET Database Engine Error '80040e14'
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
Microsoft JET Database Engine :: Cannot Update. Database Or Object Is Read-only
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
Database Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
How Do I Export Data Fom Local Database To Server Database?
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Microsoft JET Database Engine , Database Or Object Is Read-only
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
Using Value From Database Updating The Database And Resuing The Value
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedMany-to-Many :: Seperate Database Or One Database?
Products ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
Web Database
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
Do While Out Of A Database
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies View RelatedASP With Database
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
Database.mdb
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
Database Not
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
Job Database
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
Same Database
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
Database
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.
SQL Database
This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
ASP - Database
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example :
If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
but i want to get with separate variables.