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

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

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

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 have the following CREATE TABLE R_TEST ( PROJECT_ID NUMBER, VERSION NUMBER, READY_DATE DATE, ESTATE_NO VARCHAR2(1 BYTE) ) TABLESPACE vvvvvvvvv PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT...

You know how we could use: dateStamp DATE DEFAULT sysdate to assign a default value to a column in table_x. What if I want to assign a default function? Can I do that? The function will have some values from "table_params" to run some formula including a column named : "base" in table_x...

does anybody know the equation for excel's cumipmt function ? i am trying to convert this to some coldfusion function but i cannot find any details on the equation. thanks. ColdFusion Ninja for hire.

I have the following fields in tblA itemID fieldName fromVal toVal 110 end date 08-JUN-11 10-JUN-11 123 cost 8 9 123 quantity 1 6 157 quantity 4 1 If the field name contains cost or quantity for the same itemIDs, I have to display the result as...

I have the following: select * from categories c, forums f, topics t where c.category_id = f.category_id (+) and t.forum_id (+) = f.forum_id and ( c.is_removed = 0 and f.is_removed = 0 and t.is_removed = 0 ) the mgmt decided not to delete the records and just include a flag. if it's...

I am using jQuery. I am trying to create a unique taskID list based on the selections. Each task may have 2 companies at the most. My problem is the taskID comparison below fails. My code: <script> $().ready(function() {...

There are two inserts in my trigger which is fired by an update. My Vendor_Hist table has a field called thID which is the primary key in Task_History table. thID gets its' value from mySeq.nextval. INSERT INTO TASK_HISTORY ( thID, phId, LABOR, VERSION ) (...

I am trying insert a PK as a FK to another table. Inside my trigger, I have: tmpTHID number; select mySeq.nextval into tmpTHID from dual; insert into tbl1 ( tmpTHID, .... ) insert into tbl2 (id, tmpTHID, ... ) when i change something on tbl2, i get a tbl1 primary key constraint...

I am working on a system to track a project's history. There are 3 main tables: projects, tasks, and clients then 3 history tables for each. I have the following trigger on projects table: CREATE OR REPLACE TRIGGER mySchema.trg_projectHistory BEFORE UPDATE OR DELETE ON mySchema.projects...

I am working on an update/delete trigger on tblProjects. The idea is to keep track of the project's version by keeping a history in tblProjectHistory. I am not quite sure how to do this but this is what I have so far: CREATE OR REPLACE TRIGGER trg_ProjectHistory BEFORE UPDATE OR DELETE ON...

When I try to connect to the cisco vpn client, I get this error: secure vpn: connection terminated locally by the client reason:422 failed to enable virtual adapter I googled this error, and several sites suggested uninstalling/reinstalling cisco vpn client. That didn’t help. Btw, I see the...

I have been thinking about getting a machine with Windows 7 Pro but have couple questions. The sales guy at a local store mentioned that all of my software (runs on Win XP Pro) won't run on Windows 7 (64bit). I don't need to run XP mode on a Windows 7. I want to utilize the 8gig ram that is on...

I am still learning Oracle. I am trying to determine if a given date is less than 2 years from sysdate. Is this a valid statement or is there a better way of doing this? select (to_date(sysdate) - to_date('01/01/2008','dd/mm/yyyy'))/365 yearsBetween from dual; thanks www.fuzzysiberians.com