Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nohandlesleft254

    Doing IN backwards....

    Perfect - Thanks!
  2. nohandlesleft254

    Doing IN backwards....

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

    Latest IE7 with flash

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

    QofQ - Incorrect select list...

    Arg - your right - thanks!
  5. nohandlesleft254

    QofQ - Incorrect select list...

    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,*...
  6. nohandlesleft254

    ODBC from External software

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

    ODBC from External software

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

    ODBC from External software

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

    Re-using a JS function on each row of a loop

    damn! - thanks cLFlaVA
  10. nohandlesleft254

    Re-using a JS function on each row of a loop

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

    Re-using a JS function on each row of a loop

    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) {...
  12. nohandlesleft254

    Re-using a JS function on each row of a loop

    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)...
  13. nohandlesleft254

    Stupid Comparison Problem

    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!
  14. nohandlesleft254

    Stupid Comparison Problem

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

    Stupid Comparison Problem

    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?
  16. nohandlesleft254

    Stupid Comparison Problem

    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?
  17. nohandlesleft254

    Stupid Comparison Problem

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

    MailShot

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

    Comparison Exception: While executing &quot;=&quot;

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

    Comparison Exception: While executing &quot;=&quot;

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

Part and Inventory Search

Back
Top