safe_insert using AND in the WHERE clause

NicolasGraph · 2016-07-06 16:09:08

safe_insert using AND in the WHERE clause does not work; what would be the easier way to do that?
Should I use safe_query?
Thanks for your help.

ruud · 2016-07-06 17:15:33

Can you post the code that doesn’t work?

NicolasGraph · 2016-07-06 18:03:01

Here is the idea:

safe_upsert(
    'txp_lang', 
    'data = "My data", event = "public"',
    'name = "my_data" AND lang = "en-gb"'
)

Edit: … and here is the error message User_Error "Duplicate entry '0' for key 'lang'"

Edit#2: Here is the INSERT command if the row does not exist:
[SQL: INSERT INTO txp_lang SET name = 'my_data' AND lang = 'en-gb', data = 'My data', event = 'public' ]

Last edited by NicolasGraph (2016-07-06 18:54:28)

ruud · 2016-07-06 20:28:07

safe_insert('txp_lang', 'data = "My data", event = "public", name = "my_data", lang = "en-gb"');

Should work fine…
However, you’re using safe_upsert, which internally calls safe_insert, but can’t handle anything more then the most simple ‘where’ part. It’s a safe_upsert limitation. One could consider this a bug. If so, open an issue at github.

NicolasGraph · 2016-07-07 06:35:40

ruud wrote #300218:

One could consider this a bug. If so, open an issue at github.

Thanks Ruud, I sent a pull request; let see what will happen…

Last edited by NicolasGraph (2016-07-07 06:36:04)

Textpattern CMS

Textpattern CMS support forum

#1 2016-07-06 16:09:08

safe_insert using AND in the WHERE clause

#2 2016-07-06 17:15:33

Re: safe_insert using AND in the WHERE clause

#3 2016-07-06 18:03:01

Re: safe_insert using AND in the WHERE clause

#4 2016-07-06 20:28:07

Re: safe_insert using AND in the WHERE clause

#5 2016-07-07 06:35:40

Re: safe_insert using AND in the WHERE clause

ruud wrote #300218:

Board footer