it doesn't work... maybe problem lies in W2k where mySQL server is
installed?
Mariusz Muszalski
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 21 August 2001 11:39
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: mySQL and ASP
>
>
> I had a similar problem before, asp would not return where any
> bigint types
> where involved in the query. The fix was to check the 'convert bigint to
> int' box
> in the myodbc settings and everything came back just fine. might
> be worth
> a try
>
> Sean
>
> -----Original Message-----
> From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
> Sent: 21 August 2001 02:50
> To: [EMAIL PROTECTED]
> Subject: mySQL and ASP
>
>
> I've just spotted something STRANGE in mySQL... using mySQL query from ASP
> (connection via mySQL ODBC driver ver 2.50.37.00). MySQL query returns
> normally records, but returns nothing with ASP...
>
> Code (VBscript) is here:
>
> <%@ LANGUAGE="VBSCRIPT" %>
> <%option explicit%>
> <%
> Dim MyConn
> Dim SQL_query
> Dim RS
>
> Set MyConn = Server.CreateObject("ADODB.Connection")
> MyConn.Open("DSN=mySQL_test;Username=root")
>
> SQL_query = "SELECT Number, Count(*) as Count FROM Results WHERE GameID=1
> Group by Number"
>
> Set RS = MyConn.Execute(SQL_query)
>
> while not RS.eof
> ..
> wend
>
> MyConn.Close
> %>
>
> Query is pretty simple, and normally under mysql console returns three
> records. Table structure is below:
>
> #
> # Table structure for table 'results'
> #
>
> CREATE TABLE results (
> GameID int(10) NOT NULL default '0',
> Number int(10) NOT NULL default '0'
> ) TYPE=MyISAM;
>
> #
> # Dumping data for table 'results'
> #
>
> INSERT INTO results VALUES (1,22);
> INSERT INTO results VALUES (1,22);
> INSERT INTO results VALUES (1,23);
> INSERT INTO results VALUES (1,24);
> INSERT INTO results VALUES (1,23);
>
> Question is WHY with ASP it returns NOTHING ????
>
> Regards,
>
> Mariusz Muszalski
>
>
> ---------------------------------------------------------------------
> 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
