Garbage after statement while using WHERE [Last Modified Date] >=$(vLastExecTime) and [Last Modified Date] < $(vExecTime)

[#1]

Hi All,

I'm Getting an error "Garbage after statement" while using WHERE [Last Modified Date] >=$(vLastExecTime) and [Last Modified Date] < $(vExecTime).

when i remove " WHERE [Last Modified Date] >=$(vLastExecTime) and [Last Modified Date] < $(vExecTime).0" from my script its working fine.

Please help me if any one can.

Thanks in Advance...

[tresesco · Accepted solution]

Try putting single quotes around variables like:

WHERE [Last Modified Date] >= '$(vLastExecTime)' and [Last Modified Date] < '$(vExecTime)' ;

If the date formats match, this should work.

[hic]

Probably because your variables are texts - a time stamp and a date. If so, you can either write your where clause with single quotes:

WHERE [Last Modified Date] >='$(vLastExecTime)' and [Last Modified Date] < '$(vExecTime)'

or you can define the variables numerically:

Let vLastExecTime = Num(...)

and write the where clause with numeric expansions:

WHERE [Last Modified Date] >=$(#vLastExecTime) and [Last Modified Date] < $(#vExecTime)

HIC

[rwunderlich]

Your variables vLastExecTime and vExecTime may not be initialized correctly. Look in the Document Log to see what values are being substituted in the WHERE clause.

-Rob

http://robwunderlich.com

[#5]

Thanks...

It is working fine..

Thanks lot.

[#6]

Thanks...

Both Solutions are working fine

Thanks lot