Year coming in from database with comma HELPPPPP - Objectif Lune Tech Support Self Help

IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

You are not logged in. [Log In] Objectif Lune » Forums » PrintShop Mail Suite 7 » PrintShop Mail Design » Year coming in from database with comma HELPPPPP

Topic Options

#53347 - 04/20/16 03:13 PM Year coming in from database with comma HELPPPPP
scustodio OL Newbie Registered: 04/20/16 Posts: 1	I really need help with this. I am pulling from the database a field named "Year" and it has years of vehicles in it. However, when it populates, it comes with a comma in it. Ex. "2014 Subaru Outback" is coming like "2,014 Subaru Outback" How can I fix this?!
Top

#53355 - 04/20/16 06:05 PM Re: Year coming in from database with comma HELPPPPP [Re: scustodio]
Jeff_K Unregistered	scutodio This sounds like the input field is identified as a number instead of an text field. You should be able to convert the input field to a string via a variable using something like STR('Year') and then use the variable in place of the original field.
Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: Alex Banahene, cosimo, Jean-Cédric, OL Newsgroup Support, OL Newsgroup Training, Philippe F., Raphael Lalonde Lefebvre