使用Visual Studio Online进行发布管理(release management with Visual Studio Online)
使用VS Update 4,我们现在可以在Visual Studio Online中使用Release Management。
使用Release Management服务器:没问题。 使用Visual Studio Online:我无法创建自动部署。
我的进程总是无法使用此日志消息“部署步骤”“字典中没有给定的密钥”。 我的环境本地化在Azure中的不同云服务中。
你知道问题可能来自哪里吗?
With VS Update 4, we can now use Release Management with Visual Studio Online.
With Release Management server : no problem. With Visual Studio Online : I can't manage to create a automated deployment.
My process always fail to "Deploy Step" with this log message "The given key was not present in the dictionary". My environment is localized in different cloud service in Azure.
Do you have an idea of where the problem may come?
原文:https://stackoverflow.com/questions/27619719
更新时间:2022-03-20 20:03
最满意答案
创建2个表:
CREATE TABLE product ( id INT NOT NULL PRIMARY KEY, name VARCHAR() NOT NULL ); CREATE TABLE options ( product_id INT NOT NULL PRIMARY KEY, color VARCHAR(30), size VARCHAR(10), price DECIMAL(10,2) );
在表中获取和插入记录:
$result1 = mysql_fetch_assoc(mysql_query('SELECT * from ProductTemp GROUP BY ProductID', $conn)); $result2 = mysql_fetch_assoc(mysql_query('SELECT * from ProductTemp', $conn)); foreach( $result1 as $v ) { $retval1 = mysql_query("INSERT INTO product VALUES('$v['ProductID']','$v['Product Name']')", $conn); if(!$retval1) { echo 'Could not enter data into table product: ' . mysql_error(); exit; } } foreach( $result2 as $v ) { $retval2 = mysql_query("INSERT INTO options VALUES('$v['ProductID']','$v['Color']','$v['Size']' , $v['Price'])", $conn); if(!$retval2 ) { echo 'Could not enter data into table options: ' . mysql_error(); exit; } }
Creation of the 2 tables:
CREATE TABLE product ( id INT NOT NULL PRIMARY KEY, name VARCHAR() NOT NULL ); CREATE TABLE options ( product_id INT NOT NULL PRIMARY KEY, color VARCHAR(30), size VARCHAR(10), price DECIMAL(10,2) );
Fetching & inserting records in the tables:
$result1 = mysql_fetch_assoc(mysql_query('SELECT * from ProductTemp GROUP BY ProductID', $conn)); $result2 = mysql_fetch_assoc(mysql_query('SELECT * from ProductTemp', $conn)); foreach( $result1 as $v ) { $retval1 = mysql_query("INSERT INTO product VALUES('$v['ProductID']','$v['Product Name']')", $conn); if(!$retval1) { echo 'Could not enter data into table product: ' . mysql_error(); exit; } } foreach( $result2 as $v ) { $retval2 = mysql_query("INSERT INTO options VALUES('$v['ProductID']','$v['Color']','$v['Size']' , $v['Price'])", $conn); if(!$retval2 ) { echo 'Could not enter data into table options: ' . mysql_error(); exit; } }
相关问答
更多-
有什么数据库专业书籍介绍?[2022-05-19]
mysql -
出于安全原因,您应该拥有要从中生成报告的数据库/表的白名单。 查询所有表假定所有将来的表都需要成为此系统的一部分。 您可以使用show columns from tableName查询每个表中的show columns from tableName并迭代结果。 For security reasons you should have a whitelist of databases/tables you want to generate reports from. Querying for all tabl ...
-
SELECT Credit.Amount,User.username FROM Credit INNER JOIN用户ON Credit.username = Users.username 问题是每个表中的用户列不同 credit-> UserID用户:用户名 尝试这个: SELECT Credit.Amount,User.username FROM Credit INNER JOIN用户ON Credit.UserID = Users.username SELECT Credit.Amount, User ...
-
感谢大家,基于你的所有帮助,我可以编写一个PHP类,将表A中的所有列复制到表B中,如果它们不在那里: class MatchTable { var $_table_one_name; var $_table_two_name; var $_table_one_db_user; var $_table_one_db_pass; var $_table_one_db_host; var $_table_one_db_name; var $_table ...
-
php / mysql数据库重新设计和迁移:将数据库更改为表(php/mysql database redesign and migration: changing databases to tables)[2023-08-14]
你为什么认为你需要3个独立的数据库连接和相同的凭据? 在任何mysql查询中,您都可以通过在数据库名称前加上数据库名称(和之间的一个)来引用同一实例上任何数据库的表。 我建议不要使用'database_name'作为属性名称: $databases=get_mysql('SELECT DISTINCT database FROM users.userinfo ORDER BY database'); $count_of_users=count($databases); foreach ($databases ... -
如何使用PHP一次将数据插入两个mysql表[重复](How can I insert data into two mysql tables at once using PHP [duplicate])[2022-03-10]
不,这是不可能的。 Mysql INSERT语法接受一个且只有一个表作为目标 No, it is not possible. Mysql INSERT syntax accepts one and only one table as a target -
将MySQL数据库中两个表的数据与PHP PDO和提取相匹配(Match data from two tables in a MySQL database with PHP PDO and extract)[2023-03-17]
如果关联表具有相同的列名称zipcode且列具有相同的数据类型,请使用NATURAL JOIN 。 SELECT * FROM table_x NATURAL JOIN table_y 或者在zipcode上使用INNER JOIN SELECT * FROM table_x INNER JOIN table_y ON table_x.zipcode=table_y.zipcode Use NATURAL JOIN, if the associated tables have the identical ... -
你需要做的是加入表格。 最常见的JOIN类型: INNER JOIN - 用于匹配与ON()语句匹配的数据。 如果ON()不匹配,则结果将被排除。 LEFT JOIN - 用于在ON()中匹配的数据不必在那里。 它只是将数据追加到原始的FROM中,并且如果没有数据匹配,则使用NULL填充列。 例 SELECT ft.id, ft.file_name, ft.file_description, ft.file_url, af.id as access_id, af.student_id, af. ...
-
mySQL查询从1个数据库PHP上的2个表中检索相关信息(mySQL query to retrieve related information from 2 tables on 1 database PHP)[2022-06-29]
试试这个使用MySQL和PHP将数据分成两个不同的数据库表(Separate data into two different database tables using MySQL and PHP)[2023-12-23]
创建2个表: CREATE TABLE product ( id INT NOT NULL PRIMARY KEY, name VARCHAR() NOT NULL ); CREATE TABLE options ( product_id INT NOT NULL PRIMARY KEY, color VARCHAR(30), size VARCHAR(10), price DECIMAL(10,2) ); 在表中获取和插入记录: $result1 = mysql_ ...相关文章
更多- 《新版 Visual C++全能速查宝典》扫描版[PDF]
- 《用多媒体学Visual C++.NET》
- 《从零开始学Visual C++》扫描版[PDF]
- 《数字图像处理与机器视觉:Visual C++与Matlab实现》扫描版[PDF]
- Nike Free Run Shoes Sale Online Shopping
- 软件项目风险管理(Project Risk Management)
- SharePoint Development Tools
- SharePoint Development Tools
- CLR Via C# 3rd 阅读摘要 -- Chapter 21 – Automatic Memory Management (Garbage Collection)
- 基于C#的UDP协议的同步实现
最新问答
更多- 您如何使用git diff文件,并将其应用于同一存储库的副本的本地分支?(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
- 将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
- OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
- 页面加载后对象是否有资格进行垃圾回收?(Are objects eligible for garbage collection after the page loads?)
- codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
- 在计算机拍照在哪里进入
- 使用cin.get()从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
- No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
- 单页应用程序:页面重新加载(Single Page Application: page reload)
- 在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
- System.StackOverflow错误(System.StackOverflow error)
- KnockoutJS未在嵌套模板上应用beforeRemove和afterAdd(KnockoutJS not applying beforeRemove and afterAdd on nested templates)
- 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
- android - 如何避免使用Samsung RFS文件系统延迟/冻结?(android - how to avoid lag/freezes with Samsung RFS filesystem?)
- TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
- 企业安全培训的各项内容
- 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
- C#类名中允许哪些字符?(What characters are allowed in C# class name?)
- NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
- 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
- 将多个行和可变行移动到列(moving multiple and variable rows to columns)
- 提交表单时忽略基础href,而不使用Javascript(ignore base href when submitting form, without using Javascript)
- 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
- Angular $资源不会改变方法(Angular $resource doesn't change method)
- 在Angular 5中不是一个函数(is not a function in Angular 5)
- 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
- 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
- 常见的python rpc和cli接口(Common python rpc and cli interface)
- Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
- 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)