Webmaster Forum / ColdFusion / Advanced Techniques / March 2005

Hi,       I am writing a CFC which takes the array as input and return type as
string. Wondering how i can display the field properties of the array.  Fields
in MyArray are FName, LName which are strings  <cfcomponent displayname='MyCFC'
hint='CFC WSDL'>            <cffunction ...

I need to do the following with CF:
When a user visits my website, I need to get his/her IP address and thus know the country he/she is browsing from.
Is this possible?
Kindly advise

I am building a search page that look for many different information on the
database using the following syntax
<cfquery name="MyQuery" datasource="MyData">
SELECT *

Has ColdFusion MX taken care of SQL injection ?  The reason is that when I
tried to test my own application without using <cfqueryparam ...> it seems like
when I test with a form field it adds extra quotes automatically in the query
at runtime to handle this.  If this is so do we ...

Our webserver was upgraded to Coldfusion MX 6.1 from Coldfusion 4.5 and now
alot of my forms/scripts no longer work.  This is one of them.  This page
search in the PDF directory and retrieves the appropriate document; however, it
now doesn't work with the upgrade and I get the ...

Hi Guys, need your help on this please, I am trying to get the result of my
query splited in 2 columns, where in the first column will have my first half
and the second column will have the other half, can you guys help? I need that
in orther the first column the first amount of ...

I have a list I created and keep as a variable. This list is dynamic so there
is no way I can hard code this. So, the variable MUST work in my query.  
Anyways the variable I have for TownList =
'Williamstown','Clarksburg','Florida','North Adams'  I have a query that I wish

Has anyone ever tried to create a date range from a week number?  Here is my
scenario: I have a database with a primary key of weekNum.  There are 52
entries in this DB ranging from 1-52.  I want to list out these entries as date
ranges.  For example: Week 9 (Feb. 20 - Feb. 26) ...

I've been trying for exactly a month now to create databases from ColdFusion
with no success and I've used up all resources I could possibly found. Now I'm
changing my gear by creating the databases from the SQL side using a simple sql
script. I'm using microsoft SQL and I know ...

Does anyone know how I could create a variable that  would appear in the #cgi#
scope ?  I have  x number of  coldfusion servers and on each one of them I want
to hard code their names, to get around a number of bugs.  When you have debug
info turned on, you see  a number of ...

I am trying to use a drop down menu to switch pages based on the users
selection.  I get the error that 'year_select' is not defined.  What cam I
doing wrong? thanks Here is my code'   <CFFORM name='changeyear'
action='#year_select#' method='post'> <select name='year_select'

I'm trying to get conditional cfformgroups within a flash form.
For example if someone clicks on radio button named Marketing then a
cfformgroup is displayed with marketing details.
The code below doesn't work unless you comment out the "onclick" event.

I have a SQL Server stored procedure that expects an nvarchar parameter.  The
cfprocparam is sending Russian characters, but  the stored proc seems to be
receiving only question marks.   Ordinarily, an n-prefix should be used to send
the unicode string, but I get a CF error when ...

In Access I can set a default value in a date field by using Date(). How do
I do this in an SQL Server database.
Bill

I've got a timestamp field that I want to order by date. In other words, all
the entries on a particular day should be grouped under that day, and so with
each preceeding day. Unfortunately, if I group by the timestamp field, nothing
is ordered because each timestamp is different ...