Showing UNICODE (Chinese) From SQL Server On An ASP Page Using Dreamweaver
I have a simple ASP form in which I am reading and showing the data from SQL Server database. This database has a nVarchar field, which stores some data in Chinese language. When reading and printing the data using a SELECT query it shows ??? (Question Marks) instead of the Chinese data. I have checked using Query Analyzer that the data is correctly stored in Chinese only.
I have looked up for this problem and it looks like many have faced the same before. But the only solution which seems to be provided for this is using the FORMS 2.0 controls, because VB converts the Unicode to ASCII and that corrupts the data. But is there any other solution to this?
I am using Dreamweaver to write the ASP pages. Dreamweaver is capable of showing the Unicode data, but can’t do much if it gets corrupted data from the VB itself.
So Please any help will be highly appreciated.
That’s the sample code which I am using if it helps: .....
View Replies
ADVERTISEMENT
Can anyone explain why the expression "AscW(ChrW(38321))" is equal to -27215 ?
(38321 is the Unicode code for one of the Chinese traditional characters)
AscW is supposed to return a Long value, isn't it?
This also happens in VB6
View Replies
View Related
I have the following connection string:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../_database/MOO_ACCESS.mdb") & ";"
Which tests successfully.
When I try to view the tables within Dreamweaver of the access database though, it shows none. There are definitely 2 tables built in the database.
anyone have any ideas?
View Replies
View Related
I have an asp to display data in database, the data is in big5 encoding
(chinese characters)
I haven't specify the codepage in the asp and placed the file into 2 machine.
When I browse the file in NT machine the chinese characters can display
correctly, but doesn't for the page in my winxp machine. Both OS is english
version. Since the file is actually the same (by copy and paste), so any
setting in the OS or IIS level cause the problem?
View Replies
View Related
I have an ASP page in a table style (heading and data). At the beginn of each month (actually only the first day) there is no data in my database and so-with nothing to show up on the ASP page. If I would like to open the ASP page over the net IE is telling me that it cannot find my page. Is it possible that, even if there are no records to show, at least the heading is shown on the Internet?
View Replies
View Related
I am new to ASP and tried to do an ASP page up using FrontPage and Access. I have encountered a problem that even when I select all records in the database, the records are not showing in the ASP page as they shld be. Code:
View Replies
View Related
I'm a beginner when it comes to ASP, so forgive my vagueness. I'm using Dreamweaver MX 04 to upload files I'm creating from templates and saving as asp files. I can see the file on the server, but when I point my browser to it, I get an internal server error. What am I doing wrong?
Some files are showing up and some are not. The only ASP even used in the template are library items, for example:.....
View Replies
View Related
I created a connection, recordset and master detail page using dreamweaver.
When I go to preview the page, I get an error:
"Data source name not found and no default driver specified"
Which tells me that there is not a DSN on the server. I defined the DSN locally, under System DSN. So, does that mean it is only on my system? Do I have to create the DSN on the server?
Here is the code for where I am getting the error: ....
View Replies
View Related
I am trying to do some maintenance on a site for one of my clients and all of the pages are done in tables and using ASP.
I got the entire site off of the server and took a page into Dreamweaver to begin some edits. The entire content portion of the code is greyed out and it will not let me edit any of the code. Anyone have any idea why that is? Only the content portion of the page is greyed out, everything else on the page such as the search form, etc. is fine and I can edit that.
Anyone know of a solution or why it may be doing this?
View Replies
View Related
Can anyone tell me if there is a way to validate form fields using the dreamweaver server behaviours except using javascript. Basically I need a method of validating each form field when the form is submitted. I don't want to use javascript as I know that users can switch 'active scriting' off, which disables javascript. Due to the forms being critical inputs within an e-commerce system, I must validate them 'server-side'. Is their a dreameaver extension that does this or has anyone over come this issue before?
View Replies
View Related
I would like to show my data in a ASP table. I do not want a sort of record selector on that page. So I did the following: Please be as kind and look the attachment
I would like to see a table header like "tradeid,clearingnumber" etc - and underneath the list of records.
can someone tell me how to get this because in the moment I only see one record always it's not continuing writing the list.
View Replies
View Related
I am trying to establish a connection in Dreamweaver MX 2004 and an Access database for a log in ASP page, but keep getting an error. I am trying to establish "Custom Connection String" and here's what I type into the boxes that pop up:
1) CONNECTION NAME: ConnectToMyDB (I know, here I can put anything)
2) CONNECTION STING: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:Documents_and_SettingsJohn_SmithMy_Doc umentsJohnsSitedbJohnsWeb.mdb;
(tried with and without quotes around this)
3) Dreamweaver should connect: Using driver on Testing server
4) When I hit "TEST" I get an error "An unidentified error has occurred"
I am using Windows 2000. The database is in a db folder in the my defined site (moved it there). Is it the path I am typing in Dweaver or my Win2000 settings?
Hope someone can tell me what I am doing wrong. Is it my path to the database?
View Replies
View Related
I have defined a recordset in Dreamweaver to retreive information from an Access Database Table, but everytime I try to insert a master detail page, a dialog box asks me to first create a recordset, which I already did. Any thoughts on why it keeps doing this?
View Replies
View Related
I've been setting up an online payment system for our site, and it all works fine except for one part. When it submits to the merchant's site, the customer is greeted with a blank page for a few seconds while it verifies the card. Then it redirects to our site.
Is there any way to do a form POST to another site without actually making the browser go to that page?
View Replies
View Related
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
View Replies
View Related
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
View Replies
View Related
I have a 3 layer system, SQL Server 2000 database, COM+ dll's (VC++ 6) and
ASP frontend, this system has been in production for quite some time using
english, spanish and portuguese versions. Now I've been asked to test the
system to function with Simplified chinese. The development of the system
was outsourced and we don't have communication with the company (some sort
of legal problems i think).
Now, I've been reviewing the code and recompiled one of the core DLL's for
unicode support with no problems, I've tested the database (SQL Server 2000)
inserting Simplified Chinese characters and the DB supports it fine (the DB
fields are NVARCHAR), in the ASP frontend, the retrievel process (calling
the COM+ DLL functions) works fine displaying this data I inserted directly
in the DB.
View Replies
View Related
I developed a site in English but need it to be viewed in chinese.
Is it possible if so how do i go about it.
I've tried various ways but i can't get it to work.
I've done the following but it yieled no results.
<body lang="zh-TW" xml:lang="zh-TW">
Is there anything else i can do....
View Replies
View Related
I have this program we use at work that keeps track of everyones hours and its what they use to clock in and out.
the whole this is in .asp and theres alot of bugs and things that need to be fixed but we cannot get much support on it so I was thinking of going in and fixing those things myself. but the thing is they seem to be in chinese is there a way i can convert the pages to english?
View Replies
View Related
some one cuts and pastes the chinese charcters.
they are saved in DB as
---- case1 : ----
& # 6 5 3 9 6 ; & # 6 5 4 2 7 ; & # 6 5 4 1 9 ;
----
i used the space above as it is converting the characters while posting..
but i noticed some few records which are saved as
-- case 2 --
ÓÀÀÖ´óµäÏ·ÎÄÈýÖÖУ
---
if values are stored as case1 then i have no problem.
but with the case2 .the chinese characters are shown good in few pages and at few pages they are shown as it like symbols.
when i cheked the its the same.what shd i do to see that in a html page these character codes display correctly?
View Replies
View Related
I am having a probem with asp, xml, com while using chinese chars. The chinese letters come out of com fine and they are also fine when i use asp to write to a text file.
When i load the chinese chars into an xml dom they become invalid Chinese chars show as this æˆ'çš,,模æ?¿. but when i doa xsl translation then some of the chinese chars are displayed and some are shown as garbage chars. My ASP Page has the following headers
<%@Language=VBScript CodePage="65001"%>
<%
Response.CharSet = "UTF-8"
Response.ContentType = "text/html"
%>
My XSL has the following header <?xml version="1.0" encoding="UTF-8"?> ..
View Replies
View Related
I'm currently having trouble with porting our classic ASP web app for Chinese users - in any web form, the Del key on a chinese keyboard clears all of the fields in the form, which is not ideal.
View Replies
View Related
I've got an english site designed that I need to translate into Chinese.
I've got the Chinese wording to work with but I can't figure out how to get it into my code.
I thought I could simply paste the chinese characters from a Word document into my html editor between <P> tags using the PMingLiU or SimSun font but it just enters like this:
公司简介: turns into ????:
View Replies
View Related
I am writing an asp page which reads an access 2000 database. In the access database, there is data containing the simplied chinese characters. I used the following connection string to connect to the access database.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & GetServerPath & "..myDB.mdb;Persist Security Info=False"
When I use "Response.write(rs.fields("theField"))", I cannot get the original string which I can see in the Access. In fact, I have tried to use charset=gb2312, charset=big5, charset=utf-8 to encode the string, but all fails. (I am using tradition chinese OS). Can anyone help me?
View Replies
View Related
due to my 'Language for non-Unicode Setting' in Regional Settings,my ASP page keeps outputing the date format as Chinese Simplified characters when issuing say, <%=Now()%>. In addition, my client script also interpret it as Chinese characters, which I don't want it to behave this way.
However, I can't remove my 'Chinese (PRC)' settings in control panel as I need it for other Chinese version software. Does anyone knows how can I display the date in my ASP page in normal English? I did try out the META tag Content Type and put in several charset to try out, but seems like it doesn't work at all.
View Replies
View Related
How do I Pass chinese characters, charset GB2312 and BIG5, from Form to SQL using asp?
My field in SQL is already set to nvarchar.
View Replies
View Related
I have been add the vb script:
......codePage=65001%>
and html document add the followings
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
But I cannot correctly received the chinese data (request.querystring) from other asp page, which data are the user input from it.
View Replies
View Related
I've got an english site designed that I need to translate into Chinese. I've got the Chinese wording to work with but I can't figure out how to get it into my code.
I thought I could simply paste the chinese characters from a Word document into my html editor between <P> tags using the PMingLiU or SimSun font but it just enters like this:
????: turns into ????:
View Replies
View Related
hwo to use ASP to handle chinese characters output? I have try two ways.store the string in a text file(unicode file) . store the string in an access database
The first method got an error:
Active Server Pages error 'ASP 0239'
Cannot process file
UNICODE ASP files are not supported.
The second method output "???" on the browser.
View Replies
View Related
I've built a simple asp website with sql 7.0 backend. There's
a form based screens to save info to the database. I'm having problems for
some of our Chinese customers - they are saving information in Chinese
characters and they are being translated into weird characters. For
example: Code:
View Replies
View Related
Is ASP page compiled or interpreted by the web Server and what about the internet explorer how it deal with HTML and other realted pages?
View Replies
View Related
I have the following URL that was HTML encoded in my web page:
<a HREF="transfer/rad0/﨨.jpg" TARGET="_blank">﨨.jpg</a>
I am attempting to download this file which is simply one chinese character followed by .jpg. For IE, Netscape, Safari I right click on this URL and attempt to download the file. If the name contains only ASCII characters it works. I also cannot cut and paste this URL directly into IE and retrieve my image either. What do I need to do to be able to use Chinese (unicode) characters in URL's?
View Replies
View Related
I use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). Code:
View Replies
View Related
