[phorm] [Phorm:] Re: Need help using dbfetch

  • From: webbbs@xxxxxxxxx
  • To: support@xxxxxxxxx
  • Date: 10 Mar 2004 22:17:12 -0000

The following new message has been posted on Phorm Support Forum at 
<http://www.phorm.com/support/>. 

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

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

  Reply To: (#3852) Re: Need help using dbfetch 
  Author:   Mary Ellen 
  Date:     March 10, 2004 at 2:06 p.m. EST 

Thanks for the troubleshooting tips. I have an environment now to test easily 
in, however I'm still missing something. 

I turned debug72 on, got this: 
DBFETCH: select PeopleID from users where UserName='mikieat' 

If I put that query in with phpMySQL, the response is 1085 which is the 
correct value. 

But, something is wrong when it executes in dbfetch it seems. I also dumped 
$ph_ID and got 
Resource id #7. I don't know internals well enough to know if that is actually 
good, but I assume that since it looks like something real it should be good. 

However, $PHORM_DBFNREC is null after the mySQL call. 

Mike 

> I had nearly the same problem. First, try setting 
> debug72 on. Where you have the other variables 
> declared, add 

> $ph_debug72="true"; 

> this will display the value of the query string sent 
> to dbfetch (I'm assuming you have some sort of ack 
> page that it'll display on. Not sure it'll work 
> otherwise). 

> If that doesn't help you can always include echo 
> statements in the config where you're calling dbfetch 
> from and see what's being passed. 

> My guess is (and this is ONLY a guess based on my 
> exprience) that $UNAME isn't being set before dbfetch 
> is called. 

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

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.

Other related posts: