script insert row in table

[lamson_]

Hello Ladies and Gentlmen,

I have a table call 'u_test' and there are the fields 'field_one' and 'field_two',

i would like to write a script that will create a row in this table with 'field_one' and 'field_two' fill.

My current attempt was with:

var database = new GlideRecord('u_test');

database.initialize();

database.field_one='hello';

database.field_two=4;

database.insertWithReferences();

But it only create a record without any value in the 'field_one' and 'field_two'.

Maxime NGUYEN.

----------------------------

Re all: Thanks for all your answer,

Sorry for all your trouble, i'm embarassed, actually there isn't any error in the script itself, it was just me who had put caps without noticed it.

Message was edited by: Maxime NGUYEN

[Aakash Shah4]

Hi,

use this

var database = new GlideRecord('u_test');

database.initialize();

database.setValue('field_one','hello');

database.setValue('field_two',4);

database.insert();

[lamson_]

Hi, thanks for your fast answer,

It still adds a row without any value in it, it send this error message:

UA: Could not find app attrs for app u_test, for table u_test

[Aakash Shah4]

Use this

database.setValue('field_one','hello');

database.setValue('field_two',4);

[lamson_]

Re: Same problem.