Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FALCONSEYE

    ColdFusion microservices with REST

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

    Error: no known VMs. (check for corrupt jvm.cfg file) !!! How I Fixed It !!!

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

    query question : get previous, current and next teams from 1 table

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

    select records within 12 months of each other

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

    question about a query [ get all null and filled answers by question and category ]

    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 =...
  6. FALCONSEYE

    question about a query [ get all null and filled answers by question and category ]

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

    New coldfusion 10 installation upgrade on coldfusion 8 server running Server 2003

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

    specified CFC could not be found

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

    self join with rank

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

    self join with rank

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

    cfscript and javascript

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

    sql help

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

    sql help

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

    sql help

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

    sql help

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

    How can I create Multiple users in Login/Register Form?

    :) 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.
  17. FALCONSEYE

    Customer rating add on / code

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

    Accessing CFLOGIN Vars

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

    Import Excel to SQLServer - last posted in 2006

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

    Edit page containing DropDowns

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

Part and Inventory Search

Back
Top