k****h
发帖数: 27 | 1 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 looks like ado,dao can do it in a recordset.
MySQL,don't know.【 在 bee (只会嗡嗡叫的蜜蜂) 的大作中提到: 】 |
|
B*******n
发帖数: 58 | 3 【 以下文字转载自 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 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 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 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 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 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 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 请高人帮我看看,同样的一段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 我把"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
,
..
的? |
|
|
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比。 |
|
|
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里面做这计算么？ |
|
|
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 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 EXCEL不是用来存储数据的，那么多记录，所以才用数据库啊，EXCEL管用，人家数据库
不都倒闭了。 |
|
i****a
发帖数: 36252 | 25 question is, why do you want to have 100 excel files with 500k records each? |
|
g***l
发帖数: 18555 | 26 因为EXCEL有个65535的RECORD限制
each? |
|
i****a
发帖数: 36252 | 27 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 输出到CSV或者ACCESS不就得了，问题是那么大你怎么QUERY啊，找什么数据，他们自己
都不知道吧，EXCEL去拔份几百万的数据，有点可笑 |
|
u***t
发帖数: 3986 | 29 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? |
|
|
u***t
发帖数: 3986 | 31 I have yet to see a solution from you, pro! |
|
w*r
发帖数: 2421 | 32 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 Use the same Queries from offsource developers to clone a 2nd DB schema for
testing purpose, does that work?!
such |
|
g***l
发帖数: 18555 | 34 弄个BACKUP ZIP一下，下载下来RESTORE一个不就完了，还EXCEL，还要IMPORT多个文件，最后这里出错那里出错的，笑死。
for |
|
u***t
发帖数: 3986 | 35 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.
件，最后这里出错那里出错的，笑死。 |
|
|
g***l
发帖数: 18555 | 37 什么不是BASED ON BUSINESS RULE啊，现在是说数据，大数据量传输怎么能用EXCEL呢
？EXCEL不是数据库，多个文件就是自找麻烦
validation. |
|
u***t
发帖数: 3986 | 38 from a recordset, how to fetch records from row 1000 to row 2000?
Thanks. |
|
c*******e
发帖数: 8624 | 39 你这个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 did you open the recordset? |
|
s**********o
发帖数: 14359 | 43 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 请高人帮我看看,同样的一段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 试试在写入field前把Application.ScreenUpdating设为false。
所有数据都写入后再设成true
spreadsheet |
|
g****j
发帖数: 6 | 48 等一下去办公室试试看，只是不明白次为何解? 自己写的Function 和Microsoft的
CopyFromRecordset的performance 还是有上百倍的差距，不知道MS下了什么料在他们
的build-in function里。 |
|
|
w*****s
发帖数: 122 | 50 数据库中的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 |
|
