Search results for query: *

Hi, I have a column in a table that is a string (ALL,ACCE,PB,CORN). When i query this table i need to be able to look in this string for my var (say PB). 'LIKE' with wildcards works most of the time but i do have some lists like ALL,ACCE,PBS,CORN, so it obviously returns both. How can i say...

Hi, Ive been using cfchart on an https site. Until now i have been using savecontent to allow me to then change the flash codebase link from http to https, but now IE7 just updated it returns the insecure warning again? Any know work around yet? Thanks

Hi, I have a main query that i use to get all invoices for the last 6/12/18/24 months. I am then trying to use QofQ to obtain the information for the months individually, but i get an error; *Query Of Queries syntax error. Encountered "Date. Incorrect Select List, Incorrect select column,*...

Hi, I am using a DB on sql server 2005 for an online account systerm. The sql db is a live copy of our internal systems DB (ODBC). My problem is that sometimes the internal system can send blank field values out to a numeric field in the SQL db, it fails to convert and stalls the system. I dont...

Hi, I have been using a simple JS show/hide tab function. I now want to use it on x rows returned from a query. I have tried dynamic function names etc etc but can get it to work... *Item = Code of item (each row represents an item) <script language="text/javascript"> function show(layerName)...

Hi, Can anyone explain why im such a muppet!? this keeps running the 'else' regardless... * AddItem.Depth is a input text field * TotalPrice is set at start of function Thanks if (AddItem.Depth != <cfoutput>#FindItems.Depth#</cfoutput>) { // If the depth has been reduced if...

Hi, Im looking at doing a simple mailshot app, but im not sure on best pratice for the to addresses. Should i list them in the bcc as to avoid them appearing in the header? Thanks

Hi, Can anyone see whats wrong with the query or queries below, i keep getting the error - 'Query Of Queries runtime error. Comparison Exception: While executing "=" ' but i can see a thing wrong... <cfquery name="CheckForUnits" dbtype="query"> SELECT SerNr, PlanRef, Code, Name, Quant...

Hi, If i was to ask what the most efficient method for keeping form results within a page long after the form has been submitted would most people tell me the same thing? I have a search form with 8 fields. Once the form is submitted the user can then use a pages function, or column sort...

Can anyone tell me why cfif causes gaps in my IE pages? Thanks

Hi, I'm using the code below to check whether a quote has already been opened, and if so just focus it rather than open again. Only thing i cant work out how to do is get it to not reload the page on focus....? <!-- OPEN QUOTE FUNCTION <!-- First set the variable for the window name -->...

Hi, Can anyone tell me how to get to an array or a query stored within a query cell? Im looping through the main query and want to be able to loop through the stored queries on each line...CFDump shows the array of the query inside the cell, but i cant workout how to replicate this output. Thanks

Im trying to use the code below and keep getting the error ' The start tag must have a matching end tag. An explicit end tag can be provided by adding </CFSCRIPT>.' - But there is a </CFSCRIPT> closing tag...? <cffunction name="CFQUERY" access="public" returntype="query"> <cfargument...

Hi, I have a bit of code that adds and removes lines in a query. The lines represent items that can either be individual items or parts of a multi-part item. The field that shows this difference is called PlanRef. Plan Ref Item Code 1 BU40 2 BU80 3 D3DP60 3...

Hi, I'm rubbish with javascript so could someone have a quick scan of below and tell me why all my vars are appearing in the DelAddrCode field, and the other fields are getting a value of 'undefined'. Thanks! <!---- The call ---->...

Hi, I'm using the below query to get invoices from my DB. What I want to do is only get invoices that dont have a payment against them in the joined 'receipts' table (e.g. where receipts.invoicenr = ''). Yet i cant seem to arrange the query to give me that result. Any suggestions? Thanks PS...

Hi, Im using coldfusion and SQL server. I want to perform a multiplication by percentage on a field before i then run a WHERE on it. I have written out incorrect SQL of what i want to do - can anyone tell me how i actually need to do it!? WHERE (CAST(Sum4 AS NUMERIC)+((CAST(Sum4 AS...

Hi, For some reason the 'GROUP1.DoorCodes' loop is repeating its first value for every output row, yet it is outputting the correct number of rows. Dont know what im missing!! Can post more info if anyone has an idea... <!--- PRICE GROUP1...

Hi, Im using the below code to write then check a txt file. The problem being it always returns false. I thought this may be the delay in writing the file so i added a loop from 1 to 50000 before checking but it still returned false. Do i need to wait longer? Also is there a better way of...

Hi, I'm using the below javascript function to get a pop-up to populate a field on the parent page. The problem is that i cant seem to get the CF variable in the Javascript. Help... function updateParent(DoorCode) { opener.document.form_FindItem.DoorStyle.value = DoorCode...