Skip to Content.
Sympa Menu

freetds - RE: [freetds] DB Abstraction Syntax Question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris Hettinger" <chettinger AT encompas.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] DB Abstraction Syntax Question
  • Date: Mon, 25 Aug 2003 08:22:55 -0500

Thanks Freddy,

I will be giving it a better look.


-ch

-----Original Message-----
From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafone.com]
Sent: Monday, August 25, 2003 8:13 AM
To: FreeTDS Development Group
Subject: RE: [freetds] DB Abstraction Syntax Question


>
> Update, Thanks Freddy and others for the help with FreeTDS in
> the past couple weeks. I have finally finished my setup and
> have successfully connected to the MSSQL server and pulled
> data from my test table. :)
>
> Curious if someone could answer a ADODB syntax question for
> me in regards to querying my MS SQL Table.
>
> My table is this:
> (only 1 record)
>
> id fname lname addr1 addr2 city
> state zip
> 1 Chris Hettinger 1000th St. Des
> Moines Iowa 55555
>
> Below is my simple test script:
>
> //
> // Select data
> //
> $sql = "SELECT * FROM chettinger.test_users";
> $rsData = $db->Execute($sql);
>
> if(!$rsData){
> print "<p>Query Failed.";
> }else{
> print "<p>Success.<p>";
> ?>
> Fname: <?= $rsData->fields('1'); ?><br> <-- works
> Lname: <?= $rsData->fields['2']; ?><br> <-- works
> Addr1: <?= $rsData->fields('addr1'); ?><br> <-- doesn't work
> Addr2: <?= $rsData->fields['addr2']; ?><br> <-- doesn't work
> City: <?= $rsData->fields('city'); ?><br>
> State: <?= $rsData->fields('state'); ?><br>
> Zip: <?= $rsData->fields('zip'); ?><br>
> <p>
> <?
> }
>
> My question is about the display of the results... when I
> have worked with MySQL I was used to using the field name to
> reference the result data to display, in this test I can not
> to do this, I can only get the data if I use the array
> pointer. I tried the braket and the paren based on another
> developers recommendation, but it made no difference.
>
> Any one have any thoughts or experience with this?
> Could this be an issue with how the DB driver works when
> pulling the result set?
>

Hi Chris!

Is quite hard to see where the problem reside... There are 3 layers from
your script to db:
- ADODB
- PHP module (what module are you using ?)
- FreeTDS library (what library are you using ?)

All freetds libraries are able to return column names... First check
script. Perhaps it's a problem with case. Try to return a fiels like 'a'
(a single characters) and grab 'a' field and 'A' field. Second try
watching ADODB source.

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


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





Archive powered by MHonArc 2.6.24.

Top of Page