List Labels with my sql query

3 posts by 3 authors in: Forums > CMS Builder
Last Post: August 26, 2010   (RSS)

Re: [rjbathgate] List Labels with my sql query

By Jason - August 26, 2010

Hi,

Is the advanced sql statement part of a brand new field, or did you modify a field that was already there? If you just modified it, records using the old field would still have their old values. That could account for this.

If that's not the case, I'll need to take a closer look at the records where this is happening. If you could email your FTP Details and CMS Information to jason@interactivetools.com and let me know which page you're experiencing this error, I can take a closer look.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [rjbathgate] List Labels with my sql query

By Dave - August 26, 2010

Hi Rob,

Because of the way those fields interact you pretty much have to look those values up manually with an SQL query.

Let me know if you need a hand with that.
Dave Edis - Senior Developer
interactivetools.com