This topic is locked

Northwind Master-detail relationship Testing

1/8/2006 10:57:28 PM
ASPRunnerPro General questions
J
jim-mullowney@bresnan.net author

I've been working on a website to allow users to upload files using master-detail data structure. But I kept getting an error when I tried using the site after I posted it. So I grabbed the Northwind database from MS and ran it through ASPRunnerPro 4.0 (Build 65).
When I drill down to Order detail, then try to return to orders using the 'Back to list' link, I get the follow error (Same error from the site I started with).
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[Microsoft][ODBC Microsoft Access Driver] Missing ), ], or Item in query expression '([Order Details].[OrderID]=10248'.

/Northwind/Order_Details_list.asp, line 743
Browser Type:

Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Page:

GET /Northwind/Order_Details_list.asp
I can send you the code, or you could recreate it in about 5 minutes. I think there is a little more tweaking required in that section code.
Sincerely, <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2288&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />

Newbie.

Sergey Kornilov admin 1/9/2006

Jim,
this problem was fixed in build 69. Please download and use it.