Recent content by alsjka

Yeah I don't want to dicard the data really it will be used for a QA process..I just thought there was a trick of some sort that would keep the scale from expanding. Thanks for you thoughts.

Hi I have a question I hope someone can anwser. I have a cfchart that is plotting data points within a certain range say 16.7 to 17.8 all the points plotted should be between this. My scaling is from=15 to=18 but if a data point is plotted at say 25 it causes the scale to increase to the...

This was my final solution if anyone has a need for something like this. I had to sort the list so no matter how the list is combined it will always be the exact way i need to have it. If anyone has anything that would make this better or that i could have done better please let me know...

Thanks I managed to find a solution. See below. <cfquery name="data" datasource="db2"> select * from stringhistory where tagname = 'mt_mm2_scaledata' and datetime > {ts '2006-03-20 07:45:00'} and datetime < {ts '2006-03-20 15:45:00'} and value is not null </cfquery> <cfset clist = "">...

Hi I have the following list returned from a query. select value from stringhistory where tagname = 'mt_mm2_scaledata' and value is not null This is the string returned. ------------------ 03/21/2006 11:10 n 3 x 45.23 g Min 35.9 g Max 63.7 g Diff. 27.8 g Is there a way to break the string...

Thanks all great reply's! I will try this when at work tomorrow. JKA!

I want to be able to return all records that are greater than 4 weeks from the date received. I want to use the following query is this possible? select ponum, count(itemnum) as itemnum, count(invoicenum) as invoicenum from poreceiv where ponum = '#get_po_item.ponum#' and itemnum =...

This is just my query from my code everything else works but this. I am trying to compare smithr or smitht or reissec against rsmith@tonnes-thine.com or tsmith@tonnes-thine.com or ecreiss@tonnes-thine.com. I did post this under Microsoft: Access Queries and JET SQL did not know where this...

I have the following data i would like to compare. Lastname, first initial - catalognum smithr smitht reissec - This one has two first initials that need to be compared instead on just one initial. Against the following - emp.email rsmith@tonnes-thine.com tsmith@tonnes-thine.com...

Hi..I guess I did not explain well.. I have the following data i would like to compare. Lastname, first initial - catalognum smithr smitht reissec - This one has two first initials that need to be compared instead on just one initial. Against the following - emp.email...

Question please: I am trying to gather info like below. The issue is i have a record used with the substring that i need to compare the first 2 characters instead of 1. Could someone lead me in the right direction please. How would I change this to be able to compare 12name or 2name...

Hi could someone please let me know if and or how I would add a "cfmailparam" tag that could handle moods in Lotus Notes? I am not sure if it even possible. I can add the importance like this "<cfmailparam name = "Importance" value = "Low">" but not a mood. Thank You.

Perfect thanks a bunch.

Hi, Could someone help to anwser this question. Is it possible to have a <cfif #variable# like '%test%'> in a cfquery select statement? I tried the following but a no go. <cfquery name="get_tagname_3" datasource="#source#"> <cfif #variable# like '%test%'> select top 1 name <cfelse>...

Hi I have a question if someone could help anwser. Is it possible to have a CFIF statement in the actual CFMAIL tag. I am trying (see below) to no avail. is there something I would need to change in my code? Thanks <cfmail to="tonamehere" <cfif get_emp.purchasingcenterid eq...