Hi
I found an interesting thing.. But it will just make my work much harder..
comparing to ASP... :o(((( (which I already am not able to use in the
project we should deliver to our customer in a few weeks.... :o((((
<?php
// database settings
$dsn = "dsn_database";
$user = "enduser";
$pass = "";
$query = "EXEC usp_get_subj 10";
/*
$query = "SELECT col_subj_id,
col_cat_id,
col_lang_id,
col_subj_class,
col_subj_owner_id,
col_subj_secur,
col_subj_last_update,
col_subj_title, --varchar(512)
col_subj_reg_page, --varchar(128)
col_subj_content, -- text(16)
col_subj_keywords --varchar(256)
FROM tbl_subject WHERE col_subj_id = 10";
*/
$conn = odbc_connect($dsn, $user, $pass);
$res = odbc_exec($conn, $query);
$data = odbc_result($res, "col_subj_content");
$data = odbc_result($res, 8);
echo $data;
odbc_close($conn);
?>
This code will not retrieve the data from col_subj_content.. But!!
If I replace the call of the stored procedure by the same its content but as
an obviouse SQL query, everything will work and I will get the content of
this field.. Hmm... So, what is the hell is that??? Could anyone HELP me to
use the calls of sp way in the right way?!?
<?php
// database settings
$dsn = "dsn_database";
$user = "enduser";
$pass = "";
$query = "SELECT col_subj_id,
col_cat_id,
col_lang_id,
col_subj_class,
col_subj_owner_id,
col_subj_secur,
col_subj_last_update,
col_subj_title, --varchar(512)
col_subj_reg_page, --varchar(128)
col_subj_content, -- text(16)
col_subj_keywords --varchar(2560
FROM tbl_subject WHERE col_subj_id = 10";
$conn = odbc_connect($dsn, $user, $pass);
$res = odbc_exec($conn, $query);
$data = odbc_result($res, "col_subj_content");
$data = odbc_result($res, 8);
echo $data;
odbc_close($conn);
?>
The stored procedure is:
Create Procedure usp_get_subj
(
@subj_id int
)
As
SELECT col_subj_id,
col_cat_id,
col_lang_id,
col_subj_class,
col_subj_owner_id,
col_subj_secur,
col_subj_last_update,
col_subj_title, --varchar(512)
col_subj_reg_page, --varchar(128)
col_subj_content, -- text(16)
col_subj_keywords --varchar(2560
FROM tbl_subject WHERE col_subj_id = @subj_id
RETURN
Michael Yevdokimov
Web developer
e-mail: [EMAIL PROTECTED]
--------------------------------
Globalocity B.V.
Tel.: +31 (0)70 312 2814
Fax.: +31 (0)70 312 2808
http://www.globalocity.com
e-mail: [EMAIL PROTECTED]
--------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
