Classic ASP Discussion - ambiguous date

Print Page | Close Window

ambiguous date

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4748
Printed Date: 30 March 2026 at 1:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ambiguous date

Posted By: cuedog
Subject: ambiguous date
Date Posted: 04 August 2003 at 10:28pm

I use mysql server and I am getting an error that I don't understand.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-max-debug]Column: 'submissiondate' in order clause is ambiguous

/search.asp, line 259

I got this error from an sql statement

sql = "Select * From articles INNER JOIN review ON (articles.articleID = review.ArticleID) Where articlehead like '%" & strKeyWord & "%' OR articletopic like '%" & strKeyWord & "%' OR articleintro like '%" & strKeyWord & "%' AND validated = 1 Order By submissiondate;"

submissiondate is a timestamp datatype

What does this mean?

Replies:

Posted By: ljamal
Date Posted: 04 August 2003 at 11:27pm

Probably that there is more than one field in the join that is called submissiondate.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming