Recent content by KOVMoe

I have a table that has all of the airports that the applcaition requires. I have another table that stores detail about shipments. The problem is I need to update and pull old information from one server to another. The detail table has origin airports and destination airports on the same...

ok, both are great, and work. This is what I came up with: function validateForm() { frm = document.frmDataInputs; var objRegExp = /(^-?\d\d*\.\d*$)|(^-?\d\d*$)|(^-?\.\d\d*$)/; //number from not to exceed 999,999 var objChk6 = /^(\d{1,3},\d{3}|\d{1,3})$/; //number not to exceed 99,999 var...

I need to limit the number input into a field to less than 1,000,000. The user might enter the infroamtion as 99999, or 22,222, and so on. I have tried this: var objChk2 = /^(\d{0,2}\,\d{0,3})$/; but that will not allow numbers less than 10,000 then i tried var objChk5 =...

CONTAINS is exactly what I was looking for, Thanks!!!!! Thank you, [king]Moe-King of the Village Idiots. "When in trouble, when in doubt; Run in circles- SCREAM & SHOUT!!" Burma Shave

I have an applicaiton where i need to search for a certain word in a string. So I just do a CFIF tag like this: <cfif #qryData1.CustomerName# like '%Hold%'> <cfset a = 104> <cfelse> <cfset a = 10402> </cfif> Will the place holder % work? Thank you, [king]Moe-King of the Village Idiots...

Yes, the only diff between the two tables is that the first has raw data, the second has had any duplicates removed. The tables themselves are exact duplicates. Thank you, [king]Moe-King of the Village Idiots. "When in trouble, when in doubt; Run in circles- SCREAM & SHOUT!!" Burma Shave

I need to count two tables and put the information into a third table. Table one contains part shipments(all sorted and scanned). Table tw contains the same information, but has been filtered for duplicates. Table a might have 2355 lines and 150 duplicate scans. Table two would then have 2205...

I have a time field, GMT, that I need to subtract the local time zone from. Example if I am in Dallas I need to subtract 6 hours, Standard, from the time stamp entered. I have the time and another field that has the number of hours behind or ahead. The time filed is datetime, the time zone...

With out giving away too many trade secrets... Here is my code. SELECT S.SHR_NA_TE, COUNT(DISTINCT(A.PKG_TCK_NR))AS PKG, SUM(CASE WHEN(DATEPART(HH,(DATEADD(HH,CAST(A.UTC_TCF_MT_QY AS REAL),A.PKG_DEL_TM)))<=08)AND(A.PKG_DEL_DT BETWEEN @dtPuDate1 AND @dtPuDate2)THEN 1 ELSE 0 END)AS PU08 FROM...

I am using VBA to ftp a file in s stored procedure in SQL. I can download the file, but cannot do anything with the file due to the format of RTF. I need txt to move the information to a table. Has ayone done this, or seen this done? Thank you, [king]Moe-King of the Village Idiots. "When in...

I have begun a quest to figure out holidays, in CFM only. I have to present reports that will, on Monday Mornings, show last week. Not a problem. But the upcoming Holiday does throw a wrench in the works. New Years, 4th of July, Christmas and New Years Eve are all easy. How do I go about...

sorry, posted in haste. I am looking to see what time a package was picked up and the date it was delivered. The problem i have is that the unique identifier is scanned several times and i need to get the last scan and count it. Currently the location that i am looking at has 13 packages for...

he numbers for the pkg are correct and the scan are wrong. I have several packages for each scan and cannot get distinct or max to work. Any one have any ideas? select reg_nr, v.loc_na,v.loc_sys_nr,count(distinct pkg_tck_nr)as pkg, sum(case...

I was not getting the results I wanted, when I put the () in the or statement it worked great! Thanx for the quick help. Thank you, [king]Moe-King of the Village Idiots. "When in trouble, when in doubt; Run in circles- SCREAM & SHOUT!!" Burma Shave

Why can i not do this? What would be the best way to do this? select T.REG_NR ,T.DIS_NR ,T.PKG_DEL_CTR_NR ,T.PKG_TCK_NR ,SUBSTRING ( t.pkg_tck_nr,9,2)as test ,T.PKG_DEL_DT ,T.PKG_DEL_RSL_CD ,T.SHR_ID_INF_TE ,T.PKG_DEL_TM ,T.CNS_NA ,T.PKG_XCP_RPT_DT ,T.PKG_XCP_RPT_TM...