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 Chriss Miller 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: JohnShell
  • Content: Threads
  • Order by date
  1. JohnShell

    Dynamic HTML table and 3 dynamic radio buttons

    Hi, I have an HTML table dynamically populated with data from a coldfusion query and having radio buttons - see code following below. I need javascript to see the radio buttons and the user's selection - "approved"; "denied"; or, "N/A". If the user selects "approved" for multiple rows and then...
  2. JohnShell

    I'm lost - <cfif> or <cfswitch>

    I do not know which or how to do this. Have lengthy <cfquery> for MS SQL. Have <cfmail> tag to direct results of query to appropriate recipients. Here's query: <cfquery datasource="#Application.DSN2#" name="allinone"> SELECT USER_PIN, USER_LNM + ', ' + USER_FNM AS FullName...
  3. JohnShell

    Date formatting input text box

    Hi, Using CF9 and MS SQL Server 2008. Have a form with JQuery calendar for user date insert. Data submitted onto SQL Srvr database "datetime" column. Have another form with cfgrid (format is html and selectmode is row) and select statement to populate data from SQL Srvr. Using mask in cfgrid...
  4. JohnShell

    Start/End Date validation

    Hi, Want to ensure end date(s) do not precede start date(s). There are 5 text inputs for begin and end dates. They are: startdate1; startdate2; startdate3; startdate4; RCbeginDate; stopdate1; stopdate2; stopdate3; stopdate4; and, RCendDate. Of course, what I have below does not work. Any...
  5. JohnShell

    Simple query for 2 tables

    Quite new to SQL and no idea how to do this. Have two tables: Table 1 is employees: (Column Name), (Data Type), (Allow Nulls) ID, int, no nulls Empname, varchar(50), no nulls team, varchar(10), nulls branch, varchar(5), no nulls position, varchar(2), nulls Table 2 is RAWH: (Column Name), (Data...
  6. JohnShell

    function if statement

    Hi, Have coldfusion textarea and want to insure user makes entry before submit to server processed. I am doing this wrong - any suggestions to correct are greatly appreciated. <script type="text/javascript"> function rationale() { var denInfo = document.getElementById("denialReason")...
  7. JohnShell

    syntax function if statements

    Hi, Do not know how to do this. Using coldfusion. Have cfselect object (id="Decision") with 3 values - Select; Approved; Denied. Have two input buttons, Request Approved (id="approved") and Request Denied (id="denied"). The Approved is visible but disabled. The Denied is not visible. The user...
  8. JohnShell

    cfif and submit

    I do not know how to successfully do this. Have cfselect (id=Decision) with values 0 = -Select-, 1 = Approved, 2 = Denied. Would like to show disabled submit button on form with value Request Approved. Also have another submit button with value of Request Denied which is not visible. If user...
  9. JohnShell

    simple function for a simple man

    Just starting to learn js. Have a hidden text box. Want to enable users to click button to display that text box and click another button to hide instructions. Seems two functions needed but I do not know syntax. For example, function showInstructions() {...
  10. JohnShell

    cfgrid row select

    Hi, Been searching how to do this. Have cfgrid which is populated from database. Want to allow user to select a row and bind other db info to input objects (type=text and/or textarea) with additional info from those fields in the db. The input objects are located under the grid. Is it possible...
  11. JohnShell

    Simple query with GetDate

    Hi, Have table with one column "dateRequested" which is the current date and another column "reqDecision" which is boolean (yes/no or null if not entered). I want to query those columns and get the fields that are the current date minus one day and "reqDecision" equals "null". How is that done...
  12. JohnShell

    Date validations - Rookie here

    Hi, Got input boxes for begin and end dates - using JQuery for date picker calendar for each. Need to validate 2 things - 1 is that end date is => than begin date, 2 is that user enters date into begin date rather than just numbers. I got date picker JQuery from another office where I work and...
  13. JohnShell

    Add alert to function

    Hi, Inserted function to limit amount of characters in a textarea. Want to add alert to that function that informs users they reached input limit - how do I do it? <script language="javascript" type="text/javascript"> function imposeMaxLength(projects, MaxLen) { return(projects.value.length...
  14. JohnShell

    JS function help

    Have the following two functions - first one adds max of 3 rows to a table - one row added each time user clicks button: <script type="text/javascript"> var showing = 0; function showAnother() { if ( showing <= 3 ) { ++showing...
  15. JohnShell

    Show table rows

    Hi, have table with 5 rows. First 2 rodes visible. Last 3 rows hidden - <tr id="row1" style="display: none"> <tr id="row2" style="display: none"> <tr id="row3" style="display: none"> With onclick would like to make those rows visible to user - how can I do that? thank - john
  16. JohnShell

    Phillip AKA Vacunita

    Vacunita, I do appreciate your help. And I am sorry to trouble you again but, I am lost. I know variables must be declared, and arrays rest in memory, but I do not know how or where to place the statements document.getElementById('No_of_Hours1') document.getElementById('No_of_Hours2')...
  17. JohnShell

    js array output recognition

    Hi, Trying to better phrase my question, so here goes. I have 3 functions. I do not know how to have 2 functions recognize the output of an array from the other function. All of this revolves around input(text boxes). What is the array's output? In other words, how do I get the newly added...
  18. JohnShell

    Updating database from JS dynamic table cells

    Hi, I am very new to JS. Do not know how to do this. Have dynamic table with 4 columns. User can add rows - 7 max - and insert data into each cell. First 2 cells use JQuery for calendar - start & end dates. Third cell is select list with 4 values. Fourth cell user inputs number -...
  19. JohnShell

    Check Box coding

    Thank you for you input. Have a spreadsheet customized to user's requirements. Option buttons would be better but user wanted check boxes. Placed some check boxes in frame and others not. Any suggestions on VBA syntax to make check boxes behave like option buttons - only one enabled at a...

Part and Inventory Search

Back
Top