Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 7:55 am
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.