from:"Morsky Juha"

VS: Strange problem with MySql IIS ASP

2002-10-25 Thread Morsky Juha

Millions of thanks!

Now it's working perfectly!!!
Once again MS bugs...

Regards
Juha

-Alkuperäinen viesti-
Lähettäjä: Terence [mailto:terencel;sunway.edu.my]
Lähetetty: 23. lokakuuta 2002 4:54
Vastaanottaja: Morsky Juha; [EMAIL PROTECTED]
Aihe: Re: Strange problem with MySql  IIS  ASP



I had the same problem. It's in your connection, somehow ASP doesnt retrieve
the results when doing a select and count, so you need to use a connection
like this:

dim myConn
Set myConn= Server.CreateObject (ADODB.Connection)
myConn.ConnectionString =
Driver={MySQL};SERVER=xxx.xxx.xxx.xxx;DATABASE=mydb;UID=user;PWD=pwd;PORT=3
306;OPTION=16384;
myConn.Open

Hopefully this works.

Cheers
Terence





Hi All!

I've Select like this:

SELECT ExpDepDate, ActArrDate FROM oceandata

It works beautifully

But When I modify it like this

SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata

I'll get nothing, just a empty screen with a browser!

I'm using Ultradev to create this and when I test it in Ultradev it works
good, same in MySQL CC Admin. But not on IIS?
ASP look like this:

%@LANGUAGE=VBSCRIPT%
!--#include file=../../Connections/connMyIFDData.asp --
%
set Recordset1 = Server.CreateObject(ADODB.Recordset)
Recordset1.ActiveConnection = MM_connMyIFDData_STRING
Recordset1.Source = SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs
FROM oceandata
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%
%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
table width=100% border=0
  %
While ((Repeat1__numRows  0) AND (NOT Recordset1.EOF))
%
  tr
td%=(Recordset1.Fields.Item(ExpDepDate).Value)%/td
td%=(Recordset1.Fields.Item(ActArrDate).Value)%/td
td%=(Recordset1.Fields.Item(Act_Est).Value)%/td
  /tr
  %
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%
/table
/body
/html
%
Recordset1.Close()
%

Any help will be helpfull

Regards
Juha Mörsky


MySQL

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Strange problem with MySql IIS ASP

2002-10-21 Thread Morsky Juha

Hi All!

I've Select like this:

SELECT ExpDepDate, ActArrDate FROM oceandata

It works beautifully

But When I modify it like this

SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs FROM oceandata

I'll get nothing, just a empty screen with a browser!

I'm using Ultradev to create this and when I test it in Ultradev it works
good, same in MySQL CC Admin. But not on IIS?
ASP look like this:

%@LANGUAGE=VBSCRIPT%
!--#include file=../../Connections/connMyIFDData.asp --
%
set Recordset1 = Server.CreateObject(ADODB.Recordset)
Recordset1.ActiveConnection = MM_connMyIFDData_STRING
Recordset1.Source = SELECT ExpDepDate, ActArrDate, Count(Ref) as NoOfRefs
FROM oceandata
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%
%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
table width=100% border=0
  % 
While ((Repeat1__numRows  0) AND (NOT Recordset1.EOF)) 
%
  tr 
td%=(Recordset1.Fields.Item(ExpDepDate).Value)%/td
td%=(Recordset1.Fields.Item(ActArrDate).Value)%/td
td%=(Recordset1.Fields.Item(Act_Est).Value)%/td
  /tr
  % 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%
/table
/body
/html
%
Recordset1.Close()
%

Any help will be helpfull

Regards
Juha Mörsky
 

MySQL 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Strange problem with MySql IIS ASP

2002-10-18 Thread Morsky Juha

Hi All!

I've Select like this:

SELECT ExpDepDate, ActArrDate FROM oceandata

It works beautifully

But When I modify it like this

SELECT ExpDepDate, ActArrDate, (TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as
Act_Est FROM oceandata

I'll get nothing, just a empty screen with a browser!

I'm using Ultradev to create this and when I test it in Ultradev it works
good, same in MySQL CC Admin. But not on IIS?
ASP look like this:

%@LANGUAGE=VBSCRIPT%
!--#include file=../../Connections/connMyIFDData.asp --
%
set Recordset1 = Server.CreateObject(ADODB.Recordset)
Recordset1.ActiveConnection = MM_connMyIFDData_STRING
Recordset1.Source = SELECT ExpDepDate, ActArrDate,
(TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as Act_Est  FROM oceandata
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%
%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#FF text=#00
table width=100% border=0
  % 
While ((Repeat1__numRows  0) AND (NOT Recordset1.EOF)) 
%
  tr 
td%=(Recordset1.Fields.Item(ExpDepDate).Value)%/td
td%=(Recordset1.Fields.Item(ActArrDate).Value)%/td
td%=(Recordset1.Fields.Item(Act_Est).Value)%/td
  /tr
  % 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Recordset1.MoveNext()
Wend
%
/table
/body
/html
%
Recordset1.Close()
%

Any help will be helpfull

Regards
Juha Mörsky
 

MySQL 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Update problem in MySQL

2002-09-26 Thread Morsky Juha


Do anyone has a idea how to Insert (create SQLQuery) from onetable to an
other table as
decripted under:

Here is the orginal Table:

Table1:

Ref   | Timestamp | ActionDate
---+-+
001  |  DEP + 2002/01/02
---+-+
001  |  ARR + 2002/01/04   
---+-+
001  |  DLV + 2002/01/15   
---+-+
002  |  ARR + 2002/02/02   
---+-+
002  |  DEP+ 2002/02/03   
---+-+
002  |  DLV + 2002/02/18
---+-+
003  |  DEP + 2002/01/12
---+-+
003  |  ARR + 2002/01/14   
---+-+
003  |  DLV + 2002/01/25 


I should update Table one to Table2, which means that insted of 9 rows I
should have row per Ref 

Table2:

Ref   | Departure   |  Arrival| Delivery
---+-+--+
001  | 2002/01/02 + 2002/01/04 | 2002/01/15
---+-+--+
002  | 2002/02/02 + 2002/02/03 | 2002/02/18
---+-+--+
003  | 2002/01/12 + 2002/01/14 | 2002/01/25
---+-+--+

Thanks for your help
Juha

  

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

VS: Strange problem with MySql IIS ASP

Strange problem with MySql IIS ASP

Strange problem with MySql IIS ASP

Update problem in MySQL

4 matches

Site Navigation

Mail list logo

Footer information