issues with Randomize code

HI there, a while ago I was helped to create this code below:

Set Header=oConn.Execute("SELECT * FROM site_header WHERE brand_ID='"&SubDomain("sites.brand_ID")&"' AND header_live=TRUE ORDER BY RND(-10000000*TimeValue(Now())*header_ID)")
HeaderImage=Header("header_image")

Select allOpen in new window

However I am getting this error:

Microsoft VBScript compilation error '800a03ee'

Expected ')'

Response.Write("<td width="&SiteWidth&" height=300 align=center valign=bottom background="&BrandImageDir&"/"&HeaderImage&" bgcolor="&SubDomain("brand_bg-color")&" rowspan=2 style='background-size:cover;background-position:center,center'>")
------------------------------------------------------------------------------------------------------------^

Select allOpen in new window

I cannot figure out why this is the issue

help!?