Search results

This really looks like a master-detail (normalisation) problem, you should not be using multiple columns for this.

Excellent! Thank-you very much, worked like a charm.

My main menu in V12.6 seems to be double-spaced compared to the drop-down main menu in V10.x. An earlier post shows how to reduce the width of the main menu using CSS, but a few attempts have failed to change the height. Is there any way to reduce the height of the main menu items?

I have a database of 50,000 images, and somebody needs to mark 1000 of them as "chosen for the website". I have a field "web" as a select_single with hard-coded choices ~No~Yes~. I expected that the live edit feature would provide a drop-down on the results grid lines, but as currently...

Thanks Eugenio. Is it possible to get a copy of an interim version 11.x so I can do the upgrade in two steps?

I started from DadaBik 10.4 Manarola Enterprise, and upgraded to 11.10 Elba Enterprise without many surprises. However, when trying to upgrade to 12.6-Aveto Enterprise using the new up.php method, I got an error message after the files had been extracted saying "Unexpected table name...

I have been trying to search the forum for information on upgrading from 10.2, and the site keeps telling me it is ignoring 10 and 2 because they are too short. Searching for "10.2" also returns "too short or too long or too common". It's really annoying, and the length limit should be shorter...

I think you mean 14500, if the (now) 23rd value is less than 15k. I'm not sure there is an easy way to describe this. I have a paragraph in my docs about the failure to "Next" when the current record is edited and doesn't match the filter any more, but will have to add some more paragraphs...

Umm, yes, I'd better read the docs again :-) I need to note this in the documentation I'm providing to MY users, who aren't particularly computer-literate.

a) Start Sales/CRM demo b) Login as root c) Choose [Products] from the menu d) Change Description filter to "Contains" and enter "Radio" e) [Quick Search] returns 2 items f) Click the [Edit] icon for the first record "AM / FM Table Radio Tivoli Audio iPAL..." g) Change the word "Radio" in the...

I have been using a quick search to identify a set of records which I wish to correct. After editing a record, clicking "Save" and then "Next" returns a page saying only "The item from which you came no longer exists" It appears that the search is re-executed after the save and the corrected...

When you say "Default date", is that a database column default, or an import default? I suspect those default dates are in your database now. You could use a view to convert out-of-range dates to NULLs, or a custom formatting function (see manual 10.3) with a date comparison to return without...

I have the "Is empty" and "Is not empty" choices enabled for most of my quick search fields. However, once the search is made, they always revert to the first choice, "contains". This is really annoying. This occurs even when there is content in some of the other fields. Len. You are using...

Yes, that's how you do it. Create a create a group for public, create a user "public" with a long dummy password in the public group, put that username in the config as above, assign read rights to the custom page to the public group. To have it auto-refresh you need to emit the following html...

To chrisj: If you have Enterprise/Platinum, you can add custom buttons which can reference the array of record IDs where the box is checked. After doing sanity checks, you can then run your SQL query. In the manual, under "10.7. Custom buttons" see the section "Custom buttons and records...

Is it too much of a hassle to run two separate Dadabik applications on the same database? One for WordPress and one for internal use? Len.

I am also curious about "active" applications. When you say "if you don't use it", does that mean the web-apps phone home? Otherwise, how is "active" defined? I have never built a canned application, but have just made 4 copies of the dadabik files, given each of them a unique ID string and...

Hello, I would like to be able to create bookmarks or shortcuts which pass the username to the login form, so the user only has to enter the password. Is it possible to do this by appending some sort of parameter to the login form URL of http://192.168.x.x/Trainfinda/login.php ? Thanks, Len...

On the website at https://dadabik.com/index.php?function=show_pricing the prices in the top row of the table are in $ (USD I assume) but the maintenance prices at the bottom are in Euro. There should be a currency selector somewhere, or at least the prices should be in the same currency. BTW...

I have a number of tables with only a few columns, and all the searchable fields enabled for Quick Search. None are enabled for Search, but the Search button still appears, and when clicked on brings up a search page with no actual entry fields.