Skip to main content
I
InfoCon_Brian
Known Participant
April 23, 2008
Question

ColdFusion 8 - Client Variables don't work with PostgreSQL

  • April 23, 2008
  • 2 replies
  • 652 views
RedHat Fedora Linux
PostgreSQL version 8.2
ColdFusion version 8 Developer

Steps to create problem:
Creating Client Variables in the "ColdFusion Administrator".
checked "Create Client Variables" pressed "submit"

Results:
The "ColdFusion Administrator" errors out.

Problem:
"ColdFusion Administrator" calls a the page "postgresql.cfm", which creates the tables in the database.
Until "ColdFusion" executes the SQL "create table CGLOBAL (cfid char(64), data text, lvisit datetime)".

According to PostgreSQL website and documentation, the data type "datetime" doesn't exists."
Valid 'time/date data types' are timestamp,interval,date and time.

Question:
Is there some way of getting "ColdFusion" to "create a 'Client Variables' database" in PostgreSQL DBMS,
using "ColdFusion Administrator?
What are the SQL statements to "create a 'Client Variables' database" by hand?

This topic has been closed for replies.

2 replies

P
paross1
Participating Frequently
April 24, 2008
Have you viewed the Livedocs section at Client Variables page? It does explain the process for creating client variable tables:

Use the following sample ColdFusion page as a model for creating client variable database tables in your own database. However, keep in mind that not all databases support the same column data type names. For the proper data type, see your database documentation.

This is where you can substitute the correct data types that are appropriate for your flavor of DBMS.

Phil
D
Dan_Bracuk
Inspiring
April 24, 2008
create table (fieldname datatype, etc)

For details specific to PostGreSql, refer to their documentation. If you don't have any, google "PostGreSql create table"
I
InfoCon_BrianAuthor
Known Participant
April 24, 2008
> create table (fieldname datatype, etc)
I know how to create tables with SQL.
Hence, my statement:
"According to PostgreSQL website and documentation, the data type 'datetime' doesn't exists.
Valid 'time/date data types' are timestamp,interval,date and time."

I asked:
"What are the SQL statements to "create a 'Client Variables' database" by hand?"

Because the SQL commands in the complied "postgresql.cfm", shipped in "ColdFusion 8",
are not even close to being valid.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices