Customer e-mail field

[Beatwear]

Hi,

We have a customer who has tried to order from us on a site that we still run v5 on. Her e-mail account is 43 characters long and although she can complete the checkout process when we try to download the order we get the "string data truncated" message and the order will not come through and we have to abort the download.

It appears that this is due to the e-mail field too short. Anyone know what I should do to lengthen the field or can this not be done?

Cheers in advance,
Jon

[Beatwear]

Anyone?

Ok I know this is a bit like asking how stone age man made fire now v8 is out but someone must know

Thanks in advance

J

[Mike Hughes]

Personally I don't know enough to mess about with Actinic so I leave it alone and work around it.

In this case I'd limit the input to the form filed using maxlength and possibly have some javascript to warn the customer if they try to exceed the limit. At least that way you'll get the order and can always follow up to get the email address later if needed.

Mike

[Bruce]

Make sure Actinic is closed. Navigate to 'C:\Program Files\Actinic ecommerce v5\Sites\Site1' and open the Access Database, its called 'ActinicCatalog.mdb'. Before making any changes, please make a back-up of the database and save it to an alternate location. Within the database you will find a table called 'Person' double click on it to open, click on 'Design View' and then click on the 'Email Address' Field, you will find that the field size is set to '40'. Increase the field size and save changes. Close the table and then the database, open Actinic and you should be able to download an order from the same customer. Remember you have a backup in the event something goes wrong.

Kind regards,