Re: return value of Identity Column
wrong. It's the last identity value used by that connection. i was previously told on this list that @@IDENTITY is per connection per table. no, its per connection. if you insert a table that has a trigger that fires an insert into another table w/identity, then @@IDENTITY will contain the 2nd table's value. in these cases its easy enough to re-write the triggers to grab the 1st @@IDENTITY hold it in a local var to send back to the caller. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: return value of Identity Column
Or in the stored procedure you could save the @@IDENTITY in a variable and return it at the end... i.e: /*Do an insert here*/ INSERT BLAH BLAH DECLARE StoredId INT SELECT StoredId = @@IDENTITY /*Do 2nd Insert Statement*/ INSERT BLAH BLAH SELECT @StoreId This still doesn't require the need for any additional triggers to be written and maintained. From: [EMAIL PROTECTED] (Paul Hastings) Organization: TEI Reply-To: [EMAIL PROTECTED] Date: Mon, 3 Jul 2000 13:40:09 +0700 To: [EMAIL PROTECTED] Subject: Re: return value of Identity Column wrong. It's the last identity value used by that connection. i was previously told on this list that @@IDENTITY is per connection per table. no, its per connection. if you insert a table that has a trigger that fires an insert into another table w/identity, then @@IDENTITY will contain the 2nd table's value. in these cases its easy enough to re-write the triggers to grab the 1st @@IDENTITY hold it in a local var to send back to the caller. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ReReplace
But, in the Excel file that is appended, I do not need the html, therefore it needs to be taken out. I would assume I use ReRlace, but I am unsure of the reg_expression that I would use. Anyone have any ideas? cfset text = REReplace(text, "[^]*", "", "All") where 'text' is your stuff. HTH, -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Normalization, one to many; sub records by year
Hi Jamie, I don't think you really need a 'year' table unless you intend to use a code for the year other than the current four digit style in common use. ;) From your description I think you need a faculty table as you described and a publications table that has faculty id, name of publication, type of publication, date of publication and text of publication. You should perhaps consider an 'internal' autonumber field as the key to the publication table (PublicationId?), it is much easier to manage in the situation you describe. To get the publications for a particular faculty member in a particular year the query would be something like: cfset LastDayLastYear=createDate(year(now())-1, 12, 31) cfset FirstDayNextYear=createDate(year(now()+1, 1, 1) cfoutput cfquery name="getPublications" datasource="MyDatasource" dbtype="ODBC" select * from publication where facultyid = #YourSelectedFacultyId# and publicationDate #CreateODBCDateTime(LastDayLastYear)# and publicationDate #CreateODBCDateTime(FirstDayNextYear)# /cfquery /cfoutput cfoutput query="getPublications" #formatDate(publicationDate, "DD MMM ")#nbsp;#publicationName# /cfoutput I've taken a few liberties here but it should get you started... Good Luck Brett Payne-Rhodes B) Jamie Symonds wrote: This is a multi-part message in MIME format. --A05047AA17E94D5BB8533278 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Here's the situation: I understand normalization and can easily create a database to suit my needs in Access. But using it on the web with cold fusion has me confused - what I have is: faculy members. Every faculty member is in a table, their email is the primary key which derives their name, office location, phone, etc. Each faculty member each year publishes articles, chapters, books, etc., and right now I just have it set up simply as a Textarea to submit it to a memo block in my db - ideally, I would like to select the year, and input data in a block for that year, etc. Does this sound clear? I would create a faculty table, a year table, and a year/faculty table where year and faculty id identify publications for that year. Just looking for someone to give me very simple direction, and I can work from there. Thanks --A05047AA17E94D5BB8533278 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Symonds, Jamie Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Jamie Symonds n: Symonds;Jamie adr:Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada email;internet: [EMAIL PROTECTED] title: Bachelor of Information Systems, Major (student) x-mozilla-cpt: ;0 x-mozilla-html: TRUE version:2.1 end:vcard --A05047AA17E94D5BB8533278-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Connecting to Excel?
Yes you can query the sheet: CFQUERY NAME="GetInfo" DATASOURCE="MyExcel" SELECT WhatevercolumnNames FROM `Sheet1$` WHERE this = this /cfquery You have to be certain of the reverse single quote before the sheet name and after the dollar sign. OK, just for the record - you can use [ and ] instead of ` around the sheet name, but they MUST be there Also, as ODBC won't release the Excel spreadsheet, even if you chuck it a duff query, it's a lot easier to use Access to point at the spreadsheet file, and then you can replace it whenever you want without any problems. I ran into this issue a couple of months back. Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: limiting upload file size - solution
Hi all , To do this use you can use the CGI.CONTENT_LENGTH variable Justin MacCarthy - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 03, 2000 3:04 AM Subject: Re: limiting upload file size I want to not upload at all if the file is bigger than 1MB. How can this be done? I can't think of a way to do this, but while I was looking around for a solution I found this page about file upload fields which is quite informative: http://www.hut.fi/u/jkorpela/forms/file.html I hope this is of some interest. Rob Keniger -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Licensing of CF Server Enterprise on Solaris...
Hi there. We would like to go down the route of remote/distributed ColdFusion serving - the engine on one box and the web server on another. What are the licensing implications for this - will just the one license do or will we need to purchase another one? That is, one for the CF engine box and the other for the web server. Also, has anyone gone down this route before? How easy was it to set up? Did it work first time? FYI, we're using Solaris version of CF Server Enterprise. Thanks in advance, Alan S. Willis, Web Apps Developer = Alan S. Willis, Web Applications Developer, Tayside Health Board, Maryfield House, 30 Mains Loan, Dundee, DD4 7BT Phone: 01382-561818, x70277 Mob: 07092-022140 Fax: 01382-424466 Email: [EMAIL PROTECTED] (Accepting Only Plain Text) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: limiting upload file size - solution
I just had to do this recently. I found the tutorial here. Check it out: http://www.teamallaire.com/tutorials/limitFileUploadSize.cfm Joel : To do this use you can use the : CGI.CONTENT_LENGTH variable : : Justin MacCarthy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: limiting upload file size - solution
: To do this use you can use the CGI.CONTENT_LENGTH variable I just had to do this recently. I found the tutorial here. Check it out: http://www.teamallaire.com/tutorials/limitFileUploadSize.cfm Unfortunately, relying on CGI.CONTENT_LENGTH doesn't prevent a user from uploading a file larger than you want to allow, it merely allows you to not do anything with that file. By the time that CGI.CONTENT_LENGTH exists, the web server has received the HTTP request header and body containing the file, I'd think, since both are sent simultaneously. If your concern is that someone will attempt to upload an extremely large file as a crude denial of service attack, this doesn't address that concern. You'd need some client-side logic, using an applet or ActiveX control, to avoid using standard HTTP form-based file uploading. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Unsubscribe
Some lists that I subcribe to have in the footer: "You are currently subscribed to listname as: [EMAIL PROTECTED]" Perhaps something like that would help this gentleman (term used loosely) unsubscribe himself off of this list. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. [EMAIL PROTECTED] 205 South Whiting Street Ph: 703-823-4300Suite 201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: MS Access SQL
Hi Folks, I am wondering if anyone knows of a way to have MS Access spit out the SQL necessary to create the tables that make up a given database. In other words, I'd like to do some kind of export that would export just the actual SQL statements that would create identical table structures in a new database if they were run. I know you can do this with SQL server, but I am wondering if there is a way to do this from MS Access 2000 (without upsizing to SQL server first :-) ) Thanks, Eron -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: MS Access SQL
I think you'd have to import the tables into SQL, and then create the scripts in SQL. CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 9:54 AM To: [EMAIL PROTECTED] Subject: OT: MS Access SQL Hi Folks, I am wondering if anyone knows of a way to have MS Access spit out the SQL necessary to create the tables that make up a given database. In other words, I'd like to do some kind of export that would export just the actual SQL statements that would create identical table structures in a new database if they were run. I know you can do this with SQL server, but I am wondering if there is a way to do this from MS Access 2000 (without upsizing to SQL server first :-) ) Thanks, Eron -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: MS Access SQL
sure... To start with, you need to know the syntax of CREATE TABLE syntax in sql - I don't offhand, but it's pretty easy offhand. Then, you can "scroll" through your fields and indexes collection of your recordset - you can obtain the names, and other properties, such as field type and size. With this information, you can dynamically create a text string that can be saved into a .SQL text file (be sure to use Print statement in basic to avoid quotes). I hope this helps... Tom ICQ: 2575057 -Original Message- From: Eron Cohen [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, July 03, 2000 8:58 AM Subject: OT: MS Access SQL Hi Folks, I am wondering if anyone knows of a way to have MS Access spit out the SQL necessary to create the tables that make up a given database. In other words, I'd like to do some kind of export that would export just the actual SQL statements that would create identical table structures in a new database if they were run. I know you can do this with SQL server, but I am wondering if there is a way to do this from MS Access 2000 (without upsizing to SQL server first :-) ) Thanks, Eron --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Verity Problems HELP needed
I am using Verity for the first time to index and search data in a SQL 7 db. I am following the simple setup guidelines etc. in FORTA's book and the problem is --very odd results. I have a table with thousands of names in it and searching for the letter "s" will come up with no results, or the letter "d" will come up with say 2. I should be getting hundreds of hits for these searches. . Is there some obvious setting that people often don't get right -- anyone had similar problems. Everything seems so straightforward to setup -- and I have triple-tested that my query brings back stuff. but not the verity search of the indexed query results... CFQUERY name="getnames" datasource="mydb" select firstname, lastname, id from member /query CFINDEX ACTION="refresh" collection="myVerity" key="id" type="custom" title="lastname" query="getnames" body="firstname,lastname" --- then on the results page ... CFSEARCH collection="myVerity" name="search" criteria="#form.criteria#" type="simple" cfoutput#search.recordcount#/cfoutput cfoutput query="getnames" #title# /cfoutput -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Verity Problems HELP needed
|I have a table with thousands of names in it |and searching for the letter "s" will come up with no results, |or the letter |"d" will come up with say 2. I should be getting hundreds of |hits for these |searches. Dont forget to use the wildcard * in your criteria if you wish partial keyword type searches. Regards, Anthony Geoghegan, Lead developer, IFTN www.wow.ie mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: MS Access SQL
I am wondering if anyone knows of a way to have MS Access spit out the SQL necessary to create the tables that make up a given database. In other words, I'd like to do some kind of export that would export just the actual SQL statements that would create identical table structures in a new database if they were run. I know you can do this with SQL server, but I am wondering if there is a way to do this from MS Access 2000 (without upsizing to SQL server first :-) ) There are macros out there for this. I use one to convert Access databases to MySQL, but I've also seen Access - MSSQL and other converters. I don't have the URL to that site where I saw those macros right now but if you really want them, then I guess I can dig it up. Erki -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Optimizing Win 2000 (IIS) for Warp speed with Cold Fusion.
Mark, Could you post your results on NT 4, IIS, CF. Thanks, Dan - Original Message - From: "Mark W. Breneman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 03, 2000 11:47 AM Subject: OT: Optimizing Win 2000 (IIS) for Warp speed with Cold Fusion. About 9 months ago I collected and posted a compiled list tips and tricks (thanks for all the info, by the way) for optimizing NT4.0(IIS) and Cold Fusion for max performance. I would like to do the same for Windows 2000 (IIS 5) and CF 4.5. Please also include any gaping security holes and fixes. And / Or any handy tricks like renaming the administrator account in NT. I will post all the tips and tricks compiled in a list with my own in a few days. If you would like to contact me off list [EMAIL PROTECTED] Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Documentum integration
Does anyone have experience with integrating Documentum document management software with CF apps? I'm interested in searching the repository and linking to specific documents in HTML, adding document content to the repository, and verifying the existence of specified docs. TIA, Jeff Beer Senior Programming Architect Hydrogen Media, Inc. www.hydrogenmedia.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Optimizing NT server 4.0 IIS 4 and CF 4.0.
As requested. Here is the list of tips and tricks for optimizing NT server 4.0 IIS 4 and CF 4.0. This is by no means a full list. Some tips range from obvious to... "how did you ever find that?". If anyone would like to compile and post this list and or my soon to be posted Windows 2000 tips and tricks to a webpage please do so. I give this info as freely as I have received it. If you have tips for NT server 4.0 IIS 4 and CF 4.0 OR Win 2000 you may contact me off list @ [EMAIL PROTECTED] Mark W. Breneman -Sr. Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 cf Disclaimer I offer this to anyone who wishes to use it. I will assume no responsibility for damage to anything if you choose to use this information. (including your cat, car or house) BTW everything worked fine for me. /cf Disclaimer --Keep in mind this info was compiled in late November of 99. Some info may be outdated.-- Windows NT 4.0 General OS Settings 1.For Windows NT 4.0 servers, set Windows NT Server to Application Server: On the desktop, right-click Network Neighborhood and select Properties. On the Services tab, double-click the Server service. Select Network Applications. The Application Server setting also instructs Windows NT to trim the file cache more aggressively. 2.Ensure all unused IIS file mappings are removed: Using the Microsoft Management Console, navigate to the Web sites (virtual servers) under the IIS snap-in. Right-click Default Web Site, and/or any other Web site(s) where your content exists and select properties. Select the Home Directory property sheet. Click the Configuration button under the Application Settings section. Remove all unused mappings, leaving at least one mapping in place (the server requires at least one mapping). Leave the ".CFM" extension in place if no other mappings are being used. 3.Disable performance boost for foreground applications: Open the Control Panel. Double-click the System icon, and select the Performance property sheet. Move the Application Performance slider to None. 4.In HKLM\System\CurrentControlSet\Services\TCPIP\Parameters, set the following DWORD values (add if not already there): DWORD MaxUserPort and set to 0xfffe DWORD TcpWindowSize and set to 65535 DWORD MaxFreeTcbs and set to 72000 DWORD MaxHashTableSize and set to 65536 DWORD TcpTimedWaitDelay and set to 60 5.Set receive buffers for the Network Interface Card (NIC) to maximum: Dropped packets on the receiving end cause TCP (Transmission Control Protocol) to retransmit. This minimizes the number of dropped packets on the receiving end, thus increasing performance. See the documentation for your NIC for details. This parameter can often be set using the properties of the NIC under the Network Control Panel. It also couldn't hurt to set the NIC speed to 100 MBit (default is usually "auto"). 6.Disable any services not absolutely required for machine operation (i.e. SMTP, FTP, MSDTC, Browser services, Spooler, etc.) 7.Remove the Page Files, defragment the drives and recreate the Page Files to ensure contiguous disk space is used for virtual memory. 8.For multiple NIC machines, used the Microsoft Affinity tool to bind one NIC to each CPU. (ftp://ftp.microsoft.com/bussys/winnt/winnt-public/tools/affinity/) 9.If using 1GB of RAM, set maxmem=1024 in boot.ini Microsoft Internet Information Server Settings 1.Minimize IIS logging and/or use striped partition: It is desirable to log only data required for weblog trend analysis. Logging to a striped partition with a controller that allows write-back caching, especially if you see heavy use on the log disk can also be beneficial. Using the Microsoft Management Console, navigate to the Web sites (virtual servers) under the IIS snap-in. Right-click Default Web Site, and/or any other
Re: Problem Displaying a 2D array.
CFLOOP INDEX="x" FROM="1" TO="#ArrayLen(addresses)#" CFOUTPUT#addresses[#x#][1]#/CFOUTPUT /CFLOOP I get the following error when I run the code: Loose the #'s around the X... Like this: CFLOOP INDEX="x" FROM="1" TO="#ArrayLen(addresses)#" CFOUTPUT#addresses[x][1]#/CFOUTPUT /CFLOOP Erki -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem Displaying a 2D array.
|CFLOOP INDEX="x" FROM="1" TO="#ArrayLen(addresses)#" |CFOUTPUT#addresses[#x#][1]#/CFOUTPUT |/CFLOOP Hi Jeff, Use this instead: CFLOOP INDEX="x" FROM="1" TO="ArrayLen(addresses)" CFOUTPUT#addresses[x][1]#/CFOUTPUT /CFLOOP Regards, Anthony Geoghegan, Lead Developer, IFTN www.wow.ie mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: MS Access SQL
Erki, Can you give me a hint where you found them? Eron -Original Message- From: Erki Esken [mailto:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 11:38 AM To: [EMAIL PROTECTED] Subject: Re: MS Access SQL I am wondering if anyone knows of a way to have MS Access spit out the SQL necessary to create the tables that make up a given database. In other words, I'd like to do some kind of export that would export just the actual SQL statements that would create identical table structures in a new database if they were run. I know you can do this with SQL server, but I am wondering if there is a way to do this from MS Access 2000 (without upsizing to SQL server first :-) ) There are macros out there for this. I use one to convert Access databases to MySQL, but I've also seen Access - MSSQL and other converters. I don't have the URL to that site where I saw those macros right now but if you really want them, then I guess I can dig it up. Erki -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problem Displaying a 2D array.
I swore I tried that, oh well it works thanks. Erki Esken wrote: CFLOOP INDEX="x" FROM="1" TO="#ArrayLen(addresses)#" CFOUTPUT#addresses[#x#][1]#/CFOUTPUT /CFLOOP I get the following error when I run the code: Loose the #'s around the X... Like this: CFLOOP INDEX="x" FROM="1" TO="#ArrayLen(addresses)#" CFOUTPUT#addresses[x][1]#/CFOUTPUT /CFLOOP Erki -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
WOT: Oracle indexes
I know this is way off topic, but I don't want to join an Oracle list just to find out this one thing. Thanks for indulging me. I have an existing database that I am "investigating" and I'm having a bit of trouble getting information on the indexes. I have retrieved all the information that I need except the fieldnames used in the index. I have been pulling information from the all_indexes table, but I can't find a field with the fieldnames. I also can't retrieve a description of any indexes. When I type descr and paste the name of an existing index (copied from all_indexes) I get an "object does not exist" message. I've tried with several index names copied from the all_indexes table. It works with all other objects, so I don't know what I'm doing wrong. I'm not used to using indexes, nor am I terribly familiar with Oracle, so I may just be confused about the way they work. I don't know where else to look, so if anyone knows how to retrieve this information, please contact me off list. Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: WOT: Oracle indexes
Someone has shown me the way, so nevermind. One pain in my butt eliminated! At 12:13 PM 7/3/00 -0500, you wrote: I know this is way off topic, but I don't want to join an Oracle list just to find out this one thing. Thanks for indulging me. I have an existing database that I am "investigating" and I'm having a bit of trouble getting information on the indexes. I have retrieved all the information that I need except the fieldnames used in the index. I have been pulling information from the all_indexes table, but I can't find a field with the fieldnames. I also can't retrieve a description of any indexes. When I type descr and paste the name of an existing index (copied from all_indexes) I get an "object does not exist" message. I've tried with several index names copied from the all_indexes table. It works with all other objects, so I don't know what I'm doing wrong. I'm not used to using indexes, nor am I terribly familiar with Oracle, so I may just be confused about the way they work. I don't know where else to look, so if anyone knows how to retrieve this information, please contact me off list. Thanks! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: retrieving data from multiple tables
This really depends on your db schema, and what type of normalization you're using. Let's assume you have three tables, each with a primary key, and each with a foreign key (except the first table) select tablea.recorda, tableb.recordb, tablec.recordc from tablea join on tablea.a_pk = tableb.b_fk join on tableb.b_pk = tablec.c_fk where tablea.a_pk = 'whatevervalue' LW wrote: This is a multi-part message in MIME format. --=_NextPart_000_002E_01BFE40E.A119A230 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I have a submit form which inserts the data into multiple tables which = works fine. For eg, in the language category where I allow the user to = select from several checkboxes their choice - which using the cfloop I = have successfully inserted the data. Now in my update page, I am trying to recall the data and have the all = checked and unchecked boxes in the language category displayed - How do = I go abt this? Thanks in advance Wai Leng --=_NextPart_000_002E_01BFE40E.A119A230 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi all,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I have a submit form which inserts the = data into=20 multiple tables which works fine. /FONTFONT face=3DArial size=3D2For = eg,=20 innbsp;the language category where I allow the user to select from = several=20 checkboxes their choice - which using the lt;cfloopgt; I have = successfully=20 inserted the data./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Now in my update page, I am trying to = recall the=20 data and have the all checked and unchecked boxes in the language = category=20 displayed - How do I go abt this?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks in advance/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Wai Leng/FONT/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_002E_01BFE40E.A119A230-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Billy Cravens [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Can you loop a CFMAIL tag w/o a query?
I'm working on something that will upload a text file and then parse info and send out mail to the addresses that are loaded into an array, but CFMAIL tells me that you can't use a CFOUTPUT tag in a CFMAIL tag unless you have the QUERY attribute. Is there a way to do this or am I going to have the load this data into the database? After the mail is sent the information is not needed so it's kinda silly to load it into the database. -Jeff Bearer -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF Solaris 4.51 SP1 Alpha
Hello! Has anyone successfully installed the alpha SP1? Helge -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What am I doing wrong?
I am trying to insert data into a table and get the following errors. I provided the semicolon, yet I still get the errors. What am I doing wrong? TIA, Lisa ODBC Error Code 37000 (Syntax error or access violation) [ODBC Mircosoft Access Driver] Missing semicolon (;) at end of SQL statement. cfquery name="ptobs" datasource="#dsn#" dbtype="odbc" insert into ptobs (pi,patno,PSL_ID,currPI,PIreason,pires_ot,dttype,results, modHAART, intHAART, intreason, fatmaldis, hypergly, gly_pre, hyperlip, lip_pre, lla_yn, ll_agent, lla_dose, anti_dyn,anti_d, antid_ot, antid_ds) values ( '#ptdat.pi#','#variables.patno#', #session.PSL_ID#, '#currPI#', '#attributes.PIreason#', '#attributes.pires_ot#', #CreateODBCDateTime(variables.dttype)#, '#attributes.results#', '#attributes.modHAART#', '#attributes.intHAART#', '#attributes.intreason#', '#attributes.fatmaldis#', '#attributes.hypergly#', '#attributes.gly_pre#', '#attributes.hyperlip#', '#attributes.lip_pre#', '#attributes.lla_yn#', '#attributes.ll_agent#', '#attributes.lla_dose#', '#attributes.anti_dyn#', '#attributes.anti_d#', '#attributes.antid_ot#', '#attributes.antid_ds#' ) where demog.PSL_ID=#session.PSL_ID# ; /cfquery -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What am I doing wrong?
You don't want to use a where clause in an insert statement, if you are updating data, you want to use a update statement. -Jeff Lisa Greenberg wrote: I am trying to insert data into a table and get the following errors. I provided the semicolon, yet I still get the errors. What am I doing wrong? TIA, Lisa ODBC Error Code 37000 (Syntax error or access violation) [ODBC Mircosoft Access Driver] Missing semicolon (;) at end of SQL statement. cfquery name="ptobs" datasource="#dsn#" dbtype="odbc" insert into ptobs (pi,patno,PSL_ID,currPI,PIreason,pires_ot,dttype,results, modHAART, intHAART, intreason, fatmaldis, hypergly, gly_pre, hyperlip, lip_pre, lla_yn, ll_agent, lla_dose, anti_dyn,anti_d, antid_ot, antid_ds) values ( '#ptdat.pi#','#variables.patno#', #session.PSL_ID#, '#currPI#', '#attributes.PIreason#', '#attributes.pires_ot#', #CreateODBCDateTime(variables.dttype)#, '#attributes.results#', '#attributes.modHAART#', '#attributes.intHAART#', '#attributes.intreason#', '#attributes.fatmaldis#', '#attributes.hypergly#', '#attributes.gly_pre#', '#attributes.hyperlip#', '#attributes.lip_pre#', '#attributes.lla_yn#', '#attributes.ll_agent#', '#attributes.lla_dose#', '#attributes.anti_dyn#', '#attributes.anti_d#', '#attributes.antid_ot#', '#attributes.antid_ds#' ) where demog.PSL_ID=#session.PSL_ID# ; /cfquery -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can you loop a CFMAIL tag w/o a query?
I'm working on something that will upload a text file and then parse info and send out mail to the addresses that are loaded into an array, but CFMAIL tells me that you can't use a CFOUTPUT tag in a CFMAIL tag unless you have the QUERY attribute. Is there a way to do this or am I going to have the load this data into the database? After the mail is sent the information is not needed so it's kinda silly to load it into the database. Jeff, There is a query that will convert your array to a query in the tag gallery called ArrayToQuery. (If you can't find it, email me direct and I'll send it to you) Or you could your CFLOOP around the outside of your CFMAIL and loop through your array of addresses that way. Regards Stephen -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What am I doing wrong?
Lisa, A semicolon is not needed in a CF SQL statement and also you really have an SQL UPDATE cmd since you have a WHERE clause. So, you either need to change the INSERT to UPDATE or remove the WHERE clause. Also, remove the ; Jim -Original Message- From: Lisa Greenberg [mailto:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 2:05 PM To: cftalk Subject: What am I doing wrong? I am trying to insert data into a table and get the following errors. I provided the semicolon, yet I still get the errors. What am I doing wrong? TIA, Lisa ODBC Error Code 37000 (Syntax error or access violation) [ODBC Mircosoft Access Driver] Missing semicolon (;) at end of SQL statement. cfquery name="ptobs" datasource="#dsn#" dbtype="odbc" insert into ptobs (pi,patno,PSL_ID,currPI,PIreason,pires_ot,dttype,results, modHAART, intHAART, intreason, fatmaldis, hypergly, gly_pre, hyperlip, lip_pre, lla_yn, ll_agent, lla_dose, anti_dyn,anti_d, antid_ot, antid_ds) values ( '#ptdat.pi#','#variables.patno#', #session.PSL_ID#, '#currPI#', '#attributes.PIreason#', '#attributes.pires_ot#', #CreateODBCDateTime(variables.dttype)#, '#attributes.results#', '#attributes.modHAART#', '#attributes.intHAART#', '#attributes.intreason#', '#attributes.fatmaldis#', '#attributes.hypergly#', '#attributes.gly_pre#', '#attributes.hyperlip#', '#attributes.lip_pre#', '#attributes.lla_yn#', '#attributes.ll_agent#', '#attributes.lla_dose#', '#attributes.anti_dyn#', '#attributes.anti_d#', '#attributes.antid_ot#', '#attributes.antid_ds#' ) where demog.PSL_ID=#session.PSL_ID# ; /cfquery -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What am I doing wrong?-solved
--D82B2777473DE9569A6A5589 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I gather from your statement that it isn't legal to use a where clause. One solution I thought of is to wrap this insert in a cfif statement. Thanks for your help --Lisa Jeff Bearer wrote: You don't want to use a where clause in an insert statement, if you are updating data, you want to use a update statement. -Jeff Lisa Greenberg wrote: I am trying to insert data into a table and get the following errors. I provided the semicolon, yet I still get the errors. What am I doing wrong? TIA, Lisa ODBC Error Code 37000 (Syntax error or access violation) [ODBC Mircosoft Access Driver] Missing semicolon (;) at end of SQL statement. cfquery name="ptobs" datasource="#dsn#" dbtype="odbc" insert into ptobs (pi,patno,PSL_ID,currPI,PIreason,pires_ot,dttype,results, modHAART, intHAART, intreason, fatmaldis, hypergly, gly_pre, hyperlip, lip_pre, lla_yn, ll_agent, lla_dose, anti_dyn,anti_d, antid_ot, antid_ds) values ( '#ptdat.pi#','#variables.patno#', #session.PSL_ID#, '#currPI#', '#attributes.PIreason#', '#attributes.pires_ot#', #CreateODBCDateTime(variables.dttype)#, '#attributes.results#', '#attributes.modHAART#', '#attributes.intHAART#', '#attributes.intreason#', '#attributes.fatmaldis#', '#attributes.hypergly#', '#attributes.gly_pre#', '#attributes.hyperlip#', '#attributes.lip_pre#', '#attributes.lla_yn#', '#attributes.ll_agent#', '#attributes.lla_dose#', '#attributes.anti_dyn#', '#attributes.anti_d#', '#attributes.antid_ot#', '#attributes.antid_ds#' ) where demog.PSL_ID=#session.PSL_ID# ; /cfquery -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --D82B2777473DE9569A6A5589 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html I gather from your statement that it isn't legal to use a where clause. One solution I thought of is to wrap this insert in a cfifnbsp; statement. Thanks for your help p--Lisa pJeff Bearer wrote: blockquote TYPE=CITEYou don't want to use a where clause in an insert statement, if you are brupdating data, you want to use a update statement. p-Jeff pLisa Greenberg wrote: br br I am trying to insert data into a table and get the br following errors.nbsp; I provided the semicolon, yet I still get br the errors.nbsp; What am I doing wrong? br br TIA, br br Lisa br br ODBC Error Code 37000 (Syntax error or access violation) br [ODBC Mircosoft Access Driver] Missing semicolon (;) at end br of SQL statement. br br lt;cfquerynbsp; name="ptobs" datasource="#dsn#" dbtype="odbc" brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; insert into ptobs brnbsp;nbsp;nbsp; (pi,patno,PSL_ID,currPI,PIreason,pires_ot,dttype,results, br modHAART, intHAART, intreason, fatmaldis, hypergly, gly_pre, br brnbsp;nbsp;nbsp;nbsp; hyperlip, lip_pre, lla_yn, ll_agent, lla_dose, br anti_dyn,anti_d, antid_ot, antid_ds) brnbsp;nbsp;nbsp;nbsp; values ( '#ptdat.pi#','#variables.patno#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; #session.PSL_ID#, '#currPI#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.PIreason#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.pires_ot#', brnbsp;nbsp;nbsp;nbsp;nbsp; #CreateODBCDateTime(variables.dttype)#, brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.results#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.modHAART#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.intHAART#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.intreason#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.fatmaldis#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.hypergly#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.gly_pre#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.hyperlip#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.lip_pre#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.lla_yn#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.ll_agent#', brnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.lla_dose#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.anti_dyn#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.anti_d#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.antid_ot#', brnbsp;nbsp;nbsp;nbsp;nbsp; '#attributes.antid_ds#' ) brnbsp;nbsp;nbsp;nbsp;nbsp; wherenbsp;nbsp;
Re: Can you loop a CFMAIL tag w/o a query?
Or you could your CFLOOP around the outside of your CFMAIL and loop through your array of addresses that way. Stephen, That's what I was attempting to do but CF complains about it like below. I'll look for the tag thanks for the help. -Jeff Stephen Moretti wrote: I'm working on something that will upload a text file and then parse info and send out mail to the addresses that are loaded into an array, but CFMAIL tells me that you can't use a CFOUTPUT tag in a CFMAIL tag unless you have the QUERY attribute. Is there a way to do this or am I going to have the load this data into the database? After the mail is sent the information is not needed so it's kinda silly to load it into the database. Jeff, There is a query that will convert your array to a query in the tag gallery called ArrayToQuery. (If you can't find it, email me direct and I'll send it to you) Or you could your CFLOOP around the outside of your CFMAIL and loop through your array of addresses that way. Regards Stephen -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Can you loop a CFMAIL tag w/o a query?
Or you could your CFLOOP around the outside of your CFMAIL and loop through your array of addresses that way. Stephen, That's what I was attempting to do but CF complains about it like below. I'll look for the tag thanks for the help. [snip] Oh I see what you mean You can just stick the variables in surrounded by hashes (#); no need for the cfoutput's... Regards Stephen -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Table Font Size
The reason you don't see font as an attribute of TD is because it isn't; you nest the font tags inside of the TD. Also, my experience has been that style table cells (TD) doesn't work in Netscape. A pain, I know. -- Billy Cravens [EMAIL PROTECTED] Paige Chandler wrote: Hi All, Is it possible to set the font size for a tbale to other than the = default font? The syntax below dosen't appear to work. TIA. Regards, Paige Font Size=3D5 Table CellSpacing=3D7 Tr THInsured/THTHLast Name/THTHFirst Name/THTHProperty = ID/TH /TR TR TD#Ins_Id#/td TD#Ins_Last1#/td TD#Ins_First1#/td TD#Ins_PropId#/td TD#Status#/td TD#Ins_MailCd#/td /tr /Table=20 /Font =20 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
my pre-selected select box - why won't this work?
Sorry, this is probably very simple but I can't figure it out. I have a pre-selected value on my select box but it won't display. It should pre-select Maryland but it goes to the first option, Alaska. If I hard-code "MD" into the 'SELECTED' parameter of the CFSELECT tag, the right option is selected but if it is drawn from the query, it is wrong. Can anyone tell me why? The URL is: http://206.239.48.11/test.cfm The code is: CFQUERY name="query_state" datasource="closingquotesdev" SELECT state_des, state_abbrev FROM states ORDER BY state_abbrev /CFQUERY CFQUERY NAME="GetCompanyAddress" datasource="closingquotesdev" SELECT state FROMdbo.comp_address WHERE comp_address.company_address_id = 299 /CFQUERY CFOUTPUTGetCompanyAddress.state: #GetCompanyAddress.state#/CFOUTPUTBRBR CFFORM ACTION="" METHOD="POST" FONT face="MS SANS SERIF, HELVETICA" size="-1"State: FONT COLOR="Red"*/FONTBR CFSELECT NAME="state" MESSAGE="Please select your state." QUERY="query_state" VALUE="state_abbrev" DISPLAY="state_des" SELECTED="#GetCompanyAddress.state#"/CFSELECT/FONT /CFFORM Thanks. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon Park Computer Systems Management, Inc. [EMAIL PROTECTED] 205 South Whiting Street Ph: 703-823-4300Suite 201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Can you loop a CFMAIL tag w/o a query?
If you are doing a lot of bulk mail-shots or mail lists you should look at the POST server at www.coolfusion.com or http://www.coolfusion.com/post_se.htm for $79 It beats the heck out or the CFmail ... ~Justin MacCarthy - Original Message - From: Roberts, Jesse D [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 03, 2000 7:29 PM Subject: RE: Can you loop a CFMAIL tag w/o a query? I've used this type of method before. This code is modified from what I use in my case, but you get the idea. CFLOOP COLLECTION="Array or Stucture Name" ITEM="Email_Address" CFMAIL TO="#Email_Address#" FROM="[EMAIL PROTECTED]" SUBJECT="Subject" SERVER="mail.domain.com" Message text. /CFMAIL /CFLOOP Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA [EMAIL PROTECTED] Ph. 714-896-3462 Fx. 714-896-3303 -Original Message- From: Jeff Bearer [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 10:59 AM To: cf-talk Subject: Can you loop a CFMAIL tag w/o a query? I'm working on something that will upload a text file and then parse info and send out mail to the addresses that are loaded into an array, but CFMAIL tells me that you can't use a CFOUTPUT tag in a CFMAIL tag unless you have the QUERY attribute. Is there a way to do this or am I going to have the load this data into the database? After the mail is sent the information is not needed so it's kinda silly to load it into the database. -Jeff Bearer -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: my pre-selected select box - why won't this work?
Sorry, this is probably very simple but I can't figure it out. I have a pre-selected value on my select box but it won't display. It should pre-select Maryland but it goes to the first option, Alaska. If I hard-code "MD" into the 'SELECTED' parameter of the CFSELECT tag, the right option is selected but if it is drawn from the query, it is wrong. Can anyone tell me why? The only reason that Alaska is selected by default is because none of your OPTION tags (generated by the CFSELECT) contain the SELECTED attribute. This normally indicates that none of the values from the query matched the value you specified as SELECTED. The best guess I can make from looking at the output of your code is that the value stored in the DB is "MD " (note the trailing spaces). This could prevent the CFSELECT from pre-selecting Maryland because "MD" is not the same as "MD". Take a close look at the data in your database... my guess is your problem lies there. You could try changing the SELECTED parameter of the CFSELECT to read SELECTED="#Trim(GetCompanyAddress.State)#" but the best solution really is to fix up the data in the database. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: my pre-selected select box - why won't this work?
Just a guess, but you might try putting using Trim in your SELECTED varaible. If your db state value has a space character, it would prevent it from working. Jesse D. Roberts Business Process Analyst Procurement Quality Assurance Boeing - Huntington Beach, CA [EMAIL PROTECTED] Ph. 714-896-3462 Fx. 714-896-3303 -Original Message- From: Park, Simon [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 11:56 AM To: [EMAIL PROTECTED] Subject: my pre-selected select box - why won't this work? Sorry, this is probably very simple but I can't figure it out. I have a pre-selected value on my select box but it won't display. It should pre-select Maryland but it goes to the first option, Alaska. If I hard-code "MD" into the 'SELECTED' parameter of the CFSELECT tag, the right option is selected but if it is drawn from the query, it is wrong. Can anyone tell me why? The URL is: http://206.239.48.11/test.cfm The code is: CFQUERY name="query_state" datasource="closingquotesdev" SELECT state_des, state_abbrev FROM states ORDER BY state_abbrev /CFQUERY CFQUERY NAME="GetCompanyAddress" datasource="closingquotesdev" SELECT state FROM dbo.comp_address WHERE comp_address.company_address_id = 299 /CFQUERY CFOUTPUTGetCompanyAddress.state: #GetCompanyAddress.state#/CFOUTPUTBRBR CFFORM ACTION="" METHOD="POST" FONT face="MS SANS SERIF, HELVETICA" size="-1"State: FONT COLOR="Red"*/FONTBR CFSELECT NAME="state" MESSAGE="Please select your state." QUERY="query_state" VALUE="state_abbrev" DISPLAY="state_des" SELECTED="#GetCompanyAddress.state#"/CFSELECT/FONT /CFFORM Thanks. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Simon ParkComputer Systems Management, Inc. [EMAIL PROTECTED]205 South Whiting Street Ph: 703-823-4300 Suite 201 fax: 703-823-4301 Alexandria, VA 22304 http://www.csmi.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Content management
List, A growing number of my company's clients are pushing for the ability to maintain the content (i.e. text, basic HTML, images, etc) on their sites. This really isn't that big a deal in and of itself, but these sites are growing more and more complex, and there is no longer a simple separation of "content" (i.e. the text or simple HTML itself) from its "presentation" (in this case, the CF logic that runs to personalize navigation systems, page headers, etc). Up to this point we have been simply granting clients FTP access to their directory on the server and telling them not to change anything that begins with "CF". This is a TERRIBLE thing, and I've been fighting to move away from this ever since I started. Anyways, I was wondering how some of the other players out there deal with this sort of request from a client. One the one hand I don't want ANYONE but someone from my company touching the CF code, but I can understand a client's desire to have control over their site. I wouldn't want to pay $50-$75 per hour for simple HTML changes either. In particular, I'm looking to evaluate possible solutions against the following metrics: 1) Security: giving a client FTP access to a shared CF server is obviously a bad idea because one client could, either on purpose or by accident, adversely affect other hosted sites by crashing the CF service, uploading templates that use CFFILE, etc. As a general rule we don't let clients upload CF files to the server, but this is not enforced by anything other than a verbal contract with the client. Whatever solution I find has to, in some way or another, adequately shield one client from the actions of another, which means unrestricted direct file access is a no-no g. 2) Protection of intellectual property: we have a series of pre-written "modules" (calendar, classified ads, etc) that we sell to our clients. Since these are sold as pre-written applications, the client does not gain any ownership of the code. FTP access to the site again poses a problem because it makes these templates directly available to the client. A savvy HTML/CF author working for the client might steal this code and re-sell it. 3) Cost: I'm looking for a relatively inexpensive solution right now (i.e. please don't recommend Spectra g). Neither us nor our clients are particuarly interested in paying huge sums of money for a feature-packed solution at this time. I don't necessarily need ALL aspects of each page available to the client to change. Certain parts of the site, such as CF-enabled navigation systems, can remain under my company's control. With all of these things in mind, does anyone out there have any pointers for me? Either links to prewritten applications or ideas on "rolling my own" system are welcome. Thanks in advance, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
copy all files in a directory?
I am a little confused about the syntax for CFFile. I want to copy all the files in a directory (including subfolders), but don't see an easy way to do this in ColdFusion 4.0. I would also rather not use custom tags, if possible. Can someone show me the correct way to set up the initial and action pages? Thanks ever so much. - Greg Albert -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: copy all files in a directory?
Not sure why you don't want to use a custom tag, but if you change your mind, look into CF_AutoCopy in the Allaire tag gallery. If you want to do it yourself, you'll need to get directory listings, copy individual files, traverse subdirectories, create subdirectories at the destination. You'll have to use both the CFDIRECTORY and CFFILE tags. Use CFDIRECTORY with ACTION="LIST" and ACTION="CREATE" and CFFILE with ACTION="COPY". Loop over the directory listing, checking queryname.type. If the type is 'file', copy the file, otherwise create the subdirectory, then recursively do the same thing in subdirectories. Jim -Original Message- From: Gregory M. Albert [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, July 03, 2000 2:26 PM Subject: copy all files in a directory? I am a little confused about the syntax for CFFile. I want to copy all the files in a directory (including subfolders), but don't see an easy way to do this in ColdFusion 4.0. I would also rather not use custom tags, if possible. Can someone show me the correct way to set up the initial and action pages? Thanks ever so much. - Greg Albert -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What am I doing wrong?-solved
That's correct. A WHERE clause is illegal in an insert. If by wrapping the insert in a cfif statement you mean to do either an insert or an update, that's correct. You'll have some criteria to determine if you're doing an insert or an update (often this will be if a record id is passed to the template). For example: cfif IsDefined("url.record_id") cfquery datasource="mydsn" UPDATE mytable SET this = '#form.this#', that = #form.that# WHERE record_id = #url.record_id# /cfquery cfelse cfquery datasource="mydsn" INSERT INTO mytable (this, that) VALUES ('#form.this#', #form.that#) /cfquery /cfif Jim -Original Message- From: Lisa Greenberg [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, July 03, 2000 12:28 PM Subject: Re: What am I doing wrong?-solved --D82B2777473DE9569A6A5589 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I gather from your statement that it isn't legal to use a where clause. One solution I thought of is to wrap this insert in a cfif statement. Thanks for your help --Lisa -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
memo fields and paragraphs
Does anyone know how to preserve the paragraphs (carriage returns) in text in a memo field? When I copy text from something like a Word document and paste it into a memo field, it seems to smash all the lines together, as though the paragraphs weren't there at all. Looking at the data in the Access database, the paragraphs are still there, but when I read the field in CF, they're gone. Is this a memo field thing, or a CF thing? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: memo fields and paragraphs
Thanks, Jennifer, that was exactly what I was looking for. Works great! -Original Message- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 2:51 PM To: [EMAIL PROTECTED] Subject: Re: memo fields and paragraphs At 02:27 PM 7/3/00 -0700, you wrote: Does anyone know how to preserve the paragraphs (carriage returns) in text in a memo field? When I copy text from something like a Word document and paste it into a memo field, it seems to smash all the lines together, as though the paragraphs weren't there at all. Looking at the data in the Access database, the paragraphs are still there, but when I read the field in CF, they're gone. Is this a memo field thing, or a CF thing? It's a browser output thing. Browsers recognize all white space as a single white space. What you need to do is make sure that the users skips a line between paragraphs (so there is one completely blank line between each) then wrap the output in #paragraphformat(put your variable name here)# -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Content management
I store just about all of the content in a database, and have an administrative interface where the owner can change the text on each page. This is password protected. I'm going to do something similar, although I'm going to write the user specified text to a file and CFINCLUDE it, rather than doing a database query. For sites where the content isn't changing more than a few times a month, it seems rather inefficient to keep hitting the database over and over. Thanks for the thoughts, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Calculate Function on a form?
I have exactly this setup in a few sites - basically I have a form button that submits the form back to the same template with the form fields filled with the new calculated values. You can change the action of a form using javascript like this: onClick="document.formname.action='thispage.cfm?action=calc'; document.formname.submit();" You make the template check for the action=calc and then do the calculation and populate the fields. Your other submit button is just a standard submit button. Rob Keniger -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Calculate Function on a form?
Send them to a 'Review' page that calculates every thing BEFIRE you submit the form as all CF is server side code. Stupid question... I've got a form that required a decent amount of calculations (figuring insurance premiums) to be done before it is submitted. Currently, I've written a JavaScript function that runs when I hit a "Calculate" button on the form. However, this is driving me absolutely NUTS in JavaScript, as it will calculate correctly except when one number is a multiple of ten or something..among other things... Is it possible in Cold Fusion to write a similar function that would run and do the calculations so the user could see the result before submitting the form? [button] onsubmit="calcform" or something? I know how to do it when I submit the form and get the results out the other side, but haven't exactly figured out how to get anything to run within the form Suggestions? Thanks! Les Mizzell *** Who needs Intel? Athlon Inside!!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Server Optimization Settings
Check out Allaire KB Article 11772 and 11773 for recommended tuning and optimization settings for various platforms and web servers. I keep these up to date based on Allaire Enterprise Lab test data and settings. Please bring any other settings (Win 2000 or otheriwise) that should be considered for these articles to my attention. The articles are meant to be relavent for JRun, ColdFusion and Spectra customers on all platforms. A batch of Apache and Linux tuning information will be added in the next couple weeks. Damon Cooper Enterprise Lab Manager Allaire [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cookie Math
CFCookie Name="LastTotal" Value="#Evaluate(GetLastSite.LastOne+1)#" Only variables can be within #s. If you want a function to be evaluated within #s, you'll need to use the Evaluate() function. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED]] Sent: Monday, July 03, 2000 10:45 PM To: [EMAIL PROTECTED] Subject: Cookie Math This is a multi-part message in MIME format. --=_NextPart_000_0007_01BFE540.4363E0F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, CFSET LastTotal=3D#GetLastSite.LastOne#+1 - This Works. =20 CFCookie Name=3D"LastTotal" Value=3D#GetLastSite.LastOne#+1 This = Does not work. I would like to be create the cookie with +1. Is there a way? TIA. Regards, Paige --=_NextPart_000_0007_01BFE540.4363E0F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp;nbsp;CFSET=20 LastTotal=3D#GetLastSite.LastOne#+1gt;nbsp; - This=20 Works.BRnbsp;nbsp;nbsp;/FONT/DIV DIVFONT face=3DArial size=3D2nbsp;nbsp; CFCookie = Name=3D"LastTotal"=20 Value=3D#GetLastSite.LastOne#+1gt;nbsp; This Does not = work./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2I would like to be create the cookie = with +1. Is=20 there a way?nbsp; TIA./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Paige/FONT/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0007_01BFE540.4363E0F0-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Content management
If thats the approach your after, the co. Abe Lloyd was at - where they developed www.catholicweb.com might be of interest to you. Its now a "community" ware app - for developing community like portals - but I beleive its customizable. Last I heard form them they wer putting the touches on the comm'l application. There's a few others "CF" based that Ive seen - but am drawing a blank on those. Not too sure exactly what your after but. All the best, Steve - Original Message - From: "Seth Petry-Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 03, 2000 04:45 PM Subject: Re: Content management I store just about all of the content in a database, and have an administrative interface where the owner can change the text on each page. This is password protected. I'm going to do something similar, although I'm going to write the user specified text to a file and CFINCLUDE it, rather than doing a database query. For sites where the content isn't changing more than a few times a month, it seems rather inefficient to keep hitting the database over and over. Thanks for the thoughts, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
What an Array Looks Like
A few holiday thoughts on arrays... Coming from a non-programmer background, I found arrays rather intimidating until I began to realize how similar they are to everyday items: One-dimensional array: like a numbered list. Two-dimensional array: like a spreadsheet or table with cell references based on row and column. Three-dimensional array: like a cube with cell references based on 3 dimensions. Of course, I know that in CF, arrays are dynamic -- each "row" of a 2 dimensional array can be a different length. A 2-dim array is really just a one-dimensional array where each cell is occupied by a one-dimensional array of any length. Although I've often heard it said that it's difficult to visualize arrays of more than 3-dimensions, I wonder if a game we used to play as children might helpIt was called Quad, and was basically a multi-tiered Tic-Tac-Toe game -- multiple levels of rows and columns. So, ignoring the fact that CF arrays don't necessarily have the same number of elements in each dimension, I'd be interested in feedback on whether the following models accurately portray complex arrays: Three-dimensional array: Like a "Quad" game. Example: MyArray[2][3][1] means the data that's stored on the second level of the game, third row and first column. Four-dimensional array: Like a single-file lineup of Quad games. MyArray[5][2][3][1] means the data that's stored on the fifth game in the lineup, second level, third row and first column. Five-dimensional array: Like a big checkboard with a Quad game sitting on each square. MyArray[4][5][2][3][1] means the data that's stored in the game that's sitting on the fourth row and fifth column of the checkerboard, and on that game, the data is in the second level, third row and first column. Six-dimensional array: Like a huge Quad game, with each square occupied by a Quad game of its own. MyArray[2][4][5][2][3][1] means the data that's stored in the game found on the second level, fourth row and fifth column of the huge Quad game, and on that game, the data is in the second level, third row and first column. I could keep going... 7 dimensions would be like a string of huge quad games, with each of the huge quad games having each of their cells occuped by a Quad game...Seems like you could keep going forever... Accurate depiction? Next question: When would you need a 7-dimension array? Gene Kraybill -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What am I doing wrong?
hello i am new in cold fusion programming but i check your code and in my opnion there is only one syntax error and taht is datasource="#dsn#" you can use without hash sign(#) e.g datasource="dsn" if you do this your error meghit be remove. Thanks Farhan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What am I doing wrong?
The ## around the DSN are valid, especially if the #dsn# is a variable that contain the real DSN. This variable could be set just about anywhere, but is usually done in the Application.cfm (or other similar file) using the syntax: cfparam name="dsn" default="mydsn" This way, if you ever have to change the DSN, you only have to change it in one place, as opposed to every single place you used that DSN, if it were hard-coded. This is generally a good coding practice to follow. Todd Ashworth - Original Message - From: FARHANAHMAD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 04, 2000 1:15 AM Subject: Re: What am I doing wrong? hello i am new in cold fusion programming but i check your code and in my opnion there is only one syntax error and taht is datasource="#dsn#" you can use without hash sign(#) e.g datasource="dsn" if you do this your error meghit be remove. Thanks Farhan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Content management
Use CF mappings and CFINCLUDE the intellectual property into the area accessible by FTP. All the user sees are CF templates that contain one line: CFINCLUDE TEMPLATE=/#CFmapping#/File.cfm best, paul At 04:13 PM 7/3/00 -0400, you wrote: 2) Protection of intellectual property: we have a series of pre-written "modules" (calendar, classified ads, etc) that we sell to our clients. Since these are sold as pre-written applications, the client does not gain any ownership of the code. FTP access to the site again poses a problem because it makes these templates directly available to the client. A savvy HTML/CF author working for the client might steal this code and re-sell it. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.