由买买提看人间百态

topics

全部话题 - 话题: recordsets
首页 上页 1 2 (共2页)
k****h
发帖数: 27
1
来自主题: Database版 - problem with IIS->access
I am using IIS 5.0 on windows 2000 to connect with access database.
It works if use the following code in the asp file
<% con= "Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=g:\pvd.mdb">
<% set dbMain = server.createobject("ADODB.Connection")
dbMain.open con
Set rsProducts = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM products WHERE beginspecial <= #" & date() & _
"#" & " AND endspecial >= #" & date() & "#"
rsProducts.open sSQL, dbMain, adopenstatic, adlockpessimistic
j**i
发帖数: 419
2
来自主题: Database版 - 纪录查找问题
looks like ado,dao can do it in a recordset.
MySQL,don't know.【 在 bee (只会嗡嗡叫的蜜蜂) 的大作中提到: 】
B*******n
发帖数: 58
3
来自主题: Database版 - [转载] ASP古怪问题
【 以下文字转载自 BuildingWeb 讨论区 】
【 原文由 BoyzToMen 所发表 】
平台:IIS/WinXP/ASP/Access
问题:注册登陆根据用户行为更新数据库表a后,再用一个asp页面x查询a时,
有些用户返回正常,有些像是进入了死循环,一直无法返回。
屏蔽掉x中循环输出语句,结果还是无法返回。
怀疑问题是connection/recordset没有正常关闭。
重新改写全部asp,增加关闭conn/rec语句,结果一样。
很是古怪,关键是有些用户正常,有些用户不正常。
当前数据库中330用户左右,目前发现332、333工作不正常,
而331、334工作却正常。
谁遇到过这种情况?或是知道那里能查到相关信息?先谢了。
c**t
发帖数: 2744
4
来自主题: Database版 - 问一个简单的Query
Table:
Cat Acct num
1 abc x
2 abc y
1 def z
2 deg x

I want to get recordset like:
Acct Cat1 Cat2 num
abc x y x+y
def z 0 z
deg 0 x x
Thx
p**i
发帖数: 688
5
来自主题: Database版 - Help needed: MS Access 2000
Do you use addnew/update method with ADO recordset to add a record?
here ASP+access works fine for me, but it isn't serving lots of users.
c**t
发帖数: 2744
6
来自主题: Database版 - ADO Bug Report
I use ADO 2.0 library in VB to get data from MSAccess, and find a bug:
if the recordset has a memo field in the middle, the rest fields will be
ignored. (There are newline in the memo field).
Does anybody else have the similar issue? If I put the memo field at the
end of select statement, the problem will go away. But if having two memo
fields, I don't have idea to retreive data. :-(
And how to update memo field with update statement? I can't think out a way
to escape newline, sigal quote, ..
l**u
发帖数: 67
7
来自主题: Database版 - Need help on VBA! Please!
Access expert help!!
Support I am going to fill in a Form, there is a number(PhoneNumber) that I
would like to check if the record of this number exists in my link table? If
so, just go ahead to append to A table, if not, then just pop-up a message and
append to B Table. The following is my code:
Private Sub WTN_AfterUpdate()
Dim rsp
Dim Cur_DB As DAO.Database, WTN As DAO.Recordset
Set Cur_DB = CurrentDb
Set WTN = Cur_DB.OpenRecordset("Select * from LinkTable where = ;")
If WTN.RecordCount <>
n*********g
发帖数: 75
8
来自主题: Database版 - sql question
there are records in Database such as
1 A
2 A
2 B
3 C
4 B
I want to return a recordset that combine the value of
the second column if the value of the first column is the same,
like below
1 A
2 AB
3 C
4 B
how to implement it using sql statement?
b******y
发帖数: 139
9
来自主题: Database版 - Help on Oracle Query
I have a recordset ordered by CusipCol, IDCol like this:
CusipCol IDCol ValueCol
1C 1 A
2C 2 B
3C 1 A
3C 1 Null
4C 1 A
4C 2 Null
5C 1 A
5C 2 B
6C 1 Null
6C 2 B
7C 1 Null
7C 2 Null
I need write a oracle query to get the fol
m*******n
发帖数: 370
10
来自主题: Database版 - rsArray 为啥写不全? (转载)
请高人帮我看看,同样的一段code,如果database连Access, rsArray里可以正常写入所有的
fields,但是如果连SQL server就只能写入NomID和Categories.Description,其他都为
空.我把strQ对应的select语句放到SQl server里去run,结果也是对的,每个field都显示
了,但为什么没有能够被读到里rsArray呢? rsArray = objRS.GetRows()为什么没能读
全?
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS.ActiveConnection = Connection
strQ = "SELECT NominationDetailsCurrent.NomID, Title, OrderNo, Letter,
CategoryName, Categories.Description, Categories.Weight " & _
"FROM (NominationDetailsCurrent LEFT JO... 阅读全帖
m*******n
发帖数: 370
11
来自主题: Database版 - rsArray 为啥写不全? (转载)
我把"If Not objRS.EOF Then" comment out了,发现是data type的问题:
The strQ is: False
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
所以应该改database里的data type吗? 之前在access里用的是text/memo,现在MS SQL用的
是nvarchar(255)/nvarchar(max).不觉得有什么问题啊?
B*****g
发帖数: 34098
12
看一看zenny前面的贴子,先生成hash,hash不一样的肯定不同,hash一样的再double
check一下。

