bowtellj
Posts: 65
|
| Posted: 12/08/2007, 6:27 PM |
|
I have created a intranet for work and I use MySQL as the main DS. I now need to pull some employee data from my boss' accessdb named COMPANY and table EMPLOYEES into a grid of asset records.
I have retrieved the ID of the employees into the asset record but cannot get the sql code to work to show the asset records from table intranet.assets and the concat of the employees name from the access db company.employees in a grid.
What would the sql code be to pull data from 2 datasources.
Thanks
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
 |
 |
Oper
Posts: 1195
|
| Posted: 12/09/2007, 8:24 AM |
|
Same server? i mean just 1 connection?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
bowtellj
Posts: 65
|
| Posted: 12/10/2007, 12:35 PM |
|
There are 2 connections. Core_intranet (mysql) and CompanyTables (Msaccess).
_________________
Thanks
James
Just another Newbie! - Apache 2.24, PHP 5.2.3, MySQL 5.0.41, Windows XP SP2. CCS 3.2.0.2/4.0.2
|
|
|
|
Oper
Posts: 1195
|
| Posted: 12/10/2007, 1:49 PM |
|
normaly what i do is before page start at the very begining to the _Event.asp
i get the ID into a Public variable XX_ID
like:
<%
dim XX_ID
XX_ID=ccdlookup(............................,DBCOnnection2)
then during the quiery builder etc on the conection 1
just use EmployedID = XX_ID (expresion)
shoudl work for any language even i use ASP script for the sample.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
