Search results for query: *

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

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

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

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

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

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

I am trying to look at 3 fileds to get information when a certain object was found, scanned and the number of the part. I can count the individual part numbers, but I run into problems when I try to count the number of parts picked up between 2 times. Here is my code. declare @dtPuDate...

I need to add four items together and have tried <cfset strJobCode = '5115','e115','e140','e120'> and <cfset strJobCode = ('5115','e115','e140','e120')> these items from from a form and could be 1 item up to 100. Can any body help? Thanx Thank you, [king]Moe-King of the Village Idiots...

I am trying to pull one line per package. I get a record for every scan, can be up to 10 scans. I just want the last one. pkg_tck_nr is unique to package, but not to database. code: SELECT E.PKG_TCK_NR, E.SHR_AC_NR,D.DY_DT,E.PKG_XCP_RPT_DT ,E.PKG_XCP_RPT_TM,E.PKG_XCP_RPT_OGZ_NR...

when I use the Sum case on a date field I get an error, cannot convert nvarchar to int. Here is the code. SUM(CASE WHEN d.dat_val_dt = '2005-08-03' THEN 1 ELSE 0 END)AS TOTSPH Any ideas? Thank you, [king]Moe-King of the Village Idiots. "When in trouble, when in doubt; Run in circles-...

I want to count a column several ways. select v.loc_na, v.loc_nr, count(n.nit_pr_cml_nr)as counterz, counter2 = (select count(*) from tnitnam_name c where c.nit_pr_cml_nr <100) from tnitnam_name n inner join vlocref v on n.loc_sys_nr = v.loc_sys_nr group by...

I use the following query to run series of pages. The user might choose a city, state, user, customer or address for filtering. They can choose one or all of the above. The query runs in Query Analyzer, but returns nothing to the page. I know the first thing is to say the info is not getting...

I am trying to populate a drop down box with a query, this part works. I then need to send the information to the next page, I use a JS. I cannot get my variables to populate and go to the correct page. Can anybody help? Here is the code in question.... function...

I am trying to take a table, HTML, and export to Excel. here is the code I sue to create the table: <table id="TableID" class="G_TBL_Info" G_rollover id="#VARIABLES.strFuncID#_tblReportTable1" width="#VARIABLES.strModuleWidth#" cellspacing="0" cellpadding="0"> <tr> <th align="left"...

As a simple minded programmer, I wrote this code for multiple drop down boxes. It works, for a while The user can go to 2 seperate locations then the code just stops working. Here is the code, Does anyone see what I have screwed up? <head> <script language="JavaScript"> function...

I am using this code in a stored procedure: SET NOCOUNT ON SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT C6.OCR_ID_NR,C6.OCR_STS_NR,E2.LOC_NA, C6.OCR_NA, C6.OCR_DT, C6.TEM_ID_NR, C6.OTH_TEM_ID_NR, C6.DIS_LOC_SYS_NR, C6.CO_ID_NR, C6.OCR_CDN_EMP_NR,D8.SVP_ID_NR, C3.MSG_ID_NR...