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.