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 derfloh 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: susanh
  • Content: Threads
  • Order by date
  1. susanh

    Loop Problem

    Good Morning, I know that i just have the syntax wrong on my code, but I can't tell what I am doing wrong. When I run the page, I get the email 25 times, as I have 5 records in the database. Help :) Thanks Sue My Code: <cfquery name="tickler" datasource="Intranet"> Select ID, ProjectID...
  2. susanh

    CFOUTPUT Date if it is NULL

    Hi everyone, I am having a serious time remembering if you can do this or not. It has been a while. Can tell Coldfusion to cfoutput a date field if the table shows that it is NULL? I define it here <cfif isdefined("GetProject.duedate") and len(trim(GetProject.duedate))> <CFSET...
  3. susanh

    Weekly Summary Report

    Good Morning, I am trying to create a summary schedule report. I need to layout the columns to be Monday Tuesday Wednesday Thursday Friday then the rows to be the name of the individuals. Employee1 Employee2 Employee3 Employee4 then I want to dynamically output the...
  4. susanh

    Report Master Tutorial or Manual

    Hi Everyone, Does anyone know where I can find a tutorial or Manual on how to use the report master? We are currently on version 4.05 Sue
  5. susanh

    Drop Ship Question

    Hi Everyone, For those of you that have drop ship orders. Is there a particular way that you manage the quanity side of the transaction? How do you capture the data? Custom reports? Or is there a setup option that we can turn on in setup to capture the data? Any input would be great...
  6. susanh

    Add Bin Location to Purchase Order

    Hi, I am trying to add the bin location of an item to our Purchase Order form. Has anyone ever done this? If so, is it an easy process? I am a bit nervous to do this as I don't see the table included in the query for the Purchase Order. Sue
  7. susanh

    Query Operator Help

    Hi, The end result that I am trying to get from the following query is just give me the ProjectID's that are in the Projects table BUT are not in the Task Table. I am trying to do this with the not equal operator, but that does not seem to be giving the correct results. Can someone point me...
  8. susanh

    Sort Date Question

    Hi All, Is it possible to sort my date column so the records that have blank dates are at the bottom of the list?
  9. susanh

    Checkbox Frustration..Help Please?

    Hi All, I am trying to get multiple values inserted into a database based on user selection of checkboxes. I am getting a database error and not sure what is wrong with my code. If someone has a minute I would sure appreciate another set of eyes to look at it and tell me what I am doing...
  10. susanh

    How do I display my rows as columns

    Hi Again, I am trying to create an inventory report that displays different vendors and their price by item numbers. So part of my report creation is to grab the data and dump it into a temp table like the following DROP TABLE temp_vbelts_table5 SELECT POR_VendorPriceLevel.itemnumber...
  11. susanh

    How do I total up my columns per row?

    I am so stuck and trying to learn how to do this, but have just gotten confused. All I want to do is add my columns for each row and display the total. Here is my query. Can you guys help? DROP TABLE temp_vbelts_table2 SELECT IM_14ItemReceiptHistory.itemnumber...
  12. susanh

    Customer Discount if in certain area

    Good Morning, I have a question on how do I implement a Sale Price on customers that are in a certain area? I have created a Sales Promotion with a Sale Price and applied to the item numbers...but then it does not implement correctly on the sales order. It is giving everyone that sale price...
  13. susanh

    CFQuery Question - Where

    I have a question on my cfquery and I don't know how to do this. My cfquery if very simple... SELECT * FROM Tasks WHERE Assigned = '#Username#' Which then outputs my task data for just those tasks with the specific username that is logged in. What I would like to do is tweek the query so...
  14. susanh

    Email a Report from Report Builder

    Good Morning, I am to the Report Builder and so far like it, but I am kind of stuck on how to email my report. I have been searching the web and have found ways to do it using cfdocument. So I am a bit confused and am wondering how I email it. Here is my code which works fine via the web...
  15. susanh

    CF Report Builder - Method not allowed

    Hi, I just installed the Report Builder and am trying to make a connection. I type in my Description which is my Server Name My Host Name: which is my ip address Port: 80 context root: blank RDS Security Username: blank Password: type in my password which I set in CF Administrator and...
  16. susanh

    Run Import Jobs via a VPN connection

    Has anyone run their Import Jobs (with VI) via a VPN connection? Recommend or don't recommend Thanks Sue
  17. susanh

    Month End Processing

    Hi, I have a quick question. Our dealer/consultant instructed us that the AP module has to closed last. Just wondering is that absolutely true? Thanks Sue
  18. susanh

    Alias Item Number Import

    Has anyone had any luck doing an import into Alias Item Number table. I tried this yesterday under our test company with a csv file of 2 records with the VI and used table IM_Alias. I orginally put in the csv file that it was a type "V" and the vendor number and vendor division, but it failed...
  19. susanh

    Ship Via Field Data Entry Question

    Hello All, I have an AR Clerk that uses the Sales Order Module Invoice Data Entry. In the Ship Via field she is able to just data entry and move on to other fields and the data stays in place. Now, when she goes to a different company and tries to do the same process...the data does not stay...
  20. susanh

    Client Workstation Question

    We are running MAS90 v4.05 on our network with the client installed on the local machines. Our reseller has installed a local version of v4.10 on 1 workstation for us to test for a few days. If I share this local version on this one workstation with a few network users and create a separate...

Part and Inventory Search

Back
Top