I am currently writing an online registration system for my work. When I collect data from users I ask them to submit there first and last names on different fields.
When I try to pass them as a value to our Verisign account it concatenates the names to look like this
JohnSmith
JaneRoe
I would Like them to look like this
John Smith
Jane Roe
Here is the line of code I use in my form. I am not sure how to put a space in between the values.
I have a page(1) with a form on and another page(2), from which (2) I want to post a value into a field of a form on the other page(1)! Clear?!?!?
View Replies View Relatedi need to get the values from the stored procedure below, basically the Name, Description, and is Active values and display them in two textboxes and a checkbox. How can i do this? Or can it be done with this stored procedure? I havent been able to find any good examples on the web... Code:
View Replies View RelatedI've encountered is in a UTF-8 test script. Here, the input - a single two-byte Cyrillic character (as reported by Javascript in the originating form) is posted to the receiving script, where IIS or IE has expanded that to a 4-byte field. -- while the display of that character is correct. What encoding is the latter?
View Replies View RelatedI have simple form where user enter the search criteria and the form is
posted back to itself and runs a query based on the values that are entered.
Everything is expect the values that the user enters disappears everytime
the form is refreshed when posting it to itself.
Is there anyway I can retain the values that were entered on the form?
is there a way in ASP to automatically submit a form and its values when a page loads ?
if not is there any way round this scenario. i want to have a drop down list of options depending on which is selected will depend on where the form is submitted to.
Is it possible to pass a multidimensional array values[retrieve form the database] back to a form and only display the first record. When a user click a button[left , right] , i will move through the array and display the values on texboxes using the button onclick event.
===============
Problem ..
===============
When a user enter "Ap" in a textbox, i will goto the database and retrieve a whole list of values[industry, address, postalcode, country .. etc] with Company name that begin with "Ap". I will store all the values in an multidimensional array and when user click a left/right button, i will move through he array and retrieve the values and display in textboxes.
I have a form I am validating on a page. Currently I have the page call itself to check the form values for validity. I want to use the form post method to send the form values to the Update page but can't because I am using the "Response.Redirect" which doesn't post the form values to the next page.
What is a good way to validate a form values then direct it to an update page if values are valid. Should I use Client-Side or Server-side script?
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
I have a service request form in asp, which takes a bunch of data (name, id, etc). it then has 2 checkboxes, either or both of which can be checked to request a certain service. depending on which box is checked, the other data collected is inserted into a corresponding database. what is the best way to do this?
can i just use 2 IF statements (not nested) to open the connections to the databases?
I'm building a wizard-type site and I have a form that has a fair amount of
information being posted page to page until it reaches the end where it has
all of the data from Page 1 - Page 5.
For future reference more than anything...is there a way to post all of the
data coming from a previous page to the next page? Basically I just wrote
out all of the values I received on each page into hidden variables and then
posted that to the next page every time. Is there a simpler way?
If you have an SQL error, response.write your SQL including all variables to the browser.
If I had a dollar for every error that could be fixed in about 15 seconds after doing this, I'd have like at least 15 bucks.