Re: [cobalt-developers] UNSUBSCRIBE

["Phil L. Huff" <philhuff@xxxxxxxxxxxxxx>]

dumbass
--- "Supachai Sukhanindr,Ph.D." <sidney@xxxxxxxxxxx> wrote:
> 
> 
> -----Original Message-----
> From: cobalt-developers-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Michael
> Aldor
> Sent: Saturday, December 28, 2002 2:53 AM
> To: cobalt-developers@xxxxxxxxxxxxxxx
> Subject: [cobalt-developers] postgres, cobalt and chiliasp 8k
> read/write limit
> 
> 
> 
> The following is are some issues I am having with writing and reading
> from a postgres 7.2.3 db using ChiliAsp on a Cobalt Raq 4: 
> I would appreciate any help you can provide.
> Hello I need further guidance on resolving this 8k limit.
> I created a java class to update the db in cases where the text is
> over
> 8k, I am now running into a 9k read limit on data coming from the
> postgres 7.2.3 database while using chili ASP. Also if I call my java
> class though chili asp I get an error saying my SQL statement is too
> long. If I call my java class though my java interface then the
> database
> update is ok (I can successfully update more then 8k). 
> This database field limit is quite frustrating. I have tried changing
> odbc driver references with no luck. I am also curious as to where
> the
> chilisoft jre has referenced the postgres database as it is not
> referencing the correct jdbc driver. I put a Jar reference to the
> lastest JDBC in javasetup.sh but it seems to not be referencing that
> driver. When I took the jdbc jar classpath reference out of the
> javasetup.sh file classpath, my code did not crash but continued with
> the too long sql statement error every time I try to update over 8k.
> This is quite concerning as when I took out the JDBC reference my
> code
> should crash as I would not be referencing any JDBC driver JAR file.
> I have concluded that this is not a database issue as I can
> read/write
> more then 8 k using tomcat. This seems to be an issue with chiliASP
> or a
> ChiliAsp Cobalt thing, and I would appreciate any help on where this
> 8k
> limit has been configured in the Chiliasp system.
> Thank you for your help.
> Regards,
> Michael Aldor
> -----Original Message-----
> Sent: December 9, 2002 6:29 PM
> Subject: RE: Help - Does Chilisoft have an 8k text field limit with
> postgres db? (Tracking #11784)
> 
> We tried the symlink, pointing to the newest odbc driver from
> postgresql, but the problem still persists. Is there anything else we
> can try?
> 
> -----Original Message-----
> Sent: December 6, 2002 3:17 AM
> To: Michael Aldor
> Subject: RE: Help - Does Chilisoft have an 8k text field limit with
> postgres db? (Tracking #11784)
> 
> Michael,
> This is actually a bug is the open source code that we compiled the
> Postgres driver from. You can try compiling a new Postgres driver
> from
> an updated
> version of the source. Keep in mind this isn't officially supported,
> but
> it
> may help resolve your bug. Here's what to do.
> 1. Compile the new driver.
> 2. Save it on your RaQ4.
> 3. Go to /home/chiliasp/odbc/opensource/lib/
> 4. Change the symlink for libodbcpsql.so so that it points to your
> new
> driver.
> -Prashant
> ChiliSoft Product Support
> 
> > Hello,
> > 
> I am having a problem with writing more then 8,141 bytes to my
> postgres
> > database on a Raq 4 cobalt box with chiliasp. 
> > 
> > Is there a limit somewhere in the chili asp config files that I can
> > change to get over this hurdle?
> > 
> > Or do I have to configure chiliasp to reference the most recent
> postgres
> > driver?
> > 
> > If so, how do I modify chiliasp to reference a new driver?
> > I tried doing this throught the system dsn interface but I cannot
> get
> > this to work with postgres.
> > 
> > The following is the error I get when I to submit more then 8 k:
> > 
> > error '80004005' 
> > 
> > 
> > .........../testTextfield.asp, line 24 
> > 
> > 
> > At first I thought it was the postgres database version, so I
> > successfully installed a second instance of postgres (version
> 7.2.3).
> I
> > can now successfully write more than 8k to the db through the psql
> > command interface. I also have linked pgadmin II to the db and
> again
> can
> > write more than 8k though a tcp/ip connection.
> > 
> > However I still cannot write over 8k to the db throuh my chili asp
> code.
> > I have tried switching drivers (through the system DSN interface)
> > but I cannot seem to use the system DSN to get a successfull
> connection.
> > Instead I am using DSN-less connection, but am stuck with whatever
> > driver chiliasp is looking at.
> > 
> > The following is the error I get when I try to use the System DSN 
> > with the one that came with the postgres install (libpsqlodbc.so):
> > 
> > ADODB.Connection.1 error '80020009' 
> > 
> > Could not open connection using Connection string dsn=testdb; 
> > 
> > ...../textfieldTest.asp, line 5 
> > 
> > I would like to change the driver chiliasp is trying to use, but am
> not
> > sure where to start.
> > 
> > Any help in resolving this issue is appreciated
> > 
> > the following is the code I am testing this issue with:
> > <%
> > strConnect =
> >
>
"Driver={PostgreSQL};Server=localhost;Port=9999;Database=testdb;UID=x;PW
> > D=x"
> > set conn = server.createObject("ADODB.connection")
> > conn.open strConnect
> > 
> > function addrNull(strField)
> > if strField = "" then
> > addrNull = "null"
> > else
> > addrNull = "'" & strField & "'"
> > end if
> > end function
> > function quoteFixer(strField)
> > if InStr(strField, "'") > 0 then
> > quoteFixer = Replace(strField, "'", "''") 
> > else
> > quoteFixer = strField
> > end if
> > end function
> > 
> > if request.form("state") = "update" then
> > sqlStr = "update text_test set text_field='" &
> > quoteFixer(request.form("content")) & "' where test_id = 1"
> > conn.execute(sqlStr)
> > response.write("<p align=center>Your site has been updated!</p>")
> > conn.CommitTrans
> > end if 
> > set rsTest = conn.Execute("SELECT * FROM text_test where
> test_id=1")
> > %>
> > <html>
> > <body>
> > My Postgres Test
> > <form action="textfieldTest.asp" name="test" method="post">
> > <textarea name="content" rows=10
> > cols=80><%=rsTest("text_field")%></textarea>
> > <input type="hidden" name="myid" value="<%=rsTest("test_id")%>">
> > <input type="hidden" name="state" value="update">
> > <br>
> > <input type="submit" value="go">
> > </form>
> > </body>
> > </html>
> > 
> > 
> > 
> > Regards,
> > Michael Aldor
> 
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
> 
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
=== message truncated ===


=====
Phil Huff * Diversified Financial Group
philhuff@xxxxxxxxxxxxxx * 843-884-9851 
A Product Everyone Needs! 
With an UNPARALLELED Business Opportunity!
visit http://ppl.philhuff.net for more! 
Page me online  http://wwp.mirabilis.com/9507752 

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com