2. ASPRunnerPro General questions
  3. MYSQL-Problem with Version 4.0
This topic is locked

MYSQL-Problem with Version 4.0

 		1/15/2006 12:14:25 PM
ASPRunnerPro General questions
Pfeiffer author

Hello,

I use MYSQL 4.2 with ODBC and have no problems with version 3.2
In version 4.0 (Build 79) the list page is not shown. The debugger stopps at line
maxpages = maxRecords \ nPageSize in list.view
Error message of debugger is : Typen unverträglich
The variable nPageSize = 20 and maxRecords = 59 are set properly
The problem is that maxrecords is cdbl and nPageSize not. So the division fails !!

I changed the code an now the problem is solved :
maxpages = cdbl(maxRecords) \ cdbl(nPageSize)

if cdbl(maxRecords) mod cdbl(nPageSize) > 0 then maxpages =maxpages +1

if cdbl(mypage) > cdbl(maxpages) then mypage = maxpages
Best regards

Uwe Pfeiffer
Sergey Kornilov admin 1/16/2006

Uwe,
thank you for pointing me to this. I'll take a closer look.
Pfeiffer author 1/17/2006

Uwe,

thank you for pointing me to this. I'll take a closer look.


Hello,

this problem only occurs on my Windows 2003 Web Server. On a different Server 2000 everythink works.

Maybe it's a special problem of vbscript but my changes will work on every server.
Best regards

Uwe Pfeiffer