Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

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


1 - 4 of 4
<<PREVIOUS 1 NEXT>>