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