Webmaster Forum / ColdFusion / Advanced Techniques / May 2006

query results:every other record/row grey and white
how would you make every other record/rows a different color just like the
forums color.  Lightest grey and white?
<cfquery name="Myqueryname"

i have the following query to perform
<cfquery name="products" datasource="#client.dsn#"
username="#client.username#" password="#client.password#">
Select * from Products

With custom tags, there's a 'ThisTag' variable.  Is there an equivalant for
functions?  How does a function know who it is?  The 'this' scope seems to call
the parent, and the function's name is present in the local 'variables' scope,
but there's nothing to indicate who is is.   ...

I want to check a form variable against a value in the database, if that value
is not there, I then want to insert into the datbase. If the value IS there,
then I want to return what the database has. I can do this in the code, but
since I want to do this in many different pages, ...

I am using the code attached to upload a file, it should only accept gif or
tiff files. When i upload a tiff file, cffile reports the file as image/jpeg
instead of image/tiff. I have tried using several different files with
different tiff compression types etc and no luck.

I have some legacy C code.Does anybody know how to
call it  from Cold Fusion?
Thanks!

I am passing a number of variables via URL in order to sort a dataset.  The
problem I have is that if I also have a submit form on the same page, such as a
dropdown to select a certain status, or a list of items that I can checkmark,
the variable that I originally passed with ...

Is it possible to use Java libraries already installed with MX7, from a custom
.class file?
Say with something like the attached code... I compile it with iText.jar from
the MX7 install \lib dir in the classpath, and copy it to the WEB-INF\classes

First of all, I am a ColdFusion novice, so please forgive me if the answer to
this is either blantantly obvious or totally impossible. Here is my problem.
I am querying a database with several hundred records. The query will return
on average between 10 - 15 records. I then want ...

I have two tables.  One with raw data and one with summary data.  There is a
form that the raw column data is input into then on submit I use a cfloop
function to get the data into the same column in the raw data table.  I can't
seem to figure out an easy way to calculate the max ...

Hi i have just changed my database from access to mysql, there is just one
error i have
could someone tell me why this is any how i could fix this
many thanks

i'm trying to find a way to determine whether the current browser is runing
over secure or not. I can't find anything that will detect the first part of
the URL:
   http:// or https://

I am new to Coldfusion and am having trouble doing the following:     When the
users click on a button, all the folders on a CD drive or on a USB drive,
should be parsed automatically, and whichever folders contain the .ini file
type, all the files from that folder should be ...

I have been wrecking my brain on this and I am sure that it is possible I am
just not sure what the proper search expression is.
If I have an XML document like this:
<items>

I have an XML file that I read in using CfFile and then XmlParse.  Once I have
it as an XML document I can loop through the records with no problem.  But the
size of the XML file is starting to get rather large.  So instead of looping I
would like to use XMLSearch or some other ...