update a field from a file with a field from a selection from two files
Hi!When I try this:update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key)I get the message "Null values not allowed in column or variable VALUE."on the other hand, when I do this selection:(select...
View Answer
| Apr 29 2008 11:03 AM GMT
| asked by
Mr.
Update, SELECT statement, SQL
Updating Dreamweaver Templates
Can anyone suggesta reason why my templates are not updating pages based on the template?I create a template in the usual way. Create a page based on the template. I go to the Assets Folder, click on edit. when I edit the template it asks me if I want to update pages based on the template.For some...
Answer Question
| Jan 2 2008 1:24 PM GMT
| asked by
Ken10k
Dreamweaver, Website templates, Update
update single row error
This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why?UPDATE property pSET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code...
View Answer
| Oct 20 2007 2:43 PM GMT
| asked by
Mandrews81
Update, multiple row query
Problem with Microsoft Update
Working with an XP SP2 machine, I get notices that updates are ready to download. I choose them manually, but they never download. Next time I'm online, I get the same notices. Any suggestions greatly appreciated.
View Answer
| Sep 26 2007 3:04 PM GMT
| asked by
NoHa11
Microsoft Windows, Windows XP, Update
