Search Results getting messed up with INNER JOIN
Hi; I built the search results pages with DA and then modified the SQL to use an inner join to get more meaningful info to display in the results view.
I had to alias 2 fields, but the search fails when I select either of these options... centerid and contact
contactinstores_search.asp
The issues are:
1) Selecting either the centerid or contact give me a 500 error
2) The Default Store checkbox behaves strangely (the field is a char & I tried several combinations of default values
3) How do I get ALL the results without selecting any search criteria?
Modified SQL ...
SELECT dbo.contactinStores.id as ID, dbo.GPCWebViewCust1.CustName, dbo.contact.name, dbo.contactinStores.centerid as centerid, dbo.contactinStores.contactid as contactid, dbo.contactinStores.defaultstore as defaultstore
FROM dbo.contact INNER JOIN dbo.contactinStores ON dbo.contact.contactid = dbo.contactinStores.contactid INNER JOIN dbo.GPCWebViewCust1 ON dbo.contactinStores.centerid = dbo.GPCWebViewCust1.CenterID
Thanks in advance