Search results for query: *

Phil AKA Vacunita, Great point - of course js only affects browser side. Altering code accordingly. Many thanks.

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

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

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

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

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

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

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

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

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

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

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

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

Thank you Lyndon - I will try this tomorrow AM. John

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() {...

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

Markros, Many thanks. I will try this tomorrow. John

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

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.

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