Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

SQL Statements

May 28, 2000, 4:58 AM
Robert
Enthusiast (718 posts)
May 28, 2000, 4:58 AM
Post #1 of 3
Views: 271
Shortcut
Quote Reply
SQL Statements
I tried to do the following:

UPDATE Category set Meta_keywords = 'Test' where Meta_keywords = ''

Thatīs ok for all first level cats; but what should i do to change categories like cat1/cat2

Robert

May 28, 2000, 10:50 AM
pugdog
Veteran / Moderator (6956 posts)
May 28, 2000, 10:50 AM
Post #2 of 3
Views: 250
Shortcut
Quote Reply
Re: SQL Statements In reply to
I'm not sure what you are asking.

You did not put a restriction on the UPDATE, and it should have set all Null Meta_Keywords to "Test" no matter what category they were in.


May 28, 2000, 10:58 AM
Robert
Enthusiast (718 posts)
May 28, 2000, 10:58 AM
Post #3 of 3
Views: 248
Shortcut
Quote Reply
Re: SQL Statements In reply to
???
I have
cars
toys
cars/porsche
toys/boys

With the UPDATE-Command i could set all keywords in the first level: cars and toys to test, but i didnt change toys/byos and cars/porsche.

Thatīs it.
I dont know why it doesnt do what i want.