You're still setting your connection object up and then trying to assign
a string to the object itself as opposed to passing the string as a
parameter to the Open() method. Try this instead :-
<%
dim
cn,rs,Projectname,bids,avergebid,jobtype,started,ending,bid,rs1,a,b,
strConnString
set cn=server.createobject("ADODB.connection")
set rs=server.createobject("ADODB.recordset")
set rs1=server.createobject("ADODB.recordset")
set rs2=server.createobject("ADODB.recordset")
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; "
strConnString = strConnString & "DBQ=" &
Server.MapPath("/access_db/wecommerce.mdb")
cn.Open strConnString
'...
You might also want to take a look at
http://www.w3schools.com/ado/ado_intro.asp.
Dan
________________________________
From: AspClassicAnyQuestionIsOk@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jegatha
Sent: 23 August 2005 06:47
To: AspClassicAnyQuestionIsOk@yahoogroups.com
Subject: Re: [AspClassicAnyQuestionIsOk] data retriving
/*****My first Page Code is******/
<body>
<%
dim
cn,rs,Projectname,bids,avergebid,jobtype,started,ending,bid,rs1,a,b
set cn=server.createobject("ADODB.connection")
set rs=server.createobject("ADODB.recordset")
set rs1=server.createobject("ADODB.recordset")
set rs2=server.createobject("ADODB.recordset")
cn="DRIVER={Microsoft Access Driver (*.mdb)}; "
cn=cn & "DBQ=" & Server.MapPath("/access_db/wecommerce.mdb")
rs.open "select * from 3dmax",cn,1,2
rs2.open "select * from 3dmax",cn,1,2
rs1.open"select a.ProjectName,a.hits from 3dmaxsubmit a,3dmax b where
a.ProjectName=b.ProjectName",cn,1,2
while not rs2.eof
while not rs1.eof
if(rs("ProjectName")=rs1("ProjectName")) then
a=rs1("hits")
b=rs1("ProjectName")
end if
rs1.movenext
wend
rs2.movenext
wend
session("a")=b
response.write b
%>
<p><b>
Feature projects</b></p>
<table border="1" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#ACAAA8" width="100%"
id="AutoNumber1" bgcolor="#E2E1E0">
<tr>
<td width="24%"><b>Project Name</b></td>
<td width="16%"><b> </b></td>
<td width="16%"><b>No Of Bids</b></td>
<td width="17%"><b>AverageBid</b></td>
<td width="17%"><b>Jobtype</b></td>
<td width="17%"><b>Started</b></td>
<td width="17%"><b>EndDate</b></td>
</tr>
<form name=frm method=post action="3dmax1.asp">
<%while not rs.eof
b=rs(1)%>
<input type=hidden name=hid1 value=<%=rs(1)%>>
<tr>
<td width="24%"><%=rs(1)%> </td>
<td width="16%">
<input type=submit value="viewdetails" style="color: #000000;
text-decoration: blink; background-color: #6699FF"></td>
</form><form> <%
if(a>0) then%>
<td width="8%"><%=a%> </td>
<%else%>
<td width="8%"><%=rs(2)%> </td>
<%end if%>
<td width="9%"><%=rs(3)%> </td>
<td width="25%"><%=rs(4)%> </td>
<td width="17%"><%=rs(5)%> </td>
<td width="17%"><%=rs(6)%> </td>
</tr>
<%
rs.movenext
wend
%>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>
</form>
</body>
/*******submit page code is***/
<body>
<%
dim hide1
hide1=request.form("hid1")
response.write hide1
set cn=server.createobject("ADODB.connection")
set rs=server.createobject("ADODB.recordset")
cn="DRIVER={Microsoft Access Driver (*.mdb)}; "
cn=cn & "DBQ=" & Server.MapPath("/access_db/wecommerce.mdb")
rs.open "select * from 3dmax where projectname='"&hide1&"' ",cn,1,2
%>
<form method="POST" action="3dmax2.asp">
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#E2E1E0" width="57%"
id="AutoNumber1" bordercolorlight="#E2E1E0" bordercolordark="#E2E1E0">
<tr>
<td width="19%" bgcolor="#C0C0C0" style="font-weight:
bold">Status</td>
<td width="81%" bgcolor="#C0C0C0" style="font-weight:
bold"><%=rs(8)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#E2E1E0"><b>Budget</b></td>
<td width="81%" bgcolor="#E2E1E0"><%=rs(12)%> </td>
</tr>
<tr>
<td width="19%" style="font-weight: bold" bgcolor="#ACAAA8">Bid
Open</td>
<td width="81%" style="font-weight: bold"
bgcolor="#ACAAA8"><%=rs(5)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#E2E1E0" style="font-weight: bold">Bid
Close</td>
<td width="81%" bgcolor="#E2E1E0" style="font-weight:
bold"><%=rs(6)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#ACAAA8"><b>Creator</b></td>
<td width="81%" bgcolor="#ACAAA8"><%=rs(9)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#E2E1E0"><b>Description</b><p> </td>
<td width="81%" bgcolor="#E2E1E0"><%=rs(7)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#ACAAA8"><b>Job Type</b></td>
<td width="81%" bgcolor="#ACAAA8"><%=rs(4)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#E2E1E0"><b>Database </b> </td>
<td width="81%" bgcolor="#E2E1E0"><%=rs(10)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#ACAAA8"><b>Operating System</b></td>
<td width="81%" bgcolor="#ACAAA8"><%=rs(11)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#E2E1E0"><b>No of Bids</b></td>
<td width="81%" bgcolor="#E2E1E0"><%=rs(0)%> </td>
</tr>
<tr>
<td width="19%" bgcolor="#ACAAA8"><b>Average Bid</b></td>
<td width="81%" bgcolor="#ACAAA8"><%=rs(2)%> </td>
</tr>
</table>
Regards,
Jegatha
Mark E <[EMAIL PROTECTED]> wrote:
Post your code so we can see it.
Mark
Jegatha <[EMAIL PROTECTED]> wrote:
hi all,
my program structure is like
---------------------------------------------- |
field name1 | submit button |
field name2 | submit button |
-----------------------------------------------| when i click the
submit depends upon the field name1 it should post all the data in the
submit page.For the first recordset i m getting result.for the remaining
when i click submit the field name appers in the address bar,but no
result.
all fields are from same table only.
what could be the error?
thanks
Jegatha
---------------------------------
Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and
lots more.
http://in.promos.yahoo.com/rakhi/index.html
[Non-text portions of this message have been removed]
SPONSORED LINKS
Programming languages C programming language Computer programming
languages Java programming language C programming language History of
computer programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspClassicAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
[Non-text portions of this message have been removed]
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspClassicAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and
lots more.
http://in.promos.yahoo.com/rakhi/index.html
[Non-text portions of this message have been removed]
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hsj93un/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124790417/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
