Adobe Community : All Content - All Communities

Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Fri, 08 Aug 2014 14:59:52 GMT

Hi everyone. I'm trying to get 2 drop down menus to each have something selected when the form is submitted. I'm using javascript for this, but I can't get it to work. Basically, if one is blank and the other one isn't, I want an error to pop up saying they have to fill in the one that is blank and vice versa. What am I doing wrong? Here's what I have for the javascript and on the form below. My 2 drop down names are Mfg_Spec_Prod_Approval_Initials and Mfg_Spec_Prod_Approval_Rev. Thanks for anyone's help!

Andy

function verify() {

var partNumber = '';

var ecoNumber = '';

var ProdInit;

var ProdInitValue='';

var ProdRev;

var ProdRevValue='';

var allArray = document.getElementById('listofids').value.split(",");

var error=false;

for(var i=0;i<allArray.length;i++) {

ProdRev = document.getElementById('Mfg_Spec_Prod_Approval_Rev'+allArray[i]);

ProdInit = document.getElementById('Mfg_Spec_Prod_Approval_Initials'+allArray[i]);

ProdRevValue = ProdRev[ProdRev.selectedIndex].value;

ProdInitValue = ProdInit[ProdInit.selectedIndex].value;

if(ProdInitValue != '' && ProdRevValue == '') {

error=true;

ecoNumber = document.getElementById('ECID'+allArray[i]).value;

partNumber = document.getElementById('Part_Number'+allArray[i]).value;

alert("You must enter a Rev for ECO " + ecoNumber + " Part Number: " + partNumber);

}

else if(ProdRevValue != '' && ProdInitValue == '') {

error=true;

ecoNumber = document.getElementById('ECID'+allArray[i]).value;

partNumber = document.getElementById('Part_Number'+allArray[i]).value;

alert("You must enter your initials for ECO " + ecoNumber + " Part Number: " + partNumber);

}

if(error) {

return false;

}

else {

return true;

}

</script>

Start of form

<option value="#Initials#"

<cfif #Initials# EQ MfgSpecProdInitials>selected</cfif>>#Initials#</option>

</cfloop>

</select>

</cfif>

</td>

<option value="#Doc_Rev_Initials#"

<cfif #Doc_Rev_Initials# EQ MfgSpecProdRev>selected</cfif>>#Doc_Rev_Initials#</option>

</cfloop>

</select>

</cfif>

</td>

Create mac desktop look inside a swoosh

forums_noreply@adobe.com — Wed, 20 Nov 2013 16:16:12 GMT

I'm trying to get this swoosh in the link below re-created since this image file is not very high res. I'm having a hard time getting that mac desktop background to work inside of this swoosh since it has gradients and dimension to it. Does anyone know how to do this, or to get it to work correctly in Illustrator? I would like to do this in Illustrator since it's going to be part of a logo I am creating. Thanks. Here's the link:

http://s280.photobucket.com/user/gmckfowler/media/NBSSwoosh_final_hires.png.html

Andy

Re-size image on upload

forums_noreply@adobe.com — Thu, 28 Mar 2013 20:38:20 GMT

Hi everyone,

I have created a Blog page on our site and am setting up a page for anyone in the company to update the blog with some text and an image.

Does anyone know how to set up code so when the Browse button is clicked that it will resize the image automatically to what I want it to be with the pixel size and file size? I’m thinking having it be 200 pixels wide and height doesn't matter. Maybe have the file size at 4K or so. It would be like Facebook when you upload a large file image, but it re-sizes it automatically.

We have CF version 7, so I can't use the CFimage code that's in 8 and 9. I've found something called imageCFC.resize(), but I don't understand how to use this or incorporate this into my code.

This is what I have on my pages now just to upload an image file:

Add Page:

Add Action Page:

</cfif>

Insert Into Blog (Blog_Image)

Values ('#file.ServerFile#')

</cfquery>

I then just display the image on my blog page as an image src file.

Thanks.

Andy

logging into an edit page

forums_noreply@adobe.com — Thu, 21 Mar 2013 17:29:09 GMT

Hi everyone,

I have set up a blog page on our site. I created an Add Blog page for engineers to enter the blog info. They choose who to send the info. in an email to have it approved. When the approver receives the email, there is a link they can click on to edit that blog info. When they click update, it approves the blog entry just entered and displays it on the Blog page. I also set up a login page that the engineers and approvers must log into before they can get to the add blog page or edit blog page. I have this working fine to get to the add blog page, but I'm having problems with the edit page. How can I get the link in the email to work correctly to get to the edit page, but having to login first? I've set this code on the add and edit pages:

</CFIF>

This code will not allow someone to just type in the direct link and use these pages. It re-directs them to a login page first. Is there a different way I should be using to get to the login page instead of this code? Once logged in, then they can go to these pages.So when the link in the email is clicked, it re-directs to the login page, but I can't get the login button to go to the edit page because it has to go to a specific edit page with the correct BlogID so it updates the correct information just entered.I can get the link to work in the email just fine without going to the login page. Here's what I'm doing:

This is from the Add page after the engineer adds their info. and it gets emailed to the approver:

<CFMAIL TO="#Users_Email#"

FROM="andy@ironwoodelectronics.com"

SUBJECT="Update Blog Entry">

#Users_First_Name#,

An engineer has uploaded a new Blog entry. Please edit this and approve it. Follow this link:

http://www.ironwoodelectronics.com/blog/edit_blog.cfm?BlogID=#BlogID#

Thank you.

</cfoutput>

</CFMAIL>

</cfif>

</cfloop>

This is on the login page. I thought I would need to say that the BlogID needs to be defined in order to go to the validate page.

</cfif>

This is on the validate page that directs the user to the correct page after they login. I kept the Add page in here to so you can see how that one works fine, but the Edit page doesn't. I could not get the relative path to work at all.

</cfif>

Then it should just go to the edit page to update the information.

SELECT BlogID, Blog_Date, Blog_Info, Blog_Image, Blog_Approval_Initials, Approved_entry

FROM Blog

Where BlogID=#url.BlogID#

</cfquery>

SELECT *

From Blog_Users

where Blog_Initials = 'true'

Order by Initials

</CFQUERY>

Then the items to edit are displayed.

I tried to not include all the code, so hopefully this is enough. If you would need all the pages to see this, I could email them to anyone that could help me. Thanks for your help in advance.

Andy

Require question with checkboxes to be answered

forums_noreply@adobe.com — Tue, 16 Oct 2012 14:22:55 GMT

Hi.

I have some questions on a form and I want to require that they all be answered with something. I have some Cold Fusion code that puts a requirement on some of the questions, so if they don't answer it and they click submit, a pop up will display telling them they have to answer question 3 for example. Here's waht I have on one of the questions that has radio buttons:

<cfinput type="radio" name="Current_Project" value="yes" required="yes" message="Please answer question 2.">Yes

<cfinput type="radio" name="Current_Project" value="no">No

How can I do this on a question that has checkboxes since multiple ones can be checked? Each checkbox is a different name also. That's the problem. If they were all the same, it would be easy to code this. But they each need to be a seperate name because that's how I have them in the database. If I put the require code on each checkbox, the form will not go through until all the checkboxes are checked. I don't want that becasue the user needs to be able to choose their choices for that question and maybe only have 1 or 2 answers. Can I do this with Cold Fusion, or do I need to do javascript with these? Does anyone know how to do this? Thank you.

Andy

Update date field to a Null

forums_noreply@adobe.com — Fri, 05 Oct 2012 19:42:27 GMT

Hi everyone,

I have a web page called Quality that has mulitple records on it with multiple people logged into it at the same time updating it.I’m trying to update a date on one field, and it works, but then if I try to clear it out and update it, it doesn’t update it to a Null. When I put in the code to try and update it as a Null in the Update Query, it puts a date of 1/1/00 in the field for some reason and also updates the other blank fields to this date. I have something to account for the Nulls on the drop downs in my other fields. The code I used for those was like this in the Update Query:

Set Approval_Initials = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Evaluate('form.PDF_Creation_Doc_Control_Approval_Initials#id#')#" null="#NOT len(trim(Evaluate('form.PDF_Creation_Doc_Control_Approval_Initials#id#')))#" />

Do I have to use something like this again for the Date field except with the CF_SQL_DATE tag? Below is what I have for the Date field right now:

Update Approval

Set Approval_Date = '#Evaluate("form.Quality_Date#id#")#'

WHERE APV_ItemID = #id# AND Document_Type = 'Quality'

</cfquery>

</cfif>

Is this enough information? What does the CF_SQL_DATE do exactly? Any help would be greatly appreciated.

Andy

Resizing images automatically with Browse button

forums_noreply@adobe.com — Fri, 14 Sep 2012 17:41:34 GMT

Hi,

I have created a Blog page on our site and am setting up a page for anyone in the company to update the blog with some text and an image. What I would like to do is resize the image automatically to what I want it to be with the pixel size and file size. I found a web site that does this, but I would like to have this code on my own web site. Here it is:

http://www.resizemypicture.com/

Does anyone know how to set up code so when the Browse button is clicked that it will resize the image automatically to what I want it to be with the pixel size and file size? I’m thinking having it be 120 pixels wide by 86 pixels high at 4K file size. It would be like Facebook when you upload a large file image, but it re-sizes it automatically. Is there some code out there I could use? Or would we have to purchase that? Is it hard to set up? Thanks.

Andy

Edit page

forums_noreply@adobe.com — Tue, 14 Aug 2012 19:19:51 GMT

Hi,

I came across another problem I was having on my edit page I am creating. I have a field called Open_Jobs_Affected_Date. For some reason, on this edit page, it would not let me have this field named like this. I kept getting this error:

Form entries incomplete or invalid

3/1/12

So I decided to change the name of my field and see what would happen. I just changed it to Open_Jobs_Affected_2Date and it worked. I found something online that it’s looking at the “_date” part and it tries to validate the form field as being a valid date time value.

Does anyone know if there is a different way around this? I really don’t want to have to change my field name. I would have to change it on all the other pages I’ve used it on then. Can I use something like these around it: [] or something similar somehow?

Andy

Release Initials on edit action page

forums_noreply@adobe.com — Thu, 09 Aug 2012 18:53:24 GMT

Hi,

I have an edit page that I'm trying to update all the info. in my database. I have multiple tables with all this info. and am having a problem getting the Release Approval Initials from the Approvals table to display on an action page.

I was able to figure out how to get the Release Approval Initials to display on the edit_all_ec_number_action.cfm page, but I’m having a problem getting them to display on the docs_to_be_removed_all_action.cfm page. This is one page further past the original action page.

Basically, on the edit page, if “i” is chosen for the Docs to be removed from P Drive drop down menu, it will go to the action page and display the info. entered, but I have some code that intercepts this first, to enter the Docs to be removed. Then, once you click update on this page, it goes to the docs_to_be_removed_all_action.cfm page. This is the page where I’m having a problem getting the Release Approval Initials to display. How am I supposed to pass them from the edit_all_ec_number_action.cfm page to this action page? This is what I have on the edit page:

SELECT *

FROM Approval

WHERE Approval.APV_ItemID = #url.ItemID#

</cfquery>

SELECT ECID, Requested_By_Initials, EC_Completion_Initials, EC_Completion_Date, Flag_Comments, Comments, ItemID, ECID_SPEC, ECO_Start_Date, Date_Requested, Requested_By_Initials, Part_Number, Description, CN_Entry, P_Drive_Docs, Dismiss_Part_Number, Release_Status, Validation_ItemID, Validation_ECID, Validation_Qty, Docs_to_remove, SW_Model_Only, PNR_BOM_Change_Only, Doc_Changes_Only, Doc_Removal_Date,

Approval_Release.Approval_Initials as Release_Initials

FROM ECO_Master LEFT JOIN ECO_Items ON ECO_Master.ECID = ECO_Items.ECID_SPEC

LEFT JOIN Validation_Records ON ECO_Items.ItemID = Validation_Records.Validation_ItemID

LEFT JOIN Approval ON ECO_Items.ItemID = Approval.APV_ItemID

LEFT JOIN Approval as Approval_Release ON ECO_Items.ItemID = Approval_Release.APV_ItemID AND Approval_Release.Document_Type = 'Release'

Where ItemID=#url.ItemID#

ORDER BY ItemID

</CFQUERY>

<tr>

<td class="edit" align="right">Release Initials:</td>

<option value="#Initials#"

<cfif Initials EQ ReleaseInitials>selected

</cfif>>#Initials#</option>

</cfloop>

</select>

<font color = "red">The Approval for this has not been filled out.</font>

</cfif>

</td>

</tr>

This is what I have on the edit_all_ec_number_action.cfm page to get the initials to pass to the next action page:

</cfif>

Then on the docs_to_be_removed_all_action.cfm page, I have this to output the Initials, but it doesn’t display anything. It says the Variable ID is undefined.

<cfif isDefined ("form.Release_Approval_Initials#id#") and

"form.Release_Approval_Initials#id#" neq "">

#Evaluate("form.Release_Approval_Initials#id#")#

</cfif>

Does anyone have any ideas what I can try? Thanks.

Andy

Cookie login

forums_noreply@adobe.com — Wed, 25 Jul 2012 19:42:35 GMT

Hi,

I was just wondering how to get my text box on my login screen to remember my username when I come back to it? I'm thiking I need some sort of cookie. I want it to be as simple as possible. Below is what is on my login screen now. Does someone know how I can do this? Thanks.

Andy

<html>

<head>

<title>Ironwood Electronics Member Login</title>

function rfqlogin()

{

document.foo.rfq_login.value="yes";

document.foo.eco_login.value="no"

document.foo.action ="validate.cfm";

document.foo.submit();

}

function ecologin()

{

document.foo.eco_login.value="yes";

document.foo.rfq_login.value="no";

document.foo.action ="validate.cfm";

document.foo.submit();

}

</script>

</head>

<body>

--->

<tr>

</tr>

<tr>

</tr>

<tr>

<cfform name="foo"  method="post" onSubmit="return validate()">

</tr>

<td align="left">Password: <input type="Password" name="password" maxlength="14" size="12"></td></tr>

<span class="error">#url.message#</span>

</td></tr>

</CFOUTPUT>

</CFIF>

<tr>

<td>

</td>

<tr>

<td>

</td>

</tr>

<tr>

</cfform>

</td>

</tr>

</table>

</body>

</html>

Using wildcard in If statement

forums_noreply@adobe.com — Tue, 05 Jun 2012 21:15:41 GMT

Hi. I have 2 part numbers I'm trying to find and I just want to display the text below on these 2 parts only. The 2 part numbers are:

PL-PLCC44-S-01TR

PL-PLCC68-S-01TR

This is not on a search page, so the Like command does not work.I created this If statement and when I put the whole part number in the quotes, it works fine, but I want to use a wildcard since there will be more parts like this and I will not want to keep adding parts to this If statement.So basically, I'm trying to search for all the part numbers that end in TR. If they do, display the text below on the page. How can I use these wilcards correctly?

<cfif ThisPart.Client_SKU EQ "%TR">Min. buy of 50pcs is required.</cfif>

Thanks.

Andy

Simple Default value for drop down menu

forums_noreply@adobe.com — Fri, 11 May 2012 20:42:51 GMT

Does anyone know why this would be happening?

I have a drop down menu on my Quality page for PDF_Creation_Doc_Control_Approval_Initials (I’ll shorten this to Doc Initials so you know what I’m talking about). Right now it is defaulted to be blank if nothing has been chosen for it yet. If initials are chosen, the initials will display when the page is loaded. The problem I’m having is that I want the “None” option to display as the default if the SW_Model_Only is 1. I’m just trying to get “None” to be the default for these. The code below does work if I hit the refresh button, but it does not work when I just click on the Quality link. Why would this be? How do I fix it? Below is the code for this drop down on the Quality Page. I added this If Statement:

</cfif>

The option value="" was already there.

</cfif>

<option value="#Initials#"

<cfif #Initials# EQ PDFCreationDocControlInitials>selected</cfif>>#Initials#</option>

</cfloop>

</select>

</cfif>

</td>

Thanks for your help.

Andy

Freeze top header row in HTML table like in Excel

forums_noreply@adobe.com — Wed, 09 May 2012 20:51:21 GMT

Hi,

I have some results pages that display info. in some large tables in my cold fusion pages. I was just wondering, is there a way I can freeze the header top row and scroll all the other rows, just like in an Excel file? Or would the only way to make that work correctly is by having frames?

Andy

Requests Limit in Access

forums_noreply@adobe.com — Mon, 12 Mar 2012 17:56:49 GMT

Does anyone know if the amount of requests Access can handle at one time is 10 or not? Since Thurs., our web site has been crashing a lot and we think it might be from the amount of traffic we're getting and Access can't keep up, or that Access is limited to only 10 requests at a time. Is there a way to change this limit?

We have 3 Access databases we're using with Cold Fusion. We're thinking that all the requests are adding up and Access just can't handle everything at once. Everyone within our company uses 2 of the databases and the 3rd one is our web site. Search engines seem to keep making requests to our web site all day long. When you add up all these requests, it's probably over 10 for sure at a time.

Has anyone experienced this before? We've been told to switch over to SQL instead of Access. Hopefully this would solve everything and the server wouldn't crash anymore.

When I created my last database called, ECO Register, I remember creating it in Access 2007 and I saved it as .accdb extension, but I could not get connected to it in the Cold Fusion Administrator, so I made it .mdb instead. If our Access databases were the newer version, could that maybe handle more requests at one time? Or do we have to install a newer driver for Access on Cold Fusion to handle more requests? I did see in the Adminstrator page there is a Microsoft Access driver type and a Microsoft Access with Unicode driver type option. What are the differences? I see that we have an SQL driver type in the Administrator page. Do we have to do a lot of set up to make that work? Or do I just connect my Access database to that SQL driver and then update the pages to use SQL?

If anyone could help me out, that would be great. Thanks.

Andy

Not Equal to

forums_noreply@adobe.com — Fri, 24 Feb 2012 20:41:20 GMT

Hi. I'm just trying to get some rows to not show up on my display page that have a "D" in the Dismiss_Parts column. This is what I have in the Query to do this:

And Dismiss_Parts <> 'D'

It removes the rows with the D in them, but it also removes all the other rows. Does anyone know why this would be, or if there is anything else I can try to make it not equal to a "D"? I've tried NEQ, <>, and Not Like, but nothing works.

Thanks.

Andy

1 form with 2 buttons to go to 2 different pages

forums_noreply@adobe.com — Mon, 23 Jan 2012 19:48:54 GMT

Hi. I have 1 form I'm using on a page for adding some information. I have an Add button at the bottom that goes to an action page that inserts the data into an Access Database and displays what was inserted. I want to use the same form, but I want to have another button that goes to a different page, but still inserts the data into the database. How do I do this? Below is what I have for the beginning of the form and the button I click on to add it to the database. I won't put all the stuff inside the form so I keep this concise.

Andy

Login Screen

forums_noreply@adobe.com — Mon, 16 Jan 2012 15:41:59 GMT

Hi. I had a login screen with a username and password, which also included checking off a check box of the initials of the user logging in. This would get them to the next screen of information. On Fri., we decided we do not need the user to check off their initials anymore, so I removed them. I can log in just fine on Firefox and Chrome, but for some reason, I cannot log in on Explorer at all. I'm using IE 8. It does not go to the next page after I hit the log in button. I'm not sure why. After the submit button is hit, it does go to a validation page I have set up to make sure the user exists. This page also has a javascript on it to go to a company search page once the user is checked and exists. Here's the javascript I'm using:

self.location='../RFQLOG/company_search.cfm';

</script>

Would this be the problem with why the log in screen does not get me to this page? Or what else could I be doing wrong? It was working fine with the checkboxes, so this really confuses me. Any help would be greatly appreciated. Thanks.

Andy

Creating a form submission

forums_noreply@adobe.com — Thu, 05 Jan 2012 18:49:33 GMT

Hi.

I was just wondering how do I submit a simple form on a web page? I know how to creat the form with text boxes to fill for a name, email, etc, but how do I actually get the form to submit? I have a godaddy account and I think I can do it with a PHP script. Do I have to use some kind of script, or can I just make the form submit without a script? I saw somewhere that there is a free script. Is this what I need: http://www.mindpalette.com/scripts/index.php#PFAnchor

Any help would be greatly appreciated. All I need is for it to be really simple. Thank you.

Andy

Comments field does not accept apostrophe

forums_noreply@adobe.com — Wed, 09 Nov 2011 19:04:03 GMT

Does anyone know why my Comments field will not accept an apostrophe? It's just a memo field in Access. I have this same field in my other databases and it works fine with apostrophies. Here's what I have for the code on the first page:

<textarea name="Comments#ItemID#" cols="38" rows="2">#Trim(Comments)#</textarea>

Here's the code I have on the action page that inserts the Comments field into the database:

Update ECO_Items

Set <cfif isDefined("form.Comments#id#") and evaluate("form.Comments#id#") neq "">

Flag_Comments = #Evaluate("form.Flag_Comments#id#")#,

Comments='#Evaluate("form.Comments#id#")#'

Flag_Comments = '',

Comments = ''

</cfif>

Where ItemID=#id#

</cfquery>

This inserts text, periods, commas, etc., and blank info. into the Comments field, but when I put an apostrophe in some text such as "It's fixed", it will not insert that. What would be causing this? How do I fix it?

Thanks.

Andy

Require both drop downs to be equal

forums_noreply@adobe.com — Wed, 09 Nov 2011 15:15:37 GMT

Hi. I have 2 drop downs per row of data that are for PNR and BOM initials. I want each row with both of these drop downs to match when submitted. If they don't, an error pops up saying that they have to match if there's something chosen in each drop down. I also have another column to tell if the part is a Change or New Entry by populating it with a "C" or an "N". When the part is an "N", the PNR Initials can be chosen and the BOM initials can be blank and it will go through fine. If it's an "N" and the BOM Initials are chosen and the PNR Initials are blank, an error pops up saying that the PNR Initials have to be chosen.

When the part is a "C", there are no restrictions, other than if there are initials chosen in each drop down, they have to match. It doesn't matter if one or the other is left blank.

I almost have all this working with Javascript, except that when just an "N" is on the page and initials are chosen for each column that don't match, the error pops up, which is good, but then when I click ok, it goes through and inserts the initials into the database. Why is that?

I also have a problem when there are just "C" part numbers on the page, the javascript does not work at all. No errors stop the 2 drop down initials from being entered when they don't match. There has to be an "N" on the page for the code to work at all. When this javascript was first created, it was just for the "N" part numbers, but then we wanted all the rows to have the code for the initials matching each other, so I added this code to the existing code and I have these problems now. Should I have created another javascript? The only problem is the onsubmit says this: onsubmit="return verify();" So I can't name another javascript file with the same name, can I, or can I?

There's some code towards the bottom that says if the Change or New Entry column is an "N" or "C", to do some stuff. I have attached the whole page of code, so you can see exactly what I'm talking about. Can someone help me with this? Thanks.

Andy

</center>

</table>

SELECT *

From Users

where Engineer_Initials = yes and Initials <> '#cookie.UserInitials#'

Order by Initials

</CFQUERY>

SELECT ECID, Requested_By_Initials, EC_Completion_Initials, EC_Completion_Date, Flag_Comments, Comments, ItemID, ECID_SPEC, ECO_Start_Date, Date_Requested, Part_Number, Description, P_Drive_Docs, Release_Status, Validation_ItemID, Validation_ECID, Validation_Qty, Open_Jobs_Affected, CN_Entry, SW_Model_Only,

Approval_PNR.APVID as PNR_APVID,

Approval_BOM.APVID as BOM_APVID,

Approval_PNR.Approval_Initials as PNR_Initials,

Approval_BOM.Approval_Initials as BOM_Initials,

Approval_PNR.Doc_Rev as PNR_Rev,

Approval_BOM.Doc_Rev as BOM_Rev

FROM ((((ECO_Master LEFT JOIN ECO_Items ON ECO_Master.ECID = ECO_Items.ECID_SPEC)

LEFT JOIN Validation_Records ON ECO_Items.ItemID = Validation_Records.Validation_ItemID)

LEFT JOIN Approval as Approval_PNR ON (ECO_Items.ItemID = Approval_PNR.APV_ItemID AND Approval_PNR.Document_Type = 'PNR Req'))

LEFT JOIN Approval as Approval_BOM ON (ECO_Items.ItemID = Approval_BOM.APV_ItemID AND Approval_BOM.Document_Type = 'BOM Req'))

WHERE Requested_By_Initials = '#cookie.UserInitials#'

AND EC_Completion_Date Is Null

And SW_Model_Only = 0

And Doc_Changes_Only = 0

And ((Approval_PNR.Approval_Initials Is Not Null And Approval_PNR.Approval_Initials <> '' And (Approval_PNR.Doc_Rev Is Null Or Approval_PNR.Doc_Rev = '') And Approval_BOM.Approval_Initials Is Not Null And Approval_BOM.Approval_Initials <> '' And Approval_BOM.Doc_Rev Is Not Null And Approval_BOM.Doc_Rev <> '')

Or (Approval_PNR.Approval_Initials Is Not Null And Approval_PNR.Approval_Initials <> '' And (Approval_PNR.Doc_Rev Is Null Or Approval_PNR.Doc_Rev = ''))

Or (Approval_BOM.Approval_Initials Is Not Null And Approval_BOM.Approval_Initials <> '' And (Approval_BOM.Doc_Rev Is Null Or Approval_BOM.Doc_Rev = '') And Approval_PNR.Approval_Initials Is Not Null And Approval_PNR.Approval_Initials <> '' And Approval_PNR.Doc_Rev Is Not Null And Approval_PNR.Doc_Rev <> '')

Or (Approval_BOM.Approval_Initials Is Not Null And Approval_BOM.Approval_Initials <> '' And (Approval_BOM.Doc_Rev Is Null Or Approval_BOM.Doc_Rev = ''))

Or ((Approval_PNR.Approval_Initials Is Null or Approval_PNR.Approval_Initials = '') And Approval_PNR.Doc_Rev Is Null And (Approval_BOM.Approval_Initials Is Null or Approval_BOM.Approval_Initials = '') And Approval_BOM.Doc_Rev Is Null))

ORDER BY ECID ASC, ItemID ASC

</CFQUERY>

<head>

<title>Select Engineer for PNR/BOM Approvals</title>

function verify() {

var partNumber = '';

var ecoNumber = '';

var bom;

var bomValue='';

var pnr;

var pnrValue='';

var requiredArray = document.getElementById('PNR_Required_ID_List').value.split(",");

var allArray = document.getElementById('listofids').value.split(",");

var sameArray = document.getElementById('Same_Required_ID_List').value.split(",");

var allArrayInit = document.getElementById('listofids').value.split(",");

var error=false;

for(var i=0;i<requiredArray.length;i++) {

pnr = document.getElementById('PNR_Approval_Initials'+requiredArray[i]);

bom = document.getElementById('BOM_Approval_Initials'+requiredArray[i]);

pnrValue = pnr[pnr.selectedIndex].value;

bomValue = bom[bom.selectedIndex].value;

if(bomValue != '' && pnrValue == '') {

error=true;

ecoNumber = document.getElementById('ECID'+requiredArray[i]).value;

partNumber = document.getElementById('Part_Number'+requiredArray[i]).value;

alert("You must enter some PNR initials for ECO " + ecoNumber + " Part Number: " + partNumber);

}

if(bomValue != pnrValue && bomValue != '') {

error=true;

ecoNumber = document.getElementById('ECID'+requiredArray[i]).value;

partNumber = document.getElementById('Part_Number'+requiredArray[i]).value;

alert("PNR and BOM Initials must be the same for ECO " + ecoNumber + " Part Number: " + partNumber);

}

for(var i=0;i<allArray.length;i++) {

pnr = document.getElementById('PNR_Approval_Initials'+allArray[i]);

bom = document.getElementById('BOM_Approval_Initials'+allArray[i]);

pnrValue = pnr[pnr.selectedIndex].value;

bomValue = bom[bom.selectedIndex].value;

}

for(var i=0;i<sameArray.length;i++) {

pnr = document.getElementById('PNR_Approval_Initials'+sameArray[i]);

bom = document.getElementById('BOM_Approval_Initials'+sameArray[i]);

pnrValue = pnr[pnr.selectedIndex].value;

bomValue = bom[bom.selectedIndex].value;

if(bomValue != pnrValue && pnrValue != '' && bomValue != '') {

error=true;

ecoNumber = document.getElementById('ECID'+sameArray[i]).value;

partNumber = document.getElementById('Part_Number'+sameArray[i]).value;

alert("PNR and BOM Initials must be the same for ECO " + ecoNumber + " Part Number: " + partNumber);

}

for(var i=0;i<allArrayInit.length;i++) {

pnr = document.getElementById('PNR_Approval_Initials'+allArrayInit[i]);

bom = document.getElementById('BOM_Approval_Initials'+allArrayInit[i]);

pnrValue = pnr[pnr.selectedIndex].value;

bomValue = bom[bom.selectedIndex].value;

}

if(error) {

return false;

}

else {

return true;

}

</script>

<!--- This works above in the brackets, but not here on it's own after the Change Value code.

if(bomValue !== pnrValue) {

error=true;

ecoNumber = document.getElementById('ECID'+requiredArray[i]).value;

partNumber = document.getElementById('Part_Number'+requiredArray[i]).value;

alert("PNR and BOM Initials must be the same for ECO " + ecoNumber + " Part Number: " + partNumber);

} --->

</head>

<body>

<tr>

#cookie.UserInitials#- Select Engineer for PNR/BOM Approvals

</center>

</td>

</tr>

</table>

<tr>

<!--- <td><B>APVID - PNR</B> </td>

<td><B>APVID - BOM</B> </td> --->

<td><B>Part Number </B></td>

<td align="center"><B>Change or<br>new entry</B></td>

<td align="center"><B>PNR<br>Initials</B></td>

<td align="center"><B>BOM<br>Initials</B></td>

<td align="center"><B>Open Jobs Affected</B></td>

<td align="center"><B>Comments</B></td>

</tr>

<tr>

</td>

</tr>

</td></tr>

</cfif>

<tr>

<td>

<font size = "5" color=dd0000><strong>#Flag_Comments#</strong></font>

</cfif>

</td>

#ECID#

</cfif>

</td>

#Part_Number#

</cfif>

</td>

#CN_Entry#

</cfif>

</td>

<option value="">PNR Initials</option>

<option value="#Initials#" <cfif Initials EQ PNRInitials>selected</cfif>>#Initials#</option>

</cfif>

</cfloop>

</select>

</td>

#PNR_Rev#

</cfif>

</td>

<option value="">BOM Initials</option>

<option value="#Initials#" <cfif Initials EQ BOMInitials>selected</cfif>>#Initials#</option>

</cfif>

</cfloop>

</select>

</td>

#BOM_Rev#

</cfif>

</td>

<td>

</cfif>

</td>

<td>

<textarea name="Comments#ItemID#" cols="38" rows="2">#Trim(Comments)#</textarea>

</td>

</tr>

</cfif>

</cfif>

</cfloop>

<tr>

</td>

</tr>

</table>

</cfform>

</table>

</div>

</body>

</html>

</cfoutput>

select Drop-Down List item Based On Text Field not being empty

forums_noreply@adobe.com — Tue, 01 Nov 2011 20:39:45 GMT

Hi. I have some javascript code to click on a button and it will insert the date into a text box called "Controller_PDF_Creation_Doc_Control_Date" on my form. I also have a drop down menu called "Release_Approval_Initials". All I'm trying to do is when there is a date entered into the text box, I want the "Release_Approval_Initials" drop down menu to default by selecting the option "TM". The drop down menu is dynamically populated too. How can I do this? Below is the code that I have.

function verify() {

var partNumber = '';

var ecoNumber = '';

var pdfDate;

var queue;

var queueValue='';

var allArray = document.getElementById('listofids').value.split(",");

var error=false;

for(var i=0;i<allArray.length;i++) {

pdfDate = document.getElementById('Controller_PDF_Creation_Doc_Control_Date'+allArray[i]).value;

queue = document.getElementById('Release_Approval_Initials'+allArray[i]);

queueValue = queue[queue.selectedIndex].value;

if((pdfDate != '' && queueValue == '') || (pdfDate == '' && queueValue != '')) {

error=true;

ecoNumber = document.getElementById('ECID'+allArray[i]).value;

partNumber = document.getElementById('Part_Number'+allArray[i]).value;

alert("You must enter both a PDF Creation and/or Doc Control approval date and Queue to Release for ECO " + ecoNumber + " Part Number: " + partNumber);

}

if(error) {

return false;

}

else {

return true;

}

</script>

<option value="#Initials#"

<cfif Initials EQ ReleaseInitials>selected

</cfif>>#Initials#</option>

</cfloop>

</select>

Any help would be greatly appreciated. Thank you.

Andy

Gray out or disable text box

forums_noreply@adobe.com — Tue, 04 Oct 2011 18:09:36 GMT

Hi,

I have a drop down menu called CN_Entry_Initials that has options of a "C" or an "N". I also have a text box called Part_Number to enter a part number into. I want the Part Number text box to be grayed out or disabled until either a "C" or an "N" has been chosen out of the CN_Entry_Initials drop down menu. I have this working, except that I cannot get the Add button to do anything. I think it’s something to do with the way I have the If statement for this disabled text box, or do I have to change the button to a submit button. Does anyone know how to fix this? Below is the javascript and the drop down menu and text box code along with the Add or submit button. There is extra stuff in the Javascript that I have on the page, but I don't need to worry about those things since they are working correctly. I have the disabled text box code at the top of the javascript under the function verify() code. Thanks.

<!-- Begin

function verify()

{

if (document.getElementById('CN_Entry_Initials').value == "C"

|| document.getElementById('CN_Entry_Initials').value == "N")

document.getElementById('Part_Number').disabled = false;

else

document.getElementById('Part_Number').disabled = true;

}

{

var PartNum=document.AddECNumber.Part_Number.value;

var regularExpression = new RegExp(/[cC][0-9]/); //regular expression to check for a letter C followed by a number

if(regularExpression.test(PartNum)&& document.AddECNumber.CN_Entry_Initials.value == "N" && document.AddECNumber.Validation_Qty.value == "") { //this will return true if the input passes the regular expression

alert("Enter a Validation Quantity for this new Custom");

}

else if(document.AddECNumber.CN_Entry_Initials.value == "N" && document.AddECNumber.P_Drive_Docs_Initials.value == "i") { //this will return true if the input passes the regular expression

alert("You cannot select 'i' for docs to be removed for a new part");

}

else if(document.AddECNumber.CN_Entry_Initials.value == "" && document.AddECNumber.SW_Model_Only.value == "0") { //this will return true if the input passes the regular expression

alert("ECO type required - Select (N)ew or (C)hange for eco line item");

}

else if(document.AddECNumber.PNR_BOM_Change_Only.value == "1" && document.AddECNumber.CN_Entry_Initials.value != "C" && (document.AddECNumber.Release_Status_Initials.value == "U"

|| document.AddECNumber.Release_Status_Initials.value == "N")) { //this will return true if the input passes the regular expression

alert("ECO type required - Select (C)hange for eco line item and Select N for Release Status if PNR/BOM Change Only is yes");

}

else if(document.AddECNumber.PNR_BOM_Change_Only.value == "1" && document.AddECNumber.CN_Entry_Initials.value == "C" && document.AddECNumber.Release_Status_Initials.value == "U") { //this will return true if the input passes the regular expression

alert("ECO type required - Select (C)hange for eco line item and Select N for Release Status if PNR/BOM Change Only is yes");

}

else if(document.AddECNumber.Doc_Changes_Only.value == "1" && document.AddECNumber.CN_Entry_Initials.value != "C") { //this will return true if the input passes the regular expression

alert("ECO type required - Select (C)hange for eco line item since Doc Changes Only is yes");

}

<!--- else if (document.AddECNumber.P_Drive_Docs_Initials.value == "i")

// self.location='eco_search.cfm'; --->

else

{

document.AddECNumber.submit();

}

// End -->

</script>

<tr>

<td class="edit" align="right">Change or new entry:</td>

<td>

<option value="">Select</option>

<option value="#CN_Entry_Initials#">#CN_Entry_Initials#

</CFOUTPUT>

</select>

</td>

</tr>

<tr>

<td class="edit" align="right" valign="middle">Part Number:<br><h6>(Limit to 25 characters)</h6></td>

</tr>

</cfform>

Thanks.

Andy

little javascript code

forums_noreply@adobe.com — Wed, 21 Sep 2011 14:45:50 GMT

Can someone help me with some javascript I'm having a hard time with? Below is the section I'm having a problem with. The PNR_BOM_Change_Only is a yes/no drop down, but the values are 0 and 1. The CN_Entry_Initials and Release_Status_Initials are drop downs that have a few options in them to choose from. The CN_Entry_Initials has a Null Value, C, or an N option. The Release_Status_Initials has only a U and N option. I'm trying to get this javascript to display an alert box if the PNR_BOM_Change_Only is a 1 and the CN_Entry_Initials is not equal to a C, and the Release_Status_Initials is not equal to an N. This alert box works if the PNR_BOM_Change_Only is a 1 and if I choose an N in the CN_Entry_Initials drop down and the Release_Status_Initials is a U, but it does not work if I choose an N in the CN_Entry_Initials drop down and the Release_Status_Initials is an N. This ends up processing through and it shouldn't yet because the CN_Entry_Initials is not a C. If I remove either the CN_Entry_Initials or the Release_Status_Initials code and keep the PNR_BOM_Change_Only code, this does work just fine then. What am I doing wrong?

else if(document.AddECNumber.PNR_BOM_Change_Only.value == "1" && document.AddECNumber.CN_Entry_Initials.value != "C" && document.AddECNumber.Release_Status_Initials.value != "N") { //this will return true if the input passes the regular expression

alert("ECO type required - Select (C)hange for eco line item and Select N for Release Status if PNR/BOM Change Only is yes");

}

Andy

Use ReReplace with Evaulate

forums_noreply@adobe.com — Tue, 20 Sep 2011 17:49:06 GMT

Hi,

I have a page that I am passing the letter "X" through a hidden field to my action page. But when I try to output the "X", it put the single quotes around the X like this 'X'. How can I remove the single quotes from displaying on the page? I was thinking using the ReReplace function, but I'm not sure how to write this code with the Evaluate function. Here's what I have:

<font size = "5" color=dd0000><strong>#Evaluate("form.Flag_Comments#id#")#</strong></font>

</cfif>

How can I incorporate this with the Evaluate function above:

#ReReplace(cookie.class, "\'", "", "ALL")#

I think this will remove the single quotes, correct? Thanks.

Andy

Alert message in javascript if drop down in 1 column is blank and other column is not blank

forums_noreply@adobe.com — Wed, 15 Jun 2011 14:38:41 GMT

What I’m trying to do is have a java window alert pop up if the PNR column is blank and the BOM column is not blank on each row. I also put a cold fusion If statement around this javascript that the CN_Entry column in the Items table has to be an “N”. This code all actually works, but it only works on the row with the latest or newest item with an “N” in the CN_Entry column. I would like this to work on every row, so that if someone does this on any row, or multiple rows, this alert box will keep popping up until all the conditions are satisfied. What do I need to change to make this javascript work? Thanks.

<!-- Begin

function verify() {

var themessage = "Please enter ";

if (EditItem.PNR_Approval_Initials#ItemID#.selectedIndex == 0 && EditItem.BOM_Approval_Initials#ItemID#.selectedIndex > 0)

{

alert("You must enter some PNR initials for ECO #ECID_SPEC# Part Number: #Part_Number#");

EditItem.PNR_Approval_Initials#ItemID#.focus();

return (false);

}

else

{

document.EditItem.submit();

}

// End -->

</script>

</cfif>

Andy

Combine 2 rows into 1 row

forums_noreply@adobe.com — Fri, 08 Apr 2011 16:59:26 GMT

Hi,

I'm not sure if this is possible or not, but I have 2 different columns in a display page- 1 for PNR Initials and 1 for BOM Initials, but when I insert everything into the database, I only have 1 column to handle both the PNR and BOM initials. The way I tell them apart is with another column that is called Document_Type. If it says "PNR Req", then I know to output it into the PNR Initials column. If it says "BOM Req", then I know to outupt it into the BOM Initials column.

Although the inserting works correctly, the display page does not put them next to each other since the data is dynamic and it's outputting each column's initials into their own rows. For instance, I updated the PNR Initial to "VP" and hit the update or insert button and it inserted the PNR Initial into the database. Then I went back to the display page to insert the BOM Initial to "AG". It inserted it correctly. But now when I go back to the display page, there are 2 different rows with the first row that has the drop down menu in the PNR Column and "AG" in the BOM column. But then there is another row that has "VP" in the PNR column and the drop down menu in the BOM column. Since I've updated both columns, it should just show the PNR Initials under the PNR column once and the BOM Initials under the BOM column once, but all in the same row and not on 2 separate rows. How do I get it so they show up on the same row? The 2 different rows are indicated by the APVID 5 and 9, but they both are linked to the same item number 5 in the Items table. Here's what my display page looks like now:

APVID	APV_ItemID	Part_Number	PNR	BOM
5	5	aaa5	Drop Down Menu	AG
9	5	aaa5	VP	Drop Down Menu

It should look like this:

APVID	APV_ItemID	Part_Number	PNR	BOM
5 and 9	5	aaa5	VP	AG

The APV_ItemID is linked to a column in another table. That table is the ECO_Items table that has the ItemID column that has all the items. The info. above for the APV_ItemID and Part number can always all be the same, but the PNR and BOM columns have to display the correct initals in each on 1 line. I tried the maxrows and the group function on the output query, but those did not work. I've also tried some IF statements, but they do not work either. Any other ideas? Is this even possible?Thanks.

Andy

Updating & Inserting with dynamic data

forums_noreply@adobe.com — Wed, 04 May 2011 15:30:19 GMT

Hi. I am trying to update and insert some initials I have in drop down menus on a page that has dynamic data. I am able to update the items that have initials in the database already, but I cannot get the insert to work at the same time if another row that has initials chosen and is not in the database yet. For instance if the 3 sets of initials below represent my rows with drop down menus, the bottom 2 are already in the database, so I just update them and I have the code for this working. For the top one, however, I just chose those initials now as I am working on this page, so I need to insert those initials into the database and just update the bottom 2 initials. I'm not sure why my If statement is not working. I have it below. I basically have it saying if the drop down has initials chosen and the APV_ItemID is the row to update, then update the table. Elseif the Initials are chosen and the APV_ItemID is blank or does not exist in the database, then insert those initials. If I remove the APV_ItemID is blank code, then it just inserts both the initials I want it to insert and also inserts the update info. into more rows in the database. It should just update the bottom 2 and insert the top one. What am I doing wrong here? I also have another column called Document Type that tells me if it's a PNR or BOM Request, so I'm not sure if I need that. I commented that out. Can someone help me with this? Thanks.

<cfquery Datasource="#application.DataSource#">
Update Approval
Set [Approval_Initials]='#Evaluate("form.PNR_Approval_Initials#id#")#'
Where APV_ItemID=#id#
</cfquery>

<cfquery Datasource="#application.DataSource#">
Insert Into Approval (APV_ItemID,
                      APV_ECID,
                      Document_Type,
                      Approval_Initials)

Values ('#Evaluate("form.ItemID#id#")#',
        '#Evaluate("form.ECID#id#")#',
        <cfif isDefined ("form.PNR_Document_Type#id#") and
        "form.PNR_Document_Type#id#" neq "">
        '#Evaluate("form.PNR_Document_Type#id#")#',
        <cfelse>
        Null,
        </cfif>

        <cfif isDefined ("form.PNR_Approval_Initials#id#") and
        "form.PNR_Approval_Initials#id#" neq "">
        '#Evaluate("form.PNR_Approval_Initials#id#")#'
        <cfelse>
        Null
        </cfif>)

</cfquery>

</cfif>

</cfloop>

Andy

Break dynamic data into sections in a table

forums_noreply@adobe.com — Tue, 17 May 2011 17:57:13 GMT

I have some data that is being dynamically output into a table. I have multiple line items for each ECO Number on their own rows. For instance:

ECO	Part Number	Revision
1	C4520	A
1	C5680	B
1	C8902	A
2	C5000	B
2	C5050	C
2	C4950	A

How can I put in a blank line between the ECO sections of data. For instance, after the third line of ECO 1, there should be a blank line so I can break each section apart of ECO's. It should look like this:

Header 1	Header 2	Header 3
1	C4520	A
1	C5680	B
1	C8902	A

2	C5000	B
2	C5050	C
2	C4950	A

I have tried putting another row in the table, but it just puts a row after all this dynamic info. I've tried breaks everywhere too. So how do I keep the sections together and then break each section apart?

Andy

Test to see if text in text box starts with a C

forums_noreply@adobe.com — Thu, 12 May 2011 17:21:54 GMT

I have a text box called Part_Number. If the part number starts with a "C", then I want my Validation_Qty text box be a requirement to be filled in. If there's anything else in the Part_Number box, nothing else matters. There are no requirements for any other part numbers. How would I go about **** this? Here are my 2 text boxes:

Thanks.

Andy

Selected Items in Drop Down Menu in Dynamic Data Table

forums_noreply@adobe.com — Mon, 02 May 2011 14:52:17 GMT

Hi. I am having a problem getting some initials to be selected in a drop down menu I have when I output dynamic data into a table with a form for updating. This code works in Cold Fusion 9, but not in 7. I have a friend that says it works on his anyway and that's the only difference we see between each other's systems. Does anyone know why this is or what I could do to get this to work correct? Below is what I have. Thank you.

<CFQUERY NAME="ShowInitials" Datasource="#application.DataSource#">
SELECT *
From Users
where Engineer_Initials = yes
Order by Initials
</CFQUERY>

<CFQUERY NAME="PNRBOMSearch" Datasource="#application.DataSource#">
SELECT ECID, Requested_By_Initials, EC_Completion_Initials, EC_Completion_Date, Comments, ItemID, ECID_SPEC, ECO_Start_Date, Date_Requested, Part_Number, Description, P_Drive_Docs, Release_Status, Validation_ItemID, Validation_ECID, Validation_Qty, Open_Jobs_Affected,
Approval_PNR.APVID as PNR_APVID, Approval_BOM.APVID as BOM_APVID,
Approval_PNR.Approval_Initials as PNR_Initials, Approval_BOM.Approval_Initials as BOM_Initials

FROM ((((ECO_Master LEFT JOIN ECO_Items ON ECO_Master.ECID = ECO_Items.ECID_SPEC)
LEFT JOIN Validation_Records ON ECO_Items.ItemID = Validation_Records.Validation_ItemID)
LEFT JOIN Approval as Approval_PNR ON (ECO_Items.ItemID = Approval_PNR.APV_ItemID AND Approval_PNR.Document_Type = 'PNR Req'))
LEFT JOIN Approval as Approval_BOM ON (ECO_Items.ItemID = Approval_BOM.APV_ItemID AND Approval_BOM.Document_Type = 'BOM Req'))

WHERE (Requested_By_Initials = '#cookie.UserInitials#' AND EC_Completion_Date Is Null)

ORDER BY ECID DESC, ItemID DESC
</CFQUERY>

<td align="center">
<select name="PNR_Approval_Initials#ItemID#">
<option value="">PNR Initials</option>
<cfloop query="ShowInitials">
<option value="#Initials#" <cfif Initials EQ PNRBOMSearch.PNR_Initials>selected</cfif>>#Initials#</option>
</cfloop>
</select>
</td>

</cfloop>

</cfform>

</cfoutput>

Andy

Insert multiple rows with dynamic data

forums_noreply@adobe.com — Thu, 07 Apr 2011 14:41:05 GMT

Hi,
When I do an insert into a table that has multiple rows of dynamic info. on
a page, it inserts all the rows that are dynamically populated. I only want it
to insert the rows that I choose the initials on. How can I do that? Let's say I
have 5 items that are displayed on a page and I only want to insert initials for
the first 2 because the last 3 are left blank, how do I do that? I've tried
setting up an if statement that says:

<cfif "form.PNR_Approval_Initials#aid#" neq "">

Then do the inserting into the table

<cfelse>
</cfif>

I also have all of this set up in a loop that says:

<cfloop index="aid" list="#form.listofids#" delimiters=",">

Below is the code for just the inserting. I also have some code on here to
update another table. I got that to work, so I'm just trying to get the insert
working correctly for right now. I cannot use this where statement in the query:
Where ItemID=#id# because I am trying to insert into the Approval table, not
the Items table. The items table is just being updated with some other info. in
some other input boxes.

<cfloop index="aid" list="#form.listofids#" delimiters=",">
<cfif "form.PNR_Approval_Initials#aid#" neq "">

<cfquery Datasource="#application.DataSource#">
Insert Into Approval (APV_ItemID,
                              APV_ECID,
                              Document_Type,
                              Approval_Initials)

Values ('#Evaluate("form.ItemID#aid#")#',
'#Evaluate("form.ECID#aid#")#',
<cfif isDefined ("form.PNR_Doc_Type#aid#") and
"form.PNR_Doc_Type#aid#" neq "">
'#Evaluate("form.PNR_Doc_Type#aid#")#',
<cfelse>
Null,
</cfif>

<cfif isDefined ("form.PNR_Approval_Initials#aid#") and
"form.PNR_Approval_Initials#aid#" neq "">
'#Evaluate("form.PNR_Approval_Initials#aid#")#'
<cfelse>
Null
</cfif>)

</cfquery>

</cfif>
</cfloop>

On the display page, it just has a table of the dynamic info. These are the 4
things I have on this page that should get inserted into the database.

<input type="hidden" name="ECID#ItemID#" value="#ECID#">
<input type="hidden" name="ItemID#ItemID#" value="#ItemID#">
<input type="hidden" name="PNR_Doc_Type#ItemID#" value="PNR Req">

<td align="center">
<cfif Approval_Initials Is Not "">
#Approval_Initials#
<cfelse>

<select name="PNR_Approval_Initials#ItemID#">
<option value="">Select Initials</option>
<cfloop query="ShowInitials">
<cfif Engineer_Initials EQ 1>
<option value="#Initials#">#Initials#</option>
</cfif>
</cfloop>
</select>

</cfif>
</td>

Can anyone please help me on just the inserting into the database so that it
only inserts on the rows I choose the initials on and not the others? Thanks.

Andy

Populating drop down menu with iniitials if checkbox is checked in database

forums_noreply@adobe.com — Wed, 09 Feb 2011 17:41:18 GMT

I am trying to populate a drop down menu with a user's initials that I have in my database, but it has to depend if the "Received_By_Initials" column is checked. I tried putting an If statement in the loop query on the drop down, but it doesn't seem to work. This code I'm using is on an edit page, so that's why I have the selected code on here too because I would like to have the initials display in the drop down if they are already chosen from before. The reason I want to do this is because I have a lot of different drop downs I'm going to use these initials for and I don't want to create multiple tables for Received By, Assigned By, RFQ Leader, etc. Does anyone know how to fix this so this will work? Here's the code:

<CFQUERY NAME="ShowReceivedByInitials" Datasource="#application.DataSource#">
SELECT Initials, Received_By_Initials
From Users
Order by Initials
</CFQUERY>

<select name="Initials">
<option value="">Select Initials</option>
<cfloop query="ShowReceivedByInitials">
<option value="#Initials#"
<cfif #ShowReceivedByInitials.Received_By_Initials# EQ "1">selected</cfif>>#Initials#
</cfloop>
</select>

Thanks.

Andy

Creating a variable to use in Javascript

forums_noreply@adobe.com — Thu, 04 Nov 2010 17:14:02 GMT

I have created a web site with a search function where the user can use drop down menus. This is in a small window that pops up when you click Advanced Search. They choose the first drop down and then the next drop down appears and has items in it depending on what was chosen in the first drop down. This all works, except that it only works on our www. site. If you don't type in the www., then these drop down menus do not work. These drop downs use Javascript and in this javascript, I have the full path of our web site to the .cfm file where this is more javascript for the drop downs. This path has the www. in it. Does anyone know how I can write this so that both ways or paths work- with and without the www.? Do I need to set up some kind of variable to use? How do I do that in Javascript. I think I can do it in Cold Fusion, but I don't think that will work inside the javascript. The web site is www.ironwoodelectronics.com Here is the javascript code below. Thanks.

Andy

<script>
     function getICNumber() {
          $('#ICNumber').load("http://www.ironwoodelectronics.com/incICNumber.cfm",{ManufacturerID:$('#select_ManufacturerID').val()});
     }
     function getPackage() {
          $('#Package').load("http://www.ironwoodelectronics.com/incPackage.cfm",{ManufacturerID:$('#select_ManufacturerID').val(),ICNumber:$('#select_IC_Number').val()});
     }
     
     function getPackageType() {
          $('#PackageType').load("http://www.ironwoodelectronics.com/incPackageType.cfm",{FunctionID:$('#select_FunctionID').val()});
          $('#Pitch').html("");
     }
     function getPitch() {
          $('#Pitch').load("http://www.ironwoodelectronics.com/incPitch.cfm",{FunctionID:$('#select_FunctionID').val(),PackageID:$('#select_PackageID').val()});
     }
     function getBody() {
          $('#Pitch').load("http://www.ironwoodelectronics.com/incPitch.cfm",{FunctionID:$('#select_FunctionID').val(),PackageID:$('#select_PackageID').val(),PitchID:$('#select_PitchID').val()});
     }
     function getArray() {
          $('#Pitch').load("http://www.ironwoodelectronics.com/incPitch.cfm",{FunctionID:$('#select_FunctionID').val(),PackageID:$('#select_PackageID').val(),PitchID:$('#select_PitchID').val(),BodyID:$('#select_BodyID').val()});
     }
</script>

First, Middle, and Last name search box

forums_noreply@adobe.com — Thu, 12 Mar 2009 18:48:28 GMT

Hey everyone,
Does anyone know how to be able to search on all 3 fields for a First Name, Middle Name, and a Last Name all in the same search box? I am able to do this now, but the problem is if there are 2 words in a last name, such as "La Rue", the search can't find this. The only way I know how to make this work is to do a search on each field separately, but we want to be able to search for all 3 fields in one search box. Does anyone know how to do this? I have attached the 2 different types of code for searching in one box, or searching in 3 boxes that we already have. Thanks.

Andy

counting number of RFQ's each person has

forums_noreply@adobe.com — Thu, 15 Jan 2009 17:46:30 GMT

Hi. Hopefully this isn't too difficult. I have a field for RFQ Leader Initials. The table has lots of RFQ's in it and each RFQ has an RFQ Leader assigned to it. I would like to count how many RFQ's each person has assigned to them. I can get a total count of all the RFQ's that everyone in the database has by using this: #RFQLeaderSearch.RecordCount#, but I can't narrow it down to see how many each person has. On the first page, I have a checkbox list that a user can choose who they want to search for. On the action page, I just have a small table that outputs the RFQ Leader and the number of RFQ's each person has. Does anyone know how I can get this to work? I have attached the action page code. Can someone please help me? Thank you.
Andy

Relative or Absolute Linking to local network

forums_noreply@adobe.com — Wed, 03 Dec 2008 20:33:00 GMT

Hi. I am trying to put a link on a web page that we use internally at work using cold fusion to open a file that is on our internal network. I'm just wondering how I could get this work? What it's doing when I create an a href is it's doing a relative link, but I don't want that address to show up in the link. Is there a way to strip out that part of the address? I will not show the entire path, but just a little so you can understand what I'm talking about. I want just this to show in the address bar when I click the link: \\Server\Server_Folder\Sales What shows up instead for the link is: http://192.168.0.2....\\Server\Server_Folder\Sales
How do I get rid of the http://192.168.0.2...?
Can someone please help me? Thanks.

Andy

Searching options on first, middle, last names

forums_noreply@adobe.com — Mon, 01 Dec 2008 18:27:41 GMT

Hi everyone. I just have a question about creating some search options with a first, middle, and last name. I have the code working to search for any of these names since they are in 3 different fields. What I'm having a problem with though, is searching for a name with different criteria that has to be met from another table. I have to display info. that depends on if there is some feedback in another table for that person. I have attached some code that I though would work, but it doesn't. I can only get the searching to work on the names, but I cannot get the criteria for the feedback to work. Can someone please help me with how I can get this to work? Thanks.

<CFQUERY NAME="ContactSearch" datasource="#application.DataSource#">
SELECT ContactID, RFQID, RFQID_SPEC, ItemID, Company, Company_Name, Company_Classification, First, Middle, Last, Standard_Part_Number, Generic_Description, Sales_Order_Number, CFID, CF_ItemID, CF_RFQID, CF_Date_Registered, CF_Handled_By, CF_Feedback_Concerns, CF_Resolution, CF_Comments

FROM
((((Contacts LEFT JOIN RFQ_Numbers ON RFQ_Numbers.Contact_Num = Contacts.ContactID)
LEFT JOIN Companies ON Contacts.Company = Companies.Company_Name)
LEFT JOIN RFQ_SPEC ON RFQ_Numbers.RFQID = RFQ_SPEC.RFQID_SPEC)
LEFT JOIN Customer_Feedback_Register ON RFQ_SPEC.ItemID = Customer_Feedback_Register.CF_ItemID)

where 1=1
<cfif listlen(form.fullname,' ') eq 3>
AND First like '%#listgetat(form.FullName,1,' ')#%'
AND Middle Like '%#listgetat(form.FullName,2,' ')#%'
AND Last Like '%#listgetat(form.FullName,3,' ')#%'
<cfelseif listlen(form.fullname,' ') eq 2>
AND First like '%#listgetat(form.FullName,1,' ')#%'
AND Last Like '%#listgetat(form.FullName,2,' ')#%'
<cfelse>
And First like '%#form.FullName#%'
OR Middle Like '%#form.FullName#%'
OR Last Like '%#form.FullName#%'
</cfif>
AND CF_RFQID >0
And (CF_Feedback_Concerns is Not Null or CF_Resolution is Not Null or CF_Comments Is Not Null)

ORDER BY #set_order#
</CFQUERY>
Andy

update form requirements

forums_noreply@adobe.com — Tue, 11 Nov 2008 19:14:39 GMT

I have an edit form to update records in my database, and I want to set up a requirement that says if something is typed into the M2M Quote number field, then make it a requirement that the complete date field must be filled out as well. I think I will need some javascript to make this work, but I'm not sure what this would be. I have attached some code I thought might work, but it doesn't. Can someone please help me? Thanks.

Andy

Searching for keywords

forums_noreply@adobe.com — Tue, 10 Jun 2008 18:52:18 GMT

Hi everyone,
I was wondering if there was a way I could find some text that is separated by a word in the middle? For example, if I search for GHz Socket on our web site, our part numbers don’t show up because the column this search is querying off of has, “GHz BGA Socket” in it. Is there a way so that the user does not have to type the exact thing or groups of words together all together when they type the words in? I would like it so they don’t have to type BGA in order to see these parts. I’m trying to use the % signs which I thought you could type anything anywhere and still come up with results since it would have some of thee words in the search. The way I have the code right now is like this:

<cfif PartNumber NEQ "*">

<cfset session.BrowsePartGridWhere = "Part_Description LIKE '%#PartNumber#%'">

</cfif>

Thanks.

Andy Text

Spry Menu bar not working correctly with IE

forums_noreply@adobe.com — Wed, 30 Jan 2008 18:57:10 GMT

Hey everyone,
I'm having problems with the spry menu bars I created with Dreamweaver working correctly on internet explorer browsers. I have IE version 7 on the PC. What happens is when the menus drop down, they overlap the other drop down. It's supposed to go directly to the right of the other drop down. If you have IE 7, please take a look at my site here: http://www.ironwoodelectronics.com/proto/index.html
I am also having another problem in IE 5 on the mac. I have a horizontal menu and it shows up vertically in IE 5 on the mac and the drop downs don't even work. Is there anything I can do to make these work in these versions of Explorer? I have attached the SpryMenuBarHorizontal.css code that I've updated so it looks the way I want it to. Thanks for anyone's help.

Andy

Verifying a radio button

forums_noreply@adobe.com — Tue, 06 Nov 2007 19:36:28 GMT

CF Users,
Does anyone know how to verify a radio button using Javascript? Basically, all I would like to do is if the user doesn't answer a yes/no question, I want a pop up to show up when they click the submit button that says they didn't answer that question. I have some other code that works for a checkbox unless there's a way to have it all go into the same scripting code. Below is some code I've been working with, but I cannot figure out how to get this to work. Can anyone help please? Thanks.

Andy

Dynamic Drop Down Menus

forums_noreply@adobe.com — Tue, 17 Apr 2007 15:17:09 GMT

Hi everyone,
I am trying to create 4 drop down menus depending on what was chosen in each previous menu. It's set up just like search engines for cars, only these are for electronic parts. You first choose the "make" and then depending on what you chose here, will populate what is displayed in the next drop down which is "model". I do not want to use any kind of javascript to do this. I only want to use Cold Fusion. I have it somewhat working, but once I click on the first drop down, it displays the next 3 menus at once. I would like it to display each menu one at a time depending on what was chosen from the previous menu. Can anyone help me with this? I have attached the code that I have been working with. Thank you.

Andy

Displaying an edit or add link

forums_noreply@adobe.com — Thu, 19 Oct 2006 14:45:05 GMT

Hi everyone,
I have a page that I would like to display either an edit or an add link depending if there is any info. typed into a column or
not. For instance, I would like to have the edit link show up if there is info. in any of these 3 columns in my database:
CF_Feedback_Concerns Or CF_Resolution Or CF_Comments. Otherwise I would just like the add link to show up. I can make this work if I only do it on 1 column. How do I write an If Statement for any of the 3 columns? Attached is the code I tried and below that is the error message I get when I try it. Can anyone please help me? Thanks.
Andy

Sending an attachment with an e-mail

forums_noreply@adobe.com — Thu, 07 Sep 2006 18:46:08 GMT

Does anyone know how to send an attachment with an e-mail using a
form page that is on our web site? I am using the TYPE attribute of
the form tag as "File" to get the file I want to attach to the e-
mail. Below is the code I have. The first page is where the user can
click the browse button to search for a file to attach. The second
page is where the e-mail should be sent to. Thanks for your help.

Andy

Making a row colored in a table

forums_noreply@adobe.com — Thu, 27 Jul 2006 18:58:54 GMT

Hi,
I have some tables that get displayed when someone does a search
for a company for instance. In this table, it shows the company name,
the contact, address, company classification, etc. The company
classification field is just a way to tell us if the company is a key
account or not. They are labeled as an "A" if they are. What I would
like to do is to make the rows that have the company classification
labeled as an "A" to be a yellow color so users can tell if the
company is a key account right away or not. Does anyone know how to
get this to work correctly? I have attached only a little code. I
think this is where I will have to update it at. Can anyone help me?
Thanks.

Andy

Insert Into statement error in MX 7

forums_noreply@adobe.com — Wed, 28 Jun 2006 21:01:40 GMT

We have upraded our server from ColdFusion 4.5 to MX 7. I am having problems inserting info. into our database now that I did not have before. I think something has changed between these 2 versions, but I'm not exactly sure. I just can't add anything to the database. Below is the error message I receive when I try and insert something into the database. I do have 3 address fields named Address1, Address2, and Address3. Would this cause problems since they all have the same name in each of them? Below is my insert code. Can someone tell me what I need to change in this to make this work with MX 7?
Thanks.

Andy

Error I receive when I try and insert something into the database:

Error Occurred While Processing Request
Error Executing Database Query.
Syntax error in INSERT INTO statement.

Resources:
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address 64.122.92.67
Referrer http://info.ironwoodelectronics.com/Prospect_Information/add_contact_life_cycle.cfm
Date/Time 28-Jun-06 03:27 PM