+ Sign Where The Spaces
I 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
ADVERTISEMENT
Sign-up
I am creating a little signup script and tus far i have run into problems with this line. This line inserts the users information that they entered from the form into the SQL database. Does anyone know what is wrong with this line?
myconn.execute("INSERT regfreeup set signup = '" & Now() & "' , firstname = '" & first & "' , lastname = '" & last & "' , email = '" & email & "' , ordernum = '" & order & "', username = '" & user & "' , pass = '" & pass & "' , site = '" & site & "';")
Sign Up
i need to know how signing up works, the kind where you will fill in a form and then receive your password and username by email.
How do you generate the password and username, if you cant help please refer me to another site that i can check on.
Different $ Sign
In some searches on our web site the items will come back with a different dollar sign than the US $ symbol why is that?
View Replies View RelatedSQL Syntax Near The = Sign
I am concatenating the firstname and lastname in the SQL query in the ASP page. I get the error:
Syntax error near =
This query works in Access.
<input type=hidden value="<%=strNetworkID%>" name=""networkid">
"SELECT" EmpID, FirstName + ' ' + LastName as Employee_Name, NetworkID FROM Employee WHERE networkID = " & Request.form("networkid")
Sign A Form Using PDA Pen In ASP
I am developing a simple ASP that requires a user, after verfiying a checklist, to be able to actually sign the form using a PDA pen (The device is a PDA). My problem is that I do not have idea as to how to do this. Is there any API or any other method (say canvas?) that I can incorporate into the ASP so that the user can sign?
View Replies View RelatedProblems With # Sign...???
I'm linking from one page to another like so: page.asp?modelName=#1 Common Ash Wood.
On the next page I store that value in a variable so I can use it however I like. The problem is that if that # is there the value doesn't pass and is left blank. If I have something like 2.25 #2 Common Birch then only the 2.25 comes through.
I had a similar problem in the past with quotes and was told to use ASCII ” and that solved the problem. Now, though, I'm doing a search for ASCII values and I'm finding a lot...but none of them seem to match up and work.
All the tables I'm finding say to use " for quotes and then says to use # for the # sign. When I try that for #, it does indeed switch and display a # in Dreamweaver, but still leaves the value blank when trying to use it in my application.
Where did you guys get the ” from and why can't I find any charts that have that to use for quotes? Whatever chart that is, is probably the chart I need for #.
Hope I haven't confused you too much. Basically, I just need to know how to be able to use the # in a querystring without it blanking out everything after it.
£ Sign Not ? Mark
I am using ("Microsoft.XMLHTTP") to grab content from a site and display it
on my site, the issue I have and have had for weeks now is that on the
original page the sign "£" exists and when I get it to my site it is
displayed as a "?".
If I find the ASC code for the ? and replace on that it still does not work
:-(((
I have tryed all the usual method of fixing this with no success...
anybody had this issue or know where I might start to look to fix it ???
Joker Sign
Anyone know how I can delete files from an asp page using filesystem and joker sign
I know how to delete one singel file, but I want to delete more than one file, only by
knowing the end of the filename, is there a joker sign I can use like "%" og "*"
I have tried something like this:
varFilename = * & "thefilename.txt"
fs.DeleteFile (server.mappath("files emp"& varFilename))
Using XML For Single-sign On
I am looking to implement a single-sign on solution for my company's website which has many partner websites scattered around the globe.
I want the members to be inconvenienced as much as possible, so if they log into one website, they are logged into all of them. As each website exists on seperate web servers in different locations, this makes my options a little tricky.
Has anyone had any experiences of single-sign on? I only know a little of XML, but I understand that this kind of thing can be achieved using XML over SOAP.
Single Sign On
point me to resources that will tell me more about enabling a web application to tegrate with windows security for single sign on
View Replies View RelatedSQL Update With ' Sign
I had successfully programed a running Update ASP Page. While troubleshooting the pages, I discovered a error when I input something with ' For example: (john) is okay, (john') will give me error message. How can I do so the applicant can input ' in the update page?
The following is SQL code in my update page: .....
Currency Sign
I have a problem with an ASP page pulling data from a SQL2000 server. Expected behaviour is that when prices are displayed they are displayed in pounds as this is the default locale of the server. However they are displayed in dollars.
I've checked the default locale and the user locale of the (windows 2000) server and these are both British english. The language for the SQL user is also British english. Are there any other setting that could affect this?
Sign-up Form
I have a sign up form where a person is signing up for several events,names and signup info goes into an access database.
I need to have it cut off when the events get full and prevent futher signups. Different events have different capacities, so some events could close and others still be open for sign up.
Single Sign-on W/ASP
I'm building a few web sites that will use distinct domain names but will reside on the same server, at the same IP address, in the same application space, and will share a database. They will each provide different content depending on the domain name, but will share some core functionality behind the scenes.
What I'd like to be able to do is have one site serve as the primary site. If a visitor comes to one of the secondary sites and wishes to perform a function that requires them to be logged in, I'd like them to be able to log in only once and then be able to visit any of the sites without having to login again. Does anyone know of a pure ASP script-based single sign-on system?
Code For Sign Out Option
I want to make sign out option in my website as like yahoo and hotmail.
View Replies View RelatedSingle Sign On Function
i need when a user is logged in, his or her account is locked and no other ppl can login by using these account.
View Replies View RelatedPrevent Double Sign In
How can i prevent double sign in with same account?
View Replies View RelatedInsert Data Into DB For New Sign Up
i wanted to do a sign up page using vbsript for new pple to register as member, but therr is also error: too few parameters, expected 2. Code:
View Replies View RelatedSpaces
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 RelatedSpaces
i 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?
Spaces
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>")
Checking An Email Length And @ Sign
Just a thought, the code below checks to see that an email address submitted from a form check to see if that there is an @ sign and if the length of the email address is greater than 0.
If InStr(request.form("email"), "@") > 0 then
sSender = request.form("email")
Else
...
I can assume then that the code about makes the LEN function redundant?
If len(InStr(request.form("email"), "@") > 0) then
sSender = request.form("email")
Else
...
Passing Percent Sign In Querystring
I am passing a sql string thru my querystring for the next page to
capture.
example: www.xxxxxxxx.com/index.asp?str=select * from table where name
like '%doe%'
Passing a basic string works fine. But, when I use the LIKE statement it
does not work. I know it's because of the % sign, so how do I translate
this thru, so that the following page picks up the percent sign?
Spaces In Data
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.
Removing Spaces
how do i remove spaces in the middle of the string?
from this:
var = "sand bag"
to this:
new var = "sandbag"
Spaces In Folder Name
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
ASP/Checkboxes And Spaces
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.
Spaces Carrying Over
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.
Handling Spaces With Sql/asp In A Url
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: ....
Spaces Between Words
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 RelatedSpaces In Recordset??
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")%>
Spaces In A Username
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?