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?
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?
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.
i'm trying to make a form that will pull details from a record that is found with (asset Number) but comes up with this error: 2342 "A RunSQL action requires an argument consisting of an SQL Statement"
Dim SQL As String SQL = "SELECT *" SQL = SQL + " FROM Computer" SQL = SQL + " WHERE (((Computer.Asset)=" & TxtAsset.Value & "));" DoCmd.RunSQL SQL
I am recieving a weird error when I try to run asp scripts on my local machine, I can use pages that access a database, but when I try to write to the file system ie upload a file I get the error message below.
I have a page that creates a .CSV file that has been migrated over to Windows Server 2003 from Windows 2000 Server. It worked fine before I moved it, but now when it creates the .CSV file, and you open it, the first row opens in cell A1 and the second row opens in cell A2. Code:
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?
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
I have a wee lil problem when I am inserting data into my db from my asp page. The problem is that it is inserting unwanted characters with the values. I have used the following to try and remove the unwanted characters but to no avail: Code:
I have a variable I'm pulling from a database that's a phone number in XXX-XXX-XXXX format. What I'm looking for is a way to strip out all non-numeric characters from the variable (XXXXXXXXXX). I don't want it to look only for "-", since sometimes, there are also alpha characters entered as well.
Im doing a update page and noticed this error, whenever you want to write for example "can't, i've" it errors on submit, but characters like "." are okay. Why doesn't it like these characters and how can i make it like them? I need some extra code?
I have a SQL statement to retreive results based on keywords entered I only want to show the first 200 characters of the field though, how would I modify this code to do just that?
I am currently building a website and in one of the pages, it is to return Immediate, Extended, Standdown instead of 1.Immediate, 2.Extended, 3.Standdown(in the Ms Access). I am wondering if there is any quote to help me not display the first 2 characters(eg 1.) but just the 3rd character onwards. # I need the numbering there for future usage thus i cannot remove it from the Access database
I have created a form in which people insert there fax number, at the moment it returns an error if a space is inserted in the fax number ie: 0234 76893. How do I correct this?
The website that I am developing is having a search option. The search is according to the type of Industries, like IT-Software, IT-Hardware etc. I am using procedure to search through the database. Now whenever I Select an Industry name like IT - Software, FMCG/Foods/Beverages(i.e with special characters) etc. i get an error message Code: Line 1: Incorrect syntax near '/'. here is the code where I am getting the error
this is same for every keyword having special characters like / , - and even space But when I use keywords without any special character its works fine.
I'm pulling product descriptions from the database and would like to limit the number of charcters that is displayed. Also, I'd like to add ... at the end.
Something like: This long text is boring blah blah blah
I have a database with names, lastnames which has special characters to be seen (10-15 of them), for example: "{" has to be "š". I emphasize - those characters are not to be replaced in the database, but just to be replaced when go to the screen.Is the only way to do that function replace in the user function that has to be made? I have to say that I have to make the similar function for data entry - input also, which has to replace those characters before - for example search.
i am running MS SQL server over ASP.When i try to retrieve values from my MS SQL db, i get all values except for text characters. with a simple select statement such as
select * from table1
When i then try to apply the record sets in my ASP page. e.g.
<%=(products.Fields.Item("category").Value)%>
I get all values for varchar, bit, interger, numeric etc but the text values which are more than 250 characters dont appear.What could be the problem?
