7 questions
0
votes
1
answer
48
views
Selecting parent records when child mathes criteria
I am trying to limit returned results of users to results that are "recent" but where users have a parent, I also need to return the parent.
CREATE TABLE `users` (
`id` int(0) NOT NULL,
`...
0
votes
1
answer
177
views
While loop for selecting field names?
I have a nasty, nasty data layout that I am forced to work with. I finally got a working query using C# and a for loop executing the same query over and over but adjusting which fields are called, but ...
1
vote
2
answers
801
views
Need Ctree Faircom connection string for Tosca Automation tool
We are trying to establish connection between Tosca and ctree faircom database but it fails to establish the connection.
Getting the following error message:
'Could not establish a connection using ...
0
votes
0
answers
279
views
Get DataTable Value from Adjacent Cell without ForEach loop?
I am working my way around this problem: Create multiple results from single row joining either 2 or 3 tables based off conditional of table1 results? and while I wish I could take Strawberry's advice,...
0
votes
1
answer
125
views
Create multiple results from single row joining either 2 or 3 tables based off conditional of table1 results?
First let me say that yes, this is a horrible way to have stored data, second, it isn't my fault :) I am trying to integrate with a 3rd party database to extract info which is stored in 3 tables, ...
1
vote
0
answers
463
views
Error when exporting the data from FairCom c-tree database (ODBC) into MS Excel
I'm trying to transfer the data from an old .dat file into MS Excel using the ODBC driver for FairCom c-tree database. The data is transfered to Excel, but before import I've received two warning ...
2
votes
1
answer
881
views
FairCom c-tree ODBC Connection - PHP
I have a User DSN configured in Windows ODBC:
Name Driver
testdb FairCom c-tree ODBC Driver
$user = "";
$pass = "";
$dsn = "testdb";
$cx = odbc_connect($dsn,$user,$pass);
if($cx === ...