Oracle Access in MX7
Hi
Coldfusion page throwing ODBC error when Oracle (9i) Query executed. No useful
error message shown.
Same query gets executed successfully in Oracle Client.
Point | | 0 | 75 | 3/29/2008 12:45:53 PM |
Encrypting a SQL Server 2005 DB
Does anybody know how I can back up a file, and then encrypt this file?
| | 2 | 79 | 3/28/2008 9:48:40 PM |
Newbie Setup MySQL on Mac Tiger
Newbie I need help Setting up MySQL 5.xx on Mac Tiger (for CF8). I'm not good with command line stuff. Is there a GUI? Any help would be appreciated
| | 1 | 86 | 3/28/2008 8:50:12 PM |
Query output based on date - Oracle 8i
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
where sta | | 6 | 118 | 3/27/2008 8:10:44 PM |
Data type correct for some records, not for others
Hello~
I am adding records to a table from another with an Append query in Access.
The column names and types are exactly the same. However, when I look at the
query results on a w | | 4 | 119 | 3/27/2008 3:33:46 AM |
Problem after upgrading ms sql db
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 | | 3 | 79 | 3/26/2008 8:12:48 PM |
cfgrid row posioning
I need to position my grid to a row depending on the value of a cfinput on the same form.
| | 0 | 97 | 3/26/2008 6:45:37 PM |
CFGrid in CF8
I'm trying to create a very basic data grid using CF8, but it shows no rows
every time. I know the query works on it's own. What am I missing?
<!---survey.cfc--->
<cffun | | 10 | 88 | 3/26/2008 6:43:02 PM |
Loosing / in sql
Im using cfdirectory to read a directory, and then adding the filename, size,
directory into mysql 5 database.
Code:
<cfdirectory action="list" directory=&qu | | 2 | 76 | 3/26/2008 2:31:27 PM |
Using Unicode with MS-SQL-Server 2000
Hello,
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:
* corre | | 1 | 84 | 3/26/2008 11:38:35 AM |
Creating ODBC socket connection to Excel
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
som | | 16 | 151 | 3/25/2008 3:47:31 PM |
Migrating from CFv.4.5 to MX7
I am experiencing the following error after migrating code from v.4.5 to MX7.
***This code:
<cfif isDefined("URL.Add")>
<cfinsert DATASOURCE="eval" | | 1 | 79 | 3/24/2008 4:52:33 PM |
CF8, Mysql, Date and Time 1 hour behin
Hi Guys we have CF8, and we are using Mysql 5.0 the connection with the
database is perfect
but we have a very estrange problem we store date and time information into
the database
| | 1 | 95 | 3/24/2008 4:26:25 PM |
Exceded Maximum Row Size
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 wit | | 7 | 94 | 3/21/2008 6:53:16 PM |
JDBC "Address already in use"
Of late, we are seeing web application errors and intermittent log entries like
these:
"Error","jrpp-11","03/20/08","23:34:56","mycfdnsname& | | 3 | 186 | 3/21/2008 4:55:26 PM |
Quick Help Needed - Connecting to MySQL DB
(I'm new to MySQL) - I'm trying to connect to a MySQL DB (below) - in cf admin
I tried:
Database = TEST1
server = localhost
port = 8888
user = root
pass = root
< | | 3 | 97 | 3/20/2008 11:31:26 PM |
Newbie Setup MySQL connection to CF7
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?< | | 6 | 90 | 3/20/2008 7:39:40 PM |
Options for online version of Access???
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 &quo | | 3 | 116 | 3/20/2008 7:37:09 PM |
Oracle Stored Procedure problem
I am upgrading to Coldfusion 8 from MX. I currently have a program that
accesses Oracle 10g using a stored procedure call (cfstoredproc). It works on
MX but not on 8. I can do regular querie | | 1 | 146 | 3/20/2008 5:18:11 PM |
Reading IP Address from csv file insert into database
Here is what i have
<CFFILE action="upload" destination="d:\NESECDB\Uploads" filefield="file1"
nameconflict="overwrite">
<CFS | | 4 | 104 | 3/20/2008 2:33:40 PM |
Blockfactor?
G'day
I'm just auditing some client code, and came across a <cfquery> tag using a
BLOCKFACTOR attribute. Something made me stop and think "hmmm... I seem to
recall that doesn't | | 5 | 129 | 3/20/2008 7:03:29 AM |
Connecting to Access DB from Dreamweaver
Hi:
I am trying to connect to an Access db using Microsoft Access with Unicode
from Dreamweaver and getting a popup dialog box that displays, "The following
error has occured while | | 1 | 98 | 3/19/2008 7:42:00 PM |
Random Record from a Query
I have a page on my site that displays certain information in kind of a
"feature" section, where it needs to query the database based on certain
criteria and then display the data | | 9 | 88 | 3/19/2008 3:33:40 PM |
Incorrect Syntax
Below is the error I recieve - Im close because its passing the data through
but it stops here. I have ticks by the email and reason on purpose. Pretty sure
thats how it should be done. Tha | | 7 | 106 | 3/19/2008 1:11:56 PM |
query problems
does anyone know why the program would be entering the same field everywhere,
when i tell it to enter dynamic text, it only enters the first field of the
database. I am a beginner, with cold | | 3 | 87 | 3/19/2008 10:07:47 AM |
Frequent "Error Executing Database Query" errors?
I am getting frequent "Error Executing Database Query. Timed out trying to
establish connection" errors after upgrading our server to version 7. These
errors only occur with applic | | 2 | 95 | 3/18/2008 5:57:32 PM |
Net8 protocol error
I am getting Net8 protocol error even after loading the Data Direct Drivers 3.5.
Please advise.
Ram
| | 0 | 110 | 3/18/2008 5:51:32 PM |
Cold Fusion Websites fails
I have site on a Cold Fusion MX Version: 6,1,0,hf45343_611 running on A Windows
2000 server and IIS5 using a Microsoft SQL 2000 Cluster in the backend. When
ever the cluster fails over the w | | 0 | 113 | 3/18/2008 3:36:40 PM |
Problems to send emails from CF 5.0 - processor 100%
Hello,
I have a problem to send emails from the ColdFusion 5.0 Server. The first
email (only text emails - 1 KB) load to the spool folder. The server (all
entries for the email server | | 2 | 80 | 3/17/2008 11:57:30 PM |
Query on Query giving less records
I have a query say A whcih gives me a record set of around 96 records. I have
another query B where I select distinct of userid and username from the query
A. On the web page when I display | | 2 | 78 | 3/17/2008 2:04:53 PM |
CF8 & ODBC
hi does anyone know why is the ODBC agent & server services cannot started?
WinXP, CF8 Dev. Edition and MS Access.
| | 8 | 99 | 3/17/2008 11:48:25 AM |
Malformed GUID in hosting migration
I am moving a site from a Win2k3 server running IIS6, CF7 and using an MS
Access database to new hosting provider. I'm using their Windows Hosting option
so I can just set up the access data | | 2 | 73 | 3/16/2008 8:34:34 PM |
CF 4.5 and MS SQL 2005
Any quick and easy points or guidance to getting these two to play together?
We are in the unenviable position of having to get some maintenance,
enhancement code installed on the venera | | 4 | 82 | 3/15/2008 9:05:35 PM |
Microsoft Acces Data Base / MAC OSX
(sorry my english)
I have the Server Configuration installed in MAC OSX running in MAMP.
I have a problem conecting an Acces Data Base ("Can't load library: c:\program
files\i | | 2 | 87 | 3/15/2008 8:30:56 PM |
CF8, MS-SQL, scope_identity()
In CFMX 6-7, I used to write the following:
<cfquery dbname=name dbtype=odbc name=myInsertQuery>
insert into myTable (field1,field2,field3) select top 1 'VALUE1' as
value1,va | | 12 | 106 | 3/15/2008 7:03:03 PM |
Problem Connecting to VFP Free Table
ODBC Error Code = S0002 (Base table not found)
I am having a problem connecting to a data source with ColdFusion 5.0.
I have data sources setup FoxPro on both the same server that | | 2 | 98 | 3/14/2008 4:43:38 PM |
Oracle Sessions Hanging
I am developing a cold fusion application using Dreamweaver 8 that runs on a
windows nt server and using an Oracle 10 g database on a unix box. Everytime
Dreamweaver is opened with a page th | | 1 | 126 | 3/14/2008 1:40:55 PM |
newbie help
Hi,
my site was recently moved by the webhost and now the site cannot connect to
the db, they have changed the pass for the db.
Where in my site will I find the password used to c | | 4 | 93 | 3/13/2008 9:22:52 PM |
Storing WORD or PDF files in SQL database
Can WORD document or PDF documents be stored in SQL database? If so, how? I
would like an example (if possible).
I do realize that I can store a reference pointer that points to a physical < | | 1 | 112 | 3/13/2008 3:05:56 PM |
Rename columns within a query?
Is there a way that I can rename a column within a coldfusion query? I've
attached an example.
I've joined a table with the same table here and have named them A and B. I
want to b | | 2 | 92 | 3/12/2008 3:06:14 PM |
Datasource could not be found
Been working on this problem for several days now. My CF 7 server with
developer configuration (using the built-in CF server) is fine, so I copied my
production-ready site to my new CF 8 pr | | 7 | 173 | 3/11/2008 4:10:06 PM |
Error Message Says File Doesn't Exist...
Hello. I'm trying to install a CF website on the same server with an ASP
website which is already up and running. Both sites will access the same FoxPro
data, which may lead to conflicts I'l | | 1 | 86 | 3/8/2008 9:06:36 PM |
ODBC vc. JDBC
We are moving, (hopefully,) from CF5 to CF8, and from SQL Server 2000 to SQL
Server 2005. My question is on the database access - is there a performance
improvement going with JDBC instead o | | 1 | 84 | 3/8/2008 12:55:47 AM |
Help, any suggestions on this connection problem
I've reinstalled CF 8 on my Mac 10.4 Server because of problems with connecting
to my MySQL database using DWCS3 located on my MacBook Pro Client. The CF8 had
no problems in launching on my | | 0 | 85 | 3/8/2008 12:35:22 AM |
Can CF and ASP Access the Same Database?
Hello. I'm about to go into beta with a ColdFusion 8 site I just wrote, and
I've just realized there could be a problem I haven't anticipated. There's
another site, written in ASP, which wil | | 9 | 71 | 3/7/2008 9:18:16 PM |
joing tables with different databases
Hi, I just wonder if it is possible to do it in CF. I will have to make
calculations based on records from two tables. Each table belongs to different
database and databases are located on d | | 6 | 102 | 3/7/2008 8:08:55 PM |
CFQUERY and Memory
Im trying to free up some memory and have a few questions..
Ive read that you can set <CFQUERY name="session.queryname"> in order to cache
the record set. Im confused a | | 7 | 99 | 3/6/2008 7:39:33 PM |
Choosing most recent records from multiple tables?
Let's say that you have two tables; one contains news articles with the fields
TITLE, ARTICLE, and a timestamp DATE and the other contains different news
articles with the fields TITLE, DESCRIPTIO | | 4 | 92 | 3/6/2008 3:18:38 PM |
SQL ALTER TABLE Question
Hi,
I'm fine changing the field type on a single field using the following sql:
ALTER TABLE #TP#_TemporaryTable
ALTER COLUMN Price double
I need to change multiple f | | 3 | 85 | 3/6/2008 4:12:32 AM |
Coldfusion Query Delay Problem
Folks we are having some intermittent problems with our application web servers.
We are using coldfusion to serve data from Oracle databases. SELECT statements
only, no updating of the | | 2 | 81 | 3/6/2008 1:39:06 AM |