GlideMultipleUpdate with addQuery

[Chris P_]

I'm trying to use GlideMultipleUpdate, but it behaves kinda weird...

Here's my code:

var grt = new GlideMultipleUpdate("u_grit_path_import");

grt.addQuery('u_groupname', 'BUILTIN\\Administrators');

//grt.addQuery('u_groupname', 'CONTAINS', 'BUILTIN');

//grt.addQuery('u_groupname', 'IN', 'BUILTIN\\Administrators');

//grt.addQuery('BUILTIN', 'IN', 'u_groupname');

grt.setValue("sys_import_state", 'ignore');

grt.execute();

I've tried with different options which are commented out in the above example, but I keep getting the error message:

*** ERROR *** com.glide.db.GlideSQLException:

See glide log for error details

With the following message in the log:

*** ERROR *** com.glide.db.GlideSQLException:

And when I don't get an error message, he just skips the where-clause and updates all records.

I'm at a loss, any ideas anyone?

[sergiu_panaite]

Hi Chris,

I see you are mixing "" with '' in your script. Can you keep only one type of quotes?

Regards,

Sergiu

[Chris P_]

I usually use single quotes, but I copied the first line from a website, so I didn't replace them... (as for the setValue I see now)

I only tend to use double quotes when there is a single quote inside the string.

Though I'm not seeing as how that solves this problem?

[sergiu_panaite]

I thought initially that the Glide call being translated to a SQL call would cause issues because of the mix of quotes, but checking again, I don't think that's the issue here.

From the log, under "*** ERROR *** com.glide.db.GlideSQLException:" there should be something more. Can you paste the full error? And stack trace under if available?

Regards,

Sergiu

[Chris P_]

Yeah after the : you would expect something more... But it only showed a blank line and after that a line with the runtime...