Space With File Name
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
View Replies
ADVERTISEMENT
how to read a space delimated text file in ASP. The senario is i have a text file which is delimated with spaces. Example is given below
Code # P.I.N. Code TOT-CR LBR OP CS TOT-CR DIFF $ DIFF/DEB CLAIM TYPE AUTH. PART CNT PART # - DESC
0116604 1GKDS13S972119280 0.00
RETURN REASON: EH N6642 000
0116605 6G1LK53B26L559568 127.90 E3850 127.90 001 92199784
0116610 KLV1J58Z06B177798 0.00
RETURN REASON: VA N6604 000
These are only three records some time single record appeared in 2 lines.
View Replies
View Related
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 Related
I 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 ....
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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)
View Replies
View Related
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.
View Replies
View Related
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)
%>
View Replies
View Related
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 Related
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 Related
Now 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 Related
Sometimes 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.
View Replies
View Related
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.
View Replies
View Related
where i can find a myspace clone?
View Replies
View Related
I 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 ?
View Replies
View Related
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.
View Replies
View Related
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 ?
View Replies
View Related
who has free web space for forum?
View Replies
View Related
I 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:
View Replies
View Related
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 Related
Simple 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.)
View Replies
View Related
I have a script that allows you to edit an html page (the html being stored in a database). The problem is that any characters in the html disappear when viewing the page for editing. Is there some way to escape them?
View Replies
View Related
I retrieved some data from the database and put it in a textbox but the words after the blank sapace cannot be shown, why is that?
Name = rs("requestor") 'where the name is "Sam Siew"
<TD><INPUT TYPE=TEXT Name=requestor size=12 Value=<%=Name%>></TD>
In the text box, it only show "Sam".
View Replies
View Related
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 ...
View Replies
View Related
I have a combo box bulit by taking in values from database. some of the values have spaces in between them
e.g
<select name="place">
<option value="Presidents Office">President's Office</option>
</select>
So when i use this code to read
Response.write(Request.Form("place"))
Its only returns me President's
HOw can make it include whole string including spaces..?
View Replies
View Related
Could anyone recommend a server provider that can handle asp for a site that will contain roughly 500 pages that won't cost me the earth. The site will be UK based mainly for UK customers. I have found so many but it's tough to tell who is and isn't worth the money.
View Replies
View Related
I am trying to create a short description by taking the first 100 characters from my description field. My code is: Code:
shortdesc=left(objpagingrs("description"),100) & "..."
How would I make this take the first 100 characters (as it is now) but also take the next few letters until the next space. (so that I don't cut a word in the middle.)
View Replies
View Related
let say i got a string:
apple, orange, durian
how to check got how many commas in this string? how to check beside the commas is space or not space? if the words beside the commas is space, i wan to remove the space? if the words got commas, i have to remove the space.
View Replies
View Related
how i can have a fixed 2 decimal space for price of an item.i have the code shown below but the result shows more than 2 decimal space or even 1 space. Code:
<%=formatnumber(rsProdInfo("Unit_Price"))*(GST)+ formatnumber(rsProdInfo("Unit_Price"))%> ...
View Replies
View Related