When I tried the "Dim SQL2 As String," I get the error message below.

Microsoft VBScript compilation (0x800A0401)
Expected end of statement

That should not be used in ASP. It is VB code. Please see my previous post on this.

_________________________
-Vijay G
Strive for Perfection

I will play around with the single and double quotes. I will update you tomorrow. Thank you.

Leon

Hi ViJay,

I think I finally have my problem solved. You were right; it does have something to do with my double and single codes. I used "escape sequence" to add a double quotes at the start and end of the query string. But what i forgot is that if I put the string in a variable, and when i reference them, I don't need to have double quotes. Anyway, sorry to have caused you so much trouble. Thank you soooooooooooo very much for all your help.

Leon

Hi Leon,

Yes. That's what I was suspecting, as asked in one of my posts.
Also when searched on the net regarding your error message, I got some stuffs related to Quotes being misused there, that caused the error.

Anyways, it is a learning again. Good luck.
Cheers!

_________________________
-Vijay G
Strive for Perfection