SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Feb 2000
    Location
    Minnesota
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How do you "Delete" from two databases?

    I am trying to delete a record from two DB tables at once. They both have the common column called "product_num".

    I tried this, but it's not working:
    Code:
    SELECT * FROM products P, products_cross_sell C where P.product_num = C.product_num AND P.product_num = " & Request.Form("product_num")
    Thanks!
    Keomed.com Webmaster
    www.keomed.com

  2. #2
    SitePoint Guru okrogius's Avatar
    Join Date
    Mar 2002
    Location
    US
    Posts
    622
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It would be a good idea to mention what type of databases you are talking about and the language of the script you're doing this with.

  3. #3
    SitePoint Addict
    Join Date
    Feb 2000
    Location
    Minnesota
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oops, you're right.
    SQL and ASP.

    Thanks!
    Keomed.com Webmaster
    www.keomed.com

  4. #4
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL= Structured Query Language

    Do you mean MSSQL Server database? Then you can check out Stored Procedures. They are pretty strong and will do what you want.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •