RE: VB, MyODBC, MySQL problems

[David Schuetz]

> For goodness sake, don't switch to an all-MS solution! 

I figured that'd get SOMEBODY's attention. :-)

I've had three quick responses, all of which suggested I escape some of the
more problematic characters (' and ").  That seems to be working now, with a
straight command execution (cmd.commandtext = "UPDATE ....", cmd.execute),
but I've already discovered at least one extra character that needed
escaping (?, for some reason).

This approach always makes me nervous, mostly 'cause I'm never certain
whether i've found all the possible problems or whether I'm just introducing
new ones.  

Does anyone know how the "Visual Data Manager" does things?  That Add-In
seems to have no problems updating the DB, as long as I use "Dynaset"
(instead of "Snapshot").  I'm gonna revisit my straight-ADO code and see if
I can't figure out how to work some "dynaset" option into it...

I'd really like to go to ADO, just 'cause it's a lot cleaner (rs!content =
dhtml1.document.html, rs.update) than doing SQL stuff..

Thanks for all the help so far!


david.