--- "Norland, Martin" <Martin.Norland@xxxxxxxxxx>
wrote:
> (Bear with me on this, because I've got nothing
> remaining to go on...)
> What do you get from:
>
> var_dump($query_rsVendorJobs);
> var_dump($totalRows_rsVendorJobs);
> var_dump($XXXX->SelectLimit($query_rsVendorJobs));
> var_dump($rsVendorJobs); // should match above.
> // If this one is huge - we may want to hold off on
> this one
> var_dump($XXXX);
>
I held off on the vary_dump($XXXX);
The most revealing were:
var_dump($query_rsVendorJobs);
This is just basically the sql statement:
string(513) "SELECT `VendorJobs`.`Contact`,
`VendorJobs`.`Conmail`, CONCAT_WS('-',
`VendorJobs`.`JobID`, `VendorJobDetails`.`OptRefCode`,
`VendorJobs`.`JobTitle`) AS `RefEm`,
`VendorSignUp`.`CompanyName`, `VendorJobs`.`JobID`,
`VendorJobs`.`JobTitle`,
`VendorJobDetails`.`OptRefCode` FROM `VendorJobs`
INNER JOIN `VendorJobDetails` ON (`VendorJobs`.`JobID`
= `VendorJobDetails`.`JobID`) INNER JOIN
`VendorSignUp` ON (`VendorJobs`.`VendorID` =
`VendorSignUp`.`VendorID`) WHERE (VendorJobs.JobID =
10042) "
Yet the JobID is correct so that's a positive
The other var_dump is:
var_dump($rsVendorJobs);
this returned alot. I snipped most of it but if you
look , well if I look, all the fields have the correct
values:
object(kt_adorecordset_mysql)(33) { ["dataProvider"]=>
string(6) "native" ["fields"]=> array(14) { [0]=>
string(12) "Hamas Zwicki" ["Contact"]=> string(12)
"Hamas Zwicki" [1]=> string(18) "stuart4m@xxxxxxxxx"
["Conmail"]=> string(18) "stuart4m@xxxxxxxxx" [2]=>
string(24) "10042-A99839-Entry Clerk" ["RefEm"]=>
string(24) "10042-A99839-Entry Clerk" [3]=> string(13)
"Talman Zwicki" ["CompanyName"]=> string(13) "Talman
Zwicki" [4]=> string(5) "10042" ["JobID"]=> string(5)
"10042" [5]=> string(11) "Entry Clerk" ["JobTitle"]=>
string(11) "Entry Clerk" [6]=> string(6) "A99839"
["OptRefCode"]=> string(6) "A99839" } ["blobSize"]=>
int(100) ["canSeek"]=> bool(true) ["sql"]=>
string(540) "SELECT `VendorJobs`.`Contact`,
`VendorJobs`.`Conmail`, CONCAT_WS('-',
`VendorJobs`.`JobID`, `VendorJobDetails`.`OptRefCode`,
`VendorJobs`.`JobTitle`) AS `RefEm`,
`VendorSignUp`.`CompanyName`, `VendorJobs`.`JobID`,
`VendorJobs`.`JobTitle`,
`VendorJobDetails`.`OptRefCode` FROM `VendorJobs`
INNER JOIN `VendorJobDetails` ON ...[snip]
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
