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!

  • Congratulations Mike Lewis 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. tinapa

    SQL server full text indexing, ranking and joining to other tables

    i searched the net about sql server full text indexing and ranking and got this sample sql statement and it works using 1 table only: SELECT myTable1.id, myTable1.Title, fulltextSearch.Rank FROM myTable1 JOIN FreeTextTable(myTable1, [myField1], 'awesome ranking') fulltextSearch ON myTable1.id =...
  2. tinapa

    SQL - Dispose of @domain.com

    hi r937, it works!, ur awesome! tnx a lot.
  3. tinapa

    SQL - Dispose of @domain.com

    hi guys, ive been trying to extract names from email address field. if i have emails like these: adam.peter@yah123.com esther.oliver@test678.com . . . how to i write a sql to make it to look like this: adam peter esther oliver i been using replace,trim functions but it only gets me so far...
  4. tinapa

    Suggest doesnt work for both input text fields.

    hi guys, i just thought to update you regarding this challenge. well, i was able to get it to work. what i did was just to have links to ajax.js and ajax-dynamic-list-countries.js only on the header side and put/add the cities.asp code into the countries.asp code. that's it. and it worked. i...
  5. tinapa

    Suggest doesnt work for both input text fields.

    hi dian, can you give me some more ideas how to do that?
  6. tinapa

    Suggest doesnt work for both input text fields.

    hi Diancecht, on the ajax-dynamic-list.html, i changed the function ajax_showOptions to ajax_showOptions2: . . <input type="text" onFocus=clearText(this) name="cities" autocomplete="off" onKeyUp="ajax_showOptions2(this,'getByLetters2',event)"> . . and on the ajax-dynamic-list-cities.js, i...
  7. tinapa

    Suggest doesnt work for both input text fields.

    i am trying to adapt this php suggest: http://www.dhtmlgoodies.com/index.html?whichScript=ajax-dynamic-list in my code, the suggest for text input countries works. the suggest for text input cities works. but one would not work if i try to have them both have suggest. what am i missing? what...
  8. tinapa

    AVE of rows with nulls

    BIG THANKS!
  9. tinapa

    AVE of rows with nulls

    hi Borislav, YOU ARE AWESOME!!!! IT WORKED!
  10. tinapa

    AVE of rows with nulls

    hi guys, AVE is only for columns? can i use this in rows? if i have this sample how can i have the sql server calculate this: average of rows with null id col1 col2 col3 col4 1 1 2 3 4 2 null 1 7 7 3 1 null null 9 4 3 2 1 6 to this? for...
  11. tinapa

    Time of update

    thnx Borislav.
  12. tinapa

    Time of update

    hi guys, ive searched the net and didnt find any lead. is there a way in sql server for me to know when a particular row was updated without having to add a date/time field on the table? tnx for any inputs.
  13. tinapa

    Monitor in Portrait Mode

    thanks to ArizonaGeek and to kjv1611. and most especially to JimInKS for some sample and anotherhiggins for such a comprehensive explanation. guys, have a nice weekend!
  14. tinapa

    PHP to ASP

    thnx faherke, corrected the typo still didnt do it.
  15. tinapa

    PHP to ASP

    hi guys, im totally newbie to php. i need to convert a php script to asp and this seems to be not working. can you please have a look to see what's wrong in my asp script? thanx the php script: . . if(isset($_GET['getCountriesByLetters']) && isset($_GET['letters'])){ $letters =...
  16. tinapa

    Monitor in Portrait Mode

    sorry kjv1611, i was not so specific. -price should be around $200-350. -size: 19-24" -LCD -yes, for photo/image thing. tnx
  17. tinapa

    Monitor in Portrait Mode

    hi guys, can you please give me some advice of a good desktop monitor that i can use in portrait mode. their brand/model. thanks.
  18. tinapa

    SOUNDEX in TEXT field

    hi gmmastros, the function worked! thank you very much. there are not going to loads of rows in the table. once again many thanks!
  19. tinapa

    SOUNDEX in TEXT field

    Hi guys, I have specified the "(8000)" bit, but I am still not returning any records.
  20. tinapa

    SOUNDEX in TEXT field

    Hi guys, I am experimenting on the SOUNDEX feature of SQL Server 2K and came across with a roadblock. I have this code and it's not returning a record but I've checked that there's a content in the TEXT data type field called Description the word "alcohol"(without the quotes). SELECT...

Part and Inventory Search

Back
Top