Ask a Question related to ASP Database, Design and Development.
-
Aaron #1
select statement form mutiple data sources
Hello,
I have information in a Access data base and a SQL
database, but i need to be able to create a select
statment which pulls information out of both sources.
Any help????
Aaron Guest
-
One Form, Mutiple Inserts, Multiple Records
I am attempting to create a form which allows multiple record inserts. This will be used to add classes by participant to a training database. The... -
Getting form info into a mysql select statement
Hi, I'd like to get user input from an html form into a mysql select statement. Here's where I'm stumped: $result = mysql_query("SELECT * FROM... -
Mutiple conditions in an if statement
This might seem like a silly question but how do you form an if statement involving 2 conditions within ASP (VBScript) I tried this with no luck:... -
Creating a table using the IXF file format for data exported using a SELECT * statement
Hello, everyone. Which of the following is being kept in the new table? Check constraints Catalog statistics Primary key definitions -
Can a form have two record sources ?
I want to have a form with an overview of data from 4 different queries. How can I have different record sources (ie different query fields) on the... -
John Beschler #2 select statement form mutiple data sources
You should be able to link the SQL tables into your Access
database. Then, you can select from the linked tables.
>-----Original Message-----
>Hello,
>
>I have information in a Access data base and a SQL
>database, but i need to be able to create a select
>statment which pulls information out of both sources.
>
>Any help????
>.
>John Beschler Guest
-
John Beschler #3 select statement form mutiple data sources
Well, yes...and no.
You can not join two tables between seperate databases in
ASP. However, there are at least a couple methods I can
think of to accomplish this - to a degree.
Technically a JOIN handles cases where there are
mismatches between your key fields. Since you can not do a
JOIN in ASP, you will have to handle the exceptions
yourself.
One possible method:
Declare two arrays and use GetRows to populate each array.
Make sure to include the key fields from each table/view
in the appropriate array. Then, you step through your
parent array in code and use the key to find the
corresponding row in the child array.
WARNING! This is not going to be easy!
>-----Original Message-----
>Hello,
>
>Lets say that I do not have not option. Is there anyway
>to do this with code?
>
>>Access>>-----Original Message-----
>>You should be able to link the SQL tables into your>.>>database. Then, you can select from the linked tables.
>>
>>>>.>>>-----Original Message-----
>>>Hello,
>>>
>>>I have information in a Access data base and a SQL
>>>database, but i need to be able to create a select
>>>statment which pulls information out of both sources.
>>>
>>>Any help????
>>>.
>>>
>>
>John Beschler Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
