custum tags

Discussion in 'ASP General' started by mekusharim.ltd@gmail.com, Apr 23, 2006.

  1. Guest

    hi ,
    i have 2 questions .

    about custom tags .
    i have a table that users are inserting custom tages ,
    it looks like :

    user_id type value
    1 99 television
    2 98 beach
    3 99 coldplay

    etc.
    now i have to make a search which will show all the users
    that typed the same value from the same type .
    i dont want the query to be a textual query (slow ...)
    what is the right way to do it ?

    another question :
    how can i make a query that JOINs to tables from 2 different databases
    ???

    THANX ...
    , Apr 23, 2006
    #1
    1. Advertising

  2. Matt Guest

    Not sure about your first question. Maybe a stored procedure will work for
    you?

    Here is an example of a query that joins two databases (Users and IAPSST).

    Use this syntax <database name>.dbo.<table name>

    Select A.FirstName, A.LastName, C.*, D.AccountAccessID as EXPR1

    from Users.dbo.USER_INFO A Join IAPSST.dbo.IAP_V1 C

    on A.UserID = C.userID Left outer join

    Users.dbo.ROLES D on

    C.userID = D.UserID

    <> wrote in message
    news:...
    > hi ,
    > i have 2 questions .
    >
    > about custom tags .
    > i have a table that users are inserting custom tages ,
    > it looks like :
    >
    > user_id type value
    > 1 99 television
    > 2 98 beach
    > 3 99 coldplay
    >
    > etc.
    > now i have to make a search which will show all the users
    > that typed the same value from the same type .
    > i dont want the query to be a textual query (slow ...)
    > what is the right way to do it ?
    >
    > another question :
    > how can i make a query that JOINs to tables from 2 different databases
    > ???
    >
    > THANX ...
    >
    Matt, May 5, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dean H. Saxe
    Replies:
    0
    Views:
    1,015
    Dean H. Saxe
    Jan 3, 2004
  2. Karl Jensen

    Web custum control

    Karl Jensen, Feb 6, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    381
    Peter Blum
    Feb 7, 2004
  3. =?Utf-8?B?QXNobGV5?=

    Custum error site in asp.net

    =?Utf-8?B?QXNobGV5?=, Feb 10, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    387
    dm_dal
    Feb 10, 2004
  4. Rob Nicholson
    Replies:
    3
    Views:
    682
    Rob Nicholson
    May 28, 2005
  5. Jef Driesen
    Replies:
    8
    Views:
    373
    JustBoo
    Jan 9, 2006
Loading...

Share This Page