I.T. Discussion Community!
-Collapse +Expand
ASP Classic
Search ASP Classic Group:

Advanced
-Collapse +Expand ASP Classic Store

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyASP Classic Coding BoardASP Classic - Handling Data Topic   Print This     

ODBC Join tables

ODBC Join tables in ASP Classic - Handling Data topic (part of our ASP Classic Coding group).

Quick Search: ODBC Join   ODBC Join tables  
Yesid.B
-- --

I am attempting to join two tables through an 'INDEX' field like so:

SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE,
w."INDEX", w.QUAR FROM wrhse AS w, items AS s
WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX"

However I am not getting a result.

Initially I was using the following:

sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc'

to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables?

Thank you in advance.

 Posted 25 months ago (Thread Starter)
Comment Quote
About Yesid.B -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17105, 10 replies
Thread Started 5/9/2018 7:01:04 AM
View Counter=957
Last Reply Posted 4/13/2020 12:01:49 AM)
Location=-- -- 
Joined=46 months ago   MB Posts=4  
PS_1117
jobhubnet
-- USA

It is my pride to visit this site repeatedly as it is very useful and delightful for me.
This post truly made me happy.
Latest Jobs

 Posted 21 months ago
Comment Quote
About PS_1117 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17249 (Level 2) and Parent is 17105
Reply Posted 9/15/2018 6:52:18 PM
Location=-- USA 
Joined=21 months ago   MB Posts=3  
PS_1117
jobhubnet
-- USA

It’s remarkable to visit this web site and reading the views of all mates concerning this paragraph i much like this
Bepanah video

 Posted 21 months ago
Comment Quote
About PS_1117 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17250 (Level 3) and Parent is 17105
Reply Posted 9/15/2018 6:53:58 PM
Location=-- USA 
Joined=21 months ago   MB Posts=3  
PS_1117
jobhubnet
-- USA

My brother recommended I might like this website. He was entirely right i like it very much.
This post truly made my day. Watch Tv Dramas
You can also try if you like:
https://dastaanmohabbat.com
Try out this:
http://kulfikumar.com
This is also awsome:
https://kasautizindagi.net
Amazing entertainment:
https://kasautizindagiki.net
Try this one:
http://yehmohabbatein.su
This one is amazing
http://kumkumbhagyadrama.com/category/dil-hi-to-hai

 Posted 21 months ago
Comment Quote
About PS_1117 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17251 (Level 4) and Parent is 17105
Reply Posted 9/15/2018 6:54:51 PM
Location=-- USA 
Joined=21 months ago   MB Posts=3  
Anonymous Post
Your post is extremely great and gets a piece of very useful information. keep sharing this post. Keep sharing. I visit again on your website
Old UBB Archived Link: [URL=http://www.mahipalpurgirls.in/]Escorts in Delhi[/URL]

Old UBB Archived Link: [URL=http://www.riyamalhotra.in/]Delhi EscortsService[/URL]

Old UBB Archived Link: [URL=http://www.priyasharma.in/]Call Girl in Delhi[/URL]

Old UBB Archived Link: [URL=http://www.riya-panjaban.in/]Delhi Escort[/URL]
 Posted 6 months ago
Comment Quote

Post ID #17774 (Level 5) and Parent is 17105
Reply Posted 12/21/2019 4:02:11 AM
PS_2450
Delhi Escort
-- USA
Fine way of telling, and pleasant post. With thanks! Valuable information! Useful post, Nice info! Delhi Escorts || Mahipalpur Call Girls || Escort in Delhi || Delhi Escorts Agency || Call Girls in Delhi ||  



 Posted 6 months ago
Comment Quote
About PS_2450 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17776 (Level 1.1)  Reply to 17774 and Parent is 17105
Thread Started 12/21/2019 4:11:19 AM
Location=-- USA 
Joined=6 months ago   MB Posts=4  
PS_2450
Delhi Escort
-- USA



 Posted 6 months ago
Comment Quote
About PS_2450 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17778 (Level 1.2)  Reply to 17774 and Parent is 17105
Reply Posted 12/21/2019 4:11:19 AM
Location=-- USA 
Joined=6 months ago   MB Posts=4  
PS_2450
Delhi Escort
-- USA
 Posted 6 months ago
Comment Quote
About PS_2450 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17775 (Level 6) and Parent is 17105
Reply Posted 12/21/2019 4:10:31 AM
Location=-- USA 
Joined=6 months ago   MB Posts=4  
PS_2450
Delhi Escort
-- USA

Absolutely great. I actually happy when i done this topic. I am excited world have an excellent author.nice sharingEscort in Delhi Delhi Escorts Agency Delhi Escorts

 Posted 6 months ago
Comment Quote
About PS_2450 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17777 (Level 7) and Parent is 17105
Reply Posted 12/21/2019 4:15:00 AM
Location=-- USA 
Joined=6 months ago   MB Posts=4  
papercoach
PaperCoach
-- USA

Don’t know how to write an essay or a term paper? Count on professionals to do these assignments for you. Click now at papercoach.net and get rid of an academic burden.

 Posted 5 months ago
Comment Quote
About papercoach -Collapse +Expand
Visit Profile
Membership pending.
Member does not subscribe to this thread.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17814 (Level 8) and Parent is 17105
Reply Posted 1/14/2020 3:02:52 PM
Location=-- USA 
Joined=5 months ago   MB Posts=1  
Most Recent Post
PS_2569
SEO
-- USA

If you need a limousine for an important occasion, such as a wedding or a client visit, you need to ensure that your service provider lives up to the expectations of the occasion.  https://alternativestips.com/alternatives-of-putlocker

 Posted 51 days ago
Comment Quote
About PS_2569 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #17992 (Level 9) and Parent is 17105
Reply Posted 4/13/2020 12:01:17 AM
Location=-- USA 
Joined=109 days ago   MB Posts=2  
Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P134A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17105 Counter
957
Since 5/9/2018

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech