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

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

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

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

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

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

Good morning! I am getting syntax errors in microsoft query code when trying to use PIVOT TRANSFORM Sum(Temp_Parts.Ext_Amnt) AS SumOfExt_Amnt SELECT Temp_Parts.LastOfDivision, Temp_Parts.Customer FROM Temp_Parts GROUP BY Temp_Parts.LastOfDivision, Temp_Parts.Customer PIVOT Temp_Parts.Prod_Line...

Good Morning, Is there a way in the following query that can my results to display a bit differently? My current display/output Customer Lastofdivision GL_Accnt Prod_Line 2 3 4 5 6 PATRIOT HAULING 06 1000 SR 30300-50-100-000 ADPT 2 16.3725 8.185 59.32 31.88 PATRIOT HAULING 06 1300 Cone...

Hi everyone, I am trying to create a report that takes a table of our customers that own equipment, then match it up to a Parts table that shows what type of parts they have purchased (Product Code). So the output displays the customer, all the machines they own and then in a grouped format...

Hi Everyone, I am a bit new to MYSQL as I am SQLServer. So I am trying to do a simple update query (for zen cart) and keeping getting an Error 1064 syntax error. What does MYSQL not like about my code? and can someone explain why? UPDATE zen_categories SET zen_categories.categories_image =...

Hi, I have a Zen Cart store that I have added some code that will display in the product description info page. My problem is that I can not tell if it is my PHP code or the Query. I am new to PHP/MHSQL. I am more of a Coldfusion/SQL developer. Below is my code and a link to help explain...

Hi, I am hope I am in the right forum, if I am not I apologize. Please let me know which forum I need to be in. My question is a beginner question, do you have to install PHP on your web server in order to run php pages? Just like you would a coldfusion page or an asp page? If so, is it...

Hi, I am having a problem with a query. I am not sure how to do this... I have Table A and Table B. I need to match up itemnumbers from Table A to Table B with I have done with a join. Those records display fine, but I also want the item numbers from table B to display also...the ones that...

Hi everyone, I have a little job application where I am trying to track employee's hours on a particular job. When the employee puts in their hours worked, I would like to keep a running total because it may be days worth of hours before the job is closed....anywhere I wrote the following...