Webmaster Forum / ColdFusion / General CF Topics / August 2004

I'm having an issue with a process I've got. After I have a text file uploaded
to the server, I am using CFHTTP to read the file, and then use an INSERT
statement to put the tab delimited records into the database. The problem is
that it seems to always omit the very first record ...

I've got a table with states, cities, areacodes and zipcodes in it.  Zipcode
is the main field.  There are some records that have the same zip but a diff
city, so there might be six records with 85234 as the zip but a diff city for
each.  There is also a flag field in the table.

You can use the following code to generate the random list, then just convert
it using
ListToArray():
<cfset Numlist = "">

I need to upload multiple images at once.  I am trying to store the paths into
my database, and upload the image at the same time.  However, I am running into
a problem with the #file.serverfile# variable.  Here is my code..
<!--- Set images --->

The following code generates a date of "12/30/99" Would anyone know why?
<cfset mytime = "#timeformat(NOW(), 'hh:mm:ss')#">
<cfset mydate = #dateformat(now(), 'mm/dd/yy')#>
<cfquery name="postmess" datasource="#dsn#">

Can someone tell me why it is that no matter what I do, the selected item on
every form returned, is always the value of the first record in the query?
e.g. if phot number one has a rider of Chris then the selct box in each
subsqequent photo form is Chris.  Even thoung te actual ...

A while back I created a site that would display years of data for agricultural
studies. I created a login so only authorized people could view the data. Now
I've been asked to take it a step further and allow the edit and delete ability
to each individual number on the displayed ...

Hi all, not sure this can be done, but wanted to see what you all thought.
I'm trying to have the query results I obtain through CF be output in the
following way:
* Excel [2000] opens and displays the content as a standard spreadsheet.

HI,
Greetings.
I want to know if there is a limit in the number of "hidden" fields we can
have in CFLOOP.

I'm sure this is an old question but I could not find it in the forum
archives...
I have read that GoogleBot will not index pages using session IDs.
Does this include CF pages that use <cfapplication sessionmanagement="yes"?

I have the "easy way" to get the output I desire. But if i add additional
baseplans I dont wanna have to update this query. So what I seek is some sort
of looping query that finds all plans in use from the accounts table, and
outputs them properly, please see example and you will ...

<cfset myString="She is the most beautiful girl in the world">
Can I find the number of special character?
For example, the number of "i" is 4.
The following code which doesn't work correctly will show what I am trying to

I've got a conceptual question for everyone.  I'm in the middle of
creating a new Coldfusion application that was originally written with
Access Forms and has lots of subforms on many tabs.  I've created all
the subforms as separate pages (for now) and they're linked to the

I'm trying to update one of my tables (and there are some relationships
here) but I'm getting the following error:
"You cannot add or change a record because a related record is required
in table 'tblMasterClients'".  This kinda ties to my question a couple

I have this page where I am using my database to store field names for my user
interface.  I have reasons for this.
The one problem I am facing is with my database insert.
I have a text box where the user can "update" a value