Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

v6.3.12版本pageSqlContents查询不出数据来 #1198

Open
linrb opened this issue Aug 15, 2018 · 2 comments
Open

v6.3.12版本pageSqlContents查询不出数据来 #1198

linrb opened this issue Aug 15, 2018 · 2 comments
Labels
BUG

Comments

@linrb
Copy link

@linrb linrb commented Aug 15, 2018

<stl:pageSqlContents connectionStringName="ConnectionString" cellpadding="2">
stl:queryString
select * FROM model_Content where siteId=1 ORDER BY AddDate DESC
</stl:queryString>

                <stl:sqlContent type="Title" wordnum="20"></stl:sqlContent>
           
            (<stl:sqlContent type="AddDate" formatString="yyyy-MM-dd"></stl:sqlContent>)
            <br>
        </stl:pageSqlContents>

生成页面后,没有任何数据,用sqlContents可以查询有数据,sqlContents不能分页。

@starlying

This comment has been minimized.

Copy link
Contributor

@starlying starlying commented Aug 16, 2018

问题已修复,升级到6.5.4-beta即可。

@starlying starlying added the BUG label Aug 16, 2018
@starlying starlying mentioned this issue Aug 16, 2018
30 of 30 tasks complete
@zx122248006

This comment has been minimized.

Copy link

@zx122248006 zx122248006 commented Aug 17, 2018

<stl:sqlContents isDynamic="true">
stl:queryString
SELECT SUM([Hits]) AS TotalHits FROM [cms6.5.1].[dbo].[model_Content] WHERE [ChannelId] = '{channel.ChannelId}'
</stl:queryString>
{Sql.TotalHits}
</stl:sqlContents>

我用6.5.1 这个样子写sql就能够查询到,不知道是不是BUG。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
3 participants
You can’t perform that action at this time.