Does anyone have an example of how to replace all whitespace at the end of a string?
I'm trying something like:
do while right(str,1) = " "
str = replace(right(str,1)," ","")
loop
response.write("str:" & str)
.... but it is killing off the entire string ...
when it writes the varFault option to SQL, there is lots of whitespace written too!I have tried the Trim option but to no joy
<%@LANGUAGE="VBSCRIPT" %>
<%OPTION EXPLICIT
Dim objConn, strSQL, objRS, varName, VarExt, VarFault, varDept, strSQL1, objRS1
Set objConn = Server.Createobject("ADODB.Connection")
objConn.open Application("helpdesk")
varName = Request.Form("name")
varDept = Request.Form("departments")
varFault = Request.Form("txtFault")
strSQL = "INSERT INTO new_calls (Name, Department, Fault) VALUES "
strSQL = strSQL & "( '" & varName & "','" & varDept & "','" & varFault & "')"
strSQL1 = "SELECT * FROM new_calls "
strSQl1 = strSQL1 & "WHERE call_id= '"'
set objRS = objConn.Execute(strSQL)
%>
Say I have a 'Mc Paul' in the database, what would i need to do if the user searched for 'McPaul' how could i pull that record out of the DB.
View Replies View RelatedI am using a xml parser to retrieve and scan through some HTML from a website so that I can use VBScript operations (Left, Right, Mid, Len etc) to pick out the data that I require from the responsetext.
The code works very well and I am attempting to validate the data that the code finds by comparing it to data in a database. Below is a section of code that extracts race locations from a website. Code:
My form gets populated from an access database. Now in the database there are fields containg <br>. While in a normal page everything works as it's supposed to, in my listbox the <br> shows as it is. What I would like to do is replace it with a space so I've used this:
<option value="<%=(rsProducts.Fields.Item("CatNum").Value)%>"><%=replace(rsProducts.Fi elds.Item("NotesR").Value),"<BR>"," "%></option>
but it doesn't seem to work.
What exactly am I doing wrong here?
All of a sudden this morning my ASP files started generating the error:
Out of String Space: 'Replace'
These script files have been running just fine for several weeks with no
problems. I did review the code and yes the script is calling the
Replace function at the line specified in the error information.
I'm puzzled as to why the code would all of a sudden start generating
this error ?
My site seems to preload everything prior to displaying itself. I get a white screen for a couple of seconds and then, bam!, its all loaded and displayed.The same happens when the user navigates around the site. In between each page there is a white screen and a delay.is there anything I can do to minimise this white screen delay?
View Replies View RelatedThere is a problem which confused me for a long time. I have a web application built by ASP running on IIS, and most time it's OK.
occasionally when IE send request to IIS and then receive HTML from server it will stop with no reason. IE shows a white-screen and then I check the HTML source and find that only partially received. After I press F5 everything is OK again...
I was calling another asp page from my main page. The another page contains lot of code and processing But after some time my page has turned white and curosr shows that sytem is still busy. Why this happened ?
View Replies View RelatedI have two sites, one is a white label version of another. they both use exactly the same code.
The site that isn't white label works fine. Hover the white label site gives the following error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'left'
/list.asp, line 234
I've looked at line 234 in list.asp and it is just a SQL expression that doesn't appear to have any problems: Code:
If I replace "a" with "b", and then I replace "b" with "a", shouldn't I get the same result? That is what I am trying to encode and decode with Replace() function, but it is giving me different things when I replace and replace again. Here is what I am talking about: Code:
View Replies View RelatedUsing IIS 5.0 and sometime some asp pages (absolutely
randomly) showing as blank white pages. So far only one
way of fixing it - restart whole server. Restarting IIS,
or specific web server not helping, only whole server.
I enable server side and client side debugging, but no
errors showing up...
In view source pages always look like this:
-----------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1251"></HEAD>
<BODY></BODY></HTML>
-----------------------
Any idea why it can happened and how to fix?
i have a form where a user will enter their information.... i know how to check if the user didn't enter a value so that they are not redirected to the next page but how to check if the user pressed space and not allow that space character to be a valid character?
View Replies View RelatedI have a webpage with some hyperlink within a button. The problem is that some of my hyperlink is shorter that others and therefore the user must navigate to the hyperlink to click on the link
The thing I want is to make the button more user-friendly user can click anywhere on the button and not only on the hyperlink within the button
Here is my code ....
In an ASP Page is there a way to have a link that calls another page whose name includes a space? For example, I'd like to be able to call "My Page.asp" by building a href type link the user can click on. The equivalent of:
<a href="My Page.asp"> Open </a> the page
I've tried URLEncode but that didn't work.
I’m reading a list of values from a database table a creating a dropdown list on a web page. These are used as search criteria to search on a second table. The user selects and item from a list and then clicks a button to submit the search. All of that works.
Most search words in the list are a single word with no spaces. Some are two words. When that is passed, anything passed second space gets lopped off. Here is the line of code that creates the dropdown box
sDataSet = rs1("Dataset")
response.write "<OPTION selected value=" & sDataSet & ">" & sDataSet
I tried this, but it didn’t work
response.write "<OPTION selected value=" & Replace(sDataSet, “ “, “%20”) & ">" & sDataSet
It replaced the space with %20, and the entire search phrase was passed, but the search failed because the %20 was not converted to a space on the other end. So now I doing the conversion myself after I do the Request.Form. Is there a better way though, to deal with spaces.
i need to combine 2 vriables that are retrieved from a form. idate and
itime.i want to put these into the t_date field in my sql db. but for it to work
properly, there needs to be a space between the idate and itime.
how do i do this?
i know i should know this, and i have used it before. but it has been so
long, that i can't remember for the life of me.
1. dopage.asp?<% =SessionID=value_here%> is different tha
2. dopage.asp?<%=SessionID=value_here%> ??
Please note that there is a space between the asp tags and the = sign in the first item. I thought ASP will treat #1 and #2 as the same. However it seems that is not the case.
can anyone fix the space problem in my sql statement? I am getting this error message:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
This is my sql statement:
sql = "SELECT * FROM " & tblname & " WHERE " &Col& " = N'" &Var& "' AND [Show]=1 ORDER BY [Code] ASC"
And I am passing the parameters to the url something like this:
Product.asp?Visit=Yes&Var=Hong%20-%20Kong&Col=Place
Problem is that most of my data contain a space (eg. Hong Kong).
I don't have this error when my data is single word (eg. Sydney)
I want to check the disk drive space on a small intranet. Like 30 computers. All have been partitioned and have a D: drive that is shared and is the drive I'm trying to check. This is basically what I have tried:
Code:
Dim fs, pcdrive, cdrive, n
Set fs=Server.CreateObject("Scripting.FileSystemObject")
Set pcdrive = fs.GetDrive("xx.xx.xx.xxshare01-d")
Response.Write("Share01 Free Drive Space is: " & pcdrive & "<br>")
set pcdrive = nothing
set fs = nothing
Is there something wrong with the code or would it possibly have to do with permissions? When this script runs,I get a page cannot be displayed.
I'd like to know how can I make the first letter of every word on a textbox field, uppercase, automatically. I'd like to use this for the Name and Surname field, but I don't know how?
View Replies View RelatedNow that my website is compleate(ish), I am looking for server space(for free) to host it on. A lot of the ones I have seen, for some reason, do not support classic ASP.
View Replies View RelatedSometimes I am getting the errormessage "Out of string space ". The error occurs on this code:
sBrf = sBrf & sBodyTmp & "par page par "
When this occurs len(sBrf)<100.000 and len(sBodyTmp)<10.000. Also there is about 1,5gb fysical memory free. I am using Windows 2000 IIS5. I tried isolating the proces in IIS to make sure no other scripts are involved, but it doesn't help.
If I try to retrieve a char field from MySQL with 11111111
in the field I have no problem, however if I put in: 11111 111111
then it doesn't retrieve the part after the spaces it seems to just chop it at the first space. Can anyone help my with the code to make it work.
where i can find a myspace clone?
View Replies View RelatedI trying to find the memory occupied by the object in RAM, For Example:
Set ObjTest = Server.CreateObject("ADODB.RecordSet")
I need the space occupied by the ObjTest in RAM. Is it possible ?
We have a regular ASP page that loads data from a database. It looks "normal" in IE or any other browser. When I print it on legal paper, there is an enormous gap between the header graphics and the first section where data is presented.
If I print on standard "letter" paper, this gap doesn't exist. Is this an issue with ASP or is there something really bizarre going on with my printer or IE? No other applications seem to have problems printing on legal paper.
I am calling my procedure like below
Rs.Open "MyProcedure "&myvalue, database,1,3
en MYprocedure is below:
@Keyword nvarchar(30)
...
select *.................. like @Keyword .........
but if myvalue has a space it doesn't work!
I tried:
Rs.Open "MyProcedure '"&myvalue&"'", database,1,3
it worked, but it didn't give any result!
How can I use space in myvalue ?
who has free web space for forum?
View Replies View RelatedI have a page that writes a hyperlink to files in a folder, but the
hyperlink fails with the space in the filename. How can I strip out that
space or replace with ? Code:
I am trying to open Exel file and Csv file from the website. =if sFile name contains white space (test file.xls), the file openining with some error. Error contains some session variable.
my code is as follows.
Response.Buffer = TRUE
Response.Clear
'Response.AddHeader "Content-Disposition","inline;filename=" & sFile
Response.AddHeader "Content-Disposition","inline;filename=" & sFile
If Not GetReportOutputType.EOF And Not GetReportOutputType.BOF Then
Response.ContentType = GetReportOutputType.Fields.Item("MimeType").Value
End If
Response.BinaryWrite( Data )
Response.End
Set FileReader = Nothing
else
Response.Redirect("ReportViewErrorMsg.asp?Mode=FileNotFound")
End If
filetxt.Close
please see the variable in red, this variable is basically a search string, this works perfect if there is no space in search string, but if there is space like "air condition" then it only takes the first word "air" and leaves the "condition", is there a way i can keep both words together Code:
View Replies View RelatedSimple question for you probably. I can't understand why the output for
something like
<%="x"%> <%="x"%>
is
"xx" (no quotation marks)
Why is there no space between the two x's?
(Of course I could achieve this in other ways, but I can't understand
why this happens.)