Webmaster Forum / ColdFusion / Database Access / March 2008

Should it be a possibility to use the alter session in a query ?
I would like to make something like this:
<cfquery>
ALTER SESSION SET NLS_COMP = LINGUISTIC;

Hi
Coldfusion page throwing ODBC error when Oracle (9i) Query executed. No useful
error message shown.
Same query gets executed successfully in Oracle Client.

Does anybody know how I can back up a file, and then encrypt this file?

I am trying to write a very simple query to output data based on date ranges,
but I keep encountering an error.
When I do this statement:
select * from my.table

I need to position my grid to a row depending on the value of a cfinput on the same form.

I have a coldfusion 7mx website that is attached to a ms SQL 2000 DB and all
works fine, I copied the DB to sql 2005 and now in order to use the same
queries I have to add the schema name to the query (was) database.tablename or
just tablename and (now) it needs to be database ...

Im using cfdirectory to read a directory, and then adding the filename, size,
directory into mysql 5 database.
Code:
<cfdirectory action="list" directory="D:\Backup\Cv'z" name="files" sort="Name

i want to migrate my coldfusion application to support unicode. for that i
read some articles here in the knowledge bas e and on the web. So i actually
tested with:
* correct use of cfcontent,cfprocessingdirective

Hello, helpful people!
I installed CF8 without documentation.  This caused the known issue of not
doing a full install of ODBC drivers.  I was actually doing fine (I could, for
some reason, use MySQL drivers without an issue) until I suddenly wanted an

I am experiencing the following error after migrating code from v.4.5 to MX7.
***This code:
<cfif isDefined("URL.Add")>
    <cfinsert DATASOURCE="eval"

I had a user get the following error: "Cannot create a row of size 10781 which
is greater than the allowable maximum of 8060."
Does anyone what this means and how to deal with it?
Thanks

Of late, we are seeing web application errors and intermittent log entries like
these:
"Error","jrpp-11","03/20/08","23:34:56","mycfdnsname","Error Executing
Database Query.[Macromedia][SQLServer JDBC Driver]Error establishing socket to

(I'm new to MySQL) - I'm trying to connect to a MySQL DB (below) - in cf admin
I tried:
Database = TEST1
server = localhost

I'm acquainted with setting up connections to MS Access for CF7, however now I would like to set up a connection to a MySQL database. I have no idea how to get started. Can anyone help get me going?

I have an association client that has been using MS Access to  manage their
membership roles, and once a month they send it to me for upload to their
website.  They now have requested a "online" Access type of database that will
live on their server, and they can go in and make ...