Re: [PHP-DB] stumped-mail and database

2004-12-08 Thread Stuart Felenstein

--- Stuart Felenstein [EMAIL PROTECTED] wrote:

 
 --- Jason Wong [EMAIL PROTECTED] wrote:
 
  
  Also just to be certain that you *are* running
 those
  lines of code change the 
  echo $to, to echo Before $to  echo After $to
 or
  something.
  
Some may remember my problem the other day where I was
trying to create a mail() block using fields from the
database.  Finally figured out my problem. Basically I
needed to declare the recordset / resultset as a
global and move it further up in the script.  Things
are working way better except I still have one issue.
One field is coming from a TEXT column (mysql) I know
there is new line formatting in the text.  I can't get
it to send in the email as the body remains blank.  I
can do both a print_r and echo and it is fine (except
the new lines dissapear) I wonder if it's becasue it's
a text column that I am having this problem.

global $rsVendorJobs;
global $rsRes;
global $rsCL;
$to = $rsVendorJobs-Fields('Conmail');
$subject = $rsVendorJobs-Fields('RefEm');
$body = $rsCL-Fields('LurkCovLet');
$headers = From: [EMAIL PROTECTED];
mail($to,$subject,$body,$headers);

The field that comes up blank in the email is the
$body line. I've tried double quotes in various
places.  Wonder if I'm missing something ?

Thank you
Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Stuart Felenstein

--- Jochem Maas [EMAIL PROTECTED] wrote:

 I just thought, if your query object ($) is
 returning a
 resultset object then maybe you have to 'loop' the
 resultset object
 in order to retrieve the 'row' object(s) from which
 you can retrieve the 
 data.
 

Yes, but the recordset (or resultset) has already been
looped.  Though I did attempt to loop it again within
the mail variable declarations.  Same error message
about call to a member function on non-object.

Here is what's freaking me out ! :)

Anywhere on the page I can do a 
?php echo $rsVendorJobs-fields('Conmail');?

And it will echo out the correct value, 

But! as soon as I do a 
$to = $rsVendorJobs-fields('Conmail');

I get a Fatal error: Call to a member function on a
non-object in /ho

So I tried adding global $rsVendorJobs and that did
absolutely nothing.

Very puzzling.  
Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Jason Wong
On Tuesday 07 December 2004 18:13, Stuart Felenstein wrote:

 Here is what's freaking me out ! :)

 Anywhere on the page I can do a
 ?php echo $rsVendorJobs-fields('Conmail');?

 And it will echo out the correct value,

 But! as soon as I do a
 $to = $rsVendorJobs-fields('Conmail');

 I get a Fatal error: Call to a member function on a
 non-object in /ho

What happens when you do this:

$to = $rsVendorJobs-fields('Conmail');
echo $to;
echo $rsVendorJobs-fields('Conmail');
$to = $rsVendorJobs-fields('Conmail');
echo $to;

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
BOFH Excuse #134:

because of network lag due to too many people playing deathmatch
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Stuart Felenstein

--- Jason Wong [EMAIL PROTECTED] wrote:

 What happens when you do this:
 
 $to = $rsVendorJobs-fields('Conmail');
 echo $to;
 echo $rsVendorJobs-fields('Conmail');
 $to = $rsVendorJobs-fields('Conmail');
 echo $to;
 

Same thing: Call to a member function on a non-object
in..

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Jason Wong
On Tuesday 07 December 2004 19:15, Stuart Felenstein wrote:
 --- Jason Wong [EMAIL PROTECTED] wrote:

Please be explicit, do you mean this what you get?:

  What happens when you do this:
 
  $to = $rsVendorJobs-fields('Conmail');
Call to a member function on a non-object

  echo $to;
Nothing, as $to is undefined (or ill-defined)

  echo $rsVendorJobs-fields('Conmail');
The contents of 'Conmail'

  $to = $rsVendorJobs-fields('Conmail');
Call to a member function on a non-object

  echo $to;
Nothing, as $to is undefined (or ill-defined)


