Hello,
I am having the problem of writing more then 8,141 bytes to my
postgres database on a Raq 4 cobalt box with chiliasp.
Has anyone been able to wrtie more than 8k to the db through 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 as well?
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.
I also tried a symlink from the chiliasp driver to odbc driver that came
with postgres 7.2.3
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.
Any help in resolving this issue is appreciated
the following is the code I am testing this issue with:
<%
'strConnect = "dsn=testdb"
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
[EMAIL PROTECTED]
http://list.cobalt.com/mailman/listinfo/cobalt-developers
