RE: ALTER TABLE syntax

2002-01-09 Thread Dave Watts
> Any idea what's wrong with this SQL? > > ALTER TABLE test > ADD COLUMN testNum BYTE NOT NULL DEFAULT 5 > > This is using Access 2000. It seems to be the DEFAULT > that's causing problems (works OK with just NOT NULL, > or without constraints altogether). > > Even statements copy-pasted fr

Re: ALTER TABLE syntax

2002-01-09 Thread Douglas Brown
P.S I may be a little off due to the way SQL was handled after version 7 from MS. In version 7 you had to use the WITH clause and for 2000 it is without the WITH clause. Not real sure about access 2000. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't bel

RE: CFEXECUTE output to page

2002-01-09 Thread Brendan Avery
oh -- btw; when running cfexecute in coldfusion on windows 95/98, the shell window will be visible on screen when executed (and remains after process is completed.) i built a little .dll to handle hiding it if anyone is running cf on a 95/98 machine (not that you should, but hey, it's a powerf

RE: CFEXECUTE output to page

2002-01-09 Thread Brendan Avery
you're right. i just love replying to posts without reading them first. :p,, -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 17:33 To: CF-Talk Subject: Re: CFEXECUTE output to page But that doesn't accomplish anything beyond what you c

Re: ALTER TABLE syntax

2002-01-09 Thread Douglas Brown
Should be more like this shouldnt it? ALTER TABLE test ADD COLUMN testNum BYTE NOT NULL WITH DEFAULT 5 You need the WITH clause. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Mes

Re: CFEXECUTE output to page

2002-01-09 Thread Jim McAtee
Ok. Figured it out. You MUST set a timeout attribute value if you want to see results output to the page. Makes sense. Without the timeout (or a timeout of '0') the process is spawned, but CF doesn't wait for it to complete. Jim - Original Message - From: "Jim McAtee" <[EMAIL PROTEC

Re: Better Javascript/DHTML Calender!

2002-01-09 Thread han peng
hihi... mind if u can send me a copy of that pls..?!! cheers han - Original Message - From: "ronmyers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 4:12 AM Subject: RE: Better Javascript/DHTML Calender! > I got it. Must of been the last one for

Re: CFEXECUTE output to page

2002-01-09 Thread Jim McAtee
But that doesn't accomplish anything beyond what you can already do with the outputfile attribute. Namely, you specify a file, read it with CFFILE, and then display the contents on the page. The documentation suggests that these steps should be unnecessary if you merely don't include the attribu

ALTER TABLE syntax

2002-01-09 Thread Gyrus
Any idea what's wrong with this SQL? ALTER TABLE test ADD COLUMN testNum BYTE NOT NULL DEFAULT 5 This is using Access 2000. It seems to be the DEFAULT that's causing problems (works OK with just NOT NULL, or without constraints altogether). Even statements copy-pasted from the MS Jet SQL re

Re: how to prevent user from opening multiple browsers..

2002-01-09 Thread han peng
hi.. mark and lewis.. thank you very much for yr suggestions.. i'm running my application in intranet.. so mark suggestion is useful... but how do i capture the ip?? to a database..? or?? pls shed some light to it.. as for lewis.. yr method cant restrict people from having 2 different logins at

RE: CFEXECUTE output to page

2002-01-09 Thread Brendan Avery
MS DOS fun factoid #29484: you can generate output from any console program by following the command line with a > and the name of the output file; ala: C:\myproggie.exe > C:\output.txt ::brendan avery 2.0 ::310.779.2211 ::[EMAIL PROTECTED] ::santa monica, california -Original Message-

CFEXECUTE output to page

2002-01-09 Thread Jim McAtee
In the CF5 docs, regarding cfexecute's 'outputfile' attribute, it states: "Optional. The file to which to direct the output of the program. If not specified, the output is displayed on the page from which it was called." While outputfile seems to work as advertised when I specify a file, I'm not

RE: DBTYPE=Dynamic

2002-01-09 Thread Douglas Lamb
This is not a permanent data source, thus there's no entry in "CF Admin". The dbtype is dynamic. Douglas -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: January 9, 2002 7:51 PM To: CF-Talk Subject: RE: DBTYPE=Dynamic uncheck the MAINTAIN DATABASE CONNECTION checkb

RE: Weird Join (o8i)

2002-01-09 Thread Bryan Love
put this in your SQL statement: ORDER BY [bookName?],[authorName?] You'll still get two records for one book, but you can control the output with CF like so: #bookName# authors: #authorName# the outer loop will only list each book once while the inner loop will iterate over

RE: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Brendan Avery
I believe that to get ACCESS table names you would could either use a COM interface for Microsoft DAO ... or if MS ACCESS itself is installed on the server, you could use the "Access.Application" object to get access to the file: I don't remember what the prope

RE: DBTYPE=Dynamic

2002-01-09 Thread Bryan Love
uncheck the MAINTAIN DATABASE CONNECTION checkbox in the CFAdministrator and the lock will be released after the Excel file is read. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunicat

DBTYPE=Dynamic

2002-01-09 Thread Douglas Lamb
I've got a dynamic datasource, correctly accessing an EXCEL spreadsheet. However; the connection does not close, and thus locks the file. How do I force the ODBC connection to release the EXCEL file ?? Thanks. Douglas __ Why Sh

RE: Suggestions for Mag Subscription Billing Application

2002-01-09 Thread Paris Lundis
cold fusion it :) not an impossible system... would be interested in hearing about anyone's online subscription system they might have built :) -p -Original Message- From: Paul E. Cross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 19:49 To: CF-Talk Subject: OT: Suggest

