World: r3wp

I think there is missing default value for cookie expiration

hmm.. maybe not

Yeah .. windows

Im still not getting any cookies at all  xp FF2 ie7

Can you login to my server?

url?

http://www.compkarori.co.nz

user: dockimbel
pass: 1234

Graham: no problem here

well, I guess you logged in okay

or someone did :)

So, cookies must be working

yeah

what I meant is cheyenne running on localhost  (winxp) is not setting 
any cookies

tis for  me

may be a browser limitation, experienced same issue here depending 
on browsers, also some do not eat cookies when using ip instead of 
hostname in urls

Aren't servers supposed to send cookies with domains ?

Hmm.

Im guessing that using the ip would work.. haven't tried it yet.

Is there a possibility of using the standard sql dialect for 'do-sql 
?


eg [ {insert into table (one, two, three ) values (?,?,?)} a b c 
]

it should work if your DB driver supports it, DO-SQL is just a higher 
level wrapper.

Graham: cookies specification says that if domain attribut in cookie, 
is not provided, "The default value of domain is the host name of 
the server which generated the cookie response."

Graham: it seems that I've found a bug the session expiration in 
Cheyenne, that might be the cause of your error. It's now fixed. 
I'm testing it a little more before releasing it, I'd like to fix 
the cookies issues of Brian and Terry too (one way or another, these 
issues must be related to the info Cheyenne is sending back in the 
response).

Thanks.

qry: [ {select fnames, surname, uid from users where userid = "?" 
and pass = "?" and activ = 'T'} in-user in-pass ]
			sql: do-sql 'remr qry
gives me this

Error Code :  	329
Description : 	script error !

ODBC error: Dynamic SQL Error SQL error code = -206 Column unknown 
? At line 1, column 59.
Near : 	[insert port data 
copy port
]
Where : 	do-sql

but this works;


   qry: rejoin [ "select fnames, surname, uid from users where userid 
   = '" in-user "' and pass = '" in-pass "' and activ = 'T'" ]
			sql: do-sql 'remr qry

oops  ...

ignore

Seems that I found the guilty for the weird session cookie issues, 
need to dig up a little more to confirm the theory.

I'm seeing this after successful inserts 


{make object! [ code: 329 type: 'script id: 'bad-bad arg1: "ODBC" 
arg2: "Invalid cursor state" arg3: none near: [copy port] where: 
'do-sql ]}

where no recordset is being returned

that's coming from the ODBC driver

Yes.

The insert is occuring okay.

but I get this error

so, is cheyenne querying the database after the query expecting a 
response ?

I can bypass the error by wrapping an attempt around the sql insert

do-sql is doing an INSERT on the database port, then a COPY on the 
port. Does your query only require an INSERT on the port and no COPY 
?

let me check RT's doc about that.

Yes, only an insert

/remote-ip is picking up the router address .. anyway to get the 
actual remote ip address?

must be because the remote-ip appears in the logs

if the client is behind a router and has a local IP NAT-ed by the 
router, no way.

RT's documentation about databases drivers doesn't say what 'insert 
is supposed to return ? Could you tell me that ?

it returns nothing

I never do a copy on a db-port after an insert

you mean after an SQL INSERT or the REBOL 'insert  ?

>> insert p [ {insert into weblog (remoteip) values (?)} "127.0.0.1" 
]
>> copy p
** Script Error: ODBC error: Invalid cursor state
** Near: copy p

ok, I see now.

There's a workaround until I publish the next release (later tonight), 
use : insert databases/remr query

Ok.