Re: [SQL] postgresql and ColdFusion

2003-12-08 Thread Roberto Mello
On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote: > Hi, > How to call PostgreSql function from ColdFusion, if > that function returns result set using cursor? Through ODBC. Don't know it they have native access now. -Roberto -- +|Roberto Mello -http://www.brasileiro.ne

[SQL] postgresql and ColdFusion

2003-12-08 Thread viola
Hi, How to call PostgreSql function from ColdFusion, if that function returns result set using cursor? Thank you. Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

[SQL] postgresql and ColdFusion

2003-12-08 Thread viola
Hi, Does anybody know how to call PostgreSql function from ColdFusion, if that function returns cursor?   Thank you. Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

Re: [SQL] [ADMIN] Field Size

2003-12-08 Thread Bruno Wolff III
On Mon, Dec 08, 2003 at 18:36:57 +0530, Somasekhar Bangalore <[EMAIL PROTECTED]> wrote: > There is no harm in having a field size of 1000 character provided u use the proper > datatype. Don't user char(1000). Try using varchar(1000). And if the 1000 limit is just a large number you picked rathe

Re: [SQL] Field Size

2003-12-08 Thread Ganesan Kanavathy
Can anyone tell me, what harm would setting a field size to 1000 characters do to the size?   By increasing the size, will the database require more space? Or does it only consume space if there is data in the field only?   Regards, Ganesan