Weird problem with IFRAME

2012-12-13 Thread Claude Schnéegans
Hi, One of my customers is having a very weird problem with an IFRAME in my site. Here is the code in file mondossier.cfm: IFRAME SRC=monDossierEdit.cfm?type=#type# WIDTH=950 HEIGHT=650 FRAMEBORDER=0 STYLE=position:relative; NAME=admin/IFRAME type is blank With all

Re: Weird problem with IFRAME

2012-12-13 Thread Byron Mann
Think I ran into this before with relative paths without '/' Try ./file.cfm Byron Mann Lead Engineer Architect HostMySite.com On Dec 13, 2012 2:14 PM, wrote: Hi, One of my customers is having a very weird problem with an IFRAME in my site. Here is the code in file mondossier.cfm:

Re: Weird problem with IFRAME

2012-12-13 Thread Claude Schnéegans
Try ./file.cfm Ok, I tried, but it makes no difference. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

SQL Question, incrementing values

2012-12-13 Thread Scott Stewart
Hey all I have a couple of questions with a query that I'm trying to put together What I need as part of this query is a running count of applications that each value of cc_type_id (there's five). I'm trying to do it in the CASE statement below, however if I try to use AS something in order

Re: SQL Question, incrementing values

2012-12-13 Thread John M Bliss
This gives you the error...? CASE WHEN cc.cc_type_ID = 1 THEN @careCB + 1 WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 WHEN cc.cc_type_ID = 4 THEN @careVACC + 1 WHEN cc.cc_type_ID = 5 THEN @careOFCC + 1 ELSE 0 END AS myvar On Thu, Dec 13, 2012 at 3:45 PM,

Re: SQL Question, incrementing values

2012-12-13 Thread Scott Stewart
Except I need those values individually as part of the return.. On 12/13/2012 4:49 PM, John M Bliss wrote: This gives you the error...? CASE WHEN cc.cc_type_ID = 1 THEN @careCB + 1 WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 WHEN cc.cc_type_ID = 4

Re: SQL Question, incrementing values

2012-12-13 Thread Scott Stewart
DOH!! end of the day, yeah... cc.cc_type_id isn't part of a group by or aggregate function.. and I need those end values as part of the returned record set On 12/13/2012 4:49 PM, John M Bliss wrote: This gives you the error...? CASE WHEN cc.cc_type_ID = 1 THEN @careCB + 1 WHEN

Re: Weird problem with IFRAME

2012-12-13 Thread Byron Mann
Is it possible the IFrame src is getting redirected to the root because the user is not logged in? On Thu, Dec 13, 2012 at 4:14 PM, wrote: Try ./file.cfm Ok, I tried, but it makes no difference. ~| Order the Adobe