Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - nepo77

1
Questions / multi column list
Is there example anywhere on how to have a list of records spread across 3 columns instead of a single one , be it on a view page or
a edit page? Id like to use more width on some pages to avoid scrolling.
2
Questions / Sub Page link to Record ID
Hi

Im trying to link Recordcount boxes to a specific record id of the subpage.
I got the table Customers and the Table Accounts. Accounts has the field CustomerID.
So the subpage of customers for accounts should filter by CustomerID.
I managed to get the record count working right by adding "basename(parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH))"
in the sql query of the Recordcount as the last parameter is the record Number of the Customer List (so the CustimerID in Accounts)
but when i click on the Account Box it just goes to Accounts/list without the filtering for the Records....

Thanks for any help.
4
Questions / Is it okay to run 2 Classic Instances
I like working on 2 different projects at the same time. It seems i can open PHPRad classic several times for this. I just wanted to ask if its alright to do so ?
5
Bugs / Serach box doesnt trim
the Search box doesnt trim input from users, if they accidentally copy something with a space the search fails.
6
Questions / change welcome page
Hi

Id like to not have the standard welcome page but rather one of the sub pages instead, can i change the url of the start page somewhere ?
7
Questions / show record based on user table info
Hi
Id like to display a record from Table A that has the field company. company is also a field in the user table.
Ive seen the global constants like USER_ID which i can use in a sql query but how do i do the same with alternate field of the usertable as these are not constants as far as i know. Or can i just do USER_company as argument in the query ?
8
Questions / Re: how can i see entire query ?
Thanks that worked!

Now the query displayed is

SELECT SQL_CALC_FOUND_ROWS id, b, pseudo, f, g, h, altersklassen.id AS altersklassen_id, altersklassen.Klasse, kategorien.id AS kategorien_id, kategorien.kategorie FROM meisterschaft WHERE e REGEXP '[a-zA-Z]' AND Index = NULL ORDER BY g DESC, h DESC LIMIT 10 OFFSET 0

and mysql sais syntax error near Index=Null
Which i dont understand cause i never had a field named Index in there...  ::)
9
Questions / Re: how can i see entire query ?
I did this
$records = $db->get($tablename, $limit, $fields);
      echo $db->getLastQuery();

But doesnt show anything for me besides the standard error.
10
Questions / Re: how can i see entire query ?
It is the List Page of a table in classic 2.59 . It was originally created with 2.5.1.
I used the duplicate page feature to make another one based on this one which was working and then after publish it no longer worked.
11
Questions / how can i see entire query ?
Im getting this SQl error on a page i didnt change at all and im at a lost whats causing it. I need to see the entire query, this is not telling me the problem. I dont know what Index= Null means, i have no such field. Is there a way to see it as its passed to mysql ?

"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Index = NULL ORDER BY g DESC, h DESC LIMIT 1000 OFFSET 0' at line 1"


Thanks for any help.
12
Questions / changelog
Is there a changelog somewhere for the new version ?