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