Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DavidJA
  • Content: Threads
  • Order by date
  1. DavidJA

    Outlook drag & drop of attachments in VB

    I was hoping someone can point me to a tut on dragging a mail item from outlook to a vb app (perhaps with the OLEDragDrop Event). I'm trying to implement the functionality of dragging an attachment (out of OutLook) out of an mail item that you can select and drag to the explorer and it will...
  2. DavidJA

    Refreshing an IFrame from the parent window

    Hey all! I have a form with 2 iframes on it, and I would like to the concent of one of the iframes. I could do document.all.iframeSearch.src = 'AgencyOrderFormItemsTaskTypeSearch.asp?' + qs but then the iframe scrolls back to the top. I basicly want to be able to do something like...
  3. DavidJA

    Copying TEXT from one row to another

    Hey all, I'm sure the answer to this is obvious AND simple, but I just can't get it! I have a row in a database that contains a varchar(50) column and a TEXT column. I want to copy the values of these two columns to another row, withing a stored procedure. Keeping in mind that text can not be...
  4. DavidJA

    ASP/COM scalability

    Hey All, I have a n-teir application which consits of an ASP front end hosted on IIS5, VB created DLL files hosted on COM+ (as server application) and SQL server database. The application appears to work well, exept when a call to my com components takes more then a split second to execute...
  5. DavidJA

    recursively creating folders

    Hey all. Maybe my brain is dead today, but anyway, I can't figure out how to recursively create a folder. EG: If I want to create a folder called c:\Folder1\Folder2\Folder3\Folder4 and Folder1 does not exist, then I need to create Folder1, then I need to create Folder2, then Folder3 and...
  6. DavidJA

    Scraping a web site!

    Hey all, I need to be able to (in vb) connect to a URL and download all HTML files and .class files. Can someone please tell me how to do this in VB.
  7. DavidJA

    Creating folders are setting security

    Hey all. I want to be able to create a folder (which I can do using the MS Scripting Runtime), but also be able to assign access rights to this folder (every one/full control) How can I do this in VB?
  8. DavidJA

    stopping rounding of numbers in SPs

    Hey all, consider the following code: create table #test (Num decimal(6,2)) insert #test (num) select 50 / 100 select * from #test For me this returns 0.00, but 50/100 = .05 how can I make this code return 0.05.
  9. DavidJA

    blocking inherence with CSS

    Hey all, I have a parent table and a child table. On the parent table I define { background-color:red} , how do I stop the child table inherating this? I would have thought it would be something like { background-color:'' } or { background-color:""} but that does not work....
  10. DavidJA

    Advanced CSS & Tables question

    Hey all, I need to produce many different HTML pages to display heirachal data rowsets, eg, nested tables with a 'parent table' and a 'child table'. Because these tables need to be 'artisticly correct' with a lot of formatting we have created an external CSS file. In this CSS file we have 2...
  11. DavidJA

    backup a database to CD

    Hey all, The powers that be have insisted that as well as our normal backup to tape rotation that happens every night, I backup our entire DB to CD once a week so that we have a perminate off-site record. The problem is my DB is around 1.4 gig, and obviosuly to large to fit on one file. Is...
  12. DavidJA

    Derived Tables with aggrigate queries.

    Hi all, I have a query with a derived table in the from clause. The derived table is made up of an agrigate query. FROM xyz LEFT JOIN (select min(dteDeadline) as MinDeadline, OrderID FROM tblOrderItems) is there any way that I can put a where clause in the aggrigate query and specify columsn...
  13. DavidJA

    Part number for CPU heat sink

    Hi all, I have a few 5500r PII Xeon servers, and I have recenty come across a few PII Xeon CPUs without the compaq Heatsink/clip on them. Does anyone know where I could find the part number for the headsink/clips required to get these into the 5500? (or a supplier name/no?)
  14. DavidJA

    Running MSWord from within IE

    Hey all, I need to start a copy of MSWord from JavaScript, opening a spacific document. EG: I need to simulate the following start winword.exe \\Fileserver2\documents\david\MyDoc.HTM, and have MS word open the document in read-write mode. (the HTM file is obviously not associated with word so...
  15. DavidJA

    running MSWord from JS

    Hey all, I need to start MSWord from JavaScript, opening a spacific document. EG: I need to simulate the following start winword.exe \\Fileserver2\documents\david\MyDoc.HTM, and have MS word open the document in read-write mode. (the HTM file is obviously not associated with word so simply...
  16. DavidJA

    Hard drive trays

    Hi all, I have a few Prolient 5500R's. (Xeon 450's). I have noticed on Ebay that a few people are selling "68 pin scsi compaq hot swap hard disk trays" Compaq spare part #199880-001 Anyway, I'm thinking it would be nice to buy some of these and put my own SCSI drives in them, and...
  17. DavidJA

    Forcing files to be saved to disk.

    Hey All, Is there a way I can force the browser to give a file saveas dialog box when a user attempts to view certain JPG files? EG, I would like to do a 'window.location='http://mysite.com/lowres/121a.jpg', and when this is sent to the client they get a save as dialog box instantly, insted of...
  18. DavidJA

    Opening PDF documents

    Hi all, I have a B2B advertising site. Clients can go to it and see Proofs of jobs. These proofs are in Adobe Acrobat Format, served off an IIS 5 server. (sitting in a virtual folder) I am sending the user to the file using a the following JavaScript...
  19. DavidJA

    String replacement

    Hey all, I have a problem :( I need to replace all chars in @MyVarCharString that are NOT in A..Z a..z 0..9 with the '-' char. EG: 121 O'brian@^A should equal 121-O-brian--A Can someone please show me how to do this in T-SQL.
  20. DavidJA

    Making the Query Optimizer more intelligent?

    Hey all, I have a DB with several tables which are between 100,000 rows and 500,000 rows. When I join some of these tables using INNER JOIN, SQL Server will choose to use HashMatch/Inner Join, and take around 30 seconds to execute my query. When I change my joins to INNER LOOP JOIN, the same...

Part and Inventory Search

Back
Top