MS SQL Server

Рассылка закрыта

При закрытии подписчики были переданы в рассылку "Вопросы и ответы по MS SQL Server" на которую и рекомендуем вам подписаться.

Вы можете найти рассылки сходной тематики в Каталоге рассылок.

←   Август 2001   →
		1	2 02.08.2001 18:32:18 19:01:06	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Автор

Сергей

Статистика

17.597 подписчиков
-20 за неделю

• Выпуски
• Статистика

←   Все выпуски   →

MS SQL Server - дело тонкое... (Продолжение)

Служба Рассылок Subscribe.Ru проекта Citycat.Ru

---

---

#058<<  #059 Часть вторая

ПОЛЕЗНОСТИ Программное управление источниками данных ODBC Автор: N/A. Тема нашего сегодняшнего разговора - ODBC. Если вы хоть раз писали СУБД (системы управления базами данных), то вам, наверное, знакома эта аббревиатура. Расшифровывается ODBC как Open DataBase Connectivity (вольный перевод - открытая система связи с базами данных). Open (открытая) в данном случае означает "расширяемая", "легко наращиваемая", "открытая для модификаций". Вы сами это поймете, если посмотрите на архитектуру построения ODBC... [подробнее] Новости проекта SQL.RU Russian SQL User Group: начато обсуждение чернового варианта проекта Устава, с основными положениями которого Вы можете ознакомиться тут: Russian SQL User Group - от слов к делу! RSUG: СТАТЬЯ V - ПРАВЛЕНИЕ ДИРЕКТОРОВ И ЧИНОВНИКИ Новые технические статьи Microsoft Q111723 - BUG: SQL Server SQLSetParam Fails on the 252nd Parameter Driver Removes Entry From WIN.INI Q113146 - BUG: Some API's May Return SQL_ERROR: SQLSTATE S0001 Q119812 - BUG: SQLSRVR.DLL GP Fault on Vines When SQL Server Not Running Q121449 - BUG: SQL Server: Certain Outer Joins Can Cause SQL_ERROR Another Table in FROM May Cause SQL_ERROR Q123657 - BUG: 16-bit ODBC Driver Setup Fails Due to Missing ODBC32.DLL Data Sized Between 64K and 128K Q124899 - BUG: SQLNumResultCols May Fail After Prepared SQL Statement Q135715 - BUG: SQLParamData Returns Incorrect Values Under Win32s Q135989 - BUG: SQLNumResultCols Returns Zero for the pcCol Argument Q137970 - BUG: Precision for a Projected Column Always Reported as 255 Q141811 - BUG: Problems w/ ODBC 32-bit Thunking Installer DLL in Win32s Q149644 - BUG: Out of Range Error When Binding a SQL_C_BINARY Datatype Not Return Unique Index Information Q169468 - BUG: SQL Server ODBC Driver AVs When Inserting from a Remote SP Support WebCast: Implementing ADOX in Jet and SQL Server Applications Q304363 - FIX: Merge Snapshot Does Not Recognize FTP for Jet Subscribers Q304096 - PRB: Trigger Does Not Fire on View When Updated Through ADO Q280458 - BUG: SQL Server May Not Find Existing Appropriate Query Plan Causing Recompilation Q303897 - FIX: Cubes Unavailable During Incremental Update Q100087 - BUG: Print Database Properties from SQL Admin Mixes Results Q304261 - INF: Support for Network Database Files Convert to SYBCHAR > 255 & FMT File Q124314 - BUG: dbconvert Not Consistent w/ Transact SQL CONVERT Function Q128726 - BUG: Mac ODBC App Via TCP/IP May Cause Connections to Hang Q141664 - BUG: Convert From Binary to Numeric Gives Error 8114 Q151593 - BUG: SQL Server's ODBC Function SQLConnect is Not Thread Safe Q153847 - BUG: ODBC Driver Misses ANSItoOEM with Server Cursors Q154891 - BUG: ODBC TDS Error Calling Procedure with SQLTrace. Q161351 - BUG: Bcp_bind Does Not Correctly Convert Real DBFLT4 Q187874 - CnPool.exe Test Connection Pooling with Tempdb Objects Persistence Model Q199872 - PRB: Some Database Tables Are Not Available for OLAP Cubes Procedures Under Source Control in Visual InterDev Q224973 - PRB: OLAP: MSSQLServerOLAPService Should Use Domain Account When Using Integrated Security Q238912 - INF: Understanding Microsoft Repository Q240036 - FIX: Distribution Agent Ignores Error on Pre-Creation Command Q240039 - FIX: DBCC OPENTRAN Does Not Report Replication Information Q240221 - INF: How To Handle Errors in DTS Package and Step Objects Q239583 - INF: DTS Transfer SQL Server Objects Does Not Transfer Table with User-Defined Datatype Q240833 - FIX: Full-Text Search Support for TOP via CONTAINSTABLE and FREETEXTTABLE Clauses Q241249 - INF: How to Obtain a List of DTS Packages Q254123 - FIX: Incorrect Values for Datetime, Smalldatetime, and Money Types With Big-Endian Client Q254759 - BUG: ListAvailableServers Method of the SQLDMO.Application Object Causes Error 0x800A000E Q256178 - BUG: OLAP DTS Task May Display HRESULT Error Codes on Failure Q258990 - INF: How to Trace in SQL Server by Using Extended Stored Procedures Q259571 - PRB: DTS Connection Password Is Write Only Q261133 - FIX: DTS "Send Mail" Fills Up Mailbox and Outlook Cannot See or Delete E-Mail Messages Q260895 - PRB: Error -2147217900 When You Run Distributed Queries in SQL from MTS Q263076 - PRB: SQL Server 2000 Install May Fail Due to 'mfc42u.dll' Q265263 - PRB: Cannot Open a Client-Side Cursor for a SQL Query to OLAP Server Q268020 - PRB: Error Message 15320 Generated When Trying to Expand the Log for a Database on a Shared Device Q268358 - PRB: OLAP Dates May Display Incorrect Format on Japanese Windows NT 4.0 Q268362 - PRB: OLAP Databases Larger Than 150 GB May Result in NT Kernel Out of Memory Errors Q268505 - PRB: Deletion of Rows with the Same Values Behaves Differently in SEM and Query Analyzer Q268591 - PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space Q268877 - INF: Registering SQL Server Wizard Gives a Misleading Error Message Q271509 - INF: How to Monitor SQL Server 2000 Blocking Q270856 - BUG: Processing a SQL Server 7.0 Object From a SQL Server 2000 DTS Task Causes an Error Q271770 - PRB: SELECT in Incremental Update Filter Might Return ODBC Error Message Q271887 - PRB: Desktop Engine Upgrade of MSDE 1.0 Fails Q274199 - INF: Cannot Install MSDE 2000 on Windows 95 Q273495 - PRB: Cluster Count Property May Not Match the Actual Number of Clusters Displayed in the Mining Model Editor Q274390 - PRB: Rebuildm.exe not Available After You Upgrade MSDE Edition to SQL Server 2000 Q273833 - BUG: Restore of a Large Database on Windows 98 May Fail with 3257 Error Message Q273836 - INF: Running OLAP Services on a Domain Controller Q275305 - FIX: Directory Name \MSDE2000\RESOURCES Is More Than Eight Characters, Resulting in Non-ISO CD Q275309 - FIX: Uninstall, Repair, or Modify Fails on Program with Embedded SQL Server 2000 MSDE Merge Modules Q277626 - FIX: Distributed Partitioned View By Using UNION May Not Use Optimal Plan Q278239 - FIX: Extreme Memory Usage When Adding Many Security Roles Q278325 - BUG: OLAP Server Stops Responding When Data Files are Corrupted Q279489 - INF: How to Connect to Analysis Server 2000 By Using HTTP Connection Q279490 - FIX: Analysis Services 2000 Does Not Support Security Account Delegation Q278667 - BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers Q281117 - FIX: Timeout Error Occurs with Large Dimensions in Dimension Editor or Wizard Q281126 - PRB: System Tables Missing Primary Key Information After Upgrade from SQL Server 6.x to SQL Server 7.0 or SQL Server 2000 Q281184 - FIX: SQL Server 2000 Desktop Engine Merge Modules Dependencies Are Incorrect Q280380 - FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures Q282017 - PRB: SQL Server 2000 Help File Contains Confusing Information About the Desktop Engine Setup Q283564 - BUG: Alias Parameters Do Not Work with Oracle Databases Q281983 - PRB: Cannot Specify Instance Name Using SQL Server 2000 Merge Modules Q285103 - BUG: BOL Incorrect on SAPASSWORD and USEDEFAULTSAPWD Options for SQL Server 2000 Desktop Engine Installation Q285097 - INF: How to Change the Default Login Authentication Mode to SQL While Installing SQL Server 2000 Desktop Engine by Using Windows Installer Q285833 - PRB: Need to Map to Default Admin Account and Use NULL for Password In Order to Query Linked Server to Access Database Q287139 - PRB: Cannot Connect to OLAP Database Using OLE DB Provider for ODBC Q288095 - BUG: Query with Large IN Clause Results in Stack Overflow Q288890 - PRB: Incompatible Repository Error Message Occurs After Installation of DSO on Client Computer Q290416 - BUG: Unable to Drill Down to Next Level with Hide Member if Property Set Q289804 - FIX: Dimension Wizard Generates Unusable Custom Rollup Formula with Private Parent-Child Dimension Q289748 - BUG: Missing Values For Database Event Constants Q290562 - FIX: HTTP Connection Resets Session ID of an ASP Session Object Q291265 - FIX: Error Occurs when you Exit Internet Explorer or Excel When You Use a Pivot Table Control with a Visual Basic User Defined Function Q291364 - FIX: Query Performance Slower When Client Locale Differs from Server Locale Q291374 - FIX: Creation of Local Cube with More Than 202 Measures May Fail Q291563 - FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections Q290799 - BUG: Missing Horizontal Scroll Bar in Cube Browser Q292295 - BUG: Unable to Connect to Analysis Services 2000 When OfficeXP is Installed Q293195 - FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query Q293318 - FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update Q293463 - FIX: ASP Error 0115 Occurs When Connecting Through HTTP to Analysis Server on Windows NT 4.0 Q293516 - FIX: Processing of Remote Partition Fails When Dimension and Fact Table Are in Different Data Sources Q293528 - FIX: Drill-Through Fails if Dimension Table Has an Alias in the Cube Q295022 - FIX: Sqlmaint.exe Is Not Available with MSDE 2000 Q294276 - FIX: "Subscript Out of Range" Error Message in Usage Analysis Report Q293609 - FIX: Drill-Through Returns Incorrect Data When Dimension Tables Are Aliased in Dimension Editor Q293612 - FIX: Remote Partitions Require Remote Servers to Run Under OLAP Administrators Account Q294285 - FIX: Processing All Dimensions May Fail with Very Large Dimensions Q293616 - FIX: How to Migrate Repository from Meta Data Format to SQL Server Database Format Q294287 - INF: How to Automate an Archive or Backup of OLAP Database Q293627 - BUG: Failure to Migrate Repository from Meta Data Format to SQL Server 7.0 Format Q293641 - FIX: Error Occurs When You Process Cube or Dimension Through ASP Q294371 - FIX: Cubes and Dimensions Not Visible After Upgrading From OLAP Services 7.0 to Analysis Services 8.0 Q293776 - FIX: Cube Remains in Repository Database After Restore of Archived Database Without Cube Q293782 - BUG: Can Only Administer Analysis Server if User is a Member of Administrators Group Q294535 - FIX: Real-Time Cubes Fail to Process with a Measure Defined as Distinct Count Q294703 - FIX: Incorrect Data in Local Cube Using Custom Rollup with Parent Child Dimension and UNARY Operator Q294734 - FIX: Invalid Data Displays after Refreshing the Definition of a Cube That Contains Virtual Dimensions Q294746 - FIX: Error Occurs When Changes are Made to Dimension Security for Very Large Dimensions Q294664 - FIX: Timeout Error While Browsing Data from Analysis Manager Q294929 - FIX: MSDE Installation Contains the Wrong Icon for the Service Manager Q294968 - FIX: Error Processing Partitions in Parallel Through DTS May Cause Processing to Fail Q296064 - FIX: Analysis Services Cubes Restored From Archive May Show #ERR When Browsed Q295442 - FIX: Processing OLAP 7.0 Objects from Analysis Services DTS Task Fails Q295443 - INF: How To Enable Analysis Server to Use 3 GB of RAM Q295446 - FIX: MSOLAP 8.0 Provider Returns Invalid Property Values for Non-Leaf Members Q294993 - FIX: Combination of Order and CrossJoin Functions in MDX Causes Error Q295463 - FIX: Cube Editor Reports Named Set Name Not Valid but Named Set Displays Correctly Q296147 - FIX: Errors in Application Center Event Viewer About Analysis Services Performance Counter Q296186 - BUG: Incorrect Results In Cube Editor When You Edit a Dependent Calculated Member or Calculated Cell Q295533 - BUG: Opening an Existing DTS Package with OLAP Tasks Causes Error After Analysis Manager Is Installed Q295605 - FIX: Internal Error on Writeback to a Virtual Cube That Has More Dimensions Than the Component Cubes Q295537 - FIX: Unable to Save Changes to Analysis Services Named Sets Q295634 - FIX: Server Fails with Query to Cube with Multiple Partitions and Distinct Count Measure Q295683 - FIX: Virtual Cube Returns #ERR if You Use Dimension Security and Visual Total Together Q295706 - FIX: Virtual Cube Returns Empty Cells if Custom Rule Is Applied Q297205 - FIX: A Remote Cut and Paste of a SQL Server 7.0 Cube or Dimension In Analysis Manager Causes an Error Q295737 - FIX: Analysis Manager Reports Error: Cannot Create Temp Directory Due to Disk Space Problems Q297179 - FIX: OLAP Service Fails to Start After Changing Sort Order to Binary on Japanese Windows Q297232 - FIX: Can't Browse Cubes or Process Mining Model After Installing Analysis Services 2000 RTM Q297248 - FIX: Server Shutdown When Processing a Cube with Private, Virtual, and Shared Dimensions Q296378 - FIX: Query Using NON EMPTY Clause Fails for Measures with a Large Cellset Q296380 - FIX: IS_DRILLTHROUGH_ENABLED in MDSCHEMA_CUBES Resultset Invalid for Copied Objects Q296381 - FIX: Creating a Local Cube with a Large Number of Measures May Cause Error on the Client Q296419 - FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension Q296420 - FIX: Incremental Update of Cube Results in Empty Cube if Partition Was Previously Empty Q297338 - FIX: Division by Zero Produces Zero as a Result for a Calculated Member Q296496 - FIX: Replace of Fact Table Does Not Display Correct Fact Table Name in Cube Editor Q296533 - INF: Analysis Services Processing Task May Not Execute Correctly Q295985 - FIX: Creating a Local Cube from a Linked Cube May Return Error Q296639 - FIX: Analysis Services Fails When All Shared Dimensions Are Processed Q296652 - FIX: Dimension Editor Displays Error Message While Setting Default Member Q296762 - FIX: DSO Allows Cube Role or Data Mining Role to Be Added Without a Corresponding Database Role Q296774 - FIX: DTS Logs Processing Messages Even When Package Logging Is Turned Off Q296901 - FIX: Cube Editor Stops Responding on Save After Adding Private Dimension Q296905 - FIX: Data Mining Provider Stops Responding When Using Row Navigation through OLE DB API Q296915 - FIX: Access Violation When Processing a Database That Was Restored Over Existing Database Q296929 - FIX: Creation of Ad Hoc Data Mining Models Fails with Mining Execution Location=3 Q297728 - FIX: Unhandled Exception Error Querying with the Data Mining Provider from ADO+ and C# Q297799 - PRB: Empty Cells Are Returned by a MDX Query that Uses a Non Empty Clause Q297823 - FIX: Incorrect Data Displays in PivotTable When it is Filtered and AutoCalc is Set to Max or Min Q297933 - FIX: Full Process of a Remote Partition Unprocesses Other Remote Partitions in Same Server Q297889 - FIX: Unable to Count Fact Table Rows When Creating a Cube Q298443 - FIX: Analysis Services Always Uses Visual Totals for Restricted Dimensions Q298600 - FIX: Partition Stops Inheriting FromClause Property from Parent Cube Q298700 - FIX: Syntax Error Occurs When You Use EQUAL_AREAS or THRESHOLDS Keyword for DISCRETIZED Method Q298701 - FIX: Error When Regional Setting Is Different Than Operating System Language Q298679 - FIX: NonEmptyCrossJoin Queries Cannot Run Remotely on the Server Q298711 - FIX: Unable to Browse Data Mining Model that has the Same Name as a Cube Q298485 - FIX: Incremental Update of Cube with Distinct Measure Causes Analysis Server to Shut Down Q298681 - FIX: Drillthrough Query on a Virtual Cube Shows Incorrect Results or Error Q298688 - FIX: "Members With Data" Property Produces Wrong Result with Unary Operators in Parent-Child Dimension Q298689 - FIX: Analysis Manager Cube Browser May Fail While You Browse Cube Data Q298822 - FIX: MSDE Connection May Fail on a Multihomed Computer Q298594 - FIX: Cubes with a Remote Partition and Parent-Child Dimension Display #ERR Q298595 - FIX: Order and Format of Dimension Members Not Maintained After Processing Q299351 - BUG: MSDE Installation Fails on Systems that Have SQL Server 2000 Service Pack 1 Installed Q299383 - FIX: Incorrect Results Returned from MDX Query When Default Member Is Defined by User Q299616 - FIX: Error Training Mining Model That Has Many Input Attributes and Many Rows of Data Q299926 - INF: Writebacks That Use Multi-Hierarchies Must Specify All Hierarchies Q299930 - PRB: Unable to Set SourceTable Property of Partitions to a Different Source Table Q300047 - PRB: Analysis Services Runs Out of Memory While Processing Q301472 - FIX: Assertion Occurs When You Use VT_UI4 Integer for SERVICE_TYPE_ID with the OpenSchema Method Q301627 - FIX: Error Message: "ICE03 Invalid template string" Reported by MSIVal2 Q303343 - SQL Server 2000 User-Defined Functions White Paper Q42745 - INFO: SQL Row Size Limited to 1962 Characters Q80640 - BUG: Convert Defaults to 30 When No Length Is Given Q89384 - INFO: Improving Performance in Views with Aggregate Functions Q121728 - BUG: dbconvert Fails to Convert Strings Other Than "0" or "1" Q161354 - BUG: SQLGetInfo Gives Incorrect Result for SQL_DRIVER_HSTMT Q231951 - INF: Permission Needed for Administering an OLAP Server Q282966 - BUG: DTS Package Fails with Dynamic Properties Task and OLAP Processing Task Q293815 - INF: Dimension Rules for Security Role Not Saved When Programmatically Set Q299905 - INF: Data Types Used by Analysis Services ФОРУМ SQL.RU: САМЫЕ ПОПУЛЯРНЫЕ ТОПИКИ НЕДЕЛИ Russian SQL User Group - от слов к делу! SQL Server user group in Russia - ДВА Репликация данных посредством триггеров? Работа с данными через Интернет SQL-Mail OutLook. Отправка. Помогите построить запрос, плиз! Сравнение с Null Еще раз о Instead, многотабличном view и клиентах Запросик слабенький Как настроить package ? Получение MIN от выражения sp_executesql (exec) и локальный курсор RE:SQL Server user group in Russia - ДВА Отображение дат MSSQL server 7 - помогите Горизонтально секционированных представлений и индексы целостность ФОРУМ SQL.RU: ВОПРОСЫ ОСТАЛИСЬ БЕЗ ОТВЕТА Merge replication и вертикальный фильтр Вопрос от чайника event id 17055 В Enterprise Maneger при открытиии DTS Package пропали все элементы группы Task Репликация транзакций с обновляемыми подписчиками Конвертация DBF-SQL table Помогите составить запрос (типа cross-tab)... Странный глюк Про репликацию, может я чего не понимаю .... MSAccess2000 MSDE - для локальной сети 128кбит/сек - есть ли другой вариант??? OLE DB Session портится? Кто-нить из MultiEdit с SourceSafe 6 работает? Может не в тему, но нужно очень

