Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › Strange error I have no idea of how to deal with

View all replies to this thread

Strange error I have no idea of how to deal with

Thread began 8/20/2012 6:57 pm by mrs | Last modified 8/21/2012 9:35 am by mrs | 1222 views | 5 replies

8/20/2012 6:57 pmmrs

Strange error I have no idea of how to deal with

'Column 'fld_id' in field list is ambiguous' with pages created using Data Assist from Data Bridge

The files it's happening on are the details page and the results list. What's going on here then?

I have narrowed it down to the drop down menu where I used the fld_name for the labels, but I used the fld_id for the values... it's these that it considers ambiguous, but I have no understanding of why, especially when the DB settings for it are INT, 11, UNSIGNED, PRIMARY KEY which is pretty standard for a key column in MySQL.

If I use the fld_name for both labels and values, then the error disappears.

Any thoughts?

I've attached the files affected in a zip file.

Attached Files

ambiguous error.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.