[ Ïîèñê ] - [ Ïîëüçîâàòåëè ] - [ Êàëåíäàðü ]
Ïîëíàÿ Âåðñèÿ: àíàëîã mssql_get_last_message
drouZ
Çäðàâñòâóéòå, ðåøèë ïåðåñåñòü ñ ïðÿìîãî ïîäêëþ÷åíèÿ ê SQL íà ODBC, íî ïîÿâèëàñü çàãâîçäêà: êàêîé àíàëîã ôóíêöèè mssql_get_last_message íà ODBC?

ïðèìåðíî âîò òàêîé êîä:

mssql_query("declare @inv varbinary(1920); set @inv = (SELECT data FROM table1 WHERE ID='".$some_parametr."'); print @inv");

âñå ýòî äåëî äîñòàþ îòòóäà :

$data= substr(mssql_get_last_message(),2);

òàê âîò, êàê ýòî ìîæíî ñäåëàòü ïîñðåäñòâîì ODBC, íî è òàê, ÷òîáû â ñëó÷àå íåîáõîäèìîñòè ÿ ìîã âåðíóòü ïðÿìîå ïîäêëþ÷åíèå ê SQL áåç èçìåíåíèÿ êîäà?




Ñïóñòÿ 1 ÷àñ, 6 ìèíóò, 11 ñåêóíä (14.03.2011 - 12:05) Dezigo íàïèñàë(à):
1. óáåðè @inv ( áåñìûññëåíîå ïðèñâîåíèå)
2. òåáå íå íóæåí (print @inv)
3.íàñòðîé ñíà÷àëî ODBC ñîåäèíåíèå ñ ñåðâåðîì
4.Ïî÷èòàé êàê àíàëîãè÷íî ïîäêëþ÷èòñÿ ñ ïîìîùüþ ODBC
http://php.net/manual/en/function.odbc-connect.php
5.èñïîëüçóé mssql_fetch_array

Ñïóñòÿ 8 ìèíóò, 7 ñåêóíä (14.03.2011 - 12:13) drouZ íàïèñàë(à):
ðå÷ü èäåò î MSSQL SERVER íå î mysql
áåç print inv íå âåðíåò îí ìíå íè÷åãî, óæå ïûòàëñÿ.
êàê ïîäêëþ÷àòü îäáö, ñïàñèáî, óæå çíàþ.

Ñïóñòÿ 33 ìèíóòû, 57 ñåêóíä (14.03.2011 - 12:47) Dezigo íàïèñàë(à):
Èçâåíÿþñü îïå÷àòàëñÿ - èñïîëüçóé mssql_fetch_array.
print âîîáùå íå íóæåí.

Ñïóñòÿ 9 ìèíóò, 59 ñåêóíä (14.03.2011 - 12:57) drouZ íàïèñàë(à):
õîðîøî, ïîïðîáîâàë áåç äåêëàðèðîâàíèÿ ëèøíèõ ïåðåìåííûõ, õîòÿ íà ïðÿìîì êîííåêòå îí íå ïåðèâàðèâàåò ýòî, îñîáåííî íà 2000 SQL, íî, ïîÿâèëàñü âòîðàÿ ïðîáëåìà, âìåñòî õåêñàìè ìåþ ñëåäóùåå
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ

Ñïóñòÿ 1 ÷àñ, 14 ìèíóò, 19 ñåêóíä (14.03.2011 - 14:11) Dezigo íàïèñàë(à):
Êàêîé collation ó áàçû è ñîåäèíåíèÿ?

Ñïóñòÿ 10 ìèíóò, 26 ñåêóíä (14.03.2011 - 14:21) drouZ íàïèñàë(à):
àíãëèöêèé ó ïîäãëþ÷åíèÿ è chienese_prc_ci_as ó ñàìîé áàçû

Ñïóñòÿ 2 ÷àñà, 12 ìèíóò, 20 ñåêóíä (14.03.2011 - 16:34) drouZ íàïèñàë(à):
âîò âåäü ïðîáëåìà-òî: íå ìîãó âûòàùèòü áèíàðíûå äàííûå èç áàçû ÷åðåç ODBC user posted image

Ñïóñòÿ 15 ÷àñîâ, 6 ìèíóò, 14 ñåêóíä (15.03.2011 - 07:40) drouZ íàïèñàë(à):
àï, ðåáÿò, ÷òî, íèêòî íå ñìîæåò ïîìî÷ü?
Áûñòðûé îòâåò:

 Ãðàôè÷åñêèå ñìàéëèêè |  Ïîêàçûâàòü ïîäïèñü
Çäåñü ðàñïîëîæåíà ïîëíàÿ âåðñèÿ ýòîé ñòðàíèöû.
Invision Power Board © 2001-2025 Invision Power Services, Inc.