Gossamer Forum
Home : Products : Gossamer Links : Discussions :

How do I preset the URL value?

Quote Reply
How do I preset the URL value?
I am adding new links to a category. All the links share the same URL. I want the URL to be there when I enter a new link. In the older version of Links SQL, I know how to do it. I simply went to the table and entered the URL there. Now I cannot find the same table there. Where should I enter my URL?
Thanks.

Quote Reply
Re: How do I preset the URL value? In reply to
Im still using an older version, but can't you add a default value to the URL column by going to the Database menu then *Links Properties*.

Installs:http://wiredon.net/gt
FAQ:http://www.perlmad.com

Quote Reply
Re: How do I preset the URL value? In reply to
PaulWilson:

I went to Database and Mysqlman. There I chose Links-properties. I saw URL as a field. I clicked on change and entered the default URL. Somehow nothing happened in real life. When I went back to add another link, the URL field is empty. How come it does not show up the default value I entered. Something is not right here. Any suggestions?

Quote Reply
Re: How do I preset the URL value? In reply to
Did you re-sync and repair tables?

Installs:http://wiredon.net/gt
FAQ:http://www.perlmad.com

Quote Reply
Re: How do I preset the URL value? In reply to
PaulWilson:

I could not find recync, but I clicked on repair table. The response seems to be ok. Still the field is empty when I tried to add a link. To be honest with you, when I tried to put in my default URL, there is another URL. I put it there a year ago. Under normal circumstances that URL should show up. But it did after we made the move. When I entered into this new URL, still it does not show up. My links SQL is 2.03. Gossamer helped me to move all the data from the another machine to this one. What problem could it be? Thanks

Quote Reply
Re: How do I preset the URL value? In reply to
The resync command for the individual table is at the bottom of the tables->properties screen.

To resync all your tables, at least all that Links installed, you go to the setup->sql->update .def files option (the last option of the 3)



PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Plugins:http://LinkSQL.com/plugin
Quote Reply
Re: How do I preset the URL value? In reply to
To All those that responded:

I did it finally. I still could not find Sync. But in Admin-database-editor, you choose link and choose properties. You can go to a editor: Table definition. There I entered my URL and all default URL will come up next time I add a link. I did that in MySQLman and it did not work. Can someone explain the difference? thanks.

Quote Reply
Re: How do I preset the URL value? In reply to
Here is a screen capture....

There is a big black dot next to *resync* Wink

http://www.links247.net/re.gif

Installs:http://wiredon.net/gt
FAQ:http://www.perlmad.com

Quote Reply
Re: How do I preset the URL value? In reply to
Paulwilson:

Stupid me! Finally I found the sync as you described. In the Edit: table definition, I have my default URL. In Mysqlman in URL field I also have my default URL. Then I did a sync. After the sync, The default URL in Editor: Table definition is gone. It is still in the table shown by Mysqlman. Obviously the table in Editor: table definition is not sync with the table shown in Mysqlman. I wonder between what tables did I sync? do you have any idea?