[ciapug] Adodb -> mssql, grabbing from a result set

[Lathrop Preston]

That is not anything close to what the expected data should be.

have you tried running the query outside of php (ie in the query analizer?

it looks like the query is returning no rows.

try sticking the following between the query execution and
$tmp = $rsCaseID->GetAssoc();

if($rsCaseID === false){ die($qtdb->ErrorMsg()); }

or you can echo instead of die();

Laith

Chris Hettinger wrote:

> If I take the LastGenID and break it out to it's own page, to test it... it works. And I included the var_dump
> 
> $tmp = $rsCaseID->GetAssoc();
> var_dump($tmp);
> 
> here is the output:
> 
> bool(false) 
> 
> 
> -----Original Message-----
> From: Lathrop Preston [mailto:laith@prestonfam.org]
> Sent: Monday, December 15, 2003 12:35 PM
> To: ciapug@cialug.org
> Subject: Re: [ciapug] Adodb -> mssql, grabbing from a result set
> 
> 
> Chris Hettinger wrote:
> 
> 
>>Those that are familiar with ADODB...
>>	
>>	$sql = "SELECT LastGenID FROM QTII_UR.dbo.urlastgenid WHERE userid = 'encwebtools'";
>>        	$rsCaseID = $qtdb->Execute($sql);
>>
>>
>>
>>>>Succeeds, Returns 1 record with the value '3281608'
>>
>>
>>        	$caseID = $rsCaseID->fields['LastGenID'];
>>
>>$caseID is empty... Though my select is succeeding the assignment is not grabbing the value of the field. I have also tried the assignement like this:
>>
>>	$caseID = $rsCaseID->fields[0]; // still nothing.
>>
>>I have review the Adodb manual, but not sure if I need to do this assignment differnet since I am querying a Mssql DB ???
> 
> 
> 
> Try accessing the value as $rsCaseID->Fields('LastGenID');
> 
> I have noticed that sometimes for no apparent reason Fields() will work 
> but fields[] will not and the reverse.
> 
> you might also try doing the following
> 
> $tmp = $rsCaseID->GetAssoc();
> var_dump($tmp);
> to see if maybe there is a case sensitivity issue with mssql
> 
> Laith
> 
> _______________________________________________
> ciapug mailing list
> ciapug@cialug.org
> http://cialug.org/mailman/listinfo/ciapug
> 
> 
> CONFIDENTIALITY NOTICE:  This communication, including any attachment, may contain confidential information and is intended only for the individual or entity to whom it is addressed.  Any review, dissemination, or copying of this communication by anyone other than the intended recipient is strictly prohibited.  If you are not the intended recipient, please contact the sender by reply email, delete and destroy all copies of the original message.'
> 
> _______________________________________________
> ciapug mailing list
> ciapug@cialug.org
> http://cialug.org/mailman/listinfo/ciapug