Gossamer Forum
Home : Products : Gossamer Links : Discussions :

SQL Monitor - Matching Link Zip Codes to Cities Question

Quote Reply
SQL Monitor - Matching Link Zip Codes to Cities Question
I'm trying to add corresponding Zip Codes to my existing city locations that are already in the link's "Description" Field. I created a new "Zip" field to put in each link's Zip code. I also added <%Zip%> to the links template page. It seems to work fine.

My question is - Is there a quick and dirty way to add the actual Zip code of the link automatically to the corresponding link that already has the City name in the Description field using the SQL Monitor. What SQL statement would I use to make this happen?

As an example I would want 44121 to appear in the <%Zip%> field when everytime "South Euclid, Ohio" appears in the Description field.

Is this possible?? Any assistance would be very much appreciated. I have over 35,000 links in my db but am looking for a "quick and dirty" way to accomplish this task.

mgeyman
Subject Author Views Date
Thread SQL Monitor - Matching Link Zip Codes to Cities Question mgeyman 3359 Aug 11, 2002, 7:46 PM
Thread Re: [mgeyman] SQL Monitor - Matching Link Zip Codes to Cities Question
Stealth 3301 Aug 11, 2002, 8:05 PM
Thread Re: [Stealth] SQL Monitor - Matching Link Zip Codes to Cities Question
mgeyman 3284 Aug 12, 2002, 4:04 PM
Thread Re: [mgeyman] SQL Monitor - Matching Link Zip Codes to Cities Question
Teambldr 3282 Aug 12, 2002, 4:08 PM
Thread Re: [Teambldr] SQL Monitor - Matching Link Zip Codes to Cities Question
nakulgoyal 3216 Dec 14, 2003, 3:57 AM
Post Re: [nakulgoyal] SQL Monitor - Matching Link Zip Codes to Cities Question
pugdog 3213 Dec 14, 2003, 12:34 PM
Thread Re: [mgeyman] SQL Monitor - Matching Link Zip Codes to Cities Question
transom 3193 Dec 15, 2003, 10:14 AM
Post Re: [transom] SQL Monitor - Matching Link Zip Codes to Cities Question
nakulgoyal 3191 Dec 16, 2003, 2:29 PM