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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by HardcoreTechnoHead

  1. HardcoreTechnoHead

    Running two processes at same time in MSDE

    Alternatively, use second recordset object to return the results of your second query. something like objRecordSet.Open "select * from Customer", objConnection, adOpenStatic do while not objRecordSet.eof strCustomerId = objRecordSet.Fields("CustomerId").Value...
  2. HardcoreTechnoHead

    Generic XML Style Sheet

    <xsl:stylesheet xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot; version=&quot;1.0&quot;> <xsl:output method=&quot;html&quot;/> <!-- Override the built-in template --> <xsl:template match=&quot;text()&quot;/> <xsl:template match=&quot;/&quot;> <html> <head> <META...
  3. HardcoreTechnoHead

    Generic XML Style Sheet

    Found my own solution Andie Harper &quot;If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation&quot;
  4. HardcoreTechnoHead

    Generic XML Style Sheet

    I've been reading around but have not yet got past the barrier that you need to know the elemnt name up form the product the style sheet. As I have approximatley 50 tables, If I need to know the element name I would have to write 50 style sheets. I sure it must be possible through a single...
  5. HardcoreTechnoHead

    Generic XML Style Sheet

    I have an audit table in a SQL database which keeps the actual audit data for all operations in XML format something like <TABLENAME> <NEW> <COL1>value</COL1> <COL2>value</COL2> </NEW> <OLD> <COL1>value</COL1> <COL2>value</COL2> </OLD> </TABLENAME> I need ot be able to report on...
  6. HardcoreTechnoHead

    IN Clause problem

    The parser was a good idea, sometimes you need to step away from the problem to see the solutions. Basically I parse the input paramter into a temporary table and use a select to produce the &quot;IN&quot; list Thanks for the help Terry Andie Harper &quot;If you can keep your head when all...
  7. HardcoreTechnoHead

    IN Clause problem

    More info I'm using SQL Server 7 I have already stated tha the use of dynamic SQL is not allowed as this requires SELECT pemrissions on the USER table. As this is for a web applicaiton using a single SQL login, it is not possible to isolate permissions for specific users Any other ides...
  8. HardcoreTechnoHead

    Removing Spaces

    You can use the REPLACE function to get rid of the additional spaces Something like SELECT LecturerTitle + ' ' + REPLACE(LecturerInitial,' ','') + ', ' + LecturerSurname As LecturerName Andie Harper &quot;If you can keep your head when all around you have lost theirs, you probably haven't...
  9. HardcoreTechnoHead

    IN Clause problem

    I have a Database which requires all access to be made through stored procedures for security/audit purposes. What I need to do is pass the list of id's to search in an IN clause as a parameter of a stored procedure i.e. Create Procedure [GetOrgUserList] @OrganisationList varchar(2048) AS...
  10. HardcoreTechnoHead

    Extreme File Handling

    kel1981b Access and Lock operate independently of each other. Access is how your code can use the file. Lock is how other programs can use the file at the same time as your program. Whilst it may not always be approriate to do so, al logical combinations of Access and Lock can be used...
  11. HardcoreTechnoHead

    Extreme File Handling

    In the end, I have written a Java utility to split the files into chunks that can be processed by the VB Parser. Thanks for all your attempts to answer this. In answer to some of your questions MichaelRed - I have almost a terrabyte of storage available, so no problem with processing needs...
  12. HardcoreTechnoHead

    Unload all forms upon closing MDI form

    In the form_unload event of the MDI form, loop through all of you open forms and close them.
  13. HardcoreTechnoHead

    Extreme File Handling

    Does anyone have a way of handling files that are larger than 2Gb with VB. I have a Parsing Utility which has been used to parse text files (about 1Gb each) output from a mainframe billing system and insert the data into a database. We are in the process of decomissioning the mainframe...
  14. HardcoreTechnoHead

    Trouble with .AddItem

    Check the values in you database table. One of them is an empty string. .Open &quot;SELECT DISTINCT SHAPE from tblStockList&quot;, &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\deepblue\EngineeringBOM\Data\EngineeringBOM_data.mdb;Persist Security Info=False&quot;, adOpenStatic...
  15. HardcoreTechnoHead

    Trouble with .AddItem

    Two questions 1) What is the error that is produced? 2) Which version of ADO does you project reference?
See more

Part and Inventory Search

Back
Top