Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Site Related Discussions
 Search failing

Author  Topic 

Kristen
Test

22859 Posts

Posted - 2005-07-14 : 13:28:51
A search for the phrase

if @PKCols is null

finds thread

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=52356

but does not find thread

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51902

any idea why?

(Due to lack of confidence I seem to resort to Google to find stuff here nowadays)

Kristen

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-07-14 : 15:13:01
Graz, I might have solution

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=45239
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45779

rockmoose
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2005-07-14 : 15:58:53
We already have Google search setup on the Search page (http://www.sqlteam.com/search.asp) and it searches the forums. Oddly enough it only finds one of the threads also.

select * from forum_reply
where r_message like '%if @PKCols is null%'

Finds them both. Weird.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-07-14 : 16:34:19
"Oddly enough it only finds one of the threads also"

Might be because one of them is really REALLY new.

Kristen
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-07-14 : 18:21:28
>>"We already have Google search setup on the Search page "
Ooops, sorry.

Didn't find it yet

rockmoose
Go to Top of Page

hasanali00
Posting Yak Master

207 Posts

Posted - 2005-07-25 : 11:51:06
What about searching by username??

This site does not allow search by username. How can I find all the topics posted by me??
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2005-07-25 : 15:01:45
quote:
Originally posted by hasanali00

What about searching by username??

This site does not allow search by username. How can I find all the topics posted by me??




Sure it does. On the forum search page (http://www.sqlteam.com/forums/search.asp) you can enter a username. That will only find posts made by that member.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page

hasanali00
Posting Yak Master

207 Posts

Posted - 2005-07-25 : 16:00:38
thanks graz, but i have tried this search 100 times. every time i enter my username, nothing returns.

I tried your name > no result

If I search for my username PLUS search for a word, then the system finds a topic posted by me
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-25 : 16:12:47
There is a link in your user profile to find all non-archived posts.
http://www.sqlteam.com/forums/search.asp?mode=DoIt&MEMBER_ID=12907

Tara
Go to Top of Page

hasanali00
Posting Yak Master

207 Posts

Posted - 2005-07-25 : 17:03:53
this is great, Tara. Can u tell me how do I get to this link from the main site
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-25 : 17:07:16
From www.sqlteam.com, click Forums, click members, type in your username and hit enter, click on your username. Click the non-archived posts link. Alternatively, you can just click on your name in this thread to get to that link.

Tara
Go to Top of Page

hasanali00
Posting Yak Master

207 Posts

Posted - 2005-07-26 : 04:51:45
thanks.
I should have asked this question long time ago.
Go to Top of Page
   

- Advertisement -