This is a first for me...so all help much appreciated.
I am trying to create a survey form which retrieves all its questions form
an ACCESS database.. (I know ACCESS isn't the best option, it just not my
call).
This database is to be multi lingual and my current survey is to be in THAI...
So in creating the survey, I copy the thai text into the ACCESS table from a
WORD document and all looks good. ACCESS seems to understand the THAI.
When I retrieve these Questions from the Database, loading them into a
recordset however, I get '????'s' in the output instead of the thai text .
I have set the charset of the HTML document as charset=TIS-620..
Can anyone tell me what i am missing? What needs to be done to display thai text in my ASP App?
I was reading up on ASP for a report and it talked about scripting languages. It also talked about using VBScript or Javascript as a scripting language? What exaclty is a scripting language and why do you have to use it?
We have a few English websites running on a single server and are in the process of adding a Spanish website to the same server. I am trying to determine how one would set the language for a particular website. For example, instead of ASP generating a date like "Monday, July 19, 2004" .
Can any one tell me how many programming languages are there in the world? I tried to google it but could not really get an exact or complete list of them all.cheers.
My ASP/Access app'n uses UTF-8 data in mixed languages/scripts successfully. That is, it takes input, stores and retrieves stuff OK browser-wise. The app also writes an RTF file and downloads that to the client (for display by Word) fine, but ONLY English; Cyrillic and the CJK group gets the trash display - and it's not a font pblm, cuz the browser display is good.
I've tried a number of charset directives in the RTF-writer, including CP-1251, UTF-8, Unicode, etc. None works. I don't know whether I need an explicit code-set translator or not, and am working with ChilKat's Charset product without any improvement so far.
I am now creating a website which have 3 languages (English, Simplified Chinese and Traditional Chinese). The server has installed English version Window 2000 (Server Version, Default Codepage is Traditional Chinese) and MSSQL 2000 (English). I have created a database which use the codepage "chinese_PRC".
However, when I created an testing asp pages ( 1 textbox and it will insert the content into the table), it cannot store the chars in correct coding. I would like to know whether asp or MSSQL has something wrong in my setting?
Just started learning ASP, seems like lots of people use VBScript to program with. Though, I have spent the last year learning Java. Just wondering if I can use this to program with? along with its API's ?
Also, is it worth while to learn VBScript ? Is it industry standard or needed? Im guessing it is from the way its the language used in most ASP books. Any insight would be great.
I have an ASP page that I want to support multiple languages. If I set the <%@ Language=VBScript CodePage=65001%>
and adds a <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
meta tag it seems to work OK. Now instead of setting the codepage in every page I tried adding a global.asa (Session_onStart) file and add session.codepage=65001 and also tried to add response.charset="utf-8" (I was not allowed to set <%@ Language=VBScript CodePage=65001%> inside global.asa). This does not seems to work though. Is it possible to set a codepage in some event in a global.asa to make it global for the entire application? Is it possible to add a directive in global.asa that works like setting a <meta http-equiv="Content-Type" content="text/html; charset=utf-8">. If this is possible I don't have to recomplie my business logic that creates the html.
how ASP (not ASP.Net) to do the following things: 1) Get real-time information from other web site such as tracking via Fed-Ex; 2) Real-time credit card charging via a payment gateway such as WorldPay; 3) How to support multiple languages.
Ive done quite a few sites now that involve different languages using different strategies and I would like to hear some different opinions on which is the most efficient.
The previous sites with languages that I have done have not been majorly big or would involve vast amounts of traffic so using included language file have been ok. I am about to do a site in 4 - 6 different languages that will have quite a lot of traffic. I have also used application variables in some cases but not sure if that is the best way.
So if anyone has any ideas on a better way and also one that is easy on server resources I'd love to hear them (and maybe a link to some code would be koool)..
I want to create some pages using .net, and have others using regular asp with vb. Just wondering? I know you can have Java within the same pages, but didn't know if using asp, and then wanted to do some .net things if the site would have problems.
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId FROM (tblArtists INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId) LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
I have a MS Access file that consits of 500 movie titles, I already upload this file onto Brinkster.com, but I don't know to code this into ASP or PHP so I can have an on-line database. Please help me code this Access file into an ASP or PHP file.
I have a field in my Access db which is used to put a category against a company, rather like Yellow Pages. The categories are held in another table in the same db. The Category field in my companies table is a look up field using this syntax
SELECT [categories].[ID], [categories].[Category] FROM categories;
My problem is when I want to list a company and do a response.write rs("Category") I get the ID relating to that category rather the description. How can I get the description instead?
I am using Access and ASP.I am just trying stuff out.I created an access database and put some validation in access on some fields. I created an ASP program to insert into my database. When I try to insert a record that validates OK with access rules all is fine. Then I type input that violates the access rules; I hoped to get a helpful message back. All I got was my message saying an error had occured and it was Error number 0 and native error 2097228. As I was testing I know it is due to failing a validation in access. I am learning I wanted to look up this native error, I cannot find it in access help or internet searches where would I look for native errors please? I know I need to validate client side that is not the issue it is understanding native errors!
I'm trying to search the Access database using 3 fields and I think there's a problem in my If statement...pls check it out for me.....I'm using ASP...this is what I'm trying to do:
If Request.Form("txtUser_Id") = "User_Id" and Request.Form("txtWeekNo") = "WeekNo" Then strSQL = "SELECT (MSD + Methods + Analysis + Architectures + Models + Studio + Elective1 + Elective2 + Elective3) AS PersonTotals, FirstName, LastName, WeekNo, Semester, StudioTeamName FROM tblpersons" strSQL = strSQL & " WHERE Semester=" & Request.Form("DaInBox") 'strSQL = strSQL & "WHERE Semester ='" & strSemester & "'" End If
I'm planning to change my database from MS Access to an SQL database. So, what do i have to change in my code for that?Is it possible to have multiple tables in SQL which are linked to each other?Are there pro's and contra's ?
I made a little app that selects data from a database depending whether there is a NO, in the YES/NO column. The data is exported to a txt file with aso. What i'm wondering is, is after the data has been downloaded to that txt file, how to write to the database saying all they were marked NO, go to YES.
I have never dealt with XML before, So this is way out of my realms...
I am trying to get a XML feed into an Access Database..
The XML source can be found here:-
but as you can see.. there is another problem.. the file is in a .GZ format.. so i need some way of Un-Zipping it onto my web host, and then importing the XML data into the database..
Ive looked around, and the only information i can find is un-zipping it onto a local machine, and then uploading the XML file.. but that's not practical.. i don't want my web page to be dependant on my PC at home being logged on...
As for the import of the XML to Access... that's another black hole there.. ive never done anything like this before..
I'm still very much on the learning curve when it comes to writing ASPs and have always used Access for my db. A colleague in work has told me that I should never use access on a commercial site where I'm likely to get a lot of traffic. Is this correct, is Access totally unsuitable?
Alright, I am opening an Access XP database via ASP. One of the fields is a numerical field, and I would like to force it to display the number + 1 digit to the right of the decimal. For some reason it is only displaying digits to the left. In Design View, my Access Table (names 'arlist') looks like this: Field Name: level, Data Type: Number, Field Size: Integer, Format: Fixed, Deciaml Places: 1
My SQL Statement: SELECT * FROM arlist;
Then the VBScript I'm using to access the table looks like this: Response.Write"<TD align=""right"" bgcolor=""" & strBG & """ width=""10%""><P class=""body"">" & rsDC.Fields("level") & "</TD>" & vbCRLF
I am opening the table via ADO Statically with a Read-Only pointer because the page just displays the contents of the table. I've tried everything I can think of to preserve the decimal place. If I view the table in Access, the decimal places are correct.
I have got a display page where im displaying Company ID Company Names with Their Products Added The data im extracting from the access DB The thing is as im adding a lot of products for a each company so im adding them in a loop in my Products table so each time i add a new product with the particular company id the the id gets repated as its in the loop as well and thus each time a new record is being genarated what i want to achieve is that on a display page where i want to see the data that has been added i just want to get the Company ID not repated and with all the products related to that company id and then the next Id with the products like ive got 20 products for a company ID 1 so i just want to show that company ID once and with all the 20 products and then go on for the next company ID how will u do this do i have to use the distinct thing or do i have to open another recordset and match the id