#058<<  #059

---

Вопросы, предложения, коментарии, замечания, критику и т.п. присылайте Александру на адрес: MSSQLHelp@pisem.net

---

Поиск на SQL.RU Искать:  Результатов на странице: 10 20 50 Формат: Полный Короткий Только ссылки Тип запроса: Все слова Любое из слов Раздел: Весь сайт Документация Рассылка Книги Конференция

МИНИФОРМА ПОДПИСКИ Подписать

---

http://subscribe.ru/ E-mail: ask@subscribe.ru

Отписаться

Рейтингуется SpyLog

---

В избранное

{#template MAIN} <div id="loginForm" style="display:none;" class="subscriberu_popup"> <div class="popup_register"> {#include js_tmpl_auth_reg_tab} {#if $P.login_register_tab == 1} <form class="authentication-form" method="post" action="/MEMBERLOGIN_authen_cred"> <dl class="rg_block_options"> <dt id="js_tap_panel_auth"> <h1>Войти на сайт</h1> {* {#include js_tmpl_auth_reg_button} *} {#include js_tmpl_auth_reg_action} <hr class="logreg_line noPhones"> <div class="logreg_descr noPhones"><p>{#include js_tmpl_auth_reg_descr} </p></div> <div class="logreg_advice noPhones"> Если вы еще не с нами, то начните с <a href="#" onclick="rgNav('js_tab_reg');return false;" class="dashed" data-func="registr">регистрации</a> </div> <br><br> <a class="dashed auth-enter" href="/manage/author/"><b>Вход для авторов</b></a> </dt> </dl> </form> {#/if} {#if $P.login_register_tab == 2} <div class="rg_block_options"> <div id="js_tap_panel_auth"> <h1>Регистрация</h1> <div class="social_reg"> {* <div class="rg_description">{#include js_tmpl_soc_auth_reg_descr}</div> *} {#include js_tmpl_auth_reg_soc} <div class="rg_soc_auth_agree">{#include js_tmpl_auth_reg_agree}</div> </div> <div class="subscribe_reg"> {* <div class="rg_description"> #include js_tmpl_auth_reg_descr </div> *} {#include js_tmpl_auth_reg_action} </div> {* {#include js_tmpl_auth_reg_button} *} <div class="clr"> </div> <hr class="logreg_line noPhones"> <div class="logreg_descr noPhones">{#include js_tmpl_auth_reg_descr} {#include js_tmpl_soc_auth_reg_descr} </div> </div> </div> {#/if} </div> {* <div class="gray_bg register_shadow"></div> *} </div> {#/template MAIN} {#template js_tmpl_auth_reg_tab} <ul class="rg_nav"> <li id="js_tab_auth" class="{#if $P.login_register_tab == 1} rg_active_nav {#/if} rg_first_nav"><a onclick="rgNav('js_tab_auth');return false;" href="">Вход на сайт</a></li> <li id="js_tab_reg" class="{#if $P.login_register_tab == 2} rg_active_nav {#/if}"><a onclick="rgNav('js_tab_reg');return false;" href="">Регистрация </a></li> </ul> <span onclick="hidebo();" class="rg_closed"> </span> {#/template js_tmpl_auth_reg_tab} {#template js_tmpl_auth_reg_action} {#if $P.login_register_tab == 1} {#include js_tmpl_auth_reg_soc} {#/if} <div class="rg_forms"> <input type="hidden" id="login_register_destination" value="{$P.login_register_destination}"/> {#if $P.login_register_tab == 1} <div class="rg_for_input"> <span class="rg_text_inner">E-mail или код подписчика</span> <input id="credential_0" class="js_keydown_selector rg_input_text" data-js_submit="no" data-js_next_input_name="credential_1" name="" type="text" /> </div> <div class="rg_for_input"> <span class="rg_text_inner">Пароль</span> <input id="credential_1" class="js_keydown_selector rg_input_text" data-js_submit="yes" data-js_action="js_loginFormBut" name="" type="password" onkeyup="showAttention(this,!!window.event.shiftKey)" /> <span class="pswd_attention" id="attention_pswd"> <span class="icon_attention"></span> <span class="pswd_attention-text" id="attention-text_pswd1">Русская раскладка клавиатуры!</span> <span class="pswd_attention-text" id="attention-text_pswd2">У вас включен Caps Lock!</span> <span class="pswd_attention-text" id="attention-text_pswd3">У вас включен Caps Lock и русская раскладка клавиатуры!</span> </span> </div> <div class="rg_for_input input-alien"> <span class="chk noPhones"><input id="chk_alien" name="" type="checkbox" /></span><label for="chk_alien" class="noPhones"> Чужой компьютер</label> <a class="forgot_pass" href="/member/totalrecall">Забыли пароль?</a> </div> <div class="rg_for_input"> <em id="auth_msg" class="reg_error"></em> <input id="lf_typeauthid" value="email" type="hidden"> <input type="submit" class="button button-red logreg_submit" id="js_loginFormBut" value="Войти"> <!--</a>--> <div class="loading loading-cover" style="display: none;"><div class="loader"></div></div> </div> {#/if} {#if $P.login_register_tab == 2} <div class="rg_for_input"> <span class="rg_text_inner">E-mail</span> <input id="arfemail" class="js_keydown_selector rg_input_text" name="" type="text" data-js_submit="yes" data-js_action="js_regFormBut"/> </div> <div class="rg_for_input rg_set_lineh rg_for_input_wide"> <label class="js_tap_panel_checkbox"> <span class="chk"><input name="" id='js_tap_panel_checkbox_terms' type="checkbox" data-js_submit="yes" /></span> Я ознакомился и согласен с <a class="link_txd logreg_accLink" href="/faq/vereinbarung.html">условиями сервиса Subscribe.ru</a> </label> <br /> <label class="js_tap_panel_checkbox"> <span class="chk"><input name="" id='js_tap_panel_checkbox_personal' type="checkbox" data-js_submit="yes" /></span> Нажимая на кнопку "Готово!", я даю <a class="link_txd logreg_accLink" href="/faq/persverordnung.html">согласие на обработку персональных данных</a> </label> </div> {* <div style="float: left;position: absolute;left: 11em;"> <img src="http://www.kupivip.ru/images/vip/logo.png?1604" style="width: 86px; vertical-align: middle;display: block;"> </div> <div class="rg_for_input rg_set_lineh"> <label class="js_tap_panel_checkbox"><input name="" id="js_tap_panel_checkbox_kupivip" type="checkbox" data-js_submit="yes"> Я хочу получать новости о скидках на одежду</label> </div> *} <div class="rg_for_input"> <em id="reg_msg" class="reg_error rg_for_input_wide"></em> <em id="reg_msg2" class="reg_error rg_for_input_wide"></em> <input id="rf_typeauthid" value="email" type="hidden"> <a class="button button-red logreg_submit" id="js_regFormBut" href="#">Готово!</a> <div class="loading loading-cover" style="display: none;"><div class="loader"></div></div> </div> {#/if} </div> {#/template js_tmpl_auth_reg_action} {#template js_tmpl_auth_reg_agree} <div class="rg_for_input rg_set_lineh rg_for_input_wide"> <label class="js_tap_panel_checkbox"> <span class="chk"><input name="" id='js_tap_panel_checkbox_terms_reg' type="checkbox" data-js_submit="yes" /></span> Я ознакомился и согласен с <a class="link_txd logreg_accLink" href="/faq/vereinbarung.html">условиями сервиса Subscribe.ru</a></label> <em id="reg_msg_soc" class="reg_error rg_for_input_wide"></em> </div> {#/template js_tmpl_auth_reg_agree} {#template js_tmpl_auth_reg_button} <div class="rg_butons_socials"> {#if $P.login_register_tab == 1} <a class="rg_btn_soc rg_bs_01 js_tap_panel_selector" action="auth_email" href="#"><span><i></i>Email</span></a> <a class="rg_btn_soc rg_bs_01 js_tap_panel_selector" action="auth_openid" href="#"><span><i></i>OpenID</span></a> <a class="rg_btn_soc rg_bs_02 js_tap_panel_selector" action="auth_vkontakte" href="#"><span><i></i>Вконтакте</span></a> <a class="rg_btn_soc rg_bs_02 js_tap_panel_selector" action="auth_mailru" href="#"><span><i></i>Mail.Ru</span></a> {#/if} {#if $P.login_register_tab == 2} <a class="rg_btn_soc rg_bs_01 js_tap_panel_selector" action="reg_email" href="#"><span><i></i>Email</span></a> <a class="rg_btn_soc rg_bs_01 js_tap_panel_selector" action="reg_openid" href="#"><span><i></i>OpenID</span></a> <a class="rg_btn_soc rg_bs_02 js_tap_panel_selector" action="reg_vkontakte" href="#"><span><i></i>Вконтакте</span></a> <a class="rg_btn_soc rg_bs_02 js_tap_panel_selector" action="reg_mailru" href="#"><span><i></i>Mail.Ru</span></a> {#/if} </div> {#/template js_tmpl_auth_reg_button} {#template js_tmpl_auth_reg_descr} {#if $P.login_register_tab == 1} Для оформления подписки на выбранную рассылку, работы с интересующей вас группой или доступа в нужный вам раздел, просим авторизоваться на Subscribe.ru {#/if} {#if $P.login_register_tab == 2} Для регистрации укажите ваш e-mail адрес. Адрес должен быть действующим, на него сразу после регистрации будет отправлено письмо с инструкциями и кодом подтверждения. {#/if} {#/template js_tmpl_auth_reg_descr} {#template js_tmpl_soc_auth_reg_descr} Или зарегистрируйтесь через социальную сеть. {#/template js_tmpl_soc_auth_reg_descr} {#template js_tmpl_auth_reg_soc} <div class="rg_soc"> {#if $P.login_register_tab == 1} <a onclick="return _checkSocConfirm(event)" href="https://oauth.vk.com/authorize?client_id=3954260&scope=wall,offline,photos,groups,video,audio,email&redirect_uri={location.protocol+'//'+location.host}/member/login/vk/&response_type=code&v=5.15" class="login_register_vk_button"> <span class="login_register_vk_icon"></span> </a> {#/if} {#if $P.login_register_tab == 2} <a onclick="return _checkSocConfirm(event)" href="https://oauth.vk.com/authorize?client_id=3954260&scope=wall,offline,photos,groups,video,audio,email&redirect_uri={location.protocol+'//'+location.host}/member/join/vk&response_type=code&v=5.15" class="login_register_vk_button"> <span class="login_register_vk_icon"></span> </a> {#/if} </div> {#/template js_tmpl_auth_reg_soc}

{#template MAIN} <div id="loginForm" style="display:none;" class="subscriberu_popup"> <div class="popup_register"> {#include js_tmpl_auth_reg_tab} <dl class="rg_block_options"> <dt id="js_tap_panel_auth"> <p class="rg_description">{#include js_tmpl_auth_reg_descr}</p> <div class="clr"> </div> {#include js_tmpl_auth_reg_action} <div class="clr"> </div> </dt> </dl> </div> <!-- <div class="gray_bg register_shadow"></div> --> </div> {#/template MAIN} {#template js_tmpl_auth_reg_tab} <ul class="rg_nav"> <li id="js_tab_reg" class="rg_active_nav rg_first_nav"><a href="" onclick="return false;" >Регистрация</a></li> </ul> <span onclick="hidebo();" class="rg_closed"> </span> {#/template js_tmpl_auth_reg_tab} {#template js_tmpl_auth_reg_descr} <strong>Пожалуйста, подтвердите ваш адрес.</strong><br><br>Вам отправлено письмо для подтверждения вашего адреса {$P.register_confirm_mail}.<br>Для подтверждения адреса перейдите по ссылке из этого письма. {#/template js_tmpl_auth_reg_descr} {#template js_tmpl_auth_reg_action} <div class="rg_forms confirm_code_from_letter"> <div class="rg_for_input"> <span class="rg_inp_descr" style="width:15em;">Или введите код из письма:</span> <input type="text" value="" id="confirm_code" name="" data-js_submit="yes" data-js_action="js_confirmFormBut" class="js_keydown_selector rg_input_text_conf" > </div> <div class="rg_for_input"><label>Не пришло письмо? <b>Пожалуйста, проверьте папку Спам</b><br /> (папку для нежелательной почты).</label><br />  <a href="" onclick="ajax_recall_code();return false" >Вышлите мне письмо еще раз!</a></div> <div class="rg_for_input"> <em class="reg_error" id="confirm_msg"></em> <a href="#" class="button button-red" id="js_confirmFormBut">Готово</a> <div class="loading loading-cover" style="display: none;"><div class="loader"></div></div> <br> </div> </div> {#/template js_tmpl_auth_reg_action}