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,*...
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...
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,
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)...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.