Webmaster Forum / ColdFusion / Database Access / December 2007

Anyone out there able to provide assistance? I created the RDS
configuration, but it tells
me Eclipse cannot connect.... CF8 debugging turned on; port, server, and
admin pw

I do a lot of things like like:
<cfset selectStatement="select id, someText, someValue from myTable ">
<cfset whereStatement= " where id=#form.getId# ">
Then

I recently upgraded to CF8 and have started having problems with cfstoredproc.  
Here is the code:
<cfstoredproc datasource="#request.myDSN#"
procedure="dbo.p_online_password.get_account" >

I am trying to build an insert statement by concatenating strings. Basically,
this is what I'm doing:
<cfset string1 = "INSERT INTO #tablename# (">
<cfset string1 = string1 & #colname#>

i have a form that is inputting form data into my sql db...that works fine.  in
the same script, a confirmation email sends information of from this to an
administrator.  however, all this info that is sent is being taken from the
form, not the db.  the code is INSERTing the data ...

I am getting an error trying to connnect CF to Oracle via ODBC on our
server: "TNS could not resolve the connect identifier specified".
The thing is, the ODBC connection *works fine* for other apps, such as
MS-Access. It just does not work for ColdFusion MX 7 on Oracle (and CF

I have a set of data that I want to display in a HTML page.  My problem is that
I want to basically drop my data into a set of available buckets without
knowing what actual data exists.  An example,
dbTable1

Problem:  A basic "select *" query returning 5 rows is taking a little over
5000ms.
Platform: Vista Business, CF8 Developer, MS SQL 2K5 Developer SP2, ODBC Socket
using trusted connection

# Connection verification failed for data source: Test
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink
Server]Unable to retrieve error message from backend ODBC Driver.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC

I created an ODBC connection to connect to an Excel Workbook which I can use
as database.
In CF Admin -CF 7 (Datasources), I put "DSExcel" as datasource name and "ODBC
Socket" as Driver. But am getting the following error when trying to verify the

Ok I'm trying to order by a column which consists of numbers, which works,
however, I want the high numbers at the top not the bottom. Now I know DESC
works for alphabetical entries, but what works for numbers? This has to be
simple. Thanks!

I am getting this error when a form is submited from my site....Basically the
user answer some questions, and then after the submit button is pressed, the
script is supposed to check the user answers with the answers I have on the
Database, but when the script is ran, it gives me ...

I am trying to write a small app that is making use of 2 tables in a DB. I
wanted to break this down into a few steps, starting with making step 1, and I
kind of need help. I am not sure how to write this. I am posting what I have so
far and I will comment out what I can't figure ...

I'm having a bear of a time tracking this down, and I suspect it's something
easy and syntactical, but it's making me insane.
I'm renaming/moving files to a different directory, setting variables based on
the new filename and a friendly file title, and then I want to write those ...

I'm querying purchase order information from an AS400 server, and saving it to
a SQL database in another location.  The header information and the individual
lines come from separate tables, and will save to separate tables (yay normal
form!).