I don't think your taf would work, some values would need to be
quoted, and some wouldn't. Also, what about dates? Some may need to
be escaped or formatted properly. What about blobs, or unicode, or
any other data type that wtiango would insert using a bound value.
What about a text field in it, that had a comma in the data. There
are many reasons why this taf wouldn't work.
To work, I think you would have to also do a select, that your DB
supports, that would describe the fields of the database for you, and
do the appropriate thing in building the insert statement, based on
datatype. You would need to escape any data that could contain a
quote, and think about all of those lovely issues.
One of the things witango does so nicely for you, is it handles all
of this type of stuff (escaping, bound values, and such) for you in
its DB actions. You lose all of that, and must do yourself, if you
choose to go direct dbms, and MUST think of all the possibilities
that can blow up your statement.
The reason I suggested VB or RB, is it does all for you (it is
supposed to, I HAVE had to work around a few bugs in the past).
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Jul 28, 2005, at 2:08 AM, Alan Wolfe wrote:
<sqltest.taf>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
