Search results for query: *

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 =...

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

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...

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...

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

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...

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...

BIG THANKS!

hi Borislav, YOU ARE AWESOME!!!! IT WORKED!

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...

thnx Borislav.

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.

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!

thnx faherke, corrected the typo still didnt do it.

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 =...

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

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.

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

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

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...