Questions tagged [sql]

Structured Query Language (SQL) is a language for querying databases.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
23 views

Using the SQL `Delimiter` statement in component update

For the next version of my component I need split some data into different tables, which requires some rather more complex SQL than I would usually use. The problem is that there doesn't seem to be a ...
1
vote
1answer
48 views

How to store component parameters after modification

As I understand it, the current values of a component configuration are stored as JSON in the params field of the #__extensions database table, in the entry that matches the component name as element. ...
1
vote
1answer
36 views

How to use Joomla's query building methods to generate a query containing joined subqueries?

I am trying to write a query using Joomla's query building methods, but I cannot manage to write the subquery into the query. Here is my desired raw sql with php variables: "SELECT track_type, ...
1
vote
2answers
60 views

How to count aggregate data from RSForm submission values with Joomla's query building methods?

user SubmissionId FormId FieldName FieldValue bob 2 16 state mystate1 bob 2 16 qda myqad1 bob 2 16 city mycity1 rob 3 16 state mystate2 rob 3 16 qda myqad1 rob 3 16 city mycity1 jac 4 16 state ...
0
votes
0answers
18 views

How do I get Edit Profile to not save with invalid date input on Joomla Community Builder

On my volunteering website, users can edit their profile and enter a date in the future when they are available to volunteer. If they are already signed up for a volunteer opportunity, they shouldn't ...
0
votes
0answers
33 views

ERROR 1054 when login in admin section

An exception has occurred while executing: SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.email AS ...
0
votes
1answer
196 views

Use the “sql” form field type in extension xml only if the table exists

I developed a plugin for Joomla!, and I have the below sql parameter field in my sampleplugin.xml <field name="cb_fields" type="sql" label="Select CB fields" query="SELECT name ...