i am currently working on code that searches an excel spreadsheet and displays results. Below is the code for the drop down. I was wondering is there a way to modify this to ignore blanks as when i use the drop down, it contains the blank cell spaces Code:
View Repliesi have a form for users to enter their name password and e-mail,i am currently using javascript to check that all details have been filled,
if(myForm.fname.value=='')
{
alert("Plz enter a first name")
return false
}
This works if the field is left blank however if the user enters numbers(1,2) or spaces i.e.(" ") how do i deal with these,i also need to check that the e-mail contains "@" and "."
I have a drop down list, values coming from a db, when I come into the form I want it to have no value - how do I do this? Also, if I want to capture the value that a person selects from the drop down list do I need to use a session variable if I want to print it to the screen after they select it?
View Replies View Relatedif I read an XML document using ASP without any encoding, ican read it fine, but if an XML document contains an encoding parameter, like the following, ...
<?xml version="1.0" encoding="ISO-8859-1" ?>
... then it doesnt work and just stops working with no errors.
Can I ignore the encoding, if so how?
I can't seem to find the right way to do this, how do I get ASP to ignore a quotation mark in a string? " doesn't work.
View Replies View RelatedI need to truncate a news article to only show a certain number of characters on the front page. the news articles often contain html and the characters in the html are being counted. So, even though I want the text to be truncated at, say, 350 characters, the final result on the page looks like it's been truncated way further up, because the text of the html added to the character count.
here's the code i'm using to truncate
URLFunction ChopLastWord( Line, Length )
If Len(Line) < Length Then
ChopLastWord = Line
Exit Function
End If
Dim spaceat
spaceat = InStrRev( Line, " ", Length )
If spaceat < Length-20 Then spaceat = Length ' value of 20 is arbitrary
ChopLastWord = Left( Line, spaceat ) & "..."
End Function
I'm using the replace functions but it is case sensitive. I'm doing a search through my DB and I want the keywords I use in the query to come out in bold so basically I do a:
Code:
strResults = searchRS("pgdescription")
for j = 0 to (Ubound(newArray))
strResults = replace(strResults, newArray(j), "<strong>" & newArray(j) & "</strong>")
next
it spits out my results but it doesn't bold them unless they're the exact same case... Anyone know a way to make the replace function ignore cases?
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
View Replies View Relatedhow can I add a space between words in my formtomail script. i know that by putting & VbCrLf & it adds a line break but I need to be able to add a space.
View Replies View Relatedi m using a simple form to cleect user info and i need to chech if the user left any spaces befor or between words and delete it for ex if the user pressed enter many times before typing the data in the text area.
it makes errors in my db so how can i check if there is spaces in the textarea ot text box and delete it?
I have a problem with the following code :
Response.write rstContacts(1).Value
The above line prints "Andark Marine"
However the following only passes "Andark" and stops at
the space. How do I get over this ? Its the same with all
records.
Response.Write("<td align=center><a
ref=companycontacts.asp?Company=" & rstContacts(1).Value
& " target=_new><img src=imagescontact.ico width=25
height=25 border=0></a></td>")
I seem to have now been able to get ASP to write the full contents of a field with spaces in it by using:
Var_Myname = "'"&rs.fields("User_Name")&"'"
<input name="txtFname" type="text" size="25" maxlength="25" VALUE=<% = VAR_UFname %>>
that works fine but when I just do a simple Response.write(Var_Myname) I end up with something like:
'James'
I don't want these quotes, so the question is can I either correct the Response.write (don't really want to do that each time.or is there a way to ge the text boxes to do their bloody job propper.
how do i remove spaces in the middle of the string?
from this:
var = "sand bag"
to this:
new var = "sandbag"
I use breadcrumbs for navigation
I have a folder called College Students in WWWRoot
in college students i have a page called mainpage.shtml
when i open the page like this
www.abc.com/college students/mainpage.shtml
i see the breadcrumbs like this
Home >> College%20Students >> Students List
but i want to see it like this
Home >>College Students >> Students List
Students List is the title of the page
Can someone tell me how to get rid of those %20 that i see when i have spaces in my folder name
I have the following in one of my asp pages:
....
Response.Write("<form action=createpst.asp method=post>" )
Response.Write("<input type=checkbox name=pstfldr value=" & myArray(i) & ">")
Response.Write("<a href = '" & strLink & "'>" & myArray(i) & "</a>" & "<br>")
Next
Response.Write("<br>" & "<input type=submit value=submit>" & "</form>")
%>
In my createpst.asp page I am trying to load in an array using the split function:
<%
Dim arrVals
arrVals = split(Request.Form ("pstfldr"), ",")
Dim i
For i=0 to UBound(arrVals)
Response.Write arrVals(i) & "<br>"
Next
%>
However, the problem is that some of my values that are read in from myArray(i) in the first asp page can be more than one word. So, when I get to my second asp page and traverse through the loop, some of the values stored that contain more than one word only output the first word.
Even when I try using LTrim function, I have one variable that has two
mysterious spaces in front of it when i pass it to the next page in a
query string
<a
href="timestar-nevada-salesview.asp?resortname=<%=rstime("resortname")%>
&resortstate=<%=rstime("resortstate")
the resortname variable gets two spaces thrown in front of it for some
reason.
I have written some code to query a database and create a hyperlink based on a value, however, if the value comprises of more than one word, the hyperlink only references the first part of the value. e.g. For instance, if the value retrieved is "the strokes", the hyperlink will only contain the word "the".
Here is my code: ....
the spaces between the words (in a textbox for example) are removed when i try to pass the value to another page for saving.
View Replies View RelatedI have the following:
<%=rs1("Address")%>
which would show something like:
555 Home Rd
What can I add that will put a + sign where the spaces are so that it looks like:
555+Home+Rd
Below this code causes and error because there are spaces within the "". I can't change the name of the field, so I need to find out if there is away round this?
<% = objRS3("Job Ref No")%>
we never guarded againsts spaces in a new site we built. And while checking, a couple of users registered with spaces between their usernames. e.g. afrika 1 instead of afrika_1. Could there be downside to this?
Just a quick one, how can I add a space between words in my formtomail script. i know that by putting & VbCrLf& it adds a line break but I need to be able to add a space.
View Replies View RelatedI have a db auto uploaded to me everyday. I am displaying information from the db, but some of the columns contain spaces. When I use a space in a select statement it obviously does not work. Is there some special syntax I need to allow for a column name that contains a space?
View Replies View RelatedI found this code on the net that will prompt a user to select open or save the file. If you run it, it will just prompt to download "whatever.doc".
The problem that puzzle me is when my filename have spaces e.g. "this file.doc", the code will replace "_" to the spaces. i.e "this_file.doc"
How do i maintain the actual filename? Code:
I am using ASP to read code from a text file that I am displaying on my
page. Because I do not want the code from the text file to be executed, I
used the Server.HTMLEncode() method to display it as it is in the file.
However, the spaces used to indent lines is still removed by the browser.
I
cannot use VBScript's replace function to replace all spaces with
because that would replace all spaces, including ones that I do not want
replaced as well as majorly increasing the size of my file. Is there any
way to display the spaces used to indent the lines without manually writing
a function to do it?
I have a View button that shows a database record of entries. At the end it has a delete link for each entry. When u click it, it passes the Address(like a house address) to a script that searchs the DB for the matching address.
The only problem is most address have spaces. I read somewhere about double quotes, or using single quotes or some combination, I don't remember.
How to keep the spaces before the description line in the following code? Right now, it displays like "Net Income", but I like to have spaces before the words like " Net Income". The database value is " Net Income".
<td align="right"><Font class=content4><%=ars.Fields("LINES")%></td> ...
y spaces are replaced in to %20 in firefox. The resulting text when viewed becomes unreadable junk like this
The%20resulting%20text%20when%20viewed%20becomes%20unreadable%20junk%20like%20 this.
I am running a select statement against a table that has several columns with the name:
like
OS Name
and
OS Type
How do I do my SQL select statement and deal with the space in the column name? Thus far I have tried putting "OS Name".. which has genterated an error Then I tried 'OS Name' which did NOT spin out an error but did not return any data either.
I have an ASP (3.0, not .NET) app that writes cookies with hyphens and
spaces in the names and values. If I had the control over the apps that will
be looking for these cookies, I would eliminate the special characters, but
as it is, I do not have that luxury.
When I write the cookies, they seem okay in IE, but in Firefox, they are
strange. For example, the cookie name is US-NONUS, but in Firefox it looks
like US%2DNONUS. For a value of NEW HAMPSHIRE it comes out in Firefox as
NEW+HAMPSHIRE.
Please note that these strings are not created in any special way: They are
hard-coded into the ASP, with no encoding or anything like that.
I have some ASP pages that use ASPmail to generate emails containing infomation taken from an Access database (the info is selected from a random record, in a particular database field, and then inserted in the email text as a variable). When the emails arrive at their destination, they contain a random space. The position of the space is completely random. It can appear in the ordinary body text, or in the lines of text generated by displaying the contents of the aforementioned variables.
eg the line in the email may say:-
I am a line in an em ail.
or
I am another li ne in an email.
or
I am yet ano ther line in an email.
Sometimes the space appears in a hyperlink and causes it to fail.....
I am running a query which basically finds the next record when comparing the date of it with the current date. Code:
View Replies View RelatedI am trying to update my table with a value passed though the
request.querystring method but as you can see from the sql statement below
it is causing errors.
In this case the name of the department as displayed is "Arts and
Entertainment" but it is giving me something strange when I try to use the
variable
update empprofile set department ='Arts%20%26%20Entertainment' where
employeenumber =219104
Microsoft JET Database Engine error '80004005'
You cannot add or change a record because a related record is required in
table 'Departments'. Code: