Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Monday, December 01, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
The ever-powerful ListX module forum. Post your questions, new configuration ideas and reviews.
Forums > Bi4ce.Modules.ListX > General
Subject: Action Execute Problem

You are not authorized to post a reply.   
Author Messages
tduchch
Featherweight
Posts:6
10/02/2008 8:28 AM Alert 
Can someone please explain why this dose not work:

My first two Action items are:

Action Execute Query[rgidQuery] Select rgid from custable where crid=@crid

Action Execute Query[rsidQuery] Select rsid from rgTable where rgid=[rgid,rgidQuery] and rs_svc_id=7

The first query works as I can use this variable in our Format region.

The second query fails saying [rgid,rgidQuery] is an "Invalid Column Name"

I have tried escaping the variable with no success.

Terry
pauldes
Immortal
Posts:1392
10/02/2008 9:03 AM Alert 
You say the first query works, but what does the Tables section of the debug say? How many rows does it return? If = 0 then that's why the second doesn't work.
ListX....makes you look brilliant, even though you're not.
svedire
Cruiserweight
Posts:107
10/02/2008 4:24 PM Alert 
Hi Terry,

You can try to debug and see if the first query is returning any results...

Did you try to execute the same query in your database?

Thanks,
Sindura
R2integrated
tduchch
Featherweight
Posts:6
10/02/2008 9:38 PM Alert 
The first Query works fine.

1 row returned as expected.

I also use the [rgid,rgidQuery] in the Detail section of Format for further processing and am seeing what I expect.

It is only when I use it in the second Action Statement where it appears as though it is not defined yet. Could it be that the second Action item executes before the first item is complete?

Terry
tduchch
Featherweight
Posts:6
10/02/2008 10:03 PM Alert 
Fixed...

It was because the first Action Item had the "Run as Process (Name)" option checked.

TD
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > General > Action Execute Problem


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation