sql help for the syntactically challenged - UBB.threads Community

You are not logged in. [Log In] UBB.threads Community » Forums » Managing & Customizing your Board » Admin Zone » sql help for the syntactically challenged

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options

3 Registered (gliderdad, Island Piper, 1 invisible), 20 Guests and 17 Spiders online.

Key: Admin, Global Mod, Mod

Top Posters

Gizmo	11707
Rick	7567
Ian	4107
Mark S	3983
ntdoc	3114
Sirdude	2041
jgeoff	1882
David Dreezer	1759
driv	1569
AllenAyres	1530

Latest Photos

Carrie - So Very

Testing

Test Photo

4TH of July at the river!

Test shots from D300 part 3

Topic Options

Rate This Topic

#215120 - 07/03/08 04:11 PM sql help for the syntactically challenged
Carte Blanche journeyman Registered: 07/30/06 Posts: 77 Loc: New Zealand	Hi, I want to change the value for 1 field in a table for all records in that table. Specifically, in the Forum_permissions table, I think the default for the field ad_island is 0, I want to update every record so that the value for that field is 1. Which in truth, it should be. Having that value set to one for every group is fine and won't change anything unless you actually designate a post island to be displayed in the forum details side. Anyway, could someone help me out with the sql statement for that?
Top

#215121 - 07/03/08 04:19 PM Re: sql help for the syntactically challenged [Re: Carte Blanche]
Carte Blanche journeyman Registered: 07/30/06 Posts: 77 Loc: New Zealand	Bleh, nevermind, got it. I'm a lazy bastard is all
Top

#215142 - 07/04/08 08:28 AM Re: sql help for the syntactically challenged [Re: Carte Blanche]
Sirdude Registered: 04/19/07 Posts: 2041 Loc: SoCal, USA	Sql Query: UPDATE ubbt_USERS u, ubbt_USER_PROFILE up SET u.USER_LAZY_BASTARD=1 WHERE u.USER_ID=up.USER_ID AND up.USER_DISPLAY_NAME='Carte Blanche' _________________________ A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.
Top

#215242 - 07/06/08 06:56 PM Re: sql help for the syntactically challenged [Re: Sirdude]
Carte Blanche journeyman Registered: 07/30/06 Posts: 77 Loc: New Zealand	/facepalm so true.
Top

View All Topics

Hop to:

Moderator: Gizmo

Shout Box

September
Su	M	Tu	W	Th	F	Sa
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30

Recent Topics

[7.3.x] Ignore link showed in userprofile for global moderators
by blaaskaak
Today at 01:27 PM

[7.3.x] Database password shown in adminlogs...
by blaaskaak
Today at 10:24 AM

7.3.1 Flood protection
by MattUK
Today at 03:55 AM

Changing title of forum
by Baby Boomer
Yesterday at 07:38 AM

Disable PM's for one group
by Musky
Yesterday at 07:10 AM

Forum Stats

4026 Members
33 Forums
30883 Topics
156827 Posts

Max Online: 978 @ 06/24/07 08:19 PM