[phorm] [Phorm:] Need help using dbfetch

From: webbbs@xxxxxxxxx
To: support@xxxxxxxxx
Date: 10 Mar 2004 18:57:26 -0000
The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

*************************************************************************** 

  MESSAGE:  (#3851) Need help using dbfetch 
            <http://www.phorm.com/support/?rev=3851> 
  AUTHOR:   Mike Talvola 
  DATE:     March 10, 2004 at 1:57 p.m. EST 

I'm getting no result and no errors either using dbfetch. The intent is to 
implement a password responder. 

With mySQL database cvuuforg and a table users which contains columns PeopleID 
and UserName, I run the following config [this is only a test case with the 
subject containing the values]: 

$DHost = "localhost"; 
$DUser = "master"; 
$DPass = "thepassword"; 
$DBase = "cvuuforg"; 
$PHORM_MYTABLE = "users"; 
$PHORM_DBFETCH = "PeopleID"; 
$PHORM_DBWHICH = "UserName='$UNAME'"; 

$PHORM_TO = ph_DECLARE; // Send as requested 
$PHORM_SUBJECT = "Password Request for $UNAME with $PHORM_DBFNREC is 
$db_PeopleID"; // The subject of the email message 
$PHORM_FROM = "info@xxxxxxxxx"; 

UNAME from the form is fine, but both $PHORM_DBFNREC and $db_PeopleID are null 
(the mail gets sent just fine, but there aren't values filled in). 

I have registry.php containing the line 
dbopn dbfetch.php 

I've gotta be doing something trivially wrong, but I've fooled around over and 
over and can't get a value. 

*************************************************************************** 

This is an automatically-generated notice.  If you'd like to be removed from 
the mailing list, please visit Phorm Support Forum at 
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx  If 
you wish to respond to this message, please post your response directly to the 
board.  Thank you! 
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing 
list. To send messages to the mailing list, simply send email to 
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe 
from the list by sending email to phorm-request@xxxxxxxxxxxxx with 
'unsubscribe' in the SUBJECT field.
[phorm] [Phorm:] Need help using dbfetch

Other related posts:
