2. ASPRunnerPro General questions
  3. SQL Error - primary key missing in where clause
This topic is locked

SQL Error - primary key missing in where clause

 		7/2/2006 9:42:09 PM
ASPRunnerPro General questions
N
 nealwalters author

The programs for my first table worked fine. However, for my second table (separate project), I get a SQL error when I click the "Edit" button from the "List" screen. I had to add debug to the program, and I see it generates this SQL:
SQL=select [upsell_id], [upsell_title], [upsell_purchase_prod_id], [upsell_upsell_prod_id], [upsell_sales_text], [upsell_location] From [dbo].[upsells] where (=1)
Any ideas why the where clause is wrong. It should say "where [upsell_id] = 1" (I clicked on the first row in the table which has an id of 1).
During the setup, ASPRunner correctly selected upsell_id as the "Selected Key Columns" and I did not change it.
Thanks,

Neal
Alexey admin 7/3/2006

Neal,
looks like you mixed up the files from different ASPRunner projects in one folder.

Rebuild your projects and put them into separate folders on your server.
N
 		nealwalters author 7/4/2006

Neal,

looks like you mixed up the files from different ASPRunner projects in one folder.

Rebuild your projects and put them into separate folders on your server.


So I cannot put everything in the root directory??? Why not?

I was guessing I could share the include files and the images, seems redundant to have all that stuff multiple times on the server.
Thanks,

Neal