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

    Dynamic HTML table and 3 dynamic radio buttons

    Phil AKA Vacunita, Great point - of course js only affects browser side. Altering code accordingly. Many thanks.
  2. 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...
  3. JohnShell

    Date formatting input text box

    Andy, Thank you for the suggestion. Actually I succeeded this way: In my SQL Select statement I "converted" the data thusly, convert(varchar(10),startdate, 101) as BeginDate, convert(varchar(10),stopdate, 101) as EndDate, TypeHrs as TypeofHours, NoOfHours as NumberHrsRequested, projects as...
  4. 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...
  5. 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...
  6. JohnShell

    Start/End Date validation

    Hi, Got some help locally and significantly revamped the above code: //validate entered date values - end date cannot preceed begin date function compareDate(date1,date2) { var endDate = new Date(date2); var startDate = new Date(date1); if(startDate > endDate){return true;} else...
  7. 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...
  8. JohnShell

    Simple query for 2 tables

    Folks, Figured it out and did this: <cfquery datasource="RAWH" name="employee"> SELECT name, team, branch, position, email, ( SELECT E1.email FROM employees AS E1 WHERE E1.team = employees.team AND...
  9. JohnShell

    Simple query for 2 tables

    Bear with me and my limited knowledge Employees table sample data: ID Empname Team Branch Position email 3 Rick Jones NULL VEB bc RJones@ 4 Darlene Washington EET VEB tl DWash@ 6 Andrea Winters EET VEB NULL AWinters@ 7...
  10. 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...
  11. 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")...
  12. 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...
  13. 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...
  14. JohnShell

    simple function for a simple man

    Thank you Lyndon - I will try this tomorrow AM. John
  15. 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() {...
  16. 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...
  17. JohnShell

    Simple query with GetDate

    Markros, Many thanks. I will try this tomorrow. John
  18. 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...
  19. JohnShell

    Date validations - Rookie here

    Thank you, sir, for your offer. However, got the js code to validate and compare dates and am now posting it to coldfusion onsubmit where it will notify users of any errors in their entry/ies.
  20. JohnShell

    Date validations - Rookie here

    Mr. Griffiths, I am looking at the W3schools information and tutorials. That will take a little time to decipher. Appreciate the reference. John

Part and Inventory Search

Back
Top