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 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: programmher
  • Order by date
  1. programmher

    Automatically logging in to another site

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

    form.reload vs. form.submit

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

    Reload and popup focus not working.

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

    Detecting a space, placing variables in text boxes

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

    Detecting a space, placing variables in text boxes

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

    One value needs to appear on two places on my form.

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

    Changing variables

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

    Unsupported property of method error

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

    Unsupported property of method error

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

    Detecting and disabling when a link has been clicked more than once

    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; }...
  11. programmher

    Detecting and disabling when a link has been clicked more than once

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

    Capturing a dynamically changing number records

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

    window.opener.reload(rue) FAILS

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

    Display numbers in descending order

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

    Is, contains, =, and like

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

    Ways to speed up results loading to a form

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

    Defaulting fields in an array to blank

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

    Defaulting fields in an array to blank

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

    Optimizing a stored procedure

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

    Optimizing a stored procedure

    ...varchar(4)= NULL, @CSR_LastName varchar(50)= NULL @CSR_EmpNum int= NULL AS Declare @SQLSTR varchar(2000) select @sqlstr = 'SELECT * from tbl_ClientOrders WITH NOLOCK) where ' IF @Client IS NOT NULL select @sqlstr = @sqlstr + 'Client like ''' + @Client + '%''' + ' and' IF...

Part and Inventory Search

Back
Top