Frank,
I don't think you are getting many responses because quite simply not very
many of us use PostgreSQL.
Jason is correct, though.
You could write basic cftemplates to perform your queries. You just ftp them
up to your server and run them.
A little more robust way to do it might be (like the PHP tools mentioned by
Jason):
Create a cfml template that allows you to type sql queries into a textarea
form field. If you have multiple datasources you can also have a select box
that shows your list of datasources. For security reasons you might want to
enter a username/password into the form as well. Of course this may not be
very secure depending on your enviornment (ssl?) You should have a submit
button in the template to process the query.
Now all you need to do is write the code to take the form elements and
process them.
If you've got multiple databases you'll need to take the datasource name,
username, and password and write a cfquery using that information.
If you've got only one database you could hardcode that into your template.
Again this might not be the most secure method but that's up to you.
I might be able to share some code with you if you don't know how to do this
yourself..
Good Luck,
Benjamin Fitts
Web Developer
uclick, LLC
www.uclick.com
[EMAIL PROTECTED]
Get your favorite comics emailed daily for FREE!
Visit uComics.com - The best comics site in the universe!
http://uComics.com
-----Original Message-----
From: Jason Brooke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 11:24 PM
To: CF-Linux
Subject: Re: PostgreSQL ISP
I can't help you out with cf-linux isp's - but to manipulate your database
without a shell account is as easy as writing either a complete interface to
visually manage it (like phpMyAdmin/phpPGAdmin) or a simple script to
execute your sql statements for you.
I'm not sure how flexible the odbc interface to postgres from cf is in terms
of being able to send all commands to the server that you could with say
pg_exec() in php, but even if you can strictly send only odbc-supported sql
statements, you should be able to do most things you need.
----- Original Message -----
From: "Frank Hilliard" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 5:19 AM
Subject: PostgreSQL ISP
> A while ago I asked this question to this list and got one unhelpful
answer in response. Being a bear for punishment, I'm going to ask again
because I know some of you are dealing with
> this kind of ISP. Here's the question. Can you recommend an ISP who uses
CF Linux and PostgreSQL and who gives you Telnet access into your PostgreSQL
account?
>
> I suppose a second question would be how do you access your database if
you don't have this facility, but put that aside, I'd just like to know
who's doing this.
>
> Best regards,
> Frank Hilliard
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
