Select By Length
in my asp code i have a part that selects 10 products at random, and then displays in a right hand menu as links.
however long titles tend to run over 2 lines, and dont look right clever.
I was wondering if i can add a length to my sql
for instance select * from products where prodname.length < 10
how do i do that, PS i am on mysql server
View Replies
ADVERTISEMENT
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?
View Replies
View Related
I believe that it's possiblte to set the length of time that a visitor to a site can be inactive before their session time's out, but I don't know what the coding is or where it's placed. have never had to bother with this, but I've just started with a host, whose server seems to time-out my session after like 4 or 5 minutes
View Replies
View Related
whats the maximum lenght of a url ?
View Replies
View Related
I think an url variable could be limited, maybe someone know the maximum length I can use ? (I try to send an html code with the get method, maybe some symbols could not be accepted in url).Is this length limited for a variable or for the url string ?
View Replies
View Related
I have a webpage with a form and i am saving the webpage using name value pairs. So i can give the users a link which they can click on and the form will open up prepopulated.
The problem i am having is that these forms can get exteremely long (hence the prepopulation facility) e.g test.asp?name=value?name1=value1?name2=value2
is there any way to increase the url in a browser or if you know of any other way i can accomplish this id appreciate ure feedback more detail regarding the above: I am allowing useers to save their forms with the data, also save multiple versions of the form (same form with diff data).
View Replies
View Related
I have a question about the Max Referer length. By default this is 256. I am not fully sure I understand this property. It this a header that is sent back to the Server by a client and is it part of the URL.
While testing our Secure IIS I ahd the error come up I increased the value to 1080 and the error did not repeat!. But through my search the Max Referer lenght is always 256. SO I am trying to get feel for what the Referer really is, is it part of the HTTP 1.1 protocol?
View Replies
View Related
i have a webpage containing a textbox (textbox1) and a label(label1).As the user is typing into the textbox i want the label to show the amount of characters they have typed. How do i go about doing this?
View Replies
View Related
How can I find the Max length of the QueryString?
I am passing data between ASP pages and use the Response.QueryString (I know
that this is not the best method). Is there a limit or is this configurable?
View Replies
View Related
I am reading an recordset into an array using getrows, but my recordset has 38 records but my array has 46!!
If I loop through the array, it errors on number 38 (as expected). I am using UBound to find the array length.
can anyone think what is going wrong, without the need to post my code (step 2!)?
View Replies
View Related
I previously had a post on a problem with the Microsoft SQL server, when I was trying to compare a record in the database with an inputed record, if the record in the database was not exactly the same length as the inputed record, it would not match. i.e. user codes = OAK,BRANT,QUYOU etc.
Unfortunately these records have already been made and they vary in length from 2-5 characters. Im programming in VBscript, does anyone know any functions which will rectify this problem?
i've tried the trim function but this has no effect, I could just change the length of the column so that they are all a similar length and thus will all be comparable, however this is certainly not ideal as an id code only two characters long is not unique, some of the records will clash.
I would like to avoid changing all the records as there are 25 different codes for about 10,000 records. im sure there is some code which could accomplish this but ideally I would like to solve the problem at source.
View Replies
View Related
We have web site on IIS 5.0 for sending purchase-orders to database on MS
SQL through ASP and ADO. The purchase-order is being sending to .asp script
as web request, but the script recieves only the first 2088 characters of
request. Is it possible to increase this parameter somehow, or to set it
unlimited? Does the IE limit the request length, or IIS?
View Replies
View Related
I want to load an asp page with a very great variable part (something like save.asp?myvariable=aa...zzzzz
I know the length of aa...zzzzz is limited to 255 characters. But I would like to be able to send a request of length, let say of 2500 characters.
View Replies
View Related
I need asp code for validations that needs to check if the value of the querystring variable received was alphanumeric and length of 7 characters. This querystring will be passed from another site so I am not doing client side javascript validations . If the length of the querystring variable is more or less than 7 then a user friendly error message be displayed.
View Replies
View Related
I have a text box within a form that allows for Codes to be inputted.What i want is for an error message to be displayed and the form to be prevented from being submitted, if the code length inputted is less than 14 characters.I'm using dreamweaver and i have already set the text box to restrict the maximum character length to 14 characters, but there does not appear to be a mimumum character delimiter option available.
View Replies
View Related
Categories are beïng used out of a database to make a menu, example given:
menuitem 1 | menuitem 2 | menuitem 3 | menuitem 4 | ...
This all works, but the table width can only be 770 pixels.
If the menu structure is going to be wider than 770 pixels it has got to be devided into 2 or more lines.Is it possible to determine the pixels word by word?Or is there another possibility?On Google I read it would be possible in java, php,Only I didn't find anything that refers to ASP.
View Replies
View Related
I'm really at wits end on this as I'm not having much success with locating a function or other options I have. I'm working on a message board for a website and I'm needing to check the length of the words that users put in.
For example, when someone puts in "yesssssssssssss!", I put together a small function that omits all of the s's as this is wreaking havoc on the layout of tables within the site. But I don't have a solution if someone types in "ssss sasdfjskldjfaskld;jfaskdf" as random ambiguous letters.
I know I can check the length of the entire string but don't know to check the words
within it.
View Replies
View Related
how to determine password length using asp...or vbscript. can you include a simple program about password length or any site reference.
View Replies
View Related
How do I set the max length of a text area. Say, only 200 char.
View Replies
View Related
I know that using Session.Contents is frowned upon by some.
But I feel I am in situation where I cannot avoid it. I think it is better
than using a QueryString.
Is there a length on the Session.Contents variable length
i.e., Session.Contents("myVariable") = "............"
what is the max length that can be set for myVariable
View Replies
View Related
In my database table , I have field to store the text, I am tryinf to find the length of the filed in ASP like below
response.write len(rs("cname1"))
It is displaying the value , when the data in the field is nonzero, it is not displaying anything if the filed is mty in table. I cant understand y it is displaying the length as 0 , bcaz i want to compare the length , if the length is zero , it will display one result or else it will display the value.
View Replies
View Related
Scenario: I have an ASP form that serves to the browser, anything from 1 to 20 rows of textboxes. How I've implemented this is that the user specifies in th previous page how many rows he intends to add, and then the form uses that value in a FOR...NEXT loop to serve the HTML that creates those textboxes. Each textbox is given a unique name based on the current iteration of the FOR loop.
Now, where i've had a prob is that on the submission of this "variable-row" form, I'd like for ASP to be able to tell me how many rows the user entered. I tried using request.form.length already, but no luck there (ASP says it's not supported).
View Replies
View Related
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 Related
I have an integer variable wich always ends with a "0". I have to remove this "0".
Example:
43997680
should be:
4399768
Can someone please give me the code?
View Replies
View Related
I have problem with multi-language string values. I have an input box, which accepts max 75 chars. Value goes to SQL server table field VARCHAR (75). it was okay with english language but error comes when saving Arabic or any RTL language.
I checked the values by
Response.write len(myRecievedString)
OutPut:
Lenght of String Containing 75 English chars: 75
Lenght of String Containing 75 Arabic chars: 525
Shall I increase the size of table field?
View Replies
View Related
I currently have a program that crashes if the sessionid is longer
than 9 digits. Is there a way to trim the length of the string that
IIS kicks out and limit it to 9 digits, or if that can't be done, is
there a function I can use to trim the 10 digit string down to 9
digits?
View Replies
View Related
Can someone tell me the maximum character length of a variable passed to an ASP page via a POST form (i.e. not through the querystring)? I read somewhere that said it was 1024 characters but that can't be right.
View Replies
View Related
Just a thought, the code below checks to see that an email address submitted from a form check to see if that there is an @ sign and if the length of the email address is greater than 0.
If InStr(request.form("email"), "@") > 0 then
sSender = request.form("email")
Else
...
I can assume then that the code about makes the LEN function redundant?
If len(InStr(request.form("email"), "@") > 0) then
sSender = request.form("email")
Else
...
View Replies
View Related
I just alanyzed the response of my ASP and discovered that the header
"Content-Length" was added twice. I've double checked my application , but
it only adds it once, so I think IIS has also added this header. Is there a
way to "overwrite" the header added by IIS or to tell IIS not to add this
header information?
I have a huge amount of very small responses, so the header may be a
reasonable part of the whole response and I want it to be as small as
possible. I need to add this manually, because for some responses I use
Response.Flush - so IIS simply cannot be sure what amount of data will be
there.
View Replies
View Related
Alright what I need to be able to do is to make the field it's maxlength if the user does not enter enough characters.
<input type="hidden" name="B" size="10" maxlength="6" value="">
so basicly if the user enters a 5, 4, 3, or 2 digit number the input will be forced to it's maxlength. I need this because I am writing to an SQL db and am combining multiple form inputs into one field in the db table ie(variable = A&B&C&D)
On a different webpage I need to display the variables. I am doing this by string manipulation functions like the one below.
Nbr = mid(aTable1Values(DATA, aRowLoop), 6, 6)
(DATA = A&B&C&D)
View Replies
View Related
I'm working with a file upload form and want to evaluate the length of the filename and if it's greater than 12, cut it off as such:Code:
StrFileName = Form("SourceFile").FileName <--show the whole name if its less than 12, or
StrFileName = LEFT(Form("SourceFile").FileName ,10) & "..." <--cut it off after 10.
I don't know how to evaluate the form input length and do the if then's based on it, though.
View Replies
View Related
I 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?
View Replies
View Related
Access Database
Field required = no
for i = 0 to 2
arrParap(i) = MakeSafe(Request.Form("ppara_text"&cstr(i+1)),2400)
arrImgp(i) = MakeSafe(Request.Form("pimage"&cstr(i+1)),50)
arrImgpPos(i) = MakeSafe(Request.Form("pimgpos"&cstr(i+1)),50)
if len(arrParap(i)) > 0 then
strQp1 = "INSERT INTO paragraphs(para_page, paratext, paraimage, imgposition)"
strQp1 = strQp1 & "VALUES ('" & objRS1("Subcateg_id") & "', '" _
& arrParap(i) & "', '" _
& arrImgp(i) & "', '" _
& arrImgpPos(i) & "')"
objConn.Execute strQp1
End If
result
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Field 'paragraphs.paraimage' cannot be a zero-length string. /content-builder/admin/pageadd.asp, line 53
View Replies
View Related