Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 5th, 2006, 06:41 AM
Registered User
 
Join Date: Dec 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default MY SQL to ACCESS 80040e14'

Here is the sql statement but i am getting an error on this can someone help it works fine in MySql

  displaySQL = "SELECT * FROM cinemas, (SQRT(abs("&east1&")*abs("&east2&")+ abs("&north1&")*abs("&north2&"))) AS distance FROM postcodes JOIN cinemas ON cinemas.outcode = postcodes.postcode HAVING distance <= 15000 ORDER BY distance;"

 
Old December 18th, 2006, 08:56 AM
Friend of Wrox
 
Join Date: Oct 2006
Posts: 114
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Could you add Response.Write displaySQL into your code, after the above line so that you can see the SQL statement that is being generated. Would then suggest that you try that as a query on the database, away from ASP and see if it works. You may get a clearer idea of what's going wrong with it.

Regards,

Sean Anderson





Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle error '80040e14' Nitin_sharma Oracle 2 November 5th, 2008 06:49 AM
SQL Server error '80040e14' JA1 SQL Server ASP 1 April 11th, 2006 09:26 AM
IIS 6 error 80040e14 Walkabouttigger Access ASP 0 August 8th, 2005 03:08 AM
HELP!!! Jet SQL: Error (80040e14) Coldendus Access VBA 3 December 14th, 2004 08:12 PM
error '80040e14'... only for some not all!?? dancrocker Classic ASP Databases 18 June 10th, 2004 11:15 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.