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.
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 RelatedI 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.
How can I know the number of columns of the .csv files? I want to import them to the database.
View Replies View RelatedI have a DB that contains several columns named Line1, Line2, Line3, and Line4. After that I there are 50 columns named Data0 through Data49. Data0 and Data1 will always contain text but Data2 through Data49 may or may not be empty.
I am trying to take the values out of the database and put them into arrays. Since Line1 through Line4 never change I have no problem getting them into one array but I am lost on the logic/syntax on how to not only determine how many Data(n) cells are populated but then how to get them into a new array.
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
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?
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 RelatedI'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?
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 RelatedI 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?
Can anyone please tell me if i can limit the amount session any given user can open at any one time?
View Replies View RelatedI'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.
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?
View Replies View RelatedI'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 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 RelatedI am moving from a Windows 2000 Web Server to a Windows 2003 Server.I have converted all of my old CDONTS to CDOSYS with no problems. However,I am having major problems with getting my asp pages that have both MySQL and CDOSYS
on them to work.I get the following error:HTTP 500 Internal Server error
There is a problem with the page you are trying to reach and it cannot be displayed
Because I needed to store more than 4,000 characters, I decided to convert one field in SQL Server Database from nvarchar to ntext...now the field holds many more characters without a problem as I examined in my online manager.
But when I tried to display it on my asp page with
Code:
<%=rs("Text")%>
, nothing showed up, and there is no error message. It cannot be null because i checked in the manager...
I'm using classic ASP. I made a change to a page and I got a Page Cannot Be Displayed error. I changed the code back and now I get the same thing. Other pages can run and access the db server.
I tried taking out includes and bypassing some code. I've also checked both the Application and Event logs on the server and there doesn't seem to be anything obvious there. I'm not using any components. Can anybody give me an idea as to the types of
things that cause this problem?
I've got an asp page that allows users to input quantities of certain items. When they click the "Total" button, the page is submitted to itself and a total for their selected items is displayed, similar to any online shopping cart.
When all items have been selected, the form is submitted, and their taken to the next page. If they choose the browser's "Back" button, or a "Cancel" button on the asp page, they get the Page Cannot Be Displayed Error. However, if they never update the total, and instead enter all the quantities and then submit the form, withing submitting back to itself, the browser's "Back" button and the asp "Cancel" button work fine.
It appears the back button doesn't work when the previous page has been submitted to itself. Does anyone have any suggestions? Is it a bug in my code or possibly an IIS issue?
I have a form from html called "rcf" and it suppose to get the data from users and send it to the database.but from my form to my add_rcf.asp page I get a "The " message.I uploaded the files.
View Replies View RelatedI get this page cannot be displayed every time i try to run ASP pages on Win 2k Server IIS5.1 . I know that the guy who's server it is had run a couple of lock down tools after his server's security was compromised.
Could this be part of the reason why? I had a look at his configuration and .asp files were pointing to 404.dll? I changed it to the asp.dll in inetsrv directory but that didn't help as well as restarting IIS.
i am tryint to access this ASP website, but it keeps giving me the msg PAGE CANNOT DISPLAY. when i send the url to my friend, it load for them just fine. can someone tell me if ther are any option i have to chang or any way of solving this problem?
View Replies View RelatedWe have two websites:
1. On Internet
2. On INTRANET
Anyone with any internet account can access to the first site, but to enter to the 2nd, u need to have a special internet account (say, a certain supplier).
The general menu is on the Internet website, but one of the items in the sub-menu, links to a page On the INTRANET. If u r not authorized (=did not use the certain internet account), then u get the page "The page can not be displayed".
How do I redirect the "page can not be displayed" to the help page, and of course, redirect it ONLY when the "page can not be displayed" page is there b/c of linking from this sub-menu, or b/c of trying to reach directly to the Intranet certain URL that this sub menu links to.
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View RelatedI have a page that displays images. However, at times if I have changed the actual image but have kept the same name and src, the old image still displays when I run the page. I have cleared the files and cookies and sometines this helps but not always.
Is there something I can do to force a change?
I know this is a simple problem,what are all the causes of this problem? This occurs to only when I don't login to the web server.
View Replies View RelatedI am unable to get this function to output the correct output. The Subtotal works fine, but the GST and TOTAL are not working properly. GST only shows the integer value and nothing after the decimal places. Code:
View Replies View RelatedI just installed IIS on my local system. Just wanted to check if asp was enabled too. but when i run the code on the browser it displays asp code. What am i missing out here?
View Replies View RelatedI have a dynamically populated page, and for one of the records the page is not completely displayed. When I click view source, the code is complete but about half of the code isn't shown on the page.
View Replies View Relatedi have 25 fields on a form vertical display and i want them to be displayed horizontal. i want to support my idea of horizontal display to my manager the reason why i want horizontal display is because the user wont have to scroll down. so i need some articles from the web or technical articles which support my idea.
View Replies View Related