Webmaster Forum / ColdFusion / Database Access / October 2007

What is the most effective way to simultaniously display three seperate dynamically generated tables all from the same data table?

yes i know its hard to explain what i mean but here goes.
if i select a query derived field say "select cost+2 as newfield", it seems
that i cnt reference this new field again withoiut typing in the formula again.
eg i cant say select cost+2 as newfield, newfield+22 as ...

Hello? Need your help in resolving a ColdFusion MSSQL task. I am building an
application using ColdFusion MX to support Russian users (Cryleric language).
1. Using cfform, the user can type their data, submit it online and can see
their posted data on the submit page (simply ...

Hello everyone! I'm quite new to Oracle PL/SQL stored procedure. Is it possible
and how do you call/execute a coldfusion file from an Oracle stored procedure?
I know that cfm files can call stored procedures. How about the other way
around? Any ideas or suggestions is much ...

Hello, please help me. I am quite new to oracle stored procedures. I have a
proc that returns data to cfm but it keeps giving zero results. But if i don't
use stored proc, the same query gives me something. please help. my stored proc
and cfm goes something like below:

I need to do a join on two databases to pull in all the data I need.  How does CF handle it when there is more than one datasource?

I need to insert a query object that originated as a CSV file ito a database table.
<cfquery name=test datasource=datasource>

Hi have this code
<cfparam name="URL.typeid" default="1">
<cfquery name="rsMake" datasource="cfocean01">
SELECT Make, SUM(qty) AS totalunit

<cfquery name="getData" datasource="#THIS.dsn#">
   SELECT FirstName,LastName,Emp_ID, Email     FROM employees
</cfquery>
Any code examples of converting above query to the below Javascript Array?

Hello everyone, I have a problem when trying to return a REF CURSOR from an
Oracle 9i database. The version of my ColdFusion is the number 6. The error
message is ".... sqlType = 2006 ....". I leave my code here. Please someone
help me. Thank you. Tommy.

Can anyone tell me why I would run into the following error when using an ODBC
Socket Connection vs the MS SQL Server driver?
"ByteArray objects cannot be converted to strings."
I am using a SQL uniqueidentifier as a folder name I want to direct users to.  

I recently reinstalled SQL Server and now I am unable to create the DSN through
CF Admin.  The name of the SQL instance was changed during the reinstall.  I
have attempted to use the new name in CFAdmin but get the following error:
"java.sql.SQLException: [Macromedia][SQLServer ...

My access.mdb is in server1's public share folder (everyone has right to change
or delete) and I am trying to connect my access.mdb from my cold fusion server
(windows 2003 r2 std). It works if i put the mdb to local but not network.
i got this error

Hi
I am using MS Access to create my database and i want coldfusion to be able to
access this. I have the following question: What is the system database file? (
iam using windows xp pro)

We are changing the database our website uses from MS-SQL to MySQL and in the
course of testing it I have found that the following piece of code will give an
error "Incorrect integer value: for column GraftYear" if the user does not type
anything for the graft year value, which ...