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.
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?
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.
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.
All of a sudden this morning my ASP files started generating the error:
Out of String Space: 'Replace'
These script files have been running just fine for several weeks with no problems. I did review the code and yes the script is calling the Replace function at the line specified in the error information.
I'm puzzled as to why the code would all of a sudden start generating this error ?
I've been using ASP to create my database-driven websites for about 2 years now and I'm getting a little sick of always having the scripting code mixed in with how the page should look. All I can imagine doing to solve the problem is to pre-build any content(with minimal html formatting) early on in the script and then output those strings in the desired spots on the html section. I've also been told that I should use XSLT to separate code and content, but I'm a little hazy as to how the model works. The way I understand it, I change all my ASP to output ONLY XML and then I set up the server to run XSLT on the those XML pages based on style sheets that I design. Is this correct? If so, what are the best programs to use to support this 'ideal' code and content separated form of development on the ASP platform?
scenario: a user submits a form, create session variables in login.asp and redirect to main.asp
session in login.asp example: session("uid") = var
experiment: i tried opening two browsers, and entered two different userid(uid), i also put response.write(session("uid")) within main.asp to check if different users are displayed.
problem: the session var from the second browser overwrites the session var of the first browser. so if the first browser "adds" something to a database, it gets the session var of the second browser, and not the first one.
question: how can i maintain the session var from the first browser? separating each session var from each browser.
I have an asp page which lists records. Each record has an ID appended to it.
On the following edit page, I am trying to test against a certain field value, if it is >0 then run the update, otherwise don't. The problem is the data for testing is as follows:
Dim arrMetal Dim iLoop arrMetal=split(request.form("ID"), ", ")
For iLoop=0 to Ubound(arrMetal)
IF request.form("del_qty_" & arrMetal(iLoop)) 0 THEN
Where del_qty is a number entered in the form, and arrMetal(iLoop) is the records ID whilst in the loop on the edit page. When I try the above if statement I get an error: Code:
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 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?
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.
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 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.
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 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?
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 ...
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?
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
