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 Chris Miller 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. contiw

    Need .fla analog clock with GMT support

    Thanks OldNewbie. Looking for an analog though. Appreciate your interest. WalterConti
  2. contiw

    Need .fla analog clock with GMT support

    Date and GMT time important. Please advise about free options or otherwise. Thank You very mucho. ContiW
  3. contiw

    Error saving to Memo field ...

    I am referring to an Access query. Am I in the wrong forum?
  4. contiw

    Error saving to Memo field ...

    <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#arguments.details.CONTENT#">, Error saving to a Memo field when the length of "CONTENT" is more than 510. Otherwise saves ok. Please advise. ThankYou ContiW
  5. contiw

    IN operator usage

    I would like to determine whether the value of an expression is equal to any of the values of a list contained in a specified column field: Suppose "fieldname" contains (value1, value2, ....) What is the correct syntax for: SELECT * FROM Orders WHERE ShipRegion In (fieldname) Thank You very...
  6. contiw

    Submitting a Form to CF

    Thanks LPatton. I would love to have some hints about it. Thanks for your offer. WConti walter@wconti.com By the way: does the latest version of ColdFusion create PDFs automatically?
  7. contiw

    Submitting a Form to CF

    Newbe approach to Acrobat/ColdFusion interfacing. A form is being submitted as HTML to a ColdFusion page. Everything ok with the exception that the CF page does not open in my default browser (IE6) but in Acrobat. Is there a way of submitting and exiting Acrobat? Thank you for helping.
  8. contiw

    How to conditional IIF in query.

    SELECT COUNT(*) as reccount, SUM(j.duration*#session.payInter.translatorRate#) as tot2pay, SUM(j.duration) as totduration FROM jobsDb j WHERE j.linguistId = #linguistId# AND j.status = 'completed' AND j.interInvoiceBilled is not null AND j.interInvoicePaid is null j.duration could be a value...
  9. contiw

    Help newbe optimize query

    Like a charm PH. Good lesson. Thank You.
  10. contiw

    Help newbe optimize query

    The following query returns the expected recordset but all those subqueries look weird to me. Is there a way of optimizing it? Thank You <cfquery name="session.getJobs" datasource="#db#"> SELECT j.*, IIF([status] = 'completed','b','a') as statusorder, j.duration*u.BasicFees as charges, (select...
  11. contiw

    MSAccess query. Extract distinct month name.

    Need to extract distinct month name from date column. I have found something like this ----- SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth ----- which does not work. Please advise. Thank You.
  12. contiw

    Is curr page the last in history array?

    Need to know if the current page is the last in the history array. Theoretically &quot;history[history.length-1] == window.location.href&quot; should do it but history[...], history.current, history.previous, history.next, return &quot;undefined&quot;. Working with IE 6.0. Is it a security...
  13. contiw

    Mouse pointer repositioning

    Need to reposition the mouse pointer to 0,0 until the page loads completely. Disable it will also do. In any case it should be out-of-the-way. Is it possible with javascript, css, or dhtml? Thank You all for helping.
  14. contiw

    Javascript variable

    myVar is actually an array element tranformed for semplicity, and it comes from a chunk of XML code which comes from a database query. Cannot touch that.
  15. contiw

    Javascript variable

    Hello! I have this var myVar=new Date(2003,2,12,17,18,12); alert(myVar) returns &quot;Wed Mar 12 17:18:12 PST 2003&quot; Is it possble to get the literal string &quot;new Date(2003,2,12,17,18,12)&quot; instead of the formed date? All the best.
  16. contiw

    Bad inline a:hover ...

    A:external.hover {color:red;} <a class='external' href='....'> <img style='border1px solid black;' src='....'> </a> the hovering doesn't work. Please help.
  17. contiw

    Changing tablecell content programmatically

    Yep! Works great. Thank you very much.
  18. contiw

    Changing tablecell content programmatically

    Greetings! A tablecell contains a picture, a link and variables for the onMouseover statemnet, something like this: <td width=100 align=center> <img name='img&quot;+i+&quot;' src='./GalleryCover/&quot;+i+&quot;.jpg' height=100 width=100 border=0...
  19. contiw

    Help-a-newbie with variables ...

    Thank You opnt. Tried: eval('xxx'+i = '...'); and eval('xxx'+i) = '...'; with no success. How is it?
  20. contiw

    Help-a-newbie with variables ...

    Greetings Javascripters, Need to build a series of variables on the fly: for(var i=1;i<=24;i++){ 'xxx'+i = .... } This doesn't work. Please advise

Part and Inventory Search

Back
Top