China to English Coding error messages

1 New Member

I have been given the task of "repairing" a webpage that was created in China and copied to an ASP Server in the USA. Part of the script was in Chinese when I started, but I think it's all English now:

Expand|Select|Wrap|Line Numbers

 <%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<!--#include file="inc/readImg.asp" -->

<!--#include file="inc/dbconn.asp" -->

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

<title>-=- KAKADU -=-</title>

<link href="css/aobeike.css" rel="stylesheet" type="text/css">

</head>

<body>
 
<table width="1000" height="1194" border="0" cellpadding="0" cellspacing="0" background="images/beijing.jpg">

  <tr>

    <td width="111" valign="top"> </td>

    <td valign="top"><table width="778" border="0">

      <tr>

        <td height="25"> </td>

      </tr>

      <tr>

        <td> </td>

      </tr>

      <tr>

        <td>

                <!--start website navigation-->

                <table width="778" border="0">

          <tr>

            <td width="170"> </td>

            <td width="577" class="yaoqiu"><div align="right"><a href="productlist.asp?Category=jackets" class="yaoqiu">Jackets</a>  /  <a href="productlist.asp?Category=shirts" class="yaoqiu">Shirts</a>  /  <a href="productlist.asp?Category=pants" class="yaoqiu">Pants</a>  /   <a href="productlist.asp?Category=bags" class="yaoqiu">Bags</a>  /  <a href="productlist.asp?Category=vests" class="yaoqiu">Vests</a>  /   <a href="productlist.asp?Category=hats" class="yaoqiu">Hats</a>  /  A<a href="productlist.asp?Category=accessories" class="yaoqiu">ccessories</a>  /  <a href="company.html" class="yaoqiu">Home</a></div></td>

            <td width="17"> </td>

          </tr>

        </table>

                <!--end website navigation-->

          </td>

      </tr>

<%

  page=request("page")

  Category=request("Category")

    if Category<>"" then

      temp=Ucase(left(Category,1))

        'Category=temp & right(Category,len(Category)-1)

    end if

%>

      <tr>

        <td>

<%

  if Category<>"" then

%>

                   <span style="font-size:30px;font-family:Monotype Corsiva;"><%=temp & right(Category,len(Category)-1)%></span>

<%

  end if

%>

          </td>

      </tr>

    </table>

<!--start product list-->

<%

  if Category<>"" then

      openconn

        set rs=server.createobject("adodb.recordset")

        sql="select * from [product] where category='" & category & "' order by updateTime desc"

        rs.open sql,conn,1,1

    if not rs.eof then

          rs.pagesize=12

      rs.absolutepage=1

      if page<>"" then

        rs.absolutepage=page

      end if

      page=rs.absolutepage

%>

<table width="778" border="0">

<%

  n=1

  do while not rs.eof and n<5

%>

  <tr>

<%

    for j=1 to 3 

%>

    <td align="center" width="33%">

<%

  if not rs.eof then

%>

 <table  border="0">

  <tr>

    <td align="center">

<%

    imgFile=rs("Img")

    productImg=imgFile

  if imgFile<>"" then

    imgFile=server.mappath(imgFile)

    set f=server.createobject("Scripting.FileSystemObject")

    if f.FileExists(imgFile) then

      set getImgsize=new GPS

      pd=getImgsize.getImageSize(imgFile)

      temp=pd(1)/pd(2)

      if temp>1 and pd(1)>200 then

        PWidth=200

        PHeight=200/temp

      elseif temp<1 and pd(2)>200 then

        PHeight=200

        PWidth=200*temp

            elseif temp=1 and pd(1)>200 then

               PWidth=200

                 PHeight=200

            else

              PWidth=pd(1)

                PHeight=pd(2)

      end if
 
      set getImgsize=nothing

      end if

    set f=nothing

    end if

%>

<a href="<%=rs("html")%>"><img src="<%=productImg%>" width="<%=PWidth%>" height="<%=PHeight%>" border="0">    </a>    </td>

  </tr>

  <tr>

    <td align="center"><div class="yaoqiu1" style="font-family:Monotype Corsiva;font-size:20px;"><%=rs("productName")%></div></td>

  </tr>

</table>   

 <%

    rs.movenext

    end if

%>
 
        </td>

<%

    next

%>

  </tr>

<%

    n=n+1

  loop

%>

</table>

<table width="778" border="0">

  <tr>

    <td width="650"> </td>

    <td width="118"> </td>

  </tr>

</table>
 
<table width="600" height="56" border="0" align="center">

  <tr>

    <td><table width="95%" align=center>

      <form action="<%=request("Script_name")%>?Category=<%=Category%>" method="post">

        <tr>

          <td width="80" align="center" class="yaoqiu"><%

  if page>1 then

