Recent content by FALCONSEYE

I have been looking all over for some samples with CF microservices done with some REST APIs without a framework like coldspring. Any help? Thanks in advance. ColdFusion Ninja for hire.

thread232-1177512 I came across this thread posted a while back. I did a .car deploy from a QA box on my localhost. Then, I couldn't start CF application server. After looking at windows event logs, I noticed some errors. When I looked at coldfusion-out.log file, I noticed the following error...

I am trying to get a historical representation of the previous, current and next team information broken down by start and end dates. Here is the sql fiddle. My output will look like : name | previous team | previous team start date | previous team end date | current team | current team start...

Hello, I am trying to select all the B types within 12 months of each other. Here is the sql to create the table. I need to select all type B s that are within 12 months. In this case, 5,4, and 3. How do I do this? SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO...

Thanks. This does the trick. SELECT u.*, c.*, q.*, a.* FROM tbl_category AS c JOIN tbl_questions AS q ON q.categoryID = c.categoryID CROSS JOIN tbl_users AS u LEFT JOIN tbl_answers AS a ON a.questionID = q.questionID AND a.userID =...

Hello, I have the following tables. I am trying to get a join of these 4 tables where it will list all the questions, answers even if the user didn't answer anything along with user and category. any help? CREATE TABLE [dbo].[tbl_users]( [userID] [int] IDENTITY(1,1) NOT NULL, [firstName]...

Make sure IIS is pointing to the right dir. I am running 9 and 10 side by side. http://www.serverintellect.com/support/iis6/alt-home-dir.aspx hope it helps... ColdFusion Ninja for hire.

i created a test file to include the cfinput within a cfform. copy+pasted your cfc, changed your query, and everything run fine. can you create a test page and hit this cfc directly? ColdFusion Ninja for hire.

i am sure there is a better solution but this one works for now... select distinct branchNumber as num from dbo.branches where branchNumber = 115 union select branchNumber as num from dbo.branches where masterBranch = 115 select distinct branchNumber as num from dbo.branches where...

I have the following table: USE xxx GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[branches]( [branchNumber] [int] NULL, [isSub] [char](1) NULL, [masterBranch] [int] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO insert into branches...

Try the following: var x = document.forms["myForm"]["issuedescription"].value; ColdFusion Ninja for hire.

this problem is solved. off to the next one... ColdFusion Ninja for hire.

:) see person3: he has accID 1 and 5. Your query returns person3 and person4. I need only person4. thanks ColdFusion Ninja for hire.

select * from tmp_p p1 where name not in ( select name from tmp_p where accID = 1 ) and name not in ( select name from tmp_p where accID in (2,10) ) order by p1.name this kind of works but I don't want to use the name field. instead, i want to use the personID field. ColdFusion Ninja for...

I have the following table called tmp_p : CREATE TABLE xxx.TMP_P ( PERSONID NUMBER, NAME VARCHAR2(20 BYTE), ACCID NUMBER ) TABLESPACE xxx PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M...