spot
,
..
的?
u***t
发帖数: 3986
g***l
发帖数: 18555
14
一个RECORD变四个8个TABLE,做DW的?首先你这ARCHITECTURE不能有漏洞吧,什么数据
被清理被剔除,MATCH不上的怎么办,应该设计DW的时候就考虑了,LOAD完之后就是QA
和BA的工作了,每种情形都要考虑到,多个CASE测试。老印做的东西要很小心,我这招
DBA,来个几个老印,号称是SENIOR,结果比JUNIOR考的都差。如果我猜的不错,你这
是SQL SERVER转到已经建好的DB2里,不是ETL DW,原则上我觉得应该先把数据原封不
动LOAD到DB2里,看有什么问题,否则中间丢了东西根本就没地找去。
u***t
发帖数: 3986
15
嗯, 确实只如此.
我的小组负责自动化测试
DB2接着Websphere Commerce, 确实是fixed的数据库, 老印做得, 我本人看里面的
frandulent的设计所以migrate好以后, 我在target里所有的数据都要看

QA
y****w
发帖数: 3747
16
问问看能不能找个db2 federation的测试版或类似的东东,把sql server那边的表
catalog过来,然后用sql比。
u***t
发帖数: 3986
17
我的core也是by SQL
w*r
发帖数: 2421
18
正解,先把data 分块(by geo indicator or time indicator),做hash sum, 这样找
出问题的时候再细分

double
y****w
发帖数: 3747
19
退回原点。 这个问题有必要搞这么复杂么?还是说有些什么因为权限之类的不能做?
把那个src的集合想办法弄到db2那边去,只是几个M的数量级,硬件不太差sql不太弱加
上合适的索引难道还不够?看lz发帖子说到out of memory,难道说的是jvm oom? 在
java里面做这计算么?
B*****g
发帖数: 34098
20
把数据拷过去没有技术含量呀
u***t
发帖数: 3986
21
Anything better than below? thanks.
1) ...Select... OVER...
2) using Cursor object
3Q
j*****n
发帖数: 1781
22
3) SSIS "FOR EACH LOOP" container
w*r
发帖数: 2421
23
来自主题: Database版 - Re: Recordset - I stuck! Help!
do not use that, page the record set with that many record will eat
a lot of memory in VB engine.
You should consider this:
use loop with counter to write data directly to CSV file
when counter goes up to 500K, close csv file and reopen another one
with file handler, reset counter to zero, keep writing.
with single record operation for the loop, it will be slower, however, you
can further optimize it by having a smller page size to optimize the data
fetch side oepration (handled by ado.net autom... 阅读全帖
g***l
发帖数: 18555
24
来自主题: Database版 - Re: Recordset - I stuck! Help!
EXCEL不是用来存储数据的,那么多记录,所以才用数据库啊,EXCEL管用,人家数据库
不都倒闭了。
i****a
发帖数: 36252
25
来自主题: Database版 - Re: Recordset - I stuck! Help!
question is, why do you want to have 100 excel files with 500k records each?
g***l
发帖数: 18555
26
来自主题: Database版 - Re: Recordset - I stuck! Help!
因为EXCEL有个65535的RECORD限制

each?
i****a
发帖数: 36252
27
来自主题: Database版 - Re: Recordset - I stuck! Help!
Excel 2010 limit is higher.
but my question is what LZ wants to do with records in excel. there maybe
a better way than 100 excel files
and since LZ asked in DB board, I assume the data is from a database. if
LZ has a real need to have 100 excel files, exporting directly from
database is more efficient.
g***l
发帖数: 18555
28
来自主题: Database版 - Re: Recordset - I stuck! Help!
输出到CSV或者ACCESS不就得了,问题是那么大你怎么QUERY啊,找什么数据,他们自己
都不知道吧,EXCEL去拔份几百万的数据,有点可笑
u***t
发帖数: 3986
29
来自主题: Database版 - Re: Recordset - I stuck! Help!
500,000 is the optimal maxrownum that an excel can hold. Get 500k from
source, then get 500k from target, then use a query to compare them, write
mismatch to a third excel file, takes 10 minutes.
With loop on the source, whole day.

each?
g***l
发帖数: 18555
30
来自主题: Database版 - Re: Recordset - I stuck! Help!
这种要让专业人士笑死的。
u***t
发帖数: 3986
31
来自主题: Database版 - Re: Recordset - I stuck! Help!
I have yet to see a solution from you, pro!
w*r
发帖数: 2421
32
来自主题: Database版 - Re: Recordset - I stuck! Help!
totall confused... sorce target are in different DB instance??? then you
should consider load them into same db instance and use DB engine to do such
comparison
u***t
发帖数: 3986
33
来自主题: Database版 - Re: Recordset - I stuck! Help!
Use the same Queries from offsource developers to clone a 2nd DB schema for
testing purpose, does that work?!

such
g***l
发帖数: 18555
34
来自主题: Database版 - Re: Recordset - I stuck! Help!
弄个BACKUP ZIP一下,下载下来RESTORE一个不就完了,还EXCEL,还要IMPORT多个文件,最后这里出错那里出错的,笑死。

for
u***t
发帖数: 3986
35
来自主题: Database版 - Re: Recordset - I stuck! Help!
Dev's query is based on business rule.
Testing's query is also based on business rule.
my point is using Dev's queries doesn't serve the purpose of data validation.

件,最后这里出错那里出错的,笑死。
B*****g
发帖数: 34098
36
来自主题: Database版 - Re: Recordset - I stuck! Help!
能写中文吗?

validation.
g***l
发帖数: 18555
37
来自主题: Database版 - Re: Recordset - I stuck! Help!
什么不是BASED ON BUSINESS RULE啊,现在是说数据,大数据量传输怎么能用EXCEL呢
?EXCEL不是数据库,多个文件就是自找麻烦

validation.
u***t
发帖数: 3986
38
来自主题: Database版 - query questions
from a recordset, how to fetch records from row 1000 to row 2000?
Thanks.
c*******e
发帖数: 8624
39
来自主题: Database版 - query questions
你这个recordset是table吗? table本身是无序的
n********6
发帖数: 1511
40
Because I need to generate report on web, and look for opportunities to generate one recordset by one query.
g***l
发帖数: 18555
41
不会做两个QUERY JOIN在一起啊,记得用LEFT JOIN,MONTH的在左边

generate one recordset by one query.
i****a
发帖数: 36252
42
来自主题: Database版 - ###此帖已应当事人要求删除###
did you open the recordset?
s**********o
发帖数: 14359
43
来自主题: Database版 - ###此帖已应当事人要求删除###
STORED PROCEDURE返回的是个TABLE吧,要放到RECORDSET里的,
你要先定义好,CALL完要打开
b****i
发帖数: 619
44
【 以下文字转载自 Programming 讨论区 】
发信人: bingmi (寂寞高手), 信区: Programming
标 题: 请教:如何在VB程序中显示原封不动的excel worksheet
发信站: BBS 未名空间站 (Mon Mar 13 19:54:27 2006)
目前是用recordset读的,显示搞掂了。但有个问题是,有没有办法在显示的基础上同时
保留原来worksheet的一些格式?譬如color-coded的cells,还有背景颜色、框架、字体
这些格式信息。有没有办法能够原封不动地把worksheet(搬过来)显示在VB程序当中?
现在很笨的办法是在VB当中自己按照原来excel worksheet的格式算位置,然后上色,感
觉有可能绕路了。想请教一下有没有简便的办法。
/bow
m*******n
发帖数: 370
45
来自主题: DotNet版 - rsArray 为啥写不全?
请高人帮我看看,同样的一段code,如果database连Access, rsArray里可以正常写入所有的
fields,但是如果连SQL server就只能写入NomID和Categories.Description,其他都为
空.我把strQ对应的select语句放到SQl server里去run,结果也是对的,每个field都显示
了,但为什么没有能够被读到里rsArray呢? rsArray = objRS.GetRows()为什么没能读
全?
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS.ActiveConnection = Connection
strQ = "SELECT NominationDetailsCurrent.NomID, Title, OrderNo, Letter,
CategoryName, Categories.Description, Categories.Weight " & _
"FROM (NominationDetailsCurrent LEFT JO... 阅读全帖
m******t
发帖数: 2416
46
Oracle has only provided support for CLOB/BLOB through
their proprietary classes. You have to cast your
Statement and RecordSet classes downward to the Oracle
implementation, and call some non-JDBC methods on those
classes.
Go to jGuru, search for Oracle and CLOB.
e*u
发帖数: 17
47
来自主题: Programming版 - Excel VBA copy recordset 的瓶颈
试试在写入field前把Application.ScreenUpdating设为false。
所有数据都写入后再设成true

spreadsheet
g****j
发帖数: 6
48
来自主题: Programming版 - Excel VBA copy recordset 的瓶颈
等一下去办公室试试看,只是不明白次为何解? 自己写的Function 和Microsoft的
CopyFromRecordset的performance 还是有上百倍的差距,不知道MS下了什么料在他们
的build-in function里。
k***g
发帖数: 7244
49
来自主题: Programming版 - Excel VBA copy recordset 的瓶颈
这个问题我以前也遇到过,一个 string 的长度不能超过 911 characters,否则就出
Run-time error '1004' 的错误;
使用 loop 的效率太低,即便是你把 application.screenupdating 设置为 false,也
不能有大的改观;
比较好的 solution 是使用 ActiveSheet.QueryTables.Add 的方式,不会出现 911
character 的限制;
这里有一个 reference: http://groups.google.co.uk/group/microsoft.public.excel.programming/browse_thread/thread/cfe13ba9d1211089/55fe0f8715193b3a?lnk=st&q=&rnum=3&hl=en#55fe0f8715193b3a

spreadsheet
w*****s
发帖数: 122
50
来自主题: XML版 - XML 教程--11
数据库中的XML应用实例

我们在该例中介绍如何实现数据库和XML结合。您将可以看到,该例中实现对一般
的关系数据库进行查询等操作,并将结果输出到通用的XML。例中还示范结合采用
XSL规范XML的格式,用HTTP和ASP进行网络的通信和处理。您可以在此基础上进行
许多扩充的开发,特别是服务器/客户端架构的Web应用。
下面我们来详细说明该实例及使用方法:
(1)准备工作
打开控制面板,将Northwind.mdb数据库添加至您的用户数据源(DNS)并命名为"
nwind";
process.asp放在服务器端,第4部分中要用到该文件处理HTTP请求;
用Visual Basic 6.0打开test.vbp项目,引用MS XML Version2.0库。
(2)定义的变量
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim xmlstr As String
Dim xmldoc As MSXML.DOMDocumen
首页 上页 1 2 (共2页)