Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 osql command for..		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

StephenD
Senior Member

Australia
1044 Posts
Posted - 11 August 2004 :  00:25:33  Show Profile  Send StephenD a Yahoo! Message
I need to update 2 fields in a table at the same time with a where clause. Something like:

UPDATE transactions SET tableno=NULL, SET priority=1 WHERE serverprocessed=0

Something like this?

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 11 August 2004 :  04:04:10  Show Profile  Visit Gremlin's Homepage
leave out the second set

UPDATE table Set field1 = a, field2 = b, field3 = c WHERE fieldx = y
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

StephenD
Senior Member

Australia
1044 Posts
Posted - 11 August 2004 :  19:50:14  Show Profile  Send StephenD a Yahoo! Message
Excellent, thank you.
Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts
Posted - 11 August 2004 :  23:34:38  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
http://www.w3schools.com/sql/sql_update.asp
My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07