Search code examples
asp-classicadogetstring

Why does .getstring-Method produces an empty cell at the bottom of the table?


My -layout is not as expected: Why does .getstring create a single cell at the end of the table? Is this a bug? Can you fix this via getrow and join?

Thanks for your tips

Getstring-Example@ http://www.w3schools.com


Solution

  • It's a known... well, annoyance. (Otherwise known as a bug that will never get fixed.) You either have to trim off the extra delimiters using Left(), or you have to use something other than .GetString. .GetRows is probably the most useful, but note that you can't use Join with it: the latter requires a one-dimensional array, while GetRows always returns a two-dimensional array, even if the recordset only returned one column and/or row.