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 RepliesI m using persits mailsender component for email purpose.. it was working perfectly........but now i m getting following error....
View Replies View RelatedThis is a Screen Shot of the error i am receiving.
ht t p:/ / ww w. geocities. com/sn owthef ear ed04/ error. jpg
Any Ideas? I fixed the end quotes and semi colon those are no longer at the end of the sql statement.
Can someone tell me if they see an error in my SQL statement? I'm passing the TEAMID var into this page. I know that works because I tested it.
ERROR:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/league/teams/team.asp, line 13
<%@ language=vbscript%>
<!--#include virtual="/includes/common.asp"-->
<% Dim teamID %>
<% teamID = Request.QueryString("TeamID") %>
<% Set rs = Conn.Execute("SELECT * FROM tblTeams WHERE TeamID = " & teamID )%>
I am getting the following error when I run my page I just created. The
first time I run the page I get this error, if I run the page a second time
I get no error and everything works fine. This is the case everytime.
The error is:
Can someone point out why this is giving me the error "Variable is
undefined: 'arrProducts' "
<begin_code>
Dim m_arrProducts()
Sub SerializeCart()
ReDim m_arrProducts(m_intCartCount -1)
response.Write("ARRAY: " & IsArray(m_arrProducts) & " Cart Count: " &
m_intCartCount)
For intCounter = 0 to m_intCartCount - 1
response.Write("product 1" & "<br/>")
Next
End Sub
<end_code>
the Response.Write prints "True" for IsArray and "2" for m_intCartCount.
i have a table 'Accounts' in my database, which contains a bunch of
users. From the main menu i choose "edit user" and all users in the db
are presented in a table. The first column 'Pnr' is a unique ID for
each user that i made appear as a link. clicking on one userID should
present a form where the picked users userdata is already filled in so
i can easily edit it and then move on to submit the form to update the
db. i get to the part where all users are listed nicely in a table,
but clicking on one, i get this error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested
name or ordinal.
/VS_Files/updateUserForm.asp, line 19
I think i'm doing something wrong with passing a value with the
querystring...? Code:
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.
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?
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.
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'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
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.)
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 RelatedI 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".
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 ...