where field lost a part of string?
- MichaS.
- Topic Author
- Offline
Less
More
- Posts: 26
- Thank you received: 1
10 years 8 months ago - 10 years 8 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:
i receive follow error-message in the top of the frondpage:
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
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 8 months ago by MichaS..
Please Log in to join the conversation.
- Dirk
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
10 years 8 months ago #2356
by Dirk
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!
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.
- MichaS.
- Topic Author
- Offline
Less
More
- Posts: 26
- Thank you received: 1
10 years 8 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 ;-)
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: Dirk, joest