Skip to main content
Inspiring
September 28, 2013
Question

create local temp table

  • September 28, 2013
  • 1 reply
  • 1284 views

I need to create a temp local table and look for ColdFusion informaiton, the cffile action write only can write text file, pictures is more to create file.

I would like to know does ColdFusion support to create local temp tables on session start,

If yes, should be able to get client temp directory and access the data using temp directory without using data source from ColdFusion server?

Your help and information is great appreciated,

Regards,

Iccsi,

    This topic has been closed for replies.

    1 reply

    EddieLotter
    Inspiring
    October 1, 2013

    "session start" is a server side concept. The server cannot access the client's temp directory.

    Please explain what you are trying to achieve and perhaps we can suggest some solutions.

    iccsiAuthor
    Inspiring
    October 1, 2013

    Thanks for the information and help,

    I use jQuery combox to let user type selection from drop down box, but the table has more than 10,000 records which has performance issue. I would like to load to client machine to let user access locally to resolve performance issue using jQuery combo box,

    Thanks again for helping,

    Regards,

    Iccsi,

    Carl Von Stetten
    Legend
    October 3, 2013

    Seems like a AJAX-powered autocomplete control, with a minimum number of characters required to start the AJAX requests, would be a more suitable choice.  Then you would only pull back a smaller set of results to pick from.  Personally, I'd never put more than a few dozen items in a combobox/select control for useability reasons.

    -Carl V.