Adabas syskeys in prepared statements
| From: | Kolja Kleist | 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