IPN is not a program. IPN is a feature Paypal offers to developers. With IPN, when someone pays you through paypal, an HTTP CGI post is initiated to the URL you specify. This URL would be some code; PHP, ASP, JPS etc, that you have had written that can receive that HTTP post, parse it, and do something useful with it. Sounds to me like you need to find yourself a developer to code an IPN page. What kind of webserver do you have? Linux or Windows?

set dateformat dmy

You know that that post had been directed to Yazan dont you? I also enjoy helping others, learn that is. I dont enjoy helping other people do their work, unless I am getting paid.

sounds to me like you are hoping someone will do your work for you?

This sounds to be more of a question for .NET group or something. One option in SQL Server would be to output more than one recordset from a procudure or something, but you are still dealing with a display issue which has everything to do with the application and nothing to do with SQL Server. Since it is in the ADO group. Look into Nested Repeaters and you should find your answer there.

This was thrown together, but should work if you replace the tablenames, columnnames and filenames with values that apply to your application BULK INSERT DBName.dbo.StagingTable -- StagingTable can be a copy of your destination table From 'C:\YourFile.txt' -- actual path to your file With ( FieldTerminator = ',', RowTerminator = '\n' -- for new line ) Alter Table StagingTable ADD SafeToTransfer BIT NOT NULL Default(1) -- Run some integrity checks prior to attempting to tranfer if ( select Count(*) From DBName.dbo.StagingTable Where IsNumeric( ColumnA )=0 ) >0 BEGIN Update DBName.dbo.StagingTable Set SafeToTransfer = 0 Where IsNumeric( ColumnA )=0 END if (select Count(*) From DBName.dbo.StagingTable Where isDate( ColumnB )=0 ) >0 BEGIN Update DBName.dbo.StagingTable Set SafeToTransfer = 0 Where isDate( ColumnB )=0 END if ( select Count(*) From DBName.dbo.StagingTable Where isNumeric( ColumnD )=0 ) >0 BEGIN Update DBName.dbo.StagingTable Set SafeToTransfer = 0 Where isNumeric( ColumnD )=0 END Insert Into DBName.dbo.DestinationTable ( ColumnA, -- an INT Column ColumnB, -- a datetime column ColumnC, -- a varchar(100) column ColumnD, -- a numeric(9,5) column ColumnE -- another varchar(100) column ) SELECT CAST( ColumnA as int), -- an INT Column CAST( ColumnB as datetime), -- a datetime column LEFT( ColumnC, 100), -- a varchar(100) column CONVERT( numeric(9,5), ColumnD), -- a numeric(9,5) column LEFT( ColumnE, 100) -- another varchar(100) column From DBName.dbo.StagingTable Where SafeToTransfer = 1 Alter Table StagingTable DROP COLUMN SafeToTransfer

um, what ?

after your insert, add the following: Select SCOPE_IDENTITY() as NewestRecordsID

Bulk load to a staging table, then clean the data when transferring to your production tables. This will allow you to leave the BulkInsert task alone, and expand the tranfer task as changes to the underlying data or destination tables changes. This is why we call it ETL. Extract the data from the source, transform it match your systems and the Load it into your systems. - Sage

Insert Into TableA ( ColumnList ) Select SimiliarColumnLIst From TableB Where Conditional After your insert statement, add either of the following SELECT @@IDENTITY OR SELECT SCOPE_IDENTITY() @@IDENTITY will return the ID of the last record inserted. If you have triggers on your table(s), then it would be the ID of the last record inserted by a trigger, in which case SCOPE_IDENTITY() returns the ID of the newest record, even if a trigger were to perform inserts against other tables. I personally always use SCOPE_IDENTITY() since I know what it will return now and in teh future, regardless of changes to the DB. - Sage LinkRenter

Read and Write are 2 separate permissions in Windows where as Delete is probably considered Modify and your admin might not have granted you (IUSER_MachineName) access to that function. Look into that for starters. - Sage

