On Mon, 2004-05-03 at 15:02, Tyler Hepworth wrote:
> 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.
Perfect Tyler, Thanks!!
Best regards,
Mark
--
__
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"'
>>>
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
> 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 t
On Fri, 2004-04-30 at 23:05, Tyler Hepworth wrote:
> L. Mark Stone wrote:
>
> > Is there a way to change the Customer ID for every existing
> > ticket on a per queue basis? (We have thousands of tickets
> > in our database already, so changing each one manually is not very
> > attractive!)
>
>
Thanks Tyler, we'll give it a whirl!
Assume all good news unless you hear from us otherwise!
Appreciate your help very much,
Mark
On Fri, 2004-04-30 at 23:05, Tyler Hepworth wrote:
> L. Mark Stone wrote:
>
> > Is there a way to change the Customer ID for every existing
> > ticket on a per queue
L. Mark Stone wrote:
> Is there a way to change the Customer ID for every existing
> ticket on a per queue basis? (We have thousands of tickets
> in our database already, so changing each one manually is not very
> attractive!)
You are right manual labor is not attractive. Fortunately, SQL is
On Fri, 2004-04-30 at 15:59, Tyler Hepworth wrote:
> L. Mark Stone wrote:
> >
> > Unfortunately, this customer user sees no existing tickets
> > when they log in. They only see tickets that they themselves create.
> >
> > What have we done wrong?
>
>
> The tickets that are displayed are determ
L. Mark Stone wrote:
>
> Unfortunately, this customer user sees no existing tickets
> when they log in. They only see tickets that they themselves create.
>
> What have we done wrong?
The tickets that are displayed are determined by what is set in the field
"CustomerID". If you want a manager
