Flash Games

 FAQ   Search   Members   Groups   User Control Panel      Login 

It is currently Fri Jan 09, 2009 1:37 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Begininer, needing help with ASP numeracy - Happy Christmas
PostPosted: Wed Dec 22, 2004 11:38 am 
Offline

Joined: Wed Dec 22, 2004 11:36 am
Posts: 0
Location: York, UK
Hi,

I need to display in my form fields the last record in my access database, which is a numerical value, then add 1 to that value.

The code i have so far is:

<%
' Name of the Accessdb being read
accessdb="form1"

' Connect to the db with a DSN-less connection
cn="DRIVER={Microsoft Access Driver (*.mdb)};"
cn=cn & "DBQ=" & server.mappath(accessdb)

' Create a server recordset object
Set rs = Server.CreateObject("ADODB.Recordset")

rs.CursorType = 3

' Select specific fields from the table the_bird
sql = "select t1004, t6103 from doc"


' Execute the sql
rs.Open sql, cn
%>


<%

rs.movelast

%>


<%= rs("t1004") %>">
<%= rs("t6103") %>">


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group - Flash Games - TNX Invitation Code - TNX Review

Welcome to DEVPPL.com
You are not logged in, which means that you can't post in the forums.
Click here to Register

If you are a current member here on DEVPPL, please login below:

User:
Pass:
Log me on automatically each visit: