Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cw26
  • Order by date
  1. cw26

    UPDATE with embedded SELECT...(kind of)

    Thanks BJCooperIT!!! That worked. Not quite sure how just yet, but it worked. It seems strange that I would have been getting a NULL error from TABLE2 that doesn't have any NULL values. I've double-checked that. Perhaps it was the NULLs on TABLE1 that were interferring with...
  2. cw26

    UPDATE with embedded SELECT...(kind of)

    TABLE1 ID NOT NULL VARCHAR(11) NAME NOT NULL, VARCHAR(50) Same fields defn's in TABLE2. Of course there's more fields in both tables but these are the only two I'm dealing with. TABLE2 does not have any NULL values for NAME.
  3. cw26

    UPDATE with embedded SELECT...(kind of)

    using AND T2.NAME IS NOT NULL still returns the same error message ??
  4. cw26

    UPDATE with embedded SELECT...(kind of)

    Also, I've verified that there are values for NAME for all IDs from TABLE2 that matchup to those IDs in TABLE1. So there should be no NULL values coming from TABLE2 as it appears that the error is telling me...
  5. cw26

    UPDATE with embedded SELECT...(kind of)

    ORA-01407: cannot update TABLE1.NAME to NULL
  6. cw26

    UPDATE with embedded SELECT...(kind of)

    I tried your solution for above - now I get an error indicating that I cannot update the TABLE1.NAME to NULL. Here's a example of the structure: TABLE1 ID 121, NAME null ID 123, NAME null TABLE2 ID 121, NAME "Bob" ID 122, NAME "Mike" ID 123, NAME "Scott" So...
  7. cw26

    UPDATE with embedded SELECT...(kind of)

    Thanks again for the reply, The structure is that of the first one you indicated. The NAMEs will always be one-to-one based on ID. Will the example you provide using ROWNUM = 1 do the trick and go through row-by-row for each ID that matches up?? Is that all that I'm missing?
  8. cw26

    UPDATE with embedded SELECT...(kind of)

    Thanks for the reply, There will be multiple names returned - a different name (possibly for each ID from TABLE2). So, that seems to be my problem. I need to run an update for all the rows in TABLE1 but the query from TABLE2 will return multiple rows of data. TABLE2 has all the IDs and...
  9. cw26

    UPDATE with embedded SELECT...(kind of)

    Hi, I'm trying to run and UPDATE in SQL PLUS. Basically, I have 2 tables - TABLE1 and TABLE2. TABLE1 contains an ID field that links it to TABLE2. TABLE1 has been altered to include a new field called NAME. There are no values for NAME yet in TABLE1 as these need to be taken from TABLE2...
  10. cw26

    QueryString Encoding

    I need to hide the parameters in the URL of my ASP. I can't use 'Request.Form' since the ASP must be loaded from a hyperlink. Is there any way to encode my QueryString so that the parameters are hidden in the URL? Thanks.
  11. cw26

    window properties

    Is there a 'window' object in vbscript (similar to that in javascript) that I can use to manipulate window properties from an ASP....such as hiding the location bar....?? Thanks.

Part and Inventory Search

Back
Top