RE: [KCFusion] problematic variable naming

Mon, 24 May 2004 12:14:40 -0700

Thanks for the suggestion, Bruce, but no beans.

 

Here’s my code:

 

1 <cfstoredproc datasource="somedatasource " procedure="someproc">

2          <cfprocparam dbVarName="somevar" cfsqltype="CF_SQL_CHAR" value="#somevar#">

3          <cfprocresult name="listPrice2">

4  </cfstoredproc>

5

6 <cfdump var="#listPrice2#">

7

8 <table>

9 <tr>

10         <td><strong>Product Number</strong></td>

11         <td><strong>Description</strong></td>

12 </tr>

13 <cfoutput query="listPrice2">

14         <tr>

15                     <td>#listPrice2.['prod #']#</td>

16                     <td>#desctiption#</td>

17         </tr>

18 </cfoutput>

19 </table>

 

 

Line 15 is where I’m running into problems. CFDUMPing the query displays everything just fine, but I can’t seem to get at the column within a CFOUTPUT.

 

Any other suggestions?

 

Thanks,

 

Nate

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Dunwiddie
Sent: Monday, May 24, 2004 11:46 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] problematic variable naming

 

queryname["PROD ##"] should work, or something to that effect. I don't have any cf up and running to test. don't use the evaludate....

 

Bruce Dunwiddie
Ticket Technology
P: 866.543.3331
F: 913.451.1786
[EMAIL PROTECTED]

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Nate Rightmire
Sent: Monday, May 24, 2004 11:46 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] problematic variable naming

I have a stored procedure which returns a recordset with 2 columns: ‘PROD #’ and ‘DESCRIPTION’. For now, I am unable to alter the stored procedure (it is being used by another, non-CF process).

 

How can I access that ‘PROD #’ column? I can’t do it directly, and I haven’t been able to figure out an evaluate() that works.

 

Any suggestions?

 

Thanks,

 

Nate

Reply via email to