ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreASP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old October 27th, 2003, 01:51 PM
aliaga61 aliaga61 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Posts: 63 aliaga61 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 1 m 45 sec
Reputation Power: 6
type mismatch error

i tried running the following code but am getting a "type mismatch error" referring to the "if strwoseqn <> adoRS(1)" line. can anyone help? thanks.

<!-- #include file='CO_Menu.asp' -->
<!-- #include file='DB_TMS_Open.asp' -->

<%
strPageID = "wolag"
%>



<table>
<tr>
<td>
Total Time Spent In Each basket for all TSR's between 06-SEP-03 and 06-OCT-03
</td>
</tr>
<tr>
<td>
AOP
</td>
<td>
ASW
</td>
</tr>

<%
StrSQL="select distinct t.tsnumb, wo.woseqn, wob.wcbask, wob.wcstat, wob.wcdate from tsr t, workorder wo, wobaskdtl wob where wo.wonumb not in (select wob2.wcnumb from wobaskdtl wob2 where wob2.wcbask='PROJ' and wob2.wcnumb=t.tsnumb) and wo.woseqn = wob.wcseqn and t.tsstat='C' and t.tsnumb=wo.wonumb and wo.wostat='C' and t.tscdat between '06-SEP-03' and '06-OCT-03' and wob.wcnumb=t.tsnumb and wob.wcbask not in (select wob3.wcbask from wobaskdtl wob3 where wob3.wcstat='X' and wob3.wcnumb=t.tsnumb) order by t.tsnumb, wo.woseqn, wob.wcbask,wob.wcdate"
Set adoRS = adoConn.Execute(StrSQL)

totalaswtime=0
totalaoptime=0

Do until adoRS.EOF

if strwoseqn <> adoRS(1) then
blnNewSeqn=True
else
end if

strwoseqn=adoRS(1)

if blnNewSeqn=True then
aswopen=null
aswclose=null
aopopen=null
aopclose=null
else
end if

if left(adoRS(2),2)="AO" then

if adoRS(3)="A" then
aswopen=adoRS(4)
else
end if
if adoRS(3)="C" then
aswclose=adoRS(4)
else
end if
if adoRS(3)="T" then
aswclose=adoRS(4)
else
end if
if aswclose <> null and aswopen <> null then
compaswtime=round(aswopen-aswclose,2)
totalaswtime=round(totalaswtime+compaswtime,2)
aswopen=null
aswclose=null
else
end if
else
end if
adoRS.movenext
loop
%>

<tr>
<td>
<%=totalaswtime%>
</td>
<td>
<%=totalaoptime%>
</td>
</tr>
</table>

<!-- #include file='DB_TMS_Close.asp' -->
<!-- #include file='CO_Disclaim.asp' -->

Reply With Quote
  #2  
Old October 27th, 2003, 02:43 PM
aliaga61 aliaga61 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Posts: 63 aliaga61 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 1 m 45 sec
Reputation Power: 6
please disregard, i figured it out.

i am having a related problem though if you could help...

http://forums.devshed.com/showthrea...&threadid=94003

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreASP Programming > type mismatch error


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT