I have a database I have a table where one of the fields (afl_url) contains a URL.
In another database I have a table wherein the records MAY contain a field which may have a matching URL (I only need up to the .com part)
I am trying to do MTD and YTD queries from the 2nd database where the data range is appropriate and the url contains a matching string (up to the .com part, ignoring the remainder of the url).
My date fields are defined as a 'General Date'.
What I have is this:
#str_StartDate# is defined as either 01/01/2007 or 04/01/2007 and is generated with str_StartDate = RTrim(Now()).
Not being a db guru I am just certain that this query string will not work so I thought I'd ask for a little help before I start coding this!
And any help would be greatly appreciated!
Phil
In another database I have a table wherein the records MAY contain a field which may have a matching URL (I only need up to the .com part)
I am trying to do MTD and YTD queries from the 2nd database where the data range is appropriate and the url contains a matching string (up to the .com part, ignoring the remainder of the url).
My date fields are defined as a 'General Date'.
What I have is this:
Code:
Select * from users Where usr_date > #str_StartDate# and usr_date < #Now()# and usr_referrer = afl_url
#str_StartDate# is defined as either 01/01/2007 or 04/01/2007 and is generated with str_StartDate = RTrim(Now()).
Not being a db guru I am just certain that this query string will not work so I thought I'd ask for a little help before I start coding this!
And any help would be greatly appreciated!
Phil