we had a similar problem in one of our ASP pages...our situation was a case wherein the user clicks on a button and the data from the ASP page is...

whoops...error in the query - alias for the table should be F1 instead of F...

select distinct(F2.machine_id),F1.product_key

from Forum F1,Forum F2 where

cast(F2.machine_id as varchar)***'#'***cast(F1.product_key as varchar)

not in

(

select cast(machine_id as varchar)***'#'***cast(product_key...

Hope this helps(and I hope this results in what was needed) - this is a really late in the day query reply....

note : *** is the plus sign...I can't seem...

Hi,

I came across the following in the Microsoft Knowledge base articles...

If you delete text or image data, space may not be reused when new data is inserted. This can lead...

Hi,

We use SQL Mail along with our exchange server and we get errors like "Unable to resolve email address" etc if there are two similar email addresses on the exchange...

hmmmmm...that seems so obvious - now that I think of it.... 😉

I have to learn to use this thing called the brain more often.....

This works fine......thanks.........

Thanks a lot for the info on UNION and UNION ALL...

I was using only UNION in a couple of places and I am now using UNION ALL...before the SPs went...

Hi,

Here is my response based on what I understood :

There are tables Table1 and Table2 and you want to count the number of rows in Table1 and Table2 and store...

I think I get it now...

CTF = Request.form("CompanyNameTF")

CTF = Replace(Replace(CTF,"&","AND"),"'","''")

I hope this is what you are looking for.....

Hi,

I assume that you are using the VBScript Replace function...that works fine on my system here...there's no problem replacing the "&" by "AND"...or is there something I am missing out...

problem solved... 🙂

the Exchange mail account that is configured on the server had reached its limit...we just increased this limit and its working fine now...

I agree with what JayMorrison has said...the same things work for us...with just one addition :

Just restart MSSQL after you have configured the SQL Mail...we too had similar problems...

*Finally comprehension dawns upon winash*

Thanks a lot... 🙂

Managing senior programmers is like herding cats.

Hi,

I have checked with these commands...they still give me the SQL Login details(like dbo or any other SQL Login that is being used for access)and not the NT User details...

Is...