Maximum Fields
WHat is the maximum no. of fields,we can create in Ms access 2002 table?
View RepliesWHat is the maximum no. of fields,we can create in Ms access 2002 table?
View RepliesCode:
<% While not rs.eof %>
<% close_dte= rs("close_dte") %>
<% open_dte= rs("open_dte") %>
<% DUR = DateDiff("n",open_dte,close_dte)%>
<% DUR = Round((DUR/60),2) %>
<% = DUR %><br>
<%
rs.moveNext
wend
%>
this code works great and displays an entire list of durrations. So now i have this list, i want to just single out the highest or maximum durration from the list that i have just generated.
I need a general code for limiting an image size in pixels.Uploaded Images from people may not be larger on width than 400 px.
If so than a script would minimize them to 400 but if they are 260 px then they of course appear in 260 px
I have an asp page that uploads a text file, with SQL Statements inside.
After I upload the file, I want to execute the statements and then delete the file from the server.
The problem is: when I read the first Sql statement, it gives an error when I try to execute it I get a "Identifier that starts with 'INTO blah blah' is to long. Maximum length is 128.
But when I response.write the variable it shows the whole string, all +-600 chars of it.
So is this a DB Problem? (I'm using SQL Server 2000)
And how would I change it, if it was?
whats the maximum lenght of a url ?
View Replies View Relatedthe maximum size in car that i can send throught get method ?
View Replies View RelatedHow do I find the maximum value of a recordset column? I'd rather do it this way than open a new recordset with Max(column).
View Replies View RelatedWhat is the maximum number of connections that will work when using ASP pages with a MS Access database. I've seen some information that leads me to believe that up to 20 simultaneous users is a practical limit?
View Replies View RelatedI'm doing pretty well with my SE and getting all my results but I'm trying to come up with a way to have a maximum of 10 results per page. Code:
View Replies View RelatedI'm using the FreeASPUpload script from www.freeaspupload.net. It works good until I attempt to upload files larger than about 10Meg, at which point my server chokes. The documentation says I need to change the IIS upload limit.I've not been able to figure out how to do it in IIS5.
View Replies View RelatedI have a script that has worked flawlessly for a while. It allows a user to select from a listbox - with highlighted lines already of their settings, multiple lines (CTRL-SHFT) and the page updates the database properly.
Now, for some reason, I have a user that when we load their settings, all is fine. If I submit the form, immediately, with no new additional selections, all works fine. But, if I add even one new selection on the list box by holding CTRL-SHFT, the submit button no longer works at all.
This user does have a long list of selections already, I am just wondering if I may have hit a max some how?
I made a website where I am able to record how many users are online right now at my website ysing Session_Variables.
Now I want to record the date when I had maximum number of users online at one time ...
sometimes I bekome a "Server Application Error" on my w2k Server when call a
ASP page
The server has reached the maximum recovery limit for the application during
the processing of your request. Please contact your Administrator
The only thing to do is to restart the server.
Why the instruction runs ok on sql server 2000 but in access 2000 brings me the maximum size of field in the table:
SQLCategoria = "Select * from Biblioteca_Categoria where Len(Codigo) = 6 order by Codigo asc"
We have a site that has been developed in Visual Interdev that we use the PageNavBar object for the banners on each page. I have noticed that we seem to have gotten into a situation where whenever we add a new page to the site diagram, some other page loses it's banner.
Can anyone tell me if there is some numerical maximum number of pages that can appear on a site diagram? Is there some other explanation for this that I am missing? Is there a solution?
I've been doing some work on the company's intranet, and I keep getting this error message when attempting to access ASP pages..
'The Server has reached the maximum recovery limit for the application during the processing of your request. Please contact the server administrator for assistance. The strange thing is, the pages will work for a while, before suddenly encountering this error. We then have to reset the server to get the pages to work again, but then a few days later it happens all over again. what could be cauding this, or how I can go about finding the cause?
What is the maximum length of the string that can be stored in a hidden field using javascript, which can be retrieved using ASP Request object.
View Replies View RelatedI have a small ASP program ( http://www.dickbrom.com/aspsend/ ) that accepts data from a Form and e-mails it. The form has a Textarea (<TEXTAREA NAME="MessageBig" ROWS=10 COLS=50> </TEXTAREA>).
If you enter too many characters in the textarea the Submit button does not function. Is it possible to set a maximum number of characters or possibly truncate anything over a fixed number to fix this problem.i do not want to use Javascript.
I need to evaluate a field's maximum value and then do an if
conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....
whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.
I want to specify the maximum length of an image the file can upload.If the image exceeds that limit it should show me an error.E.g.; 640x480 pixels.
View Replies View RelatedI am working on a project that requires me to check the number of rows
in a table with the same HTML "ID" value.
I do this in my code with:
i = document.all(rowid).length
However, if the number of rows with the same ID is greater than 8, it
always returns 8 (not 9, 10, etc.)
Also, I am seeing a similiar response in a 2nd page when I attempt to
get the number of elements in the Form collection
i = Request.Form.Count
This also returns a value of 8 although I know there are more elements
in the collection than 8.
Is any one aware of an issue like this? Maybe some kind of setup
issue with IIS?
what is the maximum number of characters that a string variable can hold - i
initially thought it was 256, but after some testing it seems that it can
hold much more than that..
i wirte SQL statment to collect information from oracel database but after 5 minutes i got the following measage
Error Type:
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. Code:
I have 2 fields in my database. One is startDate one is endDate. I want to display records according the current date. So far I can select all records where the startDate is greater or equal to now by using
Code:
SELECT *
FROM items
WHERE itemDateStart >= now
It seems the BETWEEN claus only accepts value, not fields.
So basically I want to select * from items between itemDateStart and itemDateEnd
I have a need to be able to identify which fields within a database are key fields.I did find the Attributes property of the Field object contains information for a field in a recordset. One of those values for the Attributes property is identified as adFldRowId which should identify whether the field is used as a key, but it doesn't seem to work. I'm currently reading off an Access database.Does anyone have any insight in being able to identify key fields within a recordset?
View Replies View RelatedI have set up my database with 4 fields (num1, num2, num3, sum), and have created a form with 3 fields to insert 3 numbers. That part is easy.My problem is when i submit these 3 numbers (5, 7, 6) i want the form/script to add these numbers together and insert it into the 4 field "sum".
View Replies View RelatedI have a database table and I am building a search-like page which is supposed to pull information from the database based on the following. "Get records where field1 is 30% (or more) higher than field2 within a specific time period". Should these records be chosen by the SQL query itself?
Or should I get all the records within the time period using GetRows, and loop through them checking whether or not it fits the criteria? While I certainly feel more capable of the second approach than the first, I am not sure if its the best way when large numbers of rows are involved.
I want to create an order form for prints online... I will have up to 200 prints to be selected. What I am thinking is that I will have an HTML Form that has all the 200 thumbnails with a check box next to them. They select the ones they want and push next. Then I would like it to create a set of options for each one they selected.
That basically says the image name then has a check box for 5x7, 8x10 and a text box for the amount for each... I do I create the page what creates these selections and how to I incorporate that into a mail form going to the next page?... it seems like a simple enough idea. Am wondering how the reality of it will be.
Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value
How would I add those to fields? It may be my inexperience but when I
tried something like
rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value
didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.
Suggestions?
I have a loads of records in an Access database relating to publications. The publications come in 3 forms, pdf, Word or .htm so I have fields for each called PDFurl, Wordurl and Publink. What I want to do is, if any of those fields contain a value then display an appropriate icon (which will link to the publication).
I'm ok with the latter part but how do I determine if any of the fields have a value and if so display the relevant icon? Rather than do a load of if then statements I was wondering is there a quicker way of doing this, perhaps using a Case?
how would you join the two felds from a table in the database so it can show the image from joining the two fields to know wherethe image is coming from
Quote:
<img src="<%=(rs_lprojects.Fields.Item("image_folder_path").Value)%><%=(rs_lprojects.Fields.Item("image_src1").Value)%>" />
I have been writing out the general steps
I want to do in plain english before writing ASP.
The values come from a customised data grid (not in .NET) that is
generated according to what fields need to be recorded for that record.
What I want to try and do is as follows:
- Read form fields into input array (skip first three values :
savevalues, userid, productcode) - Save last value of every row (add to
quantity for extra info) - rest of processing
Is the first one even possible using plain ASP? I remember being able to
do it using Javascript, but I couldn't get it to work properly.
I have tried to use Arrays in ASP before, but without much success.
is there a way to write a insert statment with out typing out all of my field names? i want to do an insert in every field but i don't want to have to write them all out.
View Replies View Related