Search results for query: *

I have a web search facility that Brings back and displays records matching a keyword. Depending on the keyword entered This can bring back over a 1000 results. These are divided into pages of 50 with links to other pages - pretty much like these forums do or any search engine does. My...

I am currently working on a message board system. The messages are in a hierarchical arrangement so that each message can have 1 or no Parents and an unlimited number of Child Messages (replies). I tried using the following query to bring back the details of a particular message and it's...

I came across some pretty useful sample code to insert a new record and retrieve the identity but I am not sure how it works! Dim new_identity 'Doing an insert Query = "INSERT INTO ComDirMOTD " & _ "(title, sender_text, message_body, Hyperlink, body_backcol, " & _...

Does any one know how to do this? I am currently trying the following SELECT * FROM DB1.Table1, DB2.Table1 WHERE (DB1.Table1.NT_Login = DB2.Table1.NT_domain_login) And getting this error Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'DB1.Table1'. Server: Msg 208, Level 16...

My SQL knowledge is currently pretty limited so I would really appreciate some help with the following: I have 2 tables (say table1 and table2) table1 is a list of users and contains the fields: UKey, SKey, and GKey (all int) table2 contains a running total of members with a particular...

I am currently writing an app which must have a free text search facility on a database field it also must allow wild card searches. But I am struggling on the most efficient way of doing this. So if someone searches a Title Field for "*elcom* *To* *Taf*" I am splitting this into...