c# - MSSQL Simple Update Query: UPDATE TABLE SET FIELD = 1 WHERE FIELD = 2 -

-

i trying perform simple update query in ms sql. in mysql issue this: 

update table set field = 1 field = 2

i getting error when try in ms visual studio. please this.

the error:

subquery returned more 1 value. not permitted when subquery follows =, !=, <, <=, >, >= or when subquery used expression. statement has been terminated.

thanks.

on limited information hand, suspect have update trigger on table coded expect single row being in inserted or deleted tables.


Comments

Post a Comment

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

-
i new in xmlreader, , think kind of hard find tutorials/code or advanced examples. question how can transform code have now, if search (through form) term jquery give me opportunity output value of <info></info> (and later other elements) in every <name></name> found in ? this code output names of books. <?php $reader = new xmlreader(); $reader->open("books.xml"); while ($reader->read()) { switch ($reader->nodetype) { case (xmlreader::element): if ($reader->localname == "name") { $reader->read(); echo $reader->value; break; }}} ?> the xml file <?xml version="1.0" encoding="iso-8859-1"?> <library> <book isbn="781"> <name>scjp 1.5</name> <info>sun certified java programmer book</info> </book> <bo...
Read more

php - Time zone issue -

-
what going on when time on server out 12 hours? working on site friend, , noticed although server in our timezone, 12 hours behind when writing records db. did checks so: <?php echo(gmstrftime("it %a on %b %d, %y, %x time zone: %z",time())); phpinfo(); ?> result: it thu on jul 21, 2011, 04:46:46 time zone: gmt ... date date/time support enabled "olson" timezone database version 2010.15 timezone database internal default timezone pacific/auckland directive local value master value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenit 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone pacific/auckland pacific/auckland ask can see, php reports 4:46 am. it's 4:46pm here. reports gmt timezone, phpinfo reports pacific/auckland timezone (gmt+12). i asked webhost going on. weren't sure, system's time correct. , there no other php.ini files being introduced. ide...
Read more