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!

  • Congratulations strongm 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: *

  • Users: GCM06
  • Content: Threads
  • Order by date
  1. GCM06

    report

    Hi guys I am using the coldfusion report builder and i'm am trying to create a function that returns a string. when i run the report it doesn't generate. i know the problem is my cfif, b/c i have tried displaying just the string and it works. I have also tried it w/out the # , '' "". Any ideas...
  2. GCM06

    views and max aggreage function

    Hi guys, I am trying to do have the following functions in a view -2.49416 + AGE + max(FTPSA - 0.065867907, 0)**3 - 355.52143 I have the following but it generates an error, any ideas? CREATE VIEW dbo.Calc AS select LoginName,( ResultAny) As Prob from (select LoginName, (-2.49416 + AGE +...
  3. GCM06

    assigning text input value to cfset

    Hi guys, how can I assign a text input value to cfset so that I can use that value in my query what i mean is that so far I have the following. <cfinput type="Text" name="RID" height="0" width="0" value="" bind= "{RequestList.selectedItem.RID}" /> <cfset RID = "RID"> <cfquery name="qAll"...
  4. GCM06

    displaying radio buttons from query

    Hi guys.... I will like to display the users selection from a input that is being stored in a table. I am able to bind text but I am having difficulties displaying the radio and checkboxes selected. <cfformgroup type="repeater" query="qListRequest" name="RequestList" > <cfformgroup...
  5. GCM06

    VIEWS

    hi guys below I have the following code. The problem that I am having is that for totalpts, I will like to get the accumulation but instead I get null values. Any ideas? by the way all the column's data types are ints. CREATE VIEW dbo.Calculate AS SELECT ptage = CASE WHEN age <= 35 THEN...
  6. GCM06

    Coldfusion Report

    I have created a report in coldfusion and will like to know if this report can be send to an ftp site. I heard that this could be possible through scheduling. Is this correct? Thanks in advance, GC
  7. GCM06

    Subreports using stored procedures and parameters

    Hi there, I want to link a subreport to the main report by the parameters that are being used from the store procedure. I link the parameters, but when i run it, the values show up in the main report but not in the subreport. Thanks in advance, Greta

Part and Inventory Search

Back
Top