https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


only display with mysql condition

  • vincentjiang
  • vincentjiang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 6 months ago #124

I just bought this software tonite. Everything seems to be working.

I see the the advance condition which is not apply to database query...It makes me worry. 'cause I only advance condition apply to database to display certain information base on my sql condition.

Please Log in or Create an account to join the conversation.

More
14 years 6 months ago #126

Hi Vincent,

what kind of advanced condition did you apply?

If this is id=@user_id and you are using e.g. Oracle DB, then you must provide table or view in Oracle DB with column id (copy of joomla column id in jos_users table).

If something else please let me know...

Best regards,
Viljem

Please Log in or Create an account to join the conversation.

  • vincentjiang
  • vincentjiang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 6 months ago #128

it is something else...

for instance...in my database table, i have following "status" column, i want only display "open" status for my database table with this condition apply.

Please Log in or Create an account to join the conversation.

More
14 years 6 months ago #129

E.G.:

In mssql I have table Customers (see demo page). I want to filter ContactTitle (the name from DB) only Owners.

WHERE ContactTitle = 'Owner'

When I look on frontend I see only Customers that have ContactTitle equal to Owner.


Which DB are you using?

Last edit: 14 years 6 months ago by user62.

Please Log in or Create an account to join the conversation.

  • vincentjiang
  • vincentjiang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 6 months ago #130

it is external database that I use to display for trading record.

Please Log in or Create an account to join the conversation.

More
14 years 6 months ago #131

Yes, above example uses external db, in fact MS-SQL.

What is the type of the Status field?

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.133 seconds

Contact Us

Contact us on Discord

Contact us on Facebook