only display with mysql condition
(1 viewing) (1) Guest
 | | |
|
TOPIC: only display with mysql condition
|
|
only display with mysql condition 6 Months, 3 Weeks ago
|
Karma: 0
|
|
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.
|
|
|
|
|
|
|
Re:only display with mysql condition 6 Months, 3 Weeks ago
|
Karma: 1
|
|
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
|
|
|
|
|
|
|
Re:only display with mysql condition 6 Months, 3 Weeks ago
|
Karma: 0
|
|
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.
|
|
|
|
|
|
|
Re:only display with mysql condition 6 Months, 3 Weeks ago
|
Karma: 1
|
|
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: 2010/01/08 04:33 By viljem.
|
|
|
Re:only display with mysql condition 6 Months, 3 Weeks ago
|
Karma: 0
|
|
it is external database that I use to display for trading record.
|
|
|
|
|
|
|
Re:only display with mysql condition 6 Months, 3 Weeks ago
|
Karma: 1
|
|
Yes, above example uses external db, in fact MS-SQL.
What is the type of the Status field?
|
|
|
|
|
|
|
 | | |
Tools JX, Powered by ; by SG
