Can you execute the problematic query directly against your db,
without witango?
On Nov 19, 2005, at 2:41 PM, Roland Dumas wrote:
and it crashes witango still...... this is befuddling....
On Nov 19, 2005, at 11:35 AM, Roland Dumas wrote:
I've changed from witango generated sql to a direct dbms. Also
changed column from tinytext to varchar. I'll know if that
resolved the issue the next time a batch of orders is processed.
Thanks for all the ideas, folks.
On Nov 18, 2005, at 11:18 AM, Robert Shubert wrote:
I would definitely try a directdbms in that case, get away from
the SQL generator. The NULL could be an issue. Personally I’m in
the habit of making flags that contain a 0 or a 1 and block the
NULL case. It’s entirely possible that there’s some glitch in
dealing with the NULL column.
On other thing would be to trace the DB. You’d like to know if
the SQL statement is getting to the SQL server or not.
Robert
From: Roland Dumas [mailto:[EMAIL PROTECTED]
Sent: Friday, November 18, 2005 2:04 PM
To: [email protected]
Subject: Re: Witango-Talk: crashing witango 5 on OS X
On Nov 18, 2005, at 9:56 AM, Robert Shubert wrote:
Well, focus on that action then and see if you can determine if
the problem is Witango’s handling of the action, or the database
or the connectivity driver.
I have been through the ODBC dramas and know their signatures -
which show up in the crash log. This has a different signature,
and looks like it's wholly within witango, as all the threads say
"witango" on them.
Again, I would start by either moving that search action to a TCF
call to further isolate it or use a Direct DBMS to remove
Witango’s SQL generator from the picture.
You may want to start logging the input that goes into your
search criteria as before write a file, send an email, whatever,
just record all the criteria that went into the statement. After
you get a good response you can mark the criteria set as OK or
delete it. When the crash happens, you’ll theoretically be left
with the bad criteria to do further testing with.
search criteria are UID = <@ARG UID>. It's looking up a
transaction record for processing.
thing is that this worked without a hitch until I brought in one
more field. The field contains a null or a Y. That's it.
Robert
_____________________________________________________________________
___ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/
maillist.taf
Roland A. Dumas
310 W. Bellevue Ave.
San Mateo, CA 94402
650-347-1373
415-412-9300 (cell)
AIM: radumas
[EMAIL PROTECTED]
______________________________________________________________________
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Bill
William M. Conlon, P.E., Ph.D.
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
