Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Update fields

Jun 20, 2003, 11:22 AM
fabio
User (315 posts)
Jun 20, 2003, 11:22 AM
Post #1 of 4
Views: 1821
Shortcut
Quote Reply
Update fields
Hi,
I've imported a Dmoz rdf Dump, and now I want to copy all contents from fields "Title" to fields "Contact_name" which are now set to "NULL"
can someone help me ??

Thanks in Advance
Bye From Italy
Jun 20, 2003, 12:07 PM
Paul
Veteran (19537 posts)
Jun 20, 2003, 12:07 PM
Post #2 of 4
Views: 1770
Shortcut
Quote Reply
Re: [fabio] Update fields In reply to
UPDATE Links SET Contact_Name = Title WHERE Contact_Name IS NULL

Last edited by:

Paul: Jun 20, 2003, 12:08 PM
Jun 20, 2003, 4:18 PM
fabio
User (315 posts)
Jun 20, 2003, 4:18 PM
Post #3 of 4
Views: 1787
Shortcut
Quote Reply
Re: [Paul] Update fields In reply to
thanks paul !!!!
I have another question......
I've the field Contact_Email to NULL, so I want set to modified URL field to reflect an email adderss, example:

FIRST
URL -> http://www.digalog.com

Contact_Email -> NULL

AFTER
URL -> http://www.digalog.com

Contact_Email -> info@digalog.com

Thanks in Advance
Bye From Italy
Jun 24, 2003, 4:29 AM
fabio
User (315 posts)
Jun 24, 2003, 4:29 AM
Post #4 of 4
Views: 1734
Shortcut
Quote Reply
Re: [fabio] Update fields In reply to
Someone can Help me ?

Thanks in Advance
Bye From Italy