MySQL Forums
Forum List  »  Newbie

Cannot write to database
Posted by: Neil Pfister
Date: March 13, 2009 10:41AM

I am a real newbie with MySQL, and I am having problems writing to a particular table. The result I am getting is:

request "Could not execute SQL query" SELECT dt FROM webcalendar_events WHERE dt in ('2009-03-13') AND calendar_id=cum_wetheralhalls FOR UPDATE Unknown column 'cum_wetheralhalls' in 'where clause'

The strange thing is that when the calendar_id is a numeric value, it works perfectly. Is there anything that I can do in MySQL to get this to work with text-characters also, or do I have to use numeric values for this?

Is this something in the PHP script that is preventing it from saving to the database?

In case you need to know the table row calendar_id is varchar(30).

Look forward to some of you shining some light on this one for me!

Thanks,
Neil

Options: ReplyQuote


Subject
Written By
Posted
Cannot write to database
March 13, 2009 10:41AM
March 14, 2009 02:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.