wangjincp's recent timeline updates wangjincp's recent timeline updates | wangjincpV2EX member #362557, joined on 2018-11-12 17:01:53 +08:00 |
| OpenWrt 中 使用 Docker 安装可道云出错。 Docker wangjincp Jun 24, 2020 Lastly replied by wangjincp | 1 |
| 关于 recaptcha 怎么监测到频繁访问网页的？ 程序员 wangjincp Oct 11, 2019 Lastly replied by airyland | 1 |
| Discuz3x 我要修改 description 的内容。 PHP wangjincp Sep 23, 2019 Lastly replied by zhensjoke | 2 |
| C# 写的一个 Windows 服务，无法安装，一直报错！ C# wangjincp Oct 15, 2019 Lastly replied by xuanbg | 3 |
| ping 网关、局域网、外网 一般故障。 1 问与答 wangjincp Sep 17, 2019 Lastly replied by wangjincp | 4 |
| 求一个 MSSQL 分组统计 SQL 查询 MySQL wangjincp May 28, 2019 Lastly replied by chitanda | 3 |
| Apache 拒绝垃圾流量，我想跳转到指定页面或者 301 到其他页面怎么做？ 奇思妙想 wangjincp Dec 4, 2018 |
| 用 https 打开京东跳转到 https://www.joybuy.com 4 京东 wangjincp Sep 24, 2019 Lastly replied by yylzcom | 82 |
wangjincp's recent replies
Jun 24, 2020 Replied to a topic by wangjincp Docker OpenWrt 中 使用 Docker 安装可道云出错。 |
我看了一下日志
20#20: *12 connect() failed (111: Connection refused) while connecting to upstream, client: 172.31.0.1, server: localhost, request: \"GET / HTTP/1.1\", upstream: \"fastcgi://172.31.0.2:9000\", host: \"10.0.0.254:8880\"\n","stream":"stderr","time":"2020-06-24T12:00:01.888439939Z"}
20#20: *12 connect() failed (111: Connection refused) while connecting to upstream, client: 172.31.0.1, server: localhost, request: \"GET / HTTP/1.1\", upstream: \"fastcgi://172.31.0.2:9000\", host: \"10.0.0.254:8880\"\n","stream":"stderr","time":"2020-06-24T12:00:01.888439939Z"}
Sep 21, 2019 Replied to a topic by wangjincp PHP Discuz3x 我要修改 description 的内容。 |
没人回答吗？？？
Sep 17, 2019 Replied to a topic by wangjincp 问与答 ping 网关、局域网、外网 一般故障。 |
@flynaj Hyper-v 的问题，我在 windows 功能关闭 Hyper-v 就好了，可能是虚拟网卡的时候有问题。很烦。
Sep 15, 2019 Replied to a topic by wangjincp 问与答 ping 网关、局域网、外网 一般故障。 |
@hcql 家用，在光猫拨号也会出现这情况，ADSL 还断开连接，立马断网。
May 28, 2019 Replied to a topic by wangjincp MySQL 求一个 MSSQL 分组统计 SQL 查询 |
谢谢各位了，已经找到解决方案了！！！
非常感谢各位！！！
SET QUOTED_IDENTIFIER ON
GO
--创建函数
Create FUNCTION [dbo].[GetSubStrBySpint]
(
@String NVARCHAR(300),
@split NVARCHAR(10)
)
RETURNS NVARCHAR(1024)
AS
BEGIN
DECLARE @location INT
DECLARE @start INT
DECLARE @seed INT
SET @String = LTRIM(RTRIM(@String))
SET @start = CHARINDEX(@split, @String)
SET @seed = LEN(@split)
SET @start += @seed
SET @location = LEN(@String) - @start + @seed
RETURN SUBSTRING(@String, @start, @location)
END
我自己写了个函数
然后在查询就好了
谢谢各位！！！
然后直接调用
select * from (select dbo.GetSubStrBySpint([fieldA] , '.') as hz,count(1) as num from Table group by dbo.GetSubStrBySpint([fieldA] , '.')) as c order by c.num desc
非常感谢各位！！！
SET QUOTED_IDENTIFIER ON
GO
--创建函数
Create FUNCTION [dbo].[GetSubStrBySpint]
(
@String NVARCHAR(300),
@split NVARCHAR(10)
)
RETURNS NVARCHAR(1024)
AS
BEGIN
DECLARE @location INT
DECLARE @start INT
DECLARE @seed INT
SET @String = LTRIM(RTRIM(@String))
SET @start = CHARINDEX(@split, @String)
SET @seed = LEN(@split)
SET @start += @seed
SET @location = LEN(@String) - @start + @seed
RETURN SUBSTRING(@String, @start, @location)
END
我自己写了个函数
然后在查询就好了
谢谢各位！！！
然后直接调用
select * from (select dbo.GetSubStrBySpint([fieldA] , '.') as hz,count(1) as num from Table group by dbo.GetSubStrBySpint([fieldA] , '.')) as c order by c.num desc
Nov 25, 2018 Replied to a topic by wangjincp 京东 用 https 打开京东跳转到 https://www.joybuy.com |
@fcymk2 我也是这个。。。我今天发现的。已经举报到 Google。
Nov 14, 2018 Replied to a topic by wangjincp 京东 用 https 打开京东跳转到 https://www.joybuy.com |
@tyhunter 我开始以为是我电脑中毒了，原来大家都一样，现在 https 都能劫持了，真牛 B，有没有大佬出来解释一下？？？
Nov 14, 2018 Replied to a topic by wangjincp 京东 用 https 打开京东跳转到 https://www.joybuy.com |
Nov 14, 2018 |
@charles83 我用 HTTPS 也是这样，我搞不懂为啥。Https 都能劫持？
Select Language