This topic is locked

The column prefix does not match with a table name or alias name used

9/26/2006 1:07:55 PM
ASPRunnerPro General questions
S
Sushy99 author

Hi all, i'm in the evaluation process but i'm stuck with this error.
whenever i try to edit a record or copy it i get this message:

Microsoft OLE DB Provider for SQL Server error '80040e14'

The column prefix 'EMEA_TBL_Company' does not match with a table name or alias name used in the query.

/DBManagement/EMEA_TBL_Company_edit.asp, line 939


the query is this:

select [ID], [Name], [Industry], [Country], [Com_Size], [App1], [App2], [App3], [DB], [ValueDriver], [Logo], [Reference], [CustomerStory], [AE] From [ngrosoli].[EMEA_TBL_Company] where ([EMEA_TBL_Company].[ID]=15)


does anyone have a clue on this?

any help is really appreciated

J
Jane 9/27/2006

Please zip and send generated ASP files to [email=support@xlinesoft.com]support@xlinesoft.com[/email] along with project file and your sample database for investigation.

I'll find what's wrong with your project running it on my test box.