My field name is "domain" - SQL Query problem

[worldwise]

Hi,

I have an Access backend with a field named 'domain'. I guess this must be a reserved word/keyword because I'm running into problems when running a query on the DB.

SELECT * FROM myTable WHERE domain = 'blah'

the error that comes back is: Unspecified Error.

I thought it might help to quantify the field by going: myTable.domain but I get the same error.

Is there any workaround? I have already built many pages using this field so changing the field name from 'domain' is really not an option.

Thank you,

-Kevin

 

[FesterSXS]

if it is a reserved word then put [red]square brackets[/red] around it in your SQL string:

SELECT * FROM myTable WHERE [red][[/red]domain[red]][/red] = 'blah'

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[damber]

domain isn't a reserved word for Access or SQL Server

Access Reserved Words:

http://support.microsoft.com/defaul...port/kb/articles/Q109/3/12.asp&NoWebContent=1

SQL Server:

http://www.bairdgroup.com/reservedwords.cfm

You will need to debug your code to determine where the failure actually occurs.. is it the connection or is it the SQL statement - try running the SQL statement directly in Access. Also if you are generating it dynamically, response.write the result and make sure that it is what you expect it to be.

A smile is worth a thousand kind words. So smile, it's easy!

 

[DotNetGnat]

show us your actual query...havent come across the word domain referred to as a keyword...there might be problem somewhere else...

-DNG

 

[worldwise]

When I put brackets around the word, it works.

SELECT * FROM myTable WHERE domain = 'blah' <--ERROR

SELECT * FROM myTable WHERE [domain] = 'blah' <-- WORKS!!!


It must be a reserved word then. But whatever the reason, its works now so I'm good! Thanks everyone for your posts!

-Kevin