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 Chriss Miller 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 alexjamesbrown

  1. alexjamesbrown

    Threading...

    Hi, I've got a windows application that references a class library - in my class library i have a method that returns a large collection. on the windows form, i have a button, that calls the method.... the method takes about a minute or so to do what it needs to do (its a large operation)...
  2. alexjamesbrown

    Text on image - watermark - font size

    I have images, that are stored in sql server. One of the images is retrieved, into a memory stream, then returned as an Image object. I then have a method called addWatermark(string text, Image img) Graphics g = Graphics.FromImage(image); g.SmoothingMode =...
  3. alexjamesbrown

    Macro - get data from other workbook

    hi, thanks for your reply. i've attached the 2 workbooks. data.xls is the orders file, and warehouse.xls is the "lookup" table... basically warehouse contains a list of product codes and warehouse locations. what i want to be able to do, is load data.xls, and load the macro, so that it adds a...
  4. alexjamesbrown

    Macro - get data from other workbook

    I am trying to create a macro to do the following: I have an excel file, called Warehouse.xls This has two columns - Column A, which is ProductCode, and Column B which is WarehouseLocation This file is a list of all my products, and where they are stored in the warehouse. I then have a second...
  5. alexjamesbrown

    Dreamweaver Find & Replace

    Hi, im currently scaling up an asp application from access to SQL Server... one of the things i need to do is convert things like: IsDate(CertSignSentDate) to sql server compliant: IsDate(CertSignSentDate) = 1 I need to run a regular expression search and replace on the IsDate([]) and make...
  6. alexjamesbrown

    best place to store connection string

    Hi, just a quick question... I usually create a db.asp file, and include it on each page i need the db connection, but where do you think is the best place to store the db connection? anything a bit more secure? global.asa?
  7. alexjamesbrown

    Freetext catalog

    I execute the following: EXEC sp_fulltext_catalog 'DescriptionsOfProducts', 'create' EXEC sp_fulltext_table 'tblProducts', 'create', 'DescriptionsOfProducts', 'PK__tblProducts__50FB042B' EXEC sp_fulltext_column 'tblProducts','ProductName','add' EXEC sp_fulltext_column...
  8. alexjamesbrown

    Help with full text search sql....

    Hi there, i have a Full text search on a table... tblProducts I am trying to query it, to search the descriptions of products.. this is the code i use (or part of it) strQuery = "Exec spSearchProducts '"&request("keywords")&"'" Set rsProducts = Server.CreateObject("ADODB.Recordset")...
See more

Part and Inventory Search

Back
Top