PostgreSQL and CFMX (OSX) Problem

[Lola Lee]

I'm trying to get the PostgreSQL database which I created on my Mac (I'm using Panther) to work through the datasource I set up in CF (6.1). I'm using Dreamweaver MX (6.0) to create the cfm files.

There are a couple of tables that I have filled with data and it should be returning data when I have my test page call it. However, I always get this error message:

Error Executing Database Query.

ERROR: relation "sweatertype" does not exist

I've tried using public.sweatertype (which is what is dispayed in Database in Dreamweaver). The other thing is that in Dreamweaver, it will not display the values stored in the table. FYI, I'm using PostgreSQL 7.4 running on :5432. Whenever I try to get Dreamweaver to load the data from a table, I get this: java.sql.SQLException: ERROR: relation "public.sweatertype" does not exist at followed by a list of java stuff.

Anybody know what's going on?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---