Search results for query: *

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...

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.

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

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...

ORA-01407: cannot update TABLE1.NAME to NULL

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...

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?

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...

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...

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.

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.