Search results for query: *

Perfect - Thanks!

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

Arg - your right - 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,*...

Ok, think im there - one question though... i can see how i would pull the fields from the 'inserted' table and do the validation, is it then just a case of performing an 'insert' with the newly formatted info? Or are the values written before the trigger event starts?

Hi fredericofonseca, Do you think you could give me a hint on the validating as numeric? Have only really done triggers to update other tables when something happens, didnt realise i could check the field value... Thanks

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

damn! - thanks cLFlaVA

also the loop starts after the JS ends so really it looks like this - <script language="text/javascript"> function show(layerName) { document.getElementById(layerName).style.display = ''; } function hide(layerName) { document.getElementById(layerName).style.display =...

Hi cLFlaVA, <script language="text/javascript"> function show(layerName) { document.getElementById(layerName).style.display = ''; } function hide(layerName) { document.getElementById(layerName).style.display = 'none'; } function tabs(Item,Show1,Hide1) {...

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 Guys, Thanks for all your help - ending up organising the code as ggriffit suggested, and somewhere along the way it started working! - so thanks!

Good Point! Below is what the parsed JS looks like... // Check if the Width doesnt equal the standard width if (AddItem.Depth != 560) { // If the depth has been reduced if (AddItem.Depth <560) { TotalPrice = (TotalPrice+25) } else if (AddItem.Depth > 560 && AddItem.Depth...

Thanks again, but still no effect - so what ive done looks like it should work? I cant see why it wont if syntax etc is correct as coldfusion code is parsed first leaving the numerical values in the JS code when passed to browser... any other ideas?

Hi, Thanks guys - No effect though.... Not to great with javascript (as you might have guessed), the additem.depth and the finditems.depth(coldfusion variable) should both be numbers, in JS can i sort of 'CAST' these as numbers? or is that not likely to be the issue?

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

OK thanks - that helps anyway - i couldnt find what double meant.. ill have a dig and see what ive done wrong.

the query is created using QueryNew and QuerySetCell etc - so i dont think the fields have a datatype as such?...