%>

                <a href="<%=request("Script_name")%>?page=1&Category=<%=Category%>">First</a>

                <%

  else

%>

            First

            <%

  end if

%>

          </td>

          <td width="80" align="center" class="yaoqiu"><%

  if page>1 then

%>

                <a href="<%=request("Script_name")%>?page=<%=page-1%>&Category=<%=Category%>">Previous</a>

                <%

  else

%>

            Previous

            <%

  end if

%>

          </td>

          <td width="80" align="center" class="yaoqiu"><%

  if page<rs.pagecount then

%>

                <a href="<%=request("Script_name")%>?page=<%=page+1%>&Category=<%=Category%>">Next</a>

                <%

  else

%>

            Next

            <%

  end if

%>

          </td>

          <td width="80" align="center" class="yaoqiu"><%

      if page<rs.pagecount then

%>

                <a href="<%=request("Script_name")%>?page=<%=rs.pagecount%>&Category=<%=Category%>">Last</a>

                <%

  else

%>

            Last

            <%

  end if

%>

          </td>

          <td width="105" align="center" class="yaoqiu"><div align="right">Goto</div></td>

          <td width="38" class="yaoqiu"><div align="right">

            <select name="page" onChange="javascript:submit();">

              <%

  for i=1 to rs.pagecount

%>

              <option value="<%=i%>"

<%

  if i=page then

%>

  selected

<%

  end if

%>

  ><%=i%></option>

              <%

  next

%>

            </select>

          </div></td>

          <td width="69" class="yaoqiu">page</td>

        </tr>

      </form>

    </table></td>

  </tr>

</table>

<%

        end if

        rs.close

        set rs=nothing

        closeconn

    end if

%>

<!--end product list-->

    </td>

    <td width="111" valign="top"> </td>

  </tr>

</table>
 
</body>

</html>

If I leave the script as is, I get this error message:

Microsoft JET Database Engine error '80004005'

Selected collating sequence not supported by the operating system.

/productlist.asp, line 61

If I remove the first 3 lines - I get this message:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'openconn'

/productlist.asp, line 55

Can anyone give me some assistance?

Jun 23 '07 #1

Subscribe Reply

1287

jhardman

3,406

Recognized Expert Specialist

It looks like 'openconn' is some kind of function call, but the function is in one of the include files, so you definitely need those includes.

The original error, regarding the collating sequence seems to be in regards to the 'conn' object. This might easily be messed up when the web app was transferred from one host to another, and I would suggest you look into that (it is also in one of the include files).

Jared

Jun 26 '07 #2

by: F. GEIGER | last post by:

When I start a py2exe-ed application I get the error 'ascii' codec can't encode character u'\xe9' in position 10: ordinal not in range(128) This is how I run py2exe: setup.py py2exe -O1...

Python

WinXP German and English .NET Framework

by: Eric | last post by:

Hi, Normally I'm developing evertime with the english versions of Win, VS.NET, ..NET etc. But know I have a german Win XP SP1 with IIS 5.1 installed. Anyway I would like to develop with...

ASP.NET

Private methods called from public methods

by: Robert | last post by:

Hi, I have been reading the article at http://www.crockford.com/javascript/private.html and I was wondering if there also was some way to be able to have private methods that can be called from...

Javascript

Access in Japan, China, Korea and Australia

by: ntbenson | last post by:

Hi, I am wanting to develop a database in Australia and also have copies of the database used in other offices. (Japan, China, Korea and Australia) If i develop the database in English in...

Microsoft Access / VBA

(part 2) Han from China answers your C questions

by: George Orwell | last post by:

Returning int pointer ? Mahendra said: No, it's impossible to say. If your target system is a pre-C99 implementation, only 6 significant characters, case insensitive, are guaranteed in...

C / C++

(part 19) Han from China answers your C questions

by: George Orwell | last post by:

Ian Collins said: Richard Heathfield said: Ian Collins said: Phil Carmody said: Jeez, and let fire burn you to a crisp if you should discuss threads on comp.lang.c. Anyone who was...

C / C++

(part 30) Han from China answers your C questions

by: Borked Pseudo Mailed | last post by:

Error handling in C Nick Keighley said: ... ... To the OP, please be aware that Nick Keighley is a known troll and is deliberately providing you with unsound advice. You asked for error...

C / C++

(part 29) Han from China answers your C questions

by: Nomen Nescio | last post by:

What is this? Eric said: That looks like either someone's poor coding or someone's poor pasting for an implementation of offsetof() from stddef.h. The (char *) leads me to think that there's...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

Similar topics