OT: Suggestions for Mag Subscription Billing Application

2002-01-09 Thread Paul E . Cross
Hi, Something needed to keep track of 1000 subscriptions, monthly invoices, payments, etc. My company's accounting department uses MAS90 which looks too detailed and involved. Can anyone recommend a lower end, smaller program which may be a better fit? My ideal would be a custom Microsoft ac

RE: Calling Stored Procedures via ADO

2002-01-09 Thread Craig Fisher
umm... According to OLEview the forth argument of the Open() method of the Connection Object is "Options" and its default is -1. Whenever I can I make it a habit of specifying defaults. -Original Message- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 4:48

Weird Join (o8i)

2002-01-09 Thread Troy Simpson
Problem: I perform a Join and I get two records for a book with two authors. I do not really want two records. I would like to have one record for the book with both(or more) authors on the same row. Anyone run into something like this before? If so, how did you resolve it? Here is more infor

RE: CFMail and html/text

2002-01-09 Thread Joseph DeVore
Yes, I have had the same problem. That is why I wrote CFX_SMTPMAIL to send straight to the SMTP server and skip CFMAIL and it's SPOOL altogether.. It supports multipart messages, cc, bcc, x-headers, replyto, smtp authentiaction, attachments and more.. It works very well when the CFAS and SMTP serv

Re: Yet another Netscape 4.75 question ...

2002-01-09 Thread Douglas Brown
Another thing that I noticed with NS 4.75 is the amount of whitespace that is present. I would view your source and check and see if you have it in yours. Mine had about 600 lines of white space in it. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't belie

RE: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Bryan Love
this code works for SQL Server 7. I don't know how to do it in Access (assuming it's possible). I do know that you instantiate a windows object using CFOBJECT that will give you what you need, but that's probably more involved than what you're looking to do. If you run a query on a table you

Re: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Julia Green
Yikes, you didn't select so.type Try SELECT * or SELECT so.type, so.name, scname Julia Green Julia Computer Consulting --- Gyrus <[EMAIL PROTECTED]> wrote: > > SELECT so.name, sc.name > > FROM sysobjects so, syscolumns sc > > WHERE so.type = 'U' AND so.ID = sc.ID > > This doesn't s

RE: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Paul Wille
If I may reply to that, it is only functional in SQL Server. Paul W. Wille[EMAIL PROTECTED] -- Certified Advanced ColdFusion 5 Developer -- ISITE Design, Inc. – Solutions Architect www.isitedes

Re: Calling Stored Procedures via ADO

2002-01-09 Thread Julia Green
What's the negative one for in the Conn.Open tag? If you want to read the table from bottom up, try some sqltext...by ORDER DESC... Julia Green Julia Computer Consulting --- Craig Fisher <[EMAIL PROTECTED]> wrote: > I need to be able to call a Stored Procedure via ADO. Using the > article at >

Calling Stored Procedures via ADO

