Search results for query: *

I am using cfhttp to automatically log in to one site from another site. The users see different things depending on their passwords and logins. (Example - jdoe might see one set of options while jsmith would see another set of options). I am using the below cfhttp code to automatically log...

I get this message: self.opener.document.Property.submit() is null or not an object

I've read and unsuccesfully tried the suggestions already posted in this forum. I have two forms. The parent form opens a popup. The popup inserts a record into my database. I need the parent form to reload (in order to show this newly inserted record) AND place the focus BACK to the...

brannon, Thanks a million!!! This worked like a charm!! One last question - is there a way to capture middle names or middle initials? <cfset midName=listMid(fullname, &quot;&quot;)> and <cfset middleName=listMiddle(Fullname, &quot;&quot;)> did not work.

I have a database with names in one field - FullName. How can I detect the space, put everything to the left of the space in field FirstName and everything right of the space in field LastName? Ex: John Doe should be in two separate fields instead of one field. Ex: Lucille MacGillicuddy...

I am passing some values from one form to another like so: window.opener.document.formname.name.value = name; My problem is that I have two places on my original form that I need &quot;name&quot; to appear every time it is changed or selected. I can always get one to appear but not the...

I have to check and change correspondence saluations on a CF form. My parameters are: <cfparam name=SalutationBeg default=&quot;Sir or Maam&quot;> <cfparam name=SalutationEnd default=&quot;Valued Customer&quot;> The user is passing the person's name as form.addressee. I want to create...

oh-ho-ho!!! Now I see!!! Many thanks to all the responses!!!

I am attempting to validate and substitute data for a phone number. If the user attempts to enter an area code other than the valid one, I need to change it. Here is my code: <script> function validate_PhoneNum(){ if (document.MyForm.PhoneNum.charAt(3)== &quot;000&quot;) alert(&quot;strip...

Jeff, Thanks for the script. I got the message; but the page still reloaded. I tried using return false; but it still loaded. <script language=&quot;javascript&quot;> var clicked = false; function doClick() { if (!clicked) { alert(&quot;Clicked!&quot;); return false; }...

I have a link on a page that opens another page. My problem arises when the user accidentally clicks the link more than once. The information from the child form does not pass to the parent form when the link is clicked twice. Below is the code: <script> onload=function(){ var...

I once did this and had the code; but cannot locate it nor fully recreate what I had... I have a query that will return a different number of records. The result might be one reocord, , it might be 30 records, or 100 records, etc. I need to create an array that will add the total associated...

All, I have the above script in an event that successfully works when I test it in my test environment. Below is the entire script: function CloseMe() { window.opener.reload(true) window.close(); } </script> My dilemna is that when I move this code to my live site, my page reloads, but the...

I have a query that returns all our company's employees. I need to show the names in alphabetical order; but show their employee numbers (like 1,2,3,etc) in DESCENDING order - regardless of when they were hired. The display would look like: Adams, Joyce 47 Brown, Henry 46 Is there an...

I have a query that performs very basic functions. I assign variables to represent certain values from two tables. My problem exists within my &quot;where&quot; clause. When I specifically compare any variable with a datatype other than INT, I get an invalid column name. (ex - querying for...

Is there any way to speed up returning results to my form? I execute an SQL in query analyzer and it takes 1 second to execute and return my result. I execute the same query from my CF form and it actually takes less time to execute but several seconds to load the results to my form. Is...

Pcorreia, Thanks a million! I guess I just needed a pair of fresh eyes to see the obvious!

I have a form that could have up to 100 columns (based on what the user selects). I want all but the first 3 columns to default to the word BLANK. My below code is not working for all the fields - only for six fields throughout my entire form. Can anyone tell me why? <cfloop...

Graham, Thanks for the suggestion! I'll give it a try and let you know. Thanks again!

I have a stored procedure that queries a table with over a million records. The table is indexed and does have a primary key. There are several necessary conditions within the procedure. The procedure takes several seconds to execute and return a result to a web form. Is there anything else...