I don't understand how in ASP empty strings are handled. I check if if a field in a resultset has indeed a value. If not, I'll add "" to the dictionary. Afterwards, I want to use the items in the dictonary but there's not "" in some fields, but the Object-type null! So I have to test on it and set the string to "" myself :( // oRs is a ADODB.ResultSet // d is a Scripting.Dictionary

e = new Enumerator(oRs.Fields); for (;!e.atEnd();e.moveNext()) {

i= e.item(); if (typeof(i.value) != "unknown")

d.add(i.name, i.value);

else d.add(i.name, "");

} arr = (new VBArray(d.Keys())).toArray for (i in arr) {

q1= d(arr[i]); if (q1 == null) q1= ""; q= Server.HTMLEncode(q1);

}

Can anyone help me?

I don't understand how in ASP empty strings are handled. I check if if a field in a resultset has indeed a value. If not, I'll add "" to the dictionary. Afterwards, I want to use the items in the dictonary but there's not "" in some fields, but the Object-type null! So I have to test on it and set the string to "" myself :( // oRs is a ADODB.ResultSet // d is a Scripting.Dictionary

e = new Enumerator(oRs.Fields); for (;!e.atEnd();e.moveNext()) {

i= e.item(); if (typeof(i.value) != "unknown")

d.add(i.name, i.value);

else d.add(i.name, "");

} arr = (new VBArray(d.Keys())).toArray for (i in arr) {

q1= d(arr[i]); if (q1 == null) q1= ""; q= Server.HTMLEncode(q1);

}

Can anyone help me?

I have an html-'template' with a form in it. When it is submitted, the entries will add to an ADODB.COMMAND to update a record in a database. I am having difficulties with empty form-entries: ADODB.COMMAND.Execute() is complaining about 'cannot use 0-length strings'. A simple workaround like if (s == "") s= " "; does the trick, but that's ugly: I don't want random spaces to appear in my database! Anyone?

I have an html-'template' with a form in it. When it is submitted, the entries will add to an ADODB.COMMAND to update a record in a database. I am having difficulties with empty form-entries: ADODB.COMMAND.Execute() is complaining about 'cannot use 0-length strings'. A simple workaround like if (s == "") s= " "; does the trick, but that's ugly: I don't want random spaces to appear in my database! Anyone?