JScript ADODB.COMMAND: can someone provide some examples?
-
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?
I'm not positive what your trying to do here but it seems that if you have a chance of a data being an empty string. And this is valid for your application then you should allow zero length fields in your database. Good Luck!!