Also just to be certain that you *are* running those lines of code change the 
echo $to, to echo Before $to  echo After $to or something.

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
--
/*
hard, adj.:
 The quality of your own data; also how it is to believe those
 of other people.
*/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Stuart Felenstein

--- Jason Wong [EMAIL PROTECTED] wrote:

 
 Also just to be certain that you *are* running those
 lines of code change the 
 echo $to, to echo Before $to  echo After $to or
 something.
 
Well now I feel like a damn jackass.  I just
discovered something that doesnt fix the issue, yet
reveals the probably cause of the issue.
  
I have this mail block tied into the script as an
after trigger, meaning if the insert transaction is
succesful, then we can proceed with email.  The
transactions have been succesful, but apparently there
is something funky with the trigger. 
When I removed the trigger function - 
to = $rsVendorJobs-Fields('Conmail'); sent me an
email and returned the correct value.  

So I'll now be debugging the trigger function to find
out what is up. The road is never straight.

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Bastien Koert
I prefer to assign the db values to loca variables to ensure that I am 
sending out exactly what I need to.

Bastien
From: Stuart Felenstein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] stumped-mail and database
Date: Mon, 6 Dec 2004 10:05:57 -0800 (PST)
I'm trying to send mail out based partially on a
recordset/binding.
The fields are available but I'm not sure if they need
to be turned into a variable first or if I can just
reference them in the body of the email.
Here is what I tried:
$to = $rsVendorJobs-Fields('Conmail');
$subject = $rsVendorJobs-Fields('RefEm');
$body = '$cl';
$headers = From: [EMAIL PROTECTED];
mail($to,$subject,$body,$headers);
echo Mail sent to $to;
}
K...so you know this didn't work.  I'm googling around
but haven't come up with anything on this subject.
Appreciate some pointers please.
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED] 
 Here is what I tried:
 
 $to = $rsVendorJobs-Fields('Conmail');
 $subject = $rsVendorJobs-Fields('RefEm');
 $body = '$cl';
 $headers = From: [EMAIL PROTECTED];
mail($to,$subject,$body,$headers);
 echo Mail sent to $to;
 }

1) change
$to = $rsVendorJobs-Fields('Conmail');
To
$to = {$rsVendorJobs-Fields('Conmail')};
Or just
$to = $rsVendorJobs-Fields('Conmail');

2) change 
$body = '$cl';
To
$body = $cl;

3) from mail() docs
[this is just for reference, since you're only sending one header it's
probably not a problem]
Note:  You must use \r\n to separate headers, although some Unix mail
transfer agents may work with just a single newline (\n).

Then we'll see where you are from there...

Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-06 Thread Jochem Maas
er, I don't know if it would interest you but here is a class I have 
been using for ages now (not that I have trouble using mail() for simple 
jobs) because its simple, packed with functionality and works well:

http://phpmailer.sourceforge.net/
the following page hopefully demonstrates how simple it is to setup/use:
http://phpmailer.sourceforge.net/extending.html
Norland, Martin wrote:
-Original Message-
...
1) change
$to = $rsVendorJobs-Fields('Conmail');
I suspect that $to would contain something like:
(Object) -Fields('Conmail')
or something even more garbage like (i.e. ),
'complex' $variables in doubled quotes strings should always
be wrapped in curly braces, if only for clarities sake
(if you want to know exactly when they are required then RTFM ;-).
To
$to = {$rsVendorJobs-Fields('Conmail')};
Or just
$to = $rsVendorJobs-Fields('Conmail');
this is the best way - saves some string interpolation.
2) change 
$body = '$cl';
	To
$body = $cl;

3) from mail() docs
[this is just for reference, since you're only sending one header it's
probably not a problem]
Note:  You must use \r\n to separate headers, although some Unix mail
transfer agents may work with just a single newline (\n).
Then we'll see where you are from there...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein

--- Bastien Koert [EMAIL PROTECTED] wrote:

 I prefer to assign the db values to loca variables
 to ensure that I am 
 sending out exactly what I need to.
 


Well the binding is one where clause that pulls the
correct record for the transaction.  Following what
you are saying, how does that actually look ?
Maybe something like this 

$myvar = select field from table where id = 2 ?

