Search results for query: *

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

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

it could be. depends on how many tasks are assigned to him in that table.

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

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

Louie - Do you recommend sage solutions http://www.sagesoftware.com/mas90/extendedsolutions/files/SO/so-1183.pdf Or can I configure the flow with what I have??? Thanks Sue

Would creating a Drop Ship Warehouse be the answer?

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

ok...here is the query. Because I just added the bin location in the select clause, and then matched up the item number in the where clause SELECT PO_20CRWPurchOrderDetail."PurchaseOrderNumber", PO_20CRWPurchOrderDetail."LineNumber", PO_20CRWPurchOrderDetail."ItemNumber"...

...ok, I will test it. Then I just need to add the binlocation field in the select portion of the query correct? Do the sub reports slow the process down? Is that why you recommend the modification of the query?

Josh Louie, I just did a sub report on a test company and that seems really simple. Makes me wonder if I am missing something or did something wrong. I ran it and the bin location printed out correctly.

Hi Louie, Well I was hoping this little project would go away, but they asked me again to add it. UGH! Anyway I was looking again at what you suggested and when I look at the code (Unless I am looking at something wrong), I think the link to the terms table is set to equal. Here is the From...

Thanks Louie, I think it is way beyond my knowledge.

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

That was it! Thanks Guys.

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

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

Yes...could be several

Man...I thought I was doing good :) Just kidding. I appreciate the help more than you know. Kevin - most of your stuff cut off so I was unable to read some of it. I am using the checkboxes as a way to flag tasks to be billed. I thought using a value of "Yes" and updating that column in the...

Ok. I got it. I change my List to form.billed