Hi
I took a backup of CONTSUPP table, modified the field size back to 35 on the SQL table. Voile - it's worked. Although the odd characters are still in the Address1 field, they now do not display on the email address and all seems okay. Thanks for all your help, saved us a huge amount of...
Hi Doug
The first query was great, it's shown me all the records that I have a problem with. The second query shows that although Address 1 field lengths are the same, the contsupref has a field length of 35, but 75 in the SQL table.
Do you now know how I can fix the 'broken' records and, if...
Hi
I'm using Goldmine 6.7 on SQL. We're having problems with some email addresses that are getting extra characters within them, for example an email address might look like this, <<name@company. co.uk>>, or like this, <<name@company.co.uk o.uk>>, even if you delete the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.