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 prob

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 r

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; N

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

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 > 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: Ca

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 r

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($uppe

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

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

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 - it

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:

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

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

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, t

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

2004-12-06 Thread Norland, Martin
: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(&#

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

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

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

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

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 b