Search results for query: *

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

I'm sorry what should I be looking for?

I have an issue/ question I would like some opinions with. I have an application running on a remote pc showing graph information getting pulled from an INSQL DB. Upon loss of power the pc restarts and displays the page showing the graph information. But when the CF server goes down the PC...

Sorry forgto to post the code.... <?php /** * Easy Peasy Image Gallery (EPIG) * * Copyright(c) 2005 Apostolos (Soumis) Dountsis * * @author Apostolos (Soumis) Dountsis * @email * @version 1.0.8 * @date 26-April-2005 * * Revisions: * 1.0.0 Initial release * 1.0.2 Added PNG support * 1.0.3...

I am not at all familar with PHP could someone lead me in the right direction on how to display the newest images to a image gallery. Thank You..

I am have an EXTREMELY hard time trying to figure out what I am missing in my code.. I am trying to get everything so that when a person changes screen resolutions the page looks the same. but now when screen resolution changes my header moves the footer moves etc... Please review and lend any...