Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

where field lost a part of string? 8 years 2 months ago #2352

  • MichaS.
  • MichaS.'s Avatar Topic Author
  • Offline
  • Posts: 26
  • Thank you received: 1
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

Please Log in or Create an account to join the conversation.

Last edit: by MichaS..

where field lost a part of string? 8 years 2 months ago #2356

  • Dirk
  • Dirk's Avatar
  • Offline
  • Posts: 1185
  • Karma: 21
  • Thank you received: 224

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 or Create an account to join the conversation.

where field lost a part of string? 8 years 2 months ago #2358

  • MichaS.
  • MichaS.'s Avatar Topic Author
  • Offline
  • Posts: 26
  • Thank you received: 1
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 or Create an account to join the conversation.

  • Page:
  • 1
Moderators: Dirkjoest