Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 27th, 2007, 07:42 AM
Registered User
 
Join Date: Feb 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ceevk1
Default trying to get data from multiple selects

I got a big table (8 rows by 20 fields or more) and lets say in every row there are 2 ID fields.
To explain better I got 8 lines and must check 2 IDs per line
If one of the 2 IDs per line matches my string i want to return from that line X fields.

this happens for all 8 rows. And i want to concetrate the results in one place.

One thought was to do a listbox for every column and associate it with the sql column i want. so after my select it automatically shows my results. but since the above will be seperated to like 16 queries, i can not have them all in the same result set.

any ideas or work arounds? it would really help, i cant think of anything else.

thnx in advance
 
Old April 3rd, 2007, 12:05 PM
Authorized User
 
Join Date: Mar 2006
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Raghunathan
Default

dear friend

can u post the exact structure of the table and query u r trying to execute..
i'll try my level best to solve the problem



Regards,
Raghu





Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Datasets from multiple Data Sources SQL_Hacker Reporting Services 1 June 18th, 2008 02:25 PM
How to combine two value-of selects? myhtpc XSLT 2 February 14th, 2006 06:20 AM
Multiple Selects in SQL QueryStrings doonman BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 6 January 30th, 2006 07:01 AM
multiple selects -single where clause collie SQL Server 2000 3 January 21st, 2005 01:27 AM
Two selects in one procedure Trojan_uk SQL Server 2000 2 December 17th, 2003 05:28 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.