[ic] Using MyODBC to update MySQL tables
Doug Alcorn
doug at lathi.net
Sun Dec 7 20:23:37 EST 2003
Joshua Lavin <joshua at kingdomdesign.com> writes:
> The new way we're trying is using MyODBC to do updates on the
> products database directly. [snip] I'm wondering if there could be
> any problems with using this method. Say the update fails halfway,
> is products going to be ruined?
Here's my warning: all user input is bad. I've had problems trying to
facilitate that catalog owner uploading new data because he has a hard
time exporting the .txt files correctly (wrong column names, invalid
data types, DOS carriage returns, etc.) I don't know what your setup
is; however, I strongly encourage you to validate the data as it comes
in.
--
(__) Doug Alcorn - Unix/Linux/Web Developing
oo / PGP 02B3 1E26 BCF2 9AAF 93F1 61D7 450C B264 3E63 D543
|_/ mailto:doug at lathi.net http://www.lathi.net
mailto:tarpit at lathi.net is a spam trap
More information about the interchange-users
mailing list