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

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

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

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.

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

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

Hi guys, I have a Search and Result pages in asp.net. If the user searched for a word but if he typed it in wrong spelling(e.g. tommorow), I want to show him that there's no record found in the database AND give him word suggestion/s(e.g. did you mean tomorrow? -- which has entry in our...

hi guys, is it a good idea to just have 1 catalog per table? can i still search the joined tables even if each table has its own catalog? will it affect the performance/speed of search? thnx for any ideas.

my apologies guys if i double post. it seems that i posted on the inappropriate forum for sql server first. ------------- hi guys, i just want to ask for your advice. i have a sql server database with more than 30 tables and i want to implement a full-text indexing on it. there's around 15...

hi guys, i just want to ask for your advice. i have a sql server database with more than 30 tables and i want to implement a full-text indexing on it. there's around 15 main tables, around 10 link tables and 10 lookup tables. some tables share the same lookup tables. this database is around...

Hi guys, I don't know if this is the right place to ask this. But i am wanting for my website's visitors to have options/buttons for zooming in and out the whole page whether they are using IE or Firefox. The code version of "ctrl +" and "ctrl -". Is this possible? Is javascript enough? by...

hi folks! how can you position a div tag relative to a table? i am asking this because when i look at my webpage in 1024res it looks ok. but when i look this same page in 1280+ resolution it doesnt look good. the div tag stays on the same spot where you can find it on 1024res. i've tried styling...

hi, i want to have a template table so that when i make a new table i just define this new table with a class=mytablecss and i want it to inherit the properties of a table defined in my css file. and i want to have a different background image for each and every td. example is: <table...

Hi folks, I have a 4X4 table. I want to show only the grid inside this table and not show the four outer borders. How can I achieve this using CSS that is both recognized by IE and Firefox? Thanks for any inputs.

hi guys, can you force Groupwise 6.5 users to see the emails in HTML view only? I don't want emails to be viewed in text. thanks

Hi guys do you have any ideas how to have magnifying glass image inside a search field? thanks

hi guys, i have posted this on the "website forum" but i don't know if that's the correct place for this question. my apologies. (site admin, please bear with me) can you give me ideas how to make something like this website? http://www.bankofengland.co.uk if you click a button from the...

hi guys can you give me ideas how to make something like this website? http://www.bankofengland.co.uk if you click a button from the horizontal menu, it gives submenus of the left side of the page. do you think this site only has one template to do that sort of navigation? i want it...