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
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