Something as simple as that perhaps ?

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein

--- Norland, Martin [EMAIL PROTECTED]
wrote:


 1) change
 $to = $rsVendorJobs-Fields('Conmail');
   To
 $to = {$rsVendorJobs-Fields('Conmail')};
   Or just
 $to = $rsVendorJobs-Fields('Conmail');
 
 2) change 
 $body = '$cl';
   To
 $body = $cl;
 

Well I'm sure this is not the syntax, but since I've
written it both ways I get a :

Fatal error: Call to a member function on a non-object
in /home/xxx/public_html/appjobb.php on line 39

Which I'm guessing means it is written correctly but
now the variable doesn't exist ?

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
What is $rsVendorJobs, where is it populated?  I assumed, from the way
you were using it - that it was a class object with a 'fields' function
that returns the value of a column when passed the column name.  Which,
looking back, seems pretty excessively  abstracted :)

Is $rsVendorJobs just the result of a mysql_query()? If so, you probably
just want to be using:

$to = $rsVendorJobs['Conmail'];

Also note - the case sensitivity may or may not be a problem (you may
need to use 'conmail')
Otherwise, let's see some code to flesh this out!

Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.


-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 06, 2004 1:37 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] stumped-mail and database



--- Norland, Martin [EMAIL PROTECTED]
wrote:


 1) change
 $to = $rsVendorJobs-Fields('Conmail');
   To
 $to = {$rsVendorJobs-Fields('Conmail')};
   Or just
 $to = $rsVendorJobs-Fields('Conmail');
 
 2) change
 $body = '$cl';
   To
 $body = $cl;
 

Well I'm sure this is not the syntax, but since I've
written it both ways I get a :

Fatal error: Call to a member function on a non-object
in /home/xxx/public_html/appjobb.php on line 39

Which I'm guessing means it is written correctly but
now the variable doesn't exist ?

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein

--- Norland, Martin [EMAIL PROTECTED]
wrote:

 What is $rsVendorJobs

It's a recordset which for lack of a better
definition is a sql query.
 
 Is $rsVendorJobs just the result of a mysql_query()?
 If so, you probably
 just want to be using:
 
 $to = $rsVendorJobs['Conmail'];

Nope, though it didn't throw an error, it was blank.
Here is the code. There is actually a transaction that
takes place (insert into database) the email is set up
as an after trigger to the  insert.  I'm leaving the
transaction out. 
 
$query_rsVendorJobs = sprintf(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 =
%s) , $colname__rsVendorJobs);
$rsVendorJobs =
$-SelectLimit($query_rsVendorJobs) or
die($-ErrorMsg());
$totalRows_rsVendorJobs =
$rsVendorJobs-RecordCount();
// end Recordset


%s = the JobID I've selected on the previous page and
passed over with $_POST

Hope this is enough.  Not sure what else to send.

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
All I can recommend from here is heavy use of printr() or var_dump() on
your variables.

 $totalRows_rsVendorJobs = $rsVendorJobs-RecordCount(); // end
Recordset

This clearly means $rsVendorJobs is an object of some sort, probably
some custom recordset object as you've said - so your best bet is to
var_dump it and look through the information you're presented with, to
try and track down what's going wrong or where your data is.

Obviously, also, you'll want to print out the query you're using to make
sure it's actually correct sql/being populated/etc.  Perhaps even run a
var_dump($-SelectLimit($query_rsVendorJobs)) to see just what
result you're getting back, although from your code it should exactly
match a dump of $rsVendorJobs.

Good luck, happy hunting
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein

--- Norland, Martin [EMAIL PROTECTED]
wrote:

 All I can recommend from here is heavy use of
 printr() or var_dump() on
 your variables.
 
They are NULL.  That is the problem.  I can't for the
life of me , figure out a way to initialize these
variables.
 
 Obviously, also, you'll want to print out the query
 you're using to make
 sure it's actually correct sql/being populated/etc. 
 Perhaps even run a
 var_dump($-SelectLimit($query_rsVendorJobs)) to
 see just what
 result you're getting back, although from your code
 it should exactly
 match a dump of $rsVendorJobs.
 
