Hey Jordan, I can download PostgreSQL, but I have never heard or used the product before. My new web server is not up yet, so I am doing everything locally right now. Steve
________________________________ From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Wed 7/12/2006 5:06 PM To: CF-Talk Subject: Re: Calendars Hi Steve, Looks like you're attempting to run the PostgreSQL script in MySQL. Do you have access to PostgreSQL or MS SQL Server? I've had reports that MS SQL Server can process PostgreSQL SQL code just fine. If not, I'll see what I can do about digging up the MySQL schema. It wont be pretty because I'll be pulling it from the installation script we have in version 1.0 (which is unfinished), but it *should* work. ;) -Jordan Steve LaBadie wrote: >Jordan, > >Every time I run the SQL I get the following. > >#1064 - You have an error in your SQL syntax. Check the manual that >corresponds to your MySQL server version for the right syntax to use >near '"user" ( > "UID" character varying(20) NOT NULL, > "OID" > >Steve > >-----Original Message----- >From: Jordan Michaels [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 12, 2006 1:02 PM >To: CF-Talk >Subject: Re: Calendars > >Steve LaBadie wrote: > > >>Has anyone had success with CF calendars? What I would like to do is >>show events by type (i.e., all events, academic camps, athletic camps, >>music camps, other camps). >> >> > >http://calendar.viviotech.net/ > >Does that, and a bit more. Still in beta, as we haven't had too much >time to put into it lately. It was inspired by a calendar I made when I >was working at a Community College. They wanted a place to post their >events and a way to categorize them. > >If we're pestered about it enough, we could probably be convinced to >release the version 1.0 we have almost done. It includes database >schemas for both MySQL and PostgreSQL, has an installation assistant, >and has better theme control as well as some bug fixes. > >Hope this helps! > > > -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Blue Dragon Alliance Member [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246365 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
