Forums

Hi,
I have built a record listing page with chronoconnectivity and I am using chronoforms to display details of the record. I have this in my connectivity linkable fields box, t1.pkiGREPID:partner&cb={t1.pkiGREPID}&cn={t1.vcCompanyName}, so I am passing pkiGREPID to chronoforms in order to display the appropriate record. I am passing vcCompanyName because I want that field displayed in the sef url. All is working perfectly, the only thing is that sometimes the value of vcCompanyName has spaces and in some browsers they display as %20. I'd very much like to replace the spaces with a dash and have been trying to find a way of either adding a msql replace function into the connectivity query or adding a php replace function into the appropriate connectivity php file.

Please could you offer some advise here, am I missing something? Is there another way to accomplish this?

Here is a link to the listing page https://grep.mygateglobal.com/developers
and if you 'view profile' you will see how the links currently appear.
eg:
https://grep.mygateglobal.com/developers/partner/409/WEBiT%20Digital%20Solutions
I want to display like this.
https://grep.mygateglobal.com/developers/partner/409/WEBiT-Digital-Solutions

Hi webstardev,

I don't know the answer to this. If the names have spaces then they have to be urlencoded to be used in a URL - maybe replacing the spaces with '+' will prevent the %20 being used??

Bob

I am passing vcCompanyName because I want that field displayed in the sef url

Then you have to make sure that the field value is url safe, you can process the value before its used in the link if you have a "Custom listing", or use the "Auto listing event" if you have an "Auto listing".

Regards,
Max