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 Wanet Telecoms Ltd 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: *

  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

    ...words not to include articles, pronouns, conjunctions, and prepositions) from each document. I then want to put this list of keywords in a SQL*Server table with links to the document containing the keyword. It would be nice to assign a weight factor to the keyword (i.e. does it occur 100...
  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...
  16. glendacom

    how to determine auto generate key on insert

    Thank-you thank-you thank-you a thousand times!!!!!! The @@identity worked! You folks are absolutely wonderful! For those of you who might want more detailed information here's the code that worked: <% ' define variables dim GmRecordSet dim GmConnection dim sqlGmInsert '...
  17. glendacom

    how to determine auto generate key on insert

    From an ASP program how do I determine the key to an inserted record where the key is automatically generated by SQL*Server?
  18. glendacom

    In program-1 I have a collection of

    In program-1 I have a collection of checkboxes defining colors of lights (named &quot;lights&quot;) as a part of a form being posted for use by program-2. When I access the value(s) of lights in program-2 it shows it as one long string (ex. yellow, red, orange). I used the split function to...
  19. glendacom

    passing data from one form to another

    well, that's my problem ... they haven't submitted the first form yet. the form fields were loaded from the database and I can get those again for form2 but they may or may not have entered changes and I would like to be able to capture those changes for form2 even if form1 has not been...
  20. glendacom

    passing data from one form to another

    i have an ASP file with two forms. The first form has fields that can be changed by the user and a submit button to process those changes to the database. The second form only has a submit button and some hidden fields. I have a need to set one of those hidden fields to a value from one of the...

Part and Inventory Search

Back
Top