L. Mark Stone wrote:
On Mon, 2004-05-03 at 12:49, Tyler Hepworth wrote:
Error: Unknown table 'queue' in where clause, SQL: 'update ticket set customer_id = ClientIDName where queue.id = ticket.queue_id and queue.name = "First Client Name::Incoming"'
Yes, it exists, but the sql query doesn't know where to find it because I forgot to specify it.
Query needs to be this
update ticket,queue set ticket.customer_id = ClientIDName where queue.id = ticket.queue_id and queue.name = "First Client Name::Incoming"'
Hi Tyler,
Well it helped in that I now have a different error! ;-)
Error: Unknown column 'ClientIDName' in 'field list', SQL: 'update ticket, queue set ticket.customer_id = ClientIDName where queue.id = ticket.queue_id and queue.name = "First Client Name::Incoming"
Any ideas? And thanks for your time on this!
Surround ClientIDName with ' ' so that MySQL will recognize it as a value. Without the quotes it is trying to interpret it as a column in a table. Hth, Tyler