Problem with the browser cache

I hate to post up on a really old thread but I think I am having this issue.
I recently changed a misspelling in a Drop Down Option list in a Section Editor.
It has not changed on the site and I'm wondering if the DB has a cache or the site itself.
Perhaps I have to force a refresh on the content pull somehow?
I have tried numerous times on different browsers all dumping the cache in each but I still see the value.
Any ideas?

Hi,

It shouldn't be a caching issue if you've tried it in multiple browsers. Are the drop down options just a list, or are they being brought in from a different table?

If you're still experiencing this issues, please fill out a 2nd Level Support Request here:
https://www.interactivetools.com/support/email_support_form.php
and we can take a closer look at this for you.

Hope this helps.

Its the same editor same table, and here is the code for the search in the head:

// load records
list($all_find_a_retailerRecords, $all_find_a_retailerMetaData) = getRecords(array(
'tableName' => 'find_a_retailer',
'allowSearch' => false,
'loadUploads' => '0',
'orderBy' => 'state',
));

list($find_a_retailerRecords,) = getRecords(array(
'tableName' => 'find_a_retailer',
'requireSearchMatch' => true,
));

and the body:

<form method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>" id="retailer_search" >
<select name="state">
<option value="">Select A State</option>
<?php $lastState = null; ?>
<?php foreach($all_find_a_retailerRecords as $record): ?>
<?php if ($lastState == $record['state']) { continue; } else { $lastState = $record['state']; } ?>
<option><?php echo htmlspecialchars($record['state']) ?></option>
<?php endforeach ?>
</select>


<input type="submit" name="submit" value="Search">
</form>
below all this is the regular old "ForEach" code for the results.
I changed the spelling for a State abbreviation in the Editor and it did not reflect the change on the site drop down for the search.
Weird.
I ended up deleting the states field from the editor and added it back in as a new entry. Which sucks because I had to go back and literally check off each state for all locations.
[:/] [:(]

Hi,

Sorry you're running into so much trouble. Are you still experiencing a problem, or has it been fixed now?

If you're still having an issue, please fill out a 2nd level support request and I can take a closer look into this.

Thanks.

Yeah still had the issue as of earlier but since then I deleted the field in the editor and recreated it but as I was saying earlier.... had to essentially re-map all the retailers (missing a state = no results in search to put them in)

Hi sublmnl,

When you change the options for a List Field set to "Use options listed below", the records aren't updated and will still contain old values. One quick way to update those records is with an SQL statement which you could punch in via the free MySQL Console Add-on. If you run into this problem again, we can help you construct an SQL statment to fix up your records.

If you need to change your list options frequently, it's best to use the "Get options from database (advanced)" feature (with "num" set to the option values field), which will preserve relationships between records should you need to rename any of the options.

I hope this helps! Please let me know if you have any questions.