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 TouchToneTommy 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 glendacom

  1. glendacom

    What tables contain a specific column

    Thanks! the Information_Schema views have done the trick! BOLs are great if you know at least some of the key words to search with and you gave me more than I needed!
  2. glendacom

    What tables contain a specific column

    I have inherited a database from some where. None of the relationships were defined and no indexes exist. One good thing is that the original designer was good about naming columns consistently. I need to determine what tables specific columns exist in. (For example "what tables contain a column...
  3. glendacom

    How to save the results of a search

    I need to be able to save to a text file the results of a search. I have done the following: START Search For Files or Folders Entered the parameters Clicked Search Now The results are hundreds of files (as expected). I now want to save the results that are in the Search Results Pane so that I...
  4. glendacom

    indexing documents

    afsearch looks promising and is definitely within my budget but I would really like to end up with a list of words for each document in a SQL*Server table. I have no idea where to even start to take a document(word for example) and extract ALL words (not just ones I specify although I would like...
  5. glendacom

    indexing documents

    I have approximately 1000 documents (word, power point, excel, project, pdf) that I need to index. I want to search each of the documents and generate a list of keywords (important words not to include articles, pronouns, conjunctions, and prepositions) from each document. I then want to put...
  6. glendacom

    convert .pst outlook files to eudora .mbx files

    I have a user who is moving from MS Outlook to Eudora and I need to convert all of her existing email files (.pst) currently in Outlook to Eudora files (.mbx). Anyone have an idea as to how to do this? I tried using Eudora's import feature but it only brings in the folders not any of the mail...
  7. glendacom

    hyperlink within <select ... <option

    I agree ... and shall make an effort to start including them ... not including them is simply lazy programming habits which are very easy to fall into.
  8. glendacom

    hyperlink within <select ... <option

    Good point, Wullie, but I'm one of those lucky (?) people that only has to target IE. It is absolutely impossible for my users to use Netscape. Would be good programming practice though to include the form tags.
  9. glendacom

    hyperlink within <select ... <option

    Boomerang! YES! a star for you ... you deserve more! That is exactly what I was looking for. I had managed to get it to work with an onSubmit using a button but I didn't want a button. The OnChange works exactly like I wanted ... no button ... no form! Thanks!
  10. glendacom

    hyperlink within <select ... <option

    my reply to your first response got lost so here it is again ... There are no buttons ... no form. Putting it in a form is superfluous (in this case) since there is no requirement for submit or reset or anything buttons. The size is plenty big enough for the example and the http://www.somewhere...
  11. glendacom

    hyperlink within <select ... <option

    Is there a way to make this code work as &quot;advertised&quot;. I want each option entry in a <select> list to include a hyperlink. <html> <head> </head> <body> <select size=3> <option><a href=&quot;http://www.somewhere&quot;>link1</a>label1</option> <option><a...
  12. glendacom

    how to determine auto generate key on insert

    Would you mind being more specific about your &quot;blah blah blah&quot;? I have tried your example but cannot get it to work with an Insert. I changed my above example to use a record set for the insert (as opposed to just a connection) and when I query the ID field I get a message that states...
  13. glendacom

    equivalent of Oracle's EXISTS or IN

    thanks, Terry ... that is exactly what I wanted! A star for you!
  14. glendacom

    equivalent of Oracle's EXISTS or IN

    sorry, I guess I didn't make myself completely clear. Yes, I know both versions work in SQL*Server but I thought there was a much &quot;cleaner&quot; way to do it in SQL*Server and that was what I was after. Thanks for the responses.
  15. glendacom

    equivalent of Oracle's EXISTS or IN

    I'm trying to do a query in sql*server that I know how to do in oracle ... can someone tell me the equivalent in sql*server. In Oracle the query would be: select fieldName1, fieldName2 from Table1 where fieldName1 in (select fieldName1 from Table2) or select...
See more

Part and Inventory Search

Back
Top