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

[Chris Hettinger]

It is the syntax for the ADODB abstraction layer I am using, it's a =
method call to Execute (i.e. $qtdb->Execute($sql)), or in $resultset =
<calles> the fields ['lastgenid'] value ...


-----Original Message-----
From: Dave J. Hala Jr. [mailto:dave@58ghz.net]
Sent: Monday, December 15, 2003 10:21 AM
To: PHP List
Subject: Re: [ciapug] Adodb -> mssql, grabbing from a result set


Ok, time for me to ask a silly question.

What does the "->" operator signify?=20

Is this like the linux command line ">" operator?

On Mon, 2003-12-15 at 10:14, Chris Hettinger wrote:
> Those that are familiar with ADODB...
> =09
> 	$sql =3D "SELECT LastGenID FROM QTII_UR.dbo.urlastgenid WHERE userid =
=3D 'encwebtools'";
>         	$rsCaseID =3D $qtdb->Execute($sql);
>=20
> >> Succeeds, Returns 1 record with the value '3281608'
>=20
>         	$caseID =3D $rsCaseID->fields['LastGenID'];
>=20
> $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:
>=20
> 	$caseID =3D $rsCaseID->fields[0]; // still nothing.
>=20
> I have review the Adodb manual, but not sure if I need to do this =
assignment differnet since I am querying a Mssql DB ???
>=20
> -Chris Hettinger, Web Specialist
> -IFMC/ENCOMPASS
> -www.encompas.com
> -(515) 279-8730
>=20
>=20
>=20
> 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.'
>=20
> _______________________________________________
> ciapug mailing list
> ciapug@cialug.org
> http://cialug.org/mailman/listinfo/ciapug
--=20

"...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and =
the Ugly)"

OSIS
Dave J. Hala Jr.
641.485.1606


_______________________________________________
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.'