Have a select question

[byteofram]

I am trying to do a select statement and I am using the following format:

select *
from database
where something = '1998'

However, the problem is the word select turns blue like it should, but the words from and where do not and the statement does not work. However, if I go to the SQL server and run the exact same statement, it works great. Can anyone help? If need be, I will send you the exact code if that would help.

 

[Guest_imported]

You must make sure that the code is wrapped at the end of every line. This is provided that you are using ASP. Use

&_ to wrap the lines together, make sure there is a space at the end of each line or the beginning and that each line is in quotes. Hope this help