Webmaster Forum / ColdFusion / Database Access / July 2008

I am able to write CLOB data type on to the Oracle database.  I would like to
know how to read CLOB data type from database because the text buffer size in
coldfusion is restricted to 64000 bytes. Please help me with your ideas.  
Thanks in advance.

I need  to use contexts in Oracle so the first step requires me to execute a
procedure and then execute a query.
Doing single tests this works perfectly, however my doubts arise for the
scenario where 2 concurrent accesses for the database. each one sets the

Upgraded  from CF7 Enterprise on Windows to CF8 Enterprise. After the
installation, the "ColdFusion 8 ODBC Agent" and "ColdFusion 8 ODBC Server"
services are not started. Tried to start them manually and the directory where
the services point to (D:\ColdFusion8\db\slserver54\bin\ ...

I been having no success in connecting to a Mysql database withing the
administrator. I am certain that the sql server is running and a database is
created. When I try to create a Datasource in the administrator, I get a
"sql exception error" Any suggestions?

I are trying to create a display value of FullName using the CANCAT function
and I am getting the following error:
'CONCAT' is not recognized as a function or procedure.
The following is my code:

I have a coldfusion application which I am using mySQL 5 database with.  When
I have a new client that wants to use the applicaton is there a way for me to
create a new database / datasource on the fly using coldfusion and then copy
files to a new folder on the web server.

I have a query I am running against an Oracle 9i db that has to check a list of
codes.  The query listed at the bottom of this post runs fine using
PreserveSingleQuotes to pass my comma-delimited list.  When I attempt to
replace the CF variable #PreserveSingleQuotes(Variables ...

Hi, first time poster and new to Coldfusion!!!
I have created a udf in SQL Server that accepts a staff
number and returns an integer. This is then called from within a component as
follows:

This is probably the dumbest question I've posted yet, but my mind is numb and
I'm not getting anywhere, no matter how much I google terms.  
I have three tables in a MS Access DB:  Owners, Vehicles, Other.  Owners is
owner info, Vehicles is car info, Other is misc items info.  ...

Hello all Gurus,
question:  Is it possible to use MS Access (XP and later) to connect
to a Access Database that is sitting on a coldfusion server?
A user has built a Access Database with A LOT of customized forms, and

I've been searching forums for quite a while now trying to find a solution to
this problem. I intend to set up a client login system for a web design
venture, this would allow a client to login and then be able to view the status
of their project.

i have a select box that needs to allow for multple selections.  
<select name="location_id" multiple="yes" size="4">
<CFLOOP QUERY="get_locations">
<OPTION VALUE="#qry_location_id#"<CFIF qry_location_id EQ location_id>

Select Id from schedule where #06/23/08 10:30 PM# between sch_date + ' '
+sch_time_start And sch_date + ' ' + sch_time_end;
Is above a valid statement ? if Not how would I fixed it. sch_date and
sch_time_start are dateformat in ms access.