…By the way, thanks for your responsiveness to all of my other questions. Right now I’m trying to create a query which is working except it won’t display a field that is formatted as a text field instead of a verchar(200) which will display. I need that filed to populate a select control. It’s not showing up in the query when I run it. I’m going to see if it’s available anyway when I try to bind it to the select. But is there any reason why a “text” formatted field called “unique_key” wouldn’t display in the query builder? Thanks.
I did not try to change the field type because I have about 30 database tables they I would have to change. It works but I spent about an hour wondering why it wasn’t showing up in the results.
My goal is for the Manufacturer’s select to be the filter for the product’s select. If that works, then I’ve got about 10 other sites to do this one. Seems like a simple bug maybe. Thanks.
I’m not having much luck getting this to work on my server. The database it’s pulling from is on my server though so in theory, if I copy everything to my server, I’m thinking it should work. Just don’t see a lot of examples online. It’s been a while since I’ve created anything data driven. I’m a old Dreamweaver user and used to use Webassist.
I’ve got a project tomorrow involving creating a landing page with an autoresponder. If I can get this to work, you’ll have a new subscriber. lol. I have lots of project I can use this for if I can get this local project deployed to my server. Thanks.
The field unique_key will not show up in the query builder so I thought something was wrong. I’m just not sure if this was by design or whether it’s a bug. Because I didn’t see unique_key, I didn’t even try to continue and spent about an hour. I thought there was something wrong with my query. lol.
I don’t really understand what the issue, with your query results are, but the Value field here:
must be some value returned from the query, not $value. Same way you selected unique_key for the text, you need to select some kind of id or whatever the value of the select option must be.
