2. ASPRunnerPro General questions
  3. HELP!!! ME!!! PLEASE!!! Getting al
This topic is locked

HELP!!! ME!!! PLEASE!!! Getting al

 		7/20/2005 2:51:24 PM
ASPRunnerPro General questions
C
 chuckbragg author

I just downloaded the newest version of ASPRunnerPro and tried updating a few things on my existing site and now nothing but problems. Nothing will work right. I can't edit some tables that I could before, I can't delete items in some tables I could before. Is this major bug or what? Do I need to go back and recreate the entire site, and if so how come querys that I used before now can not be updatable?

I am totally confused.
Here is some examples of the errors I am getting:
1.) Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/ASPRunnerPro/Customers_add.asp, line 904
2.)Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/ASPRunnerPro/Customers_edit.asp, line 797
3.)Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/ASPRunnerPro/Customers_view.asp, line 53
4.)Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/ASPRunnerPro/OrderDetailsQuery_add.asp, line 1226
5.)Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/ASPRunnerPro/OrderDetailsQuery_edit.asp, line 1101
Any help would be greatly appreciated since My site is now down due to these errors.
Chuck Bragg

Production Manager

PreMedia Concepts

c:561-301-5034

e:chuck@dpmc.biz
C
 		chuckbragg author 7/20/2005

OK- It seems that the newest version of the software doesn't allow updating a query when the query has more than one table. Even if the 2nd table doesn't do anything but limit the list of items being displayed in the "_list.asp". I was able to use this exact same query before using ASPRunnerPro3.1. What Happened? Any Ideas?
Sergey Kornilov admin 7/21/2005

Hi,
Please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.
Sergey Kornilov admin 7/21/2005

Hi,
errors 1,2,3 occur because the CustomerHiddenIdfield doesn't exist in Customerstable.

You need either to add this field to Customers table or to rebuild project in ASPRunner.
Errors 4,5 occur because SQL query isn't correct.

The correct query is:

SELECT [Order Details].*

FROM [Order Details] INNER JOIN Orders ON [Orders].[PurchaseOrderNumber]=[Order Details].[PO Number]

WHERE ((([Orders].[JobClosed])=False));