Webmaster Forum / ColdFusion / Advanced Techniques / October 2007

It works from Monday - Saturday, but bombs on Sunday
Message Incorrect number of columns in row.
Detail Verify the number of columns specified in the columns attribute and
in the target file

Hi i have a delete function using MS SQL.
DELETE FROM TABLE
WHERE DATEDIFF(d, InDate, GETDATE()) >= 28
this should delete any entries that are 28 days old, but "InDate" is a

I have some string,I want to get the string's byte length,how can do it?
for example:
<cfoutput>#len('hihi?????')#</cfoutput>
output is 9

I have a function that joins 7 csv files via cfhttp. I want to be able to
use that master query and search against it.
In another function I attempted to set the value of a variable to the result
of that fuction and then use QofQ to refine it but I am getting this error:

I have a lagacy database that I need to run a query on like the following. Can
anyone tell me how I can achieve the following.  Right now I am getting an
error that PubYear is not a valid column.  Thank you!
        SELECT       AdINFO_Publication,  

Can anyone please tell me how I can get the ins_id's to group so that the
dollar amounts sum up properly? My SQL and current out put is listed below.
<cfquery name="result" datasource="#application.data#">
   SELECT i.ins_id, sum(p.pur_quantity) * t.tic_rate AS dollar

For simplicity, I have a function that will add 1 to a number a user will enter
from a form. So if the user enters the number 2 and submits the form, the next
page will display 3.
If I enter the following code in SQL Plus, I get 3:

Ok, I am trying to get my website to display a unique web adderss for each
username in my SQL database.  For example:
username "testusername" would pop up a website entitled
"www.example.com/testusername".

I am somewhat new to coldfusion and am making a script that will read RSS docs
and grab all of the item elements without having to worry about which version
of RSS the doc is.  I am trying to  use the getElementsByTagName function to
accomplish this.

I inherited this applicaition and users are requesting to search by date so I
am looking for a way to better query my SQL database.  Here is the actual
query:  <cfquery name="GetPartInfo" datasource="#Plocekdsn#">
  Select * From Parts Where 1=1

Hi All,
I am a newbie to Coldfusion. My experience is predominantly in Oracle. I am
caught up in an issue and would like to discuss the same in this forum.
Technical Specifications : Database - Oracle 8i, Front End - ColdfusionMX 6.1

I have some code I'm trying to get to work with JBuddy (AIM gateway).  I have
CF8 std so I have 1 gateway.  I need to allow multiple users to download their
buddy list.  
Users will fill out a form with username/password and this will be written to

I have a feedback table in my database - the fields are: availability,
revelancy, timeliness, etc. What I want to do is a bar chart to show the
average (user can choose 1-5, 0=N/A) of each of these fields. The beginning of
the code is below ...I'm getting all of my data on the ...

I am currently developing a web-based game website using Coldfusion 8 and MS
SQL.
Until recentely, things have been going well. But I am now stuck on a small
issue of using an in-game skill system.

When one goes into the Administrator and correctly verifies that the SMTP email
server connects with admin:xxxxx@192.168.1.10 on the LAN (xxxx being the
password value for the ditomasos.com email server), then why can't I put that
email server's internal IP address instead of ...