Heim Architekt
Hi all! Using Informix Online Dynamic Server 7.24UC3 on HPUX 10.20 i have the following problem: Having a website with an text-area form element, inserting this input into a database via "insert into..."-SQL-statement (using a web-database gateway). If the string exeeds more than 256 bytes, error -280 occurs in the users webbrowser:"A quoted string exeeds the allowable limit of 256 bytes." This errror occurs with any kind of Informix data type supporting char more than 256 length. It is a known bug at Informix hotline. There are three possibilities to insert this value: 1. Writing the value in ASCII in file system and inserting this into the database via "load from ... insert into ..." 2. Creating an ESQL/C program. 3. Splitting this data fild in 4 or more fields. ESQL/C is not allowed in this Web-application. Creating 4 fields requires splitting the string. Does anyone know a solution for the problem? Thanks!
Greetings: I was wondering if anyone had seen this one: Platform: SCO 3.4.2 (not System V) RDS: 4.10 (Yes, I now it's old. I'm trying to upgrade) Engine: Online 7.3 I added a function to a rather large 4GL application and it compiled and linked properly. I think executed it in the debugger (modified, meaning "C" functions) and after a lengthy wait, (perhaps 45 secs), runner returned to the command line with no apparent error messages. Has anybody ever seen this? I'm guessing if it can be fixed that perhaps an O.S. kernel parameter could be treaked. Anybody have a guess? Thanks for any info Ed Schaefer
Christian Weber wrote: > Using Informix Online Dynamic Server 7.24UC3 on HPUX 10.20 i have > the following problem: > > Having a website with an text-area form element, inserting this > input into a database via "insert into..."-SQL-statement (using > a web-database gateway). > > If the string exeeds more than 256 bytes, error -280 occurs in the > users webbrowser:"A quoted string exeeds the allowable limit of 256 > bytes." > > This errror occurs with any kind of Informix data type supporting > char more than 256 length. > > It is a known bug at Informix hotline. Feature, not a bug. It is documented. It has always been that way. It may eventually be altered, but I don't think it is a priority item. I'm not saying that's good, but it is a realistic assessment. > There are three possibilities to insert this value: > > 1. Writing the value in ASCII in file system and inserting this > into the database via "load from ... insert into ..." Yuck. > 2. Creating an ESQL/C program. OK. > 3. Splitting this data fild in 4 or more fields. Yuck. 4. Upgrade your web tool to one which works with Informix databases? Since the tool doesn't pay any attention to the rules of Informix, it is clearly not correctly designed to work with Informix. If it was correctly designed, it would use the normal ESQL/C workaround of providing a host variable and using a place-holder in the INSERT statement. This will work on all SQL platforms. Using long literal strings will not work. Nor, in general, will it work if you try to embed newlines in the string literals. > ESQL/C is not allowed in this Web-application. > Creating 4 fields requires splitting the string. > > Does anyone know a solution for the problem? Try not to tie your hands behind your back before you do things. Upgrade your web software or break the rules about what is allowed. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>
Ed Schaefer wrote: > I was wondering if anyone had seen this one: > > Platform: SCO 3.4.2 (not System V) > RDS: 4.10 (Yes, I now it's old. I'm trying to upgrade) > Engine: Online 7.3 > > I added a function to a rather large 4GL application and it compiled > and linked properly. I think executed it in the debugger (modified, > meaning "C" functions) and after a lengthy wait, (perhaps 45 secs), > runner returned to the command line with no apparent error messages. > > Has anybody ever seen this? > > I'm guessing if it can be fixed that perhaps an O.S. kernel parameter > could be treaked. Anybody have a guess? Maybe. More likely, the program is just too big and the runner is crashing and not reporting that it has done so. Presumably it was once working; what did you change to make it break? Undo that change and check that it resumes working. Depending on what it was, you'll be in a better position to assess what to do about it. Upgrade is a good idea. Are you using a local 7.3 OnLine or some remote machine? And, finally, why does this appear as a sub-thread of the item with the subject line 'Heim architekt'? Oh well, never mind. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>