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: .....
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 & "';")
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.
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 RelatedI 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")
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 RelatedI'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.
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 ???
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))
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.
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 RelatedI 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?
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.
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?
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
I want to make sign out option in my website as like yahoo and hotmail.
View Replies View Relatedi 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 RelatedHow can i prevent double sign in with same account?
View Replies View Relatedi 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 RelatedJust 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
...
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?
is there anyway of separating a string by either a space or + sign,I have an sms.asp page that receives a string in this format below
http://acompany.co.uk/online/intern...text=19%2Bdavid
the last part text=I need to split into 2 parts I need to read the first part 19 and match that to the db and then deal with the name David,I have tried everything, is there anyway of doing this even if the string read text=19+david if there was a way of separating the two.
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies View RelatedequpID = "ABD-4-01" i have this string and want to cut the first part, means (ABD) by the way the first part may connsest of more that three letter , like "ABAT-2-01" .
View Replies View RelatedI am having a problem that the gateway I am working with removes the "="
sign from values in the postfield that are empty.
Example:
page.asp?aa=&ff=&xx=12
become:
page.asp?aa&ff&xx=12.
When I query the string and request the value of xx through IIS, it returns
nothing.
Can anyone help me finding where Microsoft defined the URL format that the
IIS (4.0) accepts? I have already searched the RFC's.
I am passing few parameters from one page to another.
One of the parameters is order number.
In one particular case the order number includes "&"
sign : FE:.AT&T001
Next page reads the order number as "AT" only (not the
full oredrr.
I put double quotes around the order number.
I have this page that displays a dollor amount code:
<td class="tableValue" width="122">Expiring Premium:</td>
<td width="400" align="left">
<input name="Expiring_Premium" type="text" value="<%=formatcurrency(Expiring_Premium,2)%>" class="tableValue" size="27"></td>
it would display $100.00 when i go to insert that value into the database the value i get is $100.00 and i get an error, i need to get rid of the $ sign but not sure how to do it because the number range can be from 1 to a billion dollars.
I have this code for asp that if the value is null it insert a null instead of a blank, else i get an error message in access.
'Expiring_Premium = request.form("Expiring_Premium")
if (request.form("Expiring_Premium")) ="" then Expiring_Premium = "Null" else _
Expiring_Premium = request.form("Expiring_Premium")
Any ideas on how i can strip off the $
I'm looking to update a column in a datebase that has null values with N/A and I'm using this:
UPDATE tbl_members
SET branch_no = 'N/A'
WHERE branch_no = NULL
The only reason I'm trying to do this, is because I can't seem to do if statement on a null value.
This is hard to explain, but I have wanted to know how to do this. Say you have a website, and you have a news box(where you can report all of your news), made of a picture(s), you know like something that says "news" at the top of the 'box', and the sides of the 'box' are a picture. I have wanted to know how to make one of these 'boxes' without having to use the <div> tag, and type as much text in there as i want, and it wouldnt mess up a table or anything, or realign it, because the <div> automatically wraps around the text, fitting perfectly to it. I was wondering if you can 'wrap' around the text without a <div>, but with pictures. Here is an example, this picture called ex.gif.
I know it is a link menu, but what if you wanted to add a couple more links. How would you get the 'box' to automatically resize so that it does not messup the table. I am not even sure if this is capable in ASP, but I am sure somebody knows what I am talking about.
I have a guestbook form that inserts the fields into an
Access Database. The database is residing in the "fpdb"
folder that was created by FrontPage. The ASP page that
writes the data into the databse uses the
"recordset.addnew" method. The code was working fine a
couple of weeks ago, and now all of a sudden the error
message "Cannot update.Database or object is read-only"
pops up. The ASP code or the database was not changed or
modified in any way, neither were the permissions for the
account.
I have quite strange problem and hope you guys can help me out or provide me with some tips.
when using a update script:
UPDATE categorys SET main_cat_default= '0', banner= '', b_link= '', external_text= 'Nākotnes parks', name = 'Arzemju muzika' WHERE (id = 115)
Then it messes up field EXTERNAL_TEXT. Instead of Nākotnes parks it saves it as Nakotnes parks.
But! when I open Enterprise manager and type in Nākotnes parks manually then it saves it correctly. So I believe there is something with update command or smthing like that.I changed collation also to Latvian and this did not work.
For laptop users who have an ASP application running on their laptops
- is there a way I can have it check when connected to the network
(via the FSO lastmodifieddate) which files need to be updated
(enhancements, etc.), then shoot the ASP pages that have changed down
to the client?
I'm using the following code:
rs.addnew
rs("application")=body
rs.update
body is containing a lot of text with vbcrlf in it.This is basically a form that is emailed and I want to save it to a db just in case the emails don't go through.
For some reason the field in the db (access) is only containg the first line until the first vbcrlf