it is agreed with previous posts. Especially Palbano as knowing why something works will help you make things that work so much better. You dont need to be an expert, but you should definatly have a solid understanding of the general concepts involved. HTML, XML, XHTML and CSS are pretty much prerequisites and should be considered as such. Again, mastery is good, but a solid understanding is better. When it comes to scripting languages, the more the better, but it depends on what type of developer you plan on being and who your clientelle are (going to be) ... if you are going to work in a windows shop or focus on that , then PHP and Perl arent going to be as important as ASP, .NET per se. I will say that aside for PERL, once you learn one language and get good with it... other languages will be much easier to learn. Javascript and any ECMA scripting language will all just make sense. EG. If you know/learn C/C++/C# , then Javascript and Actionscript would be simple for you. If you know PERL, them PHP will make more sense to you and be much easier to learn. That is my 2 Cents.

they are using Windows Media Server, you would need a Win2KServer or 2003 Server box, setup to use windows media services (available at the add/remove programs - > system COmponents level). to h**l with that though (in my mind) because then only people with Win boxes can use it... Look into using Flash to do what you want. They have a streaming product called Comm Server that I use very regularly. It works great, can get costly, but is available as a hosted service from other companies. Plus, better than 90% of all surfers on the net have the Flash player so there is no need to install anything additional (unless they do not have the Flash Player, but in that case, they most likely dont have Win Media either. Hope that helps. - Sage

here we go::: strAppendFileName = "C:\MBrokers\Doc1.doc" strReadFile = "C:\MBrokers\Doc2.doc" Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Add() WordApp.Selection.InsertFile strAppendFileName WordApp.Selection.InsertFile strReadFile WordDoc.SaveAs "C:\MBrokers\Doc1.doc" WordDoc.Close WordApp.Quit Set WordDoc = Nothing Set WordApp = Nothing Response.write "

Document Merged

" & VbCrLF BUT !!!!! to make it work, I had to change IIS's security context to be administrator instead of IUSR_ but it works fine.....

this document here might help you out... http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/708/qid/471051

I am looking at the API here (Word.10) and under Word.Document I see a Merge feature. Sub Merge(FileName As String, [MergeTarget], [DetectFormatChanges], [UseFormattingFrom], [AddToRecentFiles]) Member of Word.Document This looks hopeful .. I am going to mess with it here for a sec and see if this helps you because it sure sounds like the type of function you are trying to execute. - Sage

web.config and global.asax need to be in the root of the web site. try moving those 2 files to the root of the website and see if that helps. - Sage

sounds to me like the files are marked readonly (doubtful) or that you dotn have write permission on that folder. Check that out first and then let me know if that was the reason. - Sage

well then, like many web developers before us and many developers after us, it sounds to me like it is time to take a hint from a porn site or warez site. I dont know how many you have seen (not that I look at porn all day long or anything), but many of them have some "sticky" tricks which end up making their way into the legitimate side of the Internet. Pop-up ads are the most famous. The reason I mention this is another trick many of them have been employing for some time now is to open the browser in a fashion that none of the toolbars exist. For a user that dont know better (and dont know keyboard shortcuts), it is near impossible to close these windows. This sounds liek soemthing for you. Of course, you would need to "emulate" the minimize and close buttons, but it will help you do what you need to do. I would need to hunt down an example, but I thought I would throw the idea at you and see if it interests you. - Sage

I had to deal with a similair issue yesterday and here is what I did.. Situation, Users log in and we adjust their profile to show them as "Logged In", which allows us to produce an accurate list of "Current Users". Whne a users logs off (using the "defined" method, which is a button), then we update their profile to show them as "Logged off". When user logs in when user logs off, we capture the time of these two events and we produce a report of "Time Using System". Well, as you are now seeing, users dont always use your "buttons". So what I did was add a Log-Off catch in the Session_OnEnd section of the global.asa like so: Sub Session_OnEnd ' Decrement the current number of active users Application.Lock Application("CurrentUsers")=Application("CurrentUsers")-1 Application.Unlock ' Close the current users open session and adjust DB set conn = server.createObject("adodb.connection") conn.open("Server=SQLServer.petcarefinder.com;Driver={SQL Server};Database=Users_DB;UID=Username;pwd=Password;") conn.execute("dbo.con_LogUserOutOfSystem('" & Session("UID") & "')") conn.close :: set conn = nothing End Sub This only "Logs Off" the current session, it doesnt wipe out all sessions on the server. I have tested this relentlessly in the last 2 days and it seems to never not work. let me know if this would help you .... - Sage