i am new on MySQL and i have some problem with between ... and ...

[Massoud Hosseinali]

Im using asp (vb script) and mysql for my web site, im changing my database from access to mySQL
when i use this line for SQL

"SELECT * FROM tbl_games WHERE game_highlight=1 AND (game_date BETWEEN CAST('" & DateAdd("d", pastdaysi, ServerTime) & "' AS datetime) AND CAST('" & DateAdd("d", futuredaysi, ServerTime) & "' AS datetime)) ORDER BY game_date ASC;"

and the result is empty ...

donno whts the problem with this query ... ?
any help ?



Edited 1 time(s). Last edit at 10/06/2011 12:27AM by Massoud Hosseinali.