再开一贴，关于SPSS

dotnba 2003-01-19 04:25:40

RelativeLink:
http://expert.csdn.net/Expert/topic/1352/1352718.xml?temp=.261593
原贴已结
现在还有问题：
1、时间问题
StrSql = StrSql & " AND (CAST(""DAV:getlastmodified"" AS datetime) >= GETGMTDATE()) "
StrSql = StrSql & " AND (CAST(""DAV:getlastmodified"" AS datetime) <= GETGMTDATE()) "
居然都没结果，实际应该有记录
2、RS的分页问题
方式1：
Conn.ConnectionString = "provider=msdaipp.dso"
Conn.CommandTimeout = 0
Conn.Open "http://" & ServerName &"/" & WorkSpace
cmd.CommandText = StrSql
Rs.Open Cmd
方式2：
Set rSPPS = Server.CreateObject("ADODB.Record")
Set rsSPPS = Server.CreateObject("ADODB.Recordset")
sSPPSPath = "Sharepoint Portal Server/Applications"
sSPPSURL = "http://<SPPS FQDN goes here>/" & sSPPSPath
rSPPS.Open sSPPSURL
rsSPPS.Open sQuery, rSPPS.ActiveConnection，1
均无法分页，具体表现为Rs.RecordCount是-1，即错误
3、PDF全文检索
用FreeText无法检索，服务器已经安装了IFilter。但是还是检索不到。OFFICE文档没问题...

欢迎大家参与，高分回报... ...

...全文

128 18 打赏收藏转发到动态举报

写回复

用AI写文章

18 条回复

切换为时间正序

请发表友善的回复…

发表回复

NewSun99 2003-01-20

打赏
举报

select "DAV:href","DAV:iscollection","DAV:creationdate"
from scope('DEEP TRAVERSAL OF "/Demo/Documents"')
where ("DAV:creationdate" > CAST("2002-05-05T01:01:01Z" as 'dateTime'))

NewSun99 2003-01-20

打赏
举报

Examples
WHERE CAST("custom:mydateprop" AS "dateTime") > "1998-02-01T10:00"
WHERE "custom:count" > CAST("0" AS "int")
WHERE "custom:creationdate" = CAST("1999-10-22T22:12:40.296Z" as "dateTime.tz")

th820901 2003-01-20

打赏
举报

收藏先..

dotnba 2003-01-20

打赏
举报

TO Haiwer(海阔天空) AND AnyOneElse：
这个问题与PB无关，没有这个版。放这里而已。另，上面的SQL和SQL SERVER里象，但不要认为就是SQL SERVER里的语句。

The SharePoint Portal Server search language is based on SQL; however, it does not search in a relational database with user-defined tables, or indexes. Because of this, many standard SQL statements and syntax features do not apply. The following is a list of the more significant SQL features that are unavailable in SharePoint Portal Server:

CONVERT() (use the CAST functions instead)
CREATE VIEW statement
Data definition language
DATASOURCE statement
Date and Time formats other than ISO date and timestamp
Derived columns using AVG(), COUNT(), MAX(), MIN(), SUM(), or other calculations
GRANT statement
Hierarchical rowsets
Information schema
INSERT statement
OLE DB data types
SQL-standard regular expressions (use CONTAINS, LIKE, and MATCHES)
Parameters to SQL queries
Relational column comparison
Revision ID header
REVOKE statement
SCOPE aliases or revision numbers
SELECT ALL (removes duplicates automatically)
SET statement
Stored procedures
Structured document expansion
UNKNOWN keyword
UPDATE statement
BATCH statements

昵称被占用了 2003-01-20

打赏
举报

GETGMTDATE是pb的函数？不好意思，pb我一点都不懂，如果GETGMTDATE是pb的函数，那楼主的写法就不对了，因为sql server不认识GETGMTDATE。
改成:
StrSql = StrSql & " AND (CAST(""DAV:getlastmodified"" AS datetime) >= GETDATE()) "
or
StrSql = StrSql & " AND (CAST(""DAV:getlastmodified"" AS datetime) >= '" & GETGMTDATE() & "') "

dotnba 2003-01-20

打赏
举报

The GETGMTDATE function returns the current date and time in Greenwich Mean Time.

The DATEADD function performs time and date calculations for matching properties having date types.

DATEADD (DateTimeUnits, OffsetValue, DateTime)

昵称被占用了 2003-01-20

打赏
举报

response.write StrSql输出的结果贴出看看。

GETGMTDATE()？？
GETDATE()！

pbcoder 2003-01-19

打赏
举报

asp?

bomber2001 2003-01-19

打赏
举报

pengdali 2003-01-19

打赏
举报

我没有msn不好意思！
继续关注！

Chiff 2003-01-19

打赏
举报

不懂，不好乱说。

dotnba 2003-01-19

打赏
举报

TO：OpenVMS(半知半解)
SPPS 需要信任连接，要在SERVER属性里设置
好象在Conn.ConnectionString = "provider=msdaipp.dso"没有设置UID或者PWD，Portal会模拟访问ASP页面的用户权限。也就是同一个ASP可能结果不一样。
TO：cmsoft(韦小宝是我的老乡)
1、我已经输出，在ASP中没有语法错误，只是结果不正确。怎么在查询分析器里看？在.Net里用OLEDB连接，但是写出SQL提示不正确（不是针对这个SQL语句，而是别的，即使在ASP中执行正确）
2、对于一般的RS分页，用rs.open StrSql,Conn,1没有问题
对于在SPSS中，用rs.open StrSql,Conn,1,1 导致语法错误。我想用属性本身基本是只读的。
3、在Portal中搜索PDF没有问题。我没看他的Web_Part的XML语句，因为我不懂XML。

欢迎大家继续关注...