Search results for query: *

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...

:) I think you should ask specific questions rather than somebody writing the code for you. If you are looking for a freelancer, than it's a different story. hinty hint. ColdFusion Ninja for hire.

I am sorry but you might want to ask more specific questions then a complete code. Why not try to convert some of that php code into coldfusion? Also, google is your best friend. http://woork.blogspot.com/2007/11/simple-5-stars-rating-script-using-ajax.html ColdFusion Ninja for hire.

Yes, please use session vars to store logged in user info. ColdFusion Ninja for hire.

By the way, SQL Server 2005 and on does not utilize DTS anymore. You will need to use SSIS. (SQL Server Integration Services) It has been quite sometime since I actually used this but they are some really cool stuff into this. You can even put vb code in there. Since it's already in there, you...

I think you will need a query to get all the "active" clients. Then you can try the following <cfoutput query="UpDateclient"> <form> ... <tr> <td>Client</td> <td> <select name="client" id="client"> <option value="">select client</option> <cfloop query="getClients">...