[phorm] [Phorm:] DBFetch with multiple records

From: webbbs@xxxxxxxxx
To: support@xxxxxxxxx
Date: 26 Mar 2003 16:49:56 -0000

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

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

  MESSAGE:  (#2438) DBFetch with multiple records 
            <http://www.phorm.com/support/?rev=2438> 
  AUTHOR:   Rich 
  DATE:     March 26, 2003 at 11:49 a.m. EST 

Hi, 

In using DBFetch, I understand how to fetch more than one record and use 
*PHORM_DBFNREC* to know how many records are actually retrieved. However, it 
seems that I can only do this while declaring only one variable like: 

$PHORM_DBWHICH = "ProjNum ='$Proj_Num'"; 

Is it possible to fetch more than one record if I have: 

$PHORM_DBWHICH = "ProjNum ='$Proj_Num' && (File1 = '$File_1' && File1 = 
'$File_2' && File1 = '$File_3')"; 

I also tried: 

$PHORM_DBWHICH = "(ProjNum ='$Proj_Num' && File1 = '$File_1') && (ProjNum 
='$Proj_Num' && File1 = '$File_2') && (ProjNum ='$Proj_Num' && File1 = 
'$File_3')"; 

At any rate, I would like to fetch more than one record where the project # is 
the same, but the file name is different. Also, how would the template know 
which record is which? Use {{PHORM_DBFRSLT[0][File1]}} ?? 

Any help on this, if it is possible to do, would be greatly appreciated. 

Thanks... Rich 

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

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:] DBFetch with multiple records

Other related posts: