ASP select/where query

[PAz]

Hi, need a little help with my ASP sql query...

I'm still a beginner with this sort of thing despite using it for years , and cant get this to work.

My news system uses a session based login, and I want users to only be able to edit news that theyve posted...

Ive been trying to work out the select from where query but cant seem to get it to work, anyone got any ideas?

What I've got so far is below..

sqltemp = "SELECT * FROM tblNews WHERE tblNews.newsAuthor = '& (Session("Username")) &' ORDER BY newsID ASC"

Any help appreciated, thanks.

 

[GravyMonster]

you were close, just forgot the "s...

sqltemp = "SELECT * FROM tblNews WHERE tblNews.newsAuthor = '" & session("Username") & "' ORDER BY newsID ASC"

 

[PAz]

Aha, cheers

I had tried "" but never thought of '"

Thanks a lot!