where field lost a part of string?

More
10 years 7 months ago - 10 years 7 months ago #2352 by MichaS.
where field lost a part of string? was created by MichaS.
Dear Supporter,

the where string work in one of my string very well, but not in this:

(prog_call_eu-period='6')


i receive follow error-message in the top of the frondpage:

Fehler : Unknown column 'prog_call_eu' in 'where clause' SQL=SELECT a.* FROM `j25_fn_proxxx_caxxx` AS a WHERE ((prog_call_eu-period='6')) GROUP BY a.`id` ORDER BY a.`id` DESC LIMIT 0, 10


i mean it lost the last part of the colums-string?

what i can do?

when i cange i the database the name of the field from "prog_call_eu-period" to "prog_call_eu_period", it works fine ;-)


Michael from berlin
Last edit: 10 years 7 months ago by MichaS..

Please Log in to join the conversation.

More
10 years 7 months ago #2356 by Dirk
Replied by Dirk on topic where field lost a part of string?

MichaS. wrote: when i cange i the database the name of the field from "prog_call_eu-period" to "prog_call_eu_period", it works fine ;-)


First of all. Remove the brackets.

It's not a Bug the MIUNS sign in prog_call_eu-period is interpreted as MIUNS.

So set `prog_call_eu-period` in cursive single quotation mark.

Also if you have spaces in your field-names!
The following user(s) said Thank You: MichaS.

Please Log in to join the conversation.

More
10 years 7 months ago #2358 by MichaS.
Replied by MichaS. on topic where field lost a part of string?
Dear Dirk,

thank you well for this very fast support.

I will try this when come the next error-message, the last errors i solve with rename the column in the database...

Greetings to the other side of tzhe river spree


Michael from the east side of the eastside-gallery ;-)

Please Log in to join the conversation.

Moderators: Dirkjoest