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