Does mySQL support AbsolutePage? I thought it didn't and that's what everyone has said here when a question has come up.
But I've got it to work. All you need to do is set the CursorLocation to adUseClient (3) and it works perfectly. Is this right or have I missed something?
Well in theory it should, but I'm not so sure about it and I cannot try (no MySQL installed and no intention of doing it). I've also tried to use client side cursors with MySQL to help a friend (at his hosting machine) and it doesn't always work (at least it didn't with some Snitz code, althout I cannot remember whether that was base Snitz or Huw's Snitz version).
Nevertheless you should be aware that using a client side cursor does slow things down (although I cannot quantify how much). So if you can do it at the server side that's the best option.
Topic Locked
Posted - 27 April 2002 : 10:57:25
.