hi all,
this is my coding.
it enter into the if condition here the a value=contacts and the b value=1.
but inside the table(the line highlighted) it return the b value as
contacts.before it return right.i couldn't find out the problem.
can anyone find out the problem?
<%
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")
cn="DRIVER={Microsoft Access Driver (*.mdb)}; "
cn=cn & "DBQ=" & Server.MapPath("/access_db/wecommerce.mdb")
rs.open "select * from 3dmax",cn,1,2
rs1.open"select * from 3dmaxsubmit a,3dmax b where
a.ProjectName=b.ProjectName",cn,1,2
while not rs1.eof
a=rs1("ProjectName")
b=cInt(rs1("hits"))
rs1.movenext
wend
response.write a
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(0)%>>
<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>
<%if(rs(1)=a) then
response.write rs(1)
%>
<td width="8%"><%response.write b%> </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>
thanks in adv
regards,
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]
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12huelm3b/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124697786/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</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/
