Re: [DFW CFUG] Related Grid Problem

Wed, 20 Sep 2006 06:54:29 -0700

Basically what I do is that if the person logs in with username 1, the datasource is set to datasourceA. If, on the otherhand, the person logs in with username 2, the datasource is set to datasourceB.  Otherwise, everything in the code is exactly the same.  I have four grids actually.  For purposes of explaining, lets call them grid1, grid2, grid3, grid4.  When a user clicks on grid1, grid2 is filtered. This works correctly.  But when a user clicks on grid2, grid 3 isn't filtering correctly.  Likewise, when a person clicks on grid3, the data in grid4 isn't filtering correctly.  Again, this only happens when I login using and the system uses datasourceB.  Right off hand, one might think the problem is in the database. But, no, there doesn't appear to be any problem in the database either. I went into SQL Enterprise Mgr and ran the queries manually and the correct information comes up.  The databases are exact duplicates in terms of structure.
 
Now this is a quandry...at least for me.
 
Anyone have anymore insight?

----- Original Message ----
From: Mauro Enrique Luna Avelar <[EMAIL PROTECTED]>
To: Dallas/Fort Worth ColdFusion User Group Mailing List <[email protected]>
Sent: Wednesday, September 20, 2006 9:11:35 AM
Subject: RE: [DFW CFUG] Related Grid Problem

Justin,

 

How are you naming your query or queries with both datasources? Is it the same name?

 

Add your code for checking.

 

Try to validate how your queries are working with different grid.

 

De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Justin Cook
Enviado el: Martes, 19 de Septiembre de 2006 02:02 p.m.
Para: CFUG List
Asunto: [DFW CFUG] Related Grid Problem

 

I have a very odd problem. I have two datasources configured to use the same cfml pages. When a user logs in and datasource A is used, my grids are working perfectly, the parent/child relationship works (The bindings work as they should). However, when a person logs in and uses datasource B, the grids don't bind properly. The child grid shows all children instead of just the children related to the selected parent item. I examined my code and the two databases and the data in the database. Now while I admit I may have over looked something, as can happen when you look at your own code long enough...there doesn't appear to be any differences.  Anyone have any ideas whatsoever regarding what I can look at to find a potential problem?

 

Thanks,

Justin

_______________________________________________
Reply to DFWCFUG:
  [email protected]
Subscribe/Unsubscribe:
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
    http://www.mail-archive.com/list%40list.dfwcfug.org/            
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
  www.HostMySite.com
  www.teksystems.com/

_______________________________________________
Reply to DFWCFUG: 
  [email protected]
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.HostMySite.com 
  www.teksystems.com/

Reply via email to