Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (2)

Resolved Problem retrieving from DB (WHERE (optional)... country=1 AND published=1)

  1. raylee
    raylee
  2. Support
  3. Thursday, May 18 2017, 07:39 AM
I can't get the first to work to populate a selectlist field for a Country, and because of that, the 2nd and 3rd slectlist field for Region and Location is affected.

All of these use the same #__xxxregion table

1. Country is value=id, title=name, WHERE country=1 AND published=1
2. Region is value=id, title=name, WHERE city=1 AND published=1, filter is where Country is parentid=id of Country
3. Location is value=id, title=name, WHERE country=0 AND city=0 AND published=1, filter is Region where Region is parentid=id of Region

I got this to work before in earlier versions of Easy Profile 1.x but it doesn't seem to work any more :(
  1. data type
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
this happen after an update? or in a new installation?
  1. more than a month ago
  2. Support
  3. # 1
mummy-market
mummy-market Accepted Answer
Hi, I'm Ray Lee above. Apparently my question to you was detected as spam and has blocked me out of the system. So I couldn't give you a response. Can you unblock me? Anyway I noticed the problem happened after updating to 2.x. I cannot even do a simple populate from a DB table. Please help. How should I give you private info for my backend?
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.