ASP SQL Select Statement

Here is the code I am having trouble with:



sqlString = "SELECT current_weekday, " &_

"current_open_time, current_close_time FROM current_hours " &_

" WHERE current_date = " & (Date)

SET RS = Con.Execute( sqlString )



I have accessed this record using another "WHERE" statement and then
compared "current_date" and "(Date)". These values are equal with no leading
or trailing blanks. There is something wrong with the "WHERE" statement, but
I don't know what. Does anyone have any suggestions?

Ray
Sun Oct 17 18:20:49 CDT 2004

Here are my suggestions.

1. Post in microsoft.public.inetserver.asp.db
2. When posting there, indicate what "having trouble" means - do you get an
error?
3. When posting there, let us know what database you're using, Access, SQL
2000, DB/2, etc.

Ray at home

<westernnord@webtv.net> wrote in message
news:ukuoveJtEHA.2700@TK2MSFTNGP10.phx.gbl...
> Here is the code I am having trouble with:
>
>
>
> sqlString = "SELECT current_weekday, " &_
>
> "current_open_time, current_close_time FROM current_hours " &_
>
> " WHERE current_date = " & (Date)
>
> SET RS = Con.Execute( sqlString )
>
>
>
> I have accessed this record using another "WHERE" statement and then
> compared "current_date" and "(Date)". These values are equal with no
> leading or trailing blanks. There is something wrong with the "WHERE"
> statement, but I don't know what. Does anyone have any suggestions?
>
>

jeff
Mon Oct 18 11:19:45 CDT 2004

On Sun, 17 Oct 2004 15:21:40 -0700, <westernnord@webtv.net> wrote:

>Here is the code I am having trouble with:
>
>
>
>sqlString = "SELECT current_weekday, " &_
>
>"current_open_time, current_close_time FROM current_hours " &_
>
>" WHERE current_date = " & (Date)
>
>SET RS = Con.Execute( sqlString )
>
>
>
>I have accessed this record using another "WHERE" statement and then
>compared "current_date" and "(Date)". These values are equal with no leading
>or trailing blanks. There is something wrong with the "WHERE" statement, but
>I don't know what. Does anyone have any suggestions?

Not given the above information. It would help if you told us what
"trouble" you had, or even better, if you posted in an ASP database
group.

Jeff