RE: Can anybody see why the first SQL statement works but the second throws an error.

2007-06-13 Thread Ian Skinner
Are these executing in one cfquery block? If so, do you need a command separator between the statements (mysql uses ";" for example)? Now, there where two examples of the same tag running but with different values. See my follow-up for a solution, but I have a question of why the solution was

RE: Can anybody see why the first SQL statement works but the second throws an error.

2007-06-13 Thread Ian Skinner
you're sure the second one is bombing? Can you try the page with JUST that one? Exclude the 1st one. Also vice versa, try the other one the same way. Yes, I'm sure. This was a case of the same query being run with different data. See my follow up on a working solution, but I would like to know

RE: Can anybody see why the first SQL statement works but the second throws an error.

2007-06-13 Thread Ian Skinner
Ok, I have go it to work, but I would like to know why. This code works: UPDATE INTRANET.TRAK_CMP SET LOC_CODE = '#FORM.LOCCODE#', CMP_CD = '#newCompCode#', SCAN_DATE = #CreateODBCDateT

RE: Can anybody see why the first SQL statement works but the second throws an error.

2007-06-13 Thread Gaulin, Mark
Are these executing in one cfquery block? If so, do you need a command separator between the statements (mysql uses ";" for example)? Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 12:35 PM To: CF-Talk Subject: Can anybody see wh

Re: Can anybody see why the first SQL statement works but the second throws an error.

2007-06-13 Thread Greg Morphis
you're sure the second one is bombing? Can you try the page with JUST that one? Exclude the 1st one. Also vice versa, try the other one the same way. On 6/13/07, Ian Skinner <[EMAIL PROTECTED]> wrote: > UPDATE INTRANET.TRAK_CMP > > SET > > LOC_CODE = 'ROSE', > > CMP_CD = '018251', > > SCAN_D