Remove Slash from SQL Field for Image S’abonner

0
Avatar
John Peters

 I am using the Itemcode field in  our database to have a corresponding image displayed.

Unfortunately we have a number of items in itemcode that have a forward slash "/" in them and so windows OS does not like them  eg BFF500/R3.

The Picture Properties does not include a transform tab to allow the substitution of the slash character is there some other way to do this ?

Ideally I would like to be able to either just remove the slash or substitute with another valid DOS character.

Changing the Itemcodes in the DB is not possible 

5 commentaires

0
Avatar
John Peters
Actions pour les commentaires Permalien

Sorry an a noob to this

I have created a hidden text box behind the graphic which gets the field and performs the transform - is there a way to reference this in the graphic or some VB script I could run ?

0
Avatar
John Peters
Actions pour les commentaires Permalien

Well somehow the transform box is now available for the graphic so no problems !

0
Avatar
John Peters
Actions pour les commentaires Permalien

Now its not available  - i'm not sure if its me or the program ?

The Picture doesn't have the Data Sources Option only the DB part in the Picture Source

 

 

0
Avatar
John Peters
Actions pour les commentaires Permalien

This is what I want - with the additional data source properties

0
Avatar
John Peters
Actions pour les commentaires Permalien

So the solution is to not use "Get from the database field" and use the " Get the filename from Data Source" you can then specify the Database field to retrieve and perform the transform on it.

Vous devez vous connecter pour laisser un commentaire.