Adabas syskeys in prepared statements

From: Date: Wed, 28 Jun 2000 13:03:39 +0000
Subject: Adabas syskeys in prepared statements
Groups: php.db 
Request: Send a blank email to php-db+get-690@lists.php.net to get a copy of this message
Hallo, I have problems with syskeys from ADABAS-D in prepared statements, maybe someone has a solution for it: The conversion of an Adabas-D syskey in prepared statements don't work since php4.0RC1. The following code discribes the problem: $syskey = "00000000005A59AA"; // hex representation of an char(8)byte syskey $query = "insert into table (id) values ( ?)"; $pre = odbc_prepare($conn, $query); $data[0] = $syskey; $result = odbc_execute($pre, $data); The odbc_execute command will produce the following error: source: [SOFTWARE AG][ODBCLIB A][ADABAS] message: INPUT STRING VARIABLE TOO LONG. String data, right truncated error-code: 743 State: 01004 When I'm inserting a substring of the key ($data[0] = substr($syskey, 8) it works, but it isn't the same key!!! regards, Kolja

« previous php.db (#690) next »