Hello everyone,

My developer changed the delete statement to the following, which has cleared up the fatal error problem. (followed JDixon's suggestion)

string SomeID="0";

strsql="select id from DVD_I_Have where userid="+Session["userid"].ToString()+" and DVDID="+DVDID+" and onhold=0";

dr1=(SqlDataReader)DL.ExecuteCommandWithTransaction(strsql,ExecutionType.ExecuteReader,objcon,myTrans);

if(dr1.Read())

{

 SomeID=dr1["id"].ToString();

}

dr1.Close();

strsql="delete...

Hi SQLBill,

Thanks for the reply! here's what I got...

Run this query:

SELECT ServerProperty('Edition'),

ServerProperty('ProductVersion'),

ServerProperty('ProductLevel')

RESPONSE: STANDARD EDITION 8.00.2039 - SP4

Have you checked the Windows Event Viewer Logs for related error messages?How...

Thank you for the quick replies!

Lowell, the error message is consistent - I get it every time I execute the above statement.

As far as the complexity of the statement goes, its my developers...

Much thanks to everyone that replied!

I used Lowells statement as it did return all entries regardless of the time entered, and since I only need to run it once per day, (although appreciated!) the...

Hey Frank, not a problem. Thanks for the help and I look forward to your input the next time i'm stuck.

Take Care,

Rob

Ah but Frank - I did provide feedback that my problem was solved  in a earlier post!

-----------------------------------------

I took your advice - found what I  needed - it worked great!

I hear you! The worst part of running a website is having to repeat the same information over and over again to your customers.

Take...

Boy Frank, you germans are so demanding

I took your advice - found what I  needed - it worked great!

Hi Frank,

It's not very likely. I am thinking of adding the UK and Australia to my service, but I would not venture outside of providing services for   countries which do not have english...

Thanks gdefi, between wz700 and yourself you both made my day!.

The statement works perfectly and functions exactly as intended. It will certainly add a  professional touch to my monthly e-mail updates,...

wz700.  Once again you were bang on and the statement worked fine, but regretfully my program won't pickup the new column created by the count function because it's not defined in...

Thanks very much wz700, it worked like a charm.

Now that you have helped me accomplish that function, Could you tell me if it would be possible to calculate the number of duplicate...

Jay thanks for the reply,

I know very little about stored procedures but I'll try and figure it out and put it to work. Is it possible to get the results...

David - Npeters thanks for the reply,

David - the FK is a single column so I won't have a problem there.

Npeters - The reason I want to create a separate...

Thanks for the reply David,

I read it in a posting on a SQL related site. I am glad to hear the PK can be used in more than 1 table...