Search results for query: *

Hi all, I just want to see if I am on the right track to get the results I am looking for....I have looked at it to long and need another set of eyes. My goal is try and display the records that don't equal a certain criteria... For example Sara's criteria is suppose to be FTE 1, BU 2, HRS 80...

Never mind. I see what I did... on the form, instead of this <option value="#status#"<cfif Status IS "BackOrdered"> selected </cfif>>BackOrdered</option> it should have been.. <option value="BackOrdered"<cfif Status IS "BackOrdered"> selected </cfif>>BackOrdered</option>

Hi, I have the following form which updates multiple records. I am having a problem with the last field which is a drop down. The other fields update but not the drop down. Can someone tell me what I did wrong? FORM <cfquery name = "getproducts" datasource="intranet"> SELECT *...

Hi, I found this tutorial (easycfm.com)on dynamically adding rows, which when I originally added the fields I wanted worked great until I added a drop down. When it is just basic text fields and I enter data, then click on the add another all the columns stay aligned. When the drop downs are...

Hi, I have a large spreadsheet that has several "address" columns..see below Business Address, Business Address2, Business City, Business State, Business, Zip, Current Address, Current Address2, Current City, Current State, Current Zip, Preferred Address, Preferred Address 2, Preferred City...

I think I understand what you are trying to tell me. Suckerfish produces a better menu, as mine is probably not the best. With that aside I guess my question is more about the layout itself. How do I get the footer tag to expand also when the menu is clicked on? Or does it not work that...

Hi again, Ok. I started the file again. My html css code is below. My menu now overlaps the footer div tag when it is expanded. I am not sure what I am doing wrong. Sorry to keep asking for help but css is really not my expertise. Thanks Sue CSS Code html, body { margin : 0; padding ...

Hi, I have really screwed up my css file. I have a nice little menu on the left side of the css file. Menu expands and collapes with the help of a java script which I did not include. My problem is that when I expand the menu the information in my Content tag exapands along with the menu...

You Bet!

that was it!! Worked perfect! Thank you so much! Sue

ok...so something like the following select a.personnum, a.firstnm,a.lastnm,a.homelaborleveldsc1,a.payperexpectedhrs, HRSTable.hrs, VP_EMPSIGNOFFV42.SIGNOFFSUPERVISOR, VP_EMPSIGNOFFV42.SUPERVISORFULLNAME from vp_person a Left Outer Join vp_empsignoffv42 on a.personnum =...

Thanks Markros. I think that is what I am looking for but I am on SQL Server 2000. My apologies as I should have noted that in my original post. Thanks Sue

Hi, I have this query that works great. But now I want to tweek the query so it only shows the records that don't equal. select a.personnum, a.firstnm,a.lastnm,a.homelaborleveldsc1,a.payperexpectedhrs, (select SUM(b.WFCTIMEINSECONDS)/3600 as hrs from vp_alltotals b where...

You are correct. I started to look at the format of the cells and noticed when clicked in and out of the cell, the county cell with the index/match forumal worked. Sorry! My bad. Sue

ok. my sheet2 has the following kind of data ID FName LName City State County Zip 74980 FName LName AUBURN NY #N/A 13021 77363 FName LName AUBURN NY #N/A 13021 77506 FName LName AUBURN NY #N/A 13021 75084 FName LName AUBURN NY #N/A 13021 63692 FName LName AUBURN NY #N/A 13021...

Hi, i can not quite figure out what is wrong with my index/match formula. I have 1 spreadsheet and trying to index/match from 2 worksheets within the spreadsheet. Sheet1 has 2 columns Counties Zipcodes Sheet2 has my employee information with zipcodes id fname lname city state ny county...

or subquery it somehow....

Ok. I added in Table 2 and I just can not see how I can do this. Table 2 needs to be cleaned up and organized better before I can link it to Table 1. Not sure how..... Sue

I have 2000. So I started with Table 1. I wrote the following query to "pivot" the product lines. DROP Table temp_prod_codes CREATE TABLE temp_prod_codes(division char(2), Customer nvarchar(100), prod_code char(4), qty float, ext_cost money, Tsold money) INSERT INTO temp_prod_codes (division...

Hi Everyone, I need a recommondation on where to start. I have 2 tables. Table 1 is based with Customers, Product Lines and Amount Sold. Table 2 is based with Customers, and Machines. Now both tables have customers listed multiple times...(meaning they can have purchased several different...