QueryCAT Logo
Search 5,000,000+ questions and answers.

Frequently Asked Questions

When using comma delimited ColdFusion lists, why are empty elements ignored?

CFFaq.com
ColdFusion lists are not CSV comma-delimited lists and do not behave as CSV lists do. ColdFusion ignores empty list elements, so ListLen("a,b,,d,e") will return 4 (not 5), and ListGetAt("a,b,,d,e", 5) will throw an error. To convert a ColdFusion list to a CSV list, use Replace() and replace all ",," (comma comma) with ", ," (comma space comma) - a space is a valid list member value and ColdFusion will not ignore it.

What is a Comma Delimited File (CSV)?

NARA - AAD - FAQ
AAD allows you to retrieve your search results in a comma-separated format. Comma separated files are sometimes known as comma delimited, comma separated value, or CSV files. This simply means that a comma separates the individual pieces of data so other programs can import the database and correctly handle it. Nearly every application designed to handle data, such as most spreadsheet and database applications, can import and display comma-separated files.

How do I import data from Excel or a comma-delimited text file?

Plan family, military & class reunions with Reunion Plan...
In Excel, make sure your columns have data in the correct order (press F1 for Help while in the Import screen and it will tell you the correct order) or click (or right-click) here to get a sample Excel file as a template (erase the header and sample rows after adding your data). Leave any columns blank where no data exists (look at the Alumni Information Screen using the Demo Reunion to match up the Excel Columns with the fields on the screen).

Why do you provide the data in both comma delimited ASCII text and Microsoft Excel formats?

The CID Registry of California - Contact 39,000 plus CIDs (C...
Originally, our databases were provided only in comma delimited ASCII text. A couple of years ago we added the Microsoft Excel format because we wanted you to be able to see the data immediately and become familiar with the content. Most relational database management programs allow you import the data either from either the comma delimited text file or the MS Excel file.

What about ColdFusion?

w3compiler: faqs
w3compiler optimizes CFM pages exceptionally well due to the tag-oriented approach of the ColdFusion scripting language. Optimizations are limited to white space removal and comments removal, but file size savings from these can be significant.

Can the IE settings be ignored when using an alternative browser?

xpy & FAQ
It is quite usual that some non-browser software uses Internet Explorer to download files or render webpages. As a result, applying the Internet Explorer related options of xpy should be considered.

How can I create a DSN for my database connection using ASP/ASP.NET or ColdFusion/ColdFusion MX?

RackShare.Com: Web Hosting
Please ensure that Windows services is enabled in your WebsiteOS (ASP/ASP.NET or ColdFusion/ColdFusion MX), otherwise DSN cannot be created. MDAC - Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes or the file may be corrupt." The latest MDAC (version 2.7), which is currently installed on our system, is not compatible with Access 97 databases.

Why are RewriteRules in my VirtualHost parts ignored?

Apache Server Frequently Asked Questions
Because you have to enable the engine for every virtual host explicitly due to security concerns. Just add a "RewriteEngine on" to your virtual host configuration parts.

Question: How to produce a delimited file from Oracle using SQL ?

Oracle & Financial Applications (pl/sql sql apps faq links c...
this is for file transfer between databases, spreadsheets, platforms, etc NOTE: TOAD & Discoverer also have this feature filename: xxx.sql set heading off set linesize 100 set pagesize 0 set feedback off spool c:\test.txt select jobno ||'","',nyctpm ||'","', descr || '","' from jobxref; spool off - - - - - - - - - - output - - - - - - - - - outfile: test.

What are the advantages to using ColdFusion MX for the server side of a Rich Internet Application?

Macromedia - Developer Center : Pet Market FAQ
ColdFusion MX lets you easily build Rich Internet Applications that integrate with databases, XML, web services, Macromedia Flash MX, and more. ColdFusion MX empowers developers with a productive scripting environment and integrated search and charting capabilities. You can deploy on industry-standard operating systems and harness the power of the Java and .NET platforms with the legendary ease of use of ColdFusion. Learn more about ColdFusion MX.

How can I password-protect parts of a website using ColdFusion?

ColdFusion FAQ
You can use a custom tag called CF_Login. You need to setup a DSN with UserID/Password if you haven't done so already. Here's a simple security template design I created for ACFUG. You are welcome to take a look at it if you want. The simple Access DB need to be created as a datasource called "SampleDB". It uses session variables, and requires CF4. not a solution for all apps, but gives an idea of a general security structure. All the login sequence info is stored in the _Login.

How can I run an executable or batch file on the server using ColdFusion?

ColdFusion FAQ
cfexecute enables ColdFusion developers to execute any process on the server machine. <cfexecute name="ApplicationName" arguments="CommandLine Arguments" OUTPUTfile="Output file name" timeout="Timeout interval in seconds">

Realistically, what skills do I need to be productive using ColdFusion?

CFFaq.com
You should be familiar with web and internet basics, and you should know the basics of using HTML to build web pages. You also need a good working knowledge of SQL. Armed with these you'll find yourself productive with ColdFusion in no time.

Will there be any problem using the Heil HC4 or HC5 elements with the K3?

Elecraft K3 FAQ
Absolutely not. We added a ton of Mic gain that can be dialed in form the front panel. ALL the Heil mics will work well. We also added 8 bands of RX and TX EQ to the K3. A user can tailor any mic's response to mimic their mic of choice (HC4/5 etc.) Yes to all. The MH2 is identical to our old one, except much better internal mic element mounting mechanics.

Why is the down-arrow key (LF) ignored after pressing the enter key (CR) on D3/NT using Telnet?

FAQ
Quirks in the telnet spec and D3's telnet server cause this. Open the settings dialog and select the Connection or Device tab. In the "host type" field select "D3/NT". Click OK. From the File menu choose Save to save the changes. Close AccuTerm. Reopen AccuTerm. Note: in older versions of AccuTerm which do not have a "D3/NT" host type, turn off the Binary option in the Advanced settings.

Why do you have a comma in your name? Is that a typo?

Christopher,Philosopher - Thinker, Singer, Songwriter
A comma is punctuation, representing the value of education in achieving success. We all need a leader like Christopher, Philosopher who understands the ideals and values represented by education and the comma. A comma instructs one to pause for a moment to think and then continue on. In today’s society we need more reminders for us to pause and think about the consequences of our actions without preventing us from stopping progress altogether.
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact