XMLHTTP - Trying To Replace Incorrect Displayed Chrs With The Correct Ones
I have used xmlHTTP to grab a page from a server.. The page has the '£'
symbol in it, when it get to my site it is displayed as a '?'.. I have tryed
replace every way I know and it does not swap back..
I have tryed replace "?" , "£"
I have tryed chr(63) , chr(163)
I have tryed "?" , £
nothing works, except it does change the real '?' on the page, I mean the
'?' that started out as '?' and not as '£'
if I right a bit of code to count the '£' on the page it get the total right
including the original '?' and the '?' that are supposed to be '£'.. I dont
understand it I can count them by saying if {loopchr} = chr(63) but the the
chr(63) does not work in a replace statement..
I have examend the feed from theXMLHTTP and they are or seem to be got a '?'
and yet I cant replace them
View Replies
ADVERTISEMENT
If I replace "a" with "b", and then I replace "b" with "a", shouldn't I get the same result? That is what I am trying to encode and decode with Replace() function, but it is giving me different things when I replace and replace again. Here is what I am talking about: Code:
View Replies
View Related
StrSql = "SELECT * FROM [" & Screen & "] WHERE (CPN="&(COORDID)&") AND (CNUM="&(CNUMQS)&")
View Replies
View Related
I get this error with this sql statement in MSSQLincorrect syntax near '' ?
this is part or the sql statement:-
ORDER BY Sum([Ratings].[Rating])Count([Ratings].[RatingID]) DESC
View Replies
View Related
I need from an Access database using ASP. Everything I need can be found in the database, but it is scattered among different tables. Here's the situation:
Currently many tables exist, one for each event. Each table contains participants and results. Each table is for only one venue, but many tables for the same venue may exist (different events at the same location on a different date).
I need a table of participants that automatically updates if a new participant is found.
I need a table of venues that automatically updates if a new venue is found.
I need to be able to show a particpant's results at any given venue for any given time period. Code:
View Replies
View Related
Recently i noticed that there was an incorrect piece of data displayed in a
page and after investigating i noticed that it belongs to another sessionkey.
Have you experienced anything like this? i.e. when you retrieve the
sessionkey from the session variable, you get a different one?
View Replies
View Related
Getting this error:
[vbs]Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
/admin/articles.asp, line 277
[/vbs]
On this line:
SQL="UPDATE article SET title='" & request.form("title") & "',topic= " & request.form("topic") & " ,article_text='" & request.form("article_text") & "' WHERE title='" & request.form("hidden") & "'"
When it is just one line coming from the article_text thing it works fine, when it is several lines it gives this COUNT error...
View Replies
View Related
I converted my Access databases to MS SQL. I then changed the code in my ASP pages to compensate. I wanted to check that it would work. I ran into a problem: It keeps saying:
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'User'.
BTW this piece of code works fine in Access and only crashes when using SQL. Can't find anything relevant on the Internet. Can someone help please? Code:
View Replies
View Related
When i insert some values float in a form made with ASP appear an error message like this:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near ','.
sql="select id from tbl_monete where id_taglio="&idtaglio
rs1.open sql, conn
idTaglio it's the value of money that can be like 0,5 0,2,
0,1 etc etc
If i try one or two times it'll work correctly, why?
Table tbl_monete has field id_taglio that is float.
View Replies
View Related
my problem is the FormatDateTime function it is changing the date format to MM/dd/yyyy but we need dd/MM/yyyy. We already changed the settings for the administrator user. Access the regedit tool and change the format to dd/MM/yyy on all the users on the server but we are still getting the incorrect format.
First we got for every case the format switch. For example we ask for this FormatDateTime("01/10/2003",2) Octuber 1st, 2003 an the result was "10/01/2003" January 10th, 2003
for days lower than the 12th and even if we send FormatDateTime("31/10/2003", 2) we got "10/31/2003". The server is running Windows 2000 Advanced Server with IIS 5.0
After some changes this is what is happening know
FormatDateTime("01/10/2003", 2) -- > 10/01/2003
FormatDateTime("31/10/2003", 2) -- > 31/10/2003
View Replies
View Related
When I do testing with a test post page, everything functions properly. When
the actual customer does the post, the attribute following the "file"
attribute is concatenated to the file itself. When I execute the
HttpPostedFile.SaveAs(), the resulting file is what is sent Plus the
following form attribute. This following attribute is not in any Collection
from the Request object. Code:
View Replies
View Related
I'm using a binary stream to send down a file with ASP from the web
server. I've been having trouble with IE and getting it to recognize
my file. I've added the filename as a paramater(?filename=file.jpgw)
to handle IE's mime type mangling, but I'm still having trouble with
IE's default Save As Type being HTML.
When we send down a jpgw
(geo-jpeg) file IE wants to save it as an HTML file. I've got the
correct filename showing in the Filename box, and if I choose the All
Files option from the Save As Type drop down then the file is saved
with the correct extension. I'd like to have the All Files option
choosen by default. I know it's just a couple of clicks but we have
some noivce users that can't seem to get that.
View Replies
View Related
I am storing dates in a database. WHen i come to do sql queries on the dates access is interpreting them as US format (mm/dd/yyyy). When the date is stored in the db it is in the correct uk format (dd/mm/yyyy) but when asp passes the queries to access the date format changes if the day is above 13.
For example if the date being searched is 10/2/2006 (10th feb 2006) it is searching the database for 2nd October 2006. If the i pass is 13/02/2006 (13th feb 2006) it searches it correctly.
I have tried setting the session.lcid to 2057 but this makes no difference. I read somewhere that access automatically treates dates as US format and only tries another format if the us format doesnt make sense. Is there any way around this?
View Replies
View Related
I have two dynamic listboxes.One is a date and needs formatting.I am using DWMX and therefore used the format function within the dynamic listbox wizard.When I run the page the listbox without formatting is ok, but the date listbox returns the following:
Microsoft VBScript runtime error '800a000d'. Type Mismatch 'DoDateTime' /admincontacts.asp, line 189
Line 189 is the following:
<option value="<%=(rsAdmin.Fields.Item("Date_Added").Value)%>" <%If (Not isNull(DoDateTime((rsAdmin.Fields.Item("Date_Added").Value), 1, 4105))) Then If (CStr(rsAdmin.Fields.Item("Date_Added").Value) = CStr(DoDateTime((rsAdmin.Fields.Item("Date_Added").Value), 1, 4105))) Then Response.Write("SELECTED") : Response.Write("")%> ><%=(rsAdmin.Fields.Item("Date_Added").Value)%></option>
View Replies
View Related
we have just migrated to a new server both with database and web server-
migrating all web projects and all databases.then we decided to rename the
new server.we tried running all web projects on the new server but it doesnt
work causing error "configured identity incorrect, check username and
password" in a certain line in the code.
i have searched for possile solutions like synchronizing identity account in
the 3 locations where this account is stored but it seems it doesnt work.
Earlier i was able to fix scheduled jobs in the database not working caused
by renaming the new server which is also the name of the database server.But
problems in the web files itself (asp) are giving me headache particularly in
code lines with "createobject."
Whats seems to be the particular problem?Can anyone point me to the right
resources to fix this prob?
View Replies
View Related
I have all of the dates I use in my tables stored as date in the YYYY/MM/DD format, with the columns set to DATE.
When I do any queries on the database (not usinf ASP) I get YYYY/MM/DD format returned.
When I do a recordset("datefield") ASP request I get D/M/YYYY returned. I have not asked anything to convert it, I have no idea where it is getting converted. It is a real pain, as I need to copy these dates through out the table, and they are getting returned in the wrong format.
View Replies
View Related
I have IIS 5.0 running on a Win2000 server. I have
scripts that I want to run on the web page. It was
suggested to me to create an .HTA page instead of .asp
or .html to make them run. The scripts now run fine, but
when the action is finished, I get the error:
The page cannot be displayed
The page you are looking for cannot be displayed because
the page address is incorrect.
HTTP 405 - Resource not allowed
after completing a task associated with a button press,
in this case a folder copy!
I'm not very familiar with .hta pages, can someone help
me with why I might be getting this error. Are .hta
pages supposed to be used with newer version of IIS
instead of 5.0
View Replies
View Related
I am moving from a Windows 2000 Web Server to a Windows 2003 Server.I have converted all of my old CDONTS to CDOSYS with no problems. However,I am having major problems with getting my asp pages that have both MySQL and CDOSYS
on them to work.I get the following error:HTTP 500 Internal Server error
There is a problem with the page you are trying to reach and it cannot be displayed
View Replies
View Related
Because I needed to store more than 4,000 characters, I decided to convert one field in SQL Server Database from nvarchar to ntext...now the field holds many more characters without a problem as I examined in my online manager.
But when I tried to display it on my asp page with
Code:
<%=rs("Text")%>
, nothing showed up, and there is no error message. It cannot be null because i checked in the manager...
View Replies
View Related
I'm using classic ASP. I made a change to a page and I got a Page Cannot Be Displayed error. I changed the code back and now I get the same thing. Other pages can run and access the db server.
I tried taking out includes and bypassing some code. I've also checked both the Application and Event logs on the server and there doesn't seem to be anything obvious there. I'm not using any components. Can anybody give me an idea as to the types of
things that cause this problem?
View Replies
View Related
I've got an asp page that allows users to input quantities of certain items. When they click the "Total" button, the page is submitted to itself and a total for their selected items is displayed, similar to any online shopping cart.
When all items have been selected, the form is submitted, and their taken to the next page. If they choose the browser's "Back" button, or a "Cancel" button on the asp page, they get the Page Cannot Be Displayed Error. However, if they never update the total, and instead enter all the quantities and then submit the form, withing submitting back to itself, the browser's "Back" button and the asp "Cancel" button work fine.
It appears the back button doesn't work when the previous page has been submitted to itself. Does anyone have any suggestions? Is it a bug in my code or possibly an IIS issue?
View Replies
View Related
I have a form from html called "rcf" and it suppose to get the data from users and send it to the database.but from my form to my add_rcf.asp page I get a "The " message.I uploaded the files.
View Replies
View Related
I get this page cannot be displayed every time i try to run ASP pages on Win 2k Server IIS5.1 . I know that the guy who's server it is had run a couple of lock down tools after his server's security was compromised.
Could this be part of the reason why? I had a look at his configuration and .asp files were pointing to 404.dll? I changed it to the asp.dll in inetsrv directory but that didn't help as well as restarting IIS.
View Replies
View Related
i am tryint to access this ASP website, but it keeps giving me the msg PAGE CANNOT DISPLAY. when i send the url to my friend, it load for them just fine. can someone tell me if ther are any option i have to chang or any way of solving this problem?
View Replies
View Related
We have two websites:
1. On Internet
2. On INTRANET
Anyone with any internet account can access to the first site, but to enter to the 2nd, u need to have a special internet account (say, a certain supplier).
The general menu is on the Internet website, but one of the items in the sub-menu, links to a page On the INTRANET. If u r not authorized (=did not use the certain internet account), then u get the page "The page can not be displayed".
How do I redirect the "page can not be displayed" to the help page, and of course, redirect it ONLY when the "page can not be displayed" page is there b/c of linking from this sub-menu, or b/c of trying to reach directly to the Intranet certain URL that this sub menu links to.
View Replies
View Related
I have a page that displays images. However, at times if I have changed the actual image but have kept the same name and src, the old image still displays when I run the page. I have cleared the files and cookies and sometines this helps but not always.
Is there something I can do to force a change?
View Replies
View Related
I know this is a simple problem,what are all the causes of this problem? This occurs to only when I don't login to the web server.
View Replies
View Related
I am unable to get this function to output the correct output. The Subtotal works fine, but the GST and TOTAL are not working properly. GST only shows the integer value and nothing after the decimal places. Code:
View Replies
View Related
I just installed IIS on my local system. Just wanted to check if asp was enabled too. but when i run the code on the browser it displays asp code. What am i missing out here?
View Replies
View Related
I have a dynamically populated page, and for one of the records the page is not completely displayed. When I click view source, the code is complete but about half of the code isn't shown on the page.
View Replies
View Related
i have 25 fields on a form vertical display and i want them to be displayed horizontal. i want to support my idea of horizontal display to my manager the reason why i want horizontal display is because the user wont have to scroll down. so i need some articles from the web or technical articles which support my idea.
View Replies
View Related
I have done search on the board (and google too) to find a way to display properly my HTML code that are already inside the text in my database like < br > and < i > and so on. but when I see the result in my browser (using ASP) I see the HTML coding and not the result of the code.
I have found here in the Funky Functions in ASP thread probably something useful but I cant make it work (second post, the one made by aspapp).
View Replies
View Related
I had a problem which will cause the user to get an error page cannot be displayed. But this error only happened on one of my users, the rest are able to login to my site.
what might had caused the user to get "page cannot be displayed error"? Is that due to internet security settings? Or error with my code?
View Replies
View Related
