sTmp = " WHERE Sites.[Site Address] Like '" & Request("txtSiteAddress") & "'"
I’m constructing a SQL string getting the parameters from the URL that I built through a form.It works fine if it wasn’t for the jolly characters. If, for example, in my form I type %A% I can see it in the URL (I can see the % characters as well) but the ‘%’ character doesn’t get returned by the Request("txtSiteAddress").Does anybody know if there is a reason for this and a workaround?
Why does the error below occur whenever the statement Request.BinaryRead Request.TotalBytes) is executed for uploads larger than 100K? I thought the 100K limit applied only to Request.Form. This does not occur with smaller uploads. This is running on an IIS 6 server with full FP2002 extensions.
I've got a form handler that I'm useing to grade a test. The test contains some random questions pulled from a database. I'm wondering if there is a way with the request object, to get the name of the form element from the page with the form in addition to the information entered in the text box, or the value of the radio button clicked. I can get the value's from text boxes and the values of radio buttons selected, but I can't get the name of the form element. I've looked in the reference material I've got and Googled for an answer, but can't seem to find one.
When you use the Post method in a form, it is stored in the Request Object. How long do those variables last?Example: User inputs some info in a textbox, presses a "Preview" submit button to preview their input before it is submitted. The form "Action" does some stuff with the user info, looks to see if they hit "Preview" or "Submit." Since they hit "Preview," it redirects them to another page to preview what the "Action" has done.
Does this third redirect page have access to the form info through the Request Object or has it disappeared by that point?
<input type="hidden" name="id"> The value for "id" is assigned in the form.If I want to access the information from a ASP form using Request, i would use "Request.Form("id"). what is the difference between Request.Form("id") and Request("id")?
The Request("id") works but I am wondering where it gets the information. When you don't specify the collection (as in Request("id) instead of Request.form("id) ) does it mean that the request will try to get the information from the URL, the cookie and the form?
When we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
the internet explorer always give me some error " Object Required : Request Code . 0" " on some ASP pages I try so look it up on the code, but I couldn't find anything wrong FireFox and Opera could display the pages without any the error Does any knows what's wrong?
I'm trying some ASP script on my Windows XP professional.
I have installed the IIS and it's running fine. All the ASP pages are running good except when there's a request involved, a submit button or anything that loads another page such as using information from a form, a radio buttons, or checkboxes. When I click on submit I get "The page cannot be found".
Let's say I want to use the msxml object to call a web page from within my script, and on the querystring or "in the header" of that request I want to include a dictionary object, such that the called .asp page can then request the object to it's script and use the dictionary object.
Has anyone seen anything that describes marshaling an object into an http request header?
I had came across an error known as "Bad Request (Invalid URL)" when i was trying to input chinese characters into MS SQL database using my asp written page. For your info, I'm currently working on Windows Server 2003 and running IIS 6 on this server.
Hereby i enclosed my asp request method tat i'm using <% sCategory = request.querystring("txtCategory") .... %>
the txtCategory textbox contains chinese characters, and after that I'll insert the sCategory string value into MS SQL database.
I'm trying to get a .txt file from another domain using xml object; this file includes special characters like ñ, á, é, í, ó, ú and so on. The code I'm using is:
Set xml = Server.CreateObject("MSXML2.ServerXMLHTTP") xml.Open "GET", "http://domain/file.txt", False xml.Send If err.number = 0 then filebody = xml.responseText set xml = nothing
The problem is that all those chars are converted to "?" symbols. How can I get rid of this thing and get the original characters back?
I'll admit my ASP skills are very rusty, and come seeking help.
I'm currently using a dictionary object to store a multi-dimensional array.
I want to pass this dictionary object to an object, which holds an array of dictionary objects.
However I'm finding that the array is not getting set, thus I'm having great issue with dynamically resizing the object's property for every new dictionary object I'm adding.
I have a VC++ COM object which fires an event. I've written VB EXE apps against it and they receive the event notification.
I've now built a simple VB COM object which uses the VC++ COM object internally.
My question is, assuming the ASP page which loads the object does not immediately exit, will the VB COM object be able to receive the events from the internal object?
when the asp page is Request("txtName").i can use "testpage.aspx?txtName=User1" to post the value.but when i use Request.Form("txtName").i cannot use that method,what can i do to solve that problem.(as i cannot modifty the request.form syntax but i need to post data to that web page, is there any method so that i can pass that parameter?)
We are using .net 1.1 on windows 2003 server. This is we are facing in our production server.
When we are doing the load testing we are getting the bellow error. While the load testing this error is not coming frequently. When we run 20 threads for 3 mins we are getting this error message 2 or 3 times. But this line of code is executed by all the threads. Code:
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use the recordset to loop thru the recordset, update values from the recordset and then update the database by passing parmeters to another stored procedure.
I would like to use the recordset object but can it be used to pass a parameter to a stored procedure? Do I need to use a command object to open the records instead in order to pass the parameter to a stored procedure?
Anyone in here got an idea how i could limit the display on on a paragraph to 50 characters? because everytime I access the database it would show up the entire paragraph.
I have the character & (username is a&d) in a username in one of my database fields and it won't read it properly. Do you have to do something special with characters like that?
sqlString = "SELECT * FROM Users WHERE UserID=" & "'" & userid & "'"
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called: Code:
I have a MS SQL 7.0 table with a large field (> 500 characters). My select statement embedded in my ASP file in an intranet web interface only returns 255 characters. If I run the select statement in Query Analyzer, I can easily change the "Maximum Characters per Column" setting to return the entire field, but that doesn't help me in my ASP web interface. How do I return the entire field through ASP?
What I am trying to do could be simple but I have no idea how to it. I am trying to display only a part of the record retrieved from database. I have retrieve data from database and I show it in normal way <% = oRs(0)%>, the problem is that I want to show only 100 first characters and then make some thing like this … after 100 first character. In this way all the data retrieved would look the same in the page.
One of our offices in AD is called "Albert St", the OU is called "Albert St", but when I retrieve the value out of the list box it becomes "Albert" and throws errors as it cant find the "Albert" OU. Not surprising, really. I am going to try type casting, but beyond that