Search results for query: *

I have zipped it up to save download time. http://profittoolplan.com/flash.zip The old link is now broken.

I have a decent sized project about 1000 frames and 20 layers. I just opened it up and all of my Text has dissapeared?? All of the frames / keyframes / motion tweens are there..but the text are gone. Does anyone know what could cause this? Or more importantly how i could get it back? Flash...

How can I use DTS To Automate a Backup of a specific database every nite

in the System.Web.Mail namespace I cant find where I can send mail when the smtp server uses authentication. I only get an error saying cannot access cdo object. Anyone have a solution for this ?

Is there an easy way to Retrive Data With A DataReader and Convert it into Comma Seperated Values? I remember reading about something like this before and now I need to use it.

sorry about that, I figured I would post here since it was semi relevant, either way if you look at my code, I was getting the for loops completly wrong. i changed == to != and removed the -1 from count and it works perfect. Thanks again.

I changed all of the full outer joins to left outer joins and get the results I needed Thank you!

I am trying to figure out how to get this query to return an EFT Amount also the Sum of the Direct Deposit Amounts. Sometimes there are no direct deposit Amounts, So i need to use Outer Joins. I almost have it figured out, but im getting an extra row with all of the Direct Deposits in the data...

Actually I read chiph's FAQ on Collections and found my new best friend, The Arraylist. All I did was change it from an Object array to an array list and Add and Remove, with removeAT was built in. public class ACHItems { public decimal TotalAmount=0; public...

AHA looking through the other posts I found a solution. select SalesReps.SalesRepId,sum(CASE when InvoiceItemCommissions.Paid = 0 THEN InvoiceItemCommissions.Amount ELSE 0 END) + sum(case when ToolCheckCommissions.Paid = 0 THEN ToolCheckCommissions.Amount ELSE 0 END) From SalesReps inner join...

That wont work because If one is Paid it still adds it, therefore returning 6 instead of 3.

Open the Services Applet in Administrative Tools and Select Properties on the context menu of the SQLSERVERAGENT Process. Then go to the Log On Tab, If you specify an account for it to log on to and that password changed, you have to update it there.

select SalesReps.SalesRepId,sum(InvoiceItemCommissions.Amount) + sum(ToolCheckCommissions.Amount) From SalesReps inner join Commissions On Commissions.SalesRepId = SalesReps.SalesRepId inner join InvoiceItemCommissions On Commissions.CommissionId = InvoiceItemCommissions.CommissionId inner join...

Thank you both so much, It works like a charm

Ok Before I try this Tell me what you think, Is it ok to just put the variables in the select statement ? INSERT INTO [ProfitTool].[dbo].[ToolCheckCommissions]([CommissionId],[ToolCheckId],[Amount],[CommissionAmount]) select...

Ok Currently my Insert Statement is another procedure that I call using EXEC but its just an insert statement. For future reference is there a way to adjust this method for exec procedureS?

I am using a typed array i.e. ACHS[] where ACHS is a class I defined. I need to add functions for Add and Remove. I need to have functionality like AddAT and removeAT, is there an easier way to do this with the collections namespace or anything? Currently I search the Array for an ID that I...

I have a need to Iterate through records in an ms sql stored procedure and insert a record per row. Is this possible? something like.. select Name From users foreach (user) { insert into UserData(test,UserName)values('test',user.Name) } Any help would be greatly appreciated, I know I could...