2002-01-09 Thread Craig Fisher
I need to be able to call a Stored Procedure via ADO. Using the article at http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=98343CD9-C4F1-482F- BBA536DF4F33875D I feel like I am getting pretty close. I am having a problem with the Execute() method of the Command Object. the following c

Re: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Gyrus
> SELECT so.name, sc.name > FROM sysobjects so, syscolumns sc > WHERE so.type = 'U' AND so.ID = sc.ID This doesn't seem to work with Access DB. Is there an equivalent? Which DBMS is this code compatible with? cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.ten

RE: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Bryan Love
SELECT so.name, sc.name FROM sysobjects so, syscolumns sc WHERE so.type = 'U' AND so.ID = sc.ID +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---

Re: OT Modifying Source File in DTS package

2002-01-09 Thread Eric Dawson
hmmm. I don't have CF on that server or the reporting station that is picking up the weblogs. I did have my import script filtering some of the data though, my intention was to do most of the filter during import, but I resorted to doing most in a trigger. If I get back to worrying about it,

RE: OT Modifying Source File in DTS package

2002-01-09 Thread Shawn Grover
Shoot me if I'm wrong, but I'm pretty sure DTS is based on vb-script (or can be). If that's the case then you can instantiate a File system object, and use it to retrieve your directory listing. You might need to convert the directory listing to an array, but you could then step through the

Re: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread corrigan
in CF I think queryname.fieldslist gets you the list of fields from a table in a query. You have to have the table name first though obviously. Michael Corrigan Programmer Endora Digital Solutions 1900 S. Highland Avenue, Suite 200 Lombard, IL 60148 630/627-5200 x-136 630/627-5255 Fax -

RE: Problem with QuerySetCell

2002-01-09 Thread Bryan Love
That's correct. This will work: SELECT DeptName, Count(*) AS appCount, 1 AS isOnline FROM apps WHERE IsOnline = 1 GROUP BY DeptName UNION ALL SELECT DeptName, Count(*) AS appCount, 0 AS isOnline FROM apps WHERE IsOnline = 0 GROUP BY DeptName ORDER BY DeptName, isOnline +

Re: OT Modifying Source File in DTS package

2002-01-09 Thread Don Vawter
I decided to do it in cf. There are some advantages that way. I do a little cleaning on the front end to eleminate the garbage requests from code red and to exclude entries from internal hits and scheduled tasks. What I do is scan the directory, grab a file, clean it , append into db, rename the f

CFMail and html/text

2002-01-09 Thread Sheila Handler
>From experience with a project a while ago, I 'd say there would be a big problem -- the time it takes to actually send out those emails using cfmail, or even aspqmail. I remember some horrendous figures like 5 hours to send out 30,000 emails. Original message: Date: Tue, 8 Jan 2002 09:18:27 -

Re: Merchant Accounts?

2002-01-09 Thread Bud
On 1/9/02, Randy Adkins penned: >I am curious to know who CF Developers use for >online credit card processing? > >I was looking over PayPal and LinkPoint. What >are some of the others and basically what is the >cost? > >I know with PayPal is can be as low as 2.2% and >$ .30 per transaction. It c

Re: OT Modifying Source File in DTS package

2002-01-09 Thread Eric Dawson
makes sense. I wanted to something like this a little while back. for web logfiles - I wanted to get something that would scan a directory for new files. update a log, and import and process files that haven't yet been imported. It wasn't too bulky so I just manually imported and processed the

RE: SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Paul Wille
Gyrus, Yes there is, in SQL Server at least. First, let's get the list of tables: 1. Table Listing: I execute the following query on the sysobjects table. SELECT name FROM sysobjects WHERE xtype IN ('U','V') AND name != 'dtproperties' NAME = the title of the table. 2. Fieldnam

RE: Content protection?

2002-01-09 Thread Eric Dawson
h. no help. but you got me curious. if you sent me a sample file - I can play a little. I presume you are embedding an excel spreadsheet into the power point presentation and during the presentation mode executing macros in the Excel spreadsheet? Eric From: Mark A. Kruger - CFG <[EMAIL

RE: Problem with QuerySetCell

2002-01-09 Thread Tammy Hong
Thanks Bryan. I will work on this but the problem I see right away with either SQL statement is that SQL Server won't allow grouping by bit data type. I will see if there is a workaround. Tammy -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 20

SQL for grabbing list of tables in DB / fields in table?

2002-01-09 Thread Gyrus
Does anyone know if there's an SQL statement for grabbing a list of the names of tables in a DB, or of field names in a table? I'm working in Access / SQL Server. cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP k

RE: Problem with QuerySetCell

2002-01-09 Thread Bryan Love
A couple points here... Actually this would be the better query to use: SELECT count(*) AS appCount, deptName, isOnline FROM apps GROUP BY deptName, isOnline ORDER BY deptName, isOnline ..but if you want to use a UNION then do this... - add 'isOnline' to the SELECT statement and to the ORDER BY

RE: verity and html comments

2002-01-09 Thread Darryl Lyons
Yeah it does. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 7:56 AM To: CF-Talk Subject: verity and html comments Does anyone know if verity indexes text within html comments thanks, phillip __

verity and html comments

2002-01-09 Thread phillip
Does anyone know if verity indexes text within html comments thanks, phillip __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyh

RE: Sorting multi-dimensional arrays?

2002-01-09 Thread Raymond Camden
You try... http://www.cflib.org/udf.cfm?ID=390 === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda

RE: Problem with QuerySetCell

2002-01-09 Thread Tammy Hong
Well I sort of got what you are trying to explain. I created a UNION SQL statement and it is giving me the correct recordcount. SELECT DeptName, Count(*) FROM TableName WHERE IsOnline = 1 GROUP BY DeptName UNION ALL SELECT DeptName, Count(*) FROM TableName WHERE IsOnline = 0 GROUP BY DeptName O

Re: Sorting multi-dimensional arrays?

2002-01-09 Thread corrigan
What luck have you had with ArraySort(foo, text)? Michael Corrigan Programmer Endora Digital Solutions 1900 S. Highland Avenue, Suite 200 Lombard, IL 60148 630/627-5200 x-136 630/627-5255 Fax - Original Message - From: Matt Kornguth To: CF-Talk Sent: Wednesday, January 09, 2002

Sorting multi-dimensional arrays?

2002-01-09 Thread Matt Kornguth
Is it possible to sort multi-dimensional arrays? I have a two dimensional array and want to sort by the first "column". Array name is "foo": foo[1][1] = "b" foo[1][2] = "1" foo[2][1] = "a" foo[2][2] = "2" So in this case I want to sort the first "column" (alpha characters "b & a" alphabeticall

Re: Better Javascript/DHTML Calender!

2002-01-09 Thread corrigan
Gotcha. I thought it might be a poor man's solution for error control. The more I think about it, the less sense it makes. Thanks Bryan Michael Corrigan Programmer Endora Digital Solutions 1900 S. Highland Avenue, Suite 200 Lombard, IL 60148 630/627-5200 x-136 630/627-5255 Fax - Ori

Re: Better Javascript/DHTML Calender!

2002-01-09 Thread Bryan Stevenson
In short..no it's not meant for what you're doing. Try this for the sending mail if insert flys: 1) after insert..do a SELECT to determine if the new record is in the DB (mabye just by determining if insert query exists) 2) If the new record is there..send your mail. Now as far as not inserti

Re: Better Javascript/DHTML Calender!

2002-01-09 Thread corrigan
Is cftransaction only to be used with queries or can you use it in conjunction with other things? I'm inserting data into the database and then emailing that data to a client but I don't want the insert to occur if the e-mail fails and I don't want the e-mail to be sent if the insert fails.

reading text file contents intro a database

2002-01-09 Thread Tim
I need to read the contents of a comma or tab delimited .txt file, and have the contents placed in the appropriate fields in a database. For example, the text file will look like: Course name 1 First person 2 second person 3 third person etc. The database will have a "course_name" field, and a

Re: Better Javascript/DHTML Calender!

2002-01-09 Thread Tyler Clendenin
i would like, y not just attatch it to you next e-mail - Original Message - From: "ronmyers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 3:12 PM Subject: RE: Better Javascript/DHTML Calender! > I got it. Must of been the last one for the day t

OT: Modal Dialog Boxes

2002-01-09 Thread Paul Sizemore
I'm using "http://foo.pdf " and I'm having trouble getting a PDF or Doc to load in a modal dialog box. Is this possible; am I beating my head against a wall. If so, how can I achieve the same type of thing some other way? I need the minimize button to be disabled, and really like how the user ca

RE: Problem with QuerySetCell

2002-01-09 Thread Bryan Love
Ouch. This is not something you want to do... Query results should be joined using the UNION operator in SQL. Many people don't realize that you can hard-code query columns to aid in this effort like so... SELECT appID, appName, '1' AS isOnline FROM apps WHERE whatever IS NOT NULL UNION SELE

RE: CF Mappings

2002-01-09 Thread Jennifer Larkin
Of course. Just define a variable that has the target directory and call the path with #variable# where the path is supposed to go. I suggest the request scope for such a variable, since you don't have to worry about locking it. At 11:30 AM 1/9/02 -0700, you wrote: >On that note, is it possibl

Re: Project Deployment

2002-01-09 Thread Jeffry Houser
I use the synchronize utility built into WS-FTP Pro. I don't have the knowledge to compare it to CF Studio's built in functionality (Never used it). At 02:02 PM 01/09/2002 -0600, you wrote: >Does anyone know of a better way to deploy a project than ColdFusion's >Project Deployment? Not sure

RE: Better Javascript/DHTML Calender!

2002-01-09 Thread ronmyers
I got it. Must of been the last one for the day to get it. If you want it let me know and I will email you a copy 30.4kb -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:44 AM To: CF-Talk Subject: RE: Better Javascript/DHTML Calender!

RE: Problem with QuerySetCell

2002-01-09 Thread Mark A . Kruger - CFG
Tammy, First, use "arrayResize( )" to kill the first loop code: Then, use the query array syntax to grab the data you want from the second (offlineApps) query ... like so: CFLOOP query="qryGetOnlineApps"> Of course I'm assuming that the second query has at leas as many rows as the

Project Deployment

2002-01-09 Thread Bernd VanSkiver
Does anyone know of a better way to deploy a project than ColdFusion's Project Deployment? Not sure if it is just me, but I have always found ColdFusion's project deployment to be rather slow, and it doesn't delete old files and directories off the server that don't exist in the project anymore.

RE: CF Mappings (New Problem)

2002-01-09 Thread James Taavon
Um, got a bigger problem right now. I accidentally changed the webroot mapping in the administrator, oops. Now, I can't access the administrator. Is there anyway to restore it without reloading CF? -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January

Problem with QuerySetCell

2002-01-09 Thread Tammy Hong
Hi, I am trying to add the values from a second query to my first query but for some reason it is setting all rows to the first value of the query. Can someone tell me what I did wrong? TIA. Tammy _

Re: Apache Error

2002-01-09 Thread Alex
comment out mod_coldfusion.c in your .conf file On Wed, 9 Jan 2002, Jeff Reilly wrote: > I installed CF and Apache on a 98 machine and get the following message i n > Apache error log: > > [Wed Jan 09 00:36:57 2002] [error] Cannot remove module mod_coldfusion.c: > not found in module list >

Merchant Accounts?

2002-01-09 Thread Randy Adkins
I am curious to know who CF Developers use for online credit card processing? I was looking over PayPal and LinkPoint. What are some of the others and basically what is the cost? I know with PayPal is can be as low as 2.2% and $ .30 per transaction. Thanks in advance Randy ___

Re: DHTML Menus

2002-01-09 Thread Eric Carlisle
Thanks for the great responses! :) I'm looking into the alternatives posted here. I'm assuming that the licencing for the DHTML meuns generated by Fireworks are included in the licence for Fireworks. EC __ Why Share?

Re: tracing where users are from

2002-01-09 Thread Paul Hastings
> Does anyone know if there is a way (using cf) to check where users are from? > (like country)I know you can do this with a program like web trends but I > wonder if there is a more practical way to do this. (run a traceroute dos > command via cf perhaps?) not exactly cf but www.geobutton.com wo

RE: how to prevent user from opening multiple browsers..

2002-01-09 Thread Mark Stewart
Good point and probably a little bit more cleaner. Mark -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:55 AM To: CF-Talk Subject: Re: how to prevent user from opening multiple browsers.. On Wed, 9 Jan 2002 09:15:28 -0500, Mark St

tracing where users are from

2002-01-09 Thread Mark Smeets
Hi, Does anyone know if there is a way (using cf) to check where users are from? (like country)I know you can do this with a program like web trends but I wonder if there is a more practical way to do this. (run a traceroute dos command via cf perhaps?) -- Mar

RE: CF Mappings

2002-01-09 Thread Mark Stewart
I use them specifically for cfincludes. Instead of referencing a template path as ../dir/dir/filename.cfm, you can reference it as /mapping/dir/dir/filename.cfm - much cleaner Mark -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 12:54 P

OT: SiteSprung

2002-01-09 Thread Billy Cravens
Couldn't help but chuckle when I saw this on the Developer's Exchange. A web based project management system that competes with SiteSpring - seems like the product name similarity could cause Macromedia's lawyers to use someone's head as a trampoline. :-) ___

RE: CF Mappings

2002-01-09 Thread James Taavon
yes, i agree with you. The thing is, the files do exist. It works fine on my local CF server. -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 1:48 PM To: CF-Talk Subject: Re: CF Mappings No, there is no need to set up a mapping (though

RE: Defining internal DB relationships necessary?

2002-01-09 Thread Mark Stewart
I know you're probably getting a lot of information here, but... Why add extra code to your app when you can let the db do it's job. I'm a firm believer in letting the different parts of an application (i.e. db, cf, com, java, etc.) do it's particular job that it was intended to do. In addition,

RE: Where is CF Administrator?

2002-01-09 Thread Anthony Abby
It should be /cfide/administrator/index.cfm Anthony > -Original Message- > From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 8:53 AM > To: CF-Talk > Subject: Where is CF Administrator? > > > Wednesday, January 09, 2002, 8:48:26 AM > Hello cf-talk, > >

RE: DHTML Menus

2002-01-09 Thread Matt Robertson
HierMenus is the best I've seen, and people think its still free. Unfortunately its not, although the notices given on this are very vague, IMHO. I was told by an internet.com rep over the phone that they want (retroactively -- enforced by attorneys) $500-$1,495 for single-site use. Dynamic Driv

Media library app

2002-01-09 Thread Jeff Beer
Has anyone written a simple "media library" application that they would be willing to share? All it needs is a client login to view and download their own media files (all audio) and a backend to upload media files on a per client basis. It needs to be MS Access based - no SQL Server or better a

Re: CF Mappings

2002-01-09 Thread Billy Cravens
No, there is no need to set up a mapping (though the error message seems to indicate it). Mappings are more or less for convenience sake - you can point to a file without a mapping (using the relative path) Your error indicates that the file doesn't exist. - Original Message - From: "Ja

RE: CF Mappings

2002-01-09 Thread James Taavon
I have the same webroot for each site, it is on the D: drive. -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 1:34 PM To: CF-Talk Subject: Re: CF Mappings It can make some things easier. For instance, the webroot map will allow you t

RE: CF Mappings

2002-01-09 Thread James Taavon
hmmm, ok. my question came about because i have two apps right now on CF 4.5 running on NT server. One works just fine, it has a mapping which I did not know of until today since I did not set it up. The second one i have does not. I get the error:

Re: CF Mappings

2002-01-09 Thread Jennifer Larkin
It can make some things easier. For instance, the webroot map will allow you to locate files relative to the root, making it easier to use modular code from different directories. You can also set up mappings to store design elements, so if you ever want to change design you can change the des

RE: CF Mappings

2002-01-09 Thread Shawn Grover
On that note, is it possible to declare mappings dynamically (from Application.cfm I'd imagine), without using the CF Admin interface? -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:11 AM To: CF-Talk Subject: Re: CF Mappings Whet

Re: CF Mappings

2002-01-09 Thread Jim McAtee
Mostly if you need access to files or templates from CFINCLUDE and CFMODULE that are not accessible to CF through a relative path. Both tags use relative addressing to specify files, so you might have a situation where you can't get to a file using a relative path. For example, when you have fil

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Billy Cravens
There would be an error, but IMHO, *this is a good thing* - during development, it would illustrate an area where data integrity was being violated, and allow you to fix the problem (cascading deletes through triggers, or done manually through cfml) - Original Message - From: "Gyrus" <[EM

RE: Where is CF Administrator?

2002-01-09 Thread Michael Wilson
Hi, It should be located at http://YourWebServer/cfide/administrator/. HTH Mike > -Original Message- > Everything installs fine, but where did Server Administrator go? I > don't have a link to get to the administrator control panel in my > start up menu anymore! _

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Billy Cravens
You're right, not defining the relationships won't cause anything to crash, but can compromise the integrity of your database - Original Message - From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 10:52 AM Subject: Re: Defining internal

Re: Historical events

2002-01-09 Thread Billy Cravens
You could contact some of the sites that have this functionality and see if they'd sell. Do a search for "on this day" (keep the quotes) in Yahoo or Google. You'll get results for sites like http://www.on-this-day.com/ - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <

RE: Historical events

2002-01-09 Thread Paris Lundis
not sure if this will help.. but certainly some people and site that might be able to turn you onto a product.. http://search-intl.netscape.com/Society/History/On_This_Day_In_History -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 13:04 To: CF-Ta

Re: CF Mappings

2002-01-09 Thread Billy Cravens
Whether or not you wish to use mappings in your application. You'd use them in CFInclude and CFModule - Original Message - From: "James Taavon" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 11:53 AM Subject: CF Mappings > What is the determinin

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Jeffry Houser
At 05:49 PM 01/09/2002 +, you wrote: > > Well here is my thought. As far as my DB is concerned I fully use > > creating a pri key and foreign key relationships where needed on all my > > tables. This helps so much in avoiding someone delteting something from > > one table that relies on someth

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Douglas Brown
Well if someone attempted that, they would get a primary key contraint violation. This is not a very friendy error message, but you can always create your own error template to be defined in CF Admin and make it alot more friendly to the user. It would look like so without a user friendly temp

OT: Historical events

2002-01-09 Thread Bud
Howdy all. I'm in need of a database that would have a news event for every day from 1900 thru today. Any ideas on where such a beast exists? The client is certainly willing to pay rather than populating it himself. Thanks. Sorry for the OT post. -- Bud Schneehagen - Tropical Web Creations

CF Mappings

2002-01-09 Thread James Taavon
What is the determining factor whether you need a Mapping for your application or not? Is it necessary for the app to work? James __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Inst

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Gyrus
> Well here is my thought. As far as my DB is concerned I fully use > creating a pri key and foreign key relationships where needed on all my > tables. This helps so much in avoiding someone delteting something from > one table that relies on something in another table. As I said, I do rigorou

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Jeffry Houser
At 03:31 PM 01/09/2002 +, you wrote: >My only work with databases is through ColdFusion, largely >Access. > >In designing the tables, Access forces you to define a Primary >Key, but I've only ever used the Relationships view where >you define the actual relationships for visualisation purposes

Re: OT Modifying Source File in DTS package

2002-01-09 Thread Kent Bulmer
MS SQL's DTS supports various scripting languages that would be able to handle copying today's log to a standard file name that gets overwritten everyday. That way, the file name (and text datasource) can remain the same and the script handles the file name issues. We're doing something similar to

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Douglas Brown
Well here is my thought. As far as my DB is concerned I fully use creating a pri key and foreign key relationships where needed on all my tables. This helps so much in avoiding someone delteting something from one table that relies on something in another table. Another reason for doing this i

Re: OT: DHTML Menus

2002-01-09 Thread Richard Meredith-Hardy
Javascript, but I really like http://milonic.co.uk/menu/ I have built a CF wrapper for this which builds dynamic cascading menus of unlimited depth, contact me off list if you are interested. Eric Carlisle wrote: > > On a new project, I need to choose a good DHTML menu system. The one I > lik

Re: Defining internal DB relationships necessary?

2002-01-09 Thread Dina Hess
Gyrus, A well-designed normalized relational database will require you to use less code to produce the results you want in your web application. The process of normalizing a database design is intended to eliminate data redundancy and deletion/addition anomalies. Your question about constrain

odd cfhttp behavior

2002-01-09 Thread Mike Sullivan
Greetings list, I had a working call to cfhttp w/ resolveurl set to true. The target is a data/graphing collector in our intranet. The CF template grabbed the page and I redisplayed it with the images (which live in the same web dir) without a problem. Now for some reason the image links are

RE: DHTML Menus

2002-01-09 Thread Erika L Walker-Arnold
I've had fantastic success with AllWebMenus (http://www.likno.com/) Highly recommended. Erika - Erika L. Walker-Arnold, VP, RUWebby, LLC http://www.ruwebby.com 55 Tunstall Road Croydon, Surrey, United Kingdom CRO 6TY -

  1   2   >