Yeah , the sql is cool  Everything returns as
expected.

Stuart

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED] 
 They are NULL.  That is the problem.  I can't for the life of me ,
figure out a way to
 initialize these variables.

(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($-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($);

Place all of those at the bottom of the script, and I suggest enclosing
them within pre tags, for legibility. (print_r is a slightly more
legible option, but var_dump gives us more information).

- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-06 Thread Jochem Maas
Stuart Felenstein wrote:
--- Norland, Martin [EMAIL PROTECTED]
wrote:

All I can recommend from here is heavy use of
printr() or var_dump() on
your variables.
They are NULL.  That is the problem.  I can't for the
life of me , figure out a way to initialize these
variables.
be more specific - its not at all clear which variables are null?
is your 'recordset' ($rsVendorJobs) actually an object?
if not you have to go into the $-SelectLimit($query_rsVendorJobs) 
call to find out what is going wrong.

Is this the first time you are attempting to use the DB abstraction
objects/classes that your code snippets hint at? if so,
specify exactly what it is, it may help.
also have you checked your error logs?
 

Obviously, also, you'll want to print out the query
you're using to make
sure it's actually correct sql/being populated/etc. 
Perhaps even run a
var_dump($-SelectLimit($query_rsVendorJobs)) to
see just what
result you're getting back, although from your code
it should exactly
match a dump of $rsVendorJobs.

Yeah , the sql is cool  Everything returns as
expected.
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Stuart Felenstein
--- Norland, Martin [EMAIL PROTECTED]
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($-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($);
 
I held off on the vary_dump($);

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) [EMAIL PROTECTED]
[Conmail]= string(18) [EMAIL PROTECTED] [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



RE: [PHP-DB] stumped-mail and database

2004-12-06 Thread Norland, Martin
 var_dump($rsVendorJobs);
 
 object(kt_adorecordset_mysql)(33) { [dataProvider]=

Looks like you're using the ADODB library (
http://www.certicamara.com/consulta/lib/adodb/docs-adodb.htm ) or
similar.  ( That may not be the official site, I just bounced around a
bit. )

All your previous code looks to have been correct, so I'm not really
sure where to go from here.  You may want to look into $ADODB_FETCH_MODE
and see if you can't just get an associative array with your fields
directly out, instead of pulling each little piece out through the
convenience function Fields() (which... doesn't seem to be working).

Not best practice - in fact, extremely BAD practice, but you should be
able to access it with $rsVendorJobs-fields['fieldname'].  Note, of
course, that that's internal structure of their object - and you should
NOT be directly accessing such things.  Still, it will help you check if
you're sane.

I really REALLY don't recommend directly digging into a black box like
this unless you know it will never change, or have some good
documentation area where people will know to look before upgrading.

- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] stumped-mail and database

2004-12-06 Thread Jochem Maas
I just thought, if your query object ($) is returning a
resultset object then maybe you have to 'loop' the resultset object
in order to retrieve the 'row' object(s) from which you can retrieve the 
data.

your resultset object doesn't have a GetRowAssoc() method?
[ defined as GetRowAssoc($upper=true) ]
Norland, Martin wrote:
var_dump($rsVendorJobs);
object(kt_adorecordset_mysql)(33) { [dataProvider]=

Looks like you're using the ADODB library (
http://www.certicamara.com/consulta/lib/adodb/docs-adodb.htm ) or
similar.  ( That may not be the official site, I just bounced around a
bit. )
All your previous code looks to have been correct, so I'm not really
sure where to go from here.  You may want to look into $ADODB_FETCH_MODE
and see if you can't just get an associative array with your fields
directly out, instead of pulling each little piece out through the
convenience function Fields() (which... doesn't seem to be working).
Not best practice - in fact, extremely BAD practice, but you should be
able to access it with $rsVendorJobs-fields['fieldname'].  Note, of
course, that that's internal structure of their object - and you should
NOT be directly accessing such things.  Still, it will help you check if
you're sane.
I really REALLY don't recommend directly digging into a black box like
this unless you know it will never change, or have some good
documentation area where people will know to look before upgrading.
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php