Fixed! was Invalid SQL error - need help

2001-08-26 Thread Jim Watkins
The interesting thing is I had to use: count(*) AS FCOUNT instead of: count(*) FCOUNT as I have done in hundreds of scripts not involving Query in a Query - Original Message - From: Jim Watkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 24, 2001 11:35 AM

Dedicated Hosting

2001-08-26 Thread Heidi Belal
Hi All, Can you please tell of a good, reliable place where i can rent a dedicated server in the US? Thanks! Heidi = Heidi Belal ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station...

Ot: sending pdf to the browser

2001-08-26 Thread Janine Jakim
I have a cold fusion page that I use to populate a pdf. On the macs it downloads to the desktop first, then when clicked it opens in the browser. I need for it to just open in the browser. This info is sensitive and I can't have it litering the desktop then rely on the user delete the

Re: Ot: sending pdf to the browser

2001-08-26 Thread Jochem van Dieten
Janine Jakim wrote: I have a cold fusion page that I use to populate a pdf. On the macs it downloads to the desktop first, then when clicked it opens in the browser. I need for it to just open in the browser. This info is sensitive and I can't have it litering the desktop then rely on the

Re: Ot: sending pdf to the browser

2001-08-26 Thread Vygandas Razhas
Try to use CFCONTENT tag From: Jochem van Dieten [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Ot: sending pdf to the browser Date: Sun, 26 Aug 2001 19:59:38 +0200 Janine Jakim wrote: I have a cold fusion page that I use to populate a pdf. On the

Re: Dedicated Hosting

2001-08-26 Thread Mark Campbell
give fred @ 1st choice international a call of email [EMAIL PROTECTED] they have great rates i cc him for you as well Mark Campbell e2bfx.com Heidi Belal wrote: Hi All, Can you please tell of a good, reliable place where i can rent a dedicated server in the US? Thanks! Heidi =

Ot: another quick pdf to browser question

2001-08-26 Thread Janine Jakim
Thanks for the replies. They make total sense. Now I have one more simple question. I am using the CFLOCATION tag to pull up a pdf form CFLOCATION URL=http://; It shows fine on a mac, but not on a pc. I get the blank screen. I added CFCONTENT TYPE=application/pdf, but that hasn't made a

Re: Dedicated Hosting

2001-08-26 Thread Matt Robertson
I've used Cybercon (http://cybercon.com) since last December. Great prices, humans available 24/7 to deal with whatever you call in on. Phone never needs more than a couple of rings to get picked up. Connection fully reliable. You'll have to supply all software licenses. Cheers,

RE: Dedicated Hosting

2001-08-26 Thread John Lucas
Our complete server farm is in the Cybercon datacenter as well. We've utilized their dedicated boxes but have moved to our own equipment in their datacenter. We've had 100% uptime with them, multiple fiber backbones. They are located in St. Louis and we are up near Chicagowe've been to

windows media player

2001-08-26 Thread Heidi Belal
Has anyone done audio and/or video streaming? I'm trying to stream this music file online through windows media player. All i've been able to do is to create a href that will pop up the windows media player and stream the music. I would really like to have the windows media player embedded in

RE: windows media player

2001-08-26 Thread Angel Stewart
Off topic post Alert! Off Topic Post Alert! :) CF-Community list for the off topic question. But anyways, I've done this before and its relatively easy. Use Windows Media Encoder or Windows Media Publisher (all on Microsoft website...I think it is www.microsoft.com/mediaplayer to get to it) and

Create a dynamic array

2001-08-26 Thread Julia Phu
Hi, Gurus, I'm having problem with creating an 2-D array dynamically. I have two tables that are updated daily. Hard coded 3000 rows on an array is not a way to display data. Can someone shed some light on how to do it? Can you direct me to any source that cover how to do it? Best Regards,

Re: Create a dynamic array

2001-08-26 Thread Jeffry Houser
When you say tables, do you mean HTML tables or database tables? Where are you getting the information from? A Query? Queries are stored in memory as an array of structures. You should be able to display the data using a simple CFOUTPUT or CFLOOP. At 02:49 PM 08/26/2001 -0700, you

RE: reload of services

2001-08-26 Thread Dave Watts
Does anyone know were the SiteMinder services are loaded from? I uninstalled CF 5, SQL 7.0 and IIS 4.0 and now get the error notice that these 2 services cant start because they cant find a file. if they were part of the programs I uninstalled shouldn't these services been removed along

RE: which web server do you use for CF?

2001-08-26 Thread Dave Watts
A little off topic here, but I am wondering about your statement concerning PHP/Apache on a win2k machine. I was unaware they would run on a windows box as I thought both were Linux only apps. I like to have as many ways to get from idea to solution as possible and your idea bears looking

Using ColdFusion to create/manipulate Database tables

2001-08-26 Thread Mike Brunt
We have just joined a hosted environment and although we have access to SQL Server via enterprise manager, we do not have the facility to import/export tables via enterprise manager. Can anyone point me to a resource or give some good tips on using CF to manipulate-add-delete tables in a SQL

Re: Using ColdFusion to create/manipulate Database tables

2001-08-26 Thread Jeffry Houser
At 04:57 PM 08/26/2001 -0700, you wrote: We have just joined a hosted environment and although we have access to SQL Server via enterprise manager, we do not have the facility to import/export tables via enterprise manager. Can't you just use DTS to create the table objects via Enterprise

Custom tag form calling itself .. how?

2001-08-26 Thread Mike Kear
I have a login form that's being called as a custom tag and I'm not sure how I get the form to loop back on itself until the user gives a valid username/password. The reason for calling it as a custom tag is that it could be called from a variety of places. I can't use CFModule because I can't

Re: another quick pdf to browser question

2001-08-26 Thread Stephen M Aylor
its one . cflocation | cfcontent or the other - not both - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, August 26, 2001 11:44 AM Subject: Ot: another quick pdf to browser question Thanks for the replies. They make total sense.

OT: ODBC error please help

2001-08-26 Thread Dian Oktosoma
Please help me, how to fix this: ODBC Error Code = S1000 (General error) [MERANT][ODBC SQL Server Driver]Unicode conversion failed SQL = select count(distinct tracker_id) as sessions, min(datetimestamp), case Referrer when '' then 'No Referrer' else Referrer end as ref_site from SiteTracker

Re: Ot: sending pdf to the browser

2001-08-26 Thread Stephen M Aylor
if using cfcontent - provide the UNC path to the fdf on the server C:\inetpub\blah\myWorldFamousForm.fdf If cflocation - provide the URL [http://yourServer.com/studentForms/myWorldFamousForm.fdf] and again - its one method or the other - not both in the same script/page. I wasnt sure if your

RE: sending pdf to the browser

2001-08-26 Thread Tilbrook, Peter
Janine, First stop would be www.adobe.com to learn the MIME type that Acrobat expects. eg: application/acrobat (MS Word uses application/msword for example) - this may differ for the MAC and may need to be configured on the web server. Chapter 34 of Ben Forta's excellent Macromedia ColdFusion 5