query regarding recordset

spraveens · August 20th, 2003, 06:46 AM

Hi iam doing a project of asp and access ,Iam using a dsn less
connection.I would like to know How to bring the values of a recordset into a text field.while updating a record I want the previous value inside the text box.I dont know how to do it .
Kindly help...'

praveen....

pgtips · August 20th, 2003, 07:27 AM

Which bit are you stuck on:
connecting to database?
getting records back?
writing value into text box?
updating record?

can you show us what you've got so far?

rgds
Phil

spraveens · August 20th, 2003, 10:18 PM

Hello Mr.Phil

Everything is working perfectly fine(add,del,update etc)
I want to know how to write the value of a record into a text box in a form.
Thank You
S.Praveen

spraveens · August 20th, 2003, 10:19 PM

Hello Mr.Phil

Everything is working perfectly fine(add,del,update etc)
I want to know how to write the value of a record into a text box in a form

Thank You
S.Praveen

pgtips · August 21st, 2003, 03:15 AM

Assuming you already have a recordset of the values you want to write, just do:

Code:

<%
...
Response.Write("<input type='text' value='" & rsName("FieldName").Value & "'>")
...
%>
or
<input type='text' value='<%=rsName("FieldName").Value%>'>

spraveens · August 21st, 2003, 06:14 AM

Hello sir

Thankz a lot !!!!!!!!!1

praveen.....

spraveens · August 21st, 2003, 06:22 AM

Hi Mr.Phil

Iam Praveen,just finished college Btech I.T. last month
and I have joined an IT company in India,they have given a project to be done by me alone using asp,sql server.although I have a basic knowledge of asp I dont have the high end programming knowledge,so please tell me how and from where I can learn asp,sql etc..
Thank You..
Praveen...

pgtips · August 21st, 2003, 08:13 AM

you could try www.w3schools.com for starters, they have tutorials on all sorts of subjects. If you don't like the ones there, search on google for tutorials - there are lots of them out there.

hth
Phil

Kaustav · August 21st, 2003, 09:18 AM

Sir,
I am an ASP beginner. Well I had a problem when trying to add record to a recordset.
I used the following code to add a new record and received te following error. I am using Win XP an the OS.
set rs = server.createobject(ADODB.Recordset)
rs "GB", strconnect, adopendynamic, adlockoptimistic
' GB is the table and strConnect is the connection string for Ms access 2000
rs.addnew
rs("Name")="Kaustav"
rs.close
set rs=nothing

the Error

The recordset cannot be updated. Database or objet is readonly at rs.addnew

------------------
Kaustav

spraveens · August 21st, 2003, 10:16 PM

Hello Mr.Phil

My query is that How do I execute an sql query with a click of an hyper link, for ex: when I click on the link "view all customers" , I want the query "select * from customerinfo" to be executed and the results displayed.How do I do It?:(

Thank You

S.Praveen