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

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

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

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

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

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

Is there any way to preserve form A's values when I get to it by using a &quot;back&quot; button on form B? I cannot use cookies.

Can anyone tell me why I can retaing my previous pages' values if they are combo boxes but not when any of my values are text?

I have tried using history.back() and history.go(-1) to get to my previous form. I want to retain the variables the user entered on this first page. History.back() and history.go(-1) take me to the previous page; but, the form is blank rather than reflects all the date the user entered. What...

One of my clients might transfer their host to one whose servers support FrontPage and not CF. I am concerned about security. What arguments can I offer in favor of CF over FrontPage? Or, are my concerns unfounded?

Why doesn't this work? I'm trying to get the shipped date to equal the entered date plus 60 days when the entered date is changed. <script language=&quot;JavaScript1.2&quot;> function ChangeDate() { var NewDate = <output>#EnteredDate#</output>; var ANewDate = EDate+60...

Below is my stored procedure: @Client varchar(75), @salesman_lastname varchar(50), @ClientCity varchar(50), @ClientState varchar(4), @CSR_LastName varchar(50) AS SELECT @Client = @Client + '%'...