Click here to Skip to main content
15,397,318 members
Home / Discussions / Database
   

Database

 
AnswerRe: How do I change the location of (LOCAL)? Pin
kubben30-Mar-07 13:44
Memberkubben30-Mar-07 13:44 
QuestionExtracting just the date portion Pin
Marc Clifton30-Mar-07 4:28
mvaMarc Clifton30-Mar-07 4:28 
AnswerRe: Extracting just the date portion Pin
Colin Angus Mackay30-Mar-07 4:39
MemberColin Angus Mackay30-Mar-07 4:39 
GeneralRe: Extracting just the date portion Pin
Marc Clifton30-Mar-07 4:47
mvaMarc Clifton30-Mar-07 4:47 
GeneralRe: Extracting just the date portion Pin
Colin Angus Mackay30-Mar-07 5:11
MemberColin Angus Mackay30-Mar-07 5:11 
AnswerRe: Extracting just the date portion Pin
kubben30-Mar-07 5:08
Memberkubben30-Mar-07 5:08 
GeneralRe: Extracting just the date portion Pin
Marc Clifton30-Mar-07 5:14
mvaMarc Clifton30-Mar-07 5:14 
Questiongetting RecordCount = -1 Pin
Ankur.Bakliwal30-Mar-07 3:48
MemberAnkur.Bakliwal30-Mar-07 3:48 
Hello Friends,

I have a problem with recordsets.

I m getting Rs.RecordCount = -1 while calling a store procedures

here is code -

Set cmd = Server.CreateObject("ADODB.Command")
Set rs = Server.CreateObject("ADODB.RecordSet")
cmd.ActiveConnection = myCon
cmd.CommandText = "SP_Name"
cmd.CommandType = 4
cmd.CommandTimeout = 300
cmd.Parameters.Append cmd.CreateParameter("@par1",20,1,10,1)
cmd.Parameters.Append cmd.CreateParameter("@par2",20,1,10,1)
cmd.Parameters.Append cmd.CreateParameter("@par3",20,1,10,20)
cmd.Parameters.Append cmd.CreateParameter("@par4",20,1,10,Null)
Rs.CursorLocation = 3
Rs.LockType = 1
Rs.CursorType = 3
Set Rs = cmd.Execute
Response.Write "<br>RecordCount = " & Rs.RecordCount


pls give some usefull solution.






Thanks,
Ankur Bakliwal
AnswerRe: getting RecordCount = -1 Pin
Christian Graus30-Mar-07 3:55
mveChristian Graus30-Mar-07 3:55 
GeneralRe: getting RecordCount = -1 Pin
Ankur.Bakliwal30-Mar-07 3:59
MemberAnkur.Bakliwal30-Mar-07 3:59 
GeneralRe: getting RecordCount = -1 Pin
Christian Graus30-Mar-07 4:03
mveChristian Graus30-Mar-07 4:03 
AnswerRe: getting RecordCount = -1 Pin
roel_v31-Mar-07 2:45
Memberroel_v31-Mar-07 2:45 
QuestionDistribution of software Pin
drc_no130-Mar-07 3:41
Memberdrc_no130-Mar-07 3:41 
AnswerRe: Distribution of software Pin
Colin Angus Mackay30-Mar-07 4:32
MemberColin Angus Mackay30-Mar-07 4:32 
QuestionUrgent Pin
Test27030730-Mar-07 2:51
MemberTest27030730-Mar-07 2:51 
AnswerRe: Urgent Pin
Christian Graus30-Mar-07 3:06
mveChristian Graus30-Mar-07 3:06 
GeneralRe: Urgent Pin
Test27030730-Mar-07 3:44
MemberTest27030730-Mar-07 3:44 
GeneralRe: Urgent Pin
Christian Graus30-Mar-07 4:00
mveChristian Graus30-Mar-07 4:00 
GeneralRe: Urgent Pin
Test27030730-Mar-07 4:02
MemberTest27030730-Mar-07 4:02 
GeneralRe: Urgent Pin
Christian Graus30-Mar-07 4:04
mveChristian Graus30-Mar-07 4:04 
AnswerRe: Urgent Pin
Christian Graus30-Mar-07 4:04
mveChristian Graus30-Mar-07 4:04 
AnswerRe: Urgent Pin
DQNOK30-Mar-07 4:09
professionalDQNOK30-Mar-07 4:09 
GeneralRe: Urgent Pin
Test27030730-Mar-07 18:40
MemberTest27030730-Mar-07 18:40 
AnswerRe: Urgent Pin
Noman Aftab31-Mar-07 1:01
MemberNoman Aftab31-Mar-07 1:01 
Questionserver : error 18025 Pin
Navneet Hegde30-Mar-07 2:47
MemberNavneet Hegde30-Mar-07 2:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.