IT Community - Software Programming, Web Development and Technical Support

Classic asp arrays and recordset

This is a discussion on Classic asp arrays and recordset within the ASP and ASP.NET Programming forums, part of the Web Development category; The question is i have an array of five numbers. I have to check the array with database result. if ...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > ASP and ASP.NET Programming

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 11-30-2007, 03:31 AM
ramesh123 ramesh123 is offline
D-Web Trainee
 
Join Date: Nov 2007
Posts: 7
ramesh123 is on a distinguished road
Question Classic asp arrays and recordset

The question is

i have an array of five numbers. I have to check the array with database result. if the array number not exsist in result set i have to add it to a combo box.

can anybody give me the solution it would be helpful.

thanks
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-02-2007, 07:44 PM
ramesh123 ramesh123 is offline
D-Web Trainee
 
Join Date: Nov 2007
Posts: 7
ramesh123 is on a distinguished road
Default Re: Classic asp arrays and recordset

Here i attached the code kindly help me to debug this code

<!-- #include file="dbconnect.inc"-->
<%
dim access_numbers(5),i,select_numbers(5),j
access_numbers(0)="2134160606"
access_numbers(1)="2134160607"
access_numbers(2)="2134160608"
access_numbers(3)="2134160609"
access_numbers(4)="2134160610"
'dnis

set rs1=conobj1.execute("select count(dnis) as num from autodialer where account='200001' ")
num=rs1("num")

set rs=conobj1.execute("select dnis from autodialer where account='200001' ")
for i=0 to ubound(access_numbers)-1
for j=0 to num-1
if (access_numbers(i) <> rs(j)) then
Response.Write(access_numbers(i))&"<Br/>"
end if
next
next

%>
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Arrays in PHP Sabari PHP Programming 123 05-30-2008 12:46 AM
classic asp date formatting ramesh123 ASP and ASP.NET Programming 1 02-14-2008 07:13 PM
Paypal integration in classic asp Dinakaran ASP and ASP.NET Programming 3 11-26-2007 05:46 AM
Jagged Arrays in C# vigneshgets C# Programming 3 08-23-2007 12:13 AM
Writing MYSQL Query Recordset into external file. Murali Database Support 2 07-19-2007 07:03 AM


All times are GMT -7. The time now is 07:19 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0