Recent content by tinapa

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