RECORDSET

[NAIME ESTEVES]

I am trying to make a data base for a ASP website. But
when I try to write the code DataSet11.Recordset.Addnew.
Appears error when I compile to test the data base.

I hope to receive help.

[Steve C. Orr, MCSD]

Are you talking about ASP or ASP.NET?
This group is for ASP.NET

For ASP 3.0 questions try this newsgroup:
microsoft.public.inetserver.asp.general

If you're talking about ASP.NET, recordsets aren't used any more with
ADO.NET.

--
I hope this helps,
Steve C. Orr, MCSD
[url]http://Steve.Orr.net[/url]


"NAIME ESTEVES" <NESTEVES@HOUSTON.RR.COM> wrote in message
news:a0aa01c34686$c7d03960$a401280a@phx.gbl...

> I am trying to make a data base for a ASP website. But
> when I try to write the code DataSet11.Recordset.Addnew.
> Appears error when I compile to test the data base.
>
> I hope to receive help.
>

[Benjie Fallar]

i guess you have a wrong code here.

the dataset does not have Recordset object, if you are trying to add a new
row in a dataset, please use the code below:

Dim drNew as DataRow = ds.Tables(0).Rows.AddNew()
drNew(0) = "..."
ds.Tables(0).Rows.Add(drNew)

"NAIME ESTEVES" <NESTEVES@HOUSTON.RR.COM> wrote in message
news:a0aa01c34686$c7d03960$a401280a@phx.gbl...

> I am trying to make a data base for a ASP website. But
> when I try to write the code DataSet11.Recordset.Addnew.
> Appears error when I compile to test the data base.
>
> I hope to receive help.
>

[David Waz...]

read book

"NAIME ESTEVES" <nesteves9723@hotmail.com> wrote in message
news:efthnlvRDHA.3880@tk2msftngp13.phx.gbl...

>
>
> I received a Error massage with "ds is not declare" from the code you
> sent me. Please advise how can I declare the ds. I tried to use:
> Dim ds as Data
> or
> Dim ds as Table
>
> But its not work.
>
> Thank in advance
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[NAIME ESTEVES]

I already solve the problem, but now I have another problem, when I
launch the ASP Application it's not appear the field I already design on
the webform.

Can you help me??

Thank in advance

Naime

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[janet]

hi ...

i am checking if the password is matching with either the
student_table or the teacher_table then it shoudl
display "welStudent.asp" page else it sould go to another
page called "newstudent.asp".

I have created 2 recodsets because i need 2 different
queries to be executed using 2 diff tables:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnString
QUERY1 = "SELECT student_password from student_info Where
student_username='" &Request("txtNAME")&"'"
Set RSA = Conn.Execute(QUERY1)

QUERY2 = "SELECT teacher_password from teacher_info Where
teacher_username='" &Request("txtNAME")&"'"
Set RSA2 = Conn.Execute(QUERY2)

its continously giving error on this line :-(((

if RSA("student_password")=Request("txtPASSWORD") or RSA2
("teacher_password")=Request("txtPASSWORD") then

cant i use the 2 recordsets??? in one if- then-else
condition? I am pasting my script for reference.
I ahve even tried to create 2 adodb connections (which may
sound sillly ...!) but nothign is working....

any thots?? or suggestions

thanks in advance for such painful help!
janet

here goes my script==>

<%
DIM RSA
DIM QUERY1
DIM RSA2
DIM QUERY2
DIM ConnString
DIM Conn
DIM flagST

ConnString = "Driver={MySQL ODBC 3.51 Driver};"
ConnString = ConnString & "Port=3306; "
ConnString = ConnString & "DATABASE=test; "

If Request("txtNAME")<>"" and Request("txtPassword") <> ""
and Request("login") = "Login" Then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnString

QUERY1 = "SELECT student_password from student_info
Where student_username='" &_
Request("txtNAME")&"'"
Set RSA = Conn.Execute(QUERY1)

QUERY2 = "SELECT teacher_password from teacher_info
Where teacher_username='" &_
Request("txtNAME")&"'"
Set RSA2 = Conn.Execute(QUERY2)

If RSA.EOF and RSA2.EOF then
flagST = "NotStudTeach"
response.write "none"
else
flagST = "StudTeach"
response.write "any"
end if

If RSA.EOF and RSA2.EOF Then
Response.Write("Invalid Login!!! ")
server.transfer("newStudent.asp")
end if

if RSA("student_password")=Request("txtPASSWORD") or
RSA2("teacher_password")=Request("txtPASSWORD") then
server.transfer("welStudent.asp")
else
server.transfer("newstudent.asp")
end if
' RSA.Close
' Set RSA = Nothing
' RSA2.Close
' Set RSA2 = Nothing
' Conn.Close
' Set Conn = Nothing
else
Response.write "Please enter Both the Student Id
and the Password!!!"
server.transfer("loginDB.asp")
End If
%>

[janet]

Error Type:
(0x80020009)
Exception occurred.
/myweb/loginDB2.asp, line 39


this line 39 is :
if RSA("student_password")=Request.form("txtPASSWORD" ) or
RSA2("teacher_password")=Request.form("txtPASSWORD ") then

(i tried with request adn request.form both !)

>-----Original Message-----
>What is the actual text of the error message you are
>receiving?
>
>
>
>

>>-----Original Message-----
>>hi ...
>>
>>i am checking if the password is matching with either

the

>>student_table or the teacher_table then it shoudl
>>display "welStudent.asp" page else it sould go to

another

>>page called "newstudent.asp".
>>
>>I have created 2 recodsets because i need 2 different
>>queries to be executed using 2 diff tables:
>>
>>Set Conn = Server.CreateObject("ADODB.Connection")
>>Conn.Open ConnString
>>QUERY1 = "SELECT student_password from student_info

Where

>>student_username='" &Request("txtNAME")&"'"
>>Set RSA = Conn.Execute(QUERY1)
>>
>>QUERY2 = "SELECT teacher_password from teacher_info

Where

>>teacher_username='" &Request("txtNAME")&"'"
>>Set RSA2 = Conn.Execute(QUERY2)
>>
>>its continously giving error on this line :-(((
>>
>>if RSA("student_password")=Request("txtPASSWORD") or RSA2
>>("teacher_password")=Request("txtPASSWORD") then
>>
>>cant i use the 2 recordsets??? in one if- then-else
>>condition? I am pasting my script for reference.
>>I ahve even tried to create 2 adodb connections (which

>may

>>sound sillly ...!) but nothign is working....
>>
>>any thots?? or suggestions
>>
>>thanks in advance for such painful help!
>>janet
>>
>>here goes my script==>
>>
>><%
>>DIM RSA
>>DIM QUERY1
>>DIM RSA2
>>DIM QUERY2
>>DIM ConnString
>>DIM Conn
>>DIM flagST
>>
>>ConnString = "Driver={MySQL ODBC 3.51 Driver};"
>>ConnString = ConnString & "Port=3306; "
>>ConnString = ConnString & "DATABASE=test; "
>>
>>If Request("txtNAME")<>"" and Request("txtPassword")

><> ""

>>and Request("login") = "Login" Then
>> Set Conn = Server.CreateObject("ADODB.Connection")
>> Conn.Open ConnString
>>
>> QUERY1 = "SELECT student_password from student_info
>>Where student_username='" &_
>> Request("txtNAME")&"'"
>> Set RSA = Conn.Execute(QUERY1)
>>
>> QUERY2 = "SELECT teacher_password from teacher_info
>>Where teacher_username='" &_
>> Request("txtNAME")&"'"
>> Set RSA2 = Conn.Execute(QUERY2)
>>
>> If RSA.EOF and RSA2.EOF then
>> flagST = "NotStudTeach"
>> response.write "none"
>> else
>> flagST = "StudTeach"
>> response.write "any"
>> end if
>>
>> If RSA.EOF and RSA2.EOF Then
>> Response.Write("Invalid Login!!! ")
>> server.transfer("newStudent.asp")
>> end if
>>
>> if RSA("student_password")=Request("txtPASSWORD") or
>>RSA2("teacher_password")=Request("txtPASSWORD" ) then
>> server.transfer("welStudent.asp")
>> else
>> server.transfer("newstudent.asp")
>> end if
>>' RSA.Close
>> ' Set RSA = Nothing
>> ' RSA2.Close
>>' Set RSA2 = Nothing
>> ' Conn.Close
>> ' Set Conn = Nothing
>>else
>> Response.write "Please enter Both the Student Id
>>and the Password!!!"
>> server.transfer("loginDB.asp")
>>End If
>>%>
>>
>>.
>>

>.
>

[Aaron Bertrand - MVP]

Did you bother checking if either recordset was empty? What you might
consider doing is:


if NOT RSA.EOF then RSAPass = RSA("student_password")
if NOT RSA2.EOF then RSA2Pass = RSA2("teacher_password")
if (RSAPass = request.form("txtPassword") OR RSA2Pass =
request.form("txtPassword")) then
...

Out of curisoity, since student_password is in a table called student_info,
isn't the student_ prefix a little redundant? What other kind of password
could it be?



"janet" <knowgroup@hotmail.com> wrote in message
news:017301c368bf$8fc0df10$a101280a@phx.gbl...

> hi ...
>
> i am checking if the password is matching with either the
> student_table or the teacher_table then it shoudl
> display "welStudent.asp" page else it sould go to another
> page called "newstudent.asp".
>
> I have created 2 recodsets because i need 2 different
> queries to be executed using 2 diff tables:
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open ConnString
> QUERY1 = "SELECT student_password from student_info Where
> student_username='" &Request("txtNAME")&"'"
> Set RSA = Conn.Execute(QUERY1)
>
> QUERY2 = "SELECT teacher_password from teacher_info Where
> teacher_username='" &Request("txtNAME")&"'"
> Set RSA2 = Conn.Execute(QUERY2)
>
> its continously giving error on this line :-(((
>
> if RSA("student_password")=Request("txtPASSWORD") or RSA2
> ("teacher_password")=Request("txtPASSWORD") then
>
> cant i use the 2 recordsets??? in one if- then-else
> condition? I am pasting my script for reference.
> I ahve even tried to create 2 adodb connections (which may
> sound sillly ...!) but nothign is working....
>
> any thots?? or suggestions
>
> thanks in advance for such painful help!
> janet
>
> here goes my script==>
>
> <%
> DIM RSA
> DIM QUERY1
> DIM RSA2
> DIM QUERY2
> DIM ConnString
> DIM Conn
> DIM flagST
>
> ConnString = "Driver={MySQL ODBC 3.51 Driver};"
> ConnString = ConnString & "Port=3306; "
> ConnString = ConnString & "DATABASE=test; "
>
> If Request("txtNAME")<>"" and Request("txtPassword") <> ""
> and Request("login") = "Login" Then
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open ConnString
>
> QUERY1 = "SELECT student_password from student_info
> Where student_username='" &_
> Request("txtNAME")&"'"
> Set RSA = Conn.Execute(QUERY1)
>
> QUERY2 = "SELECT teacher_password from teacher_info
> Where teacher_username='" &_
> Request("txtNAME")&"'"
> Set RSA2 = Conn.Execute(QUERY2)
>
> If RSA.EOF and RSA2.EOF then
> flagST = "NotStudTeach"
> response.write "none"
> else
> flagST = "StudTeach"
> response.write "any"
> end if
>
> If RSA.EOF and RSA2.EOF Then
> Response.Write("Invalid Login!!! ")
> server.transfer("newStudent.asp")
> end if
>
> if RSA("student_password")=Request("txtPASSWORD") or
> RSA2("teacher_password")=Request("txtPASSWORD") then
> server.transfer("welStudent.asp")
> else
> server.transfer("newstudent.asp")
> end if
> ' RSA.Close
> ' Set RSA = Nothing
> ' RSA2.Close
> ' Set RSA2 = Nothing
> ' Conn.Close
> ' Set Conn = Nothing
> else
> Response.write "Please enter Both the Student Id
> and the Password!!!"
> server.transfer("loginDB.asp")
> End If
> %>
>

[Make it so!]

Hi

I am using DW7 and I am trying to use the filter part of the recordset. I have
a repeating table with all of the links in the test database showing, but when
I try to use the filter part of the recordset the information disapears when I
click live view . I think I might be going wrong in the url parameters bit, but
not too sure.

Here is the page so far, but can't get individual profiles when you click the
links.[url]http://phwebdesign.co.uk/userinfo.php[/url]

Thanks in advance,

Phil

[Make it so!]

Hi
Does anyone know about recordsets, I am trying to link the info you select on
one page to display the individual information on another. This is all from a
database. As you can see when you click peoples name on this
pagehttp://www/phwebdesign.co.uk/userinfo.php it should display their info on
it's own on the next page. But the filter part of a recordset seems to be
beating me at the moment. Any ideas how you do this?

Thanks

Phil

[acidrain9]

this seems like an issue that should be in the application section of the macromedia forums.

but if you post your recorset information here i'll try to help