2. ASPRunnerPro General questions
  3. Zero records displayed
This topic is locked

Zero records displayed

 		7/4/2003 8:29:35 PM
ASPRunnerPro General questions
author

After I finish, and run the app, it provides a really nice web page with headings and a great search function, but no records are displayed - even though it says if found 4. In place of the records, I get a hyperlink with the wording:

WebPagination(1,1);
that if I click on it, I get the error:

ASP error happened
Technical information

Error number -2147217900

Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CID='.

URL /CLBS4/Customer_master_edit.asp

SQL query select CID,cname ,ccontact ,caddress1 ,caddress2 ,ccity ,cstate ,czip ,cphone1 ,cfax1 ,cbillcontact ,cbillphone ,Caltcontact ,caltphone ,caltfax from [Customer_master] where CID=
Sergey Kornilov admin 7/8/2003

Hi,
please make sure that CID field is not empty for all records in your database.
Sergey Kornilov
500046 7/9/2003

I am having the same issue. . . .
Error number -2147217900

Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.

URL /XP Upgrade/XP_Upgrade_edit.asp

SQL query select ID,NAME ,Floor ,Quadrant ,Machine_Name ,Machine_Type ,OS ,Make_Model ,Serial ,OEM_Key ,Mem_RAM from [XP_Upgrade] where ID=
I have read the entry above and checked the ID field to ensure it's not empty for all records in your database. No change.
Any ideas?
Sergey Kornilov admin 7/10/2003

Hi,
please download latest update here (updated July 9th):

http://www.asprunner.com/files/asprun22.exe
It fixes this problem that usually happens when key column don't exist on the list page.
Sergey Kornilov
500047 7/13/2003

I am running ver. 2.2. I really like this program,I like the layout it produces, but if I can't get it to display records I can't use it. Any other ideas?
500048 7/13/2003

OK, I downloaded the latest version and installed it, rebuilt the web, and same thing - shows 4 records found, but displays none. Just the following where the records should be:
WritePagination(1,1);
500049 7/13/2003

OK, I rebuilt the web in another virtual directory, and now it brings up all records, however, when I edit a record and click save, get the following error:
ASP error happened
Technical information

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

URL /CLBS6/Customer_master_edit.asp

SQL query update [Customer_master] set cname='Dane', ccontact='Dane Contact', caddress1='111 West Road', caddress2='', ccity='Webster', cstate='TX', czip='77777', cphone1='281-222-2222', cfax1='', cbillcontact='', cbillphone='', Caltcontact='', caltphone='', caltfax='' where CID=3 and cname='Dane' and ccontact='Dane Contact'
Sergey Kornilov admin 7/13/2003

Mike,
this sounds much better. You need to set write permissions to that folder where your database located.
Please read this artcile: http://www.asprunner.com/forums/index.php?showtopic=6 for more information.
Sergey Kornilov