Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 ASP & mySQL help		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

seahorse
Senior Member

USA
1075 Posts
Posted - 18 September 2003 :  21:59:53  Show Profile  Visit seahorse's Homepage
Hi Folks,

I was wondering if someone could help me with this. I've got this SQL query.

SELECT COUNT(DISTINCT link_id ) as countID FROM tblPOPULAR WHERE sdelete_flag='0'

it runs fine within mySQL, but when I try to use it in an ASP page, I get this error. Can anyone give me any pointers on how I can work around this problem?

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/popular.asp, line 74


Thanks.
Ken
===============
Worldwide Partner Group
Microsoft

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 18 September 2003 :  23:23:48  Show Profile
Taking a guess at it but maybe it is having a problem with the word 'delete' in the 'sdelete_flag' variable.
Support Snitz Forums
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 18 September 2003 :  23:57:23  Show Profile
My guess is it's something to do with a limitation of COUNT(DISTINCT ...

Strictly a swag :)
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

seahorse
Senior Member

USA
1075 Posts
Posted - 19 September 2003 :  04:52:46  Show Profile  Visit seahorse's Homepage
quote:
Originally posted by Davio

Taking a guess at it but maybe it is having a problem with the word 'delete' in the 'sdelete_flag' variable.


No, I don't think so I've actually had no problems with my queries and 'delete' since I've added the 's' to the 'delete_flag' field.
Ken
===============
Worldwide Partner Group
Microsoft
Go to Top of Page

seahorse
Senior Member

USA
1075 Posts
Posted - 19 September 2003 :  04:55:08  Show Profile  Visit seahorse's Homepage
quote:
Originally posted by Doug G

My guess is it's something to do with a limitation of COUNT(DISTINCT ...


I think you might be right, but I'm at a lost as to how to get around it.
Ken
===============
Worldwide Partner Group
Microsoft
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 19 September 2003 :  11:27:13  Show Profile
What version of the MySQL ODBC drivers are you using? You might try getting the latest MyODBC from www.mysql.com

There is a not-free OLEDB driver for MySQL. I haven't ever tried it.

Try using MyODBC directly instead of wrapping it in the MS OLEDB for ODBC provider (i.e., a dsn-less MyODBC connection string).
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07