Ask a Question related to ASP Components, Design and Development.
-
vasanth kumar #1
How to handle, when SQL command returns a single value
Hi,
I have a problem in dealing with the return value of the SQL command. I know how to do, when SQL command returns Recordsets. But in my case it returns a single value. The following code fails when "objRst.open strQ" is executed. Can somebody suggest me how to overcome this problem.
Any Help is appreciated.
Thanks in advance,
Vasanth
-----------------------
Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbFilePath & ";"
Set objRst = Server.CreateObject("ADODB.Recordset")
strQ = "Select MAX(index) from library where index like '*B-*';"
objRst.Open strQ
cmd.execute
while Not objRst.EOF
index=objRst("index")
objrst.movenext
Wend
Set objRst = nothing
objConnect.Close
Set objConnect = nothing
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action="newupdate.asp" method=post>
index:<%=index%>
</form>
</body>
</html>
----------------------------------------
I also tried the following alternative. Here it fails when I try to print "objRst" on the page.
Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbFilePath & ";"
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = objConnect
strQ = "Select MAX(index) from library where index like '*B-*';"
cmd.commandtext=strQ
set objRst = cmd.execute
objConnect.Close
Set objConnect = nothing
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action="newupdate.asp" method=post>
index:<%=objRst%>
</form>
</body>
</html>
vasanth kumar Guest
-
#40704 [NEW]: strip_tags does not handle single quotes correctly (another regression)
From: email at steffenweber dot net Operating system: Linux PHP version: 5.2.1 PHP Bug Type: Strings related Bug... -
#40637 [NEW]: strip_tags does not handle single quotes correctly (regression)
From: email at steffenweber dot net Operating system: Linux PHP version: 5.2.1 PHP Bug Type: Strings related Bug... -
msyql command line tool can't handle del character
Mysql command line editing works perfectly with history, arrows keys, but print a ~ when I use the del char. It is a bug or a bad configuration?... -
what is the correct way to handle empty database returns?
If I do something like : $result = mysql_query($query); $dbArray = dbResultIntoKeyArray($result); and this is the function: function... -
how to handle single quotation marks
Just wonder how you guys handle the single quatation marks when you write the value of a text input into SQL server. Thanks! * * * Sent via... -
vasanth kumar #2 How to handle, when SQL command returns a single value
Hi,
I have a problem in dealing with the return value of the SQL command. I know how to do, when SQL command returns Recordsets. But in my case it returns a single value. The following code fails when "objRst.open strQ" is executed. Can somebody suggest me how to overcome this problem.
Any Help is appreciated.
Thanks in advance,
Vasanth
-----------------------
Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbFilePath & ";"
Set objRst = Server.CreateObject("ADODB.Recordset")
strQ = "Select MAX(index) from library where index like '*B-*';"
objRst.Open strQ
cmd.execute
while Not objRst.EOF
index=objRst("index")
objrst.movenext
Wend
Set objRst = nothing
objConnect.Close
Set objConnect = nothing
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action="newupdate.asp" method=post>
index:<%=index%>
</form>
</body>
</html>
----------------------------------------
I also tried the following alternative. Here it fails when I try to print "objRst" on the page.
Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdbFilePath & ";"
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = objConnect
strQ = "Select MAX(index) from library where index like '*B-*';"
cmd.commandtext=strQ
set objRst = cmd.execute
objConnect.Close
Set objConnect = nothing
%>
<html>
<head>
<title>
</title>
</head>
<body>
<form action="newupdate.asp" method=post>
index:<%=objRst%>
</form>
</body>
</html>
vasanth kumar Guest
-
Ray at #3 Re: How to handle, when SQL command returns a single value
The problem is that you do not have a column named INDEX in your recordset.
You have an unnamed column that represents MAX(index). You can either name
it in your query or use the index value in the recordset to get it. (Not
the same "index" as in your column name.)
"Select MAX(index) as TheMax from library..."
index = objRst.Fields.Item("TheMax").Value
Or, leave your query as is and do:
index = objRst.Fields.Item(0).Value
Ray at work
"vasanth kumar" <vasanth.kumar@eds.com> wrote in message
news:%23J5ak5ZaEHA.1248@TK2MSFTNGP11.phx.gbl...
Hi,
I have a problem in dealing with the return value of the SQL command. I
know how to do, when SQL command returns Recordsets. But in my case it
returns a single value. The following code fails when "objRst.open strQ" is
executed. Can somebody suggest me how to overcome this problem.
Any Help is appreciated.
Thanks in advance,
Vasanth
-----------------------
Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
mdbFilePath & ";"
Set objRst = Server.CreateObject("ADODB.Recordset")
strQ = "Select MAX(index) from library where index like '*B-*';"
objRst.Open strQ
cmd.execute
while Not objRst.EOF
index=objRst("index")
objrst.movenext
Wend
Ray at Guest
-
Ray at #4 Re: How to handle, when SQL command returns a single value
The problem is that you do not have a column named INDEX in your recordset.
You have an unnamed column that represents MAX(index). You can either name
it in your query or use the index value in the recordset to get it. (Not
the same "index" as in your column name.)
"Select MAX(index) as TheMax from library..."
index = objRst.Fields.Item("TheMax").Value
Or, leave your query as is and do:
index = objRst.Fields.Item(0).Value
Ray at work
"vasanth kumar" <vasanth.kumar@eds.com> wrote in message
news:%23J5ak5ZaEHA.1248@TK2MSFTNGP11.phx.gbl...
Hi,
I have a problem in dealing with the return value of the SQL command. I
know how to do, when SQL command returns Recordsets. But in my case it
returns a single value. The following code fails when "objRst.open strQ" is
executed. Can somebody suggest me how to overcome this problem.
Any Help is appreciated.
Thanks in advance,
Vasanth
-----------------------
Set objConnect = Server.CreateObject("ADODB.Connection")
objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
mdbFilePath & ";"
Set objRst = Server.CreateObject("ADODB.Recordset")
strQ = "Select MAX(index) from library where index like '*B-*';"
objRst.Open strQ
cmd.execute
while Not objRst.EOF
index=objRst("index")
objrst.movenext
Wend
Ray at Guest
-
vasanth kumar #5 Re: How to handle, when SQL command returns a single value
Thanks for the help. It worked.
-Vasanth
"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:OH8pRLaaEHA.212@TK2MSFTNGP12.phx.gbl...recordset.> The problem is that you do not have a column named INDEX in yourname> You have an unnamed column that represents MAX(index). You can eitherI> it in your query or use the index value in the recordset to get it. (Not
> the same "index" as in your column name.)
>
> "Select MAX(index) as TheMax from library..."
> index = objRst.Fields.Item("TheMax").Value
>
> Or, leave your query as is and do:
>
> index = objRst.Fields.Item(0).Value
>
> Ray at work
>
> "vasanth kumar" <vasanth.kumar@eds.com> wrote in message
> news:%23J5ak5ZaEHA.1248@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a problem in dealing with the return value of the SQL command.is> know how to do, when SQL command returns Recordsets. But in my case it
> returns a single value. The following code fails when "objRst.open strQ"> executed. Can somebody suggest me how to overcome this problem.
>
> Any Help is appreciated.
> Thanks in advance,
> Vasanth
> -----------------------
> Set objConnect = Server.CreateObject("ADODB.Connection")
> objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> mdbFilePath & ";"
> Set objRst = Server.CreateObject("ADODB.Recordset")
> strQ = "Select MAX(index) from library where index like '*B-*';"
> objRst.Open strQ
> cmd.execute
> while Not objRst.EOF
> index=objRst("index")
> objrst.movenext
> Wend
>
>
vasanth kumar Guest
-
vasanth kumar #6 Re: How to handle, when SQL command returns a single value
Thanks for the help. It worked.
-Vasanth
"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:OH8pRLaaEHA.212@TK2MSFTNGP12.phx.gbl...recordset.> The problem is that you do not have a column named INDEX in yourname> You have an unnamed column that represents MAX(index). You can eitherI> it in your query or use the index value in the recordset to get it. (Not
> the same "index" as in your column name.)
>
> "Select MAX(index) as TheMax from library..."
> index = objRst.Fields.Item("TheMax").Value
>
> Or, leave your query as is and do:
>
> index = objRst.Fields.Item(0).Value
>
> Ray at work
>
> "vasanth kumar" <vasanth.kumar@eds.com> wrote in message
> news:%23J5ak5ZaEHA.1248@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a problem in dealing with the return value of the SQL command.is> know how to do, when SQL command returns Recordsets. But in my case it
> returns a single value. The following code fails when "objRst.open strQ"> executed. Can somebody suggest me how to overcome this problem.
>
> Any Help is appreciated.
> Thanks in advance,
> Vasanth
> -----------------------
> Set objConnect = Server.CreateObject("ADODB.Connection")
> objConnect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> mdbFilePath & ";"
> Set objRst = Server.CreateObject("ADODB.Recordset")
> strQ = "Select MAX(index) from library where index like '*B-*';"
> objRst.Open strQ
> cmd.execute
> while Not objRst.EOF
> index=objRst("index")
> objrst.movenext
> Wend
>
>
vasanth kumar Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
