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.
When users fill out my text area field, there is a chance that there
will be no line feeds or cariage returns or spaces and just one really
long word.
THIS CAUSES A MAJOR PROBLEM! What I am trying to do is
force a vbCrLf if a string is long than 80 characters in a row. So if
a string is a total of 500 characters with no line feeds, spaces, or
returns, I want to force a vbCrLf every 80 characters so that is
doesn't overflow my preview text field on the next page.
Any suggestions on how the algorithm would be for this in VBscript
ASP?
Having a little problem with this.
response.write "<A onclick=sendme() target='myNewWin' HREF='filter.asp?ins="
& insName & "'>"%>Advanced Filter</a>
I need to have a single quote around insName.
I tried the following:
Function sIn(s)
sIn = "'" & Replace(s, "'", "' '") & "'"
End Function
sIn(insName)
but that is not working.
i m passing a string like "NEW PAGE" thru the URL itself.. when i derive the value using request.querystring("<somename>") i get only NEW.. i tried to pass it thru session but still i get the word NEW.. i dont want to pass it in sessions...i need to do it thru URL itself. y such a prob occurs?
View Replies View RelatedHow do you pass a string parameter that contains a slash (for instance a date) to a com object? I pass a date with slashes and I get "Type Mismatch" with the date 05/16/1974 being interpreted as 05%2F16%2F1998.
View Replies View RelatedHow can I pass the results of a form field submitted to this statement
below?
<%
Set MyFileObj = Server.CreateObject("Scripting.FileSystemObject")
'### This Works
'###Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath("body.txt"))
'### This Doesnt work
Set MyTextFile = MyFileObj.OpenTextFile(Server.MapPath(" &
request.form("MyFileName") & "))
WHILE NOT MyTextFile.AtEndOfStream
Response.Write(MyTextFile.ReadLine & Chr(10))
WEND
MyTextFile.Close
%>
I have a page that pulls data from a database, one of the fields is Notetext
which frequently contains an email. I then want to pass this onto another
page, that updates the email field in another database, so in page 1:
strNote = rsnotes("NOTETEXT")
And to pass to the next page:
<a
href="createemail.asp?strIssueNo=<%=zero(rsnotes.fields(0))%>&strNote=<%=str
Note%>"><img src="Images/createemail.gif" width="75" height="25"></a>
It all works fine except that only about half the email gets copied into the
other database. It's not an issue with the database as it can take that
length of characters.
So my question, Is there a limit to the number of charachters you can pass
from one page to another in a string? and if so is there any way of
increasing this or getting around it?
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
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 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?
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 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 Replies View